SysManUtil can be used to maintain table data by providing support for the following:
Action |
Description |
Delete |
Existing records can be deleted based on data from an XML file. This data must contain the full primary key value of the record(s) to be deleted. If the record to be deleted does not exist, an error is issued. The user can optionally turn off the processing of business rules while deleting records. |
Export |
Data can be exported to an XML file. The user can optionally specify a range of records to be exported instead of all data. Records can be exported with or without object attachments, and the attachments may be exported to a zip file or to a directory. |
Import |
New records can be inserted from an XML file. If the record already exists in the table, the record will fail to be inserted. The user can optionally turn off the processing of business rules while inserting records into the table. If object attachments are present in the import XML file, then they are automatically imported |
Overlay (from CSV) |
Existing records can be updated and new ones inserted with data from a CSV file. The user can optionally turn off the processing of business rules while overlaying. |
Overlay (from XML) |
Existing records can be updated and new ones inserted with data from an XML file. The user can optionally turn off the processing of business rules while overlaying. For records that are updated, if new object attachments are present in the import XML file, then they are automatically imported, and if deleted object attachments are present, then they are deleted. For records that are inserted, if object attachments are present in the import XML file, then they are automatically imported. |
Purge |
All existing records can be purged without using an XML file. Please note that for this action SysManUtil will issue a direct SQL to the database hence no business rules will be fired to validate if the purge is allowed or not. |
Update |
Existing records can be updated with data from an XML file. If the record to be updated does not exist an error is issued. The user can optionally turn off the processing of business rules while updating records in a table. If new object attachments are present in the import XML file, then they are automatically imported, and if deleted object attachments are present, then they are deleted. |