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"
