• Resolved jscottcoatsworth

    (@jscottcoatsworth)


    I inherited a site form a deceased webmaster that uses Table Press to create tables with book data – genre, author, subtitle etc etc. However, when I export the tables, I don’t get all the info that’s been entered into each of these on the posts where book reviews are posted.

    Is there a way to export the actual data for all the books from these tables, and not just the field names/options?

    I’ve exported the posts, and want to match in all that data.

    Thanks!

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • hollywoodonlocation

    (@hollywoodonlocation)

    I’m not the developer, but I just exported all of the data from one site and uploaded to another. I used the EXPORT and chose the JSON option which exports all of the data. If you choose CSV or HTML, it will not export everything.

    If this doesn’t help, hopefully the developer will reply soon.

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Can you please explain this some more? What data is missing from the exported table files? And are sure that the data is actually stored in the TablePress tables? For that, it would have to be visible on the table’s “Edit” screen.

    Regards,
    Tobias

    Thread Starter jscottcoatsworth

    (@jscottcoatsworth)

    So here’s what I get when I do the json export:

    {"id":"1","name":"Book ratings","description":"","author":"1","last_modified":"2017-02-15 03:34:23","data":[["YA","PG13"],["M","Mature Adult Content"],["V","Violence"],["X","Erotica"],["ALT","Alternative lifestyles, Gay/Lesbian\n(also labeled M/M, F/F, etc.)"]],"options":{"last_editor":1,"table_head":false,"table_foot":false,"alternating_row_colors":true,"row_hover":true,"print_name":false,"print_name_position":"above","print_description":false,"print_description_position":"below","extra_css_classes":"","use_datatables":false,"datatables_sort":true,"datatables_filter":true,"datatables_paginate":true,"datatables_lengthchange":true,"datatables_paginate_entries":10,"datatables_info":true,"datatables_scrollx":false,"datatables_custom_commands":""},"visibility":{"rows":[1,1,1,1,1],"columns":[1,1]}}

    No actual data. So where else might it be stored?

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    the data is actually right there, in the part:
    "data":[["YA","PG13"],["M","Mature Adult Content"],["V","Violence"],["X","Erotica"],["ALT","Alternative lifestyles, Gay/Lesbian\n(also labeled M/M, F/F, etc.)"]]
    This is the JSON notation for a table that looks like

    YA   PG13
    M    Mature Adult Content
    V    Violence
    X    Erotica
    ALT  Alternative lifestyles, Gay/Lesbian\n(also labeled M/M, F/F, etc.)

    This is the data of this table (ID 1, named “Book ratings”).

    What data (from where on the website) were you expecting to see in the table data?

    Regards,
    Tobias

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘How Do I Export the Actual Data’ is closed to new replies.