Validation Import (OID) in DELTA

[asurarangsan]

Hi Anyone,

I would like to change the Definition to "CT_VALIDATION_RULE_DATA_DELTA", by the purpose to update one of all TYPE, by schedule SFTP import.  In the first column is "ACTION_TYPE".

Do anyone know how the possible values for this field?

For the action:

New

Modify

Remove

Thank you,

Arthasit S.

[KevinD]

@asurarangsan can you provide a screenshot of where you are seeing this?

[asurarangsan]

Hi Kevin,

Here is steps;

1. Go to Administration -> Company -> Toos -> Import/Extract Administrator

2, Select tab "Import" and choose "EXTERNAL_VALIDATION..." (OID). Then click Modify, and select "CT_VALIDATION_RULE_DATA_DELTA".

3. Save it

4. Click tab "Configure Import Definition" to see whether "CT_VALIDATION_RULE_DATA_DELTA" definition is.

5. here in XML. There is "ACTION_TYPE" prior "TYPE" .

Best regards,

[leedau · Accepted solution]

@asurarangsan Thanks for providing the screenshot. Here is the value list for column 1 - Action Type.

'"I" - Insert the record
"U" - Update an existing record (record selection is based off of the key fields
"P" - Insert / Update (Put): inserts if not existing otherwise updates existing row
"D" – Delete

Is this what you were looking for?

Remember to tag me if your respond or feel free to mark this post as Solved if you don't have further questions or comments.  To tag me on your response, you click the  Reply button, first thing to type is @. This should bring up the username of the person you are replying to. 

[asurarangsan]

Hi @leedau , 

Yes, that is what I am looking for. Thank you very much.

Best regards,

[jpotts]

Hi Arthasit,

How were you able to setup this import job to be SFTP?