doodlesalot
12/18/2014 - 11:44 PM

This is a very rudimentary script of exporting data from desk.com to a CSV file.

This is a very rudimentary script of exporting data from desk.com to a CSV file.

require 'desk_api'
require 'csv'

# Create the CSV files
cases        = CSV.open('./cases.csv', 'wb')
interactions = CSV.open('./interactions.csv', 'wb')

# Add the headers to the CSV files
cases << ['Case #', 'Subject', 'Description', 'Status']
interactions << ['Case #', 'Body', 'Created Date']

# Run through the cases and interactions assuming DeskApi has been configured globally
DeskApi.cases.all do |res|
  cases << [res.id, res.subject, res.description, res.status]
  res.replies.all do |reply|
    interactions << [res.id, reply.body, reply.created_at]
  end
end