x2sj

0.2.1 • Public • Published

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:

operation id curratedon title
add 1 20151030 doc1 title part 1
add 1 20151030 doc1 title part 2
remove 2 20141215 doc100

People

The original author is Chris Madison.

License

Apache-2.0

/x2sj/

    Package Sidebar

    Install

    npm i x2sj

    Weekly Downloads

    10

    Version

    0.2.1

    License

    Apache-2.0

    Last publish

    Collaborators

    • tankcdr