content

» Script Library: Table Backup and Restore

Table Backup and Restore

Back up a table to a CSV with all fields from any form and save any attachments to the file system.

Restore same CSV and any attachment files extracted by the Backup script.

Demonstrates

This scrpt introduces more complex features of Meta-Update including Fields Loops, Output files based on schemas, schemas and queries being passed as arguments, and the Attachment Save command.

Loading

Nothing is needed for these scripts. Just run the Backup script first. Then run the Restore script as needed.

Running

For a complete test, run the backup script against a test form specifying a query resulting in a single record. Delete that record after the baclup script runs. Run the restore script and your record should be restored.

 SthMupd.exe  SvTbl.ini Do -p _Test test 
"'1' = \"000000000000001\"" SthMdel.exe _Test "'1' = \"000000000000001\"" SthMupd.exe LdTbl.ini Do -p _Test test

Sample output

Click the Sample Output to open a
new window with an enlarged image.

More Information

These scripts will need to be edited to fit your requirements. They will also need Meta-Update installed and licensed to run.

Downloads

    Save the zip, expand in your samples or scripts directory. The zip file may contain different versions of the script and a tutorial document.

  • zip