Topics

Hello
   I wish to show the total cost for the options the user has bought.
I've derived and ordertotal module but I cannot understand how to distinguish the options the user has really bought.

Hello I cannot understand how the SEO redirect is handled by struts: which struts action is triggered?

Thank you

Hello,
    which is in your opinion the best way to show specific products in the manufacturer's page?

Should I use tags? and how can I combine the SearchByManufacturerSubmitAction with FilterProductByTagsAction?

Hello,
   I wish to configure kk so that it uses the jndi connection pool defined in the container.

I've done what described in the docs http://www.konakart.com/docs/DatabaseNotes.html#JNDIDatabaseParameters and the web app start correctly but it I define the jndi pool in the container context:

Code Select Expand

<Context allowLinking="true">
<Resource name="jdbc/konakartdb"
auth="Container"
type="javax.sql.DataSource"
password="password"
url="jdbc:mysql://localhost:3306/konakart?zeroDateTimeBehavior=convertToNull"
username="root"
driverClassName="com.mysql.jdbc.Driver"
/>
<Valve className="org.apache.catalina.valves.AccessLogValve" prefix="localhost_access_log." suffix=".log" pattern="common"/>
</Context>

and remove the lines:

Code Select Expand

#torque.dsfactory.store1.datasource.driverClassName=com.mysql.jdbc.Driver
#torque.dsfactory.store1.datasource.url=jdbc:mysql://localhost:3306/konakart?zeroDateTimeBehavior=convertToNull
#torque.dsfactory.store1.datasource.username=root
#torque.dsfactory.store1.datasource.password=password

the application won't start anymore claiming:

Code Select Expand


KonaKart V6.0.0.0-C built 9:09PM 24-Jan-2012 GMT

12:41:16.964 [main] DEBUG org.apache.torque.TorqueInstance - init(org.apache.commons.configuration.PropertiesConfiguration@1c75cff)
12:41:16.969 [main] DEBUG org.apache.torque.TorqueInstance - setConfiguration(org.apache.commons.configuration.PropertiesConfiguration@1c75cff)
12:41:16.969 [main] DEBUG org.apache.torque.TorqueInstance - initialize()
12:41:16.970 [main] DEBUG org.apache.torque.TorqueInstance - setConfiguration(org.apache.commons.configuration.SubsetConfiguration@174e78a)
12:41:16.970 [main] DEBUG org.apache.torque.TorqueInstance - initAdapters(org.apache.commons.configuration.SubsetConfiguration@174e78a)
12:41:16.992 [main] DEBUG org.apache.torque.TorqueInstance - Adding mysql -> store1 as Adapter
12:41:16.999 [main] DEBUG org.apache.torque.TorqueInstance - initDataSourceFactories(org.apache.commons.configuration.SubsetConfiguration@174e78a)
12:41:16.999 [main] DEBUG org.apache.torque.TorqueInstance - handle: store1 DataSourceFactory: org.apache.torque.dsfactory.JndiDataSourceFactory
12:41:17.003 [main] DEBUG org.apache.torque.TorqueInstance - getConfiguration() = org.apache.commons.configuration.SubsetConfiguration@174e78a
12:41:17.003 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Starting initJNDI
12:41:17.003 [main] DEBUG o.a.t.d.JndiDataSourceFactory - JNDI path: jdbc/konakart-demo
12:41:17.004 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Time between context lookups: 60000
12:41:17.004 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Set jndi property: java.naming.factory.initial=org.apache.naming.java.javaURLContextFactory
12:41:17.009 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Created new InitialContext
12:41:17.009 [main] DEBUG o.a.t.d.JndiDataSourceFactory - InitialContext -------------------------------
12:41:17.009 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Environment properties:2
12:41:17.009 [main] DEBUG o.a.t.d.JndiDataSourceFactory -     java.naming.factory.initial: org.apache.naming.java.javaURLContextFactory
12:41:17.009 [main] DEBUG o.a.t.d.JndiDataSourceFactory -     java.naming.factory.url.pkgs: org.apache.naming
12:41:17.009 [main] DEBUG o.a.t.d.JndiDataSourceFactory - ----------------------------------------------
12:41:17.009 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Starting initDataSource
12:41:17.010 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Datasource class: org.apache.commons.dbcp.BasicDataSource
12:41:17.089 [main] DEBUG o.a.t.d.JndiDataSourceFactory - InitialContext -------------------------------
12:41:17.090 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Environment properties:2
12:41:17.090 [main] DEBUG o.a.t.d.JndiDataSourceFactory -     java.naming.factory.initial: org.apache.naming.java.javaURLContextFactory
12:41:17.090 [main] DEBUG o.a.t.d.JndiDataSourceFactory -     java.naming.factory.url.pkgs: org.apache.naming
12:41:17.090 [main] DEBUG o.a.t.d.JndiDataSourceFactory - ----------------------------------------------
12:41:17.090 [main] DEBUG o.a.t.d.JndiDataSourceFactory - Added sub context: jdbc
12:41:17.091 [main] DEBUG org.apache.torque.TorqueInstance - Adding the DatasourceFactory and DatabaseAdapter from database store1 onto database default
com.konakart.app.KKException: Unable to connect to the Database called null. Ensure that the database is running
and if so, check the database connection parameters in the konakart.properties file under WEB-INF/classes.


Any suggestions?

Hello,
    it seems that all orders are stored in the default currency rather than the currency that the user has choosen from the interface. Am I right?
Where can I pick the currency from in order to send it correctly to the payment gateway.

Thank you.

Hello,
   I'ld like to read the currency chosen by the current user from within a manager's code i.e. com.konakart.bl.CustomProductMgr how can I access it?

Hello,  I have been requested to implement such a scenario:

User Bob buy product X, billing:France, shipping:France -> price 100€
User Bob buy product X, billing:France, shipping:Italy -> price 90€

How can I implement this? is the enterprise edition necessary/sufficient?

Thank you.

Not complete but a good starting point

When in test mode this module send only "basic data" to the gateway, in production mode is sends:
[ul]

• customer name (*)
• 
  
  • customer email (*)
  • 
    
    • navigation language (*)
    • 
      
      • billing country (**)
      • 
        [/ul]
        
        (*) To be enabled in gestpay's backoffice panel
        (**) To be added in gestpay's backoffice panel

Hello,
    I'm developing for a new luxory eshop deployed in ms windows with ms sql server 2005.
Orders can be placed and are correclty saved into the db but when I checkout to the payment gateway I receive an exceltion

Code Select Expand


Exception Name = com.konakart.app.KKException
Exception Message = Cannot find order for Id = 9
Exception Stack Trace =
at com.konakart.bl.EmailMgr.sendOrderConfirmationEmail1(Unknown Source)
at com.konakart.app.KKEng.sendOrderConfirmationEmail1(Unknown Source)
at com.konakart.al.OrderMgr.sendOrderConfirmationEmail(Unknown Source)
at com.konakart.al.OrderMgr.saveOrder(Unknown Source)


The log states:

Code Select Expand


15-gen 10:56:18 INFO  (OrderIntegrationMgr.java:saveOrder:64) The order with id = 9 has just been saved
15-gen 10:56:18 ERROR (BaseAction.java:handleException:230) A customer has received the following exception message:
Exception Name = com.konakart.app.KKException
Exception Message = Cannot find order for Id = 9
Exception Stack Trace =
   at com.konakart.bl.EmailMgr.sendOrderConfirmationEmail1(Unknown Source)
   at com.konakart.app.KKEng.sendOrderConfirmationEmail1(Unknown Source)
   at com.konakart.al.OrderMgr.sendOrderConfirmationEmail(Unknown Source)
   at com.konakart.al.OrderMgr.saveOrder(Unknown Source)
   at com.konakart.actions.CheckoutConfirmationSubmitAction.execute(CheckoutConfirmationSubmitAction.java:133)
   at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
   at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
   at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
   at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.ajp.AjpAprProcessor.process(AjpAprProcessor.java:419)
   at org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:378)
   at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509)
   at java.lang.Thread.run(Unknown Source)
15-gen 10:56:18 ERROR (BaseAction.java:handleException:231) The full exception is:
com.konakart.app.KKException: Cannot find order for Id = 9
at com.konakart.bl.EmailMgr.sendOrderConfirmationEmail1(Unknown Source)
...



The connection url is:

torque.database.store1.adapter              = mssql
torque.dsfactory.store1.connection.driver   = net.sourceforge.jtds.jdbc.Driver
torque.dsfactory.store1.connection.url      = jdbc:jtds:sqlserver://DBSERVER:2410/dodoshop/\ISENGARDSQL2005;SelectMethod=cursor
torque.dsfactory.store1.connection.user     = dodoshop
torque.dsfactory.store1.connection.password = dodoshop

Database instance is a default ms sqlserver 2005:
* snapshopt_isolation_state = OFF
* is_read_committed_snapshot_on = 0

Any hint?

THANK YOU

I've noticed that email sent by the payment callback (com.konakart.actions.ipn.*) when payment is received/refused at in the store default locale.

I've ended up with this changes:

in BaseGateWayAction function sendOrderConfirmationMail() from:

  kkAppEng.getEng().sendOrderConfirmationEmail1(kkAppEng.getSessionId(), orderId, /* langIdForOrder */   -1, options);
to:
kkAppEng.getEng().sendOrderConfirmationEmail1(kkAppEng.getSessionId(), orderId, kkAppEng.getLangId(), options);


in CheckOutConfirmationAction() added:
  // Save Locale in order to reuse it in the email sent from the callback
  checkoutOrder.setCustom1("Navigation language id:" + kkAppEng.getLangId() + "," + kkAppEng.getLocale() );

before:
    return mapping.findForward("CheckoutConfirmation");

then in the gateway callback add

try {
   String navLang = localOrder.getCustom1();
   if (navLang != null && navLang.length() > 0) {
      // Custom1 should be something like: fixed_text:2,it_IT (see. src/appn/src/com/konakart/actions/CheckoutConfirmationAction.java)
      String[] t = navLang.substring(navLang.indexOf(":") + 1).split(",");
      kkAppEng.setLangId(new Integer(t[0]));
      String[] l = t[1].split("_");
      kkAppEng.setLocale(l[0], l[1]);
   }
} catch (Exception e) {
   log.error("Cannot initialize locale for order " + orderId + " " + e);
}

I've successfully moved gwt support from 1.5.x to 2.x.

1) Download gwt 2.x (http://code.google.com/intl/it/webtoolkit/download.html)
2) Remove lib/*
3) Copy jar files from the zip you downloaded into lib/
4) Modify build.xml replacing

Code Select Expand


<target name="run" description="Run it">
<java classname="com.google.gwt.dev.GWTShell"
      fork="true"
      maxmemory="256m"
      failonerror="true">
<arg value="-out" />
<arg value="./www/" />
<arg value="com.konakart.konakart/konakart.html" />
<classpath refid="run.path" />
</java>
</target>


with

Code Select Expand


<target name="run" description="Run it">
<java classname="com.google.gwt.dev.DevMode"
fork="true"
maxmemory="256m"
failonerror="true">
<arg value="-war" />
<arg value="./www/" />
<arg value="-startupUrl" />
<arg value="com.konakart.Konakart/Konakart.html" />
<arg value="com.konakart.Konakart" />
<classpath refid="run.path" />
</java>
</target>


Hello,
I have seen that the one-page-checkout process creates:

• a row in the customers table (customers_type = 2, app generated password)


• a row in the orders table


• no rows in the addresses

I would like if the user created through the one-page-checkout process can login back to the system to inspect the order history ... but the "Forgot Password" does not send any pwd to the user ... how can I change this beaviour?
Is there a reason to beave differentely for customers_type 2?

Thank you and ... happy new year!

Hello,
   I've noticed that the Tax Rates description isn't localized ... any suggestions on how I can manage the multilingual order confirmation page/mail ecc ecc?

Thanks!

I'm finalizing a new payment module for Banca Sella (Gestpay) and I will contribute it in the forum.

I'm facing a problem in a load balanced environment (two hosts w/ http load balancer).
The bank callback is done though the pubblic address on one of the two machines choosen in base of the load.
But as far as I can understand secret key is stored in memory so if user placed the order wile browsing on host 1 if the callback drops on host two the function call

kkAppEng.getEng().getOrderIdFromSecretKey(secretKey);

fails! :-(

If this is the case the callback will never succed if Tomcat is restarted in the meanwile.

What is the secretKey for?

If as firsts action in a new instance of a browser i go to http://localhost:8780/konakart/SetLocale_it_IT.do I am forwarded to Welcome.do with no newProducts.
If I go to http://localhost:8780/konakart/Welcome.do then to http://localhost:8780/konakart/SetLocale_it_IT.do I'm redirected back to the Welcome.do page correctly populated.

I do not want users to have to choose their interface language so I would like to define two virtual hosts such as:

• www.mysite.com --> forwards requests to Tomcat/kk


• www.mysite.it    --> redirect to www.mysite.com/konakart/SetLocale_it_IT.do

It seems that the prodMgr's newProducts property is empty at firrst access if forwarded from SetLocale_xx_XX.do

Hello,
    I've realized a payment gateway for Banca sella (Gestpay) starting from the WorldPay sources ... everything works fine but I canno send emails.

The sendOrderConfirmationMail(kkAppEng, orderId, /* success */false) function call does not receive any exception bue the local sendmail isn't called at all.

Other mail (Welcome, changepassword etc) have no prblems.

Any hint? How ca I diagnose the problem?

Thank you.

Is there a way to call the invoice url for a given order from withing the OrderMgr?
I need to automatically send a pdf  from the invoice.

Thank you.

Hello,
   is there a way to exclude a product from the catalogue for a single country/language?
I have a product I cannot show in my catalogue in Italy but can for other countries 'cause some legal stuff: excluding the visualization of the product for the Italian locale would be enough but how can I achieve it?

Thank you.

Hello,
   I'll like to copy some order info to a custom table when the order state changes to "payment received". I though the right places are:
   

Code Select Expand


package com.konakartadmin.bl;

public class AdminMyOrderIntegrationMgr extends AdminOrderIntegrationMgr {

   public void changeOrderStatus(int orderId, int currentStatus, int newStatus){
       AdminOrder o = getAdminEng().getOrderForOrderId( ??????, orderId);
...
}

to catch the order when the state has been changed by an administrator

and

Code Select Expand


package com.konakart.bl;

public class ArceseOrderIntegrationMgr extends OrderIntegrationMgr {
   
   public void changeOrderStatus(int orderId, int currentStatus, int newStatus){
OrderIf o = getEng().getOrder(??????, orderId, 1);
...
}

to catch the order when the state has been changed by a payment gateway callback .

BUT how do I get an Order having only it's ID? KKEngIf.getOrder() needs the session id of the logged user how do I find it?

Is there a better technique?

Thank you