Library: Difference between revisions

From Memento Database Wiki
Jump to navigation Jump to search
mNo edit summary
mNo edit summary
(14 intermediate revisions by the same user not shown)
Line 1: Line 1:
<div align="right"><small>''&laquo; as of 2016-08-29, editions Mobile 3.9.7, Desktop 1.0.3 &raquo;''</small></div>
{{Stamp|2016-12-03|4.1.0|1.0.7}}
-----
In Memento, the fundamental data structure is the library. A library contains data '''''[[Entry|entries]]''''', each of which is made up of typed '''''[[Field|fields]]''''' each of which contains a value.
In Memento, the fundamental data structure is the library. A library contains data '''''[[Entry|entries]]''''', each of which is made up of typed '''''[[Field|fields]]''''' each of which contains a value.


The set of a library's fields may be subdivided into ''pages''. By default, fields fall into the page named "MAIN".
Memento is relational; a library is equivalent to a '''table''', and an entry is equivalent to a  '''row'''. Libraries can be linked together in similar fashion to relational tables.
 
The set of a library's fields may be subdivided into '''''pages'''''. By default, fields fall into the page named "MAIN". Fields may be again subdivided by '''''subheaders''''', which allow visual separation within a page.


When a value is stored for some field types, an external file is created or referenced, so the user's database consists of his or her libraries and its associated files.
When a value is stored for some field types, an external file is created or referenced, so the user's database consists of his or her libraries and its associated files.


In addition to fields, a library can contain '''''[[#AGGREGATION|aggregation functions]]''''' to be displayed in entry lists.
In addition to fields, a library can contain '''''[[Library Edit screen#AGGREGATION tab|aggregation functions]]''''' to be displayed in entry lists.


A library can also be set up to '''''[[#AUTOFILL| autofill]]''''' certain fields from Internet-based sources.
A library can also be set up to '''''[[Library Edit screen#AUTOFILL tab| autofill]]''''' certain fields from Internet-based sources.


Libraries may be encrypted to protect the privacy of their contents.
[[Library Protection|'''Libraries may be password-protected and encrypted''']] to protect the privacy of their contents.


The set of a user's libraries may be subdivided into [[Library Groups|'''''groups''''']]. By default, libraries fall into the group named My Libraries.
The set of a user's libraries may be subdivided into [[Library Groups|'''''groups''''']]. By default, libraries fall into the group named My Libraries.
Line 17: Line 18:
In the Mobile Edition, libraries are stored locally and may or may not be synchronized with [[Cloud storage and Teamwork|'''''the Memento Cloud''''']] along with their associated files. The Desktop Edition, however, works on libraries and files stored in the Memento Cloud.
In the Mobile Edition, libraries are stored locally and may or may not be synchronized with [[Cloud storage and Teamwork|'''''the Memento Cloud''''']] along with their associated files. The Desktop Edition, however, works on libraries and files stored in the Memento Cloud.


Libraries may be [[Importing and exporting CSV files|'''imported from and exported to comma-delimited (CSV) files''']], which are often exported from or used to then import into other database products or spreadsheet file formats.
Libraries may be [[Importing and exporting data|'''imported from and exported to comma-delimited (CSV) files''']], which are often exported from or used to then import into other database products or spreadsheet file formats.
 
If the user is logged into a Google account, his or her libraries may be [[Sync with Google Sheets|'''synchronized with Google Sheets files''']] stored on the user's Google Drive. To do this, the library must already exist, so if the user wants to create a new library from a Google Sheet, the user must first create the library and its fields to match those of the Google Sheet and then set up the new library to synchronize with the Google Sheets file.
 
== Adding a Library ==
 
To add a new library:
; Press the Add Library button
: Open the menu in the Library List screen and select ''Add library''.There is no floating Add (<big>'''+'''</big>) button on this screen in the current version.
; Determine starting point
: If you want to use or start work from a template, you may select one. You can use a template already structured with fields, or you can select the ''Empty library'' template and create all library fields yourself. Also you can select a template from the online catalog. You can edit and customize the ready templates as well as the Empty library template.
; Structure your new library
: After you select the template, you will see the Library Edit screen, where you can begin to structure your library with fields, pages, aggregations, autofill rules, etc. The new library already contains the set of fields from the selected template.
 
=== Online catalog of library templates ===
You can create libraries using templates that other users have uploaded to the online catalog. For that purpose, when creating a library, on the template list select ''From online catalog''.<br />
If you would like to share your template with friends, you can publish it in the online catalog. For that purpose, open the library editor screen and then click on the ''Share'' menu item.
 
== Library Edit Screen ==
 
The Library Edit screen comprises four tabs: MAIN, FIELDS, AGGREGATION, and AUTOFILL.
 
=== MAIN ===
 
The MAIN tab allows the user to set the following settings.
 
; Color of library
: One of 20 colors may be chosen from a palette to be used as the color of the library's tile on the Library List screen.
 
; Put on the tile
: Any or all of 4 pieces of information may be selected to be placed on the library's tile on the Library List screen: library icon, number of entries, editing time, and Add Entry button.
 
; Entry Name
: Names of defined fields, if any, are displayed, and any or all of them may be selected to comprise the Entry Name, when those fields' values are concatenated using a space separator.
 
; Entry Name is unique
: Set to Off by default, this may be set to On to specify that the Entry Name is to be unique.
 
; Entry thumbnail
: Names of defined Image fields, if any, are displayed, and any one (or none) of them may be selected to function as the entry's thumbnail image on the Entry List screen.
 
; Entry color
: Names of defined single-value selection (Single-choice List or Radio Button) fields, if any, are displayed, and any one (or none) of them may be selected to determine the color of the entry on the Entry List screen.
 
=== FIELDS ===
 
The FIELDS library tab shows the library's pages as field tabs (displayed vertically), including the MAIN page and any other pages the user has previously defined, if any. The fields of the current page are displayed in order. Each field is shown in the following format:
 
{| class="wikitable"
|-
| Grab handle || Genre icon || Name<br/>Type || Role || Menu button
|}
 
From left to right in the field display, we have the following.
 
; Grab handle
: The leftmost component of the field display is a grab handle. Using that, the field may be grabbed by touch or by mouse and dragged up or down to the desired position in field order.
 
; Genre icon
: This is an icon depicting the genre of the field type. FOR INSTANCE, all text field share the same icon.
 
; Field name
: This is the name of the field.
 
; Type name
: Before the field name is the name of the field type.
 
; Role
: This is the role of the field: Name, Description, Status, or Thumbnail. If this component is black, the field plays no role or is a Regular Field.
 
; Field Menu
: The rightmost component is a 3-dot menu button to bring up the Field Menu.
 
Also provided is an Add (<big>'''+'''</big>) button for adding a new relationship, page, or field to the current page of the library.
 
; Add Relationship
: This action creates a relationship, implemented as a many-to-many Link To Entry field on the current page, to a library. A list of libraries is displayed, among which, the user is to select one to which to link. The Link To Entry field takes the name of the linked library.
 
; Add Page
: This action creates a new field page. The user is prompted for the page name. Initially, the MAIN page is the only page and this the default page. Subsequently, a user added page may be set as the default page.
 
; Add Field
: This action creates a new field on the current page. A list of field types is presented, and the user may select the type of field to be added. The Field Add card for that type is presented, after which the field will be added to the bottom of the set of goals on the page.
----
==== Field Menu ====
Pressing the Field Menu button items the menu, which contains the following options.
 
; Move to page
: A list of pages (other than the current page) is displayed, and the user can select the page to which the field should be moved.
 
: One row with prev
: This setting causes the field to be displayed on both the Field View Card and the Field Edit Card on the right portion of the screen, generally on the same line with the previous field to its left.
 
; Add a field above
: This option is equivalent to the Add button described above except that the field will be positioned just above the current field.
 
; Add a field below
: This option is equivalent to the Add button described above except that the field will be positioned just below the current field.
 
; Change
: Open the Field Edit Card for this field.
 
; Delete
: After prompting to assure the user's intent, the field will be deleted.
 
=== AGGREGATION ===
 
The AGGREGATION tab displays a list of aggregation functions that have been defined for this library. It allows the user to add an aggregation function to the library for display in Library Lists and Field Views.
 
==== The Add Aggregation card on the Library Edit screen ====
 
While on the Library Edit screen in the AGGREGATION tab, pressing the Add (<big>'''+'''</big>) button at the bottom of the screen opens the Add Aggregation card.
 
; Function : The user selects the desired function from the displayed choices: Sum, Max, Min, and Average. The default is Sum.
 
; Operand : The user selects the desired field from the displayed list of fields eligible for aggregation functions. The default is the first (or only) eligible field.
 
; Prefix : The user may provide a text string to prefix the display of the result. By default, the string is empty.
 
; Position : The user selects whether to position the result on the left or right of the result box. By default, it is placed on the left.
 
; New line? : By default, the result will be displayed at the beginning of a new line. The user may change that behavior.
 
; Result type : The user may select the result type from the displayed choices: Real, Integer, Date, DateTime, or String. By default, the result is Real.
 
; Result Scale : If the selected result type is Real, the user may select the scale of the result, between 0 and 10. By default, the scale is 4.
 
=== AUTOFILL ===
 
The AUTOFILL tab displays a list of autofill rules that have been defined for this library. It allows the user to add an autofill rule.
 
==== The Add Autofill Rule card on the Library Edit screen ====


When the Add Autofill Rule (<big>'''+'''</big>) button is pressed, the user is prompted as to whether the rule is to be By Barcode or By Title.
If the user is logged into a Google account, his or her libraries may be [[Synchronizing data|'''synchronized with Google Sheets files''']] stored on the user's Google Drive. To do this, the library must already exist, so if the user wants to create a new library from a Google Sheet, the user must first create the library and its fields to match those of the Google Sheet and then set up the new library to synchronize with the Google Sheets file.


; By Barcode : The user may select the desired Data Source from the list of choices: MusicBrainz (for albums), Google Books (for books), or Amazon. The user may then select the Barcode field to use from a list.
== See Also ==
'''[[Libraries List screen]]'''<br/>
'''[[Library Edit screen]]'''


; By Title : The user may select the desired Data Source from the list of choices: MusicBrainz (for albums), MusicBrainz (for music artists), Google Books (for books), The Movie DB (for movies), or The Movie DB (for TV). The user may then select the Text field to use from a list.
[[Category: Overview]]

Revision as of 18:55, 13 January 2017

« Page as of 2016-12-03, editions Mobile 4.1.0, Desktop 1.0.7 »

In Memento, the fundamental data structure is the library. A library contains data entries, each of which is made up of typed fields each of which contains a value.

Memento is relational; a library is equivalent to a table, and an entry is equivalent to a row. Libraries can be linked together in similar fashion to relational tables.

The set of a library's fields may be subdivided into pages. By default, fields fall into the page named "MAIN". Fields may be again subdivided by subheaders, which allow visual separation within a page.

When a value is stored for some field types, an external file is created or referenced, so the user's database consists of his or her libraries and its associated files.

In addition to fields, a library can contain aggregation functions to be displayed in entry lists.

A library can also be set up to autofill certain fields from Internet-based sources.

Libraries may be password-protected and encrypted to protect the privacy of their contents.

The set of a user's libraries may be subdivided into groups. By default, libraries fall into the group named My Libraries.

In the Mobile Edition, libraries are stored locally and may or may not be synchronized with the Memento Cloud along with their associated files. The Desktop Edition, however, works on libraries and files stored in the Memento Cloud.

Libraries may be imported from and exported to comma-delimited (CSV) files, which are often exported from or used to then import into other database products or spreadsheet file formats.

If the user is logged into a Google account, his or her libraries may be synchronized with Google Sheets files stored on the user's Google Drive. To do this, the library must already exist, so if the user wants to create a new library from a Google Sheet, the user must first create the library and its fields to match those of the Google Sheet and then set up the new library to synchronize with the Google Sheets file.

See Also

Libraries List screen
Library Edit screen