cfitz619 Posted February 10, 2021 Report Share Posted February 10, 2021 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: Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted February 10, 2021 Administrators Report Share Posted February 10, 2021 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. Quote Link to comment Share on other sites More sharing options...
cfitz619 Posted February 11, 2021 Author Report Share Posted February 11, 2021 Thanks for the info. I'll try that. Quote Link to comment Share on other sites More sharing options...
Strider Posted February 11, 2021 Report Share Posted February 11, 2021 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.