nathanh12 Posted April 20, 2011 Report Share Posted April 20, 2011 Hi, I have tried to upload a schedule from a CSV file using the "Import Schedules" button (see attached file) and have created 1 B737-800 using phpvms and the spelling is all the same as in the CSV file and when I import it it comes up with the message " the aircraft B737-800. does not exist" Please help as my VA is now live. Yours, Nathan Hancock. frogairlinesscheduel.csv Quote Link to comment Share on other sites More sharing options...
Tom Posted April 20, 2011 Report Share Posted April 20, 2011 You have loads of trailing "."'s in multiple fields - remove those. Quote Link to comment Share on other sites More sharing options...
Moderators joeri Posted April 20, 2011 Moderators Report Share Posted April 20, 2011 you will need to add the plane to your fleet befor you upload the schedulles Quote Link to comment Share on other sites More sharing options...
nathanh12 Posted April 20, 2011 Author Report Share Posted April 20, 2011 you will need to add the plane to your fleet befor you upload the schedulles I have added the plane, do I need to add multiple? Quote Link to comment Share on other sites More sharing options...
nathanh12 Posted April 20, 2011 Author Report Share Posted April 20, 2011 You have loads of trailing "."'s in multiple fields - remove those. After opening it in my excel (Microsoft Excel 2007) I cannot see the trailing ""'s, what should I do? Quote Link to comment Share on other sites More sharing options...
Tom Posted April 20, 2011 Report Share Posted April 20, 2011 After opening it in my excel (Microsoft Excel 2007) I cannot see the trailing ""'s, what should I do? Trailing dots: . Your aircraft is called "B737-800." - get rid of the dot. Same with other fields. Quote Link to comment Share on other sites More sharing options...
Jeff Posted April 20, 2011 Report Share Posted April 20, 2011 When I look at your .csv file, it is showing me that your Aircraft is typed like this... B737-800. try removing the decimal (.) after the aircraft name and try uploading it again. Tom beat me to it... Quote Link to comment Share on other sites More sharing options...
nathanh12 Posted April 20, 2011 Author Report Share Posted April 20, 2011 When I look at your .csv file, it is showing me that your Aircraft is typed like this... try removing the decimal (.) after the aircraft name and try uploading it again. Tom beat me to it... Thanks, that has cleared that up for me as I thought tom was talking about the quotation marks not the decimal. Thanks Again, Nathan. Quote Link to comment Share on other sites More sharing options...
nathanh12 Posted April 20, 2011 Author Report Share Posted April 20, 2011 Having taken your advice above I have removed the .'s but now when I install it comes up with the following message (see screenshot) please help. I have added the following things to save time, are they affecting anything. The word "Anytime" in departure Time The word "Anytime" arival Time The word use calc in flighttime colum The revised CSV file is also inclosed. Thanks, Nathan. frogairlinesscheduel.csv Quote Link to comment Share on other sites More sharing options...
Tom Posted April 20, 2011 Report Share Posted April 20, 2011 Referring to the above csv (there's no screenshot): distance: must be a number. Leave blank to calculate. deptime & arrtime: must be a time, format HH:MM, e.g. 12:34 flighttime: must be a number, I believe in the format H.MM, e.g. 1.5 Quote Link to comment Share on other sites More sharing options...
nathanh12 Posted April 21, 2011 Author Report Share Posted April 21, 2011 Referring to the above csv (there's no screenshot): distance: must be a number. Leave blank to calculate. deptime & arrtime: must be a time, format HH:MM, e.g. 12:34 flighttime: must be a number, I believe in the format H.MM, e.g. 1.5 How would I set it up if I wanted not to put in the flight time in as you dont know how quickly the pilots are going to fly the flights. I would also want to set the dept. and arri. as "anytime" or nothing so the flight can be flown anytime. Thanks, Nathan. Quote Link to comment Share on other sites More sharing options...
Tom Posted April 21, 2011 Report Share Posted April 21, 2011 I just use 00:00 & 00:00 and guess tge flight time. They are only advisory values... Quote Link to comment Share on other sites More sharing options...
nathanh12 Posted April 21, 2011 Author Report Share Posted April 21, 2011 Just out of interest, with the above csv would the aircraft be stuck at there destination and if so what would I do about it? Quote Link to comment Share on other sites More sharing options...
Jeff Posted April 21, 2011 Report Share Posted April 21, 2011 For what I have seen by your .csv file and by looking at your image, I can see multiple problems with the ways your are importing your schedules to your site. First and foremost, on the Import page in the Admin Center, make sure that "First line of CSV is the header" Has the check mark in the box. Second, your flight numbers should always be in number format, (ie. 1, 2, 3, 4, 5, 6, ...not A1, A2, A3) (when the site displays the flight numbers it WILL show them as FRO123) Third, you are going to need to leave DISTANCE blank or actually put a number in there. (the number format can be 123 or 123.4 never text) Forth, your flight times must be entered as time (12:00) never as text. I have taken the first flight from your .csv, and displayed how it should look prior to export (I hi-lighted my part yellow) Quote Link to comment Share on other sites More sharing options...
Guest lorathon Posted April 21, 2011 Report Share Posted April 21, 2011 I dont think that this is going to fly either £100.00. Price should be numerical 100.00 Quote Link to comment Share on other sites More sharing options...
nathanh12 Posted April 22, 2011 Author Report Share Posted April 22, 2011 I have susequently got this to work so thank you fro your input. 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.