You can find the scheduled jobs from "webtools" -> "jobs". The related database tables are JobSandbox, RecurrenceRule and RecurrenceInfo. One of the configured job from seed is "Order Auto-Cancel" which is defined in applications/order/data/OrderScheduledServices.xml.
Regards, Hansen On 3/17/08, Bruno Busco <[EMAIL PROTECTED]> wrote: > > Now i can access the Visual Fox Pro database from within ofbiz (using a > demo > version of the jdbc driver from http://www.hxtt.com). > I have defined a new entity and i can browse the VFP table using the OFBiz > entity manager. That's cool! > > In order to have the OFBiz regularly updated from the external database I > should now write a service that transfer information from the external > entities to the product and price in OFBiz, am i correct? > > Could someone please indicate where i can find some similar tasks in OFBiz > where i could start from? > I mean: > - how to write a task or service to transfer information between entities > in > OFBiz? > - how to schedule to have this task run automatically. > > Many thanks in advance. > -Bruno > > > 2008/3/15, Bruno Busco <[EMAIL PROTECTED]>: > > > > oops, > > i found the problem. I forgot to include the line: > > <field-type name="visualfoxpro" loader="fieldfile" location=" > > fieldtypevisualfoxpro.xml"/> > > in entityengine.xml. Sorry. > > > > 2008/3/15, Bruno Busco <[EMAIL PROTECTED]>: > > > > > > I have created it now with this content: > > > <fieldtypemodel xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > > > xsi:noNamespaceSchemaLocation=" > > > http://ofbiz.apache.org/dtds/fieldtypemodel.xsd";> > > > <!-- ===================== field-type-def ==================== --> > > > <!-- General Types --> > > > <field-type-def type="blob" sql-type="C" java-type="java.sql.Blob > > > "></field-type-def> > > > > > > <field-type-def type="date-time" sql-type="T" java-type=" > > > java.sql.Timestamp"></field-type-def> > > > <field-type-def type="date" sql-type="D" java-type="java.sql.Date > > > "></field-type-def> > > > <field-type-def type="time" sql-type="T" java-type="java.sql.Time > > > "></field-type-def> > > > > > > <field-type-def type="currency-amount" sql-type="N(18,2)" > > > java-type="Double"><validate method="isSignedDouble" > /></field-type-def> > > > <field-type-def type="currency-precise" sql-type="N(18,3)" > > > java-type="Double"><validate method="isSignedDouble" > /></field-type-def> > > > <field-type-def type="floating-point" sql-type="F" > > > java-type="Double"><validate method="isSignedDouble" > /></field-type-def> > > > <field-type-def type="numeric" sql-type="I" > > > java-type="Long"><validate method="isSignedLong" /></field-type-def> > > > > > > <field-type-def type="id" sql-type="C(20)" > > > java-type="String"></field-type-def> > > > <field-type-def type="id-long" sql-type="C(60)" > > > java-type="String"></field-type-def> > > > <field-type-def type="id-vlong" sql-type="C(250)" > > > java-type="String"></field-type-def> > > > > > > <field-type-def type="indicator" sql-type="C(1)" > > > java-type="String"></field-type-def> > > > <field-type-def type="very-short" sql-type="C(10)" > > > java-type="String"></field-type-def> > > > <field-type-def type="short-varchar" sql-type="C(60)" > > > java-type="String"></field-type-def> > > > <field-type-def type="long-varchar" sql-type="C(255)" > > > java-type="String"></field-type-def> > > > <field-type-def type="very-long" sql-type="TEXT" > > > java-type="String"></field-type-def> > > > > > > <field-type-def type="comment" sql-type="C(255)" > > > java-type="String"></field-type-def> > > > <field-type-def type="description" sql-type="C(255)" > > > java-type="String"></field-type-def> > > > <field-type-def type="name" sql-type="C(100)" > > > java-type="String"></field-type-def> > > > <field-type-def type="value" sql-type="C(255)" > > > java-type="String"></field-type-def> > > > > > > <!-- Specialized Types --> > > > <field-type-def type="credit-card-number" sql-type="C(255)" > > > java-type="String"><validate method="isAnyCard" /></field-type-def> > > > <field-type-def type="credit-card-date" sql-type="C(20)" > > > java-type="String"><validate method="isDateAfterToday" > /></field-type-def> > > > <field-type-def type="email" sql-type="C(255)" > > > java-type="String"><validate method="isEmail" /></field-type-def> > > > <field-type-def type="url" sql-type="C(255)" > > > java-type="String"></field-type-def> > > > <field-type-def type="id-ne" sql-type="C(20)" > > > java-type="String"><validate method="isNotEmpty" /></field-type-def> > > > <field-type-def type="id-long-ne" sql-type="C(60)" > > > java-type="String"><validate method="isNotEmpty" /></field-type-def> > > > <field-type-def type="id-vlong-ne" sql-type="C(250)" > > > java-type="String"><validate method="isNotEmpty" /></field-type-def> > > > <field-type-def type="tel-number" sql-type="C(60)" > > > java-type="String"><validate method="isInternationalPhoneNumber" > > > /></field-type-def> > > > </fieldtypemodel> > > > > > > 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: > > > > > > > > > > <datasource name="odbcfoxpro" > > > > > 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"> > > > > > <inline-jdbc > > > > > jdbc-driver="sun.jdbc.odbc.JdbcOdbcDriver" > > > > > jdbc-uri="jdbc:odbc:Arca2000Pro" > > > > > jdbc-username="" > > > > > jdbc-password="" > > > > > isolation-level="ReadCommitted" > > > > > pool-minsize="2" > > > > > pool-maxsize="250"/> > > > > > <!-- <jndi-jdbc jndi-server-name="localjndi" > > > > > jndi-name="java:/MySqlDataSource" isolation-level="Serializable"/> > > > > --> > > > > > </datasource> > > > > > > > > > > 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 > > > > >> > > > > > > > > > > > > > > > > > >
