Most of my work revolves around mail merging in Adobe InDesign for some PDF generation.
The current steps are as follows:
Enter data in MS Excel's appropriate columns, with one column dedicated to image URL (if any).
Exporting complete worksheet in .csv file format.
Updating .csv link in Adobe InDesign
Finding row no. of the newly added / entered rows
Mail-merging data in Adobe InDesign
Now the issue I'm facing is of data entry. With scope of increasing workload, I'm thinking of adding another terminal for entry of data to the excel worksheet but with this comes another issue of handling concurrent users in same excel sheet. Also, I want the files to be backed up online.
I tried using OneDrive as a central location to back up but it causes huge problem when two people start working on the same file and click 'save'. On 'saving' a file, OneDrive finds differences and instead of merging the edits intelligently, OneDrive creates another copy of the excel file and this creating confusion.
So I am wondering if:
There can be a way to have lightweight Oracle installed in other systems and Oracle server / main database installed in the main machine so that multiple people can work on same database concurrently without worrying about redundancies?
Such Oracle / MySQL or any suitable lightweight SQL database can be accessed online Such database can be backed up online
Is there a tool to import data directly from Oracle into Excel? or if not, Is there a way to convert data directly from Oracle database (filtered via SQL query) into .csv?
If there is an option to work on Database such as Oracle / MySQL / MSSQL / Postgre or any that can help me export .csv file for an extract / SELECT query, then I is there a way to enter it using some GUI instead of command line?