Ahh, in the olden days we used Perl the KING of parsing engines.... On Jul 2, 7:56 am, Ben Chernys <ben.cher...@softwaretoolhouse.com> wrote: > 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: arsl...@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 WWRUG10www.wwrug.comARSlist: "Where the Answers Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives atwww.arslist.org > attend wwrug10www.wwrug.comARSlist: "Where the Answers Are" > > image001.jpg > 3KViewDownload
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"