CSJCB Posted May 9, 2021 Report Share Posted May 9, 2021 Hello everyone My CSV Fleet file doesn't download and I do not know why, as the other ones works great. Initially I was thinking about the size of it, right now has almost 7k lines. When I press Export to CSV the sytem start working but soon after I've got a completely white browser page, only visible the url like this https://www.mysite/admin/flights/export Any tip on how can I solve this or an alternative to do it because for a 13k flights introducing one by one its a huge task, I'm using for CSV files a free program called CSV Buddy. Appreciate any suggestion or solution Thank You Quote Link to comment Share on other sites More sharing options...
jftejeiro Posted May 9, 2021 Report Share Posted May 9, 2021 You could try to export the file from phpmyadmin on your server Quote Link to comment Share on other sites More sharing options...
CSJCB Posted May 10, 2021 Author Report Share Posted May 10, 2021 Downloading via phpmyadmin works but the problem is that when uploading via phpvms as should be is not recognized. I tried both CSV versions CSV normal and for excel I dont see any difference between both. Introducing such a quantity of flights 1x1 is not a good idea :) Quote Link to comment Share on other sites More sharing options...
jftejeiro Posted May 10, 2021 Report Share Posted May 10, 2021 Another option would be to download the CSV from phpmyadmin, edit it, upload the new routes and re-import it from phpmyadmin. But what happens is very rare. I download and upload the CSVs from the phpvms7 administration panel and I have no problems Quote Link to comment Share on other sites More sharing options...
Administrators ProAvia Posted May 10, 2021 Administrators Report Share Posted May 10, 2021 Maybe the program you are using to edit the CSV is part of the issue. I have experienced issues with Excel 2003. Now I use Open Office and haven't had any issues. Be sure you are saving as a comma-delimited CSV and no special formatting that may leave unneeded characters in the file. Quote Link to comment Share on other sites More sharing options...
jftejeiro Posted May 10, 2021 Report Share Posted May 10, 2021 Indeed, I use LibreOffice Calc and I have no problems either. With excell if I had problems Quote Link to comment Share on other sites More sharing options...
DisposableHero Posted May 11, 2021 Report Share Posted May 11, 2021 When you export from Database, you should import from database too ... Exporting from A and then trying to import it from B does not work, cause the data format is different. Just a simple example for flights: Export/Import from admin : Airlines are exported/imported with their icao codes Export/Import from database : Airlines are exported/imported with their id numbers Export/Import from admin : Flight days are human understandable like 12345 Export/Import from database : They are masked values Export/Import from admin : You can import/export subfleets and fares of flights Export/Import from database : None of the above would be possible (unless you are really good at sql querries and excel etc) You can export from database, then work on the file to make it compatible for admin side import, this will take time and needs upmost attention to detail. 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.