Duplicate entry '1' for key 'uk_societe_code_clien

Using my Dolibarr
1

Dear All,

I face this problem while uploading data in third party (company info),kindly advice me as once i upload i get duplication issues

* Line 2
> Duplicate entry ‘1’ for key ‘uk_societe_code_client’
* Line 3
> Duplicate entry ‘1’ for key ‘uk_societe_code_client’
* Line 4
> Duplicate entry ‘1’ for key ‘uk_societe_code_client’
* Line 5
> Duplicate entry ‘1’ for key ‘uk_societe_code_client’
* Line 6
> Duplicate entry ‘1’ for key ‘uk_societe_code_client’
* Line 7
> Duplicate entry ‘1’ for key ‘uk_societe_code_client’
* Line 8
> Duplicate entry ‘1’ for key ‘uk_societe_code_client’
* Line 9
> Duplicate entry ‘1’ for key ‘uk_societe_code_client’

2

Hi,

“s.code_client” should not be the same in first line and the others.
It seems that you defined “s.code_client” in all lines as “1”.

3

thanks a lot for the information , but i failed to see that s.code_client is it in th kindly database or the import format kindly tell me where i can edit it so that i can finish this.it has been days with such a problem

thanks

4

It is in the fifth cell of the import format - Customer code (s.code_client).

5

thanks but i have given different codes 0E to 144E etc

i dont think i put same number check the attached doc which i failed to import it in my system,

6

Be sure that comma (,) is just there when needed in import file.

7

which coma ? I still face same problems
* Line 2
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
> Wrong value for field number 31 (value ‘3/27/2013’ does not match regex rule ^[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]$)
* Line 3
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 4
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 5
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 6
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 7
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 8
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 9
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 10
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 11
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 12
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 13
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 14
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 15
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 16
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 17
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 18
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 19
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 20
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 21
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 22
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 23
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 24
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 25
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 26
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 27
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 28
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 29
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 30
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 31
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 32
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 33
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 34
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 35
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 36
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 37
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 38
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 39
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 40
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 41
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 42
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 43
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 44
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 45
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 46
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 47
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 48
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 49
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 50
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
* Line 51
> Mandatory data is empty in source file for field 3.
> Mandatory data is empty in source file for field 4.
> Wrong value for field number 24 (value ‘’ is not a value available into field code of table Company types)
There is still 298 other source lines with errors but output has been limited.

8

Date should be written like this: 2013-27-03 and in the import document there should be no "
Delimiter between columns should be comma.

Any luck?

9

already try, all above,
but the solution it seem to empty the field 5,
it works for me
:cheer: :cheer:

10

I also have this issue. Unable to import field with existing company code. Can import OK without code which is field 5. Its a real nuisance.