Forum Discussion
Thanks this sheet I have put here is only a small subsample of functions in a big sheet I have that does everything from manage labels, extract blog authors, editors, publishers to find users by email address enmass (but still quicker than pulling out entire user database from admin).
Infact here is what the full sheet can do, let me know if anyone needs functions for this:
- Move Posts
- Get a count of how many members have a role (part of another sequence of functions / subs)
- Get a topic count (used repeatedly in another call to produce a list of topics for every board in the community)
- Get MessageID from URL
- Get repliy count for a given message id
- Get a users rank
- Delete messages
- Get all the labels on a a given message id
- Get all the tags on a given message id
- Clean the date given by the API into an actual date for excel
- Delete a Tag
- Delete a Label
- Create a Tag
- Create a label
- Find out the conversation style for a board id
- Get all the roles a given user has
- get the role id for a give blog role
- Get the RSVPs for an event
- get user id by email address
- Get a unique list of labels for a given board (up to 1000)
- List some of the meta data for a given collection of messages in a spreadsheet
- Post a message from excel to the community
- get all message ids for every topic in a board
- Get the name of the board a message id is in
- List all users who have not full completed registration
- List all categories in a given category
I also have a whole suite of tools that do stuff in Python as well.
Happy to share, keep in mind I may not always be able to reply right away.
- keithkelly2 years agoLeader
I'm on a similar track to build out little helper utilities, but so far only using Python and PowerQuery / M.
- allensmith812 years agoBoss
keithkelly Yeah PowerQuery could be really powerful, I wrote my VBA before PowerQuery was a thing.
Of course I am kinda at the point now where I am clearing my decks ready to build utilities using the new API for Aurora.. that should be a game changer from what is documented.
Can you imagine being able to label a post in real time as "hot" or "trending" because of realtime pageview counts....
Community Mecca.
Related Content
- 3 months ago
- 3 months ago
- 8 months ago