9
edits
Import data with LibreOffice: Difference between revisions
Jump to navigation
Jump to search
Added TODO for this page
(Initial page creation - still needs formatting and screenshots in English) |
(Added TODO for this page) |
||
| Line 6: | Line 6: | ||
<!-- END interlang links --> | <!-- END interlang links --> | ||
{{ToTranslate}}<br /> | {{ToTranslate}}<br /><!-- TODO | ||
Screenshots in English | |||
Page formatting | |||
Links --> | |||
= Pre-requisites = | =Pre-requisites= | ||
First make sure you have everything you need, OpenOffice, Java Runtime Environment, and the JDBC connector for MySql. Generally, you can follow this tutorial on the OpenOffice site to set up the connector. | First make sure you have everything you need, OpenOffice, Java Runtime Environment, and the JDBC connector for MySql. Generally, you can follow this tutorial on the OpenOffice site to set up the connector. | ||
| Line 15: | Line 18: | ||
'''We will take the example of importing Customers / Suppliers.''' | '''We will take the example of importing Customers / Suppliers.''' | ||
= Create the customer table = | =Create the customer table= | ||
First you need to prepare a summary table of the data to import. | First you need to prepare a summary table of the data to import. | ||
| Line 24: | Line 27: | ||
The principle is simple, whatever the table to import (see the complete list), just put the fields of this table in the first line. Then fill in the other lines with your data. Save your file (it's more careful), but leave it open. | The principle is simple, whatever the table to import (see the complete list), just put the fields of this table in the first line. Then fill in the other lines with your data. Save your file (it's more careful), but leave it open. | ||
= Create an OpenOffice link to the Dolibarr database = | =Create an OpenOffice link to the Dolibarr database= | ||
Then create a new OOo database, File> New> Database | Then create a new OOo database, File> New> Database | ||
| Line 47: | Line 50: | ||
'''Please note: everything you do in OpenOffice Base will also be done on your MySQL database, OpenOffice Base serving here as an interface only.''' | '''Please note: everything you do in OpenOffice Base will also be done on your MySQL database, OpenOffice Base serving here as an interface only.''' | ||
= Import of the customer table in the Dolibarr database = | =Import of the customer table in the Dolibarr database= | ||
Go back to the data table (under Calc), select all your columns and rows, and make a Copy (CRTL + C) | Go back to the data table (under Calc), select all your columns and rows, and make a Copy (CRTL + C) | ||
| Line 60: | Line 63: | ||
Depending on the size of your Calc table you will have to be a little patient, for 1500 entries you have to wait 2-3 minutes. So be patient. | Depending on the size of your Calc table you will have to be a little patient, for 1500 entries you have to wait 2-3 minutes. So be patient. | ||
= Conclusion = | =Conclusion= | ||
This tutorial works for other tables (products for example), you must always be sure to fill in the 'vital' fields. You can also modify the data by double-clicking on the table of your choice, it's faster than with the Dolibarr interface, but be careful, we modify the data in the database directly, don't forget. | This tutorial works for other tables (products for example), you must always be sure to fill in the 'vital' fields. You can also modify the data by double-clicking on the table of your choice, it's faster than with the Dolibarr interface, but be careful, we modify the data in the database directly, don't forget. | ||
| Line 67: | Line 70: | ||
[[Special:Categories|Category]]: | [[Special:Categories|Category]]: | ||
* [[:Category:Imports|Imports]] | *[[:Category:Imports|Imports]] | ||
Available in french : [[Importer_des_données_avec_OpenOffice]] | Available in french : [[Importer_des_données_avec_OpenOffice]] | ||
or in spanish : [[Importacion con OpenOffice]] | or in spanish : [[Importacion con OpenOffice]] | ||