Synchronizing data: Difference between revisions

m
no edit summary
mNo edit summary
mNo edit summary
Line 3: Line 3:
'''''[[This page is potentially incorrect, incomplete, and under development.]]'''''.
'''''[[This page is potentially incorrect, incomplete, and under development.]]'''''.


There are currently two facilities 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 mostly for distinct purposes.
There are currently two facilities I'm 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.


== Synchronization with the Memento Cloud ==
== Synchronization with the Memento Cloud ==
Line 40: Line 40:
Then you will see all the libraries synchronized with the current Google account. After selecting a library, it will be created on your mobile device and will receive all the data from the linked Google spreadsheet.
Then you will see all the libraries synchronized with the current Google account. After selecting a library, it will be created on your mobile device and will receive all the data from the linked Google spreadsheet.


=== Synchronization between two or more devices without the Memento Cloud, using Google Sheets ===
=== Notes ===
Using synchronization with Google Sheets, you can synchronize library data on multiple devices.
 
; New MEMENTO_ID column
: In the Google Sheet, an additional column will be created, 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
: The Locale setting on your device should match the locale setting in Google Sheets.
 
; Editing the same rows/entries
: If you edit the same entries in Memento and Google Sheets, you will be offered to choose which version is correct.
 
; Adding a new field
: Whenever you add a new field for synchronization, the sheet in Google Docs is created anew.
 
; Keep data together
: All entries in the Google Sheet should follow one after another. There should be no empty rows.
 
; Field types for synchronization
: Memento allows you to synchronize only fields of certain types: text, integer, real number, date, date/time, rating, currency, single-choice list, multiple-choice list, location, boolean, hyperlink, barcode.
 
== Synchronization between two or more devices without the Memento Cloud, using Google Sheets ==
 
To sync a library between devices, synchronization with the Memento Cloud is the recommended solution. See [[Cloud storage and Teamwork]]. If use of the Memento Cloud is not possible or desired, you can use the following method.
# On all devices, select the same Google account. On the main device, synchronize the library with Google Sheets.  
# On all devices, select the same Google account. On the main device, synchronize the library with Google Sheets.  
# On the other devices, download the library, as described in previous section.
# On the other devices, download the library, as described in the previous section.


At this point in the library restructuring process, changes on one of the devices (for example adding new types of fields) are not transferred to the other devices. You need to repeat the procedure for linking libraries for all the other devices.
At this point in the library restructuring process, changes on one of the devices (for example adding new types of fields) are not transferred to the other devices. You need to repeat the procedure for linking libraries for all the other devices.


'''Note''': Syncing a library between devices is recommended use the [[Cloud storage and Teamwork|Memento Cloud]].
[[Category:Overview]]
 
== Notes ==
* In the Google table will be created additional column '''MEMENTO_ID''' for matching rows in a table with the entries in Memento. Don't modify or delete this column.
* Locale on your device should match the locale in Google Sheets.
* If you edit the same entries in Memento and Google Sheets, you will be offered to choose which version is correct.
* Whenever you add a new field for synchronization, the sheet in Google Docs is created anew.
* All entries in the Google Spreadsheet sheet should follow one after another. There should be no empty rows.
* Memento allows you to synchronize only fields of certain types: text, integer, real number, date, date/time, rating, currency, single-choice list, multiple-choice list, location, boolean, hyperlink, barcode.
 
[[Category:Spec]]