Question

Photo of Hock_Hin Lee

0

Is it possible to "undo" data import using Excavator?

2

I am configuring Rock RMS to meet the needs of my church.  Rock is very powerful and interesting.  Just finished setting up the address format as per Malaysia postal system.

However, it would be nice to import some real-life data into the system for further testing and configuration.  Then once I am happy with the configuration, I would like to remove/undo ONLY the data imported whilst keeping all the System Configuration done.

Then only will I do the full data migration of all the members details, incorporating new fields, etc of the Final Rock Configuration.  E.g. if I managed to successfully add a "Maiden Name" field in the Person Profile page, then data for this field will also be imported.

If the data import cannot be undone/reversed, then I will have to limit myself to only a few "persons" at this stage of the development.

One possibility is the SQL scripts to delete all records in the tables containing data imported using Excavator (except the Administrators)

  • Photo of Austin Spooner

    1

    I do not believe that you can remove only the data you imported via Excavator. One thought would be to do all of your configuration and then take a database backup. Then import your data and do some testing. If everything looks good restore your database backup and do your final import. You could also create a second Rock installation for testing - in witch you import all of your test data. 

    • Jim Michael

      Jim Michael

      I second this suggestion. Just about everyone needs two Rock instances... production and a dev/test instance where you can test, play, then delete and redo it again from a dump of prod.

    • Photo of Hock_Hin Lee

      0

      Comment:   Having a Test instance is Option#2, as all the changes to configuration done in the Test Instance will have to be recorded and re-done in the Production instance.  Complexities of dealing with two objects instead of one.  But this will be the way forward if Option#1 is not possible.

      Question:   Is it possible to setup Production and Test Instances on the same server (without using virtualisation, etc)?