Kryptronic Software Support Forum

You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.

#1 07-22-2009 07:22:27

garykva
Member
Registered: 07-22-2009
Posts: 46

CCP V6 CSV Import Errors

Hello,

I have a mild problem. I get the error below alot.

I am running Win2003, MYSQL, PHP.

I took an exported version of "ccp0_prod", left all columns alone.
Filled the rows with inventory and saved as a CSV
I have tried Excel 2003 as well as Excel 2007 with little success.
I even went as far as Submitting a Raw SQL statement and getting rid of "delete from ccp0_prod"
Then attempting to import the ccp0_prod file again (650 lines).
The server I am attempting to load the stuff on has plenty of bandwidth and storage, and the workstations have varied, but most offer at least 15/2mbs connections.

The kicker here is , lets say out of 50 tries, it accepts the file twice. So it has me scratching my head.

===
Error:

Warning: All Raw Database Admin functions are unguided. Deletion of and changes to system data, tables and table columns can result in making this software inoperable. Be careful.


Fatal error: Cannot use object of type KHXCerror as array in H:\xxxxxx\xxxxx\xxxxx\core\KHXC_BackEnd\ext\rawdb.php on line 3251

-End
===

Took out the exact path but left the error. I assume most may say its that the file is not a CSV. If thats the case, maybe I shouldn't be using Microsoft Office to input my data...what works better ? Is there a conversion tool that takes a CSV created by Excel and makes it "more compatible" for CCP ?


I am not one to ask for much help, usually try to work it out. This is just a bit frustrating at times....

Offline

 

#2 07-22-2009 07:36:52

garykva
Member
Registered: 07-22-2009
Posts: 46

Re: CCP V6 CSV Import Errors

I have verified that it was saved as a CSV. I have verified that the columns are all there, and there are no extra spaces in front or behind the cells.

id, name, prodnum, pricestatus, regprice, saleprice, volprice, voltext, recurprice, whlprice, affilcomm, keywords, descshort, desclong, skinoverride, lgdisp, reldisptype, reldispnum, prodmulti, imgsm, imglg, imgxl, splashdisp, newdisp, specialsdisp, bestselldisp, featuredisp, taxstateprov, taxcountry, useinv, invlevel, addemtext, delmethod, customship, dlfile, shiponename, shiponeprice, shiptwoname, shiptwoprice, shipthreename, shipthreeprice, shiplocal, shipint, shiplength, shipwidth, shipheight, shipweight, shipnumbox, shipstateprov, shipcountry, shipzip, shipemail, xcat, xprod, xprodoptions, sortorder, sortprice, prodidx, prodview, prodviewg, minquan, maxquan

There are no special charecters no copyright, no registered symbols of any type. there are dimensions for shipping in 1/2, 1/4 and otherwise, but nothing too extreme. I have even went to the extent of changing all weight and size dimensions to whole numbers, follwed by in. and even inches. The pounds have been tried as lb. , lbs , lbs.

here is a header example:

id,name,prodnum,pricestatus, regprice,saleprice,volprice,voltext,recurprice,whlprice,affilcomm,keywords,descshort,desclong,skinoverride,lgdisp,reldisptype,reldispnum,prodmulti,imgsm,imglg,imgxl,splashdisp,newdisp,specialsdisp,bestselldisp,featuredisp,taxstateprov, taxcountry ,useinv,invlevel,addemtext,delmethod,customship,dlfile,shiponename,shiponeprice,shiptwoname,shiptwoprice,shipthreename,shipthreeprice,shiplocal,shipint,shiplength,shipwidth,shipheight,shipweight,shipnumbox,shipstateprov,shipcountry,shipzip,shipemail,xcat,xprod,xprodoptions,sortorder,sortprice,prodidx,prodview,prodviewg,minquan,maxquan

here is a single row:
GSML2104-4,Anaheim Angels 1 Liter Macho Mug - Primary Logo,89006649567,R,27.95,,,,,,,"Anaheim,Angels,Gifts,Baseball,Football,College,MLB,NFL,NHL,NBA,NCAA,Teams,bar,glassware,merchandise,autographs,autographed,memorabilia",Anaheim Angels 1 Liter Macho Mug Primary Logo. This is the LARGEST Officially Licensed Pro Sports Mug on the Planet.  Show your team spirit  by drinking out of this 32oz Macho Mug decorated with a hand-crafted metal team logo.,Anaheim Angels 1 Liter Macho Mug Primary Logo. This is the LARGEST Officially Licensed Pro Sports Mug on the Planet.  Show your team spirit  by drinking out of this 32oz Macho Mug decorated with a hand-crafted metal team logo.,,default,default,4,1,Anaheim-Angels-1-Liter-Macho-Mug-Primary-Logo.jpg,Anaheim-Angels-1-Liter-Macho-Mug-Primary-Logo.jpg,Anaheim-Angels-1-Liter-Macho-Mug-Primary-Logo.jpg,0,0,0,0,0,0,0,0,,,R,,,,,,,,,UPSTOOLS,UPSTOOLS,8 in,12 in,8 in,4 lbs.,1,TX,USA,78130,,,,,,,,A,,0,0

Offline

 

#3 07-22-2009 09:23:33

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: CCP V6 CSV Import Errors

What system and OS are you running MSoffice on?

John

Offline

 

#4 07-22-2009 09:38:12

garykva
Member
Registered: 07-22-2009
Posts: 46

Re: CCP V6 CSV Import Errors

I am running it on XP Service pack 2, all machines. All x86 machines.

Offline

 

#5 07-22-2009 09:41:46

garykva
Member
Registered: 07-22-2009
Posts: 46

Re: CCP V6 CSV Import Errors

In addition to the "white screen with black text" I only occasionally (1 in 10 failed tries) see the Kryptronic style page that says:

The CSV file you uploaded could not be read. It does not appear to be a properly formatted CSV file that can be used by this import function. Review the CSV File Information section for information on how this file should be formatted and make sure all of the table columns were represented on the first line of the file.

Offline

 

#6 07-22-2009 09:47:07

dh783
Member
From: Avondale, Arizona
Registered: 04-06-2005
Posts: 6233
Website

Re: CCP V6 CSV Import Errors

I run MSoffice on a Mac and have no problems, but I do have more than one way to save a file in csv formate and only one works, in my case CSV(Windows). If you have choices on how to save a csv file then you may have to try them one at a time until you find one that works.

John

Offline

 

#7 07-22-2009 09:53:57

garykva
Member
Registered: 07-22-2009
Posts: 46

Re: CCP V6 CSV Import Errors

Heh, have exhausted all versions of Office 2003 and 2007 Save as CSV. To no avail.

I even tried removing all commas, periods, or any other symbol in case MSO didnt double quote a particular cell.

I do have part numbers with a dash, I'll remove those as well.

Offline

 

#8 07-22-2009 10:09:34

garykva
Member
Registered: 07-22-2009
Posts: 46

Re: CCP V6 CSV Import Errors

Hummm I also have seen something that I don't remember in the past. I'll include the menu. Lookit the bottom of the list. I don't remember seeing the "xbakq4d8" line entries in the past, but maybe I was blinded from staring at the monitors all day. I deserve a tan for all the stuff I do via computer:

ccp0_cart Browse Maintain Guided Select Insert Import Export
ccp0_cat Browse Maintain Guided Select Insert Import Export
ccp0_catdisp Browse Maintain Guided Select Insert Import Export
ccp0_cofields Browse Maintain Guided Select Insert Import Export
ccp0_country Browse Maintain Guided Select Insert Import Export
ccp0_custommenu Browse Maintain Guided Select Insert Import Export
ccp0_discounts Browse Maintain Guided Select Insert Import Export
ccp0_dynformfields Browse Maintain Guided Select Insert Import Export
ccp0_dynforms Browse Maintain Guided Select Insert Import Export
ccp0_femenus Browse Maintain Guided Select Insert Import Export
ccp0_gateway Browse Maintain Guided Select Insert Import Export
ccp0_html Browse Maintain Guided Select Insert Import Export
ccp0_orderitems Browse Maintain Guided Select Insert Import Export
ccp0_orders Browse Maintain Guided Select Insert Import Export
ccp0_prod Browse Maintain Guided Select Insert Import Export
ccp0_prodcatdisp Browse Maintain Guided Select Insert Import Export
ccp0_proddetdisp Browse Maintain Guided Select Insert Import Export
ccp0_prodoptions Browse Maintain Guided Select Insert Import Export
ccp0_prodoptionsel Browse Maintain Guided Select Insert Import Export
ccp0_rescom Browse Maintain Guided Select Insert Import Export
ccp0_salecust Browse Maintain Guided Select Insert Import Export
ccp0_shipcust Browse Maintain Guided Select Insert Import Export
ccp0_shiprealtime Browse Maintain Guided Select Insert Import Export
ccp0_shiprealtimep Browse Maintain Guided Select Insert Import Export
ccp0_stateprov Browse Maintain Guided Select Insert Import Export
ccp0_storemenu Browse Maintain Guided Select Insert Import Export
khxc_affpay Browse Maintain Guided Select Insert Import Export
khxc_altrdbms Browse Maintain Guided Select Insert Import Export
khxc_columndefs Browse Maintain Guided Select Insert Import Export
khxc_dbbackup Browse Maintain Guided Select Insert Import Export
khxc_dbguided Browse Maintain Guided Select Insert Import Export
khxc_formfields Browse Maintain Guided Select Insert Import Export
khxc_forms Browse Maintain Guided Select Insert Import Export
khxc_groups Browse Maintain Guided Select Insert Import Export
khxc_guestsub Browse Maintain Guided Select Insert Import Export
khxc_incphp Browse Maintain Guided Select Insert Import Export
khxc_mail Browse Maintain Guided Select Insert Import Export
khxc_messages Browse Maintain Guided Select Insert Import Export
khxc_modules Browse Maintain Guided Select Insert Import Export
khxc_namespaces Browse Maintain Guided Select Insert Import Export
khxc_selectcustom Browse Maintain Guided Select Insert Import Export
khxc_servernews Browse Maintain Guided Select Insert Import Export
khxc_sessions Browse Maintain Guided Select Insert Import Export
khxc_settings Browse Maintain Guided Select Insert Import Export
khxc_stats Browse Maintain Guided Select Insert Import Export
khxc_statsfe Browse Maintain Guided Select Insert Import Export
khxc_statsns Browse Maintain Guided Select Insert Import Export
khxc_tabledefs Browse Maintain Guided Select Insert Import Export
khxc_users Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_cart Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_cat Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_catdisp Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_cofields Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_country Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_custommenu Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_discounts Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_dynformfields Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_dynforms Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_femenus Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_gateway Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_html Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_orderitems Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_orders Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_prod Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_prodcatdisp Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_proddetdisp Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_prodoptions Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_prodoptionsel Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_rescom Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_salecust Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_shipcust Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_shiprealtime Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_shiprealtimep Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_stateprov Browse Maintain Guided Select Insert Import Export
xbakq4d8_ccp0_storemenu Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_affpay Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_altrdbms Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_columndefs Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_dbguided Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_formfields Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_forms Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_groups Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_guestsub Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_incphp Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_mail Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_messages Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_modules Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_namespaces Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_selectcustom Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_servernews Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_sessions Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_settings Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_stats Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_statsfe Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_statsns Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_tabledefs Browse Maintain Guided Select Insert Import Export
xbakq4d8_khxc_users

Offline

 

#9 07-22-2009 11:00:00

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: CCP V6 CSV Import Errors

Those are backup tables that were created when you used the backup function in admin.

Offline

 

#10 07-22-2009 11:07:41

garykva
Member
Registered: 07-22-2009
Posts: 46

Re: CCP V6 CSV Import Errors

Ok, no prollem. what about the issue about being able to import a CSV? Any clues?

Offline

 

#11 07-23-2009 05:36:44

Dave
Member
Registered: 07-05-2003
Posts: 11233

Re: CCP V6 CSV Import Errors

Your issue sounds remarkably like the one discussed in  and, since you're using a Windows server, quite likely the same problem.

Offline

 

#12 08-07-2009 11:33:24

garykva
Member
Registered: 07-22-2009
Posts: 46

Re: CCP V6 CSV Import Errors

One of the issues with using the CSV files which I caught myself doing is for example:
using the Retail Price column. I had set that entire column to use typical numbers with decimals - no $ added into the numbering scheme - if you use the $, your prices come up blank.

So, if you change ROW 1, the "regprice" column - including Row 1 (column headers) it will cause the spreadsheet to fail and not load. Anyone experiencing the problem of:

Fatal error: Cannot use object of type KHXCerror as array in D:\khxc-private\core\KHXC_BackEnd\ext\rawdb.php on line 3251

or

An error trying to import CSV spreadsheets - I recommend having a master blank ecom_prod spreadsheet and simply copy and paste row 1 (header info for columns) and that may clear up any issues.

Offline

 

Board footer