Messages

Using the XML loader, is it possible to import a product with a name longer than the default validation length?

I have configured the database to have a larger column length and also increased in the CustomValidation.properties but there doesn't seem to be a way to reference the file from the loader

So when I'm trying to import a product with a name longer than 64 but I get a error in com.konakart.importer.xml.ImportXMLData.validateProduct

Is there any way of customising the validation the XML importer uses?

Thanks!

That should help with the export of the data from Excel.

I intend to post how to export data from Excel so that you can import it into kokakart once i have achieved it.

A problem I have is that konakart requires each product to be defined in its own XML, if products could be define in just one AdminProductXML file with multiple nodes it would make it much easier to export from excel

I had managed to add the longer names via the database but it means that If a user wants to edit a manufacturers details they will not be able to save the the update due to the length of the name.

This would force them to update the database, to shorten the name, before they could make an update.

As Im developeing for a third part client, this isn't very practicable as they wont have access to the database

I had a look at removing the data but it starts to get complicated quickly with all of teh configuration data in the database.

What I need to have is the SQL to install konakart with the base configuration required with the adminstartor and none of the demo products, categories etc.

I had a look at the other SQL fiels included in the latest release and they seem to hint at thats what they are trying to do, but I have been unable to piece together the sequence to enable a clean install of konakart without demodata

I'm trying to enter a manufacturers name that is longer than the 32 chars.

I changed the MaximumValue for Manufacturer in the Configuration but this didnt affect it.

I had a look at the CustomValidation.properties file an it doesn't have an entry for manufacturer.name, so I tried adding it

Manufacturer.name      = 0;256

I restarted but konakart still doesn't is it not possible to extend the length of the manufacturers name in the application?

Is it possible to have a manufacturer name longer than 32

are there any DTDs available for the XML files used for loading data via the XML_io importer?

I have a spreadsheet with data in it that I'm trying to save as an XML file, so that I can upload the data into the database  and it would be easier to create the XML file if I had the DTD available as an XML map for Excel 2007

Found it, under Localizations

How do I define tags?

How do I add tags to products?

I can't see anyway of adding new tags so that they can be assigned to a product in the administration

To customise the validation for products I changed the CustomValidation.properties file in the .....konakartadmin/WEB-INF/classes and uncommentted the products.name value and changed to the value I required as stated here http://www.konakart.com/docs/CustomValidationAdminApp.html

I'm looking for some guidance on what I need to remove from the SQL script to set up a shop that does not contain any of the demo data for DVDs etc.

I extended the database field OK, but there doesn't seem to be an entry in the validation file for the products, it only has validation for the customer data.

Is the value for "Product Title" hardcoded to 64 somewhere?

I have to enter products that have titles longer than the 64 length allowed in the variable name.

Can I just update the length of the column in the database or is their some other validation that will restrict entry?

I am most likely to be using the loader to load products so will not be manually entering data

The server does have its own copy of ojdbc14.jar on the classpath and it was also contained in the lib folder of the war files for both the konakart.war and the konakartadmin.war

Once I had removed the ojdbc14.jar from the war files the I could launch the applications

Big Thanks!

I followed the konakart manual installation instructions and created the wars and deployed them to a tomcat server.

When I try to open the konkartadmin i get the following stacktrace

From my understanding it looks like it can't find the databse but looking at the konakartadmin.properties the database configuration looks correct and is the same as the install which worked correctly

any ideas?

Thanks

Craig

_msg.unknownCauseDetails


Exception Stack Trace =
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.konakartadmin.ws.KKAdminEngineMgr.getKKAdminByName(Unknown Source)
at com.konakartadmin.ws.KKAdminEngineMgr.createKKAdminEngine(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.getEng(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.getStores(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)

Exception Cause =
at oracle.sql.CharacterSet1Byte.getInstance(CharacterSet1Byte.java:86)
at oracle.sql.CharacterSetWithConverter.getInstance(CharacterSetWithConverter.java:103)
at oracle.sql.CharacterSetFactoryThin.make(CharacterSetFactoryThin.java:123)
at oracle.sql.CharacterSet.make(CharacterSet.java:440)
at oracle.jdbc.driver.DBConversion.(DBConversion.java:145)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:878)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:268)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:177)
at org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS.getPooledConnection(DriverAdapterCPDS.java:132)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.testCPDS(InstanceKeyDataSource.java:749)
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.registerPool(SharedPoolDataSource.java:202)
at org.apache.commons.dbcp.datasources.SharedPoolDataSource.getPooledConnectionAndInfo(SharedPoolDataSource.java:159)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:669)
at org.apache.commons.dbcp.datasources.InstanceKeyDataSource.getConnection(InstanceKeyDataSource.java:653)
at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:749)
at org.apache.torque.TorqueInstance.getConnection(TorqueInstance.java:727)
at org.apache.torque.Torque.getConnection(Torque.java:274)
at com.konakartadmin.bl.KKAdminBase.initTorque(Unknown Source)
at com.konakartadmin.bl.KKAdminBase.init(Unknown Source)
at com.konakartadmin.bl.KKAdmin.(Unknown Source)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.konakartadmin.ws.KKAdminEngineMgr.getKKAdminByName(Unknown Source)
at com.konakartadmin.ws.KKAdminEngineMgr.createKKAdminEngine(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.getEng(Unknown Source)
at com.konakartadmin.server.KKAdminGWTServiceImpl.getStores(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.google.gwt.user.server.rpc.RPC.invokeAndEncodeResponse(RPC.java:527)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.processCall(RemoteServiceServlet.java:164)
at com.google.gwt.user.server.rpc.RemoteServiceServlet.doPost(RemoteServiceServlet.java:86)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)