Re: Data Management
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=approveruserLoginId=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.
Re: Data Management
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.comhttps://demo.hotwaxmedia.com/partymgr/control/editlogin?partyId=approveruserLoginId=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/. 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.
Some questions on Sales Order and Sales Invoice
Hi, I have a couple of questions. 1. Let say I logged in as an admin and created an order. From the order list tab of the Order Manager, there is a list of checkboxes for the status which includes Created, Processing, Approved, Held, Completed etc. So how can I set the status of the order to Completed? Right now, I can only toggle between Approved and Held status. 2. I created a sales invoice but didn't find a field where I can add in a PO number. Have I missed anything? 3. In the sales invoice that I created, I added an product but in the overview screen, the total didn't include the tax. I have earlier setup the tax authority to include the product and added the catalog, discount and store to the tax authority. Any reference link that I can go and read up? Regards, James -- View this message in context: http://www.nabble.com/Some-questions-on-Sales-Order-and-Sales-Invoice-tp16142675p16142675.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Some questions on Sales Order and Sales Invoice
According the second question nothing has been missed. 2-When you create manually you must provide information according offline order. Usually this part is done by system, sales invoice from the merchant website are generated by the system. 3 - According this question i would like to have more information about it. But you have a picture which show how to create a sale invoice. For the first question you can't edit these status . When an order is submitted the initial status according the ERP module is created. After that the only second action you can done in the ERP is Approved. Remenber that it is a processus between the CRM and the ERP. When the shipment is planned , the new status of order is Completed. You can edit the order or shipment status in the shipement module of the ERP. Ladroge james yong wrote: Hi, I have a couple of questions. 1. Let say I logged in as an admin and created an order. From the order list tab of the Order Manager, there is a list of checkboxes for the status which includes Created, Processing, Approved, Held, Completed etc. So how can I set the status of the order to Completed? Right now, I can only toggle between Approved and Held status. 2. I created a sales invoice but didn't find a field where I can add in a PO number. Have I missed anything? 3. In the sales invoice that I created, I added an product but in the overview screen, the total didn't include the tax. I have earlier setup the tax authority to include the product and added the catalog, discount and store to the tax authority. Any reference link that I can go and read up? Regards, James http://www.nabble.com/file/p16143203/Invoice.jpg -- View this message in context: http://www.nabble.com/Some-questions-on-Sales-Order-and-Sales-Invoice-tp16142675p16143203.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Withholding tax in OFBiz
Hi all, I have to configure the system to be able to apply withholding tax. Does anybody have experience with such a task? In my situation I need to issue sales invoice. The order and invoice total amounts should include the full amount of the tax, not only the part that issuer will pay to the tax authority. The invoice also should contain information about the amount of the withholding tax. I have tried to achieve this by creating 2 TaxAuthorityRateProduct records: one for the full tax, and the second with negative percentage to handle withheld tax. In this situation GL posting is correct but the problem is that the order and invoice total amounts do not include withheld tax amount. Would someone provide a pointer how to deal with this problem? Is there better way to handle withholding taxes in OFBiz? Regards, Rashko Rejmer
Re: Connecting to a legacy database (FoxPro)
#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 __ 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 __ NOD32 2959 (20080319) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com
Always Data exporting
I want to know if there is a output file for services or job planned. For example when i plan the service Findorder( is it possible to plan it automatically?). Thanks -- View this message in context: http://www.nabble.com/Always-Data-exporting-tp16144185p16144185.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Plan services
there are a couple of approaches. I suggest you look at the orders status and tasks and how they gets their info. https://localhost:8443/ordermgr/control/main https://localhost:8443/ordermgr/control/tasklist then use a template like /applications/product/templates/shipment/FedexShipRequestTemplate.xml.ftl and how to populate it in /applications/product/src/org/ofbiz/shipment/thirdparty/fedex/FedexServices.java to generate your xml files like you want them. then write a service that you can schedule. look at the code used for this UI on how to do this. https://localhost:8443/webtools/control/runService ladroge sent the following on 3/18/2008 1:11 AM: 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
Re: Connecting to a legacy database (FoxPro)
Bruno, As an alternative to using the FoxPro ODBC driver, you can use a database that supports the FoxPro DBF format: http://www.sybase.com/products/databasemanagement/advantagedatabaseserver -Adrian Bruno Busco wrote: 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
uiLabelMap access from a service?
Does anyone know if there is a way to access a uiLabelMap (the list of local text strings, etc. associated with a language in an application /Module/config/your language here.properties) from within a service that only has access to the DispatchContext and the Map objects? What I am trying to do is return errors from a service containing localized strings. Any ideas? Thank you.
Question on xml and properties
Hi, I wanted to ask if it is possible and if it is a Good practice to use together .properties file and .xmls. For example you can keep some of your spanish labels in .properties file and the rest in .xml and if you don`t find the spanish labels in the .property file you could then search these spanish lables in the .xml.(i think right now if you don`t find them in the property file the en locale is used although spanish translations might exist in the xml) thanks : Valentina -- View this message in context: http://www.nabble.com/Question-on-xml-and-properties-tp16150163p16150163.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Connecting to a legacy database (FoxPro)
OK, i can connect OFBiz to the FoxPro DB using the jdbc-odbc bridge + microsoft odbc driver. But: if i put check-on-start=true in the database tag i get lots of the following errors: 2008-03-19 22:32:57,875 (main) [ DatabaseUtil.java:1288:ERROR] Error getting column info for column. Error was:java.sql.SQLException: Column not found I am using Windows XP. In any case OFBiz is able to access the entity through the Web tools. Adrian, thank you for suggesting the Advantage solution. For the moment i will try to use the free solution of odbc driver. - Bruno
Re: Connecting to a legacy database (FoxPro)
Hi Bruno, Can you access the entity through the webtools if you put check-on-start=false? For me, I can also access via webtools when I config the same as I told you before. Why do you need to put check-on-start=true??? Nattanicha OK, i can connect OFBiz to the FoxPro DB using the jdbc-odbc bridge + microsoft odbc driver. But: if i put check-on-start=true in the database tag i get lots of the following errors: 2008-03-19 22:32:57,875 (main) [ DatabaseUtil.java:1288:ERROR] Error getting column info for column. Error was:java.sql.SQLException: Column not found I am using Windows XP. In any case OFBiz is able to access the entity through the Web tools. Adrian, thank you for suggesting the Advantage solution. For the moment i will try to use the free solution of odbc driver. - Bruno __ NOD32 2960 (20080319) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com
Re: uiLabelMap access from a service?
Hi Peter You're not looking hard enough :-) there are a million examples of this. This example is from the first java file I opened (AgreementServices.java): errMsg = UtilProperties.getMessage(resource, AccountingDataSourceError, messageMap, locale); return ServiceUtil.returnError(errMsg); Regards Scott On 20/03/2008, Peter Felts [EMAIL PROTECTED] wrote: Does anyone know if there is a way to access a uiLabelMap (the list of local text strings, etc. associated with a language in an application /Module/config/your language here.properties) from within a service that only has access to the DispatchContext and the Map objects? What I am trying to do is return errors from a service containing localized strings. Any ideas? Thank you.
Re: uiLabelMap access from a service?
Peter, Are you writing your service in Java or Minilang?? 1) If you are writing the service in Java then you can use * org.ofbiz.base.util.UtilProperties* class and its methods to access the properties files. If you specifically want to get a map of all the properties in a field you can use *UtilProperties.getResourceBundleMap(String resource, Locale locale)* method which will return all the properties from the resource file in a Map. There are other useful methods as well which you can use according to your purpose. 2) If you are writing your service in minilang, than there are some special tags availble which adds, checks and return errors in a service which also uses localized strings from property files. The below structure can be used to return an error in a service containing a string from properties file: *add-error fail-property resource= property= / /add-error check-errors/ * There is another tag *property-to-field* which can be used to access any property from a property file in our service. If you want all the properties from a property file in a Map, than you can use *call-class-method* tag to call the static method that I suggested in first point above. On Wed, Mar 19, 2008 at 9:53 PM, Peter Felts [EMAIL PROTECTED] wrote: Does anyone know if there is a way to access a uiLabelMap (the list of local text strings, etc. associated with a language in an application /Module/config/your language here.properties) from within a service that only has access to the DispatchContext and the Map objects? What I am trying to do is return errors from a service containing localized strings. Any ideas? Thank you. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892
Re: Some questions on Sales Order and Sales Invoice
On Wed, Mar 19, 2008 at 3:53 PM, james yong [EMAIL PROTECTED] wrote: Hi, I have a couple of questions. 1. Let say I logged in as an admin and created an order. From the order list tab of the Order Manager, there is a list of checkboxes for the status which includes Created, Processing, Approved, Held, Completed etc. So how can I set the status of the order to Completed? Right now, I can only toggle between Approved and Held status. An order is said to be completed when it has been shipped. Go to the Order Detail page where you can find the link to *Quick Ship Entire Order*and other links to manually ship the order. 2. I created a sales invoice but didn't find a field where I can add in a PO number. Have I missed anything? 3. In the sales invoice that I created, I added an product but in the overview screen, the total didn't include the tax. I have earlier setup the tax authority to include the product and added the catalog, discount and store to the tax authority. Any reference link that I can go and read up? Regards, James -- View this message in context: http://www.nabble.com/Some-questions-on-Sales-Order-and-Sales-Invoice-tp16142675p16142675.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- Thanks Regards Mridul Pathak Hotwax Media http://www.hotwaxmedia.com [EMAIL PROTECTED] __ Office : 509.855.4113 Mobile : +919425926892