Sahil, I have done something similar in the past utilizing a perl script. From the parent form you call a perl script with a filter and the script uses ARSPerl to log onto Remedy, gather the information and utilize perl modules to create a csv file, then once created, utilize either perl or Remedy to email the file to the customer.
On Mon, Oct 28, 2013 at 3:17 AM, Sahil <[email protected]> wrote: > ** > Thanks Joe for the reply, > > But the requirement is bit different. > > From a custom application Data (parent- children-children structure) is > imported to Remedy interface forms, using a integration application from > third party. When data is imported to remedy interface forms, we need to > perform the validation before pushing the data to the Main forms. Now if > the validation fails, the complete information is send back the source > application via a email and with the attachment in CSV so that they can see > what is wrong in the data sent. > > For that if any validation fails, I am sending data to a Custom from > -"reporting". Then I need to read the data from the reporting form and move > to CSV file and attached to the main records and send via email to the > source application. > > > regards > > Sahil > > > On Mon, Oct 28, 2013 at 9:58 AM, Joe D'Souza <[email protected]> wrote: > >> Couldn't you just trigger an email notification from the child ticket with >> the child tickets URL embedded in the notification? >> >> What specific benefit would the receiving party have by receiving a CSV >> file >> that could not be achieved by other standard mechanisms of data exchange?? >> >> Cheers >> >> Joe >> >> >> -----Original Message----- >> From: Action Request System discussion list(ARSList) >> [mailto:[email protected]] On Behalf Of Sahil Pathania >> Sent: Monday, October 28, 2013 4:54 AM >> To: [email protected] >> Subject: Read data from a form>save in CSV file> attach to Master Record. >> >> Hello ALL, >> >> I have following requirement. I would need your expertise. >> >> I have a master ticket in Master form. I need to read the child ticket >> data >> from child form, place in CSV file and attach to the Master ticket in a >> attachment field, so that I can send email to the customer with csv >> attachment. So the customer have details of all the child tickets in a csv >> file. The csv file should have a fixed format. >> >> Will be possible by Java script or Run macro utility. >> >> Could you please share your knowledge >> >> regards >> Sahil >> >> >> _______________________________________________________________________________ >> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org >> "Where the Answers Are, and have been for 20 years" >> > > > > -- > *Cheers!!* > *Sahil Pathania* > > _ARSlist: "Where the Answers Are" and have been for 20 years_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
