D&C GLug - Home Page

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

[LUG] libre office macros/dialogs

 

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


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