Description: I'm looking into building a stock portfolio management application. I want the account data to be in a local database, but there are several tables that need to be updated daily with new data. For example the price_master table looks like the following: SYMBOL PRICE DIVIDEND YIELD PAY_DATE PE_RATIO FCX 39.525 0.15 1.56% 11/01/2022 14.60 ADM 92.435 0.40 1.72% 12/07/2022 12.86 This data is available from a CSV download file and it only takes a half minute to copy/past the appropriate columns into a CALC workbook that I've setup for this. Although the data in these tables change, there is never any reason for the application to make the changes. A read only table is all that is needed. Data that is managed by the application should be in the embedded HSQLDB database. The security_master table is a good example of this: SYMBOL DESCRIPTION FCX Freeport-McMoran Inc Class B ADM Archer Daniels Midland Co Common My use case is in finance, but I can readily think of many use cases in other fields where this capability would be very useful. This enhancement would allow BASE to function as a reporting engine bringing together multiple data sources. Steps to Reproduce: 1. N/A Enhancement request 2. 3. Actual Results: N/A Enhancement request Expected Results: N/A Enhancement request Reproducible: Always User Profile Reset: No Additional Info: N/A Enhancement request
Do you know you could connect to *.csv-tables directly with internal HSQLDB? https://books.libreoffice.org/en/BG73/BG7302-CreatingADatabase.html#toc72
That looks like it will work. I'll check it out. Adding this functionality to the GUI to make it easier it all that is left to do. Much appreciated and thank you, Carlisle