Import CSV in single trx doesnt consider the value of column in current transaction being key column
Description
Import CSV file to user window having email field as KT
It create 2 records instead of one
Issue is below line in GridTabCSVImporter.java checks the records in the table if exists for key columns to merge
However below method in GridTable.java#Loader doesnt use the trx while query to get count of records with whereclause for key column
I tried doing below however it gave me timeout loading row 1 exception,
Environment
None
Attachments
1
Activity
Thomas Bayen
May 9, 2020 at 7:04 PM
I reviewd that at iDempiere Triage Day.
In my opinion this ticket is based on a misunderstanding. You try to change the content of a column that you use as a key column. That sounds not as a good idea. As I understand your case it would just help to not define the email column as /K. Possibly it may be needed to add another column to identify the record you want to change if the name is not enough. I ywould consider using the ID in this case. When I am right with this interpretation this issue is more a wrong usage than a bug. I will close it - feel free to reopen and comment if I am wrong.
Major
Import CSV file to user window having email field as KT
It create 2 records instead of one
Issue is
below line in GridTabCSVImporter.java checks the records in the table if exists for key columns to merge
However below method in GridTable.java#Loader doesnt use the trx while query to get count of records with whereclause for key column
I tried doing below however it gave me timeout loading row 1 exception,