¿ªÔÆÌåÓý

Re: Import & Export of CSV Database files in JSON format


JoAnn Taylor-Rice
 

Hi,
I finally figured out the correct JSON format after several hours of trial and error.
Thank you.
JoAnn

On Tue, May 7, 2019 at 11:39 PM Shal Farley <shals2nd@...> wrote:
JoAnn,

Your Subject text confuses me. Did you mean "Import & Export of Database
files in JSON format"? If not, the phrase "CSV Database files" is what I
don't understand.

?> I tried this multiple times and the only row that would export was the
?> HEADER row.

I've used the Export Table button, sometimes selecting JSON, and other
times selecting CSV. In each case all rows were included. So I'm not
sure how it could be going wrong for you.

In the case of JSON, the table parameters come first, then column
definitions, then row contents. In JSON the concept of a HEADER row is
implemented as an array of column definition objects. Likewise the rows
are represented as an array of row definition objects, each of which
contains some row parameters followed by an array of column values for
that row. JSON is a rather tediously verbose format for humans, but it
does capture all of the information about the table, where CSV does not.

?> I tried selecting rows thinking that was preventing the actual lines
?> to export properly. That did not work either.

No, that doesn't seem to matter.

Shal


--
Help: /static/help
More Help: /g/GroupManagersForum/wiki
Even More Help: Search button at the top of Messages list



Join [email protected] to automatically receive all group messages.