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.