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"

Reply via email to