Item IDs errors

[Droshi]

I have imported all my data from Excel by generating the XML tags for each item and adding it through the import feature under Web Tools. Occasionally I have the problem when adding new things to some lists through the normal web interface (not via importing XML tags). The message explains that adding something with that Item ID already exists, so I believe because I imported many things through XML and did not put them in manually that some variables of the last Item ID are not updated.

Is there a universal file these are stored in? I would ideally like to clean up these numbers so that items can be added through the web interface as normal rather than having to generate an XML tag to import.

Any help is much appreciated.

[hans_bakker]

have a look at the SequenceValueItem entity where the highest number is
stored. You can avoid this problem by importing Id's with a prefix like
ixxxxxx. then you also know later which records were imported and which
were entered manually,

hope this helps,

Regards.

On Sat, 2009-01-17 at 23:33 -0800, Droshi wrote:

> I have imported all my data from Excel by generating the XML tags for each
> item and adding it through the import feature under Web Tools. Occasionally
> I have the problem when adding new things to some lists through the normal
> web interface (not via importing XML tags). The message explains that adding
> something with that Item ID already exists, so I believe because I imported
> many things through XML and did not put them in manually that some variables
> of the last Item ID are not updated.
>
> Is there a universal file these are stored in? I would ideally like to clean
> up these numbers so that items can be added through the web interface as
> normal rather than having to generate an XML tag to import.
>
> Any help is much appreciated.

--
Antwebsystems.com: Quality OFBiz services for competitive prices

[BJ Freeman]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

if this is static one time data then you method is the best.
if this is re-occurring then i suggest using POI and import the excel
and call the services to put in the data.


Droshi sent the following on 1/17/2009 11:33 PM:

> I have imported all my data from Excel by generating the XML tags for each
> item and adding it through the import feature under Web Tools. Occasionally
> I have the problem when adding new things to some lists through the normal
> web interface (not via importing XML tags). The message explains that adding
> something with that Item ID already exists, so I believe because I imported
> many things through XML and did not put them in manually that some variables
> of the last Item ID are not updated.
>
> Is there a universal file these are stored in? I would ideally like to clean
> up these numbers so that items can be added through the web interface as
> normal rather than having to generate an XML tag to import.
>
> Any help is much appreciated.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJcvcLrP3NbaWWqE4RAlC3AJ9oztop9z07kcJ4Nzq6O4+c96SEowCgsq+I
QEr7Al+qUmQCyjp3fHp+EJ0=
=TLCY
-----END PGP SIGNATURE-----

[Droshi]

Much thanks to both of you, my importing was one-time only, but if I have to revert to a backup in the future I may clean up the numbers by using the "ixxxxx" trick.

Thanks again.

hansbak wrote

have a look at the SequenceValueItem entity where the highest number is
stored. You can avoid this problem by importing Id's with a prefix like
ixxxxxx. then you also know later which records were imported and which
were entered manually,

hope this helps,

Regards.

On Sat, 2009-01-17 at 23:33 -0800, Droshi wrote:
> I have imported all my data from Excel by generating the XML tags for each
> item and adding it through the import feature under Web Tools. Occasionally
> I have the problem when adding new things to some lists through the normal
> web interface (not via importing XML tags). The message explains that adding
> something with that Item ID already exists, so I believe because I imported
> many things through XML and did not put them in manually that some variables
> of the last Item ID are not updated.
>
> Is there a universal file these are stored in? I would ideally like to clean
> up these numbers so that items can be added through the web interface as
> normal rather than having to generate an XML tag to import.
>
> Any help is much appreciated.
--
Antwebsystems.com: Quality OFBiz services for competitive prices