Socket
Socket
Sign inDemoInstall

x2sj

Package Overview
Dependencies
18
Maintainers
1
Versions
10
Alerts
File Explorer

Advanced tools

Install Socket

Detect and block malicious and high-risk dependencies

Install

x2sj

Transforms an excel spreadsheet into JSON for document ingestion into SOLR


Version published
Maintainers
1
Weekly downloads
9
decreased by-18.18%

Weekly downloads

Readme

Source

x2sj (Excel 2 SOLR JSON transform utility)

Node utility to transform Excel spreadsheets into JSON for consumption into the Retrieve (SOLR) and Rank service on Bluemix.

x2sj is a component utility of the Watson Catalyst program.

Prerequisites

You need to have node installed. Install it from here: http://nodejs.org

How to install

Install the package globally using npm. Note, on Linux or Mac you might need to include 'sudo' before the command

npm install x2sj -g

Usage

As the utility is stored globally, you may execute it like any other cli command:

% x2sj
Usage:
  x2sj [OPTIONS] [ARGS]

Options:
  -i, --file FILE        An XLSX file to process
  -o, --output FILE      Output file in JSON format
  -h, --help             Display help and usage details

Data

The utility operates on Excel Spreadsheets. The first column must be the operation to execute ('add', 'remove', etc). The rest of the column headers are taken to be valid attributes that will be added to the document in SOLR. If your SOLR schema does not contain a corresponding entry, then your JSON will fail to load:(

Example:

operationidcurratedontitle
add120151030doc1 title part 1
add120151030doc1 title part 2
remove220141215doc100

People

The original author is Chris Madison.

License

Apache-2.0

Keywords

FAQs

Last updated on 07 Oct 2015

Did you know?

Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.

Install

Related posts

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc