You can run the import tool as a user without administrator rights (I just tried it on ARS7 to make sure that I wasn't dreaming that I had done it before). It depends on how much you trust the user and your environment but you could give them the import tool.
You could even create a filter that would give them an error if they try to import into another form. You could use something like $ CLIENT-TYPE$ = 4 AND (NOT ($ GROUPS$ LIKE (( "%" + "Administrator" ) + "%" ))) in the Run If you needed to make sure they don't import into forms other than the one you expect them to. Expanding on Rick's idea and your idea of using a file, you could put the script or even a batch file on the server. You would still need to supply the authentication in the script but at least it would be server side (theoretically the server should be secure). Then you could either run an escalation to run arimport against their file a on share or if there is a need to allow them to trigger the import at any time you could create a button and active link that triggers a filter that in turn runs arimport against the file on the share. Either way I would suggest creating a form just for them to import into and then you can do error checking against the records that are created and only push records to the final form if they meet the correct criteria. Jason From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Rick Cook Sent: Wednesday, July 11, 2007 4:14 PM To: arslist@ARSLIST.ORG Subject: Re: Importing csv file into Remedy ** 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> mailto:[EMAIL PROTECTED] 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 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
