VivaLV-Software

Datamanager/english: Difference between revisions

Page Discussion

Datamanager/english (view source)

Revision as of 19:13, 5 June 2012

5,134 bytes added ,  5 June 2012
→‎The simple but slow way
 
(38 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=Data Manager 1.0.0=
=Data Manager 1.7.0=


[[Image:datamanager_en_101.png]]
[[Image:datamanager_en_101.png]]
Line 13: Line 13:
All the features you need for managing all your data efficiently:
All the features you need for managing all your data efficiently:


* 14 sophisticated field types (Text, Number, Checkbox, Combobox, Date, Time, Link, Image, Location, Rating, ...)
* 16 sophisticated field types (Text, Number, Checkbox, Combobox, Date, Time, Link, Image, Location, Rating, ...)
* unlimited number of databases
* unlimited number of databases
* multiple tables per database
* multiple tables per database
Line 22: Line 22:
* configurable display of fields (visibility, font, color, order)
* configurable display of fields (visibility, font, color, order)
* flexible sorting and grouping
* flexible sorting and grouping
* total and group totals
* send data to Email, SMS, clipboard, Google
* send data to Email, SMS, clipboard, Google
* sharing of database definitions with others
* sharing of database definitions with others
* fast
* fast
* designed for large amount of data
* designed for large amount of data (tested with 5000 entries)
* standard webOS Look & Feel
* standard webOS Look & Feel
* multiple cards support
* multiple cards support
* integrated help
* integrated help
* support for TouchPad
* simple report by email
* background color, picture and theme globally and per database configurable
* create launcher icon for database


==Quick start==
==Quick start==
Line 34: Line 39:


Tap on '''+''' on the Main View ("Databases") to create a new database. Select '''From examples''' to use one of the example databases. Check the example(s) that you want and tap on '''Execute''' to create a new database. Tap on the '''tools''' symbol on the Main View to alter the database definition. Tap on the database on the Main View to go to that database. Tap on '''+''' on the Database View to enter new data. Tap on a data row to alter the data.
Tap on '''+''' on the Main View ("Databases") to create a new database. Select '''From examples''' to use one of the example databases. Check the example(s) that you want and tap on '''Execute''' to create a new database. Tap on the '''tools''' symbol on the Main View to alter the database definition. Tap on the database on the Main View to go to that database. Tap on '''+''' on the Database View to enter new data. Tap on a data row to alter the data.
==Running on the TouchPad==
Data Manager runs fullscreen on the TouchPad. Differences to the phone version:
* some screens have an additional left arrow on the bottom to go back
* screens where you can search by just typing have a magnifier at the bottom to show the virtual keyboard
* if you have a large list, Data Manager will present a button to load more data, where the phone version automatically loads more data
Other than that, Data Manager works on the TouchPad the same way as on the phones.


==Definition and data==
==Definition and data==
Line 49: Line 62:
If you tap on '''From examples''', you get to the Examples View. You can check as many of the examples as you want (even all) and then tap on '''Execute''' to create new databases based on the examples. In case a database with the default name already exists, you are asked to change the name. After that, you have one or more new immediately usable databases. Of course you can alter the definition of the example databases as you like.
If you tap on '''From examples''', you get to the Examples View. You can check as many of the examples as you want (even all) and then tap on '''Execute''' to create new databases based on the examples. In case a database with the default name already exists, you are asked to change the name. After that, you have one or more new immediately usable databases. Of course you can alter the definition of the example databases as you like.


'''Note:''' Some of the example databases are designed to save sensible data. Please be aware, that those databases are not protected by password or encrypted by default, because '''you''' have to choose the passwords. Those databases have a note telling you to do just that. Please see defining a database below for detailed description of this.
'''Note:''' Some of the example databases are designed to save sensitive data. Please be aware, that those databases are not protected by password or encrypted by default, because '''you''' have to choose the passwords. Those databases have a note telling you to do just that. Please see defining a database below for detailed description of this.


===Import definition===
===Import definition===
Line 66: Line 79:


===Editing a database===
===Editing a database===
[[Image:datamanager_editdatabase_en_101.png]] [[Image:datamanager_icons_en_101.png]] [[Image:datamanager_colors_en_101.png]]
[[Image:datamanager_editdatabase_en_140.png]] [[Image:datamanager_icons_en_101.png]] [[Image:datamanager_colors_en_101.png]]


Each database has the following properties:
Each database has the following properties:
Line 73: Line 86:
* Database (color): The color of the name of the database on the Main View.
* Database (color): The color of the name of the database on the Main View.
* Note (color): The color of the note of the database on the Main View.
* Note (color): The color of the note of the database on the Main View.
* Allow duplicates: Check this, if you want to possibly have duplicate data.
* Allow new duplicates: Enable this, if you want to be able to create/import duplicate entries.
* Note: Some notes for this database. You can see the note on the Main View.
* Note: Some notes for this database. You can see the note on the Main View.


Line 124: Line 137:


===Editing a field===
===Editing a field===
[[Image:datamanager_editfield_en_101.png]]
[[Image:datamanager_editfield_en_151.png]] [[Image:datamanager_editfield2_en_151.png]]


You get to the Edit Field View by tapping on an existing field in the field list or by adding a new field on the Edit Table View.
You get to the Edit Field View by tapping on an existing field in the field list or by adding a new field on the Edit Table View.
Line 132: Line 145:
* Type: The type of the field.
* Type: The type of the field.
* Color: The color of the field in the list of data.
* Color: The color of the field in the list of data.
* Default: The default value for this field when entering new data.
* Visible in list: Check on to see this field in the list of data.
* Visible in list: Check on to see this field in the list of data.
* Show label in list: Show the name of the field as label in the list of data.
* Show label in list: Show the name of the field as label in the list of data.
Line 152: Line 166:


=====Date=====
=====Date=====
A simple date (no time). You can tap a button when entering data to get the current date.
A simple date (no time). You can tap a button when entering data to get the current date. Configure current date as default under "Special Field Properties".


=====Date+Time=====
=====Date+Time=====
Date and time together. You can tap a button when entering data to get the current data and time. You can configure the minute interval.
Date and time together. You can tap a button when entering data to get the current data and time. You can configure the minute interval. Configure current date/time as default under "Special Field Properties".


=====Image=====
=====Image=====
Line 176: Line 190:


=====Text=====
=====Text=====
A normal field to enter text. You can configure to make this multiline.
A normal field to enter text. You can configure to make this multiline. You can optionally disable auto correct.


=====Time=====
=====Time=====
A simple time (no date). You can tap a button when entering data to get the current time. You can configure the minute interval. You can optionally suppress the value 00:00 in the list of data.
A simple time (no date). You can tap a button when entering data to get the current time. You can configure the minute interval. You can optionally suppress the value 00:00 in the list of data. Configure current time as default under "Special Field Properties".


=====URL (Link)=====
=====URL (Link)=====
An address of a WWW page. You can tap on a button when entering data to open it in the browser. You can configure to see it as symbol or hyperlink in the list of data.
An address of a WWW page. You can tap on a button when entering data to open it in the browser. You can configure to see it as symbol or hyperlink in the list of data.
=====Email=====
An Email address. You can tap on a button when entering data to create a new Email. You can configure to see it as symbol or hyperlink in the list of data.
=====Phone=====
An phone number. You can tap on a button when entering data to open the phone app. You can configure to see it as symbol or hyperlink in the list of data.


=====Reference=====
=====Reference=====
Line 188: Line 208:


==Working with data==
==Working with data==
[[Image:datamanager_database_en_101.png]]
[[Image:datamanager_database_en_170.png]]


If you tap on a database on the Main View, you get to the Database View.
If you tap on a database on the Main View, you get to the Database View.
Line 195: Line 215:


Buttons:
Buttons:
* the '''+''' button adds a new data item
* the big '''+''' button adds a new data item
* the button with a paper and arrow right opens the database in a new card
* the button with a '''paper and arrow right''' opens the database in a new card
* the button with paper and pencil allows mass delete or change
* the button with '''paper and pencil''' allows mass delete or change
* the button with '''paper and +''' open the totals menu
* the button with '''A/Z''' defines the sorting and grouping
* the button with '''A/Z''' defines the sorting and grouping


Line 211: Line 232:
Tap on '''+''' to enter a new data item. This will take you to the Edit Data View. See below for a description.
Tap on '''+''' to enter a new data item. This will take you to the Edit Data View. See below for a description.


===Editing data===
===Editing and duplicating data===
[[Image:datamanager_editdata_en_101.png]]
[[Image:datamanager_editdata_en_170.png]]


Tap on an existing item or add a new item to get to the Edit Data View.
Tap on an existing item or add a new item to get to the Edit Data View.
Line 228: Line 249:
* Reference: Swipe to the right to clear the current reference.
* Reference: Swipe to the right to clear the current reference.
* URL: Tap on the world button to open the URL in the browser.
* URL: Tap on the world button to open the URL in the browser.
* Email: Tap on the envelope button to start a new Email.
* Phone: Tap on the phone button to make a call.
If you want to duplicate the current entry, tap on '''Duplicate''' (the button with 2 sheets of paper). The app will make a copy of the current data entry, so if you go back to the Database View, you will see 2 identical entries. Each time you tap on the button, it will make another copy. If you want to modify the entry while copying it, then modify it, duplicate it and then tap on the '''Arrow''' to undo your changes of the current entry before you go back to the Database View.


For references, you can choose data from the other table by tapping on the pick button. This will take you to a new Database View, showing the data of the referenced table. You can also enter new data there. Tap on the arrow button to the right of the data entry, that you want to reference in the original data. This will take you back to the Edit Data View and show the referenced data in the corresponding field(s).
For references, you can choose data from the other table by tapping on the pick button. This will take you to a new Database View, showing the data of the referenced table. You can also enter new data there. Tap on the arrow button to the right of the data entry, that you want to reference in the original data. This will take you back to the Edit Data View and show the referenced data in the corresponding field(s).
Line 241: Line 266:


Use back-swipe or tap on the '''Checkmark''' to save your changes. Tap on the '''Arrow''' to undo your changes.
Use back-swipe or tap on the '''Checkmark''' to save your changes. Tap on the '''Arrow''' to undo your changes.
===Total and group totals===
[[Image:datamanager_totals_en_170.png]]
Tap on the '''paper and +''' button to open the totals menu. You will get a list of numeric or time fields and the '''Hide''' option. Choose one of the fields to enable totals. Choose '''Hide''' to disable totals. If you have grouping active, you will also get group totals.
Swipe over the total to push it to the left or right of the screen.


===Sending an item===
===Sending an item===
[[Image:datamanager_senddata_en_101.png]]
[[Image:datamanager_senddata_en_170.png]]


While editing data, you can also send the current item to an external app:
While editing data, you can also send the current item to an external app:
Line 332: Line 364:


===Import from Shopping Manager===
===Import from Shopping Manager===
Many people have used our Shopping Manager app as general purpose database. Those can migrate their data to Data Manager and use the advanced features and flexibility. There is one disadvantage here: You cannot import alternative shops or virtual categories.
Many users have used our Shopping Manager app as general purpose database. Those can migrate their data to Data Manager and use the advanced features and flexibility. There is one disadvantage here: You cannot import alternative shops or virtual categories.


Usage:
Usage:
Line 361: Line 393:


Data Manager will create a new database with " - 2" appended.
Data Manager will create a new database with " - 2" appended.
==Generating a simple report==
[[Image:datamanager_report_en_111.png]] [[Image:datamanager_report2_en_111.png]]
If you are in a database, you can choose '''Generate Report''' from the App Menu. Then you choose which fields should appear in the report and tap on '''Execute'''.
Data Manager will create an email with a simple report, containing the currently filtered data of the currently selected table/database with the chosen fields.
==Creating a shortcut for a database on the launcher==
[[Image:datamanager_addtolauncher_en_111.png]]
You can create a shortcut on the system launcher for launching Data Manager to a specific database. This way, you can get more quickly to a database which you use often.
To do that, tap on the '''tools''' icon in the list of databases and choose '''Add to Launcher'''.
Then choose the image, either the standard Data Manager image or one of your photos. After this, you have the new shortcut on your launcher.
To delete the shortcut, you do the same as if you want to delete an app. On the phones, press and hold the option key and then tap on the shortcut. On the TouchPad, tap and hold on the shortcut and then tap on the '''X'''.
Please do not delete Data Manager itself, while you still have shortcuts from Data Manager in your launcher. Otherwise you can't delete those shortcuts anymore.


==Global preferences==
==Global preferences==
[[Image:datamanager_globalprefs1_en_101.png]] [[Image:datamanager_globalprefs2_en_101.png]]
[[Image:datamanager_globalprefs1_en_101.png]] [[Image:datamanager_globalprefs3_en_111.png]] [[Image:datamanager_globalprefs2_en_120.png]]


You get to the global preferences by choosing '''Preferences''' from the App Menu on the Databases View.
You get to the global preferences by choosing '''Preferences''' from the App Menu on the Databases View.
Line 372: Line 424:
* Font size of database name
* Font size of database name
* Font size of notes
* Font size of notes
* Appearance
* Shop help text at bottom: Switch off to hide the help text for beginners.
* Shop help text at bottom: Switch off to hide the help text for beginners.
* Rotate screen: If on, allows the screen to rotate, when you rotate your device.
* Rotate screen: If on, allows the screen to rotate, when you rotate your device.
Line 377: Line 430:
* Ask passwords again after: If not 0, specifies the number of minutes after which a still running Data Manager asks again for a password when entering/editing/deleting a database.
* Ask passwords again after: If not 0, specifies the number of minutes after which a still running Data Manager asks again for a password when entering/editing/deleting a database.
* Google timeout: Timeout in seconds after a request to Google (data transfer or address check) will fail.
* Google timeout: Timeout in seconds after a request to Google (data transfer or address check) will fail.
* High resolution (Pre3): Use the high resolution of the Pre3, requires restart.
===Appearance===
The standard appearance of Data Manager is the Dark theme, no background color and a background image with a gradient from gray to black. You can choose a different theme. You can also set a specific background color or a specific background image. For the image, you can configure the transparency.
Choosing a background color will clear the background image. Choosing a background image will clear the background color. If you tap on '''Default''', the standard settings will be activated again.
What you choose here is the default for all databases, if you do not configure individual appearance settings there.


==Database preferences==
==Database preferences==
[[Image:datamanager_dbprefs1_en_101.png]]
[[Image:datamanager_dbprefs1_en_111.png]] [[Image:datamanager_dbprefs2_en_111.png]]


You can get to the database preferences by choosing '''Database preferences''' in the App Menu of a Database View.
You can get to the database preferences by choosing '''Database preferences''' in the App Menu of a Database View.


You can configure:
You can configure:
* Font size of the first line of a data entry.
* Font size of the first line of a data entry
* Font size of the other lines of a data entry.
* Font size of the other lines of a data entry
* Keep pos after change: If on, scrolls the list of data to the last position after a re-sort that happened because of changing a sorted field.
* Keep pos after change: If on, scrolls the list of data to the last position after a re-sort that happened because of changing a sorted field
* Appearance
 
===Appearance===
If you do not enable '''Custom''', then this database will have the globally configured appearance. Otherwise, you can configure an individual appearance for this database. For the meaning of the appearance settings, please see the chapter about the global preferences.


==Backup and restore of your data==
==Backup and restore of your data==
Line 421: Line 486:


That said, exporting your data to Google Docs is the fastest way to quickly make a backup of your data.
That said, exporting your data to Google Docs is the fastest way to quickly make a backup of your data.
===Using the homebrew Save/Restore app===
Data Manager is supported by the homebrew Save/Restore app, which can be found in Preware. This is also an easy way to backup your data to the media (USB) partition.


==Migrating your data from the Beta/Demo variant to the Full variant==
==Migrating your data from the Beta/Demo variant to the Full variant==
Line 432: Line 500:


This way, you first copy the definition of the database and then the data via the clipboard from one variant of the app to the other.
This way, you first copy the definition of the database and then the data via the clipboard from one variant of the app to the other.
'''Note: You will lose your database preferences and sort settings.'''


===The advanced but fast way===
===The advanced but fast way===
Line 464: Line 530:


==Copyright==
==Copyright==
Copyright (C) 2011 VivaLV Software
Copyright (C) 2012 VivaLV Software
Thomas
1,504

edits

Retrieved from "http://software.vivalv.de/Special:MobileDiff/3015...3226"