You must set up a UAL configuration file for each API method that you wish to call for loading data into Aria. A nightly batch job pulls the configuration file from your FTP server and attempts to load it into Aria. You can also run the batch job that loads your UAL data into Aria on-demand instead of waiting for the nightly batch job to run, or you can schedule multiple batch jobs.
Note: It is recommended that no more than 10,000 records are loaded into UAL during a given batch job. If you wish to load more than 10,000 records, please contact the Aria Systems Customer Support team.
Creating a New Activity Loader
Getting Here: Click Configuration > Integrations > Activity Loader
- Click New. The Create New Activity Loader screen displays.
- From the File Uploading Status drop-down, specify whether the UAL file upload should be enabled or disabled. If you don't want this file to be uploaded automatically during the nightly batch job, then you may wish to disable the file upload until ready for upload.
- In the Server Location field, enter the server location path from which Aria should retrieve the UAL file.
- In the File Path field, enter the path to the folder on your server in which the UAL file is located.
- In the File Name field, enter the file name of the UAL file.
You can use wildcard characters such as “*” in the file name. For example, you can enter a file name such as companynameusage_*.csv. You can then use regular expressions to uniquely name each file. That way, your files could be named as follows:
- In the Username field, enter the user name that Aria should provide in order to access the server on which the file is located.
- In the Password field, enter the password that Aria should provide in order to access the server on which the file is located.
- From the Protocol drop-down, select the type of communication that Aria should use to connect with your server.
- In the Configuration File field, click Choose File to select your configuration file.
- From the Type of Encryption drop-down, select the type of encryption that applies to your configuration file, if applicable.
- From the File Compression Type drop-down, select the type of file compression that applies to your configuration file, if applicable.
- In the File Delimiter field, enter the delimiter that you will use between the columns in the file. The delimiter can be a comma “,” or a pipe character “|”, as long as it is used consistently throughout the same file.
Note: Aria supports only the following delimiters: “,” and “|”.
- From the Respond When drop-down, Specify the type of response you wish to receive from Aria:
- Send response only when failure occurs
You will receive a response only if an error occurred while Aria was attempting to load your UAL data.
- Send response always, success or failure
You will receive a response when Aria has successfully loaded your UAL data, or if an error occurred during the file upload.
In the Number of Allowable Failures field, enter the maximum number of attempts for which a file upload can fail before Aria stops trying to load the record(s).
Note: The number of records in the error log will not exceed the number of allowable failures that you specify. Aria will stop processing the data file once the maximum number of allowable failures has been reached.
- From the Response Method drop-down, select how you want to receive a response about the results of data load attempts:
Do not send response
You will not receive a response from Aria. However, you can check the UAL logs in Aria to view the results of each data load attempt.
Always send status
You will always receive an upload status from Aria.
Notify when no files are found.
You will receive a response from Aria stating that there were no files found.
Send back to server
Aria uploads a text file listing the failed records to your server.
Send via e-mail
Aria sends a text file listing the failed records to your specified e-mail address.
Send to server and via e-mail
Aria uploads a text file listing the failed records to your server and sends that text file to your specified e-mail address.
- Click Save.
Your configuration is saved. A nightly batch process will pull the data from your server and attempt to load into Aria.
Note: Repeat these steps for each additional API method that you want to call for loading data into Aria.