- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
Can I automate FDM Multiload text file processing as a single file rather than one file per period?
I am trying to automate the loading of my budget files into FDM, the files all contain 52 periods of data (weekly frequency of data) so I am using multiload text file type.
My files will process through the FDM web application successfully and processes each budget file as one load file but when I use a batchlod script to perform the same excercise FDM treats the files differently and processes each period as an individual load file.
The batch script that I am using is
'Declare Local Variables
lngProcessLevel = 12 'Up-To-Check
blnAutoMapCorrect = 0
'Create the file collection
Set BATCHENG.PcolFiles = BATCHENG.fFileCollectionCreateML
'Execute a Multi-Load Serial batch
BATCHENG.mFileCollectionProcessML BATCHENG.PcolFiles, CLng(lngProcessLevel), CBool(blnAutoMapCorrect)
Can anyone tell me what I am missing or provide an alternative script?