eRecs bulk upload feature provides capability to update in bulk for both receivable and payable trade data.
The uploads are done using a CSV template available in the eRecs Reports portal. The CSV templates are also uploaded back into the portal.
- Open eRecs Report Portal
- Select either the
- Submit – Batch Trade Update – RCV folder [for all Receivable trade actions]
- Submit – Batch Trade Update – PAY folder [for all Payable trade actions]
- Select the TEMPLATES folder
- Select and download the template to be used
- Enter the data for updates in the file
- The templates identify trades by the trade key generated by eRecs
- Remove all other data that is not being updated (i.e. sample data in each template).
- Save the template as CSV with REQUIRED naming format below-
- Use original file name
- Remove the prefix TEMPLATE_
- Replace “USER” with user’s username (does not include @FIRM portion of username)
- Replace “testfile1” with a file name/ description
- Ex. File name TEMPLATE_ATL-RCV-TrdAmd-USER-testfile1.csv is saved as ATL-RCV-TrdAmd-FiaTech-2018trades.csv
- Use original file name
- Upload the CSV file into the Reports portal in following folder, select either the
- Submit – Batch Trade Update – RCV folder
- Submit – Batch Trade Update – PAY folder
- Upload the CSV file in this folder (the file is not loaded into the following TEMPLATES folder)
- Select the upload button on menu bar. Once file is uploaded it will sit below the TEMPLATES folder. Then the file will automatically be picked up for processing based on the correct file name. The system also expects data formatted per file name. No changes/ additions should be made to the CSV.
- Once the file is processed, the results or status of the bulk upload files will be available in the BatchTradeUpdate folder.
- The system will identify the line items that did not process and error out.
- Files that are processed successfully have a prefix of GOOD
- Files that have an error in processing will have the error lines in a file with prefix ERROR
- The system will identify the line items that did not process and error out.
Comments
0 comments
Please sign in to leave a comment.