Messages

Looks like getFormattedTotalIncTax() is deprecated.

I am getting a null result when calling AdminOrder.getFormattedTotalIncTax() using the JasperReports scriptlet below. I can see proper values in the orders_totals table.

The parameter and field values have been verified. For example, I passed an incorrect sessionId at one point and received a stack trace (as expected).

Any help is appreciated,

Bob

---------------------- JasperReports scriptlet method ----------------------------
    public String getFormattedTotals() throws JRScriptletException {
        String formattedTotals = null;
       
        KKAdminIf kkEngine = (KKAdminIf)this.getParameterValue("kkAdminEng.class");
        String sessionId = (String) this.getParameterValue("sessionId");
        Integer orderId = (Integer)this.getFieldValue("orders_orders_id");
        AdminOrder adminOrder;
        try {
            adminOrder = kkEngine.getOrderForOrderId(sessionId, orderId.intValue());
        } catch (KKAdminException e) {
            throw new RuntimeException(e);
        }
        formattedTotals = adminOrder.getFormattedTotalIncTax();
   
        return formattedTotals;
    }

Oops, I forgot to change "dbname" to the name of my database in the konakartadmin.properties file:

<konakart>/webapps/konakartadmin/WEB-INF/classes/konakartadmin.properties

You'll get an error when you run the admin tool without this change.

Bob

[Populate the database]

These are instructions for manually installing KonaKart.
The FAQ contains general KonaKart installation instructions:

http://www.konakart.com/installationfaq.php

However, these are geared for using the "set-up program" that is provided for Windows and Linux platforms. These executables do not run under Mac OS (or at least I don't know how to get them to run under Mac OS). Also, I figured it would be generally useful to provide a consolidated list of steps for performing a manual instruction.

In general, you want to follow all the documented installation instructions  EXCEPT for the "INSTALL KONAKART" section (http://www.konakart.com/installationfaq.php#Install_KonaKart) because this section assumes you are using a "set-up program" ( KonaKart-2.2.2.0-Windows-Setup.exe  or  KonaKart-2.2.2.0-Linux-Install ).

Perform all the documented installation instructions for:
* Java
* The RDBMS of your choice (MySQL in this case)

In my case, I am using MySQL and a database named "konakart". I am using Tomcat as the servlet container.

I) Populate the database

Make sure you have created an empty database instance in the RDBMS of choice as per the FAQ instructions:

In my case;
mysql> create database konakart

What is not clear from the FAQ instruction is what SQL script file to run to populate the database for a manual installation.

From http://www.konakart.com/forum/index.php/topic,302.0.html:
--------------------
To create the database run konakart_demo.sql for the database you have chosen.
---------------------


In my case:

mysql -u root -p konakart < /Users/bob/Documents/workspace/konakart/database/MySQL/konakart_demo.sql

II) Build the WAR files

1) download the zip file for manual installation as instructed here:
http://www.konakart.com/downloads.php

2) Unzip to the file to the directory of your choice.
We'll refer to this directory as <konakart>.

3) set DB name in konapart.properties
Change the string "dbname" to the name of your database (in my case "konakart") in the following file:

<konakart>/webapps/konakart/WEB-INF/classes/konakart.properties

This is documented in the "DEFINING THE DATABASE PARAMETERS" section of the installation FAQ.

4) run ant to generate the war files.

<konakart>/custom>ant
<konakart>/cusotm>ant make_wars

Detailed instruction for building the war files can be found at:
http://www.konakart.com/customizationfaq.php#How_do_I_build_the_customisable_java

III) Deploy & Test

1) deploy the WAR files
In my case I copied the .war files in <konkart>/custom/war to my tomcat "webapps" directory.

2) restart the servlet container (if necessary)
Restart Tomcat in my case.

3) test KonaKart:
Try http://localhost:8080/konakart in your browser.

I imported the script into MySQL using:

mysql -u root -p konakart < /Users/bob/Documents/workspace/konakart/database/MySQL/konakart_demo.sql

and all went well.

KonaKart is now up and running on Mac OS X.

Thank you very much!,

Bob

I am also trying to MANUALLY install KonaKart on Mac OS X. The provided installer does not run on Mac OS X so I need to do a manual install. Also, I would like to use an servlet container. After downloading the source .zip file, I have;

1) build the .war files and deployed them, and
2) created a database in MySQL

The problem is that I need to run the "standard database install script" refered to here (http://www.konakart.com/downloads.php):
-----------------------------------------------
At installation time you can choose to get the installer to load the database initialisation script for you ...
-----------------------------------------------
I see a lot of .sql files, but none appropriate for initializing the new database (see list of .sql files below).

(Q) Where is the script I need to run to initialize the database?

Any help is greatly appreciated,

Bob

:~/Documents/workspace/konakart bob$ find . -name \*.sql -print
./database/DB2/konakart_demo.sql
./database/DB2/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/DB2/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/DB2/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/DB2/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/DB2/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/DB2/upgrade_2.2.1.0_to_2.2.2.0.sql
./database/MSSqlServer/konakart_demo.sql
./database/MSSqlServer/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/MSSqlServer/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/MSSqlServer/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/MSSqlServer/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/MSSqlServer/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/MSSqlServer/upgrade_2.2.1.0_to_2.2.2.0.sql
./database/MySQL/konakart_demo.sql
./database/MySQL/konakart_supplementary_demo.sql
./database/MySQL/Paolo_Mail.sql
./database/MySQL/upgrade_2.2.0.0_to_2.2.0.1.sql
./database/MySQL/upgrade_2.2.0.1_to_2.2.0.2.sql
./database/MySQL/upgrade_2.2.0.2_to_2.2.0.3.sql
./database/MySQL/upgrade_2.2.0.3_to_2.2.0.4.sql
./database/MySQL/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/MySQL/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/MySQL/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/MySQL/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/MySQL/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/MySQL/upgrade_2.2.1.0_to_2.2.2.0.sql
./database/Oracle/konakart_demo.sql
./database/Oracle/upgrade_2.2.0.3_to_2.2.0.4.sql
./database/Oracle/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/Oracle/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/Oracle/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/Oracle/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/Oracle/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/Oracle/upgrade_2.2.1.0_to_2.2.2.0.sql
./database/PostgreSQL/konakart_demo.sql
./database/PostgreSQL/upgrade_2.2.0.0_to_2.2.0.1.sql
./database/PostgreSQL/upgrade_2.2.0.1_to_2.2.0.2.sql
./database/PostgreSQL/upgrade_2.2.0.2_to_2.2.0.3.sql
./database/PostgreSQL/upgrade_2.2.0.3_to_2.2.0.4.sql
./database/PostgreSQL/upgrade_2.2.0.4_to_2.2.0.5.sql
./database/PostgreSQL/upgrade_2.2.0.5_to_2.2.0.6.sql
./database/PostgreSQL/upgrade_2.2.0.6_to_2.2.0.7.sql
./database/PostgreSQL/upgrade_2.2.0.7_to_2.2.0.8.sql
./database/PostgreSQL/upgrade_2.2.0.8_to_2.2.1.0.sql
./database/PostgreSQL/upgrade_2.2.1.0_to_2.2.2.0.sql
:~/Documents/workspace/konakart bob$

Thanks Paolo. This has been quite helpful. The basic premise is that we want to use as much out-of-the-box KonaKart functionality as possible. After reviewing the Struts configuration and action classes, we now believe that the best approach is to simply use the KonaKart Admin Web Service (KKWSAdmin.wsdl) to push product information from the CMS (e.g. OpenCms) to KonaKart. This  differs from Design Choice #2 (above) in that we are using the entire KonaKart stack for our e-commerce solution. The CMS environment (e.g. OpenCMS) is only used for authoring product information (images, description, price, ...).

Regards,

Bob

We would like to achieve a slight variation on this architecture. I agree with Design Choice #1. The twist is regarding Design Choice #2, we would simply like to deploy the KonaKart front end (JSP) or 168 portlet as is (without porting it to OpenCms or equivalent WCM system). The benefits are; 1) we do not have to reproduce the UI funtionality, 2) we would be using a UI supported by the KonaKart community, 3) we get the best-of-breed  e-commerce functionality from KonaKart and WCM functionality from OenCms (or the like).

The problem is that we need the OPPOSITE functionality of the existing OpenCms/KonaKart integration. Specifically, we need "intercept hooks" in KonaKart to call the WCM system for:
1) product lookup and display
2) order data

Further details are listed below.

Questions:

(Q1) Are there any existing efforts to use the KonaKart UI and a WCM component for "product data"?
(Q2) Is there a "intercept hook" for pushing order data to 3rd party components?

Any help is greatly appreciated.

Regards,

Bob


Here are details from a post to magnolia-dev I posted today on this topic (in repsonse to an old thread with Paolo Sidoli:  http://www.mail-archive.com/[email]dev-list@magnolia.info[/email]/msg09229.html):
-----------------------------------------------------------------------------------------------
Paolo,


Sorry I did not see this message some time ago! I have reviewed the documentation, JavaDoc, WSDL, ... I like your approach and implementation. However, I have the OPPOSITE problem. I want to use the KonaKart UI or new 168 portlet functionality for my customers e- commerce site. The proposition is to store the "product pages" and associated metadata in Magnolia/CRX. This gives them the WCM capabilities of Magnolia combined with all the e-commerce features of KonaKart. We would not have to reproduce these UI features in our Magnolia implementation. The question becomes how do we "intercept" KonaKart request for "product pages" and redirect them to Magnolia/CRX?

It has been suggested that we implement replication functionality on Magnolia/CRX to push any "product page" changes to the location expected/used by KonaKart. I consider this a backup approach as I prefer not to have to keep two sources of data synchronized.

We have similar requirement to "intercept" KonaKart operations for persisting order data. We want to also push this data to a 3rd party application.

Any insight/efforts on your part are greatly appreciated.

Regards,

Bob
-----------------------------------------------------------------------------------------------