¿ªÔÆÌåÓý

  1. GroupManagersForum
  2. Topics

Import & Export of CSV Database files in JSON format

JoAnn Taylor-Rice
 

I finally imported a database.? However, I thought I should probably test out the export feature to make sure the DB rows could all be exported properly.? I tried this multiple times and the only row that would export was the HEADER row.? I tried selecting rows thinking that was preventing the actual lines to export properly. That did not work either.
Has anyone figured out how to do this?? If so, please provide short summary of the steps.
Thanks so much.
Regards,
JoAnn
 

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
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

1 - 3 of 3