ofbiz inventory ID format
Locked
ofbiz inventory ID format
 
|
Hi,
Is there anyway to control the format of the inventory item ID in ofbiz? right now all inventory items start at 10000 or so. is there a way to add a prefix or a suffix to the automatically generated item ID? thanks Adarsh |
Re: ofbiz inventory ID format
Administrator
|
Hi Adarsh,
AFAIK there is no prefix attribute for sequenceId in OFBiz (yet?) or any automatice way to deal with it but you may have a look at http://tinyurl.com/2j8l64, http://tinyurl.com/37n7xk and http://tinyurl.com/2uw8b9 You may also have a look at framework/entity/entitydef/entitymodel.xml Core developpers, please correct me if I'm wrong, thanks. Jacques De : "Adarsh Holavanahalli" <[hidden email]> > Hi, > > Is there anyway to control the format of the inventory item ID in ofbiz? > right now all inventory items start at 10000 or so. is there a way to add a > prefix or a suffix to the automatically generated item ID? > > thanks > Adarsh > |
|
|
In reply to this post by Adarsh Holavanahalli
just a short note, if you import the product ID thru the webtools.
you can have any product ID you want. then do the rest manually if you want. Adarsh Holavanahalli sent the following on 5/20/2007 9:50 PM: > Hi, > > Is there anyway to control the format of the inventory item ID in ofbiz? > right now all inventory items start at 10000 or so. is there a way to add a > prefix or a suffix to the automatically generated item ID? > > thanks > Adarsh > |
Re: ofbiz inventory ID format
|
|
In reply to this post by Adarsh Holavanahalli
Thanks for the responses. Importing the product IDs is a painful thing to
teach the normal user. but i guess it will have to do for now. it would have been nice if we could have setup the inventory ID prefixes as part of the setup file. imagine that this one step will allow barcoded manufacturing stickers to be preprinted (for different components) and serialized inventories to suddenly be more meaningful. hope this gets into the wish list of future ofbiz releases Adarsh -----Original Message----- From: BJ Freeman [mailto:[hidden email]] Sent: Tuesday, May 22, 2007 3:05 AM To: [hidden email] Subject: Re: ofbiz inventory ID format just a short note, if you import the product ID thru the webtools. you can have any product ID you want. then do the rest manually if you want. Adarsh Holavanahalli sent the following on 5/20/2007 9:50 PM: > Hi, > > Is there anyway to control the format of the inventory item ID in ofbiz? > right now all inventory items start at 10000 or so. is there a way to add a > prefix or a suffix to the automatically generated item ID? > > thanks > Adarsh > |
|
|
Your additional use cases bring up the problem with coding information
in your product Id. Manufacturer Id, serialized inventory, prefixed product Ids are all aliases. It is generally best for the productId as the primary key to only have meaning to the database and not to the users. This has been brought up and discussed in more detail throughout the ML so I won't rehash it here. But be warned to consider a more comprehensive approach to naming conventions. --- Adarsh Holavanahalli <[hidden email]> wrote: > Thanks for the responses. Importing the product IDs is a painful > thing to > teach the normal user. but i guess it will have to do for now. it > would have > been nice if we could have setup the inventory ID prefixes as part of > the > setup file. imagine that this one step will allow barcoded > manufacturing > stickers to be preprinted (for different components) and serialized > inventories to suddenly be more meaningful. > > hope this gets into the wish list of future ofbiz releases > Adarsh > -----Original Message----- > From: BJ Freeman [mailto:[hidden email]] > Sent: Tuesday, May 22, 2007 3:05 AM > To: [hidden email] > Subject: Re: ofbiz inventory ID format > > > > just a short note, if you import the product ID thru the webtools. > > you can have any product ID you want. > > then do the rest manually if you want. > > > > Adarsh Holavanahalli sent the following on 5/20/2007 9:50 PM: > > > Hi, > > > > > > Is there anyway to control the format of the inventory item ID in > ofbiz? > > > right now all inventory items start at 10000 or so. is there a way > to add > a > > > prefix or a suffix to the automatically generated item ID? > > > > > > thanks > > > Adarsh > > > > |
|
|
Chris is right. Use an additional field like "itemId" or "serialNumber" or similar.
Read the Data Model book about productId in entity Product. Jonathon Chris Howe wrote: > Your additional use cases bring up the problem with coding information > in your product Id. Manufacturer Id, serialized inventory, prefixed > product Ids are all aliases. It is generally best for the productId as > the primary key to only have meaning to the database and not to the > users. This has been brought up and discussed in more detail > throughout the ML so I won't rehash it here. But be warned to consider > a more comprehensive approach to naming conventions. > > --- Adarsh Holavanahalli <[hidden email]> wrote: > >> Thanks for the responses. Importing the product IDs is a painful >> thing to >> teach the normal user. but i guess it will have to do for now. it >> would have >> been nice if we could have setup the inventory ID prefixes as part of >> the >> setup file. imagine that this one step will allow barcoded >> manufacturing >> stickers to be preprinted (for different components) and serialized >> inventories to suddenly be more meaningful. >> >> hope this gets into the wish list of future ofbiz releases >> Adarsh >> -----Original Message----- >> From: BJ Freeman [mailto:[hidden email]] >> Sent: Tuesday, May 22, 2007 3:05 AM >> To: [hidden email] >> Subject: Re: ofbiz inventory ID format >> >> >> >> just a short note, if you import the product ID thru the webtools. >> >> you can have any product ID you want. >> >> then do the rest manually if you want. >> >> >> >> Adarsh Holavanahalli sent the following on 5/20/2007 9:50 PM: >> >>> Hi, >>> Is there anyway to control the format of the inventory item ID in >> ofbiz? >> >>> right now all inventory items start at 10000 or so. is there a way >> to add >> a >> >>> prefix or a suffix to the automatically generated item ID? >>> thanks >>> Adarsh > > |
Re: ofbiz inventory ID format
|
|
In reply to this post by Adarsh Holavanahalli
Hi guys,
what you are saying makes perfect sense from the database perspective. the only problem i found was that the inventory item was not searchable using the alias fields. is this correct or does the manufacturing module have the ability to pull up the inventory item based on the serial number or manufacturing ID alias? thanks Adarsh -----Original Message----- From: Jonathon -- Improov [mailto:[hidden email]] Sent: Tuesday, May 22, 2007 11:24 AM To: [hidden email] Subject: Re: ofbiz inventory ID format Chris is right. Use an additional field like "itemId" or "serialNumber" or similar. Read the Data Model book about productId in entity Product. Jonathon Chris Howe wrote: > Your additional use cases bring up the problem with coding information > in your product Id. Manufacturer Id, serialized inventory, prefixed > product Ids are all aliases. It is generally best for the productId as > the primary key to only have meaning to the database and not to the > users. This has been brought up and discussed in more detail > throughout the ML so I won't rehash it here. But be warned to consider > a more comprehensive approach to naming conventions. > > --- Adarsh Holavanahalli <[hidden email]> wrote: > >> Thanks for the responses. Importing the product IDs is a painful >> thing to >> teach the normal user. but i guess it will have to do for now. it >> would have >> been nice if we could have setup the inventory ID prefixes as part of >> the >> setup file. imagine that this one step will allow barcoded >> manufacturing >> stickers to be preprinted (for different components) and serialized >> inventories to suddenly be more meaningful. >> >> hope this gets into the wish list of future ofbiz releases >> Adarsh >> -----Original Message----- >> From: BJ Freeman [mailto:[hidden email]] >> Sent: Tuesday, May 22, 2007 3:05 AM >> To: [hidden email] >> Subject: Re: ofbiz inventory ID format >> >> >> >> just a short note, if you import the product ID thru the webtools. >> >> you can have any product ID you want. >> >> then do the rest manually if you want. >> >> >> >> Adarsh Holavanahalli sent the following on 5/20/2007 9:50 PM: >> >>> Hi, >>> Is there anyway to control the format of the inventory item ID in >> ofbiz? >> >>> right now all inventory items start at 10000 or so. is there a way >> to add >> a >> >>> prefix or a suffix to the automatically generated item ID? >>> thanks >>> Adarsh > > |
|
|
Do you mean, "not searchable" as in there's no search screen to search by InventoryItem fields?
One easy way is to create a view entity, which can be searchable by all the fields it pulls together. Jonathon Adarsh Holavanahalli wrote: > Hi guys, > > what you are saying makes perfect sense from the database perspective. the > only problem i found was that the inventory item was not searchable using > the alias fields. is this correct or does the manufacturing module have the > ability to pull up the inventory item based on the serial number or > manufacturing ID alias? > thanks > Adarsh > > -----Original Message----- > From: Jonathon -- Improov [mailto:[hidden email]] > Sent: Tuesday, May 22, 2007 11:24 AM > To: [hidden email] > Subject: Re: ofbiz inventory ID format > > > > Chris is right. Use an additional field like "itemId" or "serialNumber" or > similar. > > > > Read the Data Model book about productId in entity Product. > > > > Jonathon > > > > Chris Howe wrote: > >> Your additional use cases bring up the problem with coding information > >> in your product Id. Manufacturer Id, serialized inventory, prefixed > >> product Ids are all aliases. It is generally best for the productId as > >> the primary key to only have meaning to the database and not to the > >> users. This has been brought up and discussed in more detail > >> throughout the ML so I won't rehash it here. But be warned to consider > >> a more comprehensive approach to naming conventions. > >> > >> --- Adarsh Holavanahalli <[hidden email]> wrote: > >> > >>> Thanks for the responses. Importing the product IDs is a painful > >>> thing to > >>> teach the normal user. but i guess it will have to do for now. it > >>> would have > >>> been nice if we could have setup the inventory ID prefixes as part of > >>> the > >>> setup file. imagine that this one step will allow barcoded > >>> manufacturing > >>> stickers to be preprinted (for different components) and serialized > >>> inventories to suddenly be more meaningful. > >>> > >>> hope this gets into the wish list of future ofbiz releases > >>> Adarsh > >>> -----Original Message----- > >>> From: BJ Freeman [mailto:[hidden email]] > >>> Sent: Tuesday, May 22, 2007 3:05 AM > >>> To: [hidden email] > >>> Subject: Re: ofbiz inventory ID format > >>> > >>> > >>> > >>> just a short note, if you import the product ID thru the webtools. > >>> > >>> you can have any product ID you want. > >>> > >>> then do the rest manually if you want. > >>> > >>> > >>> > >>> Adarsh Holavanahalli sent the following on 5/20/2007 9:50 PM: > >>> > >>>> Hi, > >>>> Is there anyway to control the format of the inventory item ID in > >>> ofbiz? > >>> > >>>> right now all inventory items start at 10000 or so. is there a way > >>> to add > >>> a > >>> > >>>> prefix or a suffix to the automatically generated item ID? > >>>> thanks > >>>> Adarsh > >> > >> > > > ------------------------------------------------------------------------ > > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.5.467 / Virus Database: 269.7.6/813 - Release Date: 5/20/2007 7:54 AM |
Re: ofbiz inventory ID format
|
|
Hi Jonathon,
I did mean UI search screens. thanks Adarsh Jonathon -- Improov wrote: > Do you mean, "not searchable" as in there's no search screen to search > by InventoryItem fields? > > One easy way is to create a view entity, which can be searchable by > all the fields it pulls together. > > Jonathon > > Adarsh Holavanahalli wrote: >> Hi guys, >> >> what you are saying makes perfect sense from the database >> perspective. the >> only problem i found was that the inventory item was not searchable >> using >> the alias fields. is this correct or does the manufacturing module >> have the >> ability to pull up the inventory item based on the serial number or >> manufacturing ID alias? >> thanks >> Adarsh >> >> -----Original Message----- >> From: Jonathon -- Improov [mailto:[hidden email]] >> Sent: Tuesday, May 22, 2007 11:24 AM >> To: [hidden email] >> Subject: Re: ofbiz inventory ID format >> >> >> >> Chris is right. Use an additional field like "itemId" or >> "serialNumber" or >> similar. >> >> >> >> Read the Data Model book about productId in entity Product. >> >> >> >> Jonathon >> >> >> >> Chris Howe wrote: >> >>> Your additional use cases bring up the problem with coding information >> >>> in your product Id. Manufacturer Id, serialized inventory, prefixed >> >>> product Ids are all aliases. It is generally best for the productId as >> >>> the primary key to only have meaning to the database and not to the >> >>> users. This has been brought up and discussed in more detail >> >>> throughout the ML so I won't rehash it here. But be warned to consider >> >>> a more comprehensive approach to naming conventions. >> >>> >> >>> --- Adarsh Holavanahalli <[hidden email]> wrote: >> >>> >> >>>> Thanks for the responses. Importing the product IDs is a painful >> >>>> thing to >> >>>> teach the normal user. but i guess it will have to do for now. it >> >>>> would have >> >>>> been nice if we could have setup the inventory ID prefixes as part of >> >>>> the >> >>>> setup file. imagine that this one step will allow barcoded >> >>>> manufacturing >> >>>> stickers to be preprinted (for different components) and serialized >> >>>> inventories to suddenly be more meaningful. >> >>>> >> >>>> hope this gets into the wish list of future ofbiz releases >> >>>> Adarsh >> >>>> -----Original Message----- >> >>>> From: BJ Freeman [mailto:[hidden email]] >> >>>> Sent: Tuesday, May 22, 2007 3:05 AM >> >>>> To: [hidden email] >> >>>> Subject: Re: ofbiz inventory ID format >> >>>> >> >>>> >> >>>> >> >>>> just a short note, if you import the product ID thru the webtools. >> >>>> >> >>>> you can have any product ID you want. >> >>>> >> >>>> then do the rest manually if you want. >> >>>> >> >>>> >> >>>> >> >>>> Adarsh Holavanahalli sent the following on 5/20/2007 9:50 PM: >> >>>> >> >>>>> Hi, >> >>>>> Is there anyway to control the format of the inventory item ID in >> >>>> ofbiz? >> >>>> >> >>>>> right now all inventory items start at 10000 or so. is there a way >> >>>> to add >> >>>> a >> >>>> >> >>>>> prefix or a suffix to the automatically generated item ID? >> >>>>> thanks >> >>>>> Adarsh >> >>> >> >>> >> >> >> ------------------------------------------------------------------------ >> >> No virus found in this incoming message. >> Checked by AVG Free Edition. Version: 7.5.467 / Virus Database: >> 269.7.6/813 - Release Date: 5/20/2007 7:54 AM > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |