vicente Posted May 27, 2015 Report Share Posted May 27, 2015 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 Quote Link to comment Share on other sites More sharing options...
magicflyer Posted May 28, 2015 Report Share Posted May 28, 2015 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. Quote Link to comment Share on other sites More sharing options...
vicente Posted May 28, 2015 Author Report Share Posted May 28, 2015 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" ?? Quote Link to comment Share on other sites More sharing options...
magicflyer Posted May 28, 2015 Report Share Posted May 28, 2015 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. 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.