FrontAccounting forum — The entered information is a duplicate.

Re: The entered information is a duplicate.

null@example.com (apmuthu) — Tue, 15 Aug 2017 10:47:12 +0000

Do a diagnostic check of all your tables and re-index them. Also set the auto increment value of each such table to 1 - it should then set the actual value by itself. Make sure your Chart of Accounts sql schema compares exactly with the sql/en_US-new.sql file.

Re: The entered information is a duplicate.

null@example.com (BarryHavenga) — Tue, 15 Aug 2017 08:27:44 +0000

Hello. I changed the Reference Lines but appending an "A" to each number and it still does not work.

Is there a way to force the auto increment ID update?

Re: The entered information is a duplicate.

null@example.com (kvvaradha) — Tue, 15 Aug 2017 02:09:40 +0000

It might not updated the auto increment ID or your reference may already exist, Try change the Reference lines and test it again.

Re: The entered information is a duplicate.

null@example.com (apmuthu) — Mon, 14 Aug 2017 14:54:03 +0000

Yes

Re: The entered information is a duplicate.

null@example.com (BarryHavenga) — Mon, 14 Aug 2017 08:53:19 +0000

We currently don't have a static IP to our domain. Could I use Dropbox or Google Drive?

Re: The entered information is a duplicate.

null@example.com (apmuthu) — Mon, 14 Aug 2017 08:44:16 +0000

Give the link like http://www.yourdomain.tld//Screenshot_csv_source.png

Re: The entered information is a duplicate.

null@example.com (BarryHavenga) — Mon, 14 Aug 2017 08:06:36 +0000

Hello

I could not paste directly to your window and when I paste the links in the reply window I suspect that the links will stay text and not resolve to the graphic.

/home/barry/Temp/Screenshot_csv_source.png
/home/barry/Temp/Screenshot_csv_source.png

Re: The entered information is a duplicate.

null@example.com (apmuthu) — Thu, 10 Aug 2017 17:21:44 +0000

Paste link here.

Re: The entered information is a duplicate.

null@example.com (BarryHavenga) — Thu, 10 Aug 2017 09:54:33 +0000

No this does not appear to be the case. How do I attach screenshots so I can show you the offending entry?file:///home/barry/Temp/Screenshot_FA_Import.png
file:///home/barry/Temp/Screenshot_csv_source.png
When I do it with cut and paste only the filename shows.

Re: The entered information is a duplicate.

null@example.com (apmuthu) — Wed, 09 Aug 2017 17:18:26 +0000

Does it have anything to do with hardcoded primary keys of any auto added primary key that starts with 1 each time?

The entered information is a duplicate.

null@example.com (BarryHavenga) — Wed, 09 Aug 2017 08:24:39 +0000

Hello. I have successfully imported several hundred transactions using the Import Transactions module.

When I tried to import transactions relating to a second account, I got an error message: "The entered information is a duplicate. Please go back and enter different values."

I have checked the import CSV file and the rows referred to in the error message appear correct. How do I resolve this please.

I can upload the relevant error message and the source .csv file entries if required.