OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

importing csv into openoffice base

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
woy
Newbie
Newbie


Joined: 25 Nov 2005
Posts: 4

PostPosted: Fri Nov 25, 2005 2:59 am    Post subject: importing csv into openoffice base Reply with quote

hi got a real problem... i have an csv file with all the customer data... phone# adress email etc... i wanna create a open office database... so my co workers can easily access the data and sort it by name... company... etc...

i am a database newbie... and i really have no clue how to import it... i am able to import the csv file into oocalc... i created a oo database but cant just copy and paste it...

can you recommend me something... actually its not a big file its like 135kb... around 500 contacts... but typing everyone of them would take alot of time.... so help is appreciated...
Back to top
View user's profile Send private message
james_h
Super User
Super User


Joined: 05 Nov 2005
Posts: 883

PostPosted: Sat Nov 26, 2005 10:40 am    Post subject: Re: importing csv into openoffice base Reply with quote

Re: importing csv into openoffice base

Importing a CSV address database

Put your CSV database file in a directory by itself.
Start OpenOffice.org 2 swriter.
File > Wizards > Address Data Source ...
Select Other external data source.
Click Next.
Click Settings
Choose Database Type: Text.
Click Next.
Click Browse.
Choose the folder containing your .csv file.
Click Test Connection.
If the test works, click OK and continue.
Click Next.
Under Specify the type of files you want to access, choose 'Comma separated values' (CSV).
Under Row Format, select the details about how your CSV file is constructed.
For example, for a CSV file exported from Microsoft Outlook 2000 (en-US) you set the details as follows:

    Check Text contains headers (Checked)
    Field separator is , (comma)
    Text separator is " (double quote)
    Decimal separator is . (period)
    Thousands separator is (space)

Click Finish.
Click Next.
Click Finish.
To verify that your database is available for merging, hit F4.
To hide the available databases, hit F4 again.

Create a mail merge document

To create a mail merge document, you insert fields.
Insert > Fields > Other > Database.
Select Mail Merge Field.
Select the field you want to insert.
Repeat until you have inserted all the fields you want.
When you print a document containing database fields, OpenOffice.org asks you if you want to do a mail merge.

Inserting text from a database to a text document

With database showing (F4), drag and drop the data field you want into the text document.
Back to top
View user's profile Send private message
woy
Newbie
Newbie


Joined: 25 Nov 2005
Posts: 4

PostPosted: Mon Nov 28, 2005 1:53 am    Post subject: Reply with quote

wow... thanx alot... it really helped me out...

i just have some old databases showing when pressing F4... how can i delete them... right click... but no delete menü...


and another question...

if i want to access the database thru a lan network... without having to use open office... what possibilities do i have... i mean i want to be able to make a simple inquiry... show me name phone# and email adress for example...
Back to top
View user's profile Send private message
james_h
Super User
Super User


Joined: 05 Nov 2005
Posts: 883

PostPosted: Mon Nov 28, 2005 6:17 pm    Post subject: OOo 2: Removing an unused database from Registered Databases Reply with quote

Quote:
I just have some old databases showing when pressing F4... How can I delete them... right click... but no delete menu

OOo 2: To remove an unused database from Registered Databases list

Tools > Options
On the tree on the left, click OpenOffice.org Base to open the branch.
Select Databases
In the list of registered databases, highlight the database to delete.
Click Delete
Click OK
Back to top
View user's profile Send private message
woy
Newbie
Newbie


Joined: 25 Nov 2005
Posts: 4

PostPosted: Tue Nov 29, 2005 12:47 am    Post subject: Reply with quote

thank you for the quick answers... really appreciate it!

ok have no problem so far...

installing mysql right now... basically i want to setup a local server where co workers can make queries and new entries in the database...
Back to top
View user's profile Send private message
indijay
Newbie
Newbie


Joined: 16 May 2006
Posts: 4

PostPosted: Fri Jul 07, 2006 6:50 am    Post subject: I am lost :( Reply with quote

Hello All,

I am trying to import the OpenOffice spreadsheet in newly created database exactly as mentioned by james_h.

Before the final 'Finish' button hit, it tells me..
No, just enter the name under which you want to register the data source in OpenOffice.org
then its path of address.odb!!!

If I hit finish here, I don't see the table in tables section of my database!!!

Anybody can tell me whats going on here?

Thanks
Back to top
View user's profile Send private message
crichton007
Newbie
Newbie


Joined: 17 Jul 2009
Posts: 1

PostPosted: Fri Jul 17, 2009 2:17 pm    Post subject: Funny Thing Is Reply with quote

The funny thing is that using the Address import wizard is by far the easiest way to import data. I've been working all day to get some data that is too big for an .ods file (ironically not too big for an .xslx file) into an .odb file. The only way that I have been able to do it reliably is to use the address import even though they aren't addresses. If anyone has a reliable way to import 75284 records in I would appreciate it.

It seems that if I copy and paste records as has been documented in a number of other places Base seems to automatically interpret certain characters as delimiters (such as commas, colons, etc.) and it throws the data off. None of that happened with the address import.
Back to top
View user's profile Send private message
james_h
Super User
Super User


Joined: 05 Nov 2005
Posts: 883

PostPosted: Fri Jul 17, 2009 11:43 pm    Post subject: Reply with quote

Quote:

The funny thing is that using the Address import wizard is by far the easiest way to import data
Thanks for the tip.

By the way, I find that the data imported this way are read-only. I can't add, delete or edit the data from within OpenOffice.org Base or using View > Data Sources in the Word Processor. This may or may not matter for your application.
Back to top
View user's profile Send private message
lecmac
General User
General User


Joined: 06 Jul 2010
Posts: 12
Location: Carlsbad, California

PostPosted: Sat Jul 17, 2010 12:40 pm    Post subject: Importing CSV into OpenOffice base Reply with quote

Thanks James for the details. They worked great through "Select Other external data source". When I clicked "next" a error screen popped up with this message: The connection to the external data source could not be established. No SDBC driver was found for the given URL.

What do I need to do now to get past this?
Back to top
View user's profile Send private message Send e-mail Yahoo Messenger
james_h
Super User
Super User


Joined: 05 Nov 2005
Posts: 883

PostPosted: Wed Jul 21, 2010 10:59 am    Post subject: OOo Base: Checking settings Reply with quote

Verify Java

Make sure Java is up to date by visiting Verify Java Version with your browser on the web.
Every time you update Java Runtime Environment, you should check the OpenOffice.org settings.
Tools > Options > Java
Ensure Use a Java Runtime Environment is enabled and that the most recent version of Java is selected.
Restart the OpenOffice.org application.

Check the sample database

Tools > Options > Base
Check the settings for Connections and Database.
Click OK
Make sure that the database connectivity is working by attempting to view the sample bibliography database:
View > Data Sources F4
Bibliography > Tables > biblio

Check the ability to create a new database connection

Depending on your operating platform, you can also try connecting the database up to an address book to check the connectivity using
File > Wizards > Address Book Source...

Try connecting using the method mentioned earlier in the thread.

You can also try opening the .csv file with the spreadsheet application, then save the .csv file in the OpenDocument spreadsheet format. Next, use the new database wizard to connect to the spreadsheet data.

See also: Help > OpenOffice.org Help F1 > OpenOffice.org Base > Search > Database Wizard (Base)
Back to top
View user's profile Send private message
sherbert
General User
General User


Joined: 12 Jun 2007
Posts: 21
Location: New Plymouth, New Zealand

PostPosted: Thu Nov 17, 2011 2:54 pm    Post subject: Reply with quote

I've tried all the suggested work arounds but still get the error message mentioned above. Is there, perhaps, a sticky tutorial somewhere?
I have a list of shareholders and their postal addresses. I want to turn it into a registered database. This task eludes me. thanks
(I'd attach a screenshot but cannot see how to do that, either!)
Back to top
View user's profile Send private message
dacm
Super User
Super User


Joined: 07 Jan 2010
Posts: 769

PostPosted: Thu Nov 17, 2011 11:04 pm    Post subject: Reply with quote

How To: Import CSV into Base Table
Importing a csv file directly into base
[Example] Loading CSV into preformatted spreadsheets
[Tutorial] Using csv/text files as editable data source
SQL Functions for file based database drivers
_________________
Soli Deo gloria
Tutorial: avoiding data loss with Base + Splitting 'Embedded databases'
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group