josh90 Posted May 25, 2016 Report Share Posted May 25, 2016 Hi, One of our admins has brought to my attention that we can no longer import routes from a .csv file. We're trying to import using the template file that sits on our server, that comes with the phpVMS installation. When trying to import this file we get the error ' The import process is complete, added 0 schedules, updated 0, for a total of 0' . Attached is the template.csv file with just one fictious route that I'm trying to import as a test. This issue has been brought up a number of times on this forum by the looks of it, but I can't find a solution that works for us, things I've tried: 1. Creating a new blank .xls file, adding the headers as they appear in the template file and adding all fields except the route, leg and distance field, which can be omitted according to 3. of the instructions. One question I've got is, in point 3, it does mention to remove the legs column from the file as it is no longer counted. I can't see a legs column in the template file, or in the database itself so I guess that's correct and is aimed at people who may be using an older version of the template file. After filling out all the fields, I've saved the document as a .csv file. 2. Saving in two different types of format Windows Comma Seperated (.csv file) and MS-DOS (.csv file) format. Things to note: 1. We're using David Clark's version of phpVMS (5.5-2.x) 2. MS Excel 2010 to modify the .csv file 3. We had to re-install phpVMS a few weeks back due to a problem with our host. This feature has worked before then. 4. Routes can be added singularly using the 'Add Schedule' option in the Admin Centre 5. The airline, aircraft, dep/arr airports all exist for this test schedule 6. The schedule number is not already in use 7. When exporting the schedules, using the 'Export Schedules' option in the Admin Centre, it generates a file called schedules.csv.txt. Does that mean the import file has to be appended with .txt too? 8. An error is received in MS Excel when saving to .csv format, something along the lines of some features may be removed when saving in this format. Thanks in advance Josh template.csv Quote Link to comment Share on other sites More sharing options...
josh90 Posted June 15, 2016 Author Report Share Posted June 15, 2016 Can anyone help on this please? 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.