Messages

Try looking at:  http://www.konakart.com/importexport.php
Ming

Don,

In the next release we have introduced a custom button on the Customer panel that allows you to define your own URL to jump to if clicked.   It passes the user id and the session id as parameters so that access rights can be checked.   This might give you some options?   

Ming

Hi Jim,

Good - so you've successfully installed KonaKart and run the java_soap_examples successfully.   Now you have some examples of calling the KonaKart APIs using SOAP.   These examples should help you get started.

What you do from here is up to you. 

Regards,
Ming

You can also look at the javadoc :

http://www.konakart.com/javadoc/server/com/konakart/appif/ProductIf.html#getComparison()

Have you tried using the getProduct API call?

The reason I thought you'd customised the template is because in your other post you showed us your template code with an illegal syntax:

#if ($osh.getComments() != null)


There is no issue with Velocity here, it's just that you are using illegal syntax.

Read Kate's post below to find out how to test for nulls properly.

Ming

Hi,

Whilst array handling is somewhat fiddly and unsophisticated in the 1.5 version of Velocity, it is still possible to modify the OrderDetails template to reverse the order of the order status history records.

In the next release of KonaKart we will add the ListTool Velocity Add-On class to the context of the OrderDetails merge making this task, and others, a little easier.

In a subsequent release (further off than the next release of KonaKart) we will most likely ship with a version of Velocity that includes inbuilt improved Array handling (likely to come in Velocity 1.6).

For now you can achieve what you want with code such as this:

Code Select Expand

## This first bit figures out how many items in the array:

#set( $shlen = -1 )
#foreach( $ost in $order.getStatusTrail() )
#set( $shlen = $shlen + 1 )
#end


## Then we loop through in the right direction (high to low index) and pick out the right item in the internal loop

#foreach( $iter in [$shlen..0] )
#set( $counter = 0 )
#foreach( $osh in $order.getStatusTrail() )
        #if ($iter == $counter)
        <tr>
            <td class="dataTableContent" align="center">$dateTool.format('d-MMM-yyyy HH:mm:ss',$osh.getDateAdded(),$locale)</td>

#if ( $osh.isCustomerNotified() )
        <td class="dataTableContent" align="center"><img src="tick.gif" border="0" alt="Yes" title=" Yes "></td>
#else
                <td class="dataTableContent" align="center"><img src="cross.gif" border="0" alt="No" title=" No "></td>
#end

<td class="dataTableContent" align="center">$osh.getOrderStatus()</td>
            <td class="dataTableContent">$!osh.getComments()&nbsp;</td>
</tr>
            #end
#set ($counter = $counter + 1)
#end
#end

Ming

Hello,

I have just installed MySQL 5.0.58 enterprise gpl nt and KonaKart works perfectly with it.

My SQL Mode is the default, which is STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Note that this was a standard installation of MySQL - the only non-default I selected was to choose utf.

I realise this is not version 5.0.54 but at least I can validate that KonaKart works fine on the 5.0.58 Enterprise version with a standard installation.

I'm also at a loss as to what's wrong with your configuration.   I still suspect database setup/configuration of some kind since the database is the main component that was not installed by our installer (the other being java).

Regards,
Ming

Hi nitros,

Ths kk_api_call (and kk_role_tp_api_call) table is for securing role-based access to the API calls.

There are some places in KonaKart where you can supply you own callbacks - eg. http://www.konakart.com/configurationfaq.php#how_can_i_make_something_happen_when_an

What did you want to do exactly?

Regards, Ming

Hi Bob,

It's very helpful of you to provide these useful notes, thanks.

We have used these as a starting point for a new FAQ on Manual Installation.

It's now live at http://www.konakart.com/manual_installationfaq.php

Thanks again,
Ming

Hi James,

In the database URL, you have to change the word dbname with the name of your database schema.

EG: You can use a tool like MySQL Administrator to create a new schema for KonaKart, called konakart.  Then the URL would be:

jdbc:mysql://localhost:3306/konakart?zeroDateTimeBehavior=convertToNull

Leave the zeroDateTime*** on the end.  It's important for configuring MySQL functionality for KonaKart.

Regards,
Ming

Hi Bob,

Good news;  Thanks for confirming that.

Ming

Hi James,

Should I uninstall/reinstall KonaKart in the hope that it will pick up the correct parameters? I may have installed KonaKart before MYSQL was configured correctly.

I would definitely run the installer again and do not proceed until it accepts your database connection parameters.

Is there a way to find the correct databaseand/or connection parameters and then apply them?

The easiest way is by using the installer because it checks them for you, and you can keep trying different ones until you get paramters it can use.

If you get stuck, perhaps you could let us know the database connection parameters that you're using...  we might be able to spot the problem?

Regards - Ming

Hi James,

MYSQL server 5.0.45 install and java db

I'm not sure what you mean by "java db" here.  You only need one database - and MySQL 5 will be fine.

I had some trouble configuring the database parameters when installing KonaKart and the next window told me the connection failed

I cannot stress to you how much easier life will be for you if you go back and ensure you set the correct parameters during the installation.  When you do this, and the database is loaded successfully, all the configuration files will also be set correctly and KonaKart will work first time.
If you don't, you have to load the database manually and set the database parameters in the two properties files...  check the installation faq for details http://www.konakart.com/installationfaq.php   
Hint: Make sure you match the syntax of the MySQL database connection parameter examples.

How does KonaKart interface with an existing web business? is KonaKart a separate URL that links to the business?

You can decide yourself how much you wish to integrate KonaKart into your existing web site.  For example, the simplest integration would be one link in your existing website to your KonaKart store.  More work would be to merge your existing pages to your KonaKart website.   It's really up to you.

Regards,

Ming

Good stuff!   Thanks for letting us know.

We look forward to seeing your site.  Please send a link when it's ready!

Regards,
Ming