Re: ant run-install and mysql problems
A guess, which might be totally wrong, is that you've changed the entityengine.xml file so it is inconsistent, and now ofbiz can't find the right fieldtype file to use. I'd suggest reviewing your edits of that file. Cheers, Anne. 2009/9/4 Lucio Crusca i...@virtual-bit.com: I've tried ant run-install again with the same results, so I guess that's not a race condition. Then I ran ant again and logged the output to a file, here are the first exceptions I get: [java] 2009-09-04 08:16:23,864 (main) [ EntityDataLoader.java:130:WARN ] Could not get URL for Component ResourceHandler: org.ofbiz.base.component.ComponentException: File Resource not found: /opt/ofbiz-svn/ofbiz.9.04/themes/bizznesstime/data/BizznessTimeThemeData.xml [java] 2009-09-04 08:16:32,671 (main) [ EntitySaxReader.java:563:WARN ] [java] runtime exception report -- [java] Could not set field CurrencyDimension.dimensionId to the value _NF_ [java] Exception: java.lang.IllegalArgumentException [java] Message: Type id-ne not found [java] stack trace --- [java] java.lang.IllegalArgumentException: Type id-ne not found [java] org.ofbiz.entity.GenericEntity.setString(GenericEntity.java:461) [java] org.ofbiz.entity.util.EntitySaxReader.startElement(EntitySaxReader.java:557) [java] javolution.xml.sax.XMLReaderImpl.parseAll(Unknown Source) ... [java] 2009-09-04 08:16:32,764 (main) [ TransactionUtil.java:285:ERROR] [java] exception report -- [java] [TransactionUtil.rollback] [java] Exception: java.lang.Exception [java] Message: Stack Trace [java] stack trace --- [java] java.lang.Exception: Stack Trace [java] org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:284) [java] org.ofbiz.entity.transaction.TransactionUtil.rollback(TransactionUtil.java:266) [java] org.ofbiz.entity.util.EntitySaxReader.parse(EntitySaxReader.java:270) ... [java] 2009-09-04 08:16:32,768 (main) [ TransactionUtil.java:295:INFO ] [TransactionUtil.rollback] transaction rolled back [java] 2009-09-04 08:16:32,771 (main) [ EntityDataLoader.java:220:ERROR] [java] exception report -- [java] [install.loadData]: Error loading XML Resource file:/opt/ofbiz- svn/ofbiz.9.04/framework/common/data/DimensionTypeData.xml; Error was: A transaction error occurred reading data [java] Exception: org.xml.sax.SAXException [java] Message: A transaction error occurred reading data ... and then a few other similar exceptions, all with message Type id-ne not found. Any clue? -- Virtual Bit di Lucio Crusca http://www.virtual-bit.com -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Phone: (03) 9585 6788 Fax: (03) 9585 1086 Web: http://www.cohsoft.com.au/ Email: sa...@cohsoft.com.au Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/
Re: Where did this go?
Was looking at some of the code for header logo settings in trunk a couple of days ago. Yes, the one defined in the theme is now used instead, and there's a comment somewhere in the code that the logo field for the product store is no longer used. I presume the same applies to the style sheet, but haven't checked. The code I looked at did appear to have some other mechanism for overriding the logo defined by the theme. Didn't follow this up, but it looked like it was associated with the company settings? Cheers, Anne. 2009/9/5 Ruth Hoffman rhoff...@aesolves.com: Hi Jacques: Thanks. Anyone else care to comment? TIA Ruth Jacques Le Roux wrote: I think it's now related to Visual Themes, but just a guess Jacques From: Ruth Hoffman rhoff...@aesolves.com Hello List: Got a quick question: In 4.x releases dating back to 765601, there is a place in the Catalog Manager under store configuration where the user may enter in a style sheet and header logo for a store. By default these are set to /images/ecommain.css and /images/ofbiz_logo.jpg respectively. In the latest trunk release and 9.x releases, where did these fields go? How does one change these fields on an existing store (or a new store for that matter) using the Catalog Manager? TIA Ruth -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Phone: (03) 9585 6788 Fax: (03) 9585 1086 Web: http://www.cohsoft.com.au/ Email: sa...@cohsoft.com.au Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/
Re: RED Cross on newly created .java class file
All your classes will go in your component jar in build/lib of your component. All the required ofbiz classes/jar are already on the classpath. Have you modified your java build path ? For which classes are you getting the errors ? On Sat, Sep 5, 2009 at 1:44 AM, su2 shu...@pexsupply.com wrote: Yes I guess I just have one jar file in build/lib, I do not see new jar file for my new java class. This is what I understood from your explanation. Am I understanding correctly ? abdullah shaikh wrote: You need to put the required jars on the classpath, you can find the jars under the build/lib directory of the components, but you can still compile run ofbiz using ant as it sets the required jars on path. On Fri, Sep 4, 2009 at 11:05 PM, su2 shu...@pexsupply.com wrote: Hi All, I created new .java class file in src folder. But I am getting red cross on the file and because of that I think, I am getting red cross on all above directories too. Do anybody have any idea the reason behind this ? I really appreciate the help. Thank you. -- View this message in context: http://www.nabble.com/RED-Cross-on-newly-created-.java-class-file-tp25298736p25298736.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- View this message in context: http://www.nabble.com/RED-Cross-on-newly-created-.java-class-file-tp25298736p25301163.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: JAWR - bundling and compression for Javascript and CSS : The requested resource is not available
I've resolved the problem We have to write jawr.properties files with different names for each application, into config directory Ex. ecommerce-jawr.properties, images-jawr.properties Because just the first/last loaded jawr.properties file is taken into account Eric - Original Message - From: Eric DE MAULDE eric...@free.fr To: user@ofbiz.apache.org Sent: Tuesday, September 01, 2009 8:15 PM Subject: JAWR - bundling and compression for Javascript and CSS : The requested resource is not available Hi, Has somebody tried to implement this library : JAWR to minify, bundle and compress Javascript, CSS and CSS Image files https://jawr.dev.java.net/ I try with jawr.properties file (just for javascript files) and implemented JavascriptServlet in web.xml Into Ecommerce application, it works well, with : jawr.js.bundle.ecolib.id=/bundles/ecolib.js jawr.js.bundle.ecolib.mappings=/images/** I get the file : http://mydomain/ecommerce/images/bundles/ecolib.js Into My Application, with : jawr.js.bundle.mylib.id=/bundles/mylib.js jawr.js.bundle.mylib.mappings=/images/** If I call http://mydomain/mymountpoint/images/bundles/mylib.js = The requested resource () is not available. But http://mydomain/mymountpoint/images/bundles/ecolib.js works well I need a lot your help Tank you so much in advance Eric
Re: Where did this go?
Hi Anne: Thanks. I haven't had time to delve into the code. Seems to me like this would not be a good thing - taking away a feature in the Catalog Manager (especially something as useful as changing the logo) and replacing it with: 1) hardwiring in a configuration file 2) plus I now find out a reinstall of the seed data is required to change a theme. Does that mean a reinstall of seed data is needed to change the logo? Am I wrong? Can I still dynamically change the logo using the Catalog Manager or some other OFBiz tool? Any comments? Anyone else on the list care about stuff like this? Thanks Ruth Anne Jessel wrote: Was looking at some of the code for header logo settings in trunk a couple of days ago. Yes, the one defined in the theme is now used instead, and there's a comment somewhere in the code that the logo field for the product store is no longer used. I presume the same applies to the style sheet, but haven't checked. The code I looked at did appear to have some other mechanism for overriding the logo defined by the theme. Didn't follow this up, but it looked like it was associated with the company settings? Cheers, Anne. 2009/9/5 Ruth Hoffman rhoff...@aesolves.com: Hi Jacques: Thanks. Anyone else care to comment? TIA Ruth Jacques Le Roux wrote: I think it's now related to Visual Themes, but just a guess Jacques From: Ruth Hoffman rhoff...@aesolves.com Hello List: Got a quick question: In 4.x releases dating back to 765601, there is a place in the Catalog Manager under store configuration where the user may enter in a style sheet and header logo for a store. By default these are set to /images/ecommain.css and /images/ofbiz_logo.jpg respectively. In the latest trunk release and 9.x releases, where did these fields go? How does one change these fields on an existing store (or a new store for that matter) using the Catalog Manager? TIA Ruth
Re: Where did this go?
Le 05/09/2009 12:38, Ruth Hoffman a écrit : Hi Anne: Thanks. I haven't had time to delve into the code. Seems to me like this would not be a good thing - taking away a feature in the Catalog Manager (especially something as useful as changing the logo) and replacing it with: 1) hardwiring in a configuration file 2) plus I now find out a reinstall of the seed data is required to change a theme. Does that mean a reinstall of seed data is needed to change the logo? you can just change the logo in the database, by modifying this entry : VisualThemeResource visualThemeId=BLUELIGHT resourceTypeEnumId=VT_HDR_IMAGE_URL resourceValue=/images/ofbiz_logo.gif sequenceId=01/ Am I wrong? Can I still dynamically change the logo using the Catalog Manager or some other OFBiz tool? Any comments? Anyone else on the list care about stuff like this? ../.. -- - Erwan -
Re: Where did this go?
Hi Erwan: Understood, but that isn't my point. Unless I'm wrong, we have taken away a feature that anyone with permission could accomplish using the Catalog Manager and a form based interface and replaced that with a task that requires the following skills: The user needs to either be versed in using a text editor *and* know what file to change and where to change it Or have database experience In either case, they may also need to reinstall seed data. Not sure since I can't find it documented anywhere precisely how this is suppose to work. Am I wrong? Is there a Theme design document anywhere? Just my 2 cents. Ruth Erwan de FERRIERES wrote: Le 05/09/2009 12:38, Ruth Hoffman a écrit : Hi Anne: Thanks. I haven't had time to delve into the code. Seems to me like this would not be a good thing - taking away a feature in the Catalog Manager (especially something as useful as changing the logo) and replacing it with: 1) hardwiring in a configuration file 2) plus I now find out a reinstall of the seed data is required to change a theme. Does that mean a reinstall of seed data is needed to change the logo? you can just change the logo in the database, by modifying this entry : VisualThemeResource visualThemeId=BLUELIGHT resourceTypeEnumId=VT_HDR_IMAGE_URL resourceValue=/images/ofbiz_logo.gif sequenceId=01/ Am I wrong? Can I still dynamically change the logo using the Catalog Manager or some other OFBiz tool? Any comments? Anyone else on the list care about stuff like this? ../..
Re: JAWR - bundling and compression for Javascript and CSS : The requested resource is not available
this library, JAWR, allows to bundle and compress Javascript and CSS files ... images too in order to decrease page weight and files number So to increase its loading speed Or is there this service into OFBiz, already implemented ? Eric From: Jacques Le Roux jacques.le.r...@les7arts.com Hi Eric, Why did you need it ? Jacques From: Eric DE MAULDE eric...@free.fr I've resolved the problem We have to write jawr.properties files with different names for each application, into config directory Ex. ecommerce-jawr.properties, images-jawr.properties Because just the first/last loaded jawr.properties file is taken into account Eric - Original Message - From: Eric DE MAULDE eric...@free.fr To: user@ofbiz.apache.org Sent: Tuesday, September 01, 2009 8:15 PM Subject: JAWR - bundling and compression for Javascript and CSS : The requested resource is not available Hi, Has somebody tried to implement this library : JAWR to minify, bundle and compress Javascript, CSS and CSS Image files https://jawr.dev.java.net/ I try with jawr.properties file (just for javascript files) and implemented JavascriptServlet in web.xml Into Ecommerce application, it works well, with : jawr.js.bundle.ecolib.id=/bundles/ecolib.js jawr.js.bundle.ecolib.mappings=/images/** I get the file : http://mydomain/ecommerce/images/bundles/ecolib.js Into My Application, with : jawr.js.bundle.mylib.id=/bundles/mylib.js jawr.js.bundle.mylib.mappings=/images/** If I call http://mydomain/mymountpoint/images/bundles/mylib.js = The requested resource () is not available. But http://mydomain/mymountpoint/images/bundles/ecolib.js works well I need a lot your help Tank you so much in advance Eric
Re: JAWR - bundling and compression for Javascript and CSS : The requested resource is not available
Actually my question was, Why did you need JAWR ? Jacques From: Eric DE MAULDE eric...@free.fr I try to answer : net.jawr.web.servlet.JawrServlet need properties to configure files compression and groupings. My own application has its own JS and CSS files and need too JS and CSS files from images application. I wasn't able to dynamically implement configuration So, I've created manually each properties file (into my config directory) in order to configure JawrServlet for images application and my own application. Eric From: Jacques Le Roux jacques.le.r...@les7arts.com It was not my question : why did you need it ? Thanks Jacques From: Eric DE MAULDE eric...@free.fr this library, JAWR, allows to bundle and compress Javascript and CSS files ... images too in order to decrease page weight and files number So to increase its loading speed Or is there this service into OFBiz, already implemented ? Eric From: Jacques Le Roux jacques.le.r...@les7arts.com Hi Eric, Why did you need it ? Jacques From: Eric DE MAULDE eric...@free.fr I've resolved the problem We have to write jawr.properties files with different names for each application, into config directory Ex. ecommerce-jawr.properties, images-jawr.properties Because just the first/last loaded jawr.properties file is taken into account Eric - Original Message - From: Eric DE MAULDE eric...@free.fr To: user@ofbiz.apache.org Sent: Tuesday, September 01, 2009 8:15 PM Subject: JAWR - bundling and compression for Javascript and CSS : The requested resource is not available Hi, Has somebody tried to implement this library : JAWR to minify, bundle and compress Javascript, CSS and CSS Image files https://jawr.dev.java.net/ I try with jawr.properties file (just for javascript files) and implemented JavascriptServlet in web.xml Into Ecommerce application, it works well, with : jawr.js.bundle.ecolib.id=/bundles/ecolib.js jawr.js.bundle.ecolib.mappings=/images/** I get the file : http://mydomain/ecommerce/images/bundles/ecolib.js Into My Application, with : jawr.js.bundle.mylib.id=/bundles/mylib.js jawr.js.bundle.mylib.mappings=/images/** If I call http://mydomain/mymountpoint/images/bundles/mylib.js = The requested resource () is not available. But http://mydomain/mymountpoint/images/bundles/ecolib.js works well I need a lot your help Tank you so much in advance Eric
SQL Exception when running ant run-install for CREATE INDEX SURVEY on an IBM iSeries
Hi, I am getting this error when running ant run-install on a clean database schema. 2009-09-05 22:35:43,845 (main) [ DatabaseUtil.java:2929:ERROR] Could not create foreign key indices for entity [WorkEffortSurveyAppl]: SQL Exception while executing the following: CREATE INDEX SURVEY ON OFBIZ.WORK_EFFORT_SURVEY_APPL (SURVEY_ID) Error was: com.ibm.db2.jdbc.app.DB2SQLSyntaxErrorException: SURVEY in OFBIZ of type *FILE already exists. Has anybody else seen this error or is this somehow IBM DB2 related? -André
Re: Adding a routing element in the order process
Torstein, We do have Verification stage between picking and packing. With little customization you should be able to add associate fixed assets and party for performing this activity. Regards Anil Patel On Sep 5, 2009, at 1:23 AM, Torstein Hegbom wrote: I have a question relating to the sales-order. If I where to add a routing-task after picking and before packing and shipment, called Testing and quality control, how would I go about doing that. The work-effort would need fixed assets and a party to perform the activity. Thanks. Best regards Torstein Hegbom http://www.netbusiness.no
Re: Users with disabled accounts are still able to login
In MHO, while not permanently disabling accounts for failed logins may be desirable, this behaviour is not desirable for the admin interface. The default for the admin interface should be to permanently disable the account. David E Jones wrote: The reason for this (which is configuration in the security.properties file, BTW, and is documented in the production setup guide) is that repeated login attempts usually cause an account to be disabled, but people usually don't want permanent disabling because of the internal/ customer service headaches. Enabling after five minutes (and telling the user that will happen) still makes brute-force password guessing attacks pretty much impossible, but gives the user a way to get back in without making a phone call. -David On Jul 1, 2008, at 3:09 PM, Robert Volke wrote: Wow, that did the trick. When I first saved the Enabled flag change to N, it automatically populated the disabled date, so I deleted this date and saved the change again. Now the disabled admin can no longer login. It looks like if you simply disable an account and leave the time stamp, it will automatically enable again in 5 minutes. I'm not sure why it does this, and I didn't see a way to change the end date for the disable so I'm going to inform my users to use this work around. Thank you for all of the help, Robert Volke Bilgin Ibryam bibr...@iguanait.com 7/1/2008 3:53:22 PM Hi Robert, try to set the Enabled Flag to N WITHOUT Disabled Date Time. Bilgin This message was sent using IMP, the Internet Messaging Program. -- View this message in context: http://www.nabble.com/Users-with-disabled-accounts-are-still-able-to-login-tp18223799p25314222.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Users with disabled accounts are still able to login
you can recode the re-activation service so if there is no date it will not re-activate. snowc sent the following on 9/5/2009 7:53 PM: In MHO, while not permanently disabling accounts for failed logins may be desirable, this behaviour is not desirable for the admin interface. The default for the admin interface should be to permanently disable the account. David E Jones wrote: The reason for this (which is configuration in the security.properties file, BTW, and is documented in the production setup guide) is that repeated login attempts usually cause an account to be disabled, but people usually don't want permanent disabling because of the internal/ customer service headaches. Enabling after five minutes (and telling the user that will happen) still makes brute-force password guessing attacks pretty much impossible, but gives the user a way to get back in without making a phone call. -David On Jul 1, 2008, at 3:09 PM, Robert Volke wrote: Wow, that did the trick. When I first saved the Enabled flag change to N, it automatically populated the disabled date, so I deleted this date and saved the change again. Now the disabled admin can no longer login. It looks like if you simply disable an account and leave the time stamp, it will automatically enable again in 5 minutes. I'm not sure why it does this, and I didn't see a way to change the end date for the disable so I'm going to inform my users to use this work around. Thank you for all of the help, Robert Volke Bilgin Ibryam bibr...@iguanait.com 7/1/2008 3:53:22 PM Hi Robert, try to set the Enabled Flag to N WITHOUT Disabled Date Time. Bilgin This message was sent using IMP, the Internet Messaging Program. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator.
Products that can sell in Retail Store but not Web Store?
How to add products so that I can allow to sell in Physical Retail Store but not on Web Store? What is the best way? How about separate the products into 2 Catalogs - Common and Restricted? Add only Common Catalog to Product Store Catalogs in Catalog Manager Stores Catalogs? Could I control it on Products level rather than on Catalogs level? How to use Catalog Manager e.g. Product For: Gift Card Activation [ID:GC-001] Facitlities? -- View this message in context: http://www.nabble.com/Products-that-can-sell-in-Retail-Store-but-not-Web-Store--tp25314376p25314376.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Users with disabled accounts are still able to login
Thanks BJ, I have commented out the code in LoginServices.java. Thinking a bit deeper about the admin screen behaviour - why would admin only want to temporarily disable an account for 5 minutes? BJ Freeman wrote: you can recode the re-activation service so if there is no date it will not re-activate. snowc sent the following on 9/5/2009 7:53 PM: In MHO, while not permanently disabling accounts for failed logins may be desirable, this behaviour is not desirable for the admin interface. The default for the admin interface should be to permanently disable the account. David E Jones wrote: The reason for this (which is configuration in the security.properties file, BTW, and is documented in the production setup guide) is that repeated login attempts usually cause an account to be disabled, but people usually don't want permanent disabling because of the internal/ customer service headaches. Enabling after five minutes (and telling the user that will happen) still makes brute-force password guessing attacks pretty much impossible, but gives the user a way to get back in without making a phone call. -David On Jul 1, 2008, at 3:09 PM, Robert Volke wrote: Wow, that did the trick. When I first saved the Enabled flag change to N, it automatically populated the disabled date, so I deleted this date and saved the change again. Now the disabled admin can no longer login. It looks like if you simply disable an account and leave the time stamp, it will automatically enable again in 5 minutes. I'm not sure why it does this, and I didn't see a way to change the end date for the disable so I'm going to inform my users to use this work around. Thank you for all of the help, Robert Volke Bilgin Ibryam bibr...@iguanait.com 7/1/2008 3:53:22 PM Hi Robert, try to set the Enabled Flag to N WITHOUT Disabled Date Time. Bilgin This message was sent using IMP, the Internet Messaging Program. -- BJ Freeman http://www.businessesnetwork.com/automation http://bjfreeman.elance.com http://www.linkedin.com/profile?viewProfile=key=1237480locale=en_UStrk=tab_pro Systems Integrator. -- View this message in context: http://www.nabble.com/Users-with-disabled-accounts-are-still-able-to-login-tp18223799p25314413.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: SQL Exception when running ant run-install for CREATE INDEX SURVEY on an IBM iSeries
I see the same message with Postgresql 8.3, running java -jar ofbiz.jar -install -readers=seed,seed-initial,ext on a clean database. Cheers, Anne. 2009/9/6 André Herbst a...@softmatic.dk: Hi, I am getting this error when running ant run-install on a clean database schema. 2009-09-05 22:35:43,845 (main) [ DatabaseUtil.java:2929:ERROR] Could not create foreign key indices for entity [WorkEffortSurveyAppl]: SQL Exception while executing the following: CREATE INDEX SURVEY ON OFBIZ.WORK_EFFORT_SURVEY_APPL (SURVEY_ID) Error was: com.ibm.db2.jdbc.app.DB2SQLSyntaxErrorException: SURVEY in OFBIZ of type *FILE already exists. Has anybody else seen this error or is this somehow IBM DB2 related? -André -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Phone: (03) 9585 6788 Fax: (03) 9585 1086 Web: http://www.cohsoft.com.au/ Email: sa...@cohsoft.com.au Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/
Re: Where did this go?
Hi Ruth You got me curious, so I had a more detailed look at the code. In the standard ecommerce web pages, the logo is set to be the first found of the following: 1. a logo set for the user's session only, something to do with tracking codes in Marketing, didn't follow this up further. Haven't started trying to learn about Marketing yet :-) 2. the logo associated with the catalog (see Catalog Manager, same screen where you set the name for the catalog) 3. the logo associated with the theme. Don't know much about the first option, but I guess the one for the theme (#3) is meant to be the fallback if one hasn't been set for the catalog (#2)? Haven't actually tried any of this. I suspect what you are wanting is the one associated with the catalog. Looks like it's moved to there from the productstore. Cheers, Anne. 2009/9/5 Ruth Hoffman rhoff...@aesolves.com: Hi Erwan: Understood, but that isn't my point. Unless I'm wrong, we have taken away a feature that anyone with permission could accomplish using the Catalog Manager and a form based interface and replaced that with a task that requires the following skills: The user needs to either be versed in using a text editor *and* know what file to change and where to change it Or have database experience In either case, they may also need to reinstall seed data. Not sure since I can't find it documented anywhere precisely how this is suppose to work. Am I wrong? Is there a Theme design document anywhere? Just my 2 cents. Ruth Erwan de FERRIERES wrote: Le 05/09/2009 12:38, Ruth Hoffman a écrit : Hi Anne: Thanks. I haven't had time to delve into the code. Seems to me like this would not be a good thing - taking away a feature in the Catalog Manager (especially something as useful as changing the logo) and replacing it with: 1) hardwiring in a configuration file 2) plus I now find out a reinstall of the seed data is required to change a theme. Does that mean a reinstall of seed data is needed to change the logo? you can just change the logo in the database, by modifying this entry : VisualThemeResource visualThemeId=BLUELIGHT resourceTypeEnumId=VT_HDR_IMAGE_URL resourceValue=/images/ofbiz_logo.gif sequenceId=01/ Am I wrong? Can I still dynamically change the logo using the Catalog Manager or some other OFBiz tool? Any comments? Anyone else on the list care about stuff like this? ../.. -- Coherent Software Australia Pty Ltd PO Box 2773 Cheltenham Vic 3192 Phone: (03) 9585 6788 Fax: (03) 9585 1086 Web: http://www.cohsoft.com.au/ Email: sa...@cohsoft.com.au Bonsai ERP, the all-inclusive ERP system http://www.bonsaierp.com.au/