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!
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 » July 18th, 2016, 2:46 am

AMS1 wrote:Problem solved. I simply created a new .csv (no header) and it worked this time. Maybe the file was bad. As always, thanks for the quick replies and sorry for the fire drill.
No worries man, glad you got it sorted out!

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
Tobus_75
Class D Airspace
Posts: 70
Joined: October 13th, 2015, 10:42 am
VA Name: Andras Meridian Airlines
VA ID: 18501
Callsign: AMA141

Route importer not updating hub

Post by Tobus_75 » October 3rd, 2016, 9:50 am

Hi!

I'm in the process of moving our PNG hub from AYMD Madang to AYPY Jacksons Port Moresby.
Using the exporter, I've exported all routes to excel and changed the hub id to the new one, making sure I did not touch the new flight id on the 1st column.

I then saved to csv and used the importer to update all the routes.
The importer runs fine and finishes without error, stating all routes in file are updated.

When I look at the impacted routes though, the hub is still the old one.
Exporting the "new" routes to excel confirms this: the old hub number is still visible.

Am I doing something wrong or does the importer have an issue on updating hubs?
Image

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: Route importer not updating hub

Post by Sven2157 » October 3rd, 2016, 2:22 pm

Couple things here:
  • Are you using the correct VA ID, because the one for your profile is not a valid ID. Please ensure you are using the correct ID, then update your forum profile with the correct one also.
  • Are you using a French Region in your OS settings? Or the French version of MS Excel? If so there are known bugs when converting to CSV format. Please See: French Version of Excel saving CSV Files with a semi-colon
  • Can you please include the file so I may take a look at it, and see if I can spot any errors? I can't do my best, if I can't access all the relevant information.
Thanks! :ugeek:
Regards,

Sven2157

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

User avatar
Tobus_75
Class D Airspace
Posts: 70
Joined: October 13th, 2015, 10:42 am
VA Name: Andras Meridian Airlines
VA ID: 18501
Callsign: AMA141

Re: Route importer not updating hub

Post by Tobus_75 » October 3rd, 2016, 5:30 pm

Hi Sven,

1. No idea what you are talking about?
My VA ID is 18501, says so in my top VCAS screen.
Edit: ah, va id in my profile on this forum! typo edited, not sure what the link is to this error though.

2. No, comma's

3. see attached
Image

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: Route importer not updating hub

Post by Sven2157 » October 3rd, 2016, 6:37 pm

Tobus_75 wrote:Hi Sven,

1. No idea what you are talking about?
My VA ID is 18501, says so in my top VCAS screen.
Edit: ah, va id in my profile on this forum! typo edited, not sure what the link is to this error though.
I tried to use the ID to see the routes, but could find that VA. ;)

Let me check this CSV file (I also removed the attachment) ... Will get back to you.
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: Route importer not updating hub

Post by Sven2157 » October 3rd, 2016, 6:59 pm

Ok Toby,

Try it again - :roll: it should work. If it does, I will tell you what the problem was, I just want to make sure it works.

*** EDIT ***

Damn it! I am an idiot ... please see below ...
Regards,

Sven2157

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

User avatar
Tobus_75
Class D Airspace
Posts: 70
Joined: October 13th, 2015, 10:42 am
VA Name: Andras Meridian Airlines
VA ID: 18501
Callsign: AMA141

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

Post by Tobus_75 » October 4th, 2016, 8:44 am

Done and now updated correctly!
Image

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 » October 4th, 2016, 8:48 am

Tobus_75 wrote:Done and now updated correctly!
I am an idiot! As promised ...

I forgot to update the huib/schid = ID for the schedule, in my new script! I didn't even include it ...

A thousand apologizes! I am an idiot! :oops:
Regards,

Sven2157

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

User avatar
Tobus_75
Class D Airspace
Posts: 70
Joined: October 13th, 2015, 10:42 am
VA Name: Andras Meridian Airlines
VA ID: 18501
Callsign: AMA141

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

Post by Tobus_75 » October 4th, 2016, 9:05 am

Nope, you learned something, that what makes us smart ;)

Thanks for the help!
Image

User avatar
queenofsky
Class D Airspace
Posts: 58
Joined: August 31st, 2014, 7:49 pm
VA Name: air Switzerland Virtual Airline
VA ID: 23875
Callsign: RSW
Contact:

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

Post by queenofsky » October 4th, 2016, 9:44 am

Hello Sven

I also have a problem with uploading routes.
It says the csv file is correctly, but at the end I get this Error Message:

1. Error 492: Query database INSERT ROUTE failed!

I did try anythings possible, but not works.

Thank you for your help.
Kind Regards

Stephan
CEO Swissair Virtual Airline
VA ID:26081
Swissair Virtual Airline / SWH
https://www.swissair-va.ch/
Image

Post Reply