Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jcreed/df0192bfaecc70b05835d5d3b68016cb to your computer and use it in GitHub Desktop.
Save jcreed/df0192bfaecc70b05835d5d3b68016cb to your computer and use it in GitHub Desktop.
Destination - Get Organization information for all users
File.open(Rails.root.join("sftp_schedule_information_#{timestamp}.csv"), 'w') do |file|
file.write(to_csv_schedule(all_info))
end
****
all_info = set_info_schedules
** load below in rails console
def set_info_schedules
dest = Destination.all
schedule_info = {}
dest.each do |d|
hash={}
uis= d.organization.user_identities
uis.each do |ui|
hash[ui.user.email] = "#{ui.user.first_name} #{ui.user.last_name}"
end
info = [d.name,
d.organization.cas.name,
d.organization.cas.cycle.identifier,
d.organization.name,
hash]
schedule_info[d.id] = info
end
schedule_info
end
def to_csv_schedule(data)
CSV.generate do |csv|
csv << headers_schedule
data.each do |dest|
csv << user_info_schedule(dest)
end
end
end
def user_info_schedule(dest)
[
dest[1][0],
"#{dest[1][1]} / #{dest[1][2]}",
dest[1][3],
dest[1][4],
]
end
def headers_schedule
[
'Schedulable Name',
'CAS/Cycle',
'Organization',
'Owners Email/Name)'
]
end
def timestamp
Time.now.strftime("%Y%m%d%H%M%S")
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment