What timestamp format should be used for RPT70 files from CA7?

Products

• Automic Automation Intelligence

Issue/Introduction

When sending RPT70 files to AAI, it is best to append the files names with a timestamp.

This allows files to be processed in order and not overwritten when a new files comes in.

This will also allow you to fill in gaps in data if AAI were to be down for a period of time, as when service is restored the files can be processed in order.

Environment

Release : 6.3.0-1

Component : AUTOMIC AUTOMATION INTELLIGENCE INTEGRATION FOR CA-7

Resolution

There are two ways to accomplish this.

1. Using a file format like RPT70_YYYY-MM-DDTHH:MM:SS should work for having CA7 RPT70 files processed in order.

 

2. Alternatively there is a Configuration Tool->parameter, ca7.processEventFilesByTimestamp, that if set to True, will process files in the order of the timestamp the file was created with as long as each file name is unique.

 

Additional Information

The file name must always start with whatever is configured for the "Report Base DSN" for the scheduler configuration.