ironman Posted January 21, 2008 Share Posted January 21, 2008 I have reports based on data I export from my company database. I usually export the data into an excel spreadsheet, then within excel I create formulas that represent the info I place into my reports. (Average things, get percentages, ect) This entire task takes two hours on a goodnight so obviously I'd like to automate the process. So my thoughts were to create a php run site along with MySQL as its backed database. Does anyone have any suggestions on how to import my data daily into a master table within my MySQL database I've created? The data will be over written daily. Also a side note. I have the options to export my data in the following formats: 1. XML Spreadsheet 2. XML Data 3. Single File Web Page 4. Web Page 5. HTML 6. Unicode Text 7. CSV 8. WQ1 9. DBF 4(dBASE IV) 10. DIF (Data Interchange Format) 11. SYLK (Symbloic Link) 12. Comma Separated Text File Hope someone has some good pointers. Thanks! Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted January 21, 2008 Share Posted January 21, 2008 How is the data stored? What kind of "database" is it. If it's any type of SQL database or if it in some way has an API then it might be easier to use that. If that is not possible then I would suggest to export it as an XML file. How you would then insert that into your MySQL database obviously depends on how the data is. Quote Link to comment Share on other sites More sharing options...
ironman Posted January 22, 2008 Author Share Posted January 22, 2008 Thanks! I havent actually gone through placing the code, but I can see how it should be done. I'm having database connection issues now, but that should be resolved soon. Thanks again, i'll update this as solved. 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.