Hi,
I need a bash script with the following functionality:
1) Download a CSV File from given URL (size up to 200.000 lines)
2) Import selected columns into a mysql database (emtpy the table before import)
The CSV file format:
ArtNumber;Title;Description_Short;DisplayPrice;Img_url;Deeplink1;ProductCategoryID;ProductCategoryName;Manufacturer;Brand;Keywords;EAN;Price;Description;ProgramID;Price_old;ShippingPrefix;ShippingSuffix;Shipping;color;lieferzeit;top1;top2;top3;top4;top5;Available
if it's better (performance! up to 200.000 lines) with PHP please use PHP.
Thank you!