Ask Your Question
0

Database import of data from cdf file

asked 2019-05-31 09:25:08 +0200

01Pad gravatar image

updated 2019-05-31 10:04:00 +0200

Hi I am familiar with documents and spreadsheets, but a complete newbie when it comes to databases. In Word, I had a mailmerge system set up which took data out of a table in one word document and merged it into a report. simple. This seems not to be possible in LibreOffice. I have to make a database and do a report from that. I have been running a fix which also had a large document with a table in it, and I cut and pasted the line I wanted into a report. This has been fairly successful, if laborious, and the source document, which is added to every week, is becoming very slow to load. I need to have some random access database on the HDD which can grow without clogging up RAM too much. I could do this on the ZX Spectrum many years ago (My first computer back in the 80s) but am struggling now. So I have spent a frustrating and interesting couple of hours trying again to make it work with a database. I have exported the data from my old table into a csv file. I have created a database (and registered it - whatever that means), and have set out a table that specifies the data I need, using the titles in the csv file. But I can't find a way of linking the two documents. It seems to want always to impose my data onto an address book with its own titles. I have looked through the beginner guides, but can find nothing that helps me with this task. If there is someone out there who can advise, I'd be very grateful. Many thanks Paddy

I'm a church organist, and the database covers all the music we have sung for the past 14 years. It's getting quite large now. Here's some shots of what I've done so far. (it's pathetic, I know, but is the result of several hours of unproductive work. I have put an Index number as the Primary Key in the table, Table View The only importing bit I can find is the import wizard, which tries to map the data onto address book variables, rather than the ones I have set up in my table.

C:\fakepath\Source Wizard image.JPG I can't seem to link to this second file, which is from the Source Wizard, Address Data Source. The document converter will convert from Word, Powerpoint and excel

So I'm going down the completely wrong path; I just can't find the right one.

I have the data in a table in an Writer.ODT file, and also on a CSF.

Just to see if I could, I converted the source ODT file into a DOC file and tried to import it, but the Document converter reported that it found 0 files to convert, when looking at the folder with the doc file in it.

Help, please!!

But I can't ... (more)

edit retag flag offensive close merge delete

Comments

Same question asked at AOO forum

robleyd gravatar imagerobleyd ( 2019-05-31 09:39:12 +0200 )edit

2 Answers

Sort by » oldest newest most voted
1

answered 2019-05-31 10:37:56 +0200

robleyd gravatar image

If you have a properly structured csv (comma separated values) file, you might start with https://ask.libreoffice.org/en/questi...

You also mention CDF and CSF - I am not sure what you mean by those acronyms.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
0

answered 2019-05-31 21:39:58 +0200

01Pad gravatar image

That is the answer, thanks. I didn't see the option at all in any of my searches. It's usually there, just not where you're looking. I need to re-format the original doc file so that it exports better, and alter how base handles line breaks, and I'll be fine.

Thanks so much.

And my acronyms were rubbish. Cdf is comma delineated fiormat and Csf comma separated fornat. Inconsistent and apparently incorrect to boot. How bad is that? Sorry.

edit flag offensive delete link more

Comments

The abovebshouldn't have been an answer, but a reply to the kind answer below. Thanks. I can't see a name on my phine for the person who helped so much. But many thanks.

01Pad gravatar image01Pad ( 2019-05-31 21:43:31 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-31 09:25:08 +0200

Seen: 54 times

Last updated: May 31