The best way? There are certainly many many ways available. Misi mentions the Remedy Import Tool. Naveen gives us a bit more details. I, of-course, will talk of Meta-Update which will handle the extraction of the attached CSV, the parsing of said CSV, and the updating of what ever forms you desire based on data in the CSV with a single bit of workflow to launch the process. Imagine. No staging forms, no workflow, a simple ASCII script handles this requirement. Each row of the CSV can determine which table or rather table and record set to update/insert. Full validation, a copy of the CSV with failures being automatically created, intimate assignment control, attachments extracted, transferred to different records, renamed, etc. Meta-Update will handle CSV's with embedded quotes, line feeds, etc. The BMC Import Tool will not and neither will Excel. Meta-Update on Unix or Windows will handle each other's script files and csv file no problem. CSVs you generate can be generated on either OS for either OS. With Meta-Update this type of requirement takes 1/10th the time to develop. For a trail license with a WebEx introduction, check out the web page. Cheers Ben Chernys
Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:ben.cher...@softwaretoolhouse.com> Ben.Chernys _AT_ softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ _____ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Haque, Rezaul R Sent: July 1, 2010 8:34 AM To: arslist@ARSLIST.ORG Subject: parsing from csv ** Friends, What is the best way to pars columns from a csv format file from an attachment field then put in a Remedy form? Thanks, Rezaul Haque | Systems Engineer III | OSS-Remedy | ITIL Certified 12405 Powerscourt Drive, St. Louis, MO 63376 Office 314.288.3487 Fax 314-543-2500 charter_email_logo E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the addressee(s) and may contain confidential and/or legally privileged information. If you are not the intended recipient of this message or if this message has been addressed to you in error, please immediately alert the sender by reply e-mail and then delete this message and any attachments. If you are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or storage of this message or any attachment is strictly prohibited. _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
<<image001.jpg>>