gw-sd-2016 / EcoFriendly

Tom Senior Design Project
0 stars 0 forks source link

CO2 Car Emissions Import #8

Open ttunca opened 8 years ago

ttunca commented 8 years ago

Hello, This last week i have been trying to import a database i found from the European Environmental Agency. Its going a little slow because i had to remember how to use a .sql file to host a database online then use that host to import the database in my application. I have to do it this way because i couldnt find an actual database ready for use with the data i needed. I only found an excel sheet of the data, then i had to convert that to a csv file to finally create the actual .sql file. So now i am trying to get the database uploaded on a host to be able to call it from my application, which I am having trouble with. I ahve up[loaded the .sql file in the EcoFriendlySD folder named carsandco2.sql. Thanks

ttunca commented 8 years ago

Hey, So to add onto the issue above, I have figured out how to host a database on the seas servers aND download the db file to use in my app. The problem with that was that the db file was too big to work for the app. So instead I wrote java code that will take another sql file and use that sql file as the database to allow the user to select a car which also has its co2 emission.