Kryptronic Software Support Forum

Check your product identifiers and make sure that they do not have spaces or other special characters such as slash (/), question mark (?), etc.  You may have to export the product table to correct them given the error you are seeing.

In the Navigation Menu go to Application Selector > Kryptronic Hybrid X Core when in the X Core page then go to Home > Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin and click on export for the ccp0_prod database.

John

When editing your products in a spread sheet you need to make sure the file type you save it in is useable by ccp when imported so testing one or two products is a good idea before you do the whole database. Also you will need to clear out or delete the current database in ccp as importing will not update or change an items id, it will only update the other fields in existing items or add new ones.

John

If you only have 7 bad items then you may not want to delete the whole database then. The file type sometime depends on how you have Excel set up and or what OS system you are using.

John

John wrote: "If you only have 7 bad items then you may not want to delete the whole database then. The file type sometime depends on how you have Excel set up and or what OS system you are using"

Okay, since I only have 7 products that are in an error state, maybe I can go into the file and change them manually. Since I can't access them via the Admin panel, where can I find the file on my server (it's name and directory)?

Jack Koenig
OrderDepartment.com

To make a long story short, I deleted each offending item in the Data Overview section at the following location: Home > Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin

Unfortunately, it didn't solve the problem although the items have been deleted. Any suggestions?

Jack Koenig
OrderDepartment.com

The column names are not the same between 5.1 and 6 so a direct import is not possible with out the use of the importer-ccp51 script which if you used it in the first place did not get those item correct probably do to something in the id's.

John

The item are in your database where ever your service provider as it. You can not do anything directly to or with the database unless you service provider a given you access through something like myphpadmin or some other program or even SSH or FTP access. In ccp's admin panel you can click on Browse for ccp0_prod at Home > Kryptronic Hybrid X Core > Database: Connections, Backups and Raw Admin > Raw Database Admin where you can update, clone, delete an item. You can also select to do an SQL statement there like

Delete From ccp0_prod

which will totally remove all item in the product database. Once you use the sql statement above the information in the database will be gone forever so you need to be careful when using statements like this unless you have a backup of your information.

John

It wont delete the ccp0_database itself but will remove the information contained within it. In the Raw Database admin you will still see the ccp_prod database and the links like Browse, Maintain, import, export etc.... When you have deleted the items in the database then you only need to click on import, select the file you want and submit. You need to make sure that all the column are present in the import file which mean if you export the list to work on you need to make sure that all column names have been selected for export. The export function will let you export any number of the columns but the import wants all columns present in the file or it will error out.

Now you can also to a limited delete form the database if you know the id of the item or what I do sometimes is when working on the information I will use a field to set something that is not normal for ccp to use. In the case where I only have a few item to change  I will create the item in the spread sheet as I want it, in the bad item I will place DELETE in the field for (example) prodnum, import the the file into ccp and then run an sql statement to just remove the product I want removed like

DELETE From ccp0_prod WHERE prodnum='DELETE'

which will only remove those item which have the word DELETE in there field which usually contains the product number. Now the word delete in this example doesn't have to be in capitols, I only did that to make it stand out, it just has to be something that you know is not in that field any where but for the items you want to remove.

John

Did the file import or did you get an error message?

John

The only time I have seen that error on the ClilckCartPro side when trying to insert a product is when I had edited a column definition for a field in the product page which I don't believe you have done. Deleting the items in the product database would not have caused this. If all else fails you can always re-run the installer and choose to install the database on step 13. With out getting to see the information in the database it is going to be hard to help.

Go back to the Raw Database Admin and see if any thing show up in the ccp_prod database or at least run the delete sql statement again for ccp0_prod. If the import didn't work then you more than likley had it saved in a file that wasn't in a csv format that ccp needs but you would have gotten a error message.

If you can get to your private directory files you can turn on the debug feature which will give you a lot of information on the problem.

You can contact Kryptronic if you want more help if needed and maybe Dave will have some idea on why the add item to the product database is failing.

Last edited by dh783 (09-27-2008 19:55:57)

The debug function has to be turned on in your private_dir/khxc/core/KHXC/KHXC.php file. You can find instructions here in the wiki http://wiki.kryptronic.com/CoreDebugger .

When you first tried to import your file what error did you get if any?

John

Last edited by dh783 (09-28-2008 10:29:28)