Best format for data import

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
christian09
Posts: 20
Joined: Mon Dec 27, 2010 8:06 pm

Best format for data import

Post by christian09 »

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!
OpenOffice 3.2 on Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Best format for data import

Post by Villeroy »

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
christian09
Posts: 20
Joined: Mon Dec 27, 2010 8:06 pm

Re: Best format for data import

Post by christian09 »

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
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Best format for data import

Post by Villeroy »

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
christian09
Posts: 20
Joined: Mon Dec 27, 2010 8:06 pm

Re: Best format for data import

Post by christian09 »

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
OpenOffice 3.2 on Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Best format for data import

Post by Villeroy »

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.
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
christian09
Posts: 20
Joined: Mon Dec 27, 2010 8:06 pm

Re: Best format for data import

Post by christian09 »

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
OpenOffice 3.2 on Windows Vista
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Best format for data import

Post by Villeroy »

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.
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
User avatar
DACM
Volunteer
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: Best format for data import

Post by DACM »

christian09 wrote:I just have a huge amount of tif's and I want to organize them and use them in queries etc.
Sounds like binary image files...?
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
Post Reply