Re: Extending id fields to more than 20 chars

[Tim Ruppert]

Some people like to use the product ID for SKUs - so you are not along in this request. here's you can do it easily:

in framework/entity/fieldtype/fieldtype*.xml files




That works like a charm if you choose to go this route.

Cheers,
Ruppert
--
Tim Ruppert
HotWax Media
http://www.hotwaxmedia.com

o:801.649.6594
f:801.649.6595

On Oct 16, 2009, at 2:40 PM, Ruth Hoffman wrote:

- <field-type-def type="id" sql-type="VARCHAR(20)" java- type="String"></field-type-def> + <field-type-def type="id" sql-type="VARCHAR(40)" java- type="String"></field-type-def>

Hi James:


Maybe someone who did the original data modeling could comment.

Regards,
Ruth

James McGill wrote:

I don't think the product id field was ever intended to be used interchangeably with such identifiers as SKUs. My understanding of the data model is that the product id is to uniquely identify the product within the OFBiz domain only. That is how I have always used it. When I needed to associate SKUs or other identifiers (for example I use ISBNs), I use the ID's tab within the Catalog Manager.

Product identifiers in our industry are commonly longer than 20 characters. id and id-ne fields are defined as 20 character fields for all the databases

I have looked at, and there seems to be some tight binding to the 20

but that would be much less convenient for the users.

Please advise.

character length in forms and screen templates. We are wondering how much work we would need to do, in order to change Product id's to id- longs. That sounds pretty big at first glance, since there is so much going on with Product in so many applications. Another option would be to standardize some kind of SKU and cross reference that to a domain-specific product ID

smime.p7s
Description: S/MIME cryptographic signature