Synchronizing data: Difference between revisions

m
no edit summary
mNo edit summary
mNo edit summary
Line 1: Line 1:
{{Stamp|2016-09-17|3.9.7|1.0.3}}
{{Stamp|2017-01-13|4.2.1|1.0.7}}


There are currently two facilities in Memento for synchronizing data. One is to the Memento Cloud. The other is to the Google Sheets application via files stored on Google Drive. They are generally quite separate services, used for mostly distinct purposes.
There are currently two facilities in Memento for synchronizing data. One is to the Memento Cloud. The other is to the Google Sheets application via files stored on Google Drive. They are generally quite separate services, used for mostly distinct purposes.
Line 5: Line 5:
== Synchronization with the Memento Cloud ==
== Synchronization with the Memento Cloud ==


The Memento Desktop Edition accesses libraries and resources stored in the Memento Cloud, and there is no local copy explicitly stored on the device.
The Memento Desktop Edition accesses libraries and resources stored in the Memento Cloud, and there is no local copy explicitly stored on the device. Though there is a download that occurs, this is specifically a cached working copy; the cloud contains the real library.


The Memento Mobile Edition stores libraries and associated resources in local storage, whether internal to the device or on mounted external media. Each of these libraries, together with associated files, may be synced to the Memento Cloud, after which the local copy and that in the cloud will be kept in sync.
The Memento Mobile Edition stores libraries and associated resources in local storage, whether internal to the device or on mounted external media. Each of these libraries, together with associated files, may be synced to the Memento Cloud, after which the local copy and that in the cloud will be kept in sync.


The Memento Cloud synchronization service is used to enable supported mobile devices to:
The Memento Cloud synchronization service is used to enable supported mobile devices to:
* Enable access to Memento libraries and associated resources across multiple devices and platforms as if they are local.
* Enable access to Memento libraries and associated resources across multiple devices and platforms as if they are local
* Share access to Memento libraries and associated resources with the public or with specific other accounts.
* Share access to Memento libraries and associated resources with the public or with specific other accounts
 
Data analysis features, such as filters, grouping, charts, and sort order are client-specific, and are not synced via the Memento Cloud.


== Synchronization with Google Sheets ==
== Synchronization with Google Sheets ==
Line 42: Line 44:
=== Notes ===
=== Notes ===


; New MEMENTO_ID column
:; New MEMENTO_ID column: When the link to Google Sheets is created (called ''binding''), an additional column will be created in the Sheet, with a title of '''MEMENTO_ID''', to enable matching of rows to entries in Memento. '''Do not modify or delete this column.'''
: When the link to Google Sheets is created (called ''binding''), an additional column will be created in the Sheet, with a title of '''MEMENTO_ID''', to enable matching of rows to entries in Memento. '''Do not modify or delete this column.'''


; Matching locale settings
:; Matching locale settings: The locale setting on your device should match the locale setting in Google Sheets.
: The locale setting on your device should match the locale setting in Google Sheets.


; Editing the same rows/entries
:; Editing the same rows/entries: If you edit the same entries/rows in Memento and Google Sheets, you will be prompted to choose which version is correct.
: If you edit the same entries/rows in Memento and Google Sheets, you will be prompted to choose which version is correct.


; Adding a new field
:; Adding a new field: Whenever you add a new field for synchronization, the Sheet file on the Google Drive is created anew.
: Whenever you add a new field for synchronization, the Sheet file on the Google Drive is created anew.


; Keep data together
:; Keep data together: All entries in the Google Sheet should follow one after another. There should be no empty rows.
: All entries in the Google Sheet should follow one after another. There should be no empty rows.


; Some one-direction-only field types
:; Some one-direction-only field types: Memento allows you to synchronize fields of all types.<br/>However, Calculation, JavaScript, & Contact fields are synchronized in one direction only &mdash; from Memento to Google.
: Memento allows you to synchronize fields of all types.<br/>However, Calculation, JavaScript, & Contact fields are synchronized in one direction only &mdash; from Memento to Google.


== Synchronization between two or more devices without the Memento Cloud, using Google Sheets ==
== Synchronization between two or more devices without the Memento Cloud, using Google Sheets ==