Messages

Hi Kate,

            Thanks for ur comments n reply..I will make d changes said and jst update u.
S i've changed my KKIMPORTER.properties.I've changed....

           1.webservice_endpoint according to my port...
           2.My eng_userid and eng_password for my workin database...

Except these i've changed nothing else,is dis changes make any pbm 2 import..

Thanks,
Karthi

Hi Ryan,

I've attached my text file for ur reference....

K Ryan i'll try n update u..

[header line]

Hi Ryan,
       Thanx 4 ur reply.This s my header line for my database,

v_products_id   v_products_model   v_products_image   v_products_name_1   v_products_description_1   v_products_name_2   v_products_description_2   v_products_name_3   v_products_description_3   v_products_price   v_products_weight   v_date_avail   v_date_added   v_products_quantity   v_manufacturers_name   v_categories_name_1   v_categories_name_2   v_categories_name_3   v_tax_class_id   v_status   v_invisible   v_type   EOREOR

and dis s my record that fails,

1   Samosa   prod_samosa.jpg   samosa   "Homemade crisp patties, stuffed with fresh potatoes & peas."   samosa   samosa   samosa   samosa   3.5   0   25/10/2007   25/10/2007   91    Restaurant   Vegetarian   Appetizers      1   active   0   0   EOREOR


Thanks,
Karthi

[ERRORS]

Hi 2 Konakartians,
    I've just started to do import my bulk product using KKIMPORTER. ExportFromKKUsingEng is working fine.I am able to get all my product details in a text file(exportedDataEng.txt)....
            Now im trying 2 import using d same text file(exportedDataEng.txt) to my konakart database.But while doing this using ImportFromKKUsingEng, im gettin followin errors....

ERRORS:

D:\Program Files\Apache Software Foundation\Tomcat 5.5\import_export>java -cp %I
MP_EXP_CLASSPATH% com.konakart.importer.ImportRunner exportedDataEng.txt false
Properties file found = /D:/Program%20Files/Apache%20Software%20Foundation/Tomca
t%205.5/import_export/classes/kkImporter.properties
20-Dec 17:48:52 INFO  (KKAdmin.java:init:237) Finished Initialising Log4j
20-Dec 17:48:52 INFO  (KKAdmin.java:init:240) The configuration file being used
is /D:/Program%20Files/Apache%20Software%20Foundation/Tomcat%205.5/import_export
/classes/konakartadmin.properties
20-Dec 17:48:52 INFO  (KKAdmin.java:init:245) Initialising KKAdmin
20-Dec 17:48:52 INFO  (KKAdmin.java:initKonakart:467) KonaKart Admin V2.2.0.7 bu
ilt 10:57AM 22-Oct-2007 BST
20-Dec 17:48:52 INFO  (KKAdmin.java:init:247) Finished Initialising KonaKartAdmi
n
20-Dec 17:48:52 INFO  (KKAdmin.java:init:253) Initialising Torque
20-Dec 17:48:53 INFO  (KKTorque.java:init:53) Initialising KonaKart-Torque for o
rg.apache.torque.adapter.DBMM
20-Dec 17:48:53 INFO  (KKAdmin.java:init:266) Finished Initialising Torque
20-Dec 17:48:53 WARN  (AdminSecurityMgr.java:login:137) User 'admin' has just lo
gged in to the Admin App
20-Dec 17:48:53 INFO  (?:init:?) Using data file : /D:/Program%20Files/Apache%20
Software%20Foundation/Tomcat%205.5/import_export/exportedDataEng.txt
20-Dec 17:48:53 INFO  (?:init:?) New Line Substitution = <br>
20-Dec 17:48:53 ERROR (?:doImport:?) java.sql.SQLException: Incorrect arguments
to mysql_stmt_execute<br>Exception Stack Trace = <br>   at org.apache.torque.uti
l.BasePeer.throwTorqueException(BasePeer.java:106)<br>   at org.apache.torque.ut
il.BasePeer.insertOrUpdateRecord(BasePeer.java:653)<br>   at org.apache.torque.u
til.BasePeer.doInsert(BasePeer.java:531)<br>   at com.konakartadmin.bl.AdminProd
uctMgr.insertProduct(AdminProductMgr.java:152)<br>   at com.konakartadmin.bl.KKA
dmin.insertProduct(KKAdmin.java:2471)<br>   at com.konakart.importer.ImportData.
insertOrEdit(Unknown Source)<br>   at com.konakart.importer.ImportData.validate(
Unknown Source)<br>   at com.konakart.importer.ImportData.importMap(Unknown Sour
ce)<br>   at com.konakart.importer.ImportController.processDataLine(Unknown Sour
ce)<br>   at com.konakart.importer.ImportController.processDataFile(Unknown Sour
ce)<br>   at com.konakart.importer.ImportController.doImport(Unknown Source)<br>
   at com.konakart.importer.ImportRunner.main(Unknown Source)<br><br>Exception C
ause = <br>   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)<b
r>   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)<br>   at com.
mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)<br>   at com.mysql.jdbc.Server
PreparedStatement.serverExecute(ServerPreparedStatement.java:1169)<br>   at com.
mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:
693)<br>   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.j
ava:1404)<br>   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatem
ent.java:1318)<br>   at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedS
tatement.java:1303)<br>   at com.workingdogs.village.Record.saveWithInsert(Recor
d.java:420)<br>   at com.workingdogs.village.Record.save(Record.java:231)<br>
at com.workingdogs.village.Record.save(Record.java:198)<br>   at org.apache.torq
ue.util.BasePeer.insertOrUpdateRecord(BasePeer.java:650)<br>   at org.apache.tor
que.util.BasePeer.doInsert(BasePeer.java:531)<br>   at com.konakartadmin.bl.Admi
nProductMgr.insertProduct(AdminProductMgr.java:152)<br>   at com.konakartadmin.b
l.KKAdmin.insertProduct(KKAdmin.java:2471)<br>   at com.konakart.importer.Import
Data.insertOrEdit(Unknown Source)<br>   at com.konakart.importer.ImportData.vali
date(Unknown Source)<br>   at com.konakart.importer.ImportData.importMap(Unknown
Source)<br>   at com.konakart.importer.ImportController.processDataLine(Unknown
Source)<br>   at com.konakart.importer.ImportController.processDataFile(Unknown
Source)<br>   at com.konakart.importer.ImportController.doImport(Unknown Source
)<br>   at com.konakart.importer.ImportRunner.main(Unknown Source)
Exception in thread "main" com.konakartadmin.app.KKAdminException: java.sql.SQLE
xception: Incorrect arguments to mysql_stmt_execute<br>Exception Stack Trace = <
br>   at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:106)
<br>   at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:653
)<br>   at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:531)<br>   at
com.konakartadmin.bl.AdminProductMgr.insertProduct(AdminProductMgr.java:152)<br>
   at com.konakartadmin.bl.KKAdmin.insertProduct(KKAdmin.java:2471)<br>   at com
.konakart.importer.ImportData.insertOrEdit(Unknown Source)<br>   at com.konakart
.importer.ImportData.validate(Unknown Source)<br>   at com.konakart.importer.Imp
ortData.importMap(Unknown Source)<br>   at com.konakart.importer.ImportControlle
r.processDataLine(Unknown Source)<br>   at com.konakart.importer.ImportControlle
r.processDataFile(Unknown Source)<br>   at com.konakart.importer.ImportControlle
r.doImport(Unknown Source)<br>   at com.konakart.importer.ImportRunner.main(Unkn
own Source)<br><br>Exception Cause = <br>   at com.mysql.jdbc.SQLError.createSQL
Exception(SQLError.java:946)<br>   at com.mysql.jdbc.MysqlIO.checkErrorPacket(My
sqlIO.java:2870)<br>   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)<
br>   at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStat
ement.java:1169)<br>   at com.mysql.jdbc.ServerPreparedStatement.executeInternal
(ServerPreparedStatement.java:693)<br>   at com.mysql.jdbc.PreparedStatement.exe
cuteUpdate(PreparedStatement.java:1404)<br>   at com.mysql.jdbc.PreparedStatemen
t.executeUpdate(PreparedStatement.java:1318)<br>   at com.mysql.jdbc.PreparedSta
tement.executeUpdate(PreparedStatement.java:1303)<br>   at com.workingdogs.villa
ge.Record.saveWithInsert(Record.java:420)<br>   at com.workingdogs.village.Recor
d.save(Record.java:231)<br>   at com.workingdogs.village.Record.save(Record.java
:198)<br>   at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.jav
a:650)<br>   at org.apache.torque.util.BasePeer.doInsert(BasePeer.java:531)<br>
  at com.konakartadmin.bl.AdminProductMgr.insertProduct(AdminProductMgr.java:152
)<br>   at com.konakartadmin.bl.KKAdmin.insertProduct(KKAdmin.java:2471)<br>   a
t com.konakart.importer.ImportData.insertOrEdit(Unknown Source)<br>   at com.kon
akart.importer.ImportData.validate(Unknown Source)<br>   at com.konakart.importe
r.ImportData.importMap(Unknown Source)<br>   at com.konakart.importer.ImportCont
roller.processDataLine(Unknown Source)<br>   at com.konakart.importer.ImportCont
roller.processDataFile(Unknown Source)<br>   at com.konakart.importer.ImportCont
roller.doImport(Unknown Source)<br>   at com.konakart.importer.ImportRunner.main
(Unknown Source)
        at com.konakartadmin.bl.KKAdmin.insertProduct(KKAdmin.java:2476)
        at com.konakart.importer.ImportData.insertOrEdit(Unknown Source)
        at com.konakart.importer.ImportData.validate(Unknown Source)
        at com.konakart.importer.ImportData.importMap(Unknown Source)
        at com.konakart.importer.ImportController.processDataLine(Unknown Source
)
        at com.konakart.importer.ImportController.processDataFile(Unknown Source
)
        at com.konakart.importer.ImportController.doImport(Unknown Source)
        at com.konakart.importer.ImportRunner.main(Unknown Source)

              So,any one can suggest me 2 rectify dis error....
Thanks,
Karthi

Hi Trevor,
            Thanx again..I'll try it .

hi,
                          Thanx 4 ur reply..but i need to display the field..if i change customer details it only hide it frm customer..

Thanks,
Karthi

[required]

Hi,
   In CustomerRegistration form,i've changed my date of birth field as non-mandatory(just removed required value for field in validation.xml)and displayed.I've also changed my dob field value NOTNULL as null in my database.

          Now if i enter all d values in form except my dob field...it shows an exception message as follows



Exception Name = com.konakart.app.KKException
Exception Message = The Date parameter called birthDate must be given a value. It cannot be set to null.
Exception Stack Trace =
at com.konakart.bl.BaseMgr.checkRequired(BaseMgr.java:255)
at com.konakart.bl.CustomerMgr.registerCustomer(CustomerMgr.java:115)
at com.konakart.app.KKEng.registerCustomer(KKEng.java:655)
at com.konakart.al.CustomerMgr.registerCustomer(CustomerMgr.java:337)
at com.percipient.actions.CustomerRegistrationSubmitAction.execute(CustomerRegistrationSubmitAction.java:97)
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.doPost(ActionServlet.java:432)
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.Http11AprProcessor.process(Http11AprProcessor.java:833)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Unknown Source)

Can any one help me to solve dis error...

Thanx
Karthi

Hi Trevor,
              Thanx..I've gone through it and got a clear picture

Karthi

Hi,
   I have to know which interface is used to generate E-mail once i confirmed my order and whether the contents of email are property file or source code...

Can anyone guide me...

Thanx
Karthi

Hi,
    Thanx 4 ur kind reply..I'll just try it out

[(https://www.sandbox.paypal.com/cgi-bin/webscr)]

Hi,
   I am using PayPal as my payment module. I've created a buyer and seller test account in PayPal. When i confirm a order, the page is redirected to payment gateway of PayPal(https://www.sandbox.paypal.com/cgi-bin/webscr), where i have to enter my buyer user id and password.Finally, payment gets transacted to sellers account and order is confirmed.These happens when i'm already login to PayPal .

             But without logging to PayPal,when i confirm a order the page is redirected to home page of PayPal(https://developer.paypal.com).There i can't able to enter my buyer's test account details(user id & pwd) to complete my order.

           is there any settings in admin panel to redirect the page only to the page where i 've to enter only my buyers test account details....

Thanx
Karthikeyan
                 

Hi ,

Thanx
Karthikeyan

[cart item]

Hi,
   I have to add a product to my Cart.But before adding i have to check stock of a selected product and if der s stock i have to add.There is interface cart item where i can check stock level after adding it to cart..is there any interface to check stock of selected product before...

Can anyone help me...
ThanX.
Karthikeyan

HI,
   Can any one help me to know about one page checkout feature in konakart.


Thanks,
Karthikeyan