Hi Robert,
thanks for this. Now I found it.
regards
Mario
"Kern, Robert
SBA"
<[EMAIL PROTECTED] To
NS.COM> [email protected]
Sent by: "Action cc
Request System
discussion Subject
list(ARSList)" Re: saving data as csv file
<[EMAIL PROTECTED]
ORG>
13.09.2006 08:58
Please respond to
[EMAIL PROTECTED]
RG
Perhaps it was a spelling mistake and "Textpad" was meant.
..........................................................
Mit freundlichem Gruß / Kind regards
Robert Kern
Siemens AG
Siemens VDO Automotive
SV IO CW PD
Sodener Straße 9
65824 Schwalbach
Germany
Tel. +49 619 687 2546
Fax +49 619 687 792 546
E-Mail: [EMAIL PROTECTED]
Internet: http://www.siemensvdo.com
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Mario Roehr
Sent: Wednesday, September 13, 2006 8:54 AM
To: [email protected]
Subject: Re: saving data as csv file
Hi Joanne,
I searched the internet for this tool called taskpad but could not find it.
Can you give me a link where to download this tool or any other way to find
it.
Thanks in advance.
Regards
Mario
Joanne Mansur
<[EMAIL PROTECTED]
> To
Sent by: "Action [email protected]
Request System cc
discussion
list(ARSList)" Subject
<[EMAIL PROTECTED] Re: saving data as csv file
ORG>
12.09.2006 22:30
Please respond to
[EMAIL PROTECTED]
RG
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]> To
[EMAIL PROTECTED]
RG
09/12/2006 04:22 PM cc
Subject
Please respond to Re: [ARSLIST]
[email protected] saving data as
csv file
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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
