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
Best answer by Marcel.Ausan
@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.
@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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
