HAVING TROUBLE LOGGING IN? PLEASE DO NOT CREATE A NEW ACCOUNT, USE THE 'FORGOT PASSWORD' INSTEAD!

[ERROR] Route Importer 2.0 Issues ...

Support for VAFS 5 Virtual Airline CEO Administration System (VCAS).

READ & FOLLOW THE POSTING RULES BEFORE POSTING!
Post Reply
User avatar
Sven2157
Class A Airspace
Posts: 2395
Joined: January 13th, 2012, 4:35 pm
VA Name: Chicago Flights
VA ID: 17898
Callsign: CFX2157
Location: Chicago, IL
Contact:

[ERROR] Route Importer 2.0 Issues ...

Post by Sven2157 » April 15th, 2016, 3:48 am

I am creating this thread to aide in route importer issues that arise, when trying to add new or update routes.

When I created the import script, I added custom error handling that will tell you two key pieces of information:
  • Error Number - Error 68:
  • Line that failed in your CSV file - (Line: XXXX, [optional: Row: ###])
In 99.9% of the cases, the error should be very clear as to what happened. You should be able to fix the problems, as it tells you exactly where your issue is. In the event that you are still stuck, you need to provide us with what we need to quickly and efficiently get you on your way, please include:
  1. Error Number
  2. Line Number (Row number- if provided with one)
  3. Attach your CSV file to the post.
You may post any additional information you wish, but we should be able to address the issue with just the above information.

Until then, Happy Landings! :ugeek:
Regards,

Sven2157

Image
DO NOT PRIVATE MESSAGE ME FOR SUPPORT, UNLESS ASKED TO DO SO!
PLEASE ASK IN THE FORUM!

User avatar
Foxbat27
Class G Airspace
Posts: 9
Joined: October 1st, 2013, 6:37 am
VA Name: Africa World Virtual
VA ID: 23633
Callsign: AFW002

Error 142

Post by Foxbat27 » April 26th, 2016, 6:32 am

Good day,

I just want to find out if anyone can help.
I am trying to upload routes for a new hub but cannot seem to get them upload as I keep getting an error 142 notification.

I have attached a screenshot.

Thank You

Image

User avatar
Foxbat27
Class G Airspace
Posts: 9
Joined: October 1st, 2013, 6:37 am
VA Name: Africa World Virtual
VA ID: 23633
Callsign: AFW002

Re: Error 142

Post by Foxbat27 » April 26th, 2016, 6:52 am

I have seen that it says it cannot find the following route: 1001 (Line: 1) so I am beginning to think it could be a problem with the schedule number. I am also not sure if I can use any schedule number.

User avatar
Foxbat27
Class G Airspace
Posts: 9
Joined: October 1st, 2013, 6:37 am
VA Name: Africa World Virtual
VA ID: 23633
Callsign: AFW002

Re: Error 142

Post by Foxbat27 » April 26th, 2016, 6:56 am

OK guys no worries, I have managed to get it sorted out.

Just in case some of you also have the same problem, my initial csv looked like this

001,49181,258464,738_DF-BR,EDDF,EBBR,10:00,12:00,IFR,FL300,SP
002,49181,258464,738_BR-DF,EBBR,EDDF,10:00,12:00,IFR,FL300,SP

I then removed the 001 and 002 from it to look like this

,49181,258464,738_DF-BR,EDDF,EBBR,10:00,12:00,IFR,FL300,SP
,49181,258464,738_BR-DF,EBBR,EDDF,10:00,12:00,IFR,FL300,SP

and it has uploaded the route successfully.

Thank You

User avatar
Sven2157
Class A Airspace
Posts: 2395
Joined: January 13th, 2012, 4:35 pm
VA Name: Chicago Flights
VA ID: 17898
Callsign: CFX2157
Location: Chicago, IL
Contact:

Re: [ERROR] Route Importer 2.0 Issues ...

Post by Sven2157 » April 26th, 2016, 12:57 pm

@Foxbat27

Next time please use the search function. You could have found this thread, as well as the announcement explaining the new Route Importer.

[2016-04-13] Route Import 2.0 is here!

Glad you sorted it out, though ... :ugeek:
Regards,

Sven2157

Image
DO NOT PRIVATE MESSAGE ME FOR SUPPORT, UNLESS ASKED TO DO SO!
PLEASE ASK IN THE FORUM!

Florian77
Class E Airspace
Posts: 15
Joined: June 10th, 2016, 5:44 pm
VA Name: Air France Virtuel
VA ID: 18907
Callsign: AFR1781

Import route help

Post by Florian77 » June 10th, 2016, 6:19 pm

Hello all,

I try to import route via .csv files, i would like to make a test but it failed. In fact, i have already read all the topic about route import but they is an error;
I copy you the code that i have writted if you can correct it please.

Thanks you so much,
Florian

,26750,85215,AFRTEST,LFPG,LFMN,10:00,12:00,,FL300,IFR,SP (Too many field, how can i choose flight's type please ? )
,26750,85215,AFRTEST,LFPG,LFMN,10:00,12:00,,FL300,SP (When i have deleted IFR, now it say that error 80, Unknown Schedule Type (Line: 2, Value: SP;;;;;;;;;).
Last edited by Florian77 on June 10th, 2016, 6:31 pm, edited 1 time in total.

User avatar
Sven2157
Class A Airspace
Posts: 2395
Joined: January 13th, 2012, 4:35 pm
VA Name: Chicago Flights
VA ID: 17898
Callsign: CFX2157
Location: Chicago, IL
Contact:

Re: Import route help

Post by Sven2157 » June 10th, 2016, 6:26 pm

Florian77 wrote:...
i have already read all the topic about route import but they is an error;
I copy you the code that i have writted if you can correct it please.

....

,26750,85215,AFRTEST,LFPG,LFMN,10:00,12:00,,FL300,IFR,SP
You have 11 commas ( , ). There should only be 10. :shock:

Looks like the field with IFR is your issue; try this instead:

Code: Select all

,26750,85215,AFRTEST,LFPG,LFMN,10:00,12:00,IFR,FL300,SP
Regards,

Sven2157

Image
DO NOT PRIVATE MESSAGE ME FOR SUPPORT, UNLESS ASKED TO DO SO!
PLEASE ASK IN THE FORUM!

Florian77
Class E Airspace
Posts: 15
Joined: June 10th, 2016, 5:44 pm
VA Name: Air France Virtuel
VA ID: 18907
Callsign: AFR1781

Re: [ERROR] Route Importer 2.0 Issues ...

Post by Florian77 » June 10th, 2016, 6:32 pm

Thanks to your reply,
Now it said that Error 80 :/

User avatar
Sven2157
Class A Airspace
Posts: 2395
Joined: January 13th, 2012, 4:35 pm
VA Name: Chicago Flights
VA ID: 17898
Callsign: CFX2157
Location: Chicago, IL
Contact:

Re: [ERROR] Route Importer 2.0 Issues ...

Post by Sven2157 » June 10th, 2016, 6:39 pm

Florian77 wrote:Thanks to your reply,
Now it said that Error 80 :/
Please read the first POST, and then reply with the requested information.
Regards,

Sven2157

Image
DO NOT PRIVATE MESSAGE ME FOR SUPPORT, UNLESS ASKED TO DO SO!
PLEASE ASK IN THE FORUM!

User avatar
Sven2157
Class A Airspace
Posts: 2395
Joined: January 13th, 2012, 4:35 pm
VA Name: Chicago Flights
VA ID: 17898
Callsign: CFX2157
Location: Chicago, IL
Contact:

Re: Import route help

Post by Sven2157 » June 10th, 2016, 6:59 pm

Florian77 wrote:...
Thanks you so much,
Florian

,26750,85215,AFRTEST,LFPG,LFMN,10:00,12:00,,FL300,IFR,SP (Too many field, how can i choose flight's type please ? )
,26750,85215,AFRTEST,LFPG,LFMN,10:00,12:00,,FL300,SP (When i have deleted IFR, now it say that error 80, Unknown Schedule Type (Line: 2, Value: SP;;;;;;;;;).
Please don't edit posts, when asked for more information. It makes the thread hard to follow, and it does not notify me when you have answered.

Here is an example of a correct route line:
Image

I suspect that the reason you are receiving the Error 80: Unknown Schedule Type (Line: 2, Value: SP;;;;;;;;;) is because you have all those semi-colons (;) present. Each route, new or updated, MUST go on their own line.

If those semi-colons are not present, then it may have a space before or after the SP.

Please make sure that there are not any additional characters (visible or not) before or after, execpt New line, that are present in each line of your CSV file.
Regards,

Sven2157

Image
DO NOT PRIVATE MESSAGE ME FOR SUPPORT, UNLESS ASKED TO DO SO!
PLEASE ASK IN THE FORUM!

Post Reply