Fred,
I have setup this type of functionality before on NT platforms using
Windows Scripting Host (though you could also easily use Perl on UNIX).
As long as the file being imported has the same structure, you can use the
AR Import Tool from the command line with a predefined mapping, and
schedule it with cron or AT.
The script would open an FTP session, bring down the import files, then
run AR Import to bring in the data. I imported the data into a secondary
form and used Push filters on Merge to update/delete/add records into the
actual form based on certain record identifiers (other than the Entry ID).
Were there particulars you had questions about, or did you just need a
general idea?
Let me know,
Chris Woyton
Sr. System Engineer
Allegiant Technology
chris@allegiant-tech.com
>
> **
>
> All,
> Does anyone have a precedent for automating an import into Remedy?
> I am setting up conversions between two live systems, and their only common
> ground is that they both read .CSV files. The plan is to automate the
> export from the non-Remedy into a shared directory, then have Remedy import
> the files in (then delete them out afterward.) Any ideas?
>
> JR
>
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> Fred Wyer, Jr.
> Senior Engineer
> CRM RAC
>
> BTG, Inc.
> pgr 888.723.1264
> fwyer@btg.com
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
> _____________________________
>
>
>
_____________________________
Previous Topic
Index