You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Droshi <an...@gmail.com> on 2009/01/18 08:33:28 UTC
Item IDs errors
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.
--
View this message in context: http://www.nabble.com/Item-IDs-errors-tp21524993p21524993.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Item IDs errors
Posted by Droshi <an...@gmail.com>.
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
>
>
>
--
View this message in context: http://www.nabble.com/Item-IDs-errors-tp21524993p21528455.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Item IDs errors
Posted by Hans Bakker <ma...@antwebsystems.com>.
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
Re: Item IDs errors
Posted by BJ Freeman <bj...@free-man.net>.
-----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-----