× This category is read only

How to get your Data into mysql

More
12 years 10 months ago #595 by Dirk
How to get your Data into mysql was created by Dirk
Even if the upcoming PRO-Version will have an importer for Excel,ODS and CSV tables, every user of JooDatabase should be familiar with phpMyAdmin.
I don't know any provider who does not offer phpMyAdmin access to a webspace-package with MySql. Try to find out how to get access to the phpMyAdmin console. Normally you will find a link in your customer administration page.
phpMyAdmin can import data from CSV-spreadsheets and XML files. But You need phpMyAdmin if you want to create a new empty table.
CSV (Comma-Separated Values) files are simple text files. The data is separated by divider chars (semicolons or comas). The handling is tricky because Microsoft uses its own CSV-Format it is not sure that tables can be imported without errors.
Newer versions of phpMyAdmin will be able to import OpenDocument - Tables. Unfortunately only the latest Versions of Excel are able to save ODS-Tables. If you have Excel 2007 or later or if you use OpenOffice like me you should definitely choose ODS to import.

Some words about creating tables
  1. Open your database in phpMyadmin
  2. Look for "create new table" at the bottom of the right page
  3. Insert the name of your table and the number of columns you want. (Don't worry. you can change your table structure anytime)
  4. Create a your columns by choosing name and type. You first Column should be integer named ID with primary and auto_increment selected.
Don't use TEXT for every COLUMN. If a field is shorter than 256 chars you should use VARCHAR and the maximum length. Set the Index-flag to every COLUMN you want to search later (e.g. Title or Category) but not for text columns.
For Prices you should use decimal(6,2). Then your values will automatically rounded.
If you want to have Published/Unpublished function for your database insert a TINYINT column with the default value 0. This could be very useful if you want to give your users the opportunity to insert new data with the form-view but want to check new entries before publishing.

Please Log in to join the conversation.