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

How to add new .csv file as data source

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


Joined: 22 Sep 2005
Posts: 8

PostPosted: Thu Sep 29, 2005 3:37 pm    Post subject: How to add new .csv file as data source Reply with quote

Hi Everyone,

Keen to download and test the 2 - RC1 candidate to test this.

How do I add csv files as data sources.
If I do it in the Options, it never works ( it accepts the file I pick, but won't expose the fields )

What I have to do is run through the mail merge wizard, select the file, then cancel the wizard and the data source is installed ok ( e.g. for use in the New >> Labels

But this is somewhat un-elegant.

Am I missing something ?

regards, Dave Porter
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sat Oct 01, 2005 9:18 pm    Post subject: Reply with quote

File>New>Database

From the databse wizard choose.

Choose - Connect to an existing database. (radio button)

In the drop down box just below this select TEXT

select the NEXT button.

You will enter the path to a directory that contains the files you want to treat as tables in this databse.
You can choose to have this database open *.csv, *.txt or *.(you name it) as these tables.
You will see settings for describing how the columns are denoted, etc on this page also.

When you are done setting up the options hit NEXT, give the new ODB file a name.

That should do it for you.

HTH

Drew Jensen
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
daveporter99
General User
General User


Joined: 22 Sep 2005
Posts: 8

PostPosted: Sun Oct 02, 2005 12:45 am    Post subject: Reply with quote

Hi Drew,

Thanks for you help - that's becoming clearer now.

One thing ( and maybe it is not that important ) - How can a choose comma as the dlimiter and ignore the thousands separator ? It won't allow them to be the same, so I changed the thousands separator to ' . ', but then it won't proceed as that is the same as the decimal separator ? I blanked it out in the end, but not sure what the ramifications of that are ?

regards, Dave Porter
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Oct 02, 2005 1:08 am    Post subject: Reply with quote

Dave,

Not really sure if there will be any ramifications. But haven't tried enough combinations like that to tell you anything one way or the other. Sorry.

Drew
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
daveporter99
General User
General User


Joined: 22 Sep 2005
Posts: 8

PostPosted: Sun Oct 02, 2005 3:57 am    Post subject: Reply with quote

Thanks Drew,

I guess it just appeard to me to be a catch-22 situation and maybe something someone should look at the make it more friendly.

I am just putting together a tutorial for my clients and this seemed to throw a spanner in the works.

Will push on !

cheers, Dave
Back to top
View user's profile Send private message
DrewJensen
Super User
Super User


Joined: 06 Jul 2005
Posts: 2616
Location: Cumberland, MD

PostPosted: Sun Oct 02, 2005 5:15 am    Post subject: Reply with quote

You knowwwww Dave..

There seems to be a real dirth of documentation on Base.

If you are creating a tutorial, I bet the the folks over on the OOOAuthors site would really appreciate a version...

Drew
_________________
Blog - http://baseanswers.spaces.live.com/
Back to top
View user's profile Send private message Send e-mail Visit poster's website
daveporter99
General User
General User


Joined: 22 Sep 2005
Posts: 8

PostPosted: Sun Oct 02, 2005 2:34 pm    Post subject: Reply with quote

Hi Drew,

Yes, it had occured to me to submit the tutorial once it is finished....

regards, Dave
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