1 Reply Latest reply on Sep 12, 2017 9:34 AM by SH_INT

    Migrating a custom vb script from FDM to FDMee

    user9082214

      Hello,

       

      We are in the process of upgrading from 11.1.2.2 to 11.1.2.4 - we have some simple custom VB scripts that we would like to migrate, but having some issues.

       

      The scrip in our current system basically is very simple - just has two functions (1) focus on a location and delete a dimension mapper (for instance the Account mapper), and (2) load a new mapper from a text file

       

      Here is the script:

      =============================================================================================================================================

      Sub FDM_Import_BS_Account_Mapper()

      'the three following lines are added For Btach automation. You don’t need them when running directly into FD workbench

      Dim BATCHENG

      Set BATCHENG = CreateObject("upsWBatchLoaderDM.clsBatchLoader")

      BATCHENG.mInitialize API, SCRIPTENG

      'Define the point of view MsgBox Is added To display the value On the screen during debug

      API.POVMgr.PPOVLocation = "Europe_Bal_Sheet"

      strFilePath = "\\Tkc02shdb006w12\FDMEE\xxx\inbox\Europe_Bal_Sheet\FDM_Eur_BS_Acct_Mapper.tra"

      strDimension = "ACCOUNT"

      'Delete the previous Mapper

      RESULT1 = API.SQLUpdateMgr.fDataMapDelete(API.POVMgr.PPOVLocation, strDimension, "False")

      'Import the Mapper

      RESULT2 = API.IntBlockMgr.InterfaceMgr.fImpTRx(API.POVMgr.PPOVLocation, strFilePath, strDimension)

      End Sub

      =======================================================================================================================================================================================

       

      When the script executes, basically nothing happens.  The problem is that the "log" is really useless - here is the log - doesn't give any errors:

      ===================================================================================================================================================

      2017-08-31 13:27:48,273 INFO  [AIF]: FDMEE Process: 23, Log Level: 4, Log File: \\Tkc02shdb006w12\fdmee\Exide\outbox\logs\xxx_23.log

      2017-08-31 13:27:48,273 INFO  [AIF]: Location     : null (Partitionkey:null)

      2017-08-31 13:27:48,273 INFO  [AIF]: Period Name  : null (Period Key:null)

      2017-08-31 13:27:48,273 INFO  [AIF]: Category Name: null (Category key:null)

      2017-08-31 13:27:48,273 INFO  [AIF]: Rule Name    : Europe Custom Scripts Folder (Rule ID:10,183)

      2017-08-31 13:27:48,882 INFO  [AIF]: FDM Version: 11.1.2.4.200

      2017-08-31 13:27:48,882 INFO  [AIF]: Log File Encoding: UTF-8

      2017-08-31 13:27:49,273 INFO  [AIF]: Executing the following script: \\Tkc02shdb006w12\fdmee\xxx\data\scripts\custom\FDM_Import_BS_Account_Mapper.vbs

      Microsoft (R) Windows Script Host Version 5.8

      Copyright (C) Microsoft Corporation. All rights reserved.

      2017-08-31 13:27:49,367 INFO  [AIF]: FDMEE Process End, Process ID: 23

      ============================================================================================================================================

      Are we needing to use some new API commands?

       

      Appreciate any help......

       

      Thanks