This content has been marked as final. Show 5 replies
Are you loading with a text file for the batch process as well or with an Excel Multiload Template?
I am using text file say "abc.txt", the delimiter is comma in text file.
File example is below. The issue is: one file is getting exported for each month not sigle file for all months, while loading with batch load.
Same file is behaving fine if I am using FDM web URL(mannaul process).
Jan - 2012
PLN0291,QCEL_E,No Product Line,570,Working,Current,20,-20,40189.4
Edited by: shiv2 on Jun 13, 2012 3:26 AM
Unfortunately I think it is a "feature" of batch processing.
When processing multi-load files manually through FDM a text multiload source file produces a single export file while an excel multiload source file produces a separate export file for each period in the source file.
With batch processing unfortunately both types of source file behave the same as the manual excel way.
One option that may help you is parallel processing in the batch? Be warned though, that may not help either as the parallel processing will queue files for the same POV (I think from memory it treats different periods for the same location/category as the same POV in parallel processing so if you are loading say 12 periods for the same location/category you may not gain anything in parallel processing).
Hope this helps
Have you tested with an Excel Template?
Its just the way the multiload batch run is setup in fdm (6 export files) and manual text/excel works fine as intended.