Rules Fail when Importing csv file using a process

rbross

Can't seem to figure out why the rules and Import process is failing when doing an import process. StartDate in MRP BO is not being set to start date set in MRPImport BO
See log record below.

This is the Rule I have on the BO HamiltonMRP
IF HamiltonMRP IS NEW
THEN
HamiltonMRP.ob_MRPImport=MRPImports
HamiltonMRP.StartWeek=MRPImports.MRPStartWeek

When Import process runs this is what the Log view shows.
Rule 1
Started evaluation of rules

     Evaluating rule 'Export Data' If FILE_EXISTS(AS_STRING(MRPImports.MRPStartWeek)+'\')='No' Then  MAKE DIRECTORY AS_STRING(MRPImports.MRPStartWeek)  EXPORT DOCUMENT MRPImports.MRPFile TO FILE AS_STRING(MRPImports.MRPStartWeek)+'\'+'Data.csv'  DeleteHamiltonMRPWeekData  IMPORT HamiltonMRP FROM AS_STRING(MRPImports.MRPStartWeek)+'\'+'Data.csv' WITH VALIDATION USING 'Import Hamilton MRP'    

  Evaluating condition FILE_EXISTS(AS_STRING(MRPImports.MRPStartWeek)+'\')='No'
   Condition evaluated to false: ((04/20/15):2015-04-20+\):Yes=No

Rule 2
Started evaluation of rules
Evaluating rule 'Export Data' If FILE_EXISTS(AS_STRING(MRPImports.MRPStartWeek)+'\'+'Data.csv')='No' Then MAKE DIRECTORY AS_STRING(MRPImports.MRPStartWeek) EXPORT DOCUMENT MRPImports.MRPFile TO FILE AS_STRING(MRPImports.MRPStartWeek)+'\'+'Data.csv' DeleteHamiltonMRPWeekData IMPORT HamiltonMRP FROM AS_STRING(MRPImports.MRPStartWeek)+'\'+'Data.csv' WITH VALIDATION USING 'Import Hamilton MRP'

  Evaluating condition FILE_EXISTS(AS_STRING(MRPImports.MRPStartWeek)+'\'+'Data.csv')='No'
  Condition evaluated to false: ((04/20/15):2015-04-20+\+Data.csv):Yes=No

juicer

Need more information like:
What are you trying to do?
What processes are you running and what are all of the rules in those processes?
What rules are on what BOs?

From the little bit of the log that you show,
It looks like Rule 1 is checking if a directory does not exist.
Evaluating condition FILE_EXISTS(AS_STRING(MRPImports.MRPStartWeek)+'\')='No'
and the system is finding it so your actions are not being executed.
Condition evaluated to false: ((04/20/15):2015-04-20+):Yes=No

It looks like Rule 2 is checking if a file does not exist.
Evaluating condition FILE_EXISTS(AS_STRING(MRPImports.MRPStartWeek)+'\'+'Data.csv')='No'
and the system is finding it so your actions are not being executed.
Condition evaluated to false: ((04/20/15):2015-04-20++Data.csv):Yes=No

rbross

Changing the '=No' to a ='Yes' resolved the issue and the import process worked.