How to disable Product
Hi, I want to disable some product. I tried with putting past date in *supportDiscontinuationDate *and it was not working. Please let me know the process. Regards, Abhishake
synchronize SequenceValueItem entity for XML imports
Hi Friends, This is Kumaraswamy. I am using ofbiz for my e-commerce application. I like the option data seed through XML import which is provided in ofbiz. we are seeding the data for *InventoryItem* entity though XML import since eariler. By doing this, The sequence Numbers are not updating in * SequenceValueItem*. Now I am not able to create *InventoryItem* through events(either JAVA or mini-lang), its giving duplicate primary key error, because of the sequence numbers are already used. Of course, by doing max(sequenceId)+1 and store. That will be bad idea what I feel. Is there any alternate for this. May be an ECA to update *SequenceValueItem *entity with new seqId for every InventoryItem XML import. Generally, we do XML imports frequently for few entities. How to implement generic ECA which will update *SequenceValueItem *for every entity which uses sequenceId. Any code help will be appriciated. Thanks in Advance -- Thanks, Kumaraswamy.N
Re: Why primary keys are VAR_CHAR type in OFBiz?
Uggh That post mentions this: "What you *should* be thinking about is do you really want a varchar PK? Generally speaking, it's better to use a phantom PK (ie: a SERIAL), and put a UNIQUE constraint on the varchar in the appropriate table." IMO that is nothing short of horrible database design and complicates data models and applications significantly. There is lots of good literature showing a better way (ie natural keys), like Joe Celko who has been mentioned on this list a few times. Of course, as with any practice there are those for and against it. In absence of requirements and objectives to guide you, the only answer is it doesn't matter, you can go sit in the sun for all it matters because you haven't decided what you want to do. Once details are in place, then you can decide. -David On Feb 17, 2009, at 1:17 PM, Jacques Le Roux wrote: EnterpriseDB guys know what they are talking about (they are offering Postgres commercial support) http://markmail.org/message/7ykdxmvc7fvonx5q Jacques PS : OK, I'm a Postgres fan Jacques From: "BJ Freeman" -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 there was not statement on comparison, you are correct. have you done a test though to see what the real difference in msec is, on what you define as a large database. Sven Wesley sent the following on 2/17/2009 11:28 AM: Sorry guys, but I don't agree on the first point. An Integer or Number as primary will always win the time race compared to a varchar, specially if there's a group or order clause included. I do agree about the flexibility (that also comes with other complexities), but the performance issue is unfortunately not that simple. Of course, it's also a matter of how big your database is. The bigger the worse. Regards, Sven 2009/2/17 Jacques Le Roux 2d or 3d time this question is asked : time for a FAQ http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-WhyprimarykeysareVARCHARtypeinOFBiz Thanks David Jacques From: "David E Jones" 1. The performance overhead is minimal on modern database systems. 2. Character strings give significant flexibility, especially when it is common to migrate data from other systems that have characters in their IDs. 3. Being able to prefix IDs is used in a number of places in OFBiz, including prefixes for entire systems when data transfers between them are done to separate ID spaces. Welcome to the real world! ;) -David On Feb 17, 2009, at 8:05 AM, Dhruv Datta wrote: Hello Frns, I am a *newbie* in OFBiz and was playing with the OFBiz. During my play I found that in OFBiz data type for all the primary keys are VAR-CHAR, but VAR-CHAR data type is not a good practice for the efficiency perspective because it takes extra time during searching. Can anyone please tell me why OFBiz uses VAR-CHAR data type used for primary key instead of NUMERIC data type. Any help would be greatly appreciated. Dhruv. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmxQ6rP3NbaWWqE4RAkfjAKClPAs2o0o58AdYXTNWxsxK/+tAQgCePrLa Z7El/e8xhPwsbThwrEuo8zU= =58Or -END PGP SIGNATURE-
EcommerceSetup.bsh
All, I could be a damn question, but will ask anyway: EcommerceSetup.bsh seems to be a global setup to run ecommerce. The first line gets productStore from ... object called >request<. At which point >request< gets its content? Jacek
Re: Why primary keys are VAR_CHAR type in OFBiz?
EnterpriseDB guys know what they are talking about (they are offering Postgres commercial support) http://markmail.org/message/7ykdxmvc7fvonx5q Jacques PS : OK, I'm a Postgres fan Jacques From: "BJ Freeman" -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 there was not statement on comparison, you are correct. have you done a test though to see what the real difference in msec is, on what you define as a large database. Sven Wesley sent the following on 2/17/2009 11:28 AM: Sorry guys, but I don't agree on the first point. An Integer or Number as primary will always win the time race compared to a varchar, specially if there's a group or order clause included. I do agree about the flexibility (that also comes with other complexities), but the performance issue is unfortunately not that simple. Of course, it's also a matter of how big your database is. The bigger the worse. Regards, Sven 2009/2/17 Jacques Le Roux 2d or 3d time this question is asked : time for a FAQ http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-WhyprimarykeysareVARCHARtypeinOFBiz Thanks David Jacques From: "David E Jones" 1. The performance overhead is minimal on modern database systems. 2. Character strings give significant flexibility, especially when it is common to migrate data from other systems that have characters in their IDs. 3. Being able to prefix IDs is used in a number of places in OFBiz, including prefixes for entire systems when data transfers between them are done to separate ID spaces. Welcome to the real world! ;) -David On Feb 17, 2009, at 8:05 AM, Dhruv Datta wrote: Hello Frns, I am a *newbie* in OFBiz and was playing with the OFBiz. During my play I found that in OFBiz data type for all the primary keys are VAR-CHAR, but VAR-CHAR data type is not a good practice for the efficiency perspective because it takes extra time during searching. Can anyone please tell me why OFBiz uses VAR-CHAR data type used for primary key instead of NUMERIC data type. Any help would be greatly appreciated. Dhruv. -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmxQ6rP3NbaWWqE4RAkfjAKClPAs2o0o58AdYXTNWxsxK/+tAQgCePrLa Z7El/e8xhPwsbThwrEuo8zU= =58Or -END PGP SIGNATURE-
Re: Why primary keys are VAR_CHAR type in OFBiz?
Again, that depends upon the database, the operating system, and the hardware. If you have an installation that performs better with a different field type, then by all means, change your local copy to use a different field type. -Adrian Sven Wesley wrote: Sorry guys, but I don't agree on the first point. An Integer or Number as primary will always win the time race compared to a varchar, specially if there's a group or order clause included. I do agree about the flexibility (that also comes with other complexities), but the performance issue is unfortunately not that simple. Of course, it's also a matter of how big your database is. The bigger the worse. Regards, Sven 2009/2/17 Jacques Le Roux 2d or 3d time this question is asked : time for a FAQ http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-WhyprimarykeysareVARCHARtypeinOFBiz Thanks David Jacques From: "David E Jones" 1. The performance overhead is minimal on modern database systems. 2. Character strings give significant flexibility, especially when it is common to migrate data from other systems that have characters in their IDs. 3. Being able to prefix IDs is used in a number of places in OFBiz, including prefixes for entire systems when data transfers between them are done to separate ID spaces. Welcome to the real world! ;) -David On Feb 17, 2009, at 8:05 AM, Dhruv Datta wrote: Hello Frns, I am a *newbie* in OFBiz and was playing with the OFBiz. During my play I found that in OFBiz data type for all the primary keys are VAR-CHAR, but VAR-CHAR data type is not a good practice for the efficiency perspective because it takes extra time during searching. Can anyone please tell me why OFBiz uses VAR-CHAR data type used for primary key instead of NUMERIC data type. Any help would be greatly appreciated. Dhruv.
Re: Why primary keys are VAR_CHAR type in OFBiz?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 there was not statement on comparison, you are correct. have you done a test though to see what the real difference in msec is, on what you define as a large database. Sven Wesley sent the following on 2/17/2009 11:28 AM: > Sorry guys, but I don't agree on the first point. An Integer or Number as > primary will always win the time race compared to a varchar, specially if > there's a group or order clause included. I do agree about the flexibility > (that also comes with other complexities), but the performance issue is > unfortunately not that simple. Of course, it's also a matter of how big your > database is. The bigger the worse. > > Regards, > Sven > > > 2009/2/17 Jacques Le Roux > >> 2d or 3d time this question is asked : time for a FAQ >> >> http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-WhyprimarykeysareVARCHARtypeinOFBiz >> >> Thanks David >> >> Jacques >> >> From: "David E Jones" >> >> >>> 1. The performance overhead is minimal on modern database systems. >>> 2. Character strings give significant flexibility, especially when it is >>> common to migrate data from other systems that have >>> characters in their IDs. >>> 3. Being able to prefix IDs is used in a number of places in OFBiz, >>> including prefixes for entire systems when data transfers >>> between them are done to separate ID spaces. >>> >>> Welcome to the real world! ;) >>> >>> -David >>> >>> >>> On Feb 17, 2009, at 8:05 AM, Dhruv Datta wrote: >>> >>> Hello Frns, I am a *newbie* in OFBiz and was playing with the OFBiz. During my play I found that in OFBiz data type for all the primary keys are VAR-CHAR, but VAR-CHAR data type is not a good practice for the efficiency perspective because it takes extra time during searching. Can anyone please tell me why OFBiz uses VAR-CHAR data type used for primary key instead of NUMERIC data type. Any help would be greatly appreciated. Dhruv. >>> >> > -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmxQ6rP3NbaWWqE4RAkfjAKClPAs2o0o58AdYXTNWxsxK/+tAQgCePrLa Z7El/e8xhPwsbThwrEuo8zU= =58Or -END PGP SIGNATURE-
Re: Why primary keys are VAR_CHAR type in OFBiz?
Sorry guys, but I don't agree on the first point. An Integer or Number as primary will always win the time race compared to a varchar, specially if there's a group or order clause included. I do agree about the flexibility (that also comes with other complexities), but the performance issue is unfortunately not that simple. Of course, it's also a matter of how big your database is. The bigger the worse. Regards, Sven 2009/2/17 Jacques Le Roux > 2d or 3d time this question is asked : time for a FAQ > > http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-WhyprimarykeysareVARCHARtypeinOFBiz > > Thanks David > > Jacques > > From: "David E Jones" > > >> 1. The performance overhead is minimal on modern database systems. >> 2. Character strings give significant flexibility, especially when it is >> common to migrate data from other systems that have >> characters in their IDs. >> 3. Being able to prefix IDs is used in a number of places in OFBiz, >> including prefixes for entire systems when data transfers >> between them are done to separate ID spaces. >> >> Welcome to the real world! ;) >> >> -David >> >> >> On Feb 17, 2009, at 8:05 AM, Dhruv Datta wrote: >> >> Hello Frns, >>> >>> I am a *newbie* in OFBiz and was playing with the OFBiz. >>> >>> During my play I found that in OFBiz data type for all the primary keys >>> are VAR-CHAR, but VAR-CHAR data type is not a good practice for the >>> efficiency perspective because it takes extra time during searching. Can >>> anyone please tell me why OFBiz uses VAR-CHAR data type used for primary >>> key >>> instead of NUMERIC data type. >>> >>> Any help would be greatly appreciated. >>> >>> >>> Dhruv. >>> >> >> > >
Re: Why primary keys are VAR_CHAR type in OFBiz?
2d or 3d time this question is asked : time for a FAQ http://docs.ofbiz.org/display/OFBIZ/FAQ+-+Tips+-+Tricks+-+Cookbook+-+HowTo#FAQ-Tips-Tricks-Cookbook-HowTo-WhyprimarykeysareVARCHARtypeinOFBiz Thanks David Jacques From: "David E Jones" 1. The performance overhead is minimal on modern database systems. 2. Character strings give significant flexibility, especially when it is common to migrate data from other systems that have characters in their IDs. 3. Being able to prefix IDs is used in a number of places in OFBiz, including prefixes for entire systems when data transfers between them are done to separate ID spaces. Welcome to the real world! ;) -David On Feb 17, 2009, at 8:05 AM, Dhruv Datta wrote: Hello Frns, I am a *newbie* in OFBiz and was playing with the OFBiz. During my play I found that in OFBiz data type for all the primary keys are VAR-CHAR, but VAR-CHAR data type is not a good practice for the efficiency perspective because it takes extra time during searching. Can anyone please tell me why OFBiz uses VAR-CHAR data type used for primary key instead of NUMERIC data type. Any help would be greatly appreciated. Dhruv.
Re: Why primary keys are VAR_CHAR type in OFBiz?
1. The performance overhead is minimal on modern database systems. 2. Character strings give significant flexibility, especially when it is common to migrate data from other systems that have characters in their IDs. 3. Being able to prefix IDs is used in a number of places in OFBiz, including prefixes for entire systems when data transfers between them are done to separate ID spaces. Welcome to the real world! ;) -David On Feb 17, 2009, at 8:05 AM, Dhruv Datta wrote: Hello Frns, I am a *newbie* in OFBiz and was playing with the OFBiz. During my play I found that in OFBiz data type for all the primary keys are VAR-CHAR, but VAR-CHAR data type is not a good practice for the efficiency perspective because it takes extra time during searching. Can anyone please tell me why OFBiz uses VAR-CHAR data type used for primary key instead of NUMERIC data type. Any help would be greatly appreciated. Dhruv.
Re: Tricky! About fields in the form
Jack, I suggested configuring these through entity fields instead of in the database because that is what is supported right now. If you want something that adds fields to a Form Widget form based on data in the database that would have to be written as it currently only feeds from the form definition XML files. That wouldn't be too hard to do (ie add functionality to add fields based on the database). We decided early on that we wanted these things configured from XML files instead of being more database driven (like Compiere and certain other frameworks are) because it is easier to revision control and manage in a large-scale environment (especially for updates and collaboration when multiple people are working on the applications). So yes, it could certainly be developed as an extension to the current Form Widget, but does not exist now. -David On Feb 17, 2009, at 6:46 AM, Jack Liu wrote: Are you sure what I want and you have a good solution? Again: What I want is not drop-down list In table attributetype: Id attributetype 1 ChUrl A 2 SupportedCharsets A 3 ServerID A 4 ServerID B While in form, we can get all the attributes of type A. Three fields ChlUrl, SupportedCharsets, ServerID are all fetched from table, not written by hand. Of course, the form maybe looks different, but can reach the same effect as above. Are you sure you can do it? If you can do it, money is not a problem, I think. -Original Message- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: 2009年2月17日 21:20 To: user@ofbiz.apache.org Subject: Re: Tricky! About fields in the form -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On the list I point people to places they can learn. however if you want personal help I will be glad to consult with you for a fee. Jack Liu sent the following on 2/17/2009 5:13 AM: Could you give me an example in OFBiz? I think it's very easy for you to find an example? -Original Message- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: 2009年2月17日 20:51 To: user@ofbiz.apache.org Subject: Re: Tricky! About fields in the form find a page that has a drop down and look at the code. preferably widget. also look up views that use the org.ofbiz.common.enum entity there are examples in code. My comments are how ofbiz sees things. it takes a while for a datbase centric person to see things the way ofbiz does it. I speak from experience. If you step back and let go of the Table Columnnames, it helps. Jack Liu sent the following on 2/16/2009 9:36 PM: Why would my attribute be enumerations? You mean attribute references an enumeration below? name="Enumeration"> If a field is from an enumeration, in the page it will show a drop- down list. It's now what I want. What I want shows like below: -Original Message- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: 2009t217 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmrlprP3NbaWWqE4RApi9AKCMLp29GUOlHpReAiEI6pON3Z0RfACgkdMg q1tPBF8EF5l1wOaQdz0fRY4= =OcS9 -END PGP SIGNATURE-
Re: Tricky! About fields in the form
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 field types are gotten from the framework\entity\fieldtype folder for your specific db. look at the Type for how to define in ofbiz like type="short-varchar" there is no text type. if the db is connected to ofbiz now, and an entity is defined you can use the web tools to see what would be pulled from the table go to https://localhost:8443/webtools/control/entitymaint find your entity protocolAttribute click on Fnd you can put an "A" in the "type" field and see what comes up. you can do this with the other entities to see the results. the code that does this is part of the code you will need but written differently. The rest of the form is how you want it laid out. Please contact me directly. I can only respond to mailing list concern here. Jack Liu sent the following on 2/17/2009 5:46 AM: > Are you sure what I want and you have a good solution? > Again: > What I want is not drop-down list > > In table attributetype: > Id attributetype > 1 ChUrl A > 2 SupportedCharsets A > 3 ServerID A > 4 ServerID B > > > While in form, we can get all the attributes of type A. > >target="createProtocolAttribute?protocolid=${id}"> > > > > > > > > > Three fields ChlUrl, SupportedCharsets, ServerID are all fetched from table, > not written by hand. Of course, the form maybe looks different, but can reach > the same effect as above. > > Are you sure you can do it? If you can do it, money is not a problem, I think. > > -Original Message- > From: BJ Freeman [mailto:bjf...@free-man.net] > Sent: 2009年2月17日 21:20 > To: user@ofbiz.apache.org > Subject: Re: Tricky! About fields in the form > > On the list I point people to places they can learn. > however if you want personal help I will be glad to consult with you for > a fee. > > Jack Liu sent the following on 2/17/2009 5:13 AM: >> Could you give me an example in OFBiz? >> I think it's very easy for you to find an example? > > >> -Original Message- >> From: BJ Freeman [mailto:bjf...@free-man.net] >> Sent: 2009t217 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmwAVrP3NbaWWqE4RAthZAJ9VaOPZYck0knKhkWonlTQVM/atVACgw9L9 kuK7hmiWYs0m6TtyH4tZLUw= =84jD -END PGP SIGNATURE-
Why primary keys are VAR_CHAR type in OFBiz?
Hello Frns, I am a *newbie* in OFBiz and was playing with the OFBiz. During my play I found that in OFBiz data type for all the primary keys are VAR-CHAR, but VAR-CHAR data type is not a good practice for the efficiency perspective because it takes extra time during searching. Can anyone please tell me why OFBiz uses VAR-CHAR data type used for primary key instead of NUMERIC data type. Any help would be greatly appreciated. Dhruv.
Re: ecomm unhandled error
From: "Jacques Le Roux" Thanks Jan, This is fixed in revision 745093. But could you please revert the situation before the build takes place on the demo server ? Don't bother I made the change Jacques I'm looking for the same in trunk right now Jacques From: "Ján Valkovic" Hi, In ecommerce component in R4 an error message occured, when product has wrong configuration. For example: PC001 is "Fixed Asset Usage", but in "Rental" tab is field "Max.Nbr. of Persons for rental" empty. It is configured here (sorry :-) ): http://demo40.hotwaxmedia.com/ecommerce/control/product?product_id=PC001 IMHO, its bug. I expected some error or warning message in this case. Thanks Jan Valkovic
Re: ecomm unhandled error
Thanks Jan, This is fixed in revision 745093. But could you please revert the situation before the build takes place on the demo server ? I'm looking for the same in trunk right now Jacques From: "Ján Valkovic" Hi, In ecommerce component in R4 an error message occured, when product has wrong configuration. For example: PC001 is "Fixed Asset Usage", but in "Rental" tab is field "Max.Nbr. of Persons for rental" empty. It is configured here (sorry :-) ): http://demo40.hotwaxmedia.com/ecommerce/control/product?product_id=PC001 IMHO, its bug. I expected some error or warning message in this case. Thanks Jan Valkovic
RE: Tricky! About fields in the form
Are you sure what I want and you have a good solution? Again: What I want is not drop-down list In table attributetype: Id attributetype 1 ChUrl A 2 SupportedCharsets A 3 ServerID A 4 ServerID B While in form, we can get all the attributes of type A. Three fields ChlUrl, SupportedCharsets, ServerID are all fetched from table, not written by hand. Of course, the form maybe looks different, but can reach the same effect as above. Are you sure you can do it? If you can do it, money is not a problem, I think. -Original Message- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: 2009年2月17日 21:20 To: user@ofbiz.apache.org Subject: Re: Tricky! About fields in the form -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On the list I point people to places they can learn. however if you want personal help I will be glad to consult with you for a fee. Jack Liu sent the following on 2/17/2009 5:13 AM: > Could you give me an example in OFBiz? > I think it's very easy for you to find an example? > > > -Original Message- > From: BJ Freeman [mailto:bjf...@free-man.net] > Sent: 2009年2月17日 20:51 > To: user@ofbiz.apache.org > Subject: Re: Tricky! About fields in the form > > find a page that has a drop down and look at the code. > preferably widget. > also look up views that use the org.ofbiz.common.enum entity > there are examples in code. > My comments are how ofbiz sees things. > it takes a while for a datbase centric person to see things the way > ofbiz does it. I speak from experience. > If you step back and let go of the Table Columnnames, it helps. > > > > Jack Liu sent the following on 2/16/2009 9:36 PM: >> Why would my attribute be enumerations? >> You mean attribute references an enumeration below? > >> > >> >> >> >> >> >> >> >> > >> If a field is from an enumeration, in the page it will show a drop-down list. >> It's now what I want. What I want shows like below: > >> > target="createProtocolAttribute?protocolid=${id}"> >> >> >> >> >> >> >> > >> -Original Message- >> From: BJ Freeman [mailto:bjf...@free-man.net] >> Sent: 2009t217 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmrlprP3NbaWWqE4RApi9AKCMLp29GUOlHpReAiEI6pON3Z0RfACgkdMg q1tPBF8EF5l1wOaQdz0fRY4= =OcS9 -END PGP SIGNATURE-
Re: Tricky! About fields in the form
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On the list I point people to places they can learn. however if you want personal help I will be glad to consult with you for a fee. Jack Liu sent the following on 2/17/2009 5:13 AM: > Could you give me an example in OFBiz? > I think it's very easy for you to find an example? > > > -Original Message- > From: BJ Freeman [mailto:bjf...@free-man.net] > Sent: 2009年2月17日 20:51 > To: user@ofbiz.apache.org > Subject: Re: Tricky! About fields in the form > > find a page that has a drop down and look at the code. > preferably widget. > also look up views that use the org.ofbiz.common.enum entity > there are examples in code. > My comments are how ofbiz sees things. > it takes a while for a datbase centric person to see things the way > ofbiz does it. I speak from experience. > If you step back and let go of the Table Columnnames, it helps. > > > > Jack Liu sent the following on 2/16/2009 9:36 PM: >> Why would my attribute be enumerations? >> You mean attribute references an enumeration below? > >> > >> >> >> >> >> >> >> >> > >> If a field is from an enumeration, in the page it will show a drop-down list. >> It's now what I want. What I want shows like below: > >> > target="createProtocolAttribute?protocolid=${id}"> >> >> >> >> >> >> >> > >> -Original Message- >> From: BJ Freeman [mailto:bjf...@free-man.net] >> Sent: 2009t217 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmrlprP3NbaWWqE4RApi9AKCMLp29GUOlHpReAiEI6pON3Z0RfACgkdMg q1tPBF8EF5l1wOaQdz0fRY4= =OcS9 -END PGP SIGNATURE-
RE: Tricky! About fields in the form
Could you give me an example in OFBiz? I think it's very easy for you to find an example? -Original Message- From: BJ Freeman [mailto:bjf...@free-man.net] Sent: 2009年2月17日 20:51 To: user@ofbiz.apache.org Subject: Re: Tricky! About fields in the form -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 find a page that has a drop down and look at the code. preferably widget. also look up views that use the org.ofbiz.common.enum entity there are examples in code. My comments are how ofbiz sees things. it takes a while for a datbase centric person to see things the way ofbiz does it. I speak from experience. If you step back and let go of the Table Columnnames, it helps. Jack Liu sent the following on 2/16/2009 9:36 PM: > Why would my attribute be enumerations? > You mean attribute references an enumeration below? > > > > > > > > > > > > If a field is from an enumeration, in the page it will show a drop-down list. > It's now what I want. What I want shows like below: > > target="createProtocolAttribute?protocolid=${id}"> > > > > > > > > > -Original Message- > From: BJ Freeman [mailto:bjf...@free-man.net] > Sent: 2009年2月17日 13:08 > To: user@ofbiz.apache.org > Subject: Re: Tricky! About fields in the form > > A table in a database is an entity > in entity form you would have 4 fields > field name="id" type="id-ne"> > > > > > > your attribute would be enumerations > > BTW you can do an export of entities and it will build the Entity from > the table you put in. > > > Jack Liu sent the following on 2/16/2009 6:03 PM: >> In the table protocolAttribute, records show below >> id, protocolid, attribute, value >> 1 1 ChlUrl 192.168.77.22/abc >> 2 1 ServerID DWAI >> 3 2 ChlUrl 192.168.77.22/abc >> 4 2 SupportedCharsetsgbk,UTF8 > > >> -Original Message- >> From: Jack Liu [mailto:jack@aicent.com] >> Sent: 2009t217 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmrLLrP3NbaWWqE4RApBBAJ4874sQawsLHj4UAR0o2gXJ9LioNwCfVbfb 779UzmDOBgw4oKsAKc9p0S4= =oFaO -END PGP SIGNATURE-
Re: Add To List is Working only for Virtual
Hello Jacques, All , Thanks for your Suggestion. I just go through explanations of feature explosion mechanism. its really very helpful to me. as we see shopping list behavior from two different page 1 from product detail page 2 from show cart page (after add to cart). But I am still confused about the different behavior of wish list from different page, but IMO it should work same from both place then it will be more significant. Here is the steps that i follow 1. Login with admin and ofbiz 2. Product detail page select all the feature for the product *WG-9943* color:- Black , Size : - 4 Wheel 3 and then click to "*Add to shopping list *" , then in shopping(wish) list page, it Shows the Virtual Product WG-9943 with out feature which I selected from product detail page, where IMO it should show *WG-9943-B4* Wish List also shows the link in the last column with the drop down which contains all variants of that product (as they are available as Finished Goods in data base ). and we can *Replace with available variant.* Then some doubts as 1.What about that option which I selected from Product Detail Page ? 2.why i will again select the variant which I already selected in previous page before clicking on "Add To Shopping List". ? OK it is the case for the Variants Explosion Mechanism. As variants are available in data base But in case of Feature Explosion Mechanism as we know that it will create 1. From product detail page select feature for the product *WG-9944* *color : - black . Size :- 4 Wheel* 2. click on the "Add To Shopping list" then in shopping(wish) list page we again get the Virtual Product *WG-9944* in the list, and as there is no Variant available in Data Base, so in list there is no variant available (because that variant is created dynamically) , and then when we click on "Add to Cart" button from shopping list page and will again send us to product detail page with the message : - "*Choose Variation Before Adding to Cart.*" but now as the purpose of wish list i can understand that the, one can save the list of product what he wants/ likes to buy in the near future, and if that shopping list not contain the product with the selected features which was already saved. It is the current scenario of wish list. There is one more case where it works fine for that i followed these steps - > Login with admin and ofbiz - > Select Features for the product *(WG-9944 / WG-9943)* - > click on "Add to Cart" button - > then go to "view cart / Show cart" page - > select the "check box" for the product - > click on "Add to Shopping List" then go to shopping list page , there we can see it is showing the proper variants for the product. Thanks & Regards --- Arpit Singh Pandya Jacques Le Roux wrote: Actually it works (you get the right price in the shopping list). This is due to how feature explosion works. Look for instance at WG-9943 : you can select the variants and have them clearly in the shopping list. Please look for explanations about feature explosion mechanism. Jacques From: "Arpit Singh Pandya" Hello All, In Product Detail page while adding product to the shopping/wish list, it will only take Virtual Product in the shopping/wish list, although we can select the variant for that product. I refer to product as Large Widgets (WG-9944) is it the proper functionality of wish/shopping list. ? Please let me know I am wrong about this. Thanks & Regards Arpit Singh Pandya
Re: Tricky! About fields in the form
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 find a page that has a drop down and look at the code. preferably widget. also look up views that use the org.ofbiz.common.enum entity there are examples in code. My comments are how ofbiz sees things. it takes a while for a datbase centric person to see things the way ofbiz does it. I speak from experience. If you step back and let go of the Table Columnnames, it helps. Jack Liu sent the following on 2/16/2009 9:36 PM: > Why would my attribute be enumerations? > You mean attribute references an enumeration below? > > > > > > > > > > > > If a field is from an enumeration, in the page it will show a drop-down list. > It's now what I want. What I want shows like below: > > target="createProtocolAttribute?protocolid=${id}"> > > > > > > > > > -Original Message- > From: BJ Freeman [mailto:bjf...@free-man.net] > Sent: 2009年2月17日 13:08 > To: user@ofbiz.apache.org > Subject: Re: Tricky! About fields in the form > > A table in a database is an entity > in entity form you would have 4 fields > field name="id" type="id-ne"> > > > > > > your attribute would be enumerations > > BTW you can do an export of entities and it will build the Entity from > the table you put in. > > > Jack Liu sent the following on 2/16/2009 6:03 PM: >> In the table protocolAttribute, records show below >> id, protocolid, attribute, value >> 1 1 ChlUrl 192.168.77.22/abc >> 2 1 ServerID DWAI >> 3 2 ChlUrl 192.168.77.22/abc >> 4 2 SupportedCharsetsgbk,UTF8 > > >> -Original Message- >> From: Jack Liu [mailto:jack@aicent.com] >> Sent: 2009t217 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFJmrLLrP3NbaWWqE4RApBBAJ4874sQawsLHj4UAR0o2gXJ9LioNwCfVbfb 779UzmDOBgw4oKsAKc9p0S4= =oFaO -END PGP SIGNATURE-
ecomm unhandled error
Hi, In ecommerce component in R4 an error message occured, when product has wrong configuration. For example: PC001 is "Fixed Asset Usage", but in "Rental" tab is field "Max.Nbr. of Persons for rental" empty. It is configured here (sorry :-) ): http://demo40.hotwaxmedia.com/ecommerce/control/product?product_id=PC001 IMHO, its bug. I expected some error or warning message in this case. Thanks Jan Valkovic
How to access the Demo websites listed in Content tab?
Hi all , I have created a test website with the following parameters and added three contents on that site, Web Site Id : TEST_SITE Site Name :TEST_ LB_SITE Allow Product Store Change :Y Http Host:192.168.0.34 Http Port :8080 then I have used the following url's to view the site, but it displays an empty page 1. http://192.168.0.34:8080/TEST_SITE 2. http://192.168.0.34:8080/TEST_ LB_SITE Questions: 1. How can i access my test site? 2. How can i access the websites that were listed in the content tab? 3. Is there any public url to access those sites? Thanks & Best Regards Baiju C.John
Re: Error : OFBiz server is unreachable - connection impossible
Apache's magic :o) Jacques From: "Marco Westermann" In that second I send the mail, it works again.. ;-) Marco Jacques Le Roux schrieb: Eric, Please, look at the message I posted some hours earlier Fw: svn delays for the foreseeable future and have a look at http://twitter.com/infrabot for update... Jacques From: "Eric DE MAULDE" Hi I can't connect to the OFBiz trunk server from a French Internet connection Eric __ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank-Version 3860 (20090217) __ E-Mail wurde geprüft mit ESET NOD32 Antivirus. http://www.eset.com
Re: Error : OFBiz server is unreachable - connection impossible
In that second I send the mail, it works again.. ;-) Marco Jacques Le Roux schrieb: Eric, Please, look at the message I posted some hours earlier Fw: svn delays for the foreseeable future and have a look at http://twitter.com/infrabot for update... Jacques From: "Eric DE MAULDE" Hi I can't connect to the OFBiz trunk server from a French Internet connection Eric __ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank-Version 3860 (20090217) __ E-Mail wurde geprüft mit ESET NOD32 Antivirus. http://www.eset.com
Re: Error : OFBiz server is unreachable - connection impossible
Hi Eric, you seem to be right. I can't update the source from svn neither. (from germany) best regards, Marco Eric DE MAULDE schrieb: Hi I can't connect to the OFBiz trunk server from a French Internet connection Eric __ Hinweis von ESET NOD32 Antivirus, Signaturdatenbank-Version 3860 (20090217) __ E-Mail wurde geprüft mit ESET NOD32 Antivirus. http://www.eset.com
Re: Error : OFBiz server is unreachable - connection impossible
Eric, Please, look at the message I posted some hours earlier Fw: svn delays for the foreseeable future and have a look at http://twitter.com/infrabot for update... Jacques From: "Eric DE MAULDE" Hi I can't connect to the OFBiz trunk server from a French Internet connection Eric
Error : OFBiz server is unreachable - connection impossible
Hi I can't connect to the OFBiz trunk server from a French Internet connection Eric
Re: what is the purpose of autoCancelDate field in OrderItem entity
Yes indeed, this sounds like an appropriate description of this feature Jacques From: "Akash Jain" Hello All, Can anyone help me, please tell me what is the purpose of autoCancelDate field in OrderItem entity. I search and find that Items will be cancelled if the item is flagged with an autoCancelDate and does not have a dontCancelDate and dontCancelUserLogin associated with it, and it is past the autoCancelDate please correct me if i am wrong Thanks in advance Akash Jain