One more approach:
- Process it on the command line with Meta-Update:
Pass the name of the file on the command line
Update as many tables as you like conditionally, with Merge API
or not as you like
Meta-Update automatically handles CSVs that both the Import tool and Excel
can't with embedded line feeds, escape characters, un-doubled quotes,
commas. It can apply value interpretations and transformations on read.
Meta-Update can be run on the server or client. Meta-Update allows complex
scripting in minutes.
NO need for any ARS "import table" workflow,
Consider the problem at hand: the ITSM 7 equivalent of SHR:People. You will
find the ITSM 7 has no SHR:People and instead needs multiple records in
various tables to set up a person properly depending on the rights and roles
of that person.
Yes, IF and only IF your CSV file can be processed by the import tool, you
could build a table to receive the fields of that file and all of the
workflow that will be needed to validate and transform that data and push
across the required set of records.
Or, with Meta-Update, in a matter of minutes you'll have a regular job that
can be run over and over again reliably.
For more information, check out www.softwaretoolhouse.com or get in touch
with me off-list.
Cheers and Happy Holidays
Ben Chernys
Senior Software Architect
Software Tool House Inc.
Canada / Deutschland / Germany
Mobile: +49 (0162) 175 0956 GMT + 1
Email: <mailto:[EMAIL PROTECTED]>
mailto:[EMAIL PROTECTED]
Web: <http://www.softwaretoolhouse.com/>
http://www.softwaretoolhouse.com
A free notepad for Diary fields:
<http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm>
http://www.softwaretoolhouse.com/downloads/DiaryFieldEditor.htm
An ARS integration, import, batch, migration facility:
<http://www.softwaretoolhouse.com/products/SthMupd>
http://www.softwaretoolhouse.com/products/SthMupd
_____
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz
Sent: December 27, 2006 12:35 AM
To: arslist@ARSLIST.ORG
Subject: Re: CSV file feed into Remedy
**
Hi
you could also automate using the ARImport from the command line, you will
need to create a mapping and make sure that the file has always the same
name, if the file comes in with different name you could use a batch
command to rename the file and then import it. If you need further details
on how to do this, contact me offline and I will send you complete details.
I have done a few of these.
shafqat
Axton <[EMAIL PROTECTED]> wrote:
** Here are a few approaches you could take:
- Use EIE to load the data (costs $$$)
- Create a table on your db, and write a stored procedure to load the file.
Point a view form at it and use an escalation.
- Write an ARDBC plugin and point a vendor form at the file, then use an
escalation to process it.
- use arimport to import the data (command line)
- Write a perl script to load the data using ARSPerl, schedule it to run.
I haven't gone down the path of automating the load of data into ITSM7 yet,
so I can't speak to any nuances you may encounter at that level of the load
as compared to previous versions.
Axton Grams
On 12/26/06, Jake Taylor <[EMAIL PROTECTED]> wrote:
Hello Listers,
This may seem pretty straightforward, but I've never done it before. Our
systems people are dropping a CSV file (could be a plain text file) onto
our Remedy server. What we need to do is read this file automatically (on a
scheduled basis) into the People form of our ITSM 7 suite.
What would be the easiest way to go about doing this? Would a vendor form +
and escalation suffice? Or would we need to write some sort of script to
import the data into Remedy?
Any and all advice and comments are welcome. Thanks in advance, and Happy
Holidays!
-Jake Taylor
NewYork-Presbyterian
New York, NY
____________________________________________________________________________
___
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
<http://www.arslist.org/> ARSlist:"Where the Answers Are"
__20060125_______________________This posting was submitted with HTML in
it___
Shafqat Ayaz
"You really shouldn't say 'I love you' unless you mean it. But if you mean
it, you should say it a lot. People forget."
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com __20060125_______________________This posting was
submitted with HTML in it___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
