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

  Set the value of this parameter to True for initiating the archiving process and storing required documents in the XML files. The default value is false.

• archive_location

  The location on the client machine where the archived files are downloaded from the server.

• activity_ids

  The activity ID that must be archived. Specify a dot-separated list of activity IDs for selecting the required expense reports. The IDs correspond to the activity_id column in the alwf_activity table.

  For example, you can specify the Activity IDs as 72008.72009 to run the Archive and Purge tool for all the expense reports in the Archive and Destroy activities.

  This SQL statement provides a list of the Expense Report Activity IDs and the names to determine the appropriate activities for the Archive and Purge process:

  SELECT activity_id, display_name

  FROM alwf_activity

  WHERE (business_process_id = 101)

• cutoff_date

  The cutoff date for archiving that must be specified in the YYYYMMDD format.

  For example, if the cutoff date is 20120101, all documents created before January 1, 2012 are eligible forarchiving or purging, along with the Activity IDs.

• startDate

  The start date of the archive process. When specifying from the command line, the date and time mustbe specified in the yyyy-MM-dd%HH:MM format. The percent is included to avoid the space between thedate and the time.

• endDate

  The end date of the archive process. When specifying from the command line, the date and time formatmust be specified as yyyy-MM-dd%HH:MM. The percent is included to avoid the space between the dateand 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.

• purge

  Set the value of this parameter to True for deleting documents from the database. Else, set the value to false.

• Tenant Id (Optional)

  Specify the tenant id. This parameter applies to the multi-tenant environment only.

• archive.countryISO

  Specify the archive or purge document that belongs to a user with a country iso

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.