Importing as an update

PHPMaker General Discussion (PHPMaker)
1

H there!
Is it possible to import just extra info to records instead of creating new ones?
For example:

  • I have several records
  • Wanted to add to multiple of them, different info for each one in “notes” field that I received in a spreadsheet

I tried importing with Primary key filled, the rest of the fields empty plus the new info on “notes” field but I got this error message, which made sense to me, since this is an auto-increment field:
"Imported 1 of 1 records from Companhias.xls (success: 0, failure: 1)
row 1: Failed to execute SQL. Error: SQLState: 23000 Error Code: 544 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot insert explicit value for identity column in table ‘Companhias’ when IDENTITY_INSERT is set to OFF. (544)"Is there a workaround?
Thanks in advance

2

Uncheck Tools → Advanced Settings → Import records by insert only, so that update is allowed.

3

Thank you!

4

It would be great if one could choose the type of import on the frontside… :slight_smile:
For me, I sometimes need it to add + update and others just the add, for different tables/times.