Gives you binary mysqlexport and Ruby classes to export mysql tables into csv and json files
ActiverecordDataImporter is enable to load and import file (format is csv, json) for ActiveRecord's model. For example, when you must use and import master data(ex. game character, enemy, and item stc), it will help you.
This gem provides a converter between an existing JSON file and an existing CSV file. The Mapping is provided via YAML.
Turn your json, csv, md, or strings into grocery lists that you can then search for.
a tiny read/write dot notation wrapper for Hash, JSON, YAML, CSV, and ENV
Turnstile is a Redis-based library that can accurately track total number of concurrent users accessing a web/API based server application. It can break it down by "platform" or a device type, and returns data in JSON, CSV of NAD formats. While user tracking may happen synchronously using a Rack middleware, another method is provided that is based on log file analysis, and can therefore be performed outside web server process.
Converts the json data from surrey traffic loops API into CSV.
Convenience methods for reading CSV, TSV, & JSON files
This set of commands converts a CSV file to the following formats: - .strings (iOS) - .xml (Android) - .json - .php
Easily view SNMP tables in a variety of different formats including as a table in the terminal, json or csv.
# EventReporter EventReporter is a CSV parser and sorter. you can load a CSV and then search it. ## Installation $ gem install the_only_event_reporter_ever $ gem list event_reporter -d ## Usage After installation run: $ event_reporter Then Type 'load <filename>' to load records from a CSV $ Load event_attendees.csv Try these commands $ Find first_name sarah $Queue Print $Queue Save to <filename> ### Saving the queue accepts extensions JSON, XML, TXT, CSV. ## Contributing 1. Fork it 2. Create your feature branch (`git checkout -b my-new-feature`) 3. Commit your changes (`git commit -am 'Add some feature'`) 4. Push to the branch (`git push origin my-new-feature`) 5. Create new Pull Request
This gem transform a csv string in a json string.
json2 takes a json file as input and outputs a clean csv.
apiify is a little gem that takes any .csv file and turns it into an API. It's aimed at large organisations, e.g. government departments, that publish a lot of data as .csv and who want a quick way to access this data as JSON in their digital services.
A customizable command-line JSON/CSV converter
Generate a JSON table schema from a CSV file
Convert a stream of json objects to csv
Use a given JSON and fields names to generate a CSV.
This Ruby lib aims at converting JSON files composed of arrays of objects (all following the same schema) into CSV files where one line equals one object.
(rM: Fixing problem with to_csv.) Gattica is a easy to use Ruby Gem for getting data from the Google Analytics API. It supports metrics, dimensions, sort, filters, goals, and segments. It can handle accounts with 1000+ profiles, and can return data in CSV, Hash, or JSON
Gem will help with converting Json to csv
Adds a `rails dbrunner` command that executes SQL against your database. Accepts inline SQL, .sql files, or stdin. Outputs as table, CSV, or JSON.
A simple yet powerful tool to analyze method usage in Ruby/Rails codebases. Track which methods are called most frequently, filter by receivers or method names, and export results in table, JSON, or CSV format. Perfect for understanding code patterns, refactoring decisions, and identifying heavily-used APIs.
This gem converts arrays of JSON objects, arrays of hashes, arrays of ActionController params, simple hashes, or ActiveRecord relations and objects to a CSV-formatted string.
A Command-Line Tool converting CSV to JSON
# MakeData A CLI for generating fake json, csv, or yaml data. Uses Faker to produce fake data in whatever category you choose. ## Quick Start Requires `peco`, so `brew install peco` (or however you get packages) ``` mkdata ``` Follow the prompts to select the category, keys, count, and format. ## Options `-h --help` Shows the help menu `-c --category [CATEGORY]` choose a category from Faker. (I can never remember these, so I use the interactive mode. Mostly here so that this could be used without interaction, like in a script) `-f --format [FORMAT]` json, csv, or yaml. What format to generate the data in. `-a --all` use all the keys from that Faker category.
This gem creates Hashie::Mash objects from YAML, JSON, CSV. Use various uses.
## Dinosaur Catalog It may not be immediately evident, but I am a huge fan of dinosaurs. They're huge and dangerous and have cool names like Giganotosaurus (not to be confused with Gigantosaurus). ... Anyway. I need to catalog some dinosaurs for my newest project, DinoDex. I've got a CSV file for the dinosaur facts, and I need the code to read all the dinosaur facts and do some basic manipulations with the data. ### Requirements Go check out the CSVs and come back. Done? Cool, I've just got a few features I need: 1. I loaded my favorite dinosaurs into a CSV file you'll need to parse. I don't know a lot about African Dinosaurs though, so I downloaded one from The Pirate Bay. It isn't formatted as well as mine, but please try to parse it anyway. 2. I have friends who ask me a lot of questions about dinosaurs (I'm kind of a big deal). Please make sure the dinodex is able to answer these things for me: * Grab all the dinosaurs that were bipeds. * Grab all the dinosaurs that were carnivores (fish and insects count). * Grab dinosaurs for specific periods (no need to differentiate between Early and Late Cretaceous, btw). * Grab only big (> 2 tons) or small dinosaurs. * Just to be sure, I'd love to be able to combine criteria at will, even better if I can chain filter calls together. 3. For a given dino, I'd like to be able to print all the known facts about that dinosaur. If there are facts missing, please don't print empty values, just skip that heading. Make sure to print Early / Late etc for the periods. 4. Also, I'll probably want to print all the dinosaurs in a given collection (after filtering, etc). #### Extra Credit 1. I would love to have a way to do (and chain) generic search by parameters. I can pass in a hash, and I'd like to get the proper list of dinos back out. 2. CSV isn't may favorite format in the world. Can you implement a JSON export feature? Happy Hunting. (Giganotosaurus was the largest hunting dinosaur, at 46 feet long and up to 8 tons! Suh-weet.)
Describe a kind of file once, with its directory, extension, MIME type and encoding, and get validation, atomic and locked creation, copying and moving, and conversions into other formats (variants) for it. Ready-made classes cover text, CSV, JSON, images, PDFs and ZIP archives; image, PDF and archive work is delegated to the command line tools wrapped by gubbins-shell. RSpec mocks for all of it are included.
Fetches your Garmin Connect activities and prints them as a table, JSON, NDJSON or CSV, for people at a terminal and for agents in a shell.
CSV to JSON Converter parses raw CSV text into an array of JSON objects with column names and row counts. It handles comma, semicolon, tab, or pipe delimiters, with optional header row detection.
Upload XLSX, XLS, ODS, CSV or JSON files and get SQL for PostgreSQL, MySQL, MariaDB, SQLite, SQL Server or Oracle back from the IntoSQL API, with webhook verification.
Make a Calendar Toolkit is an offline Ruby library and command-line tool for calendar grids, US federal holiday dates, business-day arithmetic, recurring pay schedules, rotating shifts, NRF-style retail fiscal calendars, date conversions, SVG and HTML calendars, JSON and CSV data, and date-only iCalendar exports. It is original Ruby code inspired by practical date workflows; it does not call or reproduce the private implementation of Make a Calendar. Created by Ethan, the developer behind Make a Calendar. The project's RubyGems page provides clickable links to the official website and related browser-based date resources.
Read the bookmarks and history for Brave, Chrome, Chromium, Firefox, Safari and Tor Browser, and render them to CSV, JSON or a property list.
Static analysis engine for JavaScript and TypeScript trees. Detects hardcoded secrets, high-entropy tokens, and sensitive API paths, then emits table, JSON, CSV, SARIF, or Markdown. Fails CI when a severity threshold or cumulative impact score is exceeded. Serialized reports mask matched values.
A Ruby library for working with multi-dimensional data using named dimensions. Initialise from an array of hashes making it trivial to use with databases, CSV, JSON, and YAML. Dimensions and coordinates are inferred automatically.
RDF::CSV processes tabular data with metadata creating RDF or JSON output.
JSON to CSV Converter converts an array of JSON objects into structured CSV text. It outputs formatted CSV content, detected column headers, and row counts, with support for custom delimiters like commas, tabs, or pipes.
Hvor is a mountable Rails engine providing an ActiveJob that downloads and imports IP2Location LITE CSV zip archives (IPv4 + IPv6 ranges mapped to country_code) into an IPRange model, a cached Hvor.lookup(ip) API, and a lightweight mounted JSON API for looking up an arbitrary IP or the requesting client's own IP.
Scryer is an all-in-one security auditing and static analysis tool for Ruby on Rails applications — tells you what to fix first, across security, performance, dependencies, and code quality. It scans a Ruby/Rails codebase for security vulnerabilities, performance problems, dependency risk, and code-quality issues, then ranks everything it finds by severity across all of those categories — so a scan ends with one answer to "what's most worth fixing," not four separate reports to reconcile by hand. (Style/lint is RuboCop's job — Scryer doesn't touch that, except one narrow check.) Detects SQL injection, mass assignment, SSRF, path traversal, IDOR, insecure JWT/CORS/session config, hardcoded secrets, XSS, weak crypto, and more; N+1 queries, missing pagination, and other performance heuristics; near-duplicate code; and known-vulnerable gems via a live OSV.dev dependency audit — on by default, every run. Every finding includes a human-reviewable suggested fix — never auto-applied, optionally rewritten against your actual code by any LLM you configure. Reports in JSON, self-contained HTML, CSV, or SARIF (for GitHub Code Scanning). Zero runtime dependencies beyond Ruby's own stdlib.
A code risk scoring CLI for Ruby and JS/TS projects. Ranks every file by five signals — fan-in (blast radius), fan-out, cyclomatic complexity, git churn, and test coverage — with temporal coupling analysis and a diff mode for scoring only the files changed in a PR. Table, JSON, CSV, and Markdown output.
Markdownator converts PDF, Word, Excel, PowerPoint, EPUB, HTML, CSV, JSON, XML, ZIP archives and images into clean Markdown suitable for large language models, using a pluggable converter architecture.
A mountable Rails engine providing a complete data import workflow: upload/configure, preview with validation, and import. Supports CSV, JSON, XLSX, and API sources with a simple DSL for defining import targets.
tucue plays local audio files (mp3/wav) in a terminal UI, lets you mark timestamps with optional labels, and export them as CSV or JSON. Playback is delegated to mpv.
Fibrio parses large JSON array, NDJSON, and CSV inputs record by record without loading the full source into memory.
SolidStackWeb is a mountable Rails engine that provides a production-ready operations dashboard for the full Solid Stack. It covers Solid Queue (job browser, failed job retry with inline argument editing, queue pause/resume, recurring tasks, performance stats, CSV export, and alert webhooks), Solid Cache (entry browser, size distribution, 24-hour write timeline, and optional value preview), and Solid Cable (channel browser, per-channel message list, and purge controls). Ships with dark mode, Turbo Stream responses, a JSON metrics endpoint, and no asset pipeline dependency.
Mount SolidQueueWeb in any Rails app using Solid Queue to get a full-featured job dashboard: inspect jobs by status (ready, scheduled, running, blocked, failed), retry or discard failed jobs, reschedule or run scheduled jobs immediately, manage recurring tasks, filter by queue/priority/period, export to CSV, detect slow jobs, view queue depth sparklines, track job performance (p50/p95), and scrape a /metrics JSON endpoint for external monitoring — all without leaving your app.
Read SQLite and legacy plist .abbu archives or opt into read-only live macOS Contacts access. Query contacts, inspect schemas and diagnostics, compare identity evidence, extract images, and export CSV, JSON, or vCard.
Generates localization files from spreadsheets using the localio gem. Supports Google Drive, XLS, XLSX, and CSV sources with output for Android, iOS, Swift, Rails, JSON, Java Properties, RESX, and Twine.
A Ruby library for working with multi-dimensional data using named dimensions. Initialise from an array of hashes making it trivial to use with databases, CSV, JSON, and YAML. Dimensions and coordinates are inferred automatically.