Hi,
If you import your assets with the same entry id then you can use sql
udate/set statement to bring the selected 4 status history values from the
old H table into the new H table. I'd just make shure that there are no user
updstes from the time of the import to this update.
Regards,
Nicky Madjarov
phone: 973-202-4278
Find out how to bust your AR System performance @
http://www.SpeedUpARS.com
----- Original Message -----
From: "Dwayne Martin" <marti...@jmu.edu>
Newsgroups: public.remedy.arsystem.general
To: <arslist@ARSLIST.ORG>
Sent: Wednesday, May 13, 2009 9:09 AM
Subject: Mapping dis-similar Status Histories on data imports
Dear List,
We are exporting our data from the AST:ComputerSystem (Asset Management)
form into a totally customized form. AST:ComputerSystem has 14 Status
values and the new form has just four, so obviously several
AST:ComputerSystem Statuses have to map to just one Status in the new
form. No problem.
But what about Status History? In a data export file, Status history
looks like:
firstDate^firstUser^secondDate^secondUser^^^fifthDate^fifthUser . . .
(The "^"s appear as squares in Notepad. I don't know what they really
are.)
You would have to figure out which date&user pairs in the old form map to
which date&user pair in the new form, then pick the latest. It sounds
hideously complicated. But if anyone has ever tried anything similar, or
even has some ideas it would be good to hear from them.
Dwayne Martin,
James Madison University
(ARS 7.1 p2, RH Linux server, Oracle 10.2 db)
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
