How to Update Data during Import

Hi all,
Sorry, my English is not perfect.
I 'm looking for the solution to Update data if existing during the import from a CSV File (For activities).
In my CSV import file, i have not (And can not have) the Activity << Id >> generetad by ProjeQtor
I tried using the << Reference >>, always the same for every << Id >>, but ProjeQtor makes no Update, Only Insert with new << Id >>
Do you have an idea ?
Thank's a lot. 

Hello

We have the same problem but showing Error at import. (import of empty projects with .csv)
Before with versions 8.x.x it was shown what was imported and what was updated.
Now (with V9.0.1) it shows the screen if it cannot import (required columns/values have been missing), but as soon the table is "OK" to import, we waited for arround 10 min (where it seams to create the aprox 660 projects) and the spinning circle was displayed, but at the same time an error was shown instead of the list with all the changes. So after that time we thaught something went wrong and we tried again. (Result is now we have multiple times the same project...)

After that login took ages (maybe lack of RAM...)

We importet the columsnametypeproject codeorganizationstatusmanager
name, type, project code and status have been filled for every project.
sometimes there was a line gap inbetween (;;


Then if we click on "show this log file" in the administration page (Log files maintenance) some of the files are not shown (no text, just small empty box).

We found out that these files start with line
2020-12-30 12:42:10.884 ***** ERROR ***** [V8.6.6] Exception-[22007] SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF6llin' for column `projeqtordb`.`resource`.`fullName` at row 1

or

2021-01-14 11:57:37.799 ***** ERROR ***** [V9.0.1] Exception-[22007] SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF6llin' for column `projeqtordb`.`resource`.`fullName` at row 1


If the first line is a traceas or as follows, then it is displayed
2021-01-26 10:11:49.115 ***** ERROR ***** [V9.0.1] ERROR *****


Back to the topic of import...
The Log doesn't show any complication or error on import...
(Some error in login which seams to come if there was wrong password or username).
It is as follows


2021-01-26 10:11:49.115 ***** ERROR ***** [V9.0.1] ERROR *****
2021-01-26 10:11:49.115 ***** ERROR ***** [V9.0.1] on file '/var/www/html/projeqtor/model/UserMain.php' at line (1360)
2021-01-26 10:11:49.115 ***** ERROR ***** [V9.0.1] cause = ldap_bind(): Unable to bind to server: Invalid credentials
2021-01-26 10:11:49.116 ===== TRACE ===== Login error for user 'xxxxxxxx'
2021-01-26 10:11:57.886 ===== TRACE ===== NEW CONNECTED USER 'xxxxxxxx'
2021-01-26 10:47:51.489 ===== TRACE ===== NEW CONNECTED USER 'xxxxxxxx'
2021-01-26 11:46:09.754 ===== TRACE ===== DISCONNECTED USER 'xxxxxxxx'
2021-01-26 14:19:12.861 ===== TRACE ===== NEW CONNECTED USER 'xxxxxxxx'
2021-01-26 15:27:57.980 ===== TRACE ===== Importation : File type CSV
2021-01-26 15:27:57.980 ===== TRACE ===== File Name : ../files/attach//import/prepare_Project_import.csv
2021-01-26 16:46:07.874 ===== TRACE ===== Importation : File type CSV
2021-01-26 16:46:07.874 ===== TRACE ===== File Name : ../files/attach//import/prepare_Project_import.csv
2021-01-26 16:48:58.643 ===== TRACE ===== Importation : File type CSV
2021-01-26 16:48:58.643 ===== TRACE ===== File Name : ../files/attach//import/prepare_Project_import.csv
2021-01-26 16:52:48.729 ===== TRACE ===== Importation : File type CSV
2021-01-26 16:52:48.729 ===== TRACE ===== File Name : ../files/attach//import/prepare_Project_import.csv
2021-01-26 16:55:50.091 ===== TRACE ===== NEW CONNECTED USER 'xxxxxxxx'
2021-01-26 16:59:12.524 ===== TRACE ===== Importation : File type CSV
2021-01-26 16:59:12.524 ===== TRACE ===== File Name : ../files/attach//import/prepare_Project_import.csv
2021-01-26 17:00:33.026 ===== TRACE ===== DISCONNECTED USER 'xxxxxxxx'
2021-01-26 17:01:56.535 ===== TRACE ===== NEW CONNECTED USER 'xxxxxxxx'
2021-01-26 17:06:36.366 ===== TRACE ===== Importation : File type CSV
2021-01-26 17:06:36.366 ===== TRACE ===== File Name : ../files/attach//import/prepare_Project_import_2_closed.csv
2021-01-26 17:08:02.546 ===== TRACE ===== Importation : File type CSV
2021-01-26 17:08:02.546 ===== TRACE ===== File Name : ../files/attach//import/prepare_Project_import_2_closed.csv
2021-01-26 17:08:03.805 ===== TRACE ===== DISCONNECTED USER 'xxxxxxxx'
2021-01-26 17:08:03.863 ===== TRACE ===== DISCONNECTED USER 'xxxxxxxx'
2021-01-26 17:15:35.159 ===== TRACE ===== NEW CONNECTED USER 'xxxxxxxx'
2021-01-26 17:24:15.315 ===== TRACE ===== DISCONNECTED USER 'xxxxxxxx'
2021-01-26 17:24:25.197 ===== TRACE ===== NEW CONNECTED USER 'xxxxxxxx' (using remember me feature)
2021-01-26 18:10:51.492 ===== TRACE ===== NEW CONNECTED USER 'xxxxxxxx' (using remember me feature)
2021-01-26 18:16:06.238 ===== TRACE ===== DISCONNECTED USER 'xxxxxxxx'

Additional remark: the Key symbol seams to be upside down / rotated by 180° to me...

We would be very happy if it displays again what was imported/created.

Thank you

Problem of the Error if displaying the result solved by right management on our server.

The displaying of the error logs remains.

Hi

Thank you for the information about Apple.
But it was a problem of the server configuration (it displayed ngix error or something like that....)

But the problem with logs not showing if they start with Exception like the following line remains (also in V9.0.2).

2020-12-30 12:42:10.884 ***** ERROR ***** [V8.6.6] Exception-[22007] SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xF6llin' for column `projeqtordb`.`resource`.`fullName` at row 1