#1 2012-04-29 20:18:12

andybrown
Member
Registered: 2008-05-20
Posts: 107

tWriteJSONField Usage

The components guide isn't really clear on exactly how to use this component. Here is my scenario...

I have a CSV file coming in that contains 6 columns:

Name, Description, Attribute 1, Attribute 2, Attribute 3, Attribute 4

My goal is to populate another file that contains three columns

Name, Description, Attributes

The Attributes column needs to contains a the JSON output from the Attribute columns in the original file. I do get this output, however the Name and Description columns are ending up null in the final output. I tried adding these to the Group By list, however that didn't make a difference.

Do I have to define ALL fields in the JSON tree, and those in GroupBy will be taken out of the JSON-formatted output?

Offline

#2 2012-05-02 06:01:54

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tWriteJSONField Usage

Hi

When using tWriteJSONField, the fields which are not defined in JSON tree will not pass into next component.
You might use tFilterColumns to filter columns.

Regards,
Pedro


Only Paranoid Survive.

Offline

Board footer

Powered by FluxBB