× Welcome to the fracta.net forum!

Share your coding ideas or ask questions.

How? CMS data automatic export to Excel

  • vaidookas
  • Visitor
  • Visitor
9 years 1 month ago #44 by vaidookas
Replied by vaidookas on topic How? CMS data automatic export to Excel
Hi guys,

Is there any way to extract all agent group names from CMS to excel sheet?

I would like to build the drop down box to select the agent group in excel rather than in pop up CMS window because if on popup window you select CANCEL all extcel crashes and need to end task it :)

Cheers guys in advance for the help! B)

Please Log in or Create an account to join the conversation.

More
9 years 1 month ago #45 by roller
Hi, sorry for taking a while to reply. I've been trying to see if I can export the agent's groups names using VBA but I didn't have any luck.

You can add an agent group via VBA but to list all the names I couldn't get it done. In CMS the report that displays all the agent group doesn't have an export option. All the other CMS reports I exported via VBA in the past have an option to export which I used to trigger in VBA.

So unless if someone else can contribute I don't know how to help.

Please Log in or Create an account to join the conversation.

  • rajachola
  • Visitor
  • Visitor
7 years 8 months ago #219 by rajachola
Replied by rajachola on topic How? CMS data automatic export to Excel
Hi there i tried with the code mentioned by you. I have put my user name and password. However when i run the macro it gives me error 424 object required. Not sure what that error means. I am not sure where shall i put the server ip address.
Please help.
I am trying to automatically pull the data from CMS and paste it in excel.

Please Log in or Create an account to join the conversation.

More
7 years 8 months ago #220 by roller
The sever ip or name should replace the two instances where you see "cms" in the code. For example if your server ip is 10.123.123.123 then use "10.123.123.123" with the quotation marks around it.

If you tell us which line of code the error is occurring it might help.

Please Log in or Create an account to join the conversation.

  • rajachola
  • Visitor
  • Visitor
7 years 8 months ago #221 by rajachola
Replied by rajachola on topic How? CMS data automatic export to Excel
Thanks for your reply.
I am bit confused in this as i am not very good in Macros.
What i am trying to do is, automatically pull the data from CMS -> Historical ->Designer-> Skill data /w Max delay and paste it in Excel.
For this i was looking for a code.

Appreciate your help :)

Please Log in or Create an account to join the conversation.

More
7 years 8 months ago #222 by roller
I feel your pain however we don't offer full solutions in this forum and we assume that you have some VBA experience. What you are asking has been covered in othr posts.

There are at least 4 or 5 forum posts on this site with full solutions to what you are asking for, they are aalmost identical. Please read the other post and try to give it a shot.

Please Log in or Create an account to join the conversation.

Time to create page: 0.096 seconds
Powered by Kunena Forum