Re: Import Data
You can refer to applications/ecommerce/data/DemoProduct.xml. It has Demo Data for Facility, Catalog, ProductCategories, Variety of Products (Physical, Digital, Virtual and Varient, Subscription, Fin Account etc.) and the association between them. I think this will help you to understand the database structure as well. On Tue, Mar 18, 2008 at 9:10 AM, Grahame Jordan <[EMAIL PROTECTED]> wrote: > Hi, > > Thanks for your replies, they are of great help. > > So far I have written some functions in perl to take the data from the > original database and write it all in xml. > This looks good so far however I am not familiar with the requirements > of the database structure etc. > > Am I taking the right approach by creating Product_Categories -> > Products -> Price. > > > Cheers > > > Grahame > > > [EMAIL PROTECTED] wrote: > > The hard part is getting the external data into an xml format and then > into > > the ofbiz schema. Two of the approaches that work well is to make use > of > > Microsoft Access. I am not a big fan, but it is fairly easy to use. > What I > > did was to write a custom java program that generated the xml files, > used > > the Web Tools - Import to import the data into temporary tables, then > run a > > service to move the data from the temporary tables into Ofbiz. I used > the > > data import tools from Opentaps as a starting point and spent probably a > > month fine tuning them. I did it this way because I had three > businesses to > > do. For a one off, I think the Access tools are a better choice. > > > > Quickbooks has a developers toolset that can help you. > > > > Skip > > > > -Original Message- > > From: Brajesh Patel [mailto:[EMAIL PROTECTED] > > Sent: Sunday, March 16, 2008 11:08 PM > > To: user@ofbiz.apache.org > > Subject: Re: Import Data > > > > > > hi Grahame, > > > > In web tools there's a section for Entity XML Tools for > > importing and exporting data from files. For importing data from files > > you can use "XML Data Import" option. Here you'll have to specify the > > absolute path of the data file and check the options as per > > your requirements (we've used create "Dummy" FKs). > > > > Thanks & Regards > > > > On Mon, Mar 17, 2008 at 8:12 AM, Grahame Jordan <[EMAIL PROTECTED]> > wrote: > > > > > >> Hi, > >> > >> Being a noob I am just wondering how to import existing data into the > >> application. > >> > >> I have an existing product/pricelist, the sales guys are using Goldmine > >> and accounts are using Quickbooks. > >> > >> Initially I want to be using the pricelist ASAP. > >> I have the svn trunk checked out and running. > >> Many Thanks > >> > >> Grahame Jrodan > >> > >> > > > > > > > > -- > > Brajesh Patel > > HotWax Media Indore(MP) > > 09926276854 > > hotwaxmedia.com > > > > No virus found in this incoming message. > > Checked by AVG. > > Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: > 3/14/2008 > > 12:33 PM > > > > No virus found in this outgoing message. > > Checked by AVG. > > Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: > 3/14/2008 > > 12:33 PM > > > > > > -- Thanks & Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Import Data
Hi, Thanks for your replies, they are of great help. So far I have written some functions in perl to take the data from the original database and write it all in xml. This looks good so far however I am not familiar with the requirements of the database structure etc. Am I taking the right approach by creating Product_Categories -> Products -> Price. Cheers Grahame [EMAIL PROTECTED] wrote: The hard part is getting the external data into an xml format and then into the ofbiz schema. Two of the approaches that work well is to make use of Microsoft Access. I am not a big fan, but it is fairly easy to use. What I did was to write a custom java program that generated the xml files, used the Web Tools - Import to import the data into temporary tables, then run a service to move the data from the temporary tables into Ofbiz. I used the data import tools from Opentaps as a starting point and spent probably a month fine tuning them. I did it this way because I had three businesses to do. For a one off, I think the Access tools are a better choice. Quickbooks has a developers toolset that can help you. Skip -Original Message- From: Brajesh Patel [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2008 11:08 PM To: user@ofbiz.apache.org Subject: Re: Import Data hi Grahame, In web tools there's a section for Entity XML Tools for importing and exporting data from files. For importing data from files you can use "XML Data Import" option. Here you'll have to specify the absolute path of the data file and check the options as per your requirements (we've used create "Dummy" FKs). Thanks & Regards On Mon, Mar 17, 2008 at 8:12 AM, Grahame Jordan <[EMAIL PROTECTED]> wrote: Hi, Being a noob I am just wondering how to import existing data into the application. I have an existing product/pricelist, the sales guys are using Goldmine and accounts are using Quickbooks. Initially I want to be using the pricelist ASAP. I have the svn trunk checked out and running. Many Thanks Grahame Jrodan -- Brajesh Patel HotWax Media Indore(MP) 09926276854 hotwaxmedia.com No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM
Re: order shipped email
i am sure if there is any particular email sent with order shipped status. you might want to check the 'Order completed' email. this email is sent when inventory is allocated in order processing and the when the order status is changed to completed from created/approved. rohit - Original Message From: Hansen Wang <[EMAIL PROTECTED]> To: user@ofbiz.apache.org; Jacques Le Roux <[EMAIL PROTECTED]> Sent: Monday, March 17, 2008 5:59:33 PM Subject: Re: order shipped email I have been to these places. But could not find an "order shipped" email type. I have searched the java and xml files but could not locate any information about this. Does ofbiz send out an "order shipped" email once a package is shipped? Regards, Hansen On 3/17/08, Jacques Le Roux <[EMAIL PROTECTED]> wrote: > > It's set there > https://demo.hotwaxmedia.com/catalog/control/EditProductStoreEmails?productStoreId=9000 > > Jacques > > From: "Hansen Wang" <[EMAIL PROTECTED]> > > Hi, > > > > I have been going through the admin webapps looking for places where a > > shipping notification email is sent. But I was not able to find that. Is > > such function supported out of box from the admin webapps? > > > > Thanks, > > Hansen > > > Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
Re: Connecting to a legacy database (FoxPro)
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
RE: runAsync
Once again, thanks Belgin. This worked a charm. Now all we need is a way
to set a lower priority on the thread.
Skip
-Original Message-
From: Bilgin Ibryam [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 2:28 AM
To: user@ofbiz.apache.org
Subject: Re: runAsync
On Sat, 2008-03-15 at 14:19 -0700, [EMAIL PROTECTED] wrote:
> I am calling dispatcher.runAsync("computeEOQRequirements", context); from
> Is there any way to control this startup time?
You can call the service async w/o persisting it, like this:
dispatcher.runAsync("computeEOQRequirements", context, false);
Bilgin
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008
12:33 PM
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008
12:33 PM
Re: order shipped email
Thanks!
Please note that this is new feature after 4.0 since I did not see the
corresponding email type and screens in my box running ofbiz4.0.
On 3/17/08, Jacques Le Roux <[EMAIL PROTECTED]> wrote:
>
> IIRW it's "OFBiz Demo - Shipment Complete Notification #${orderId}"
>
> Look at
> component://ecommerce/widget/EmailOrderScreens.xml#ShipmentCompleteNotice
>
> Jacques
>
> From: "Hansen Wang" <[EMAIL PROTECTED]>
> >I have been to these places. But could not find an "order shipped" email
> > type. I have searched the java and xml files but could not locate any
> > information about this.
> >
> > Does ofbiz send out an "order shipped" email once a package is shipped?
> >
> > Regards,
> > Hansen
> >
> >
> > On 3/17/08, Jacques Le Roux <[EMAIL PROTECTED]> wrote:
> >>
> >> It's set there
> >>
> https://demo.hotwaxmedia.com/catalog/control/EditProductStoreEmails?productStoreId=9000
> >>
> >> Jacques
> >>
> >> From: "Hansen Wang" <[EMAIL PROTECTED]>
> >> > Hi,
> >> >
> >> > I have been going through the admin webapps looking for places where
> a
> >> > shipping notification email is sent. But I was not able to find that.
> Is
> >> > such function supported out of box from the admin webapps?
> >> >
> >> > Thanks,
> >> > Hansen
> >> >
> >>
> >
>
Re: order shipped email
IIRW it's "OFBiz Demo - Shipment Complete Notification #${orderId}"
Look at
component://ecommerce/widget/EmailOrderScreens.xml#ShipmentCompleteNotice
Jacques
From: "Hansen Wang" <[EMAIL PROTECTED]>
I have been to these places. But could not find an "order shipped" email
type. I have searched the java and xml files but could not locate any
information about this.
Does ofbiz send out an "order shipped" email once a package is shipped?
Regards,
Hansen
On 3/17/08, Jacques Le Roux <[EMAIL PROTECTED]> wrote:
It's set there
https://demo.hotwaxmedia.com/catalog/control/EditProductStoreEmails?productStoreId=9000
Jacques
From: "Hansen Wang" <[EMAIL PROTECTED]>
> Hi,
>
> I have been going through the admin webapps looking for places where a
> shipping notification email is sent. But I was not able to find that. Is
> such function supported out of box from the admin webapps?
>
> Thanks,
> Hansen
>
usually ships in 3 days
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
Re: order shipped email
I have been to these places. But could not find an "order shipped" email type. I have searched the java and xml files but could not locate any information about this. Does ofbiz send out an "order shipped" email once a package is shipped? Regards, Hansen On 3/17/08, Jacques Le Roux <[EMAIL PROTECTED]> wrote: > > It's set there > https://demo.hotwaxmedia.com/catalog/control/EditProductStoreEmails?productStoreId=9000 > > Jacques > > From: "Hansen Wang" <[EMAIL PROTECTED]> > > Hi, > > > > I have been going through the admin webapps looking for places where a > > shipping notification email is sent. But I was not able to find that. Is > > such function supported out of box from the admin webapps? > > > > Thanks, > > Hansen > > >
Re: Connecting to a legacy database (FoxPro)
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: > > > > in entityengine.xml. Sorry. > > > > 2008/3/15, Bruno Busco <[EMAIL PROTECTED]>: > > > > > > I have created it now with this content: > > > http://www.w3.org/2001/XMLSchema-instance"; > > > xsi:noNamespaceSchemaLocation=" > > > http://ofbiz.apache.org/dtds/fieldtypemodel.xsd";> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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: 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 ] > >
Shark Integration problems
While playing with the Shark Integration I found a few problems and tried to
solved them.
I used the example xpdl file provided with the Shark integration.
1) There was an error regarding the absence of SharkWorkflowSeq entity.
I added the entity, with no attributes except for the PK, and the error went
away.
2) The History button in the Process Detail List wasn't working. After
pressing it I got a blank page and an error in the console with the
following line:
Target exception: org.enhydra.shark.api.client.wfbase.BaseException: In call
to getBytes the value is not a supported type, should be byte[] or
ByteWrapper, is: java.util.HashMap
I added the following lines to the file
org.ofbiz.shark.audit.DataEventAudit
method: getNewData
line: 87
, and the error disappeared.
Object object = dataEventAudit.get(org.ofbiz.shark.SharkConstants.newData);
if(object instanceof Map) {
return (Map)object;
}
3) There was another problem related to the execution of the test blocking
service. It looks like the method wanted to wait for 30 seconds, but the
service definition specified a transaction timeout of 20 seconds, so the
service would rollback every time.
Hope it helps.
Daniel Riquelme
Re: delete a partyAndUserLogin?
You can edit through party profile and disable see " Update UserLogin Security Settings" in for instance https://demo.hotwaxmedia.com/partymgr/control/editlogin?partyId=bizadmin&userLoginId=bizadmin Jacques From: "Ryan Sweet" <[EMAIL PROTECTED]> To: Sent: Monday, March 17, 2008 5:54 PM Subject: delete a partyAndUserLogin? Is there UI for deleting a partyAndUserLogin?
Re: order shipped email
It's set there https://demo.hotwaxmedia.com/catalog/control/EditProductStoreEmails?productStoreId=9000 Jacques From: "Hansen Wang" <[EMAIL PROTECTED]> Hi, I have been going through the admin webapps looking for places where a shipping notification email is sent. But I was not able to find that. Is such function supported out of box from the admin webapps? Thanks, Hansen
Re: delete a partyAndUserLogin?
from a UI level https://demo.hotwaxmedia.com/partymgr/control/editlogin?partyId=approver&userLoginId=approver you select Enabled N as you can see the PartyID is associated with a lot of other entities. https://demo.hotwaxmedia.com/webtools/control/ViewRelations?entityName=Party so you would first have to make sure that party ID is not associated to any of them. Ryan Sweet sent the following on 3/17/2008 8:54 AM: > Is there UI for deleting a partyAndUserLogin? > > > > >
Re: Connecting to a legacy database (FoxPro)
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: > > in entityengine.xml. Sorry. > > 2008/3/15, Bruno Busco <[EMAIL PROTECTED]>: > > > > I have created it now with this content: > > http://www.w3.org/2001/XMLSchema-instance"; > > xsi:noNamespaceSchemaLocation=" > > http://ofbiz.apache.org/dtds/fieldtypemodel.xsd";> > > > > > > > > > > > > > > > > > > > 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: 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 work
RE: How to implement flexible purchase scheme
Al I didn't get this. A concrete example might be useful. Skip -Original Message- From: Al Byers [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 10:37 AM To: user@ofbiz.apache.org Subject: How to implement flexible purchase scheme We have a situation in which a company wants to purchase so many products in advance and let their employees choose, say, 2 out of 10 possible products. So if the 10 possible products all cost $50 each and the purchasing company wants to allow their 50 employees to acquire two each, that is a total outlay of $5,000 (right?) Which two products to be delivered is not specified until shipping time when the employee chooses which products they want. Any thoughts on how we can structure the order and delivery process to accomplish this? Thanks, -Al No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM
RE: Purchase requirements
You also want to set Product.requirementMethodEnumId = "PRODRQM_ATP" for all products. Alternately, you can modify the two services that deal with this to always do it depending on the store setting (which is what I did) (RequirementServices.java createAutoRequirementsForOrder() and createATPRequirementsForOrder) Skip -Original Message- From: Joel Blu [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 8:27 AM To: user@ofbiz.apache.org Subject: Re: Purchase requirements Dave Were you able to get this function working? Joel Dave Tenerowicz wrote: > > I'm finding that purchasing requirements are generated if the > requirementMethodEnumId (in Product Store) is set to "Automatic for > every sales order", but no requirements are created when set to evaluate > ATP levels. Has anyone else found this? Any ideas how to fix this > function? > > -- > Dave Tenerowicz > -- View this message in context: http://www.nabble.com/Purchase-requirements-tp12514766p16093893.html Sent from the OFBiz - User mailing list archive at Nabble.com. No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM
RE: runAsync
Thanks Bilgin.
I saw that method, but didn't think that was what I was after. I'll give it
a try.
Skip
-Original Message-
From: Bilgin Ibryam [mailto:[EMAIL PROTECTED]
Sent: Monday, March 17, 2008 2:28 AM
To: user@ofbiz.apache.org
Subject: Re: runAsync
On Sat, 2008-03-15 at 14:19 -0700, [EMAIL PROTECTED] wrote:
> I am calling dispatcher.runAsync("computeEOQRequirements", context); from
> Is there any way to control this startup time?
You can call the service async w/o persisting it, like this:
dispatcher.runAsync("computeEOQRequirements", context, false);
Bilgin
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008
12:33 PM
No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008
12:33 PM
RE: ftl refresh
Thankyou Jacques Don't know how I missed that. Skip -Original Message- From: Jacques Le Roux [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2008 3:11 PM To: user@ofbiz.apache.org Subject: Re: ftl refresh http://docs.ofbiz.org/display/OFBTECH/Apache+OFBiz+Technical+Production+Setu p+Guide#ApacheOFBizTechnicalProductionSetupGuide-CacheSettings Look at template at end end of cache.properties ;o) Jacques From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> >I am in debug mode on a complex ftl file and I am currently having to stop > and restart ofbiz for every change I make. Is there some setting or > something to not cache the ftl? > > Skip > No virus found in this outgoing message. > Checked by AVG. > Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 > 12:33 PM > No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM
RE: Import Data
The hard part is getting the external data into an xml format and then into the ofbiz schema. Two of the approaches that work well is to make use of Microsoft Access. I am not a big fan, but it is fairly easy to use. What I did was to write a custom java program that generated the xml files, used the Web Tools - Import to import the data into temporary tables, then run a service to move the data from the temporary tables into Ofbiz. I used the data import tools from Opentaps as a starting point and spent probably a month fine tuning them. I did it this way because I had three businesses to do. For a one off, I think the Access tools are a better choice. Quickbooks has a developers toolset that can help you. Skip -Original Message- From: Brajesh Patel [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2008 11:08 PM To: user@ofbiz.apache.org Subject: Re: Import Data hi Grahame, In web tools there's a section for Entity XML Tools for importing and exporting data from files. For importing data from files you can use "XML Data Import" option. Here you'll have to specify the absolute path of the data file and check the options as per your requirements (we've used create "Dummy" FKs). Thanks & Regards On Mon, Mar 17, 2008 at 8:12 AM, Grahame Jordan <[EMAIL PROTECTED]> wrote: > Hi, > > Being a noob I am just wondering how to import existing data into the > application. > > I have an existing product/pricelist, the sales guys are using Goldmine > and accounts are using Quickbooks. > > Initially I want to be using the pricelist ASAP. > I have the svn trunk checked out and running. > Many Thanks > > Grahame Jrodan > -- Brajesh Patel HotWax Media Indore(MP) 09926276854 hotwaxmedia.com No virus found in this incoming message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM No virus found in this outgoing message. Checked by AVG. Version: 7.5.519 / Virus Database: 269.21.7/1329 - Release Date: 3/14/2008 12:33 PM
How to implement flexible purchase scheme
We have a situation in which a company wants to purchase so many products in advance and let their employees choose, say, 2 out of 10 possible products. So if the 10 possible products all cost $50 each and the purchasing company wants to allow their 50 employees to acquire two each, that is a total outlay of $5,000 (right?) Which two products to be delivered is not specified until shipping time when the employee chooses which products they want. Any thoughts on how we can structure the order and delivery process to accomplish this? Thanks, -Al
delete a partyAndUserLogin?
Is there UI for deleting a partyAndUserLogin?
order shipped email
Hi, I have been going through the admin webapps looking for places where a shipping notification email is sent. But I was not able to find that. Is such function supported out of box from the admin webapps? Thanks, Hansen
Re: Purchase requirements
Dave Were you able to get this function working? Joel Dave Tenerowicz wrote: > > I'm finding that purchasing requirements are generated if the > requirementMethodEnumId (in Product Store) is set to "Automatic for > every sales order", but no requirements are created when set to evaluate > ATP levels. Has anyone else found this? Any ideas how to fix this > function? > > -- > Dave Tenerowicz > -- View this message in context: http://www.nabble.com/Purchase-requirements-tp12514766p16093893.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: inventory for a virtual product?
Ryan, Any subscription product is a Digital Good, so productTypeId="DIGITAL_GOOD" for this product. A subscription product will neither be virtual nor varient. You'll need to create a "SubscriptionResource" record and finally associate it to the "Product" using "ProductSubscriptionResource" entity. In "ProductSubscriptionResource" entity you can use fields "useTime" and "useTimeUomId" to set the Subscription Duration. On Sat, Mar 15, 2008 at 4:01 AM, Ryan Sweet <[EMAIL PROTECTED]> wrote: > I'm lost - I'm trying to create a product that is virtual - ie has no > inventory - it is a subscription account billed either monthly or yearly. > > I must be missing something because I've set the product to virtual in > the catalog, but in the store it still says that there are none of the > item in stock. > > -- Thanks & Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
How to get session information for service?
Hi all, I need to implement lock for transaction (manual pessimistic locking). I need to use sessionid to be one of parameters for lock. How can I get session information for the transaction in Java Service. Or can I have another way to do this. Finally, I knew that OFBiz provide only optimistic lock for us, right? Thanks in advance, Nattanicha
Re: inventory for a virtual product?
Ryan, Check the product with ID: GZ-NEWS-1MO It is a subscription product example. Bilgin
Re: response request redirect off-site?
Ryan, try with type="url" Bilgin
Re: runAsync
On Sat, 2008-03-15 at 14:19 -0700, [EMAIL PROTECTED] wrote:
> I am calling dispatcher.runAsync("computeEOQRequirements", context); from
> Is there any way to control this startup time?
You can call the service async w/o persisting it, like this:
dispatcher.runAsync("computeEOQRequirements", context, false);
Bilgin
