Had the same issue a little while ago which is slightly similar to yours... I get sent a text file with all users from LDAP on a regular basis and with the imported data I create user accounts on our customised application .. These are the items which I have built for this purpose: 1. A from to hold the imported data. This form is only used to clean up, validated and perform additional preprocessing stuff on teh data. 2. Filters which will take care of the preprocessing and push the data the relevant form(s). 3. A one liner batch script which calls the arimport.exe (Remedy CLI utility for importing data) which references the mapping, where the data is, what form to import too and what log file to write too. 4. An escalation which runs at a regular time which, first, truncate the table (to avoid fillinig up the log segment) and calls the batch script to import the data to the main form (from 1). If you need to see the script and the rest of the items, please email me on [EMAIL PROTECTED] thanks Shafqat Ayaz <[EMAIL PROTECTED]> a écrit : ** 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 __20060125_______________________This posting was submitted with HTML in it___ --------------------------------- Découvrez une nouvelle façon d'obtenir des réponses à toutes vos questions ! Profitez des connaissances, des opinions et des expériences des internautes sur Yahoo! Questions/Réponses. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"