chilemugriento Posted May 20, 2014 Report Share Posted May 20, 2014 Good day gentlemen: Congratulations for this phpvms and this forum, glad to be here. Our VA works with FSPassengers since 8 years ago with over 38300 pireps, but want to add phpvms for other acars, pireps system and flightsim as well. Is it posible swap or migrate FSPassengers flights and user tables to phpvms ? Dont want to lose pilots records. Regards. Quote Link to comment Share on other sites More sharing options...
Members Vangelis Posted May 20, 2014 Members Report Share Posted May 20, 2014 Everything is possible if you have the knowledge to do it You will need to export the data from the current tables and modify it and insert it to the new one Quote Link to comment Share on other sites More sharing options...
Members Vangelis Posted May 20, 2014 Members Report Share Posted May 20, 2014 I forgot to mention that i could help you doing that if you need any help Quote Link to comment Share on other sites More sharing options...
flyalaska Posted May 20, 2014 Report Share Posted May 20, 2014 I forgot to mention that i could help you doing that if you need any help I wish you were here when I moved from FSAcars. We had do it all manually. Quote Link to comment Share on other sites More sharing options...
chilemugriento Posted May 21, 2014 Author Report Share Posted May 21, 2014 Thanks for reply. This is my work by now: Exported FSP flights table as sql, CSV for Excel and PHP array as well. Same job for phpvms_pireps and compare them. Not match at all !!!! Values and syntax are diferent. Any sugestion ? Thank you !! Quote Link to comment Share on other sites More sharing options...
Members Vangelis Posted May 21, 2014 Members Report Share Posted May 21, 2014 you need to convert the data to match the phpvms_pirep table i will try to make you an automated script later on if you can wait or if you want you can send me the db to info(a)baggelis.com and i can try to do it for you Quote Link to comment Share on other sites More sharing options...
chilemugriento Posted May 21, 2014 Author Report Share Posted May 21, 2014 Mr Vangelis, Thank you !!!! Before you make a lot of work for me (apreciated), i wonder if a empty template CSV (like import schedules template) could be enough . I can get data from FSP tables (by column) and copy - paste to template CSV, then import to phpvms. It will work ? You can help me with template or a simple or automated script as you said. BTW: this is our site www.surairmexico.com.mx www.surairmexico.com.mx/phpvms Best regards Quote Link to comment Share on other sites More sharing options...
Members Vangelis Posted May 21, 2014 Members Report Share Posted May 21, 2014 the website seems to be out of order the problem is that because fspap has a diverent db layout you will have to run a query joined with the db of phpvms in order to assign the fspap flight to the phpvms pilots. for example in flights table there is no pilot id but there is the pilots name instead in the phpvms_pireps there is no name column but there is a pilot id.those 2 have to get joined and then imported. if you make this script and then echo it on a table it is very easy to import it to excell and then import it to phpvms_pireps . so first you will have to import the pilots in phpvms with the same name as they are in fspapp. second you will have to match the fspap name with the phpvms name third you will have to cut the excess from the departure/arrival airport because phpvms requires only the icao ( for example KJFK) and then put everything in a table in order to extract it to excell. to sum up because i do not have your pilot info i cannot make an automatic php script as the names need to be the same Quote Link to comment Share on other sites More sharing options...
chilemugriento Posted May 21, 2014 Author Report Share Posted May 21, 2014 sorry, wrong url, my apologize This are (confirmed) www.surair.com.mx www.surair.com.mx/phpvms (by the moment, altough register is enabled, dont accept pilots until FSP database is full instaled into phpvms) I will try your directions and post my results, hope can do it, otherwise, will contact you again for furhter help. Best regards. 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.