Tools ->Import-> Update Third-party data fails - no updates performed, in spite of success message

Developing for Dolibarr
,
1

I’ve used the Tools->Import wizard successfully to import a large amount of Third Parties.
After a while I wanted to update these same entries with additional information.
When I select " Key (column) to use for updating existing data" → Third-party name or Customer Code, and run the import - i get the success message e.g. :

Number of lines successfully imported: 1.
Number of inserted lines: 0
Number of updated lines: 1

However, when i check the third party in the UI - nothing has changed. The entry wasn’t updated.

They I checked manually the SQL logs to see what is printed regarding the UPDATE query that runs internally, and i see the following:

2025-02-19 19:28:17.328885 | UPDATE llx_societe SET nom = ‘a13’, name_alias = ‘boze bre’, fk_user_creat = 2, import_key = ‘20250219192817’ WHERE fk_user_creat = 47 AND entity IN (1)

I’ve found out through manual query executions in the database that the issue is this “fk_user_creat = 47” user - this user doesn’t exist in my database, yet for some reason the query insists on using “47” instead of “2” - my existing user.
This is the reason the Update fails.

Is there any developer here that can tell me which file needs to be edited and where in order to overwrite this “fk_user_creat = 47” with current user id?
I’ve checked this link dolibarr/htdocs/imports/import.php at develop · Dolibarr/dolibarr · GitHub

I guess this is the place for editing it, but I’m not sure.

Any assistance here will be appreciated. I’ve seen other people struggle with updating values for their imports (not just third paties, but also products, etc) - perhaps it’s related and could be beneficial for more people if we figure it out.

2

which dolibarr version? and does 47 show up anywhere in your input data?

3

Dolibarr v. 20.0.3
Database: MySQL or MariaDB 5.7.44
Operating System: Linux (system built on docker)
PHP version: 8.2.27

And to answer your question - no, 47 doesn’t show up anywhere, I have only 8 users in the system, so my highest fk_user value is 8.

It’s funny that the system actually detects the correct fk_user performing the update in the first part of the query, but at the second part it states WHERE fk_user 47

2025-02-19 19:28:17.328885 | UPDATE llx_societe SET nom = ‘a13’, name_alias = ‘boze bre’, fk_user_creat = 2, import_key = ‘20250219192817’ WHERE fk_user_creat = 47 AND entity IN (1)

I’m not sure what you mean by "input data’ - Do you mean the excel template for importing the data? I’m using the default one provided by the platform, and it lacks any fields when I can specify the user. Is there perhaps a hidden logic which will recognize fk_user_creat - so that I can add one more column for fk_user_creat and state user id “2” ?