props-command

Command-line tool to manipulate Java properties files

Installation

npm install -g props-command

Usage

Synopsis

$ props <command> <command-args> [<global-options>]

Command List

• merge: Merge a properties file into an other properties file.
• sort: Sort by keys.
• format: Alias for sort command.
• subset: Select a subset of properties according to a pattern for keys.
• from-xlsx: Extract properties file from an XLSX (Excel) file.

Global options

• --no-backup: There will no more backup made for overwritten files.

merge

$ props merge <from-properties-file> <into-properties-file>

Each property of <from-properties-file> is added to <into-properties-file>. For each property with same key inside the two files, the value from <from-properties-file> is used to overwrite the property in <into-properties-file>.

from-xlsx

$ props from-xlsx <from-excel-file> <excel-file-structure-description> <into-properties-file>

Each property extracted from <from-excel-file> is added to <into-properties-file>. For each property with same key inside the two files, the value from <from-excel-file> is used to overwrite the property in <into-properties-file>.
If <into-properties-file> file does not exist, it will be created.

<excel-file-structure-description> is a JSON file describing where properties keys and values are stored in the Excel file. See sample below:

{
    "sheet": "Sheet 1",
    "keyColumn": "I",
    "valueColumn": "H",
    "firstLine": 2,
    "escape": true
}

escape option specify if special characters like \ must be escaped. Default value is false.

Filter

In order to skip some lines, it's possible to define a filter, testing a particular column for a particular value.

{
    "sheet": "Sheet 1",
    "keyColumn": "I",
    "valueColumn": "H",
    "firstLine": 2,
    "escape": true,
    "filter": {
        "column": "C",
        "value": "OK"
    }
}

#### Multiple sheets

It's possible to extract properties from multiple sheets, using sheets field instead of sheet field.

{
    "sheets": [
        "Sheet1",
        "Sheet2"
    ],	
    "keyColumn": "I",
    "valueColumn": "H",
    "firstLine": 2,
    "escape": true,
    "filter": {
        "column": "C",
        "value": "OK"
    }
}

to-json

$ props to-json <properties-file> <json-file>

Each property extracted from <properties-file> is added to <json-file>. For each property key containing some dot, a proper nested object is created. For each property with same key inside the two files, the value from <properties-file> is used to overwrite the property in <json-file>.

If <json-file> file does not exist, it will be created.