Question

0

SQL to produce Excavator CSV files from Rock RMS system database

Hock_Hin Lee posted 8 Years Ago

Question #1

Is it possible to write SQL that will "create" table/data as per the CSV file format required by Excavator for Bulk data import? (Cut and Paste SQL results to Excel, then Save As CSV file)

This would be an easy way to "reverse-engineer" the CSV file after all the unique configuration done in Rock RMS. E.g. after adding new fields in Person page, Adding Blood Group type, etc

Question #2

Does someone already have this SQL?

0
- Nick Airdo replied 8 Years Ago
Q1) Yes, depending on your SQL skills, the amount and type of data you're talking about, and your access to the database. It should be possible. The SQL Command block under the Power Tools also creates a grid/table that has an Excel export that could be of use for that.

Q2) I have not heard of anyone doing this for Excavator yet.
Edit Answer

Q1) Yes, depending on your SQL skills, the amount and type of data you're talking about, and your access to the database.  It should be possible.  The SQL Command block under the Power Tools also creates a grid/table that has an Excel export that could be of use for that. Q2) I have not heard of anyone doing this for <a href="https://github.com/NewSpring/Excavator/wiki/Frequently-Asked-Questions">Excavator</a> yet. 
Q1) Yes, depending on your SQL skills, the amount and type of data you're talking about, and your access to the database.  It should be possible.  The SQL Command block under the Power Tools also creates a grid/table that has an Excel export that could be of use for that. Q2) I have not heard of anyone doing this for <a href="https://github.com/NewSpring/Excavator/wiki/Frequently-Asked-Questions">Excavator</a> yet. 
Q1) Yes, depending on your SQL skills, the amount and type of data you're talking about, and your access to the database.  It should be possible.  The SQL Command block under the Power Tools also creates a grid/table that has an Excel export that could be of use for that. Q2) I have not heard of anyone doing this for <a href="https://github.com/NewSpring/Excavator/wiki/Frequently-Asked-Questions">Excavator</a> yet. 
Save Cancel