Re: ant run-install and mysql problems

2009-09-05 Thread Anne Jessel
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?

2009-09-05 Thread Anne Jessel
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

2009-09-05 Thread Abdullah Shaikh
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

2009-09-05 Thread Eric DE MAULDE

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?

2009-09-05 Thread Ruth Hoffman

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?

2009-09-05 Thread Erwan de FERRIERES



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?

2009-09-05 Thread Ruth Hoffman

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

2009-09-05 Thread Eric DE MAULDE
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

2009-09-05 Thread Jacques Le Roux
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

2009-09-05 Thread André Herbst
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

2009-09-05 Thread Anil Patel

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

2009-09-05 Thread snowc

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

2009-09-05 Thread BJ Freeman
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?

2009-09-05 Thread ngterry

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

2009-09-05 Thread snowc

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

2009-09-05 Thread Anne Jessel
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?

2009-09-05 Thread Anne Jessel
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/