Migration

[saywhat01]

I have a project I am not sure on how to tackle...

I would like to take 40 weeks worth of MS Excell Spreadsheets and convert them into on handy MySql database for intigration into a web page for our end users.

I am NOT a MySql wiz by any strech and would appreciate any directions given for the successful conversion to MySql and the setup of the MySql tables and what have you required...

 

[TonyGroves]

You would need to export the spreadsheets to CSV format; you can then write a little shell script to create the tables and import the files into the database.

You would need to provide more information about the structure of your data before anybody can advise on setting up the tables.

 

[vacunita]

You could, although it would take some time, save all the Excel data as CSV files (comma separated values), then you can feed those files into MYSQL in different ways.

The table scheme will depend on how you want the information stored, what format your Excel files have What the contents of the files are etc...

You better than anybody here should know what tables you need to create, and with what fields.










----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[vacunita]

Sorry should have refreshed before posting.

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[saywhat01]

Ok...Here is what I have in a bit more Detail...

I have the following columns:

Rep Totals Week 1 Week 2 Week 3 (to Week 40) Top 5 ->
Top 10 Top 15 Top 20 Total Position Points


The Column REP contains the Name of the Rep

Weeks 1-40 Contain their Ranking for the week
Total contains the Sum of Weeks 1-40
Top 5 - 10 -15 - 20 contains Points assigned for the Number of times they finished in the Top 5 - 10 - 15 -20 (from Columns Week 1-40)

Total Position Points is the Sum of Top 5 - 10 -15 -20

Can I make a table for each weeks finish and tie that into a table of the corresponding name for each place they finish (there are 75 Reps!!!!).

In short this would be an ever growing database to help track the progress (or lack of progress) of our Reps.

The data would then be displayed on our Intranet on a secured site for our managers...

Hope this helps ...And Thank You in Advance..

P.S. This will be on a Linux Server running MySQL 5.

 

[feherke]

Hi

Sorry, but I do not understand. How many sheets you have currently ? How many tables you want to have now ( not somewhen in the future ) ? Anyway, you may post the structure like this :

Sheet 1
Column 1 - Type 1
Column 2 - Type 2
... - ...
Column n - Type n

Sheet 2
Column 1 - Type 1
... - ...

...

Then we will be able to help you with a conversion script.

Feherke.

http://rootshell.be/~feherke/