Macro to CSV Update
Last Updated -
Here, we'll show you how to connect to a Desk.com account and export all macros to a comma-separated value (CSV) file. This is a great way to audit macros for organizational and clean up purposes.
Before proceeding with this article, it should be noted that you would need some programming proficiency and experience so a developer may be required.
This script is written in Ruby and requires at least version 2.3.0, or above. To check which version of Ruby you have installed, simply run
ruby -v in a terminal.
Note: Using RVM to manage your Ruby installations is highly recommended.
Download the sample code at: https://support.desk.com/customer/portal/kb_article_attachments/128599/original.zip?1518800918
Navigate to the folder (for example using:
cd ~/Desktop/Macro-to-CSV)in a terminal and run these commands:
gem install bundler
Now run the following:
You should be prompted for your connection details and if everything is correct, you will see a progress bar while this is running.
A CSV file will be created with the format: domain_desk_com-macros-YY_MM_DD.csv in the directory of