Import CSV #SOLVED

[Fernando]

I'm trying to import my CSV route,

However When saved in CSV version columns are excluded

and is inserted ( ; )

That I generate a mistake, I need to salver stand alone (,)

example:

Correct:

code,flightnum,depicao,arricao,route,aircraft,flightlevel,distance,deptime,arrtime,flighttime,notes,price,flighttype,daysofweek,enabled
GLO,1000,SBSP,SBRJ,UZ37,PR-GOH,250,,,250,00:42,0,254,P,1234560,1,

When saved instead of being like the example above, it appears.

Error

code;flightnum;depicao;arricao;route;aircraft;flightlevel;distance;deptime;arrtime;flighttime;notes;price;flighttype;daysofweek;enabled;
GLO;1000;SBSP;SBRJ;UZ37;PR-GOH;250;;;;00:42;;254;P;1234560;1;

Can anyone help me.

I am using excel.

[Parkho]

I would suggest you export your table as CVS then edit it and truncate your table and upload the new one. Make back up first. Good luck.

[mseiwald]

I had the same thing with my Excel it seperated the columns by ; instead of , !

There is a Setting for it but i cant remember where.

However if you Import your .csv file directly in phpmyadmin you can simply change the seperator from , to ; there.

Then the Import works.

[Fernando]

I'm using a formula in excel,

worked, but this formula transforms the duration

flight in decimal.

example

00:48 to 0,319400

this is the formula that I am using to bind the columns

=(A2&" ,"&B2&" ,"&C2&" ",&D2&", "&E2&" ,"&F2&" ,"&G2&", "&H2&" ,"&I2&" ,"&J2&", "&K2&", "&L2&" ,"&M2&" ,"&N2&" ,"&O2&" ",&P2&")