Re: Data Management

[Vikas Mayur]

On Tue, Mar 18, 2008 at 9:55 PM, Vikas Mayur <[EMAIL PROTECTED]> wrote:

> There is a service findOrders in OrderLookupServices that finds the
> order(s) in system depending on various input conditions.
> Check 
> https://demo.hotwaxmedia.com/ordermgr/control/findorders
> to see how it works.
> You can write a customized schedule service that calls findOrders service
> and exports all the order(s) found in the system to an xml file.
>
> You can find similar code for exporting the order lists into a xml
> structure in oagis component under specialpurpose/.



Sorry .. I mean to say you can take help from the oagis component services
to see how data is exported into a xml structure.



>
> I think you can study the oagisSendProcessShipment service as an example.
>
> Vikas
>
>
>
> On Tue, Mar 18, 2008 at 7:15 PM, ladroge <[EMAIL PROTECTED]> wrote:
>
> >
> > I have written a previous message according the services.
> > I think that i have not been explicit.
> >
> > I globally want to know how to plan each day for example and each
> > afternoon
> > all orders in a xml files.
> > According the services planned i want to know where the differents
> > results
> > for services can be accessible.
> >
> > Example : When i plan a service wich will provide all information
> > according
> > the orders, i would like to have an xml file where orders informations
> > is
> > described(if it is possible)
> >
> > Best regards
> >
> > --
> > View this message in context:
> > http://www.nabble.com/Data-Management-tp16121547p16121547.html
> > Sent from the OFBiz - User mailing list archive at Nabble.com.
> >
> >
>

Re: Data Management

[Vikas Mayur]

I think the demo sites are not working, though this is a temporary problem.
Instead you can test it on your local box with
https://localhost:8443/ordermgr/control/findorders

You can also test it from
http://docs.ofbiz.org/display/OFBIZ/Alternative+Demo+Servers

Hope this helps.

Vikas

On Tue, Mar 18, 2008 at 10:12 PM, ladroge <[EMAIL PROTECTED]> wrote:

>
> Thanks Vikas
> Have you another link to do it because the link given is not enable.
>
> Thanks
>
>
>
>
>
> Vikas Mayur-2 wrote:
> >
> > There is a service findOrders in OrderLookupServices that finds the
> > order(s)
> > in system depending on various input conditions.
> > Check
> > https://demo.hotwaxmedia.com<
> https://demo.hotwaxmedia.com/partymgr/control/editlogin?partyId=approver&userLoginId=approver
> >/ordermgr/control/findorders
> > to see how it works.
> > You can write a customized schedule service that calls findOrders
> service
> > and exports all the order(s) found in the system to an xml file.
> >
> > You can find similar code for exporting the order lists into a xml
> > structure
> > in oagis component under specialpurpose/.
> > I think you can study the oagisSendProcessShipment service as an
> example.
> >
> > Vikas
> >
> >
> > On Tue, Mar 18, 2008 at 7:15 PM, ladroge <[EMAIL PROTECTED]> wrote:
> >
> >>
> >> I have written a previous message according the services.
> >> I think that i have not been explicit.
> >>
> >> I globally want to know how to plan each day for example and each
> >> afternoon
> >> all orders in a xml files.
> >> According the services planned i want to know where the differents
> >> results
> >> for services can be accessible.
> >>
> >> Example : When i plan a service wich will provide all information
> >> according
> >> the orders, i would like to have an xml file where orders informations
> is
> >> described(if it is possible)
> >>
> >> Best regards
> >>
> >> --
> >> View this message in context:
> >> http://www.nabble.com/Data-Management-tp16121547p16121547.html
> >> Sent from the OFBiz - User mailing list archive at Nabble.com.
> >>
> >>
> >
> >
>
> --
> View this message in context:
> http://www.nabble.com/Data-Management-tp16121547p16125225.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

view the xml

[uma kuty]

Hi friends,
   
  I am new to ofbiz.I have a task.
   
  Have a textbox in ftl page.Whatever i enter in textbox,contents should be 
displayed in XML format, in the next page in browser.
   
   
  Can anyone help me..
   
   
   
   

   
-
 Now you can chat without downloading messenger. Click here to know how.

Re: findListIteratorByCondition Error

[David E Jones]

Skip,

Transactions are just as important for reading as they are for  
writing. In fact most of transaction isolation theory is concerned  
with how reads will be affected by writes.


In OFBiz all major operations are wrapped in a transaction by default,  
even rendering of screens for outgoing information (typically in a  
separate transaction than the events processing incoming data). Most  
entity engine operations get wrapped in a transaction if there is not  
one in place, but it can't do that with the EntityListIterator calls  
because the transaction needs to stay open until the ELI and the  
ResultSet associated with it is closed.


In a busy server environment you'll probably run into database errors  
related to this, but it depends on your traffic and the database you  
use.


But yes, this IS important and was added because production errors  
became common before this was added.


-David


On Mar 18, 2008, at 8:48 PM, [EMAIL PROTECTED] wrote:


Jacopo

I guess my question should be rephrased.

"Why does the author think that all  findListIteratorByCondition()  
calls
should be surrounded with a transaction, particularly in this case  
where it

is read-only."

I just want to make sure I am not missing something.  I am quite  
happy to
comment out the exception.  In this particular case, 150gigs of log  
file
were created in one service call to compute stock needs with real  
live data
from a big company.  I am trying to debug this code and need the  
regular

debug output to be sure things are going as I expect.

If I really need the begin/end, I am happy to do that, I just wanted  
to know

why.

Skip

-Original Message-
From: Jacopo Cappellato [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 7:13 PM
To: user@ofbiz.apache.org
Subject: Re: findListIteratorByCondition Error


[EMAIL PROTECTED] wrote:
More on this error.  Here is the code in GenericDelegator which  
writes the

error to the log.

   //throwing an exception is a little harsh for now, just

display

a really big error message since we want to get all of these fixed...
   Exception newE = new Exception("Stack Trace");
   Debug.logError(newE, "ERROR: Cannot do a find that  
returns an

EntityListIterator with no transaction in place. Wrap this call in a
transaction.", module);


As the author desired, it is a REALLY big error.  I was writing  
stdout to

a

file which almost filled up my hard disk with these errors.

Could the author comment on why it is important to do this:

   TransactionUtil.begin();
Map inventory =
dispatcher.runSync("getInventoryAvailableByFacility",
UtilMisc.toMap("productId", productId, "facilityId", facilityId));
   TransactionUtil.commit();

I.E. put the begin/commit around the runSync call other than just  
to avoid

filling up your hard disk?



I'd suggest to avoid redirecting stdout to a file.

Jacopo


Skip




No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date:  
3/16/2008

10:34 AM



No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date:  
3/16/2008

10:34 AM

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date:  
3/16/2008

10:34 AM

RE: findListIteratorByCondition Error

[[EMAIL PROTECTED]]

Jacopo

I guess my question should be rephrased.

"Why does the author think that all  findListIteratorByCondition() calls
should be surrounded with a transaction, particularly in this case where it
is read-only."

I just want to make sure I am not missing something.  I am quite happy to
comment out the exception.  In this particular case, 150gigs of log file
were created in one service call to compute stock needs with real live data
from a big company.  I am trying to debug this code and need the regular
debug output to be sure things are going as I expect.

If I really need the begin/end, I am happy to do that, I just wanted to know
why.

Skip

-Original Message-
From: Jacopo Cappellato [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2008 7:13 PM
To: user@ofbiz.apache.org
Subject: Re: findListIteratorByCondition Error


[EMAIL PROTECTED] wrote:
> More on this error.  Here is the code in GenericDelegator which writes the
> error to the log.
>
> //throwing an exception is a little harsh for now, just
display
> a really big error message since we want to get all of these fixed...
> Exception newE = new Exception("Stack Trace");
> Debug.logError(newE, "ERROR: Cannot do a find that returns an
> EntityListIterator with no transaction in place. Wrap this call in a
> transaction.", module);
>
>
>  As the author desired, it is a REALLY big error.  I was writing stdout to
a
> file which almost filled up my hard disk with these errors.
>
> Could the author comment on why it is important to do this:
>
> TransactionUtil.begin();
>   Map inventory =
> dispatcher.runSync("getInventoryAvailableByFacility",
> UtilMisc.toMap("productId", productId, "facilityId", facilityId));
> TransactionUtil.commit();
>
> I.E. put the begin/commit around the runSync call other than just to avoid
> filling up your hard disk?
>

I'd suggest to avoid redirecting stdout to a file.

Jacopo

> Skip
>
>
>
>
> No virus found in this outgoing message.
> Checked by AVG.
> Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date: 3/16/2008
> 10:34 AM


No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date: 3/16/2008
10:34 AM

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date: 3/16/2008
10:34 AM

Re: findListIteratorByCondition Error

[Jacopo Cappellato]

[EMAIL PROTECTED] wrote:

More on this error.  Here is the code in GenericDelegator which writes the
error to the log.

//throwing an exception is a little harsh for now, just display
a really big error message since we want to get all of these fixed...
Exception newE = new Exception("Stack Trace");
Debug.logError(newE, "ERROR: Cannot do a find that returns an
EntityListIterator with no transaction in place. Wrap this call in a
transaction.", module);


 As the author desired, it is a REALLY big error.  I was writing stdout to a
file which almost filled up my hard disk with these errors.

Could the author comment on why it is important to do this:

TransactionUtil.begin();
Map inventory =
dispatcher.runSync("getInventoryAvailableByFacility",
UtilMisc.toMap("productId", productId, "facilityId", facilityId));
TransactionUtil.commit();

I.E. put the begin/commit around the runSync call other than just to avoid
filling up your hard disk?



I'd suggest to avoid redirecting stdout to a file.

Jacopo


Skip




No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date: 3/16/2008
10:34 AM

findListIteratorByCondition Error

[[EMAIL PROTECTED]]

More on this error.  Here is the code in GenericDelegator which writes the
error to the log.

//throwing an exception is a little harsh for now, just display
a really big error message since we want to get all of these fixed...
Exception newE = new Exception("Stack Trace");
Debug.logError(newE, "ERROR: Cannot do a find that returns an
EntityListIterator with no transaction in place. Wrap this call in a
transaction.", module);


 As the author desired, it is a REALLY big error.  I was writing stdout to a
file which almost filled up my hard disk with these errors.

Could the author comment on why it is important to do this:

TransactionUtil.begin();
Map inventory =
dispatcher.runSync("getInventoryAvailableByFacility",
UtilMisc.toMap("productId", productId, "facilityId", facilityId));
TransactionUtil.commit();

I.E. put the begin/commit around the runSync call other than just to avoid
filling up your hard disk?

Skip




No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date: 3/16/2008
10:34 AM

findListIteratorByCondition error

[[EMAIL PROTECTED]]

I am getting this error:

ERROR: Cannot do a find that returns an EntityListIterator with no
transaction in place. Wrap this call in a transaction.

on a call to findListIteratorByCondition()

I don't understand why I need a transaction for this when I am just reading
data.

I don't want to put a begin/commit around it because there is nothing to
commit and that seems messy to me.

I don't want to use findByCondition because there are something over a
million records to iterate over.

Does anyone have a suggestion on what to do?

Skip
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1331 - Release Date: 3/16/2008
10:34 AM

Re: Connecting to a legacy database (FoxPro)

[Bruno Busco]

; >>>>>
> >>>>> 2008/3/15, Bruno Busco <[EMAIL PROTECTED]>:
> >>>>>
> >>>>>
> >>>>>> oops,
> >>>>>> i found the problem. I forgot to include the line:
> >>>>>> 
> >>>>>> in entityengine.xml. Sorry.
> >>>>>>
> >>>>>> 2008/3/15, Bruno Busco <[EMAIL PROTECTED]>:
> >>>>>>
> >>>>>>
> >>>>>>> I have created it now with this content:
> >>>>>>>  >>>>>>> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";
> >>>>>>> xsi:noNamespaceSchemaLocation="
> >>>>>>> http://ofbiz.apache.org/dtds/fieldtypemodel.xsd";>
> >>>>>>>   
> >>>>>>> 
> >>>>>>>  >>>>>>> java-type="java.sql.Blob
> >>>>>>> ">
> >>>>>>>
> >>>>>>> 
> >>>>>>>  >>>>>>> java-type="java.sql.Date
> >>>>>>> ">
> >>>>>>>  >>>>>>> java-type="java.sql.Time
> >>>>>>> ">
> >>>>>>>
> >>>>>>>  >>>>>>> java-type="Double"> >>>>>>> />
> >>>>>>>  >>>>>>> java-type="Double"> >>>>>>> />
> >>>>>>>  >>>>>>> java-type="Double"> >>>>>>> />
> >>>>>>>  >>>>>>> java-type="Long"> >>>>>>> />
> >>>>>>>
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>
> >>>>>>> 
> >>>>>>>  >>>>>>> java-type="String"> />
> >>>>>>>  >>>>>>> java-type="String"> >>>>>>> />
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String">
> >>>>>>>  >>>>>>> java-type="String"> >>>>>>> />
> >>>>>>>  >>>>>>> java-type="String"> >>>>>>> />
> >>>>>>>  >>>>>>> java-type="String"> >>>>>>> />
> >>>>>>>  >>>>>>> java-type="String"> >>>>>>> />
> >>>>>>> 
> >>>>>>>
> >>>>>>> but now ofbiz aborts completely. The last messages i can see is:
> >>>>>>> 2008-03-15 17:54:50,265 (main) [ModelViewEntity.java:468:WARN
> ]
> >>>>>>> Conversion for complex-alias needs to be implemented for cache and
> >>>>>>> in-memory
> >>>>>>> eval stuff to work correctly, will not work for alias:
> >>>>>>> 

ViewEntity across multiple databases?

[Peter Felts]

Hi does anyone know how I can create a join across multiple databases? I've got 
my OfBiz database (MySQL) and an external database (Oracle) which I am using in 
an OFBiz application I'm working on. What I need to do now is create a join 
across tables in both databases but a view entity will not allow this. Any 
ideas about how this could be accomplished? Should I create my own query and 
run it in a java service?

The OFBiz documentation states that you can not create a view-entity across 
multiple databases:

"All member-entitiesin aview-entity must be in the same database, but not 
necessarily in thesame entitygroup." 
(http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling)

Re: Connecting to a legacy database (FoxPro)

[Nattanicha Rittammanart]

e implemented for cache and
in-memory
eval stuff to work correctly, will not work for alias:
quantityOrdered of
view-entity OrderItemQuantityReportGroupByProduct
2008-03-15 17:54:50,406 (main) [ModelViewEntity.java:468:WARN ]
Conversion for complex-alias needs to be implemented for cache and
in-memory
eval stuff to work correctly, will not work for alias: quantityOpen


of
   

view-entity OrderItemQuantityReportGroupByProduct
2008-03-15 17:54:50,421 (main) [ModelViewEntity.java:468:WARN ]
Conversion for complex-alias needs to be implemented for cache and
in-memory
eval stuff to work correctly, will not work for alias:
quantityOrdered of
view-entity OrderItemAndShipGrpInvResAndItemSum
2008-03-15 17:54:50,421 (main) [ModelViewEntity.java:468:WARN ]
Conversion for complex-alias needs to be implemented for cache and
in-memory
eval stuff to work correctly, will not work for alias:
totQuantityAvailable
of view-entity OrderItemAndShipGrpInvResAndItemSum
2008-03-15 17:54:50,546 (main) [ModelReader.java:385:INFO ]
FINISHED LOADING ENTITIES - ALL FILES; #Entities=766


#ViewEntities=192
   

#Fields=7915 #Relationships=2640 #AutoRelationships=1947
2008-03-15 17:54:50,734 (main) [   GenericDelegator.java:148:INFO ]
Doing entity definition check...
2008-03-15 17:54:50,734 (main) [ ModelEntityChecker.java:500:INFO ]
[initReservedWords] array length=1023






2008/3/15, Jacques Le Roux <[EMAIL PROTECTED]>:

   

Did you try to create a fieldtypevisualfoxpro.xml file and put
"visualfoxpro" in field-type-name ?

Jacques

From: "Bruno Busco" <[EMAIL PROTECTED]>


 

I am working on Win XP, i have the FoxPro database and have
installed



the

 

Visual FoxPro odbc driver.
I can access the FoxPro database from Access so i know that the


odbc
   

driver

 

works well.

Now i am trying to configure ofbiz to access the FoxPro database



with the

 

following:

   
org.ofbiz.entity.datasource.GenericHelperDAO"

 

   field-type-name="mysql"
   check-on-start="true"
   add-missing-on-start="true"
   check-indices-on-start="true"
   use-foreign-keys="false"
   use-foreign-key-indices="true"
   join-style="ansi-no-parenthesis"
   alias-view-columns="false"
   always-use-constraint-keyword="true">
   
   

 

   

but I get a lot of
2008-03-15 15:27:57,625 (main) [   DatabaseUtil.java


:1288:ERROR]
   

Error

 

getting column info for column. Error was:java.sql.SQLException:



Column not

 

found

Can anybody please suggest a solution?
Could it be becouse of the field-type-name="mysql" (but in this


case
   

how can

 

i get a Visual FoxPro fieldtype file?)

Thank you
- Bruno



2008/3/15, Bruno Busco <[EMAIL PROTECTED]>:

   

Hi,
i need to make my ofbiz box retrieve products information from a

  

legacy

 

FoxPro database.
The data should be done on a regular basis (lets say every night
  

of
   

once a

 

week) so it is not just a one time data import.

Googling around i have found this
http://lists.ofbiz.org/pipermail/users/2005-May/007836.html

Is out there any more updated how-to or documentation i could
  

start
   

from?

 

Many thanks for you suggestions!

Bruno


  


__ NOD32 2953 (20080317) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com




  __ NOD32 2954 (20080318) Information __
  This message was checked by NOD32 antivirus system.
http://www.eset.com



  





__ NOD32 2956 (20080318) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com

  



__ NOD32 2956 (20080318) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com

Re: Data Management

[ladroge]

Thanks Vikas 
Have you another link to do it because the link given is not enable.

Thanks 





Vikas Mayur-2 wrote:
> 
> There is a service findOrders in OrderLookupServices that finds the
> order(s)
> in system depending on various input conditions.
> Check
> https://demo.hotwaxmedia.com/ordermgr/control/findorders
> to see how it works.
> You can write a customized schedule service that calls findOrders service
> and exports all the order(s) found in the system to an xml file.
> 
> You can find similar code for exporting the order lists into a xml
> structure
> in oagis component under specialpurpose/.
> I think you can study the oagisSendProcessShipment service as an example.
> 
> Vikas
> 
> 
> On Tue, Mar 18, 2008 at 7:15 PM, ladroge <[EMAIL PROTECTED]> wrote:
> 
>>
>> I have written a previous message according the services.
>> I think that i have not been explicit.
>>
>> I globally want to know how to plan each day for example and each
>> afternoon
>> all orders in a xml files.
>> According the services planned i want to know where the differents
>> results
>> for services can be accessible.
>>
>> Example : When i plan a service wich will provide all information
>> according
>> the orders, i would like to have an xml file where orders informations is
>> described(if it is possible)
>>
>> Best regards
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Data-Management-tp16121547p16121547.html
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>>
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Data-Management-tp16121547p16125225.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Data Management

[Vikas Mayur]

There is a service findOrders in OrderLookupServices that finds the order(s)
in system depending on various input conditions.
Check 
https://demo.hotwaxmedia.com/ordermgr/control/findorders
to see how it works.
You can write a customized schedule service that calls findOrders service
and exports all the order(s) found in the system to an xml file.

You can find similar code for exporting the order lists into a xml structure
in oagis component under specialpurpose/.
I think you can study the oagisSendProcessShipment service as an example.

Vikas


On Tue, Mar 18, 2008 at 7:15 PM, ladroge <[EMAIL PROTECTED]> wrote:

>
> I have written a previous message according the services.
> I think that i have not been explicit.
>
> I globally want to know how to plan each day for example and each
> afternoon
> all orders in a xml files.
> According the services planned i want to know where the differents results
> for services can be accessible.
>
> Example : When i plan a service wich will provide all information
> according
> the orders, i would like to have an xml file where orders informations is
> described(if it is possible)
>
> Best regards
>
> --
> View this message in context:
> http://www.nabble.com/Data-Management-tp16121547p16121547.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>

Re: Connecting to a legacy database (FoxPro)

[Nattanicha Rittammanart]

tityOrdered of
view-entity OrderItemAndShipGrpInvResAndItemSum
2008-03-15 17:54:50,421 (main) [ModelViewEntity.java:468:WARN ]
Conversion for complex-alias needs to be implemented for cache and
in-memory
eval stuff to work correctly, will not work for alias:
totQuantityAvailable
of view-entity OrderItemAndShipGrpInvResAndItemSum
2008-03-15 17:54:50,546 (main) [ModelReader.java:385:INFO ]
FINISHED LOADING ENTITIES - ALL FILES; #Entities=766


#ViewEntities=192


#Fields=7915 #Relationships=2640 #AutoRelationships=1947
2008-03-15 17:54:50,734 (main) [   GenericDelegator.java:148:INFO ]
Doing entity definition check...
2008-03-15 17:54:50,734 (main) [ ModelEntityChecker.java:500:INFO ]
[initReservedWords] array length=1023






2008/3/15, Jacques Le Roux <[EMAIL PROTECTED]>:



Did you try to create a fieldtypevisualfoxpro.xml file and put
"visualfoxpro" in field-type-name ?

Jacques

From: "Bruno Busco" <[EMAIL PROTECTED]>


  

I am working on Win XP, i have the FoxPro database and have
installed



the

  

Visual FoxPro odbc driver.
I can access the FoxPro database from Access so i know that the


odbc


driver

  

works well.

Now i am trying to configure ofbiz to access the FoxPro database



with the

  

following:

   
org.ofbiz.entity.datasource.GenericHelperDAO"

  

   field-type-name="mysql"
   check-on-start="true"
   add-missing-on-start="true"
   check-indices-on-start="true"
   use-foreign-keys="false"
   use-foreign-key-indices="true"
   join-style="ansi-no-parenthesis"
   alias-view-columns="false"
   always-use-constraint-keyword="true">
   
   

  

   

but I get a lot of
2008-03-15 15:27:57,625 (main) [   DatabaseUtil.java


:1288:ERROR]


Error

  

getting column info for column. Error was:java.sql.SQLException:



Column not

  

found

Can anybody please suggest a solution?
Could it be becouse of the field-type-name="mysql" (but in this


case


how can

  

i get a Visual FoxPro fieldtype file?)

Thank you
- Bruno



2008/3/15, Bruno Busco <[EMAIL PROTECTED]>:



Hi,
i need to make my ofbiz box retrieve products information from a

  

legacy

  

FoxPro database.
The data should be done on a regular basis (lets say every night
  

of


once a

  

week) so it is not just a one time data import.

Googling around i have found this
http://lists.ofbiz.org/pipermail/users/2005-May/007836.html

Is out there any more updated how-to or documentation i could
  

start


from?

  

Many thanks for you suggestions!

Bruno


  


__ NOD32 2953 (20080317) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com



  
__ NOD32 2954 (20080318) Information __
  
This message was checked by NOD32 antivirus system.

http://www.eset.com



  





__ NOD32 2956 (20080318) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com

  

CREATE service GetOrders

[ladroge]

I WANT TO KNOW HOW TO CREATE A SERVICE call for example Getallorders to
integrate it in my ERP and configure it to have each days the orders
informations.


Thanks 
-- 
View this message in context: 
http://www.nabble.com/CREATE-service-GetOrders-tp16124557p16124557.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: Connecting to a legacy database (FoxPro)

[Bruno Busco]

g">
> >>>>  >>>> java-type="String">
> >>>>  >>>> java-type="String">
> >>>>  >>>> java-type="String">
> >>>>  >>>> java-type="String"> >>>> />
> >>>> 
> >>>>
> >>>> but now ofbiz aborts completely. The last messages i can see is:
> >>>> 2008-03-15 17:54:50,265 (main) [ModelViewEntity.java:468:WARN ]
> >>>> Conversion for complex-alias needs to be implemented for cache and
> >>>> in-memory
> >>>> eval stuff to work correctly, will not work for alias: statusDelay of
> >>>> view-entity ExampleStatusDetail
> >>>> 2008-03-15 17:54:50,390 (main) [ModelViewEntity.java:626:INFO ]
> >>>> Throwing out field alias in view entity InventoryItemAndDetail
> >>>> because one
> >>>> already exists with the alias name [unitCost] and field name
> >>>> [IID(InventoryItemDetail).unitCost], existing field name is
> >>>> [II.unitCost
> >>>> ]
> >>>> 2008-03-15 17:54:50,406 (main) [ModelViewEntity.java:468:WARN ]
> >>>> Conversion for complex-alias needs to be implemented for cache and
> >>>> in-memory
> >>>> eval stuff to work correctly, will not work for alias:
> >>>> quantityOrdered of
> >>>> view-entity OrderItemQuantityReportGroupByItem
> >>>> 2008-03-15 17:54:50,406 (main) [ModelViewEntity.java:468:WARN ]
> >>>> Conversion for complex-alias needs to be implemented for cache and
> >>>> in-memory
> >>>> eval stuff to work correctly, will not work for alias: quantityOpen
> of
> >>>> view-entity OrderItemQuantityReportGroupByItem
> >>>> 2008-03-15 17:54:50,406 (main) [ModelViewEntity.java:468:WARN ]
> >>>> Conversion for complex-alias needs to be implemented for cache and
> >>>> in-memory
> >>>> eval stuff to work correctly, will not work for alias:
> >>>> quantityOrdered of
> >>>> view-entity OrderItemQuantityReportGroupByProduct
> >>>> 2008-03-15 17:54:50,406 (main) [ModelViewEntity.java:468:WARN ]
> >>>> Conversion for complex-alias needs to be implemented for cache and
> >>>> in-memory
> >>>> eval stuff to work correctly, will not work for alias: quantityOpen
> of
> >>>> view-entity OrderItemQuantityReportGroupByProduct
> >>>> 2008-03-15 17:54:50,421 (main) [ModelViewEntity.java:468:WARN ]
> >>>> Conversion for complex-alias needs to be implemented for cache and
> >>>> in-memory
> >>>> eval stuff to work correctly, will not work for alias:
> >>>> quantityOrdered of
> >>>> view-entity OrderItemAndShipGrpInvResAndItemSum
> >>>> 2008-03-15 17:54:50,421 (main) [ModelViewEntity.java:468:WARN ]
> >>>> Conversion for complex-alias needs to be implemented for cache and
> >>>> in-memory
> >>>> eval stuff to work correctly, will not work for alias:
> >>>> totQuantityAvailable
> >>>> of view-entity OrderItemAndShipGrpInvResAndItemSum
> >>>> 2008-03-15 17:54:50,546 (main) [ModelReader.java:385:INFO ]
> >>>> FINISHED LOADING ENTITIES - ALL FILES; #Entities=766
> #ViewEntities=192
> >>>> #Fields=7915 #Relationships=2640 #AutoRelationships=1947
> >>>> 2008-03-15 17:54:50,734 (main) [   GenericDelegator.java:148:INFO ]
> >>>> Doing entity definition check...
> >>>> 2008-03-15 17:54:50,734 (main) [ ModelEntityChecker.java:500:INFO ]
> >>>> [initReservedWords] array length=1023
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> 2008/3/15, Jacques Le Roux <[EMAIL PROTECTED]>:
> >>>>
> >>>>> Did you try to create a fieldtypevisualfoxpro.xml file and put
> >>>>> "visualfoxpro" in field-type-name ?
> >>>>>
> >>>>> Jacques
> >>>>>
> >>>>> From: "Bruno Busco" <[EMAIL PROTECTED]>
> >>>>>
> >>>>>
> >>>>>> I am working on Win XP, i have the FoxPro database and have
> >>>>>> installed
> >>>>>>
> >>>>> the
> >>>>>
> >>>>>> Visual FoxPro odbc driver.
> >>>>>> I can access the FoxPro database from Access so i know that the
> odbc
> >>>>>>
> >>>>> driver
> >>>>>
> >>>>>> works well.
> >>>>>>
> >>>>>> Now i am trying to configure ofbiz to access the FoxPro database
> >>>>>>
> >>>>> with the
> >>>>>
> >>>>>> following:
> >>>>>>
> >>>>>> >>>>>>helper-class="
> >>>>>>
> >>>>> org.ofbiz.entity.datasource.GenericHelperDAO"
> >>>>>
> >>>>>>field-type-name="mysql"
> >>>>>>check-on-start="true"
> >>>>>>add-missing-on-start="true"
> >>>>>>check-indices-on-start="true"
> >>>>>>use-foreign-keys="false"
> >>>>>>use-foreign-key-indices="true"
> >>>>>>join-style="ansi-no-parenthesis"
> >>>>>>alias-view-columns="false"
> >>>>>>always-use-constraint-keyword="true">
> >>>>>> >>>>>>jdbc-driver="sun.jdbc.odbc.JdbcOdbcDriver"
> >>>>>>jdbc-uri="jdbc:odbc:Arca2000Pro"
> >>>>>>jdbc-username=""
> >>>>>>jdbc-password=""
> >>>>>>isolation-level="ReadCommitted"
> >>>>>>pool-minsize="2"
> >>>>>>pool-maxsize="250"/>
> >>>>>>
> >>>>>
> >>>>>>
> >>>>>>
> >>>>>> but I get a lot of
> >>>>>> 2008-03-15 15:27:57,625 (main) [   DatabaseUtil.java
> :1288:ERROR]
> >>>>>>
> >>>>> Error
> >>>>>
> >>>>>> getting column info for column. Error was:java.sql.SQLException:
> >>>>>>
> >>>>> Column not
> >>>>>
> >>>>>> found
> >>>>>>
> >>>>>> Can anybody please suggest a solution?
> >>>>>> Could it be becouse of the field-type-name="mysql" (but in this
> case
> >>>>>>
> >>>>> how can
> >>>>>
> >>>>>> i get a Visual FoxPro fieldtype file?)
> >>>>>>
> >>>>>> Thank you
> >>>>>> - Bruno
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> 2008/3/15, Bruno Busco <[EMAIL PROTECTED]>:
> >>>>>>
> >>>>>>> Hi,
> >>>>>>> i need to make my ofbiz box retrieve products information from a
> >>>>>>>
> >>>>> legacy
> >>>>>
> >>>>>>> FoxPro database.
> >>>>>>> The data should be done on a regular basis (lets say every night
> of
> >>>>>>>
> >>>>> once a
> >>>>>
> >>>>>>> week) so it is not just a one time data import.
> >>>>>>>
> >>>>>>> Googling around i have found this
> >>>>>>> http://lists.ofbiz.org/pipermail/users/2005-May/007836.html
> >>>>>>>
> >>>>>>> Is out there any more updated how-to or documentation i could
> start
> >>>>>>>
> >>>>> from?
> >>>>>
> >>>>>>> Many thanks for you suggestions!
> >>>>>>>
> >>>>>>> Bruno
> >>>>>>>
> >>>>>>>
> >>>>
> >>
> >>
> >>
> >> __ NOD32 2953 (20080317) Information __
> >>
> >> This message was checked by NOD32 antivirus system.
> >> http://www.eset.com
> >>
> >>
> >
> >
>
> > __ NOD32 2954 (20080318) Information __
>
> >
> > This message was checked by NOD32 antivirus system.
> > http://www.eset.com
> >
> >
> >
>
>

Data Management

[ladroge]

I have written a previous message according the services.
I think that i have not been explicit.

I globally want to know how to plan each day for example and each afternoon
all orders in a xml files.
According the services planned i want to know where the differents results
for services can be accessible.

Example : When i plan a service wich will provide all information according
the orders, i would like to have an xml file where orders informations is
described(if it is possible)

Best regards

-- 
View this message in context: 
http://www.nabble.com/Data-Management-tp16121547p16121547.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

Re: in stock / not in stock

[Heidi Dehaes]

thanks a lot
Heidi


2008/3/18, Mridul Pathak <[EMAIL PROTECTED]>:
>
> Hi Heidi,
>
> Following steps can be used to determine if the product is in stock or
> not:
>
> 1) productType != SERVICE Or DIGITAL_GOOD
> 2) product.requireInventory = Y or empty, and if empty then
> productStore.requireInventory = Y or empty, or we can say both of them
> must
> not equals N
> 3) Check for Toat ATP (availableToPromise) in the InventoryItem for that
> product (there can be more than one InventoryItems for a product).  If it
> comes out to be less than or equal to ZERO than product is out of stock,
> else it is in stock.
>
> On Tue, Mar 18, 2008 at 3:55 PM, Vikas Mayur <[EMAIL PROTECTED]> wrote:
>
> > If I understand it right than,
> > In Stock --> Product is available in the facility / warehouse. See
> > InventoryItem entity, there are two fields
> > ATP - Available To Promise
> > QOH - Quantity On Hand
> >
> > QOH  represents items available in the facility (This also includes
> items
> > reserved for any orders (if any), that are not delivered yet)
> > ATP represents items that are available in facility for new orders.
> >
> > Vikas
> >
> >
> > Vikas
> >
> > On Tue, Mar 18, 2008 at 1:52 PM, Heidi Dehaes <[EMAIL PROTECTED]>
> > wrote:
> >
> > > Hello,
> > >
> > > What is the (detailed) procedure to follow in order to have near the
> > > product
> > > visualised the sentence: "in stock" or "not in stock"?
> > > What steps have to be done?
> > >
> > > thanks,
> > > H.
> > >
> >
>
>
>
> --
> Thanks & Regards
> Mridul Pathak
> Hotwax Media
> http://www.hotwaxmedia.com
> [EMAIL PROTECTED]
> __
> Office : 509.855.4113
> Mobile : +919425926892
>

Re: in stock / not in stock

[Mridul Pathak]

Hi Heidi,

Following steps can be used to determine if the product is in stock or not:

1) productType != SERVICE Or DIGITAL_GOOD
2) product.requireInventory = Y or empty, and if empty then
productStore.requireInventory = Y or empty, or we can say both of them must
not equals N
3) Check for Toat ATP (availableToPromise) in the InventoryItem for that
product (there can be more than one InventoryItems for a product).  If it
comes out to be less than or equal to ZERO than product is out of stock,
else it is in stock.

On Tue, Mar 18, 2008 at 3:55 PM, Vikas Mayur <[EMAIL PROTECTED]> wrote:

> If I understand it right than,
> In Stock --> Product is available in the facility / warehouse. See
> InventoryItem entity, there are two fields
> ATP - Available To Promise
> QOH - Quantity On Hand
>
> QOH  represents items available in the facility (This also includes items
> reserved for any orders (if any), that are not delivered yet)
> ATP represents items that are available in facility for new orders.
>
> Vikas
>
>
> Vikas
>
> On Tue, Mar 18, 2008 at 1:52 PM, Heidi Dehaes <[EMAIL PROTECTED]>
> wrote:
>
> > Hello,
> >
> > What is the (detailed) procedure to follow in order to have near the
> > product
> > visualised the sentence: "in stock" or "not in stock"?
> > What steps have to be done?
> >
> > thanks,
> > H.
> >
>



-- 
Thanks & Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
[EMAIL PROTECTED]
__
Office : 509.855.4113
Mobile : +919425926892

Re: Plan services

[Ashish Vijaywargiya]

You can take help of JobSandbox,RecurrenceRule & RecurrenceInfo entities for
creating scheduled job and then create the Custom Service as per as your
requirements.


On Tue, Mar 18, 2008 at 2:41 PM, ladroge <[EMAIL PROTECTED]> wrote:

>
> Hi
> I want to have every day all information about orders in my ERP.
> Can i know how to plan it in order to have each days in an XML file all
> informations about different order of the Demo company or my company.
> I know how to get informations from the database(Import or Export XML).
> My preoccupation is to know how to plan this weekly or daily or during
> some
> minutes or hours.
>
> Thanks
> --
> View this message in context:
> http://www.nabble.com/Plan-services-tp16116810p16116810.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
>


-- 
Thanks & Regards
Ashish Vijaywargiya
+919893479711

Re: in stock / not in stock

[Vikas Mayur]

If I understand it right than,
In Stock --> Product is available in the facility / warehouse. See
InventoryItem entity, there are two fields
ATP - Available To Promise
QOH - Quantity On Hand

QOH  represents items available in the facility (This also includes items
reserved for any orders (if any), that are not delivered yet)
ATP represents items that are available in facility for new orders.

Vikas


Vikas

On Tue, Mar 18, 2008 at 1:52 PM, Heidi Dehaes <[EMAIL PROTECTED]> wrote:

> Hello,
>
> What is the (detailed) procedure to follow in order to have near the
> product
> visualised the sentence: "in stock" or "not in stock"?
> What steps have to be done?
>
> thanks,
> H.
>

Re: Connecting to a legacy database (FoxPro)

[Nattanicha Rittammanart]

7836.html

Is out there any more updated how-to or documentation i could start


from?
   

Many thanks for you suggestions!

Bruno


  




__ NOD32 2953 (20080317) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com

  



__ NOD32 2954 (20080318) Information __

This message was checked by NOD32 antivirus system.
http://www.eset.com

Plan services

[ladroge]

Hi 
I want to have every day all information about orders in my ERP.
Can i know how to plan it in order to have each days in an XML file all
informations about different order of the Demo company or my company.
I know how to get informations from the database(Import or Export XML).
My preoccupation is to know how to plan this weekly or daily or during some
minutes or hours.

Thanks
-- 
View this message in context: 
http://www.nabble.com/Plan-services-tp16116810p16116810.html
Sent from the OFBiz - User mailing list archive at Nabble.com.

in stock / not in stock

[Heidi Dehaes]

Hello,

What is the (detailed) procedure to follow in order to have near the product
visualised the sentence: "in stock" or "not in stock"?
What steps have to be done?

thanks,
H.

Re: usually ships in 3 days

[Heidi Dehaes]

The last solution works.
Thanks a lot.

Heidi


2008/3/18, Mridul Pathak <[EMAIL PROTECTED]>:
>
> Check *ProductFacility* records for the products under this catalog.  I
> think you must have mentioned *daysToShip* field in this entity.  If you
> do
> not fill up this field in this entity this line won't show.  I think this
> will solve your problem.  If not, the last option to check is for *
> standardLeadTimeDays* in *SupplierProduct* entity if you have used this
> entity in any way.
>
> On Tue, Mar 18, 2008 at 3:59 AM, Heidi Dehaes <[EMAIL PROTECTED]>
> wrote:
>
> > Hello,
> >
> > I have for one catalogus with different categories the following line
> > besides the products in this categories :
> >
> > "usually ships in 3 days"
> >
> > How can i do this away?
> >
> > I don't have this mentionned near the products of the other
> catalogusses.
> >
> > thanks for help,
> > Heidi
> >
>
>
>
> --
> Thanks & Regards
> Mridul Pathak
> Hotwax Media
> http://www.hotwaxmedia.com
> [EMAIL PROTECTED]
> __
> Office : 509.855.4113
> Mobile : +919425926892
>

Re: usually ships in 3 days

[Mridul Pathak]

Check *ProductFacility* records for the products under this catalog.  I
think you must have mentioned *daysToShip* field in this entity.  If you do
not fill up this field in this entity this line won't show.  I think this
will solve your problem.  If not, the last option to check is for *
standardLeadTimeDays* in *SupplierProduct* entity if you have used this
entity in any way.

On Tue, Mar 18, 2008 at 3:59 AM, Heidi Dehaes <[EMAIL PROTECTED]>
wrote:

> Hello,
>
> I have for one catalogus with different categories the following line
> besides the products in this categories :
>
> "usually ships in 3 days"
>
> How can i do this away?
>
> I don't have this mentionned near the products of the other catalogusses.
>
> thanks for help,
> Heidi
>



-- 
Thanks & Regards
Mridul Pathak
Hotwax Media
http://www.hotwaxmedia.com
[EMAIL PROTECTED]
__
Office : 509.855.4113
Mobile : +919425926892