1 Reply Latest reply on Nov 18, 2010 2:34 PM by TonyScalese

    FDM Import Script

    810700
      Hi,

      i'm new making import scripts to FDM. I m making an integration script between SAP and FDM. I m getting information from via web FDM, the problem is when i a m trying to add this information to the workTable. The code is as follows:

      *********************************************************
      for i = 0 to tData.Rowcount

      Set rsAppend = DW.DataAccess.farsTable(strWorkTableName1)
      rsAppend.AddNew
      rsAppend.Fields("PartitionKey") = RES.PlngLocKey
      rsAppend.Fields("CatKey") = RES.PlngCatKey
      rsAppend.Fields("PeriodKey") = RES.PdtePerKey
      rsAppend.Fields("DataView") = "YTD"
      rsAppend.Fields("Entity") = arrayResult(19)
      rsAppend.Fields("Account") = arrayResult(0)
      rsAppend.Fields("Desc1") = arrayResult(0)
      rsAppend.Fields("ICP") = "[None]"
      rsAppend.Fields("Amount") = saldoTotal
      rsAppend.Update
      next
      *********************************************************


      Whe i execute this script i just receive an error message saying: "Error: Import Failed", nothing appears in the Error log, neither in the work table.

      Can anyone help me? Does anybody know what can i do to add these records in the work table?

      Thanks in advance.

      Regards.