I actually tried that James – a concatenation
of two columns – one for Type and one for Value – that didn’t
work either. But when I look at any ‘real’ value entered into
the Currency field under normal conditions, I see this:
Type | Value
USD 250.00
JPN
XYZ
ETC
Uh, something like that, so instead of
having only the one Type, it is displaying all available types directly as attributes
in the saved value for the field. I thought maybe that was the problem.
So here is my solution – I went back to the requester and asked if the
values for most records would be similar or same. He said yes, so I
simply performed a Modify all on roughly 4 different asset types and that just
worked beautifully. I would still like to know how to do this the other
way though, so I will most likely try the previous recommendations.
Thanks!
J
Candace
From: Action Request
System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG]
On Behalf Of McKenzie, James J C-E
LCMC HQISEC/L3
Sent: Thursday, August 17, 2006
9:48 AM
To: arslist@ARSLIST.ORG
Subject: Re: Suspected Spam: Need
Help Importing CSV Asset Records With Cu rrency Field
Candace:
You will need at least two fields
to set a Currency field. They are Currency.value and currency.type (there
are actually three fields for currency.) Without the type of currency
(i.e. USD), the update will not 'take.' You stated that you are
working on a comma separated variable file and it should have the currency.type
in the file.
James McKenzie
________________________________
From:
Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Candace DeCou
Sent: Thursday, August 17, 2006
9:43 AM
To: arslist@ARSLIST.ORG
Subject: Suspected Spam: 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___
__20060125_______________________This posting was submitted with HTML in it___
