Kryptronic Software Support Forum

What form of Excel are you using like PC, Mac etc...? Sorting in a spread sheet will not effect the display in ccp.

John

Excel does have a habit of changing characters that it see's as formaulas into calculations, particuarly if you have modifcations with extra columns and data.

Try http://www.openoffice.org/ The Calc software is the Excel equivelant and this seems to work where Excel fails/corrupts

It's the product DB ccp0_prod_dataexport.

I did delete the database before I uploaded.

I am using Excel 2003 on Windows XP.

When I try to save the CSV I get a window that says:
"File may contain features that are no compatable with CSV. Do you want to keep the workbook in this format."

When I click YES . . . It doesn't save or close. The only way I can save and close the file is if I click NO, which saves it in the lastest Excel format (it says).

I only want to alphabetize the database so it appears that way under the catagories.

Dave . . . is this something that Krytronic can do for me easily?

There are many identifiers that have many zeros "00000000000012FE" and Dashes "ACS-VH-1.535", etc. Perhaps things that do not work well with Excel? They work on CCP6 but not in Excel it seems.


thanks,
Daniel

Last edited by daviat (01-05-2009 21:04:09)

daviat wrote:

<snip>
When I try to save the CSV I get a window that says:
"File may contain features that are no compatable with CSV. Do you want to keep the workbook in this format."

When I click YES . . . It doesn't save or close. The only way I can save and close the file is if I click NO, which saves it in the lastest Excel format (it says).
<snip>

That's really odd. I am able to save as CSV from Excel 2003/XP.

Dave wrote:

<snip>
Your identifiers with leading zeros like that are likely being stripped of the leading zeros by Excel and the column being considered a number.  Even in CCP it's possible that an ID in that format may end up without the leading zeros.

We had that Excel annoyance when importing a product number "10-2003" and Excel opened as "Oct 1 2003".
To overcome this, change the file ext to ".txt".
Ensure Excel doesn't automatically guess the file type. There's a setting in Excel for this. If you can't find it, try opening it anyway. You should get prompts as to whether or not it's delimited.
When you open the file from Excel, select "Delimited", on next window, "Comma", then on the third window, define that column as "Text". That should do it.
HTH!

Last edited by Blitzen (01-06-2009 10:44:29)

"Save As"
"CSV (comma delimited) (*.csv)"

As Dave said, CCP6 software sorts. You really don't have to sort in Excel.

My Excel never translated double quotes for question marks. Sorry, I can't help you there.
If you read the file in Notepad, are the ?? there or the quotes?
Could they be the stupid "Smart Quotes" that are angled (another M$ annoyance)?

I might be wrong about CCP6 sorting. They sort some things, but not all. Some are dependent on a sort number you enter in admin, other sort on id or something else.
Are you trying to sort the category list to display alphabetically?

I want to orderly sort the products alphabetically, that is what the client wants, since there are many products are are connected by company name, or product name, and I want things to be easily found. Otherwise products with similar product names might be mixed up with other products on other pages, if you know what I mean. It's just the excel thing that is stopping me from sorting. Sorting alphabetically will easily allow buyers to find products.

There are 849 products and it would be very difficult to sort through the admin individually without using excel. I have a deadline for Monday to launch. Just want to see if I can do this. I can sort the "sortorder" column through Excel easily . . . it just happens that Excel corrupts the file. I wish there was something other then Excel that I can sort the prod database.

thanks,
Daniel

Last edited by daviat (01-06-2009 20:11:38)

daviat wrote:

<snip>
. . . it just happens that Excel corrupts the file. I wish there was something other then Excel that I can sort the prod database.
<snip>

When you open the file exported from the database in Notepad, are those odd characters there?

I ask because if the MySQL isn't setup properly, it could be MySQL changing the characters, not Excel.
This happened to me and we had to change the character set for MySQL.

Okay, one more clarification.
When you open the modified Excel file in Notepad are the odd characters there?
This is after you sort and save and BEFORE you upload to the database.

I have a problem whem I download a csv file from raw admin prod using a mac it will not open in excel?

Thanks John, I have opened it in all readable doc's but only one part of the file id readable .It picks up on the same product every time. Only giving approx. 4 lines and one column across. I have even installed a new version of mac office, thought it might make a difference.

I would use open office and the scalc application which is exactly like excel.

I have the exact same problem and message displayed when I try to save off the csv file afte editing.

I run a windows based system and have used excel in vaious flavours from office xp through to office 2007 and still cannot get it to save off correctly.

The only way I can get around this is to use the above program scalc with open office...This now works flawlessly.