I open files using taskpad (freeware download) - it's easy to read and doesn't lose the formatting.
We have a special field for emplid which can have leading zeros and often causes
chaos when someone opens the import file in excel and saves it. All the zeros disappear.
Since I've strongly encouraged the use of taskpad the havoc has been lessened.
HTH
Joanne Mansur
Client Systems Analyst
Northeastern University
Phone\617.373.3295
Fax\617.373.5985
[EMAIL PROTECTED]
| Ron Fariss <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/12/2006 04:22 PM
|
|
Mimi,
There are 2 methods for opening a .csv file to see if your formatting is
correct.
More work / Easier to Read - Rename the .csv file to .txt and then
open the new file in Excel and pay special attention to the format
for each column.
Less work / Harder to Read - Open the .csv file with notepad.
Hope this helps.
Ron Fariss
AIG Technologies
Remedy & TelAlert Administration
Work: (713) 831-2365
Cell: (281) 782-0979
Ricki Haines
<[EMAIL PROTECTED] To: [email protected]
DICAL.COM> cc:
Sent by: "Action Subject: Re: saving data as csv file
Request System
discussion
list(ARSList)"
<[EMAIL PROTECTED]
ORG>
09/12/2006 03:08
PM
Please respond to
arslist
Mimi,
If you mean you’re losing the formatting of the xls file when saving as a
csv file, here’s the fix. If you’ve already changed the cell formats in
xls, do it again in the csv file (date formats, etc.). When everything
looks the way you want it, save the csv file and DON’T OPEN it again to see
if it’s still formatted properly. If you do you’ll see that the format has
been lost and you’ll need to format again. If you have a Case ID with
leading zeroes, change the format of those to Custom and enter
000000000000000 (15 0’s) or however many you have as your input length. It
took me a while to get the hang of this, but now I have no problem
importing into Remedy.
HTH,
Ricki Haines
On Tue, 12 Sep 2006 12:00:18 -0700, Mimi Lakew <[EMAIL PROTECTED]>
wrote:
Hello,
I am trying to convert an xls file to csv file so I can import the data
in remedy as csv file. Can anyone tell me how can I convert the file
please?
Thanks!
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
