**
Thanks David – yep, tried that in
import and it didn’t work so am going to try your display field and set
up WF on merge. Thanks again!
J
From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of David Sanders
Sent: Thursday, August 17, 2006
10:38 AM
To: arslist@ARSLIST.ORG
Subject: Re: Need Help Importing
CSV Asset Records With Currency Field
Hi Candace
The correct value is numeric value +
“ “ + Currency type, like “500.00 USD”
Regards
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner
2005
Best 3rd party Remedy
Application
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk
From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Candace DeCou
Sent: Thursday, August 17, 2006
6:02 PM
To: arslist@ARSLIST.ORG
Subject: Re: Need Help Importing
CSV Asset Records With Currency Field
Thanks David – what is the
‘correct’ value – I see it displayed differently in User than
in Admin.
How in the heck are you anyway? I am
busy solving all the CSS problems here – LOL. Miss you.
J
Candace
From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of David Sanders
Sent: Thursday, August 17, 2006
10:00 AM
To: arslist@ARSLIST.ORG
Subject: Re: Need Help Importing
CSV Asset Records With Currency Field
Hi Candace
Yes, importing into currency field is
tricky. One way you could do this is to import the data into a
display-only character field, then use filters running on Merge to set the correct
value to the real currency field.
HTH
David Sanders
Remedy Solution Architect
Enterprise Service Suite @ Work
==========================
ARS List Award Winner
2005
Best 3rd party Remedy
Application
tel +44 1494 468980
mobile +44 7710 377761
email [EMAIL PROTECTED]
web http://www.westoverconsulting.co.uk
From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of Candace DeCou
Sent: Thursday, August 17, 2006
5:43 PM
To: arslist@ARSLIST.ORG
Subject: Need Help Importing CSV
Asset Records With Currency Field
We are in need of updating our existing Asset records with
Cost information and I would like to export our existing records to csv, mass
update the Cost field (Currency field) and re-import back in place to our 6.3
Patch 16 server (Windows 2003, SQL Server 2000). I am getting errors on
Import since the Currency field doesn’t seem to like any of the trials I
have set up to import to that field given that it appears to have both the
Current Type and Value fields. Unfortunately, we have recently lost
Remedy support due to lack of payment on our maintenance plan, so I would
really appreciate it if anyone can help me figure out how to import cost data
into these currency fields.
Thanks in advance for your help.
J
Candace DeCou
Applications
Support Analyst
Silicon
Valley Bank
Office:
408-654-6358
Email:
[EMAIL PROTECTED]
*****************************
This message contains information from Silicon Valley Bank, or from
one of its affiliates, that may be confidential and privileged. If
you are not an intended recipient, please refrain from any
disclosure, copying, distribution or use of this information and
note that such actions are prohibited. If you have received this
transmission in error, please notify the sender immediately by
telephone or by replying to this transmission.
This message may include indicative rate information relating to
one or more products offered through Silicon Valley Bank, or
affiliated broker-dealer, SVB Securities. Rates and yields shown
are provided for informational purposes only, are not guaranteed,
and are subject to market conditions and availability. Nothing in
this communication shall constitute a solicitation or
recommendation to buy or sell a particular security.
Columbia Cash Reserves, Columbia Treasury Reserves, Columbia
Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB
Securities Institutional Liquid Reserves and SVB Securities Horizon
Shares are offered through SVB Securities, a registered broker-
dealer and non-bank affiliate of Silicon Valley Bank. Investments
in these products require the involvement of a licensed
representative of SVB Securities. Investment products offered
through SVB Securities are not insured by the FDIC or any other
Federal Government Agency, are not deposits of or guaranteed by
Silicon Valley Bank or its affiliates, and may lose value.
__20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
*****************************
This message contains information from Silicon Valley Bank, or from
one of its affiliates, that may be confidential and privileged. If
you are not an intended recipient, please refrain from any
disclosure, copying, distribution or use of this information and
note that such actions are prohibited. If you have received this
transmission in error, please notify the sender immediately by
telephone or by replying to this transmission.
This message may include indicative rate information relating to
one or more products offered through Silicon Valley Bank, or
affiliated broker-dealer, SVB Securities. Rates and yields shown
are provided for informational purposes only, are not guaranteed,
and are subject to market conditions and availability. Nothing in
this communication shall constitute a solicitation or
recommendation to buy or sell a particular security.
Columbia Cash Reserves, Columbia Treasury Reserves, Columbia
Institutional Cash Reserves, SVB Securities Liquid Reserves, SVB
Securities Institutional Liquid Reserves and SVB Securities Horizon
Shares are offered through SVB Securities, a registered broker-
dealer and non-bank affiliate of Silicon Valley Bank. Investments
in these products require the involvement of a licensed
representative of SVB Securities. Investment products offered
through SVB Securities are not insured by the FDIC or any other
Federal Government Agency, are not deposits of or guaranteed by
Silicon Valley Bank or its affiliates, and may lose value.
__20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___
__20060125_______________________This posting was submitted with HTML in it___ |