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 05-28-2003 17:19:36

Guest
Guest

Friendly Advice - Using EXCEL

hopefully to avoid someone else wasting as much time as I did trying to hunt this down, be warned that if you bring your CSV files into EXCEL to make any edits, EXCEL will (by default) drop off all leading zeros in any of the fields (thanks again microsoft for deciding for me what i should do).
This means that zip codes and potentially font colors will now be incorrect.
I noticed the issue when I brought my settings.csv file into excel to make some edits to item display count.
Once I went back to the ADMIN, the page woudl render but with errors.  My font color use to be black (000000) and now was simply 0.  This produced this error and some strange font colors thrughout the site.
Hope that helps someone out at some point!

 

#2 05-28-2003 17:34:06

kevbo
Member
Registered: 01-13-2002
Posts: 52

Re: Friendly Advice - Using EXCEL

One more thing.
If (like me) you are importing/merging any maillists into maillist.csv using excel, make sure that after your last entry, there is a carriage return.  I coudn't get EXCEL to do this and did it in some text editing software (without formatting).
If you leave the file (without carriage return) as CSV, CCP will function, but will incorrectly add the next addition thru admin / signup. If you convert to MySQL, CCP will report errors (as it should) the next time an address is entered thru admin or sign-up.
Hope that made sense and that it saves someone some time!

Offline

 

#3 05-28-2003 21:52:00

Todd
Member
From: Kitty Hawk, NC
Registered: 04-01-2003
Posts: 553
Website

Re: Friendly Advice - Using EXCEL

Thanks Kevbo for the good advice... I actually tried editing some csv files a few days ago with Excel and had all kinds of problems.  I however kept a backup of the original which I ended up having to use, but it is good to know about the evil things that software from Redmond can do.


there's more than one way to...



Offline

 

#4 05-29-2003 09:27:23

BooBoo
Member
From: Anaheim, CA
Registered: 07-25-2003
Posts: 147
Website

Re: Friendly Advice - Using EXCEL

Look at this link.  There is an editor that you can use that will allow you to edit CSV files, without all the Micro$oft superior intellect helping you.

<A HREF="https://forum.kryptronic.com/viewtopic.php?id=2368">https://forum.kryptronic.com/viewtopic.php?id=2368</A>


--
Keith Roberts
IT Manager
Laptops For Less, Inc
keith@getadeal.com
<a href="http://www.laptopsforless.com">Your source for laptop batteries, pda batteries, digital camera batteries, cell phone batteries, and accessories</a>

Offline

 

Board footer