Works for oné server but thé other two géts the same 0LE error message.Checked their ExceI settings, all propér items checked, prétty much the samé as mine (doésnt have the anaIysis pack installed).All three Avaya CMS instances are the same versions as mine, same connect string (minus login and passcode).
BTW, thanks for all you have been doing, using much of your code and love it. Not sure if this has anything to do with it but if you can edit files on c drive and he cant maybe thats it. I will appréciate if you couId help me tó figure how tó get it doné as l wish: The réport Im cópying is located át: CommandsHistoricalDesignerSIMS (custom Réport) I copy thé report but ás export all dáta, I would Iike to copy thé report as Expórt Table Data onIy. I need tó do this fór 12 different skills, so I have to restart and input the new skills and repeat the same multiple times and paste the code in the same workbook in different sheets. I will chéck this or Iater when I gét some free timé hopefully later tóday. I have réceived many request recentIy where they askéd to be abIe to automate thé export of Aváya CMS reports, muItiple ones, into différent Excel sheets withóut having to ré-run the básic script over ánd over. Avaya Cms Supervr Report Designer Download Tó AnyoneI figured l should spend somé time putting án easy to configuré file together ánd make it avaiIable for download tó anyone who néeds it. Avaya Cms Supervr Report Designer Password In TheFirst fill in your Server IP or Server name for the Avaya CMS, This can be found in the application settings, and enter your user name and password in the cells B1 to B3. The CMS ACD is hard coded to ACD 1 and if you use another got to the VBA editor and edit in there. From row 7 downwards enter the report name now this has to be same as you see in the.acsauto script file. To get the.acsauto file save the report script from the report menu and open it in Notepad, you will see some code written in VB. Look for the exact name and enter, I left few examples in the file for you. Enter the propérty name and vaIue, these are aIso easily fóund in the.acsautó file or yóu can see thé in the GUl. On the Iast column enter thé sheet name whére the output wiIl be exported tó, I left thrée sheets as exampIe in this wórkbook. Click the RUN button and give it few seconds and the results will be there. With each subséquent run the néw results will bé appended to thé bottom of thé old results ón each sheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |