Flat data convert

[crazypokerk]

Hi, boss:
For flat data, i have some comfusions.
I have some database data, such as:

ID	PID	Title	Age	Date	Status	Avail	Remarks
1		Dept. for Tunes and Technologies
2		Dept. for Manners and Celebrations
3	1	Tend todaies
4	1	Preside platypuses
5	1	Terminate economicses
11	3	Audrey Roberts	44	145324800000
12	3	Dorothy C. Anderson	62	145324800000		1
13	3	Sam S. Baker	48	1142035200000	h		At vero eos et accusam et justo duo dolores et ea rebum.
14	3	Carl Hamilton	28			1
18	4	Pat B. Chapman	91	387417600000	s	1
19	4	Kelly Young	28		s	1	Ut wisi enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat.

   "children": [
        [null, "Node 1", "id123", 0, { "e": true }],  // index=0, type=folder
        [0, "Node 1.1", "id234", 1],                  // index=1, type=person
        [0, "Node 1.2", "id345", 1, { "age": 32 }]    // index=2, type=person
    ]

In the example provided in the document, the data comes from a database table. I want to convert it into flat data, but I'm confused about the parameters used. From what I understand, the first element in the array represents the parent ID, and the second element represents the title. However, I'm not sure what the remaining elements stand for. I would like to know if there are any additional parameters and could you please provide an explanation for all the parameters?

[mar10]

See also the documentation.

The simplest version would be something like

{
    "_format": "flat",
    "children": [
        [null, { "title":"Dept. for Tunes and Technologies" }],
        [null, { "title":"Dept. for Manners and Celebrations" }],
        [0, { "title":"Tend todaies" }],
        [0, { "title":"Preside platypuses" }],
        [0, { "title":"Terminate economicses" }],
        [2, { "title":"Audrey Roberts", "age": 44, "date":  145324800000}],
        [2, { "title":"Dorothy C. Anderson", "age": 62, "date":  145324800000, "avail": true}],
        [2, { "title":"Sam S. Baker", "age": 48, "date":  1142035200000, "status": "h", "remarks": "At vero eos et accusam et justo duo dolores et ea rebum."}],
        ...
    ]
}

We may optimize by making some common attributes positional (in this case, only title is used in all rows)

{
    "_format": "flat",
    "_positional": ["title"],
    "children": [
        [null, "Dept. for Tunes and Technologies"],
        [null, "Dept. for Manners and Celebrations"],
        [0, "Tend todaies"],
        [0, "Preside platypuses"],
        [0, "Terminate economicses"],
        [2, "Audrey Roberts", {"age": 44, "date":  145324800000}],
        [2, "Dorothy C. Anderson", {"age": 62, "date":  145324800000, "avail": true}],
        [2, "Sam S. Baker", {"age": 48, "date":  1142035200000, "status": "h", "remarks": "At vero eos et accusam et justo duo dolores et ea rebum."}],
        ...
    ]
}

To take it one step further, we can use a map to shorten the key names

{
    "_format": "flat",
    "_keyMap": { "age": "a", "date": "d", "status": "s", "remarks": "r", "avail": "v" },
    "_positional": ["title"],
    "children": [
        [null, "Dept. for Tunes and Technologies"],
        [null, "Dept. for Manners and Celebrations"],
        [0, "Tend todaies"],
        [0, "Preside platypuses"],
        [0, "Terminate economicses"],
        [2, "Audrey Roberts", {"a": 44, "d":  145324800000}],
        [2, "Dorothy C. Anderson", {"a": 62, "d":  145324800000, "v": true}],
        [2, "Sam S. Baker", {"a": 48, "d":  1142035200000, "s": "h", "r": "At vero eos et accusam et justo duo dolores et ea rebum."}],
        ...
    ]
}

It is also possible to shorten values using _valueMap, but this would only make sense if we had repeating values.