OFBiz › OFBiz - User

Re: Users - Help needed for group by condition ...

‹ Previous Topic Next Topic ›
 
classic Classic list List threaded Threaded
♦
♦
 3 messages Options
Alexandre Gomes-5
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Help needed for group by condition ...

Alexandre Gomes-5
Hi Raj,

Here you have an example of how to count the products in categories
using the ProductCategoryMember table.


            DynamicViewEntity dve = new DynamicViewEntity();
            dve.addMemberEntity("PCM", "ProductCategoryMember");
            dve.addAlias("PCM", "productId", null, null, null,
Boolean.TRUE, null);
            dve.addAlias("PCM", "productCategoryId", null, null, null,
Boolean.TRUE, null);
            dve.addAlias("PCM", "fromDate", null, null, null, null, null);
            dve.addAlias("PCM", "thruDate", null, null, null, null, null);
            dve.addAlias("PCM", "productIdCount", "productId", null,
null, null, "count");

            EntityCondition condition = new EntityConditionList(UtilMisc.toList(
                    new EntityExpr("fromDate",
EntityOperator.LESS_THAN, nowTimestamp),
                    new EntityExpr("thruDate", EntityOperator.EQUALS, null)
                    ), EntityOperator.AND);
            EntityCondition havingCond = new
EntityExpr("productIdCount", EntityOperator.GREATER_THAN, new
Long(1));
            EntityListIterator eli =
delegator.findListIteratorByCondition(dve, condition, havingCond,
UtilMisc.toList("productId", "productCategoryId", "productIdCount"),
null, null);

Alexandre Gomes

On 6/18/05, Raj <[hidden email]> wrote:

> Hi to all
> I need to perform the group by operation in the where condition like order
> by operation ,how to do this operation in opentaps ,or any other operation
> similar to groups by in sql
>
>
>
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Andrew Sykes
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Help needed for group by condition ...

Andrew Sykes
Raj,

Perhaps a view entity, or a dynamic view...
http://www.ofbiz.org/api/framework/entity/build/javadocs/org/ofbiz/entity/model/DynamicViewEntity.html

- Andrew

On Tue, 2005-06-21 at 06:16 +0530, Raj wrote:

> Hi Alexandre Gomes
>  I am selecting value from table ,but when I use order by condition ,it will
> allow duplication of value for example
>
> In my table structure like this
>
> Pid   info    value
>
> 12    v1       n1
> 13    v2       n2
> 14    v1       n1
>
> Here I have 3 colum 3 record
>
> I need to diplay value where info="v1"
> In this query I get n1,n1
> Here n1 value printed (2 times ),I need to print n1 only one time (if values
> are same )
> That is reason I need group by condition or distinct operation  
>
>
>
>
> -----Original Message-----
> From: [hidden email] [mailto:[hidden email]]
> On Behalf Of [hidden email]
> Sent: Wednesday, June 21, 2006 5:05 PM
> To: [hidden email]
> Subject: Users Digest, Vol 23, Issue 68
>
> Send Users mailing list submissions to
> [hidden email]
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://lists.ofbiz.org/mailman/listinfo/users
> or, via email, send a message with subject or body 'help' to
> [hidden email]
>
> You can reach the person managing the list at
> [hidden email]
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Users digest..."
>
>
> Today's Topics:
>
>    1. Re: Help needed for group by condition ... (Alexandre Gomes)
>    2. Re: What is template path? (Alexandre Gomes)
>    3. Re: XML data import fails when importing more than ~10000
>       products (Jacopo Cappellato)
>    4. Re: XML data import fails when importing more than ~10000
>       products (BJ Freeman)
>    5. Re: how will email confirmation look like (Purani S)
>    6. where from the body for email is called (Purani S)
>    7. Re: how will email confirmation look like (BJ Freeman)
>    8. Widget separator ? (Jacques Le Roux)
>    9. Re: Widget separator ? (BJ Freeman)
>   10. Re: Widget separator ? (Alexandre Gomes)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 21 Jun 2006 02:15:20 +0100
> From: "Alexandre Gomes" <[hidden email]>
> Subject: Re: [OFBiz] Users - Help needed for group by condition ...
> To: "OFBiz Users / Usage Discussion" <[hidden email]>
> Message-ID:
> <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Raj,
>
> Here you have an example of how to count the products in categories
> using the ProductCategoryMember table.
>
>
>             DynamicViewEntity dve = new DynamicViewEntity();
>             dve.addMemberEntity("PCM", "ProductCategoryMember");
>             dve.addAlias("PCM", "productId", null, null, null,
> Boolean.TRUE, null);
>             dve.addAlias("PCM", "productCategoryId", null, null, null,
> Boolean.TRUE, null);
>             dve.addAlias("PCM", "fromDate", null, null, null, null, null);
>             dve.addAlias("PCM", "thruDate", null, null, null, null, null);
>             dve.addAlias("PCM", "productIdCount", "productId", null,
> null, null, "count");
>
>             EntityCondition condition = new
> EntityConditionList(UtilMisc.toList(
>                     new EntityExpr("fromDate",
> EntityOperator.LESS_THAN, nowTimestamp),
>                     new EntityExpr("thruDate", EntityOperator.EQUALS, null)
>                     ), EntityOperator.AND);
>             EntityCondition havingCond = new
> EntityExpr("productIdCount", EntityOperator.GREATER_THAN, new
> Long(1));
>             EntityListIterator eli =
> delegator.findListIteratorByCondition(dve, condition, havingCond,
> UtilMisc.toList("productId", "productCategoryId", "productIdCount"),
> null, null);
>
> Alexandre Gomes
>
> On 6/18/05, Raj <[hidden email]> wrote:
> > Hi to all
> > I need to perform the group by operation in the where condition like order
> > by operation ,how to do this operation in opentaps ,or any other operation
> > similar to groups by in sql
> >
> >
> >
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 21 Jun 2006 02:27:13 +0100
> From: "Alexandre Gomes" <[hidden email]>
> Subject: Re: [OFBiz] Users - What is template path?
> To: "OFBiz Users / Usage Discussion" <[hidden email]>
> Message-ID:
> <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Dhilip,
>
> It's the path where ofbiz can find the template file for your
> notification emails. The template file is generally a freemarker file
> or a screen widget which is basically a way to use the composite and
> decorator patterns with freemarker snippets.
>
> Alexandre Gomes
>
> On 6/19/06, dhilip kumar <[hidden email]> wrote:
> >
> > Hi
> >
> >     What is "template path" in email settings?
> >
> >
> > Thanks & regards
> >
> > Thilip
> >
> >
> >  ________________________________
> > Yahoo! Messenger with Voice. PC-to-Phone calls for ridiculously low rates.
> >
> >
> >
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 21 Jun 2006 06:44:32 +0200
> From: Jacopo Cappellato <[hidden email]>
> Subject: Re: [OFBiz] Users - XML data import fails when importing more
> than ~10000 products
> To: OFBiz Users / Usage Discussion <[hidden email]>
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Nick, all,
>
> I probably know the cause of this issue (but maybe not how to resolve
> this): this issue has been introduced when that import page has been
> converted to from jsp to screen widget; in fact 2 minutes is the default
> transaction timeout set for screens.
> In the "EntityImport" screen definition there is the following entry:
>
> <set field="parameters.TRANSACTION_TIMEOUT" value="7200"/>
>
> that should set the transaction timeout to 2 hours; if this doesn't work
> it is probably too late to set the timeout there (or the timeout is
> overriden by one of the screen's decorator)... any hints?
>
> Jacopo
>
> PS: Nick, you can always import your products using the command line:
>
> http://ofbizwiki.go-integral.com/Wiki.jsp?page=SeedData
>
>
>
> Nick Olson wrote:
> > It takes about 2 minutes before it comes back with this error. I've
> > tried increasing the timeout in the services.xml file, but it doesn't
> > seem to make a difference.
> >
> > David Welton wrote:
> >> On 6/20/06, Nick Olson <[hidden email]> wrote:
> >>> I am trying to import 40k products into the database (I'm running
> >>> postgres), but when I try to import, I get an error message that says:
> >>> ERROR parsing Entity Xml file: Commit transaction failed.
> >> How long is it taking?  No idea if this is the cause, but there is a
> >> transaction timeout.
> >>
> >  
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 20 Jun 2006 21:52:53 -0700
> From: BJ Freeman <[hidden email]>
> Subject: Re: [OFBiz] Users - XML data import fails when importing more
> than ~10000 products
> To: OFBiz Users / Usage Discussion <[hidden email]>
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I know command line would not work for me.
> I import from emails (CSV, Tab, XML) websites (Txt using | delimiter,
> XmL) FTP sites(zip, CSV, XML).
> Some file are 8-100mb
> These are done daily sometimes every four hours.
>
> thanks for the tip where to look will see what I can do, if someone does
> not pick up on it before then.
>
>
> Not sure on second thought that widgets would effect a service, but will
> look anyway.
>
>
> Jacopo Cappellato sent the following on 6/20/06 9:44 PM:
> > Nick, all,
> >
> > I probably know the cause of this issue (but maybe not how to resolve
> > this): this issue has been introduced when that import page has been
> > converted to from jsp to screen widget; in fact 2 minutes is the default
> > transaction timeout set for screens.
> > In the "EntityImport" screen definition there is the following entry:
> >
> > <set field="parameters.TRANSACTION_TIMEOUT" value="7200"/>
> >
> > that should set the transaction timeout to 2 hours; if this doesn't work
> > it is probably too late to set the timeout there (or the timeout is
> > overriden by one of the screen's decorator)... any hints?
> >
> > Jacopo
> >
> > PS: Nick, you can always import your products using the command line:
> >
> > http://ofbizwiki.go-integral.com/Wiki.jsp?page=SeedData
> >
> >
> >
> > Nick Olson wrote:
> >
> >>It takes about 2 minutes before it comes back with this error. I've
> >>tried increasing the timeout in the services.xml file, but it doesn't
> >>seem to make a difference.
> >>
> >>David Welton wrote:
> >>
> >>>On 6/20/06, Nick Olson <[hidden email]> wrote:
> >>>
> >>>>I am trying to import 40k products into the database (I'm running
> >>>>postgres), but when I try to import, I get an error message that says:
> >>>>ERROR parsing Entity Xml file: Commit transaction failed.
> >>>
> >>>How long is it taking?  No idea if this is the cause, but there is a
> >>>transaction timeout.
> >>>
> >>
> >>
> >>_______________________________________________
> >>Users mailing list
> >>[hidden email]
> >>http://lists.ofbiz.org/mailman/listinfo/users
> >>
> >
> >
> >  
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
>
>
> ------------------------------
>
> Message: 5
> Date: 21 Jun 2006 05:43:11 -0000
> From: "Purani S" <[hidden email]>
> Subject: Re: [OFBiz] Users - how will email confirmation look like
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi Si chen,
> If I need to check with the demo data, I need SMTP server, Isn't it?
>
> Thanks
> Purani
>
>
>
>
> On Tue, 20 Jun 2006 Si Chen wrote :
> >Why don't you just try the demo data?  It should be pretty clear.
> >
> >On Jun 20, 2006, at 1:24 AM, Purani S wrote:
> >
> >>How will email confirmation displayed in sequoiaerp0.8.3.
> >>Is the confirmation given as header in  the orderconfirmation page?
> >>
> >>
> >>Thanks
> >>Purani
> >>
> >>
> >>
> >>
> >>
> >>_______________________________________________
> >>Users mailing list
> >>[hidden email]
> >>http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
> >_______________________________________________
> >Users mailing list
> >[hidden email]
> >http://lists.ofbiz.org/mailman/listinfo/users
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.ofbiz.org/pipermail/users/attachments/20060621/1e7cc677/attachm
> ent-0001.htm
>
> ------------------------------
>
> Message: 6
> Date: 21 Jun 2006 09:30:26 -0000
> From: "Purani S" <[hidden email]>
> Subject: [OFBiz] Users - where from the body for email is called
> To: [hidden email]
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi,
> Where from is the body for the email message is called. The rest of the
> informations are from backend in  the table
> "product_store_email_setting"(Send CC, BCC).
> But where from Body is called.
>
> This is a critical issue.
> I need help.
>
> Thanks and Regard
> Purani ?
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.ofbiz.org/pipermail/users/attachments/20060621/bb3ada0a/attachm
> ent-0001.htm
>
> ------------------------------
>
> Message: 7
> Date: Wed, 21 Jun 2006 03:10:36 -0700
> From: BJ Freeman <[hidden email]>
> Subject: Re: [OFBiz] Users - how will email confirmation look like
> To: OFBiz Users / Usage Discussion <[hidden email]>
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> ofbiz is configured to send to a SMTP server and Get from either a POP3
> or IMAP server. If you need a SMTP pop3 server for testing you can run
> apache James on the same machine.
>
> I believe the Demo data reference was more to look at the code to see
> how to pre load the email data.
>
> There are many routines and services that support sending and receiving
> emails.  I suggest you use a find type of program to search for the word
>   mail on the folders and in the code. Once you see all that I am sure
> you can figure out the rest.
>
>
> Purani S sent the following on 6/20/06 10:43 PM:
> > Hi Si chen,
> > If I need to check with the demo data, I need SMTP server, Isn't it?
> >
> > Thanks
> > Purani
> >
> >
> >
> >
> > On Tue, 20 Jun 2006 Si Chen wrote :
> >
> >>Why don't you just try the demo data?  It should be pretty clear.
> >>
> >>On Jun 20, 2006, at 1:24 AM, Purani S wrote:
> >>
> >>
> >>>How will email confirmation displayed in sequoiaerp0.8.3.
> >>>Is the confirmation given as header in  the orderconfirmation page?
> >>>
> >>>
> >>>Thanks
> >>>Purani
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>_______________________________________________
> >>>Users mailing list
> >>>[hidden email]
> >>>http://lists.ofbiz.org/mailman/listinfo/users
> >>
> >>
> >>_______________________________________________
> >>Users mailing list
> >>[hidden email]
> >>http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> >  
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 21 Jun 2006 12:09:56 +0200
> From: Jacques Le Roux <[hidden email]>
> Subject: [OFBiz] Users - Widget separator ?
> To: OFBiz Users / Usage Discussion <[hidden email]>
> Message-ID: <00e201c6951a$da54b2b0$0300a8c0@LesArts>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Is there something in the widget that act as a panel, frame or lign to
> separate or group fields or is FTL needed for that ?
>
> Jacques
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
> http://lists.ofbiz.org/pipermail/users/attachments/20060621/0f200d4c/attachm
> ent-0001.htm
>
> ------------------------------
>
> Message: 9
> Date: Wed, 21 Jun 2006 03:38:14 -0700
> From: BJ Freeman <[hidden email]>
> Subject: Re: [OFBiz] Users - Widget separator ?
> To: OFBiz Users / Usage Discussion <[hidden email]>
> Message-ID: <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> This is more a Style setting in the CSS. Like Boxhead or topbox class.
> Take a look at some of the decorators.
>
> Jacques Le Roux sent the following on 6/21/06 3:09 AM:
> > Is there something in the widget that act as a panel, frame or lign to
> separate or group fields or is FTL needed for that ?
> >
> > Jacques
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> >  
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
>
>
> ------------------------------
>
> Message: 10
> Date: Wed, 21 Jun 2006 12:34:58 +0100
> From: "Alexandre Gomes" <[hidden email]>
> Subject: Re: [OFBiz] Users - Widget separator ?
> To: "OFBiz Users / Usage Discussion" <[hidden email]>
> Message-ID:
> <[hidden email]>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hi Jacques,
>
> You have this stuff you can use in the form widget. I don't know if it
> is exactly what you need :
>
>  <sort-order>
>     <banner left-text-style="bannerleft" left-text="&amp;nbsp;Name"/>
>     <field-group id="person" style="boxoutside">
>         <sort-field name="mcMarketingCampaignId"/>
>         <sort-field name="mcCampaignName"/>
>         <sort-field name="mcCampaignSummary"/>
>         <sort-field name="ptyPartyId"/>
>         <sort-field name="perMemberId"/>
>      </field-group>
>  </sort-order>
>
>
> Regards,
> Alex
> On 6/21/06, Jacques Le Roux <[hidden email]> wrote:
> >
> >
> > Is there something in the widget that act as a panel, frame or lign to
> > separate or group fields or is FTL needed for that ?
> >
> > Jacques
> >
> > _______________________________________________
> > Users mailing list
> > [hidden email]
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
>
>
> ------------------------------
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
>
> End of Users Digest, Vol 23, Issue 68
> *************************************
>
>  
> _______________________________________________
> Users mailing list
> [hidden email]
> http://lists.ofbiz.org/mailman/listinfo/users
--
Kind Regards
Andrew Sykes <[hidden email]>
Sykes Development Ltd
http://www.sykesdevelopment.com

 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
cjhowe
Reply | Threaded
Open this post in threaded view
♦
♦
|

Re: Users - Help needed for group by condition ...

cjhowe
In reply to this post by Alexandre Gomes-5
This is more of a data collection issue than a widget
issue.  I don't believe the widgets do anything with
the "Set" collection type, mainly "Lists".  So, that
said you will probably need to have a beanshell script
or simple method grab the data you're needing.

====Andrew wrote:


Raj,

Perhaps a view entity, or a dynamic view...
http://www.ofbiz.org/api/framework/entity/build/javadocs/org/ofbiz/entity/model/DynamicViewEntity.html

- Andrew

On Tue, 2005-06-21 at 06:16 +0530, Raj wrote:
> Hi Alexandre Gomes
>  I am selecting value from table ,but when I use
order by condition ,it will

> allow duplication of value for example
>
> In my table structure like this
>
> Pid   info    value
>
> 12    v1       n1
> 13    v2       n2
> 14    v1       n1
>
> Here I have 3 colum 3 record
>
> I need to diplay value where info="v1"
> In this query I get n1,n1
> Here n1 value printed (2 times ),I need to print n1
only one time (if values
> are same )
> That is reason I need group by condition or distinct
operation  
>
>
>
>
> -----Original Message-----
> From: users-bounces at lists.ofbiz.org
[mailto:users-bounces at lists.ofbiz.org]
> On Behalf Of users-request at lists.ofbiz.org
> Sent: Wednesday, June 21, 2006 5:05 PM
> To: users at lists.ofbiz.org
> Subject: Users Digest, Vol 23, Issue 68
>
> Send Users mailing list submissions to
> users at lists.ofbiz.org
>
> To subscribe or unsubscribe via the World Wide Web,
visit
> http://lists.ofbiz.org/mailman/listinfo/users
> or, via email, send a message with subject or body
'help' to
> users-request at lists.ofbiz.org
>
> You can reach the person managing the list at
> users-owner at lists.ofbiz.org
>
> When replying, please edit your Subject line so it
is more specific
> than "Re: Contents of Users digest..."
>
>
> Today's Topics:
>
>    1. Re: Help needed for group by condition ...
(Alexandre Gomes)
>    2. Re: What is template path? (Alexandre Gomes)
>    3. Re: XML data import fails when importing more
than ~10000
>       products (Jacopo Cappellato)
>    4. Re: XML data import fails when importing more
than ~10000
>       products (BJ Freeman)
>    5. Re: how will email confirmation look like
(Purani S)
>    6. where from the body for email is called
(Purani S)
>    7. Re: how will email confirmation look like (BJ
Freeman)
>    8. Widget separator ? (Jacques Le Roux)
>    9. Re: Widget separator ? (BJ Freeman)
>   10. Re: Widget separator ? (Alexandre Gomes)
>
>
>
----------------------------------------------------------------------
>
> Message: 1
> Date: Wed, 21 Jun 2006 02:15:20 +0100
> From: "Alexandre Gomes" <alexandre.rijo at
gmail.com>
> Subject: Re: [OFBiz] Users - Help needed for group
by condition ...
> To: "OFBiz Users / Usage Discussion" <users at
lists.ofbiz.org>
> Message-ID:
> <a08ca7ef0606201815g60b13b99k3ef28661db9f6dc1 at
mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> Hi Raj,
>
> Here you have an example of how to count the
products in categories
> using the ProductCategoryMember table.
>
>
>             DynamicViewEntity dve = new
DynamicViewEntity();
>             dve.addMemberEntity("PCM",
"ProductCategoryMember");
>             dve.addAlias("PCM", "productId", null,
null, null,
> Boolean.TRUE, null);
>             dve.addAlias("PCM", "productCategoryId",
null, null, null,
> Boolean.TRUE, null);
>             dve.addAlias("PCM", "fromDate", null,
null, null, null, null);
>             dve.addAlias("PCM", "thruDate", null,
null, null, null, null);
>             dve.addAlias("PCM", "productIdCount",
"productId", null,
> null, null, "count");
>
>             EntityCondition condition = new
> EntityConditionList(UtilMisc.toList(
>                     new EntityExpr("fromDate",
> EntityOperator.LESS_THAN, nowTimestamp),
>                     new EntityExpr("thruDate",
EntityOperator.EQUALS, null)
>                     ), EntityOperator.AND);
>             EntityCondition havingCond = new
> EntityExpr("productIdCount",
EntityOperator.GREATER_THAN, new
> Long(1));
>             EntityListIterator eli =
> delegator.findListIteratorByCondition(dve,
condition, havingCond,
> UtilMisc.toList("productId", "productCategoryId",
"productIdCount"),
> null, null);
>
> Alexandre Gomes
>
> On 6/18/05, Raj <ponnusamy.raj at tenth-planet.com>
wrote:
> > Hi to all
> > I need to perform the group by operation in the
where condition like order
> > by operation ,how to do this operation in opentaps
,or any other operation

> > similar to groups by in sql
> >
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.ofbiz.org
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
>
>
> ------------------------------
>
> Message: 2
> Date: Wed, 21 Jun 2006 02:27:13 +0100
> From: "Alexandre Gomes" <alexandre.rijo at
gmail.com>
> Subject: Re: [OFBiz] Users - What is template path?
> To: "OFBiz Users / Usage Discussion" <users at
lists.ofbiz.org>
> Message-ID:
> <a08ca7ef0606201827n73a50e2bq44dd538201930015 at
mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> Hi Dhilip,
>
> It's the path where ofbiz can find the template file
for your
> notification emails. The template file is generally
a freemarker file
> or a screen widget which is basically a way to use
the composite and
> decorator patterns with freemarker snippets.
>
> Alexandre Gomes
>
> On 6/19/06, dhilip kumar <dhilipsrinivasan at
yahoo.co.in> wrote:

> >
> > Hi
> >
> >     What is "template path" in email settings?
> >
> >
> > Thanks & regards
> >
> > Thilip
> >
> >
> >  ________________________________
> > Yahoo! Messenger with Voice. PC-to-Phone calls for
ridiculously low rates.

> >
> >
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.ofbiz.org
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
>
>
> ------------------------------
>
> Message: 3
> Date: Wed, 21 Jun 2006 06:44:32 +0200
> From: Jacopo Cappellato <tiz at sastau.it>
> Subject: Re: [OFBiz] Users - XML data import fails
when importing more
> than ~10000 products
> To: OFBiz Users / Usage Discussion <users at
lists.ofbiz.org>
> Message-ID: <4498CEB0.10404 at sastau.it>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> Nick, all,
>
> I probably know the cause of this issue (but maybe
not how to resolve
> this): this issue has been introduced when that
import page has been
> converted to from jsp to screen widget; in fact 2
minutes is the default
> transaction timeout set for screens.
> In the "EntityImport" screen definition there is the
following entry:
>
> <set field="parameters.TRANSACTION_TIMEOUT"
value="7200"/>
>
> that should set the transaction timeout to 2 hours;
if this doesn't work
> it is probably too late to set the timeout there (or
the timeout is
> overriden by one of the screen's decorator)... any
hints?
>
> Jacopo
>
> PS: Nick, you can always import your products using
the command line:
>
>
http://ofbizwiki.go-integral.com/Wiki.jsp?page=SeedData
>
>
>
> Nick Olson wrote:
> > It takes about 2 minutes before it comes back with
this error. I've
> > tried increasing the timeout in the services.xml
file, but it doesn't
> > seem to make a difference.
> >
> > David Welton wrote:
> >> On 6/20/06, Nick Olson <nick.olson at gmail.com>
wrote:
> >>> I am trying to import 40k products into the
database (I'm running
> >>> postgres), but when I try to import, I get an
error message that says:
> >>> ERROR parsing Entity Xml file: Commit
transaction failed.
> >> How long is it taking?  No idea if this is the
cause, but there is a

> >> transaction timeout.
> >>
> >  
> > _______________________________________________
> > Users mailing list
> > Users at lists.ofbiz.org
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
>
>
>
> ------------------------------
>
> Message: 4
> Date: Tue, 20 Jun 2006 21:52:53 -0700
> From: BJ Freeman <bjfree at free-man.net>
> Subject: Re: [OFBiz] Users - XML data import fails
when importing more
> than ~10000 products
> To: OFBiz Users / Usage Discussion <users at
lists.ofbiz.org>
> Message-ID: <4498D0A5.3010408 at free-man.net>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> I know command line would not work for me.
> I import from emails (CSV, Tab, XML) websites (Txt
using | delimiter,
> XmL) FTP sites(zip, CSV, XML).
> Some file are 8-100mb
> These are done daily sometimes every four hours.
>
> thanks for the tip where to look will see what I can
do, if someone does
> not pick up on it before then.
>
>
> Not sure on second thought that widgets would effect
a service, but will
> look anyway.
>
>
> Jacopo Cappellato sent the following on 6/20/06 9:44
PM:
> > Nick, all,
> >
> > I probably know the cause of this issue (but maybe
not how to resolve
> > this): this issue has been introduced when that
import page has been
> > converted to from jsp to screen widget; in fact 2
minutes is the default
> > transaction timeout set for screens.
> > In the "EntityImport" screen definition there is
the following entry:
> >
> > <set field="parameters.TRANSACTION_TIMEOUT"
value="7200"/>
> >
> > that should set the transaction timeout to 2
hours; if this doesn't work
> > it is probably too late to set the timeout there
(or the timeout is
> > overriden by one of the screen's decorator)... any
hints?
> >
> > Jacopo
> >
> > PS: Nick, you can always import your products
using the command line:
> >
> >
http://ofbizwiki.go-integral.com/Wiki.jsp?page=SeedData
> >
> >
> >
> > Nick Olson wrote:
> >
> >>It takes about 2 minutes before it comes back with
this error. I've
> >>tried increasing the timeout in the services.xml
file, but it doesn't
> >>seem to make a difference.
> >>
> >>David Welton wrote:
> >>
> >>>On 6/20/06, Nick Olson <nick.olson at gmail.com>
wrote:
> >>>
> >>>>I am trying to import 40k products into the
database (I'm running
> >>>>postgres), but when I try to import, I get an
error message that says:
> >>>>ERROR parsing Entity Xml file: Commit
transaction failed.
> >>>
> >>>How long is it taking?  No idea if this is the
cause, but there is a

> >>>transaction timeout.
> >>>
> >>
> >>
> >>_______________________________________________
> >>Users mailing list
> >>Users at lists.ofbiz.org
> >>http://lists.ofbiz.org/mailman/listinfo/users
> >>
> >
> >
> >  
> > _______________________________________________
> > Users mailing list
> > Users at lists.ofbiz.org
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
>
>
> ------------------------------
>
> Message: 5
> Date: 21 Jun 2006 05:43:11 -0000
> From: "Purani S" <puranisank at rediffmail.com>
> Subject: Re: [OFBiz] Users - how will email
confirmation look like
> To: users at lists.ofbiz.org
> Message-ID: <20060621054311.21748.qmail at
webmail32.rediffmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi Si chen,
> If I need to check with the demo data, I need SMTP
server, Isn't it?
>
> Thanks
> Purani
>
>
>
>
> On Tue, 20 Jun 2006 Si Chen wrote :
> >Why don't you just try the demo data?  It should be
pretty clear.
> >
> >On Jun 20, 2006, at 1:24 AM, Purani S wrote:
> >
> >>How will email confirmation displayed in
sequoiaerp0.8.3.
> >>Is the confirmation given as header in  the
orderconfirmation page?

> >>
> >>
> >>Thanks
> >>Purani
> >>
> >>
> >>
> >>
> >>
> >>_______________________________________________
> >>Users mailing list
> >>Users at lists.ofbiz.org
> >>http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
> >_______________________________________________
> >Users mailing list
> >Users at lists.ofbiz.org
> >http://lists.ofbiz.org/mailman/listinfo/users
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
>
http://lists.ofbiz.org/pipermail/users/attachments/20060621/1e7cc677/attachm
> ent-0001.htm
>
> ------------------------------
>
> Message: 6
> Date: 21 Jun 2006 09:30:26 -0000
> From: "Purani S" <puranisank at rediffmail.com>
> Subject: [OFBiz] Users - where from the body for
email is called
> To: users at lists.ofbiz.org
> Message-ID: <20060621093026.31426.qmail at
webmail47.rediffmail.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Hi,
> Where from is the body for the email message is
called. The rest of the

> informations are from backend in  the table
> "product_store_email_setting"(Send CC, BCC).
> But where from Body is called.
>
> This is a critical issue.
> I need help.
>
> Thanks and Regard
> Purani ?
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
>
http://lists.ofbiz.org/pipermail/users/attachments/20060621/bb3ada0a/attachm
> ent-0001.htm
>
> ------------------------------
>
> Message: 7
> Date: Wed, 21 Jun 2006 03:10:36 -0700
> From: BJ Freeman <bjfree at free-man.net>
> Subject: Re: [OFBiz] Users - how will email
confirmation look like
> To: OFBiz Users / Usage Discussion <users at
lists.ofbiz.org>
> Message-ID: <44991B1C.9070201 at free-man.net>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> ofbiz is configured to send to a SMTP server and Get
from either a POP3
> or IMAP server. If you need a SMTP pop3 server for
testing you can run
> apache James on the same machine.
>
> I believe the Demo data reference was more to look
at the code to see
> how to pre load the email data.
>
> There are many routines and services that support
sending and receiving
> emails.  I suggest you use a find type of program to
search for the word
>   mail on the folders and in the code. Once you see
all that I am sure
> you can figure out the rest.
>
>
> Purani S sent the following on 6/20/06 10:43 PM:
> > Hi Si chen,
> > If I need to check with the demo data, I need SMTP
server, Isn't it?

> >
> > Thanks
> > Purani
> >
> >
> >
> >
> > On Tue, 20 Jun 2006 Si Chen wrote :
> >
> >>Why don't you just try the demo data?  It should
be pretty clear.
> >>
> >>On Jun 20, 2006, at 1:24 AM, Purani S wrote:
> >>
> >>
> >>>How will email confirmation displayed in
sequoiaerp0.8.3.
> >>>Is the confirmation given as header in  the
orderconfirmation page?

> >>>
> >>>
> >>>Thanks
> >>>Purani
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>_______________________________________________
> >>>Users mailing list
> >>>Users at lists.ofbiz.org
> >>>http://lists.ofbiz.org/mailman/listinfo/users
> >>
> >>
> >>_______________________________________________
> >>Users mailing list
> >>Users at lists.ofbiz.org
> >>http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
> >
> >
------------------------------------------------------------------------

> >
> >  
> > _______________________________________________
> > Users mailing list
> > Users at lists.ofbiz.org
> > http://lists.ofbiz.org/mailman/listinfo/users
>
>
> ------------------------------
>
> Message: 8
> Date: Wed, 21 Jun 2006 12:09:56 +0200
> From: Jacques Le Roux <jacques.le.roux at
les7arts.com>
> Subject: [OFBiz] Users - Widget separator ?
> To: OFBiz Users / Usage Discussion <users at
lists.ofbiz.org>
> Message-ID: <00e201c6951a$da54b2b0$0300a8c0 at
LesArts>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Is there something in the widget that act as a
panel, frame or lign to
> separate or group fields or is FTL needed for that ?
>
> Jacques
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL:
>
http://lists.ofbiz.org/pipermail/users/attachments/20060621/0f200d4c/attachm
> ent-0001.htm
>
> ------------------------------
>
> Message: 9
> Date: Wed, 21 Jun 2006 03:38:14 -0700
> From: BJ Freeman <bjfree at free-man.net>
> Subject: Re: [OFBiz] Users - Widget separator ?
> To: OFBiz Users / Usage Discussion <users at
lists.ofbiz.org>
> Message-ID: <44992196.8080107 at free-man.net>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> This is more a Style setting in the CSS. Like
Boxhead or topbox class.
> Take a look at some of the decorators.
>
> Jacques Le Roux sent the following on 6/21/06 3:09
AM:
> > Is there something in the widget that act as a
panel, frame or lign to
> separate or group fields or is FTL needed for that ?
> >
> > Jacques
> >
> >
> >
> >
------------------------------------------------------------------------

> >
> >  
> > _______________________________________________
> > Users mailing list
> > Users at lists.ofbiz.org
> > http://lists.ofbiz.org/mailman/listinfo/users
>
>
> ------------------------------
>
> Message: 10
> Date: Wed, 21 Jun 2006 12:34:58 +0100
> From: "Alexandre Gomes" <alexandre.rijo at
gmail.com>
> Subject: Re: [OFBiz] Users - Widget separator ?
> To: "OFBiz Users / Usage Discussion" <users at
lists.ofbiz.org>
> Message-ID:
> <a08ca7ef0606210434i7f289d63sbaaea40fd9e5f5c2 at
mail.gmail.com>
> Content-Type: text/plain; charset=ISO-8859-1;
format=flowed
>
> Hi Jacques,
>
> You have this stuff you can use in the form widget.
I don't know if it
> is exactly what you need :
>
>  <sort-order>
>     <banner left-text-style="bannerleft"
left-text="&amp;nbsp;Name"/>

>     <field-group id="person" style="boxoutside">
>         <sort-field name="mcMarketingCampaignId"/>
>         <sort-field name="mcCampaignName"/>
>         <sort-field name="mcCampaignSummary"/>
>         <sort-field name="ptyPartyId"/>
>         <sort-field name="perMemberId"/>
>      </field-group>
>  </sort-order>
>
>
> Regards,
> Alex
> On 6/21/06, Jacques Le Roux <jacques.le.roux at
les7arts.com> wrote:
> >
> >
> > Is there something in the widget that act as a
panel, frame or lign to
> > separate or group fields or is FTL needed for that
?

> >
> > Jacques
> >
> > _______________________________________________
> > Users mailing list
> > Users at lists.ofbiz.org
> > http://lists.ofbiz.org/mailman/listinfo/users
> >
> >
>
>
> ------------------------------
>
>  
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
>
> End of Users Digest, Vol 23, Issue 68
> *************************************
>
>  
> _______________________________________________
> Users mailing list
> Users at lists.ofbiz.org
> http://lists.ofbiz.org/mailman/listinfo/users
--
Kind Regards
Andrew Sykes <andrew at sykesdevelopment.com>
Sykes Development Ltd
http://www.sykesdevelopment.com
 
_______________________________________________
Users mailing list
[hidden email]
http://lists.ofbiz.org/mailman/listinfo/users
Free forum by Nabble Edit this page