1. Home
  2. Point-Of-Sale Software
  3. WHY: duplicated entries in suppliers table after using QSimport

WHY: duplicated entries in suppliers table after using QSimport

hello

after using QSimport to populate the items table, i've noticed that there are a lot of duplicate entries being created in the supplier table. There are

254 only distinct supplier names, but there are 654 suppliers total. When you look at the suppliers which are present more than once, you notice (i am 99% sure) that all of the ones that get duplicated are had to be truncated to 30 characters, the max data length for that field. i checked and they are not being duplicated because they are misspelled or even because of trailing spaces in the supplier name

1) would it be harmful to increase the data length to 50?

2) why is this happening?

Thanks, Eddie B

Reply to
Eddie B
Loading thread data ...

Are you using the truncated value in your import spreadsheet? You need to use the exact value of the supplier description field as it appears in SO Manager. If this is a truncated version of the supplier then that is what you should use.

For the data you are importing, I suggest that you find out the database field formats and sizes, and validate your data prior to importing. It will save you time in the long run if using QSC.

Also-Try retail realms import facility. It's a much more user friendly, robust import tool.It it actually has some > hello

Reply to
Jamie-CR

Jamie

I've actually sent them an email a week ago and got no response. I just sent them another one.

Thanks, Eddie B

"Jamie-CR" wrote:

Reply to
Eddie B

i found the solution to the problem. in a nutshell, the txt file's supplier name column can only have 30 characters max.

thanks Eddie B

"Eddie B" wrote:

Reply to
Eddie B

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.