Kryptronic Software Support Forum

slydog · 01-30-2007 16:45:09

Anybody done this yet?

I keep getting an error that the file I'm importing is not proper CSV. Well, I open a delimited text file in Excel setting it up with comma separators, and quotes for text. Then save down as CSV. Don't work. I notice opening that in Wordpad that it doesn't have quotes around everything.

Ok, I export from Lotus Approach as a comma delimited text file. It has all the quotes and commas etc. But it is text not .csv. So I save as .csv. Don't work. Empty fields are not closed in quotes as they are on the sample download of the ccp0_cat table from CCP6.

Tried Access too, but no option to save or export table as CSV.

But all I use to do in 5.1 was export from Lotus as comma delimited (same as above), open in Wordpad, Select all and copy.. then paste into the product csv and FTP the new one up. So is the 5.1 CSV different from a CCP6 CSV? .. or something amiss with this import function in RAW DB admin .. or?

So what method to get a proper CSV for CCP6? If I save as CSV from Excel, why is it not a proper CSV? What program and method are you using for this, Nick?

While I'm on the subject, I note with interest the 1000 row import limitation. If my database is 11,000 plus products... I'm expected to break that into 12 separate databases losing my ability to maintain all of my products in one database? ... or somehow generate 12 "CCP6 Formatted" CSV files from a single database?

Is there another way to do this? Are the files accessible somewhere via FTP?

Dave · 01-30-2007 18:00:39

slydog wrote:
Are the files accessible somewhere via FTP?

This one I can answer and the answer is no. The data is stored in a RDBMS not "plain" files that you can FTP and manipulate.

slydog · 01-30-2007 18:12:04

This is the problem, I assume:

ste_prodsm_default,N,PCT,,,Sexy Wear --> CCP5.1 CSV string example (no fields quoted)

0,,default,4,default,0,,001-clth0002,A, --> Excel saved as .csv (no quoted fields)

"0",,"default","4","default","0",,"001-clth0002","A", --> Approach export as .txt comma delimited (fields quoted except empty ones)

"0",,"default","4","default","0",,"001-clth0003","A", --> Approach export as .csv comma delimited (fields quoted except empty ones)

"default","4","default","0","","2","A","" --> CCP6 CSV export (all fields including empty quoted)

slydog · 01-30-2007 18:14:26

djm0219 wrote:
slydog wrote:
Are the files accessible somewhere via FTP?
This one I can answer and the answer is no. The data is stored in a RDBMS not "plain" files that you can FTP and manipulate.

Sooo... I can't upload a 3000 product (current size going to 11,000 plus) database?

Last edited by slydog (01-30-2007 18:23:48)

Dave · 01-30-2007 18:36:18

Not directly but if you're using a MySQL database I would suggest that you take a look at . It's import function supports CSV files and provides a number of options which MAY allow you to get things loaded and updated in the future. Some of the CSV options it provides are:

CSV options
Replace table data with file
Ignore duplicate rows
Fields terminated by
Fields enclosed by
Fields escaped by
Lines terminated by

slydog · 01-30-2007 19:01:06

I have it and have looked at it. I don't see the CSV options giving me a way to tell it that empty fields are not enclosed. Which would leave the only option of exporting from Approach as text, opening in Excel just to save down again as CSV with no field enclosures and telling phpMyAdmin that there are no field enclosures.

Then there is this:

Partial import
Allow interrupt of import in case script detects it is close to time limit. This might be good way to import large files, however it can break transactions.

Number of records(queries) to skip from start

From the looks of that, it seems to be telling me that I run it till it times out and run again, and again, until finally all my data is up there. When i update, I have to remove the entire table and reload it because there is no way I have the time or inclination to manually delete 200 - 300 products everytime I update. So removing all data and then struggling through countless imports to get the new data up there every time would cripple the store for some period each time.

Was CCP6 not figured for folks with more than 1000 products in their external database?

slydog · 01-30-2007 21:19:31

Ok, I uploaded my ccp0_cat table through phpMyAdmin. I used the format I get by default from exporting out of Lotus Approach as comma delimited text file and just typing .csv after the file name during the export drill. This gives me a CSV file formatted like this:

"0",,"default","4","default","0",,"001-clth0003","A", --> Approach export as .csv comma delimited (fields quoted except empty ones)

It works through phpMyAdmin choosing CSV; Replace table data with file; Ignore duplicate rows; Fields terminated by set to comma; Fields enclosed by left at the default quote; Fields escaped by left at default slash; Lines terminated by left at the default 'Auto'

CCP6 Raw DB admin import will not import the same file.

Now another thing I notice have a bunch of categories up -- I have it set to display 4 subcategories per row. But the cell widths vary with the category name length. One category with long cat names the cells are spread nicely across the page, next one with small names are squeezed together all on the left leaving lots of blank real estate on the right. This needs to be uniform, not varying in and out like an accordion from category to category. I immediately looked at the default category skin..... nothing on there for table specs. Where can i find the CSS coltrolling that? According to my 'view source' on the category pages, the controlling CSS for those cat tables is khxc_cptbl_cat -- but that is not found in all.css. Anyone know where it is hiding?

Litemaster · 01-30-2007 22:09:08

Hi,

I am using Microsoft Excel 2002 with CCP6 CSV imports without any problems..

The way I do it is to export the CSV file from within the KHXC raw database admin control and then open it with Excel using the default settings only. I then save the file as a XLS file so that I can manipulate it using the full power of Excel.

When I am finished I save one copy as a XLS file and another save as a standard CSV file again using the default settings only.

This works without any problems on our 5000 + item file. I used the same system with CCP5.1 as well.

Mike Simpson
Litemaster Systems
wwwdjshopper.net/khxc

slydog · 01-30-2007 23:40:21

Thanks. But I don't use Excel. I have all of our databases built with input forms, formulas, etc. in Lotus Approach. No way I could use just a spreadsheet. How are you doing the upload. All 5000 at once? Does it crap out?

Litemaster · 01-31-2007 00:09:08

Works fine with the full file, maybe as it gets larger I may have to do it in two hits. I will wait until I reach the stage that it times out before splitting the file.

Mike Simpson
Litemaster Systems
wwwdjshopper.net/khxc

Last edited by Litemaster (01-31-2007 00:10:15)

slydog · 01-31-2007 00:24:33

What are ya gonna do, put the headers in another CSV and cut/paste half the data to it?

Litemaster · 01-31-2007 02:42:53

Yes that’s the way I do it. I ensure I have all the headers in the correct order by exporting them via KHXC Raw Data and enter the info by cut and paste if possible.

You have to ensure that you don’t duplicate the index entry or it will screw things up nicely.

Mike Simpson
Litemaster Systems
wwwdjshopper.net/khxc

Dave · 01-31-2007 02:53:36

slydog wrote:
Where can i find the CSS coltrolling that? According to my 'view source' on the category pages, the controlling CSS for those cat tables is khxc_cptbl_cat -- but that is not found in all.css. Anyone know where it is hiding?

That class is in all.css starting at line 702 in the default ecom skin.

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Category List Display Tables | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl_cat {
color: inherit;
background-color: inherit;
margin: 0px 0px 10px 0px;
border-spacing: 3px;
width: 100%;
}

slydog · 01-31-2007 04:09:53

I went over mine several times. I checked my saved original. I copy/pasted my original all.css into Notepad and used the find function too. No such animal and I have no section marked KHXC Required Classes: Category List Display Tables.

I have this:

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Category/Product Display Tables | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl {
color: inherit;
background-color: inherit;
margin: 0px 0px 10px 0px;
border-spacing: 3px;
width: 100%;
}

But not the other. What else is in that section?

Dave · 01-31-2007 04:29:44

Sounds like you're working with one of the beta versions rather than the released version. Nick split the css for categories, products and details into separate sections. In the released version there's a separate set of styling for each of those areas. You may want to make certain you're not working with one of the beta releases before you go too far.

Code:

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Category List Display Tables        | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl_cat {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 10px 0px;
     border-spacing: 3px;
     width: 100%;
     }

tr.khxc_cptbl_cat {
     color: inherit;
     background-color: inherit;
     }

td.khxc_cptbl_cat {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     vertical-align: top;
     }

td.khxc_cptbl_cat_blank {
     color: inherit;
     background-color: inherit;
     display: none;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Product List Display Tables         | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl_prod {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 10px 0px;
     border-spacing: 3px;
     width: 100%;
     }

tr.khxc_cptbl_prod {
     color: inherit;
     background-color: inherit;
     }

td.khxc_cptbl_prod {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     vertical-align: top;
     }

td.khxc_cptbl_prod_blank {
     color: inherit;
     background-color: inherit;
     display: none;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Product Detail Display Tables       | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl_det {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 10px 0px;
     border-spacing: 3px;
     width: 100%;
     }

tr.khxc_cptbl_det {
     color: inherit;
     background-color: inherit;
     }

td.khxc_cptbl_det {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     vertical-align: top;
     }

td.khxc_cptbl_det_blank {
     color: inherit;
     background-color: inherit;
     display: none;
     }

slydog · 01-31-2007 04:59:09

Well, I downloaded it after the official release. So how would I know? I've done all the updates -- ran the installer I think three times. How can the css be in my page on 'view source' if it's not in my all.css?

Hmm.. seems I'm missing a few things. Here is my original all.css:

Code:

/* +------------------------------------------------------------+ */
/* | General XHTML Elements                                     | */
/* +------------------------------------------------------------+ */

body {
     color: #CC99FF;
     background-color: #000000;
     font-family: Verdana, Tahoma, Arial, sans-serif;
     font-size: 11px;
     font-weight: normal;
     text-align: left;
     margin: 0px;
     }

a {
     color: #86E2FD;
     background-color: inherit;
     font-weight: normal;
     text-decoration: none;
     cursor: pointer;
     }

p {
     color: inherit;
     background-color: inherit;
     margin: 5px 0px 7px 0px;
     }

sup {
     color: inherit;
     background-color: inherit;
     display: inline;
     padding: 0px;
     vertical-align: super;
     font-size: 8px;
     }

a:hover {
     color: inherit;
     background-color: inherit;
     text-decoration: underline;
     }

fieldset {
     color: inherit;
     background-color: inherit;
     border: none;
     padding: 5px 0px 5px 0px;
     }

fieldset p {
     color: inherit;
     background-color: inherit;
     display: block;
     font-size: 11px;
     margin: 5px 5px 5px 2px;
     }

form {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 5px 0px;
     }

img {
     color: inherit;
     background-color: inherit;
     border: none;
     }

li {
     color: inherit;
     background-color: inherit;
     padding-bottom: 5px;
     }

/* +------------------------------------------------------------+ */
/* | General XHTML Classes                                      | */
/* +------------------------------------------------------------+ */

.center {
     color: inherit;
     background-color: inherit;
     text-align: center;
     }

.inlinecenter {
     color: inherit;
     background-color: inherit;
     text-align: center;
     }

p.inline {
     color: inherit;
     background-color: inherit;
     display: inline;
     padding: 0px;
     }

.strong {
     color: inherit;
     background-color: inherit;
     font-weight: bold;
     }

.hidden {
     color: inherit;
     background-color: inherit;
     display: none;
     }

a.unfancy {
     color: inherit;
     background-color: inherit;
     text-decoration: underline;
     font-weight: normal;
     }

a.unfancy:hover {
     color: inherit;
     background-color: inherit;
     text-decoration: underline;
     }

/* +------------------------------------------------------------+ */
/* | Skin Specific Divs                                         | */
/* +------------------------------------------------------------+ */

#skin_wrapper {
     color: inherit;
     background-color: inherit;
     width: 99%;
     padding: 0px;
     margin: auto;
     }

#skin_header {
     color: inherit;
     background-color: #000000;
     border: 1px solid #36586F;
     padding: 0px;
     margin-bottom: 0px;
     }

#skin_ct {
     color: inherit;
     background-color: #000000;
     border: 1px solid #36586F;
     width: 100%;
     padding: 0px;
     }

#skin_ct_lcol {
     color: inherit;
     background-color: #000000;
     padding: 7px 9px 7px 7px;
     margin: 0px;
     vertical-align: top;
     border-right: none;
     width: 160px;
     text-align: left;
     }

#skin_ct_mcol {
     color: inherit;
     background-color: #000000;
     padding: 7px 7px 7px 7px;
     margin: 0px;
     border: none;
     vertical-align: top;
     }

#skin_ct_rcol {
     color: inherit;
     background-color: #000000;
     padding: 7px 7px 7px 9px;
     margin: 0px;
     vertical-align: top;
     border-left: none;
     width: 160px;
     }

#skin_footer {
     color: inherit;
     background-color: inherit;
     padding: 0px;
     margin-top: 10px;
     text-align: center;
     }

#skin_pgtitle {
     color: #FFFFFF;
     background-color: #4E7A99;
     padding: 3px 5px 3px 5px;
     margin: 0px 0px 10px 0px;
     border: 1px solid #36586F;
     font-weight: bold;
     }

#skin_content {
     color: inherit;
     background-color: inherit;
     margin: auto;
     }

#skin_ht {
     color: inherit;
     background-color: inherit;
     border: 0px;
     margin: 0px;
     padding: 0px;
     width: 100%;
     }

#skin_ht_lcol {
     color: inherit;
     background-color: inherit;
     width: 75%;
     text-align: left;
     vertical-align: top;
     }

#skin_ht_mcol {
     color: inherit;
     background-color: #000000;
     width: 160px;
     text-align: center;
     vertical-align: top;
     }

#skin_ht_rcol {
     color: inherit;
     background-color: #000000;
     width: 140px;
     text-align: center;
     vertical-align: top;
     }

#skin_ht2 {
     color: inherit;
     background-color: inherit;
     border: 0px;
     margin: 0px;
     padding: 0px;
     width: 100%;
     }

#skin_ht2_lcol {
     color: inherit;
     background-color: inherit;
     width: 25%;
     text-align: left;
     vertical-align: top;
     }

#skin_ht2_mcol {
     color: inherit;
     background-color: inherit;
     width: 25%;
     text-align: right;
     vertical-align: top;
     }

#skin_ht2_rcol {
     color: inherit;
     background-color: #000000;
     width: 50%;
     text-align: right;
     vertical-align: top;
     }


/* +------------------------------------------------------------+ */
/* | Skin Specific Classes                                      | */
/* +------------------------------------------------------------+ */

.skin_fenavh {
     color: #FFFFFF;
     background-color: #4E7A99;
     padding: 3px 5px 3px 5px;
     margin: 0px 0px 0px 0px;
     border: 1px solid #36586F;
     font-weight: bold;
     }

.skin_fenav ul {
     color: inherit;
     background-color: inherit;
     padding: 0px;
     margin: 0px 0px 10px 0px;
     list-style: none;
     }

.skin_fenav ul li {
     color: inherit;
     background-color: inherit;
     padding: 0px;
     margin: 0px;
     border-bottom: 1px solid #CDCDCD;
     list-style: none;
     }

.skin_fenav ul li a {
     color: #CC99FF;
     background-color: inherit;
     font-weight: normal;
     display: block;
     text-decoration: none;
     padding: 3px 5px 3px 5px;
     }

.skin_fenav ul li a:hover {
     color: #333333;
     background-color: #ABC2D1;
     text-decoration: none;
     }

.skin_button {
     color: #FFFFFF;
     background-color: #4E7A99;
     padding: 0px;
     border: 1px solid #36586F;
     margin: 0px 0px 10px 3px;
     display: block;
     float: right;
     }

.skin_button a {
     color: #333333;
     background-color: #ABC2D1;
     font-weight: normal;
     display: block;
     padding: 2px 7px 2px 7px;
     }

.skin_button a:hover {
     color: #333333;
     background-color: #EFEFEF;
     text-decoration: none;
     }

.skin_headacct {
     color: inherit;
     background-color: inherit;
     width: 100%;
     text-align: right;
     clear: both;
     }

.skin_fenavmini {
     color: inherit;
     background-color: inherit;
     padding: 5px;
     margin: 0px 0px 10px 0px;
     border-left: 1px solid #36586F;
     border-right: 1px solid #36586F;
     border-bottom: 1px solid #36586F;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Divs                                         | */
/* +------------------------------------------------------------+ */

#khxc_debug {
     color: #333333;
     background-color: #FFFFFF;
     border: 1px solid #36586F;
     padding: 10px;
     overflow: hidden;
     margin-top: 10px;
     }

#khxc_printable {
     color: inherit;
     background-color: #FFFFFF;
     border: 1px solid #36586F;
     width: 800px;
     padding: 10px;
     margin: auto;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Messages                            | */
/* +------------------------------------------------------------+ */

.khxc_error {
     color: #FF0000;
     background-color: inherit;
     font-weight: bold;
     }

.khxc_confirm {
     color: #339933;
     background-color: inherit;
     font-weight: bold;
     }

.khxc_imgfloatrt {
     color: inherit;
     background-color: inherit;
     float: right;
     margin-bottom: 10px;
     margin-left: 10px;
     display: inline;
     }

.khxc_inline {
     color: inherit;
     background-color: inherit;
     display: inline;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Boxed Monospace Code                | */
/* +------------------------------------------------------------+ */

.khxc_preboxed {
     color: inherit;
     background-color: #F7F7F7;
     margin: 5px 0px 0px 0px;
     padding: 5px;
     border: 1px solid #36586F;
     font-family: Fixed, monospace;
     overflow: hidden;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Form Fields                         | */
/* +------------------------------------------------------------+ */

.khxc_formfieldradcb {
     color: inherit;
     background-color: inherit;
     }

.khxc_formfield {
     color: inherit;
     background-color: #FFFFFF;
     border: 1px solid #36586F;
     font-size: 11px;
     margin: 5px 5px 0px 2px;
     }

.khxc_formfield:hover {
     color: inherit;
     background-color: #DEDEDE;
     }

.khxc_formfieldp {
     color: #3E6B8A;
     background-color: inherit;
     display: block;
     padding: 0px;
     margin: 0px;
     }

.khxc_formfieldpnfs {
     color: inherit;
     background-color: inherit;
     display: block;
     padding: 0px 5px 0px 5px;
     margin: 0px 0px 5px 0px;
     }

.khxc_formfielda {
     color: #3E6B8A;
     background-color: inherit;
     display: block;
     padding: 0px 5px 0px 5px;
     margin: 0px 0px 2px 0px;
     }

.khxc_formbutton {
     color: #333333;
     background-color: #ABC2D1;
     border: 1px solid #36586F;
     padding: 1px;
     margin: 0px 0px 5px 0px;
     font-size: 11px;
     width: 130px;
     }

.khxc_formbutton:hover {
     color: #333333;
     background-color: #EFEFEF;
     }

.khxc_quickbutton {
     color: #333333;
     background-color: #ABC2D1;
     border: 1px solid #36586F;
     padding: 1px;
     margin: 0px;
     font-size: 11px;
     width: 130px;
     }

.khxc_quickbutton:hover {
     color: #333333;
     background-color: #EFEFEF;
     }

.khxc_quickform {
     color: inherit;
     background-color: inherit;
     margin: 5px 0px 0px 0px;
     }

.khxc_quickfield {
     color: inherit;
     background-color: #DEDEDE;
     border: 1px solid #36586F;
     font-size: 11px;
     margin: 1px 0px 0px 0px;
     }

.khxc_quickfield:hover {
     color: inherit;
     background-color: #FFFFFF;
     }

.khxc_formfieldradcb_rnc {
     color: inherit;
     background-color: #FFA4A4;
     }

.khxc_formfield_rnc {
     color: inherit;
     background-color: #FFA4A4;
     border: 1px solid #36586F;
     font-size: 11px;
     margin: 5px 5px 0px 2px;
     }

.khxc_formfield_rnc:hover {
     color: inherit;
     background-color: #DEDEDE;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Form Displays                       | */
/* +------------------------------------------------------------+ */

.khxc_formsecthead {
     color: #FFFFFF;
     background-color: #4E7A99;
     padding: 2px 5px 2px 5px;
     margin: 0px;
     border-top: 1px solid #36586F;
     border-left: 1px solid #36586F;
     border-right: 1px solid #36586F;
     font-weight: bold;
     }

table.khxc_formtblone {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 5px 0px;
     border-spacing: 3px;
     width: 100%;
     border: 1px solid #36586F;
     }

table.khxc_formtbltwo {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 5px 0px;
     border-spacing: 3px;
     width: 100%;
     border: 1px solid #36586F;
     }

td.khxc_formtbltwo {
     color: #000000;
     background-color: #F7F7F7;
     padding: 4px 2px 2px 2px;
     width: 50%;
     border-top: 1px solid #BCBCBC;
     border-left: 1px solid #BCBCBC;
     vertical-align: top;
     }

td.khxc_formtbltwospan {
     color: inherit;
     background-color: #F7F7F7;
     padding: 4px 2px 2px 2px;
     width: 100%;
     border-top: 1px solid #BCBCBC;
     border-left: 1px solid #BCBCBC;
     vertical-align: top;
     }

td.khxc_formtblone {
     color: #000000;
     background-color: #F7F7F7;
     padding: 4px 2px 2px 2px;
     width: 50%;
     border-top: 1px solid #BCBCBC;
     border-left: 1px solid #BCBCBC;
     vertical-align: top;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Boxed Paragraphs                    | */
/* +------------------------------------------------------------+ */

p.khxc_ultableh {
     color: #FFFFFF;
     background-color: #4E7A99;
     padding: 3px 5px 3px 5px;
     margin: 10px 0px 0px 0px;
     border: 1px solid #36586F;
     font-weight: bold;
     }

p.khxc_ultablei {
     color: inherit;
     background-color: inherit;
     margin: 2px 0px 0px 0px;
     padding: 3px 5px 3px 5px;
     border: 1px solid #36586F;
     }

p.khxc_ultablei a {
     color: #3E6B8A;
     background-color: inherit;
     display: block;
     font-weight: normal;
     }

p.khxc_ultablel {
     color: inherit;
     background-color: #F7F7F7;
     margin: 0px 0px 5px 0px;
     padding: 3px 5px 3px 5px;
     border-right: 1px solid #36586F;
     border-left: 1px solid #36586F;
     border-bottom: 1px solid #36586F;
     }

p.khxc_ultablel a {
     color: #3E6B8A;
     background-color: inherit;
     font-weight: normal;
     }

p.khxc_uktablesp {
     color: inherit;
     background-color: inherit;
     margin: 0px;
     font-size: 1px;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Table Data Displays                 | */
/* +------------------------------------------------------------+ */

table.khxc_sorttable {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 0px 0px;
     border-spacing: 3px;
     width: 100%;
     border: 1px solid #36586F;
     }

a.khxc_sorttable {
     color: #3E6B8A;
     background-color: inherit;
     font-weight: bold;
     text-decoration: none;
     }

tr.khxc_sorttable {
     color: inherit;
     background-color: inherit;
     padding: 5px;
     border: 1px solid #36586F;
     }

th.khxc_sorttable {
     color: inherit;
     background-color: #E9E9E9;
     padding: 4px 3px 4px 3px;
     border-top: 1px solid #CDCDCD;
     border-left: 1px solid #CDCDCD;
     vertical-align: top;
     }

td.khxc_sorttable {
     color: inherit;
     background-color: inherit;
     padding: 4px 3px 4px 3px;
     border-top: 1px solid #CDCDCD;
     border-left: 1px solid #CDCDCD;
     vertical-align: top;
     }

td.khxc_sorttable p {
     color: inherit;
     background-color: inherit;
     padding: 0px;
     margin: 0px;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Online Store Displays               | */
/* +------------------------------------------------------------+ */

.khxc_storehead {
     color: #FFFFFF;
     background-color: #4E7A99;
     padding: 2px 5px 2px 5px;
     margin: 0px 0px 0px 0px;
     border: 1px solid #36586F;
     font-weight: bold;
     clear: both;
     }

.khxc_storelink {
     color: inherit;
     background-color: #ABC2D1;
     padding: 0px 5px 0px 5px;
     margin: 0px 0px 0px 0px;
     border: 1px solid #36586F;
     }

.khxc_storelink a {
     color: #3E6B8A;
     background-color: inherit;
     font-weight: normal;
     }

.khxc_storelink p {
     color: #3E6B8A;
     background-color: inherit;
     margin: 4px 0px 4px 0px;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Category/Product Display Tables     | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 10px 0px;
     border-spacing: 3px;
     width: 100%;
     }

td.khxc_cptbl1 {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     width: 100%;
     vertical-align: top;
     }

td.khxc_cptbl2 {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     width: 50%;
     vertical-align: top;
     }

td.khxc_cptbl3 {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     width: 33%;
     vertical-align: top;
     }

td.khxc_cptbl4 {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     width: 25%;
     vertical-align: top;
     }

td.khxc_cptblblank {
     color: inherit;
     background-color: inherit;
     display: none;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Price Displays                      | */
/* +------------------------------------------------------------+ */

.khxc_pricediv {
     color: inherit;
     background-color: inherit;
     margin: 2px 0px 2px 0px;
     }

.khxc_price {
     color: inherit;
     background-color: inherit;
     display: inline;
     }

.khxc_pricex {
     color: #FF0000;
     background-color: inherit;
     display: inline;
     text-decoration: line-through;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Shopping Cart Displays              | */
/* +------------------------------------------------------------+ */

.khxc_cartbutton {
     color: #333333;
     background-color: #ABC2D1;
     border: 1px solid #36586F;
     padding: 1px;
     font-size: 11px;
     font-weight: normal;
     text-align: center;
     display: block;
     margin: 0px 0px 5px 0px;
     width: 125px;
     }

.khxc_cartbutton:hover {
     color: #333333;
     background-color: #EFEFEF;
     text-decoration: none;
     cursor: default;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Ghost Table                         | */
/* +------------------------------------------------------------+ */

table.khxc_ghost {
     color: inherit;
     background-color: inherit;
     margin: 0px;
     padding: 0px;
     border-spacing: 3px;
     width: 100%;
     }

td.khxc_ghost {
     color: inherit;
     background-color: inherit;
     padding: 0px;
     margin: 0px;
     vertical-align: top;
     }

.khxc_ghost form {
     color: inherit;
     background-color: inherit;
     display: inline;
}

td.khxc_ghost img {
     color: inherit;
     background-color: inherit;
     margin-right: 10px;
     margin-bottom: 10px;
     }

td.khxc_ghost p {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 6px 0px;
}

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Order Summary Displays              | */
/* +------------------------------------------------------------+ */

table.khxc_ordsumm {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 5px 0px;
     border-spacing: 3px;
     width: 100%;
     border-left: 1px solid #36586F;
     border-right: 1px solid #36586F;
     border-bottom: 1px solid #36586F;
     }

.khxc_ordsumm a {
     color: #3E6B8A;
     background-color: inherit;
     font-weight: bold;
     text-decoration: none;
     }

tr.khxc_ordsumm {
     color: inherit;
     background-color: inherit;
     padding: 5px;
     border: 1px solid #36586F;
     }

th.khxc_ordsumm {
     color: inherit;
     background-color: inherit;
     padding: 4px 3px 4px 3px;
     border-top: 1px solid #CDCDCD;
     border-left: 1px solid #CDCDCD;
     vertical-align: top;
     }

td.khxc_ordsumm {
     color: inherit;
     background-color: #F7F7F7;
     padding: 4px 3px 4px 3px;
     border-top: 1px solid #CDCDCD;
     border-left: 1px solid #CDCDCD;
     vertical-align: top;
     }

.khxc_ordsumm p {
     color: inherit;
     background-color: inherit;
     padding: 0px;
     margin: 0px 0px 5px 0px;
     }

.khxc_ordsumm a {
     color: #3E6B8A;
     background-color: inherit;
     }

.khxc_ordsumm a:hover {
     color: inherit;
     background-color: inherit;
     text-decoration: underline;
     }

.khxc_ordsummhead {
     color: #FFFFFF;
     background-color: #4E7A99;
     padding: 2px 5px 2px 5px;
     margin: 0px;
     border: 1px solid #36586F;
     font-weight: bold;
     clear: both;
     }

.khxc_ordsummcenter {
     color: inherit;
     background-color: inherit;
     text-align: center;
     padding: 0px;
     margin: 0px 0px 10px 0px;
     border: 1px solid #36586F;
     }

.khxc_ordsummbig {
     color: inherit;
     background-color: inherit;
     font-weight: bold;
     font-size: 16px;
     }

.khxc_ordsummlink {
     color: inherit;
     background-color: #F7F7F7;
     padding: 0px 5px 0px 5px;
     margin: 10px 0px 10px 0px;
     border: 1px solid #36586F;
     }

.khxc_ordsummlink a {
     color: #3E6B8A;
     background-color: inherit;
     font-weight: normal;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Misc                                | */
/* +------------------------------------------------------------+ */

h1.khxc_secthead {
     color: inherit;
     background-color: inherit;
     font-weight: bold;
     font-size: 11px;
     text-decoration: underline;
     }

.khxc_clearboth {
     color: inherit;
     background-color: inherit;
     clear: both;
     }

.khxc_outstock {
     color: #FF0000;
     background-color: inherit;
     }

a.khxc_hrefbutton {
     color: #333333;
     background-color: #ABC2D1;
     border: 1px solid #36586F;
     padding: 2px 5px 2px 5px;
     font-size: 11px;
     font-weight: normal;
     text-align: center;
     display: block;
     }

a.khxc_hrefbutton:hover {
     color: #333333;
     background-color: #EFEFEF;
     text-decoration: none;
     cursor: default;
     }

.khxc_outline {
     color: inherit;
     background-color: #F7F7F7;
     border: 1px solid #36586F;
     padding: 5px;
     margin-top: 5px;
     }

.khxc_outlinetrans {
     color: inherit;
     background-color: inherit;
     border: 1px solid #36586F;
     }

.khxc_outline p {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 3px 0px;
}

/* +------------------------------------------------------------+ */
/* | End                                                        | */
/* +------------------------------------------------------------+ */

Last edited by slydog (01-31-2007 05:04:58)

Dave · 01-31-2007 05:23:33

slydog wrote:
So how would I know? I've done all the updates -- ran the installer I think three times. How can the css be in my page on 'view source' if it's not in my all.css?

I'm not sure how you can tell but the default ecom all.css file is 24kb and has 1044 lines which may help you determine whether or not you've got the released/correct version of it. Do you have a page available that one could look at? Have you double checked that the css file that is being referenced is in fact the correct/expected one?

slydog · 01-31-2007 05:26:50

djm0219 wrote:
slydog wrote:
So how would I know? I've done all the updates -- ran the installer I think three times. How can the css be in my page on 'view source' if it's not in my all.css?
I'm not sure how you can tell but the default ecom all.css file is 24kb and has 1044 lines which may help you determine whether or not you've got the released/correct version of it. Do you have a page available that one could look at? Have you double checked that the css file that is being referenced is in fact the correct/expected one?

I posted my all.css original in the post above.

I originally cloned the ecom, saved an original of the css and have been working with the same css for a couple of weeks now. So the css I'm using is the one affecting the pages.

I went to the ecom skin and copied the CSS. It is 22.5kb and has 1007 lines.

Oh yeah, I guess I need some sleep because it just dawned on me that the code is calling that css (so it's in the view source) but I don't actually have the css that is being called.

I paid and downloaded AFTER a lot of other folks. So who else out there is missing something?

Last edited by slydog (01-31-2007 05:39:52)

Dave · 01-31-2007 05:46:09

Well what you posted isn't drastically different from the default ecom file but there ARE a number of things missing in yours that are present in the default. The most noticeable being:

Code:

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Category List Display Tables        | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl_cat {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 10px 0px;
     border-spacing: 3px;
     width: 100%;
     }

tr.khxc_cptbl_cat {
     color: inherit;
     background-color: inherit;
     }

td.khxc_cptbl_cat {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     vertical-align: top;
     }

td.khxc_cptbl_cat_blank {
     color: inherit;
     background-color: inherit;
     display: none;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Product List Display Tables         | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl_prod {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 10px 0px;
     border-spacing: 3px;
     width: 100%;
     }

tr.khxc_cptbl_prod {
     color: inherit;
     background-color: inherit;
     }

td.khxc_cptbl_prod {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     vertical-align: top;
     }

td.khxc_cptbl_prod_blank {
     color: inherit;
     background-color: inherit;
     display: none;
     }

/* +------------------------------------------------------------+ */
/* | KHXC Required Classes: Product Detail Display Tables       | */
/* +------------------------------------------------------------+ */

table.khxc_cptbl_det {
     color: inherit;
     background-color: inherit;
     margin: 0px 0px 10px 0px;
     border-spacing: 3px;
     width: 100%;
     }

tr.khxc_cptbl_det {
     color: inherit;
     background-color: inherit;
     }

td.khxc_cptbl_det {
     color: inherit;
     background-color: inherit;
     padding: 4px 4px 2px 4px;
     border: 1px solid #36586F;
     vertical-align: top;
     }

td.khxc_cptbl_det_blank {
     color: inherit;
     background-color: inherit;
     display: none;
     }

You also have some things that aren't in the default including:

Code:

td.khxc_cptbl1
td.khxc_cptbl2
td.khxc_cptbl3
td.khxc_cptbl4
td.khxc_cptblblank

I compared what you posted to some of the beta versions and what you have is a lot closer to them than it is to the released version. What you posted has a few more lines than the default file but that could simply be due to things you've changed and/or added.

slydog · 01-31-2007 05:53:42

That is an unchanged, unaltered original file. I always make a copy and store it away. Trust me, the one I'm using in my cloned skin has lots of changes including several new classes and IDs. But the one I posted is an original.

So I definitely am not the only one, because I got mine after many others did.

Dave · 01-31-2007 06:23:32

I don't doubt you slydog. I was simply reporting what I found. I certainly can't explain the difference and my version was installed on the 24th so it's barely a week old. AFAIK there haven't been any updates since then.

Quizno · 01-31-2007 08:14:18

Um, I concur with slydog: The original all.css in my installation is 1007 lines. The "missing" content that Dave refers to is missing from my all.css.

Dave · 01-31-2007 08:50:37

That is very odd indeed! I've just checked my copies of the last 2 beta installs as well as the release version again which I installed on the 24th and none of the all.css files have that number of lines. Weird Nick is going to have to weigh in on this one.

webmaster · 02-05-2007 11:05:52

There was an update released on 01/13/2007 which added classes to the Ecom skin. Check it out:

https://forum.kryptronic.com/viewtopic.php?id=15156

For installs prior to this all of those classes are combined. For installs after this update the new classes are used. Because the installer will not update your product detail display code or the Ecom skin during an update, installs done prior to that date will use the old CSS methodology.

wyattea · 04-09-2007 08:00:17

Ok, I'm completely lost trying to figure out this thread - where is there documentation on how to do any of this? The conversation just starts as if it's a previous thread? There's no mention in the manual or how to do anything with respect to important products using CSV? ccp5.1 was simple, you just change the product table to csv from mysql (or whatever), then go and download the file using ftp, then change all you want.

The Importer doesn't work for me but I can make my product list into a csv formatted file using excel, how do i get it into ccp6? I finally found it in khxc's raw database, but am I suppose to convert to csv before manually editing? Could someone explain it to me from the start (since the manual doesn't even MENTION the words 'raw db admin'.

James...

Kryptronic Software Support Forum

#1 01-30-2007 16:45:09

CSV imports through RAW DB admin

#2 01-30-2007 18:00:39

Re: CSV imports through RAW DB admin

slydog wrote:

#3 01-30-2007 18:12:04

Re: CSV imports through RAW DB admin

#4 01-30-2007 18:14:26

Re: CSV imports through RAW DB admin

djm0219 wrote:

slydog wrote:

#5 01-30-2007 18:36:18

Re: CSV imports through RAW DB admin

#6 01-30-2007 19:01:06

Re: CSV imports through RAW DB admin

#7 01-30-2007 21:19:31

Re: CSV imports through RAW DB admin

#8 01-30-2007 22:09:08

Re: CSV imports through RAW DB admin

#9 01-30-2007 23:40:21

Re: CSV imports through RAW DB admin

#10 01-31-2007 00:09:08

Re: CSV imports through RAW DB admin

#11 01-31-2007 00:24:33

Re: CSV imports through RAW DB admin

#12 01-31-2007 02:42:53

Re: CSV imports through RAW DB admin

#13 01-31-2007 02:53:36

Re: CSV imports through RAW DB admin

slydog wrote:

#14 01-31-2007 04:09:53

Re: CSV imports through RAW DB admin

#15 01-31-2007 04:29:44

Re: CSV imports through RAW DB admin

Code:

#16 01-31-2007 04:59:09

Re: CSV imports through RAW DB admin

Code:

#17 01-31-2007 05:23:33

Re: CSV imports through RAW DB admin

slydog wrote:

#18 01-31-2007 05:26:50

Re: CSV imports through RAW DB admin

djm0219 wrote:

slydog wrote:

#19 01-31-2007 05:46:09

Re: CSV imports through RAW DB admin

Code:

Code:

#20 01-31-2007 05:53:42

Re: CSV imports through RAW DB admin

#21 01-31-2007 06:23:32

Re: CSV imports through RAW DB admin

#22 01-31-2007 08:14:18

Re: CSV imports through RAW DB admin

#23 01-31-2007 08:50:37

Re: CSV imports through RAW DB admin

#24 02-05-2007 11:05:52

Re: CSV imports through RAW DB admin

#25 04-09-2007 08:00:17

Re: CSV imports through RAW DB admin

Board footer