Macro to CSV Update

Last Updated -

Overview

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.

Requirements

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.

If you have an older version installed, it's very easy to upgrade and manage different versions with the Ruby Version Manager (RVM). Please see the RVM website for installation instructions.

Note: Using RVM to manage your Ruby installations is highly recommended.

Installation

  1. Download the sample code at: https://support.desk.com/customer/portal/kb_article_attachments/128599/original.zip?1518800918

  2. Navigate to the folder (for example using: cd ~/Desktop/Macro-to-CSV)  in a terminal and run these commands:

  3. gem install bundler

  4. bundle install

Usage

Now run the following:

ruby macro_to_csv.rb

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 Macro-to-CSV .

You're done!

Attachments

Macro-to-CSV.zip