5 Replies Latest reply on Jun 25, 2012 9:37 PM by 945487

    FDM Multiload Batch loader issue

    shiv2
      Hi All,

      I need help in Multiload Batch load process. I am working on FDM 11.1.2.1. We need to move data of 6 months. I am using comma separated Text file for this purpose.

      When I am loading it through FDM user interface, it is fine (It is generating 1 export file for all 6 months with diffrent combination) but If I am trying to run it through FDM Batch load for Multiload it is generating the 6 export files and loading one by one (Which I don't want).


      I want one export file generated for all month. Is there any setting by which FDM will stop multiple Export file generation for diffrent month.

      Remaining process is Working fine if I am loading manually through FDM web.


      Thanks,
      Shivendra
        • 1. Re: FDM Multiload Batch loader issue
          JeffJon
          Are you loading with a text file for the batch process as well or with an Excel Multiload Template?
          • 2. Re: FDM Multiload Batch loader issue
            shiv2
            Thanks!!!

            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).

            PLN-TO-RPT
            2QEST
            Jan - 2012
            3
            R,R,,,,,N
            A,C,5,8,1,2,6,9,V,V,V
            PLN0291,QCEL_E,No Product Line,570,Working,Current,20,-20,40189.4


            Thanks,
            Shivendra

            Edited by: shiv2 on Jun 13, 2012 3:26 AM
            • 3. Re: FDM Multiload Batch loader issue
              Stuart Game
              Hi Shivendra

              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
              Stuart
              • 4. Re: FDM Multiload Batch loader issue
                JeffJon
                Have you tested with an Excel Template?
                • 5. Re: FDM Multiload Batch loader issue
                  945487
                  Its just the way the multiload batch run is setup in fdm (6 export files) and manual text/excel works fine as intended.