Duplicate values in data export #987

New Issue

Closed

opened 2023-04-01 15:43:59 +00:00 by infotecnica · 3 comments

infotecnica commented

2023-04-01 15:43:59 +00:00

Steps to reproduce the issue:

I have an excel table with data to import into my application
I obtained this table by exporting the first record and then manually adding the rest

Expected result

No error

Actual result

Instead I get duplicate value error if I have two values which contain a common part, for example if I have these values 8E22445 and 8E22445D

System information (as much as possible)

OS Name & Version:
MySql Version: 5.5.5-10.3.38-MariaDB-0ubuntu0.20.04.1
Apache Version:
PHP Version: 7.4.33
Joomla Version: 3.10.11
JCB Version: 2.13.0
Browser: Firefox

Additional comments

from verification carried out in the joomla backend and directly in the database there are no duplicate values for the table that gives an error

### Steps to reproduce the issue: I have an excel table with data to import into my application I obtained this table by exporting the first record and then manually adding the rest ### Expected result No error ### Actual result Instead I get duplicate value error if I have two values which contain a common part, for example if I have these values 8E22445 and 8E22445D ### System information (as much as possible) - OS Name & Version: - MySql Version: 5.5.5-10.3.38-MariaDB-0ubuntu0.20.04.1 - Apache Version: - PHP Version: 7.4.33 - Joomla Version: 3.10.11 - JCB Version: 2.13.0 - Browser: Firefox ### Additional comments from verification carried out in the joomla backend and directly in the database there are no duplicate values for the table that gives an error

Llewellyn commented

2023-04-01 19:37:53 +00:00

Owner

Lets be honest here, I have developed many extensions with JCB and thought I am not having any issues, I am also spending a great deal of time balancing the extension, which requires I great deal of debugging and reading over the code. No one using JCB can get away without this kind of screening as JCB is not yet able to prevent you from doing the wrong thing in many ways. So while this is why I really like JCB since it affords me the freedom I want, it is also more complicated and often require a good understanding of PHP to get things to work.

Well having said all that, it still does not explain why you have this issue, I have never had this, and believe me I work with very complex and larg projects in JCB where every view has not only export and import capabilities, but also permissional layers.

So trying to debug this yourself, and then sharing your discovery will be the only way I can help you.

This is not enough information for me to know, or even be remotely able to duplicate. Due to the nature of JCB, the possibilities are infinite. Therefor for me to be able to help I need much more details, even code snippets from that area, screenshots of the error, the database columns, a dummy import set... even the extension at times. Lets be honest here, I have developed many extensions with JCB and thought I am not having any issues, I am also spending a great deal of time balancing the extension, which requires I great deal of debugging and reading over the code. No one using JCB can get away without this kind of screening as JCB is not yet able to prevent you from doing the wrong thing in many ways. So while this is why I really like JCB since it affords me the freedom I want, it is also more complicated and often require a good understanding of PHP to get things to work. Well having said all that, it still does not explain why you have this issue, I have never had this, and believe me I work with very complex and larg projects in JCB where every view has not only export and import capabilities, but also permissional layers. So trying to debug this yourself, and then sharing your discovery will be the only way I can help you.

infotecnica commented

2023-04-02 06:26:47 +00:00

Author

In the meantime, thank you for your prompt reply.

I certainly don't want to take away your precious time for the great work you are doing.

I was just trying to figure out if my problem had happened to someone else. The strange thing is that by inserting the record manually, as a new record, it doesn't report any duplicate value errors and I certainly didn't insert a single value for the table field.

I will try to understand independently where the cause is and I will share the solution. Thank you and sorry my english translated by google translate.

In the meantime, thank you for your prompt reply. I certainly don't want to take away your precious time for the great work you are doing. I was just trying to figure out if my problem had happened to someone else. The strange thing is that by inserting the record manually, as a new record, it doesn't report any duplicate value errors and I certainly didn't insert a single value for the table field. I will try to understand independently where the cause is and I will share the solution. Thank you and sorry my english translated by google translate.

infotecnica closed this issue

2023-04-02 06:26:47 +00:00

Llewellyn commented

2023-04-02 20:34:06 +00:00

Owner

@infotecnica no issue can really waste my time, my apology if it sounded that way to you. I am really here for you! and helping you helps many other who may also run into this issue, as this is a public forum.

Please use this forum for core JCB issues, as fixing it for you fixes it for us all!