I've written such a Meta-Update script to help another consultant fix up a bad import. He did it with a free 30-day trial license.
The script is relatively trivial. If interested in finding out more, please let me know. The control characters are x'04' between the ascii date integer and the login name and x'03' between "entries" (ie after the login name and before the next date). They "should" be "documented" in ar.h but I can't seem to find them right now. Cheers Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: mailto:[email protected] Web: http://www.softwaretoolhouse.com A free notepad for Diary fields: http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm An ARS API scripting tool used for migrations, integrations, imports, reports, extracts, batch jobs: http://www.softwaretoolhouse.com/products/SthMupd -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Dwayne Martin Sent: May 13, 2009 3:10 PM To: [email protected] 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:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
