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 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
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"