Import script return error, but return proper results in Python
It is very simple script:
strfield = ''
strrecord = '1900030978,9901,19000,8155,651200,TEMP LABOR,,,2015,7,42755,ADECCO USA. INC,Williams WE 6/21/15,"1,555.40",USD,6/22/2015,6/29/2015'
def check_blank(strfield, strrecord) :
if strfield :
strTmp = str(strfield)
return strTmp
else:
strTmp = "BLANK"
return strTmp
print " result is " + str(check_blank(strfield,strrecord))
Python returns: "BLANK" is what I expected, but in FDMEE got error: FDMEE version: 11.1.2.3.520
'******************************************************************************************************************************************************************************************************************************************************************************************************
2015-08-14 07:45:26,596 INFO [AIF]: ERPI-105011:EPMERPI- File Name 07-2015 Essbase Load -Test.csv
periodKey2015-08-01
2015-08-14 07:45:26,611 DEBUG [AIF]: 105039:EPMERPI - Error evaluating the expression : check_Blank('','1900030978,9901,19000,8155,651200,TEMP LABOR,,,2015,7,42755,ADECCO USA. INC,Williams WE 6/21/15,"1,555.40",USD,6/22/2015,6/29/2015' )
result: null
2015-08-14 07:45:26,627 ERROR [AIF]: 105039:EPMERPI - 105042:EPMERPI - Error evaluating the script.