CsvUtils

• dedup: Given 2 CSV files, this gem will create a third CSV file that contains rows from the first CSV file that are not present in the second CSV file.
• xls to csv: Given an XLS file, this gem will create a CSV file with the specified name.

Installation

gem install patchwork_csv_utils

Usage

require 'csv_utils'
CsvUtils.dedup('file1.csv', 'file2.csv', 'output.csv', ['mandatory_headers'])
CsvUtils.to_csv('file1.xls', 'output_file1.csv', ['request_ids_to_skip'], ['mandatory_headers'], ['status_exclusions'])
CsvUtils.transform_csv('file1.xls', 'output_file1.csv', ['request_ids_to_skip'], ['mandatory_headers'], ['status_exclusions'])

Release

• to release a new version, update the version number in lib/patchwork_csv_utils/version.rb
• push the changes to github and then create a tag with the version number

git tag -a v0.1.0 -m "v0.1.0"
git push origin --tags

Contributing

Bug reports and pull requests are welcome on GitHub at http://github.com/patchworkhealth/csv_utils.