Unable to restore pivot following earlier Save

[bytesemantics]

Hi

I'm looking for a way to save existing pivot table definitions that users create - to store those definitions and then restore at a later date.

I have persisted the pivotui.table.options dict to a jsonfile.
However upon read of the json file back to dict - I am unable to re-create the pivot state.
( I iterate across the dict.keys() and call pivotui.table.options.__setattr(key, value)).

When the widget is rendered - the original pivot state is not recreated. (I am using the same dataframe - but a new pivotui widget instance).

Is some other pivot state that I also need to persist /load ?

[PierreMarion23]

Hi, thanks for the question. The proper way to do this should be the following:

• to save the options in a dictionary: option_dict = p.table.options.to_dict()
• to load options from a dictionary: p.table._options = option_dict

This is not explained in the example notebook. I will mention it more clearly.

[PierreMarion23]

Hum, actually it looks like it doesn't exactly work as expected. I need to take a closer look.

[bytesemantics]

Thanks for confirming the issue as I had tried the approach you have suggested. One comment to make: Options[rows] is assigned correctly. Options[cols] is unassigned.

…

On Thu, 18 Feb 2021, 18:52 Pierre Marion, ***@***.***> wrote: Hum, actually it looks like it doesn't exactly work as expected. I need to take a closer look. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#10 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AALD6QOYUHWOJAKAPI3OIE3S7VOW3ANCNFSM4X2LGJ6A> .