Author Topic: how (or can i ) to upload routes from excel?  (Read 106 times)

VARIG

  • Newbie
  • *
  • Posts: 16
    • View Profile
how (or can i ) to upload routes from excel?
« on: September 13, 2017, 04:55:32 PM »
I have a lot of routes in excel in old Vam format , how can I upload it? I could do it before on personalization but new vam doesn't have it

OAV001

  • Jr. Member
  • **
  • Posts: 74
    • View Profile
    • Open Air Virtual
Re: how (or can i ) to upload routes from excel?
« Reply #1 on: September 14, 2017, 08:10:43 AM »
Hi,

You could save them as a .CSV file in Excel and then import them via PHPAdmin, that's imho the easiest way.

Cheers,

Peter Faase
CEO / Webmaster OAV

VARIG

  • Newbie
  • *
  • Posts: 16
    • View Profile
Re: how (or can i ) to upload routes from excel?
« Reply #2 on: September 15, 2017, 11:03:45 PM »
i don't see where I can up load I looked everyere on admin panel

VARIG

  • Newbie
  • *
  • Posts: 16
    • View Profile
Re: how (or can i ) to upload routes from excel?
« Reply #3 on: September 16, 2017, 11:38:33 PM »
any one?

OAV001

  • Jr. Member
  • **
  • Posts: 74
    • View Profile
    • Open Air Virtual
Re: how (or can i ) to upload routes from excel?
« Reply #4 on: September 18, 2017, 07:17:45 PM »
There is no option in the main code from VAM but you can use PHPAdmin to stream it straight into your MySQL database, most internet providers do have this option. So PHPAdmin is not a VAM program but an MySQL (MariaDB) tool.

Sorry bit slow with answering as I am on the other side of the world.
Cheers,

Peter Faase
CEO / Webmaster OAV

VAM

  • Administrator
  • Hero Member
  • *****
  • Posts: 1217
    • View Profile
    • virtual Airlines Manager
Re: how (or can i ) to upload routes from excel?
« Reply #5 on: October 03, 2017, 11:54:22 AM »
You should create with excel or any similar tool a csv file ,one column for each table/field the follow those steps to import using PHPMYADMIN

https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html

http://www.mysqltutorial.org/import-csv-file-mysql-table/

VAM Creator and programmer.