How Use the file_get ?

[vicente]

Someone can help, how i can use the file_get to save from this website the routes for phpvms please ?

http://www.cgna.gov.br/rpl/Companhias/Cia_TAM_CS.txt

Thanks

[magicflyer]

Unless you can get a nice piece of code that'll organize it for you, we'll have to work it out old-fashioned using Excel.

I did some experimenting by copying and pasting the text into excel and running a macro, and I was able able to separate the values into their own columns in a table. You'll have to do some copy/pasting to get it to work with phpVMS' schedule CSV templates, but I guess this is a start:

Excel File: zumeweb.com/downloads/Book1.xlsx

CSV File: zumeweb.com/downloads/Book1.csv

A phpVMS Template can be found in your phpVMS Admin Panel, on the Schedule Importer's sidebar. Best I can do with helping you Best Wishes.

[vicente]

Hey man, thanks for your help, i know about the template on phpvms system, but do you can explain to me step by step how did you do that ? How do you import from that site and transform in a CSV file please ?? You said you used a "macro" ??

[magicflyer]

Macro is code for Excel.

I believe the newer version of excel has a text to columns feature. Copy and paste the text file into the excel document and use that feature to split them into columns.