• State Not Answered
  • Replies 2 replies
  • Subscribers 98 subscribers
  • Views 57 views
  • Users 0 members are here
Options
Related

How to distinguish records entered by Data Import

Giorgia

Hi everyone, I would like to know if there is a way to identify records loaded into a table through Data Import.

I need this information because I want a certain process on the UNSAccountBInUNSGroupB table not to run if the data is inserted using the Data Import tool. I noticed that the rows inserted via Data Importer have XUserUpdated as QBM_PMNTableOriginUpdate, but I am not sure if this is sufficient to distinguish them.

Can anyone help me?
Thank you very much

Parents
  • 0

    Thought about using connection variables with Importer and having processes/templates ignore if that is set?

  • 0 in reply to Ben

    Hi Ben, thanks for the suggestion. I tried setting the connection variable and inserting it into the process in addition to my generating condition, but it doesn't seem to read it: if I try to simulate the desired behavior on the Designer tool, it works correctly, but when I run the data import, the process starts. The only other solution I can think of is to create a custom field in the table of interest, set this flag to true in the CSV, and put in the process's generating condition that, if the flag is set to true, the process does not start... this actually works, although it doesn't seem like the cleanest solution to me. If you know how to use that connection variable within the process, I would appreciate your help!

Reply
  • 0 in reply to Ben

    Hi Ben, thanks for the suggestion. I tried setting the connection variable and inserting it into the process in addition to my generating condition, but it doesn't seem to read it: if I try to simulate the desired behavior on the Designer tool, it works correctly, but when I run the data import, the process starts. The only other solution I can think of is to create a custom field in the table of interest, set this flag to true in the CSV, and put in the process's generating condition that, if the flag is set to true, the process does not start... this actually works, although it doesn't seem like the cleanest solution to me. If you know how to use that connection variable within the process, I would appreciate your help!

Children
No Data