Thank you Carey...if you could assist a bit more I like the idea you presented in 1...and I had considered it...but am not skilled enough personally to create this file. I am saving the csv file to the server with the name of the GUID of the record in form A. Perl is my preferred scripting language so if you have expertise in that I would appreciate your help writing that script.
I assume it would go something like this Copy template mapping to guid.arm Edit guid.arm to change the name of it to some 8 digit equivalent of the guid Save the new guid.arm file Run arimport with appropriate command line syntax for new arm Does that sound about right? -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Carey Matthew Black Sent: Friday, December 29, 2006 10:56 AM To: [email protected] Subject: Re: arimportcmd L.J., RE: " Is there something that can be done with the mapping to allow mapping a field not in the file with a command line argument? " Not to my knowledge. However here are a few ideas.... 1) Edit the mapping file before you call arimportcmd. (This could be scripted so that you call a wrapper script that does this and then calls arimportcmd too.) 2) Edit the CSV file before import. 3) Do a second import (maybe to a display only form) so you can do one or more push actions to "map the records that are not yet mapped" to the "record that had the CSV file". 4) On import(MERGE) have a filter "look up" the record that spawned the import process. (Assuming that this will be automated and that the import process is done via a Run Process action.) Note: If you can not do a select of Form A based on the data in the file then you might need to create a "queue/log" form that holds a record that says "Form A", Entry "000000000000001" is waiting for it's CSV children records. [ The only problem there is if you can get two of these things going at the same time. ] HTH. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap.... Pick two. On 12/29/06, L. J. Head <[EMAIL PROTECTED]> wrote: > ** > > ARS 6.3 > Windows 2003 > > I have Form A that contains an attachment field that has a csv > attached to it I want to import the records into Form B from the csv > attached to Form A and I want to have the records in Form B associated > with the record in Form A > > I've got all of the procudures completed except how to associate the > records in Form B with the record in Form A. > > Is there something that can be done with the mapping to allow mapping > a field not in the file with a command line argument? ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
