Im on v 2.0.1.1
I saw there was a lot of extensions out there but i dont know if they all manage to do this.
I recive an Excell file from my supplier looking like this when opened as a CSV file (first you see the different sizes, then productname and the quantitys of the specific size and then the next and so on.. somethimes there is a date aswell
):Code: Select all
,34 1/3,35,35 2/3,36 1/3,37,37 2/3,38 1/3,39,39 2/3,40 1/3,41,41 2/3,42 1/3,43,,35,36,37,38,39,40,41,42,43,,39,39 2/3,40 1/3,41,41 2/3,42 1/3,43,43 2/3,44 1/3,45,45 2/3,46 1/3,47,47 2/3,48 1/3,,39,40,41,42,43,44,45,46,47,48,,34 1/3,35,35 2/3,36 1/3,37,37 2/3,38 1/3,39,39 2/3,40 1/3,41,41 2/3,42 1/3,43,,43 2/3,44 1/3,45,45 2/3,46 1/3,47,,,35 2/3,36 1/3,37,37 2/3,38 1/3,39,39 2/3,40 1/3,41,41 2/3,,,35,36,37,38,39,40,41,42,,,39,39 2/3,40 1/3,41,41 2/3,42 1/3,43,43 2/3,44 1/3,45,45 2/3,46 1/3,,,40,41,42,43,44,45,46,matrix11,matrix12
Productname ,0,0,0,2,1,3,11,10,12,2,0,2,0,0,Productname ,8,68,54,0,29,0,0,0,0,Productname,0,1,1,12,7,0,1,4,0,0,0,0,0,,,Productname ,0,0,0,0,0,0,0,0,0,0,Productname SR,9,19,14,50,94,95,69,41,74,44,23,38,0,0,Productname,0,0,1,5,6,7,2015-03-01,Productname,0,6,6,12,24,24,24,12,12,0,2015-03-01,Productname,12,24,36,36,24,12,0,0,2015-03-01,Productname,6,6,24,30,42,66,72,72,48,36,30,12,2015-03-01,Productname,36,60,90,90,60,30,6,,
Productname,10,14,18,55,41,33,0,0,8,0,2,41,20,32,Productname,19,74,44,0,4,0,0,0,0,Productname ,2,11,27,24,22,0,0,41,13,56,48,2,6,0,0,Productname,1,11,4,10,16,20,7,18,21,0,8,12,0,0,Productname,0,0,0,0,0,5,2015-03-01,Productname,0,6,6,12,12,12,12,6,6,0,2015-03-01, Productname,12,30,42,42,30,12,0,0,2015-03-01,Productname,0,0,0,6,6,24,24,24,12,12,6,6,,,,,,,,,,,,,,,,,,,,,,
Productname,10,19,7,71,15,39,7,0,0,0,0,0,0,16,Productname,0,1,0,0,0,0,0,0,1,Productname,0,0,0,2,0,0,0,0,0,0,0,0,0,,,Productname,0,0,0,4,10,8,36,30,22,9,9,4,0,0,Productname,0,0,2,0,0,0,2015-03-01,Productname,0,6,12,18,18,18,18,12,12,6,2015-03-01,Productname,12,30,48,42,30,18,0,0,2015-04-10,Productname,0,0,0,36,36,72,72,60,48,0,0,0,,,,,,,,,,,,,,,,,,,,,,
Productname,0,0,0,0,0,0,0,0,0,0,0,2,0,0,Productname,3,1,2,0,0,0,0,0,0,Productname,0,0,0,0,0,0,0,0,0,0,0,0,0,0,,2015-04-10,Productname,0,12,12,12,24,24,24,12,12,12,2015-03-01,Productname,24,42,60,66,48,24,0,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Productname,0,0,0,2,2,5,10,24,19,0,0,10,1,0,Productname,0,0,0,0,0,0,0,0,0,Productname,0,0,0,0,0,0,0,1,0,0,0,0,0,0,,2015-04-10,Productname,12,36,48,48,120,120,120,48,24,24,2015-03-01,Productname,60,120,180,180,126,72,24,6,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Productname,0,0,0,0,3,3,1,0,0,0,0,0,0,0,Productname,0,0,0,0,0,0,0,0,0,Productname,0,0,0,0,3,0,0,4,1,9,0,0,0,,,2015-04-10,Productname,12,24,24,36,72,72,72,36,36,24,2015-04-10,,12,48,72,72,72,30,6,0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
