Re: Attachments
sebastianscheid schrieb: Christian Geisert wrote: sebastianscheid schrieb: Hi, is there a possibility to store attachments like pdfs in the system? E.g. I want received invoices to be attached to an invoice of a purchase order. Or some email conversation should be attached to a sales order. Yes, this can be with the content framework. See the Party Profile for an example: https://demo.hotwaxmedia.com/partymgr/control/viewprofile?partyId=DemoCustCompany ,scroll down to Party Content) Thanks for replying to fast! Do you also know how to attach something to an order? Or an invoice? This isn't possible at the moment, it just needs a bit of coding (patches are welcome ;-) And what exactly is the content framework? Do you mean the content application? I thought that is a content management system. I meant the Content/DataSource etc. Entities and the related services which are part of the content application. -- Christian
Illegal Characters in an ofbiz URL
I am importing an existing database with partyIds like PG#1 and BEN+JERRIES I assumed that the standard URL symbols would be illegal, so I converted '' to a '+' and most other punction to '_'. However, the '+' sign gets passed to the bash script as a space. In other words, P+G gets passed as P G which causes obvious problems. Is there a list somewhere of what characters are legal (or illegal) so I don't have to make guesses about it? Thanks in advance if this is a stupid newbee question. Skip No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM
Re: Attachments
communications events, which includes emails are attached to a partyid, if an email address match is found. If the email has the orderID in it then you can add code to view the order and the emails related. for now you can view the order then the partyID then the communications for the party and see the communications event for that party and order# if it is in the subject. Christian Geisert sent the following on 5/8/2008 9:03 AM: sebastianscheid schrieb: Christian Geisert wrote: sebastianscheid schrieb: Hi, is there a possibility to store attachments like pdfs in the system? E.g. I want received invoices to be attached to an invoice of a purchase order. Or some email conversation should be attached to a sales order. Yes, this can be with the content framework. See the Party Profile for an example: https://demo.hotwaxmedia.com/partymgr/control/viewprofile?partyId=DemoCustCompany ,scroll down to Party Content) Thanks for replying to fast! Do you also know how to attach something to an order? Or an invoice? This isn't possible at the moment, it just needs a bit of coding (patches are welcome ;-) And what exactly is the content framework? Do you mean the content application? I thought that is a content management system. I meant the Content/DataSource etc. Entities and the related services which are part of the content application.
Re: Some questions about OFBiz
Thanks for the responses guys. And sorry for not realizing this was already in documentation. I was looking for days for information on batch printing of labels and could not find anything for the life of me. Thanks again, James David E Jones wrote: Thanks for answering this BJ, in spite of a little bit of lack of respect in the question and follow-up, especially related to not looking at existing documentation, where there are answers to all of these questions. In the end-user documentation on docs.ofbiz.org it does cover some stuff on managing pick-lists and shipment packing. Related to that, it isn't all that common to pick more than one order at a time, but usually packing/weighing/labeling packages to ship them is done one at a time. Of course, you can build anything you can imagine that is internally consistent (ie not self-contradictory), and there are good tools and lower level functionality in OFBiz that make that easier. -David On May 7, 2008, at 1:01 PM, BJ Freeman wrote: 1) here is the release plan so far http://docs.ofbiz.org/display/OFBADMIN/Release+Plan 2)OOTB only shipping per order however it would not take much to write service that would do this. For packing list you would have to add in more screens and code to verify the shipment against the packking list. Not sure from a physical workflow if this is more productive, IMHO jamesterra sent the following on 5/7/2008 11:11 AM: Could someone here provide answers to these questions please? Thanks, James jamesterra wrote: Hi there, I am currently evaluating OFBiz as the framework for a new ecommerce project that I'm working on. So far I've been very impressed with OFBiz as it appears to have all of the features that I need. I do have a few questions that I was hoping to get cleared up: I need a stable build so I pulled the code from the 4.0 release branch. However, after looking at some of the new features in development, I was hoping to find a stable development branch that I could pull from instead. Is there such a branch? Hopefully something that's been tested to some degree? Going through the order manager, I couldn't find a way to print shipping labels in batches or do other tasks in batches (such as packing). Is there a way to do this OFBiz out of the box? Thanks, James -- View this message in context: http://www.nabble.com/Some-questions-about-OFBiz-tp17068928p17130151.html Sent from the OFBiz - User mailing list archive at Nabble.com.
RE: Illegal Characters in an ofbiz URL
From the RFC: The characters ;, /, ?, :, @, = and are the characters which may be reserved for special meaning within a scheme. and Thus, only alphanumerics, the special characters $-_.+!*'(),, and reserved characters used for their reserved purposes may be used unencoded within a URL. However, Ofbiz is converting the '+' sign to a space. Can someone tell me where this conversion is happening so I can look for other possible exceptions? This is important to me because I am importing hundreds of thousands of entries and I need to handle these characters during import. Skip -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, May 08, 2008 10:14 AM To: OfbizUser Subject: Illegal Characters in an ofbiz URL I am importing an existing database with partyIds like PG#1 and BEN+JERRIES I assumed that the standard URL symbols would be illegal, so I converted '' to a '+' and most other punction to '_'. However, the '+' sign gets passed to the bash script as a space. In other words, P+G gets passed as P G which causes obvious problems. Is there a list somewhere of what characters are legal (or illegal) so I don't have to make guesses about it? Thanks in advance if this is a stupid newbee question. Skip No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM No virus found in this incoming message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM
Re: security permission
Hey Guys, So is it a bug or feature that aded permission does not get saved to SecurityPermission entity? JohnBrown wrote: Yes, that is what I mean. The manually added permission for whatever reason did not go to SecurityPermission entity which holds the list of permissions. Vikas Mayur-2 wrote: There is a one-nofk relation between SecurityGroupPermission -- SecurityPermission on permissionId field. I think, this is the reason its not giving fk error. If we going to add new security group and than want to add permission(s) using Ui, It should also add this permission to SecurityPermission, Since this is the entity which holds the list of Security Permission in system. Is there any specific reason it is not done in Ui. Vikas On Thu, May 1, 2008 at 11:14 PM, JohnBrown [EMAIL PROTECTED] wrote: HI Guys, I have a question. Is there a particular reason why the permission which is added manually ( i.e. not selected from the permissions list) on Security- permission tab is NOT get saved to SecurityPermission entity where all the permissions are stored? It appears that manually added permission just stored in SecurityGroupPermission to make a mapping to group, but not to SecurityPermission. While normally it would require foreign key constraint SecurityGroupPermission - SecurityPermission on permissionId field? Please, let me know. Thanks. -- View this message in context: http://www.nabble.com/security-permission-tp16993344p16993344.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/security-permission-tp16993344p17137109.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Interesting test results
I was doing some testing last night and discovered that the combination of Ofbiz and Derby vs Ofbiz and Postgres was pretty amazing. Ofbiz using Postgres on a Windows box was about 6 to 10 times faster than when using Derby. The 10 was observed when watching the progress over 10 1 minute intervals. The six is an extrapolation of estimates. This test was importing some data and 22 entities were written using 4 services as well as some direct writes. The results were not so great when just using direct writes using the delegator. Thought others might be interested. No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM
Re: Interesting test results
I have noticed similar response times when doing a build run-install with Derby and Postgres. I would be interested in seeing the performance difference with Postgres vs. MySQL. In the past MySQL was faster but we didn't use it because of the poor transaction support in MySQL. Brett On Thu, May 8, 2008 at 3:55 PM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I was doing some testing last night and discovered that the combination of Ofbiz and Derby vs Ofbiz and Postgres was pretty amazing. Ofbiz using Postgres on a Windows box was about 6 to 10 times faster than when using Derby. The 10 was observed when watching the progress over 10 1 minute intervals. The six is an extrapolation of estimates. This test was importing some data and 22 entities were written using 4 services as well as some direct writes. The results were not so great when just using direct writes using the delegator. Thought others might be interested. No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM
Re: Where to store the reason for canceling some quantity of Order Item
Jacopo, I followed your suggestions and created an issue with patch OFBIZ-1773 Thanks for your guidance. Yes, it would be nice to get some feedback from others too. -- View this message in context: http://www.nabble.com/Where-to-store-the-reason-for-canceling-some-quantity-of-Order-Item-tp17101121p17138856.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Interesting test results
clarification was this thru webtools, or the install script that used ofbiz to talk to the db? the other test of interest is read and writes on large data sets in a table and joined. Mysql has had issues in large data storage and multiple queries. [EMAIL PROTECTED] sent the following on 5/8/2008 2:55 PM: I was doing some testing last night and discovered that the combination of Ofbiz and Derby vs Ofbiz and Postgres was pretty amazing. Ofbiz using Postgres on a Windows box was about 6 to 10 times faster than when using Derby. The 10 was observed when watching the progress over 10 1 minute intervals. The six is an extrapolation of estimates. This test was importing some data and 22 entities were written using 4 services as well as some direct writes. The results were not so great when just using direct writes using the delegator. Thought others might be interested. No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.9/1420 - Release Date: 5/7/2008 2:12 PM
Cancel Order Item transaction error - Help
Hi, Can anyone please help me or guide me on how to solve my issue on canceling order items. It triggers a transaction timeout during cancel of a single order item. The current size of my order item in the order is 95 order items. I need to execute a cancel, add and update. It triggers unexpected timeout result. Everything goes fine when the order item size is around 30 items. Please help me. Thank you - TInee
Re: Cancel Order Item transaction error - Help
what verion of the svn are you using trunk or release? can you include the log files? Tinee Valdez sent the following on 5/8/2008 7:57 PM: Hi, Can anyone please help me or guide me on how to solve my issue on canceling order items. It triggers a transaction timeout during cancel of a single order item. The current size of my order item in the order is 95 order items. I need to execute a cancel, add and update. It triggers unexpected timeout result. Everything goes fine when the order item size is around 30 items. Please help me. Thank you - TInee
Re: Cancel Order Item transaction error - Help
I tried checking the svn version but i guess i am not able to retrieve it. My database is mysql and with default mysql settings. Under normal circumstances should my setup work correctly on update/cancel operations even if i have 100 plus order items under an order. Sorry i am not able to provide the log file. I will try to recreate a log again. Thanks Tinee On Fri, May 9, 2008 at 11:42 AM, Tinee Valdez [EMAIL PROTECTED] wrote: i am not sure on what version. May i ask the quick way on getting the version number ? thanks. On Fri, May 9, 2008 at 11:02 AM, BJ Freeman [EMAIL PROTECTED] wrote: what verion of the svn are you using trunk or release? can you include the log files? Tinee Valdez sent the following on 5/8/2008 7:57 PM: Hi, Can anyone please help me or guide me on how to solve my issue on canceling order items. It triggers a transaction timeout during cancel of a single order item. The current size of my order item in the order is 95 order items. I need to execute a cancel, add and update. It triggers unexpected timeout result. Everything goes fine when the order item size is around 30 items. Please help me. Thank you - TInee
Re: security permission
Hi John, In this case, I think it is a mistake. It shouldn't be a one-nofk relation. Should be a one relation. Not sure why there is any reason for this to be one-nofk. This isn't the usual [primary key, fromDate] composite key issue. That would have a reason for ditching the FK. The SecurityGroupPermission entity doesn't have fromDate/thruDate. I don't think it is trying to keep an audit trail by ditching the FK. Jonathon JohnBrown wrote: Hey Guys, So is it a bug or feature that aded permission does not get saved to SecurityPermission entity? JohnBrown wrote: Yes, that is what I mean. The manually added permission for whatever reason did not go to SecurityPermission entity which holds the list of permissions. Vikas Mayur-2 wrote: There is a one-nofk relation between SecurityGroupPermission -- SecurityPermission on permissionId field. I think, this is the reason its not giving fk error. If we going to add new security group and than want to add permission(s) using Ui, It should also add this permission to SecurityPermission, Since this is the entity which holds the list of Security Permission in system. Is there any specific reason it is not done in Ui. Vikas On Thu, May 1, 2008 at 11:14 PM, JohnBrown [EMAIL PROTECTED] wrote: HI Guys, I have a question. Is there a particular reason why the permission which is added manually ( i.e. not selected from the permissions list) on Security- permission tab is NOT get saved to SecurityPermission entity where all the permissions are stored? It appears that manually added permission just stored in SecurityGroupPermission to make a mapping to group, but not to SecurityPermission. While normally it would require foreign key constraint SecurityGroupPermission - SecurityPermission on permissionId field? Please, let me know. Thanks. -- View this message in context: http://www.nabble.com/security-permission-tp16993344p16993344.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Cancel Order Item transaction error - Help
You should be able to find the name of the service that is causing the timeout from the log. Then you can add to the service definition the trasaction-timeout attribute in order to increase the timeout for the service. This should fix the error; however it would be useful to improve the service performance... but this would be longer. Jacopo On May 9, 2008, at 6:01 AM, Tinee Valdez wrote: I tried checking the svn version but i guess i am not able to retrieve it. My database is mysql and with default mysql settings. Under normal circumstances should my setup work correctly on update/cancel operations even if i have 100 plus order items under an order. Sorry i am not able to provide the log file. I will try to recreate a log again. Thanks Tinee On Fri, May 9, 2008 at 11:42 AM, Tinee Valdez [EMAIL PROTECTED] wrote: i am not sure on what version. May i ask the quick way on getting the version number ? thanks. On Fri, May 9, 2008 at 11:02 AM, BJ Freeman [EMAIL PROTECTED] wrote: what verion of the svn are you using trunk or release? can you include the log files? Tinee Valdez sent the following on 5/8/2008 7:57 PM: Hi, Can anyone please help me or guide me on how to solve my issue on canceling order items. It triggers a transaction timeout during cancel of a single order item. The current size of my order item in the order is 95 order items. I need to execute a cancel, add and update. It triggers unexpected timeout result. Everything goes fine when the order item size is around 30 items. Please help me. Thank you - TInee