Re: Want to Load Data from .XLS
I did it with an Excel sheet and DDE interaction. Prerequisites: - An Excel template, which need to be open at the time of import to the Windows User Tool. - a defined Page Name in Excel to refer to. Let´s choose Page-1 - hopefully ONE operating system language for ALL clients, where Excel is installed, otherwise you get crazy for column and row translations for each OS language in your active links. Use a set fields action with a value like this: (For each field, one set fields action is necessary.) for German: $DDE$ excel;Page-1;c:\programme\microsoft office\office\excel.exe;Z112S4 for English: $DDE$ excel;Page-1;c:\program files\microsoft office\office\excel.exe;R112C4 for Spanish: $DDE$ excel;Page-1;c:\Archivos de programa\microsoft office\office\excel.exe;F107C5 enjoy ;-) Martin Sturm Remedy Fairly Skilled Professional (RFSP) akRemedy wrote: Can someone please help with the following; How can I access Windows Explorer from Windows ARS User Client to 1. select an XLS file 2. open it 3. change format of three columns to show numeric data to 3 decimal places. 4. copy data from several columns in each row to an ARS 5.1.2 regular form and commit the record to Remedy. Many thanks in anticipation of your support. -- View this message in context: http://www.nabble.com/Want-to-Load-Data-from-.XLS-tf2298988.html#a6387987 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Want to Load Data from .XLS
If it were me, I'd probably write a small program in (perhaps) Visual Basic. Allow the program to accept command line arguments (e.g. the path to the Excel file and other arguments to influence the behavior of the program). The program can programmatically open the Excel file, read data from the spreadsheet (similar to performing SQL select statements against a DB). The program can also make use of the Remedy API (you can find the API installer for VB on Support Web under Community downloads) to insert the data into Remedy. Inside Remedy, you can easily create workflow which performs a run process to launch your program and pass the appropriate command-line arguments. Ben -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of akRemedy Sent: Tuesday, September 19, 2006 8:21 AM To: arslist@ARSLIST.ORG Subject: Want to Load Data from .XLS Can someone please help with the following; How can I call access Windows Explorer from Windows ARS User Client to 1. select an XLS file 2. open it 3. change format of three columns to show numeric data to 3 decimal places. 4. copy data from several columns in each row to an ARS 5.1.2 regular form and commit the record to Remedy. Many thanks in anticipation of your support. -- View this message in context: http://www.nabble.com/Want-to-Load-Data-from-.XLS-tf2298988.html#a6387987 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: Want to Load Data from .XLS
As long as we are strictly talking about the User Tool then another option might be OLE to control Excel directly. -- Carey Matthew Black Remedy Skilled Professional (RSP) ARS = Action Request System(Remedy) Love, then teach Solution = People + Process + Tools Fast, Accurate, Cheap Pick two. On 9/19/06, Watson Benjamin A Contr AFWA/XOO [EMAIL PROTECTED] wrote: If it were me, I'd probably write a small program in (perhaps) Visual Basic. Allow the program to accept command line arguments (e.g. the path to the Excel file and other arguments to influence the behavior of the program). The program can programmatically open the Excel file, read data from the spreadsheet (similar to performing SQL select statements against a DB). The program can also make use of the Remedy API (you can find the API installer for VB on Support Web under Community downloads) to insert the data into Remedy. Inside Remedy, you can easily create workflow which performs a run process to launch your program and pass the appropriate command-line arguments. Ben -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of akRemedy Sent: Tuesday, September 19, 2006 8:21 AM To: arslist@ARSLIST.ORG Subject: Want to Load Data from .XLS Can someone please help with the following; How can I call access Windows Explorer from Windows ARS User Client to 1. select an XLS file 2. open it 3. change format of three columns to show numeric data to 3 decimal places. 4. copy data from several columns in each row to an ARS 5.1.2 regular form and commit the record to Remedy. Many thanks in anticipation of your support. -- View this message in context: http://www.nabble.com/Want-to-Load-Data-from-.XLS-tf2298988.html#a6387987 Sent from the ARS (Action Request System) mailing list archive at Nabble.com. ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org