D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] libre office macros/dialogs

 

You likely won't import CSV into a database .. you might pull it via Calc ..

There's probably a hundred ways to import it into a "real" database
(sqlite, postgresl, mysql, etc) - I've done something crude in PHP before,
but pick your poison - perl, python, bash (!), java .. I could go on ..

Regards,
Michael.

On 23/04/20 15:25, Tom via list wrote:
> A freind of mine is an archaeologist and pointed me to a lot of free data
> from a long term excavation and it comes in the form of CSV files and
> some pdf docs that describe the structure of the real DB and I thought I
> might just have a play with them in LibreOffice Base. OK so you cant read
> a CSV file in to a table, so I think I'll write macro to do it and use a
> dialog to read in the file location, extract the column titles from the
> first line and do some scanning to ascertain the column type etc etc.
>
> OK so I cant find a filefinder dialog to get me to the file and all the
> online help points nowhere! I'm not sure anyone else has ever used Base
> in anger as I can find no  useful documentation on the LO site. Have any
> of you got any links to LibreOffice stuff that might help me? I'm on LTS
> Xubuntu 18.03 and Libre Office Version: 6.0.7.3. I have a mind to keep
> kicking this until I can do stuff on Base I could do in access 35 years ago!
>
> Tom te tom te tom
>
>


Attachment: signature.asc
Description: OpenPGP digital signature

-- 
The Mailing List for the Devon & Cornwall LUG
https://mailman.dcglug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/listfaq