Archiving the documents using XMDBTool - archivepurge.bat/sh

You can now use archivepurge.bat available in the the XMDBTool distributable to archive and purge the documents from XMDBTool client. This feature is similar to the ArchivePurge feature in Infor Expense Management.

The archived files are downloaded to a directory specified by the user in the client machine. These parameters are used:

  • Archive: This parameter can be set to true or false. If set to true, the archiving process is executed. The default value is false.
  • archive_location: The location on the client machine where the archived files are downloaded from the server.
  • activity_ids: This is the activity ID that must be archived. More than one activity ID can be specified separated by dot(.). For example: activity_id=72001.72281.
  • cutoff_date: The cutoff date for archiving that must be specified in the YYYYMMDD format.
  • startDate: The start date of the archive process. When specifying from the command line, the date and time must be specified in the yyyy-MM-dd%HH:MM format. The percent is included to avoid the space between the date and the time.
  • endDate: The end date of the archive process. When specifying from the command line, the date and time format must be specified as yyyy-MM-dd%HH:MM. The percent is included to avoid the space between the date and the time.
  • dateType: The dateType parameter determines the date to select the document from 'alwf_work_item'. The possible values for the parameter:
    • doc_date_created
    • doc_date_modified

    By default, the value is set to doc_date_created.

    You can set the value of the xmdbtool.nodate application parameter to true if you do not want the dates to be considered when filtering the data to be archived. By default, the value is set to false.

The Purge functionality is now activated in the Infor Expense Management version 10.2.13. You can set the value of the purge parameter in the xmdbtool.properties file to True , when using the archivepurge.bat file from the XMDBTool client. You can also specify the purge parameter value in the background when using the archivepurge background process. By default, the value of the purge parameter is always set to False.

The logs for the Purge action is displayed in the console when the purge functionality is executed from the XMDBTool client. However, if the purge action is executed from the XMDBTool background process, the background process logs are available in the SFTP.

Note: The purge functionality deletes data for the specified activity and the specified date range from the database. Ensure that necessary backup arrangements are made such as requesting the DBA to take the DB backup, before running the purge feature.