Batch Upload Pre-Processor
Modules in this category
- Batch Upload of Sales and Royalty Data
- Batch Upload Pre-Processor
- Check Details Import/Export
- ProFiles Data Interchange (Outbound)
- Profiles Data Interchange with File Creation
Module categories
Category: Data tools
As an enhancement to the standard Batch Upload, the Batch Upload Pre-processor performs two very time efficient processes which can reduce the actual upload time dramatically. Many times that data in a batch upload is pulled from a Sales/Shipping system where a single item may appear thousands of times in a single period on several invoices for several customers. Furthermore, the sales/shipping system only knows product and has no real reference to “Contracts.” The Batch Upload Pre-processor takes care of this. Its first process will accept a sales upload file with no contract identifiers and perform an extensive search through the ProFiles data to automatically associate the sales items with the appropriate contracts. The second process will then take the detailed sales data and summarize it at the appropriate levels for the contracts to be affected by the sales. If the contract requires only grand totals by one criterion, then thousands of data lines can be combined into only a few lines. The summarizing often reduces the upload file size by as much as 70%. For large upload files, these two pre-processes provide an even greater reduction in time spent completing the monthly royalty processes.
