Ask Your Question

What is the procedure to create a custom Base data file?

asked 2020-07-24 00:14:45 +0200

ASPRO gravatar image

It's my experience to modify a Base template would take just as long as starting from scratch, for my purposes. I have spreadsheets of data I would like to search, update and append. Finding Media files across terabytes is my purpose.

Best Regards

edit retag flag offensive close merge delete


Could you please elaborate on your question? Are you aiming to use Base to perform SQL queries (search) the data which in turn is in a spreadsheet, meaning the spreadsheet is the actual database? Is the data already assembled using something outside of LibreOffice? Or, do you plan to write a macro that assembles a list of media files and have these stored in the database/spreadsheet? By modifying a Base template, are you referring to reusing an existing schema/database structure?

lazarus477 gravatar imagelazarus477 ( 2020-07-24 01:59:30 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-07-24 23:04:36 +0200

ASPRO gravatar image

Thank you for your response.

Data collection starts with a directory listing output to a CVS file that is imported into a spreadsheet. Additional columns related to metadata are added to the sheet that will be used to embed the media files consisting of audio, video, and image files. This will require 3 Base files as metadata is different between the 3 file types.

I am not sure as to queries what would be the shortest and quickest path given this scenario. I would value your advise on this issue.

I understand what macros are, a collection of commands and key strokes. I am not familiar with LibreOffice macro capabilities. I would appreciate direction to the appropriate documents outling the use of macros. Best Regards _A_

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-07-24 00:14:45 +0200

Seen: 47 times

Last updated: Jul 24