Problem with IMPORT BO from csv fle

Craig

I have a process to create sample data which states-
IMPORT MYOBJECT FROM '../lookup/MYOBJECT.csv' WITH VALIDATION
I have a rule for MYOBJECT
If EXISTS MYOBJECT WHERE (MYOBJECT.Code=ThisMYOBJECT.Code AND MYOBJECT.ID<>ThisMYOBJECT.ID) Then
REPORT ERROR 'MYOBJECT with this code already exists; Please choose a different code'

I run the process once and the attributes for BO is created with the values specified in the csv file. If i run the process again, the same attribute values are again genetated for the BO without throwing the error. If i manually create the instance of the BO giving same values the error is thrown...

bartthefish

I had a similar problem with a rule

If EXISTS MYOBJECT WHERE (MYOBJECT.Code=ThisMYOBJECT.Code AND MYOBJECT.ID<>ThisMYOBJECT.ID) Then
REPORT ERROR 'MYOBJECT with this code already exists; Please choose a different code'

The solution i found is a very strange one.

I Deleted the uniqueness rule and recreated it but this time by making the ID first

If EXISTS MYOBJECT WHERE (MYOBJECT.ID<>ThisMYOBJECT.ID AND MYOBJECT.Code=ThisMYOBJECT.Code) Then
REPORT ERROR 'MYOBJECT with this code already exists; Please choose a different code'

It worked.

Craig

Thanks Justin... i tried that.. made no difference..when i manually create the object the rule is fired. But when called by a process using IMPORT the rule does not fire..

tford

Have you looked at the logs?

Craig

Tomcat Logs -

When process is executed first time -
WebServlet URL got request with params:

Got XML request <root><start_process_action process_name="CreateSampleLookUps" ></start_process_action></root>

Calling BAS server

Server replied to the original request that some UI operation is required

Got XML request <root><continue_process_action process_id="4" ui_action_name="display_message" /></root>

Sending notification message to the server for process 4

Server replied back

Original request is successfully fulfilled
When process is executed the second time -
WebServlet URL got request with params:

Got XML request <root><start_process_action process_name="CreateSampleLookUps" ></start_process_action></root>

Calling BAS server

Server replied to the original request that some UI operation is required

Got XML request <root><continue_process_action process_id="167" ui_action_name="display_message" /></root>

Sending notification message to the server for process 167

Server replied back

Original request is successfully fulfilled

WebServlet URL got request with params:

Got XML request <root><start_process_action process_name="CreateInvestor" ></start_process_action></root>

Calling BAS server

Server replied to the original request that some UI operation is required

WebServlet URL got request with params: