Import Script Sample

#----------------------------------------------------------------
# Sample shows how to use the value from the fdmContext map, In
# this sample return the Location as value for the column
#----------------------------------------------------------------

def getOrgfromLoc(strfield, strrec):
    org = fdmContext['LOCNAME']
    return org

#------------------------------------------------------------------
# Sample to show the Jython string function. The script below is 
# used to parse a account column 01-205-4110-0000-000 and return the
# third string 
#------------------------------------------------------------------

def getSegfromAcct(strfield, strrec):
  if strfield.count("-") > 0:
    seglist = strfield.split('-')
    result = seglist[2]
    return result

#----------------------------------------------------------------
# Sample to process header record in Trial Balance report and
# store value in global variable to be used during detail row 
# This should be called from the Amount column in import format
#----------------------------------------------------------------

globalorg = ""
globalcur = ""

def copyglobal(strfield, strrec):
  if strrec[18:27] == "Currency:" :
    global globalcur
    globalcur = strrec[29:32]  
  if strrec[14:27] == "Organization:" :
    global globalorg
    globalorg = strrec[29:32]
  if strrec[42:47].strip() == 'Total' or strrec[29:34].strip() == 'Total' :
    return fdmSkip
  return strfield

#----------------------------------------------------------------
# Sample to return the global variable set during amount process
#----------------------------------------------------------------

def getCurrfromGlobal(strfield, strrec) :
    return globalcur