Well, it's kinda low-tech, but if you had a little Perl or VB script that the user could run that would prompt for the file name and form name, which it could then plug into the command line structure to execute AR Import, that seems like it could work. Only downside is that you would have to probably hard-code authentication data for a user with administrator rights into the script, or put your users in the Administrator group (neither of which is probably a good idea).
Rick On 7/11/07, Joe D'Souza <[EMAIL PROTECTED]> wrote:
** This was easily achievable in the earlier versions of MS-SQL using the data transformation services on MS-SQL which had the ability to connect to CSV files or Excel or Access or other RDBMS's or DBMS's. I'm not quite sure if this is possible on MS-SQL 2005 as I do not see that option available at least out of the box on SQL 2005. Maybe its a separate product now sold separately? It would be possible using Remedy's EIE engine, if you are willing to deal with a few share of problems it seems to be bundled out with where no fixes seem to have been offered by Remedy support for a while now - Or at least that's what I heard on a thread I had started out earlier describing problems I am facing with it. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG <arslist@ARSLIST.ORG>]On Behalf Of brooksm Sent: Wednesday, July 11, 2007 6:38 PM To: arslist@ARSLIST.ORG Subject: Importing csv file into Remedy Does anyone know of a way to allow end users to import records from a .csv into Remedy? My Remedy system is on SQL Server 2005, so I thought there may be a way to create an SSIS package that imports a file from a shared directory when triggered by workflow. Does anyone know if this is possible? Or is there some other easier way? Thanks Brooks
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
