Dylan; A lot of your decision should be based on "how" you get the file and what "format" you can get it in.
1. Is a file the only way? How about a query into the database it comes from? 2. The file is emailed to you and they have no way to do FTP or copy it to your server? 3. The file can "not" be formatted before being sent to you? If they have a database that this file is made from (scream and shout) to get access, then make a view form or maybe a Web service if they support it. If they can format the file as CSV or ASC and can automate copying it to your server, then use arimport command line and a Remedy escalation. If they can not format it before you get it, then you will have to use "something" to parse it to a format you can use (maybe arspearl if you have it). Bill Clary Remedy Developer, Tech Solutions, FIS "Wheeler, Dylan" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>... I'm trying to figure out the best way to do a scheduled data import into remedy. We have a file that we get every week that contains a list of our network users and I need to automate getting that data into remedy. We are using 6.3 with MS SQL on the back end. Would it be easiest to schedule a sql job to import that data? I'm not used to getting user data this way. I've always had access to everything from AD so I just used Vendor forms to get it. Just looking for some advice. ------------- Dylan Wheeler Production Control Analyst Principal IT Operations Downey Savings & Loan Association, F.A. Email: [EMAIL PROTECTED] This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. This message and any attachments are for the intended recipient(s) only and may contain privileged, confidential and/or proprietary information about Downey Savings or its customers, which Downey Savings does not intend to disclose to the public. If you received this message by mistake, please notify the sender by reply e-mail and delete the message and attachments. ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ---------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
