1 Reply Latest reply on Sep 4, 2012 3:32 PM by user10757003

    FDM Export file period name is wrong

    959848
      Hello All,

      While clicking Export in four fish process, file name shows incorrect POV period in Target system load pop up box. For ex: If POV period selected for P8, file name shows as Location07.Dat instead of Location08.Dat. For each period POV, file name shows previous period in file.

      Kindly provide me your thoughts.


      Thanks.
        • 1. Re: FDM Export file period name is wrong
          user10757003
          the details for the file format from the FDM API guide are listed below. do you by any chance have Period 8 in the FDM period table ending in July?

          an example i just tried has the period table record as follows:

          Period End Date = 1/31/07
          Prior end Date = 31/12/06
          Text Desc - Jan - 2007
          Target Period = P6

          The created export file gives LOCATION018.DAT (Where 8 is the next sequence number, and 01 the period - i.e. it is the FDM period not the target application period.)



          fMakeExpFilename
          FDM (Main) Data Window 11.1.2.1.00 (upsWDataWindowDM.dll) clsUtilities
          Description
          Generate a unique export file name using the format of: Location Name + Month + Sequence + .DAT.
          Parameter(s)
          ByVal strLoc As String, ByVal strFolderPath As String, ByVal dtePeriodKey As Date
          strLoc Location name to use in file name
          strFolderPath Folder path to create file in
          dtePeriodKey Date value to use for month segment of file name