[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]
On 23/04/2020 21:05, Eion MacDonald wrote:
Its seems to have some of the bits required to make something useful. I used to hate Access but I could write things with it that were really really useful and if you made sure everything worked through stored procedures or the code equivalent you could provide organisation wide tools that were really easy to use to provide reporting and data entry either directly into the ERP system or 'caches' that could be batch updated to the system later.On 23/04/2020 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 tomNever used Base in anger, or otherwise.
If Base worked even 50% as well as Access used to then it would be really useful for SMBs.
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