Kryptronic Software Support Forum

See  in the Wiki for restoring your product information (importing a CSV file) and  for exporting your product information.

Step 1: Log into your KHXC Management Interface
Step 2: Open the drop down list for the Kryptronic Hybrid X Core Main Menu
Step 3: Select Database: Connections, Backups and Raw Admin
Step 4: Select Raw Database Admin
Step 5: Chose Export for the Table you need to work on
Step 6: On the next page go to the bottom and click on Submit
Step 7: Select Save by Right Clicking and specify a folder on your computer where the file should be saved

You now have the Table as a CSV file on your computer.

Make any changes you require and upload it back into the same table using the raw database admin but this time selecting import and then telling it which file to import..

Things to note:

1: Importing does not delete any existing data it only adds new data or makes changes to modified data

2: Keep the upload less than 2 Meg in size.

If you need to clear all the data from a particular table choose the 'SQL Statement: Submit a Raw SQL Statement' function and execute the appropriate statement.

Examples:

To clear the Products table of all products the statement is:
DELETE FROM ccp0_prod

Or to clear the Category table of all Categories the statement is:
DELETE FROM ccp0_cat

If for instance you need to delete all countries except your home country the statement looks like this:

DELETE FROM ccp0_country WHERE id<>'United Kingdom'

In this case all countries except the United Kingdom will be deleted

Mike Simpson
wwwdjshopper.net

Last edited by Litemaster (05-25-2007 02:43:25)

I was trying to replace the contents of khxc_formfields in the RAW database admin.

I ran the command:

DELETE FROM khxc_formfields

I was going to import an original version of the file. But when I click on "Import" on the khxc_formfields there is no field to say where I want to import from, obviously this is becuase I have deleted the formfields database.

Can some one tell me how I can run a raw SQL statement to import the original khxc_formfields.csv file back into the table?

excellent, will this delete my databases such as gbu0_cat, gbu0_prod, gbu0_prodoptions, etc? If it will, can I use myPHPAdmin to import/export the tables?

Thank you Nick.

John.

With Excel you need to save your files with CSV(Windows) formate, and make sure that you have all of the columns present for the database you are saving to.

John

What version of Excel are you useing in my version there are some 29 different formates to save a file with the CSV(Windows) as one of them and is the only one I could get to work.

John

When importing a table via Raw Database Admin in CCP6, the existing data is not fully overwritten. How do I empty the existing data first?

I'm having difficulty too with saving an edited ccp0_cat_dataexport.csv file. I keep getting and Excel error "ccp0_cat_dataexport.csv may contain features that are not compatible with CSV (Windows). Do you want to keep the workbook in this format? To keep this format which leaves out any incompatible features, click Yes. To preserve the features, click No. Then save a copy in the latest Excel format."

I'm using Microsoft Excel 2004 for Mac version 11.5.3. The file will save but the fields will not encapsulate with quotes. Ideas anybody? I've gone through this thread and reviewed suggestions that were appropiate. Nothing works. As a side note, I deal with csv all the time but typically I just go straight into phpmyAdmin and upload via there. Wrapping text in quotes is never a requirement in other dB's I work in.

I click Yes as well. When I import, it fails. When I open the file using a text editor, nothing is encapsulated.

Edit> Success afterwards. Didn't do anything different.

Last edited by CrownRoyal (01-14-2009 17:36:03)