Best format for data import
-
- Posts: 20
- Joined: Mon Dec 27, 2010 8:06 pm
Best format for data import
i have about 1million records to import into base..1st i must convert them. So, what is the best file type to convert to,so i can import work w/ base most effectively?my options:pdf,pdf/a,.doc,.rtf,.docx,.htm,.txt,.xls,.xlsx,.pptx ,or .csv
thanks for your help!
thanks for your help!
OpenOffice 3.2 on Windows Vista
Re: Best format for data import
Convert from what?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 20
- Joined: Mon Dec 27, 2010 8:06 pm
Re: Best format for data import
Villeroy wrote:Convert from what?
Out of the list of file extensions in my first post, I am just wondering what type of data is easiest to get into base?
OpenOffice 3.2 on Windows Vista
Re: Best format for data import
For productive use cases you don't get any data "into Base". You connect a Base document to some existing database (MySQL, OracleDB, PostgreSQL,...). Base is not a database. It is a so called database frontend. The first important question is the type of database you have already.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 20
- Joined: Mon Dec 27, 2010 8:06 pm
Re: Best format for data import
Sorry, I did not understand that. I don't have one as of yet, I just have a huge amount of tif's and I want to organize them and use them in queries etc. I could use mysql as the backend. So, I imagine I just find what format is best for mysql, then find out how to link it to base as my front end?
thanks
thanks
OpenOffice 3.2 on Windows Vista
Re: Best format for data import
Example using the "integrated" HSQLDB with text fields and picture files outside the database:
http://user.services.openoffice.org/en/ ... 34#p153834
Should work with any fully functional (external) database likewise.
http://user.services.openoffice.org/en/ ... 34#p153834
Should work with any fully functional (external) database likewise.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Posts: 20
- Joined: Mon Dec 27, 2010 8:06 pm
Re: Best format for data import
Thanks, My main issue is how to import a csv or multiple csv's to mysql or using the hsql with base( i prefer base and hsql)...are there any tutorials on doing this...I haven't found any yet.
Thanks
Steve
Thanks
Steve
OpenOffice 3.2 on Windows Vista
Re: Best format for data import
Be warned: The embedded HSQLDB is very bad.
The process of text import is more or less the same in most database engines.
In this forum's tutorial section you find everything you need.
The process of text import is more or less the same in most database engines.
In this forum's tutorial section you find everything you need.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Best format for data import
Sounds like binary image files...?christian09 wrote:I just have a huge amount of tif's and I want to organize them and use them in queries etc.
Take a look at this:
http://user.services.openoffice.org/en/ ... 57#p187057
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria