Importing schedules csv

[cfitz619]

Good Morning.  I am on day 2 of trying to figure this out for myself. I have been through the forums searching for a solution. I am trying to import schedules from a csv.  I am getting the error shown in the picture below.  Any help would be greatly appreciated.  Thank You.

 

Info:

phpvms 5.5.2.72

Using Open Office to edit and save csv.

PHP version 7.2

mysql 10.2

 

OPen Office schedules.csv file:

 

 

[ProAvia]

It seems to be saying that the airline with code "MEC" does not exist. Make sure that airline is listed correctly in the airline table prior to attempting to import schedules.

 

Also, in Open Office, be sure "Separated by" is set to comma only - no semicolon. And maybe set "Character set" to UTF-8 for any imports to phpVMS. 

[cfitz619]

Thanks for the info.  I'll try that.

[Strider]

I think what is happening, the system thinks the airline code is the entire schedule detail too, which i think is down to using semicolon instead of just comma. don't use both as you can confuse code by doing that.