Skip to main content

Our customer uses excel-addin for creating and updating parts. We are trying to figure out what flags creates new records and what flags updates existing record from the excel. Is there a simple explanation? For example I get that is you create a new Part no there is a new record and of you add a new site to an existing Part no it will create a new record. 

So basically, are all P and K flags creating new records or is it all M flags as well? 

 

Hope you understand my question :)

 

Best Regards

Emma

@emmanilsson in each Mig Job definition you can control if you allow inserts or only updates. This is done via below fields in Method List tab.

So, if both inserts and updates are allowed for any given Mig Job, then the system will:

  • search for existing record to be updated - search by P and K
  • if no record was found then it will try to insert a new row with all the data from the excel row. If any M field doesn’t have a value during the insert, the insert will fail as one of the mandatory fields doesn’t have a value.

 

 

Thanks Marcel, that was exactly the answer I needed! 

 

Best Regards

Emma

Reply


Terms & ConditionsCookie settings