Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| sailfishos:projects:sailfish_contacts_rescue [2021/08/05 20:01] – implementation details, todo admin | sailfishos:projects:sailfish_contacts_rescue [2021/10/15 10:32] (aktuell) – Hilfeausgabe und Versionsstand geändert admin | ||
|---|---|---|---|
| Zeile 9: | Zeile 9: | ||
| ====== Solution ====== | ====== Solution ====== | ||
| My Solution here is to restore the data with a python script, exporting it from the Sqlite database to .vcf (vCard File). | My Solution here is to restore the data with a python script, exporting it from the Sqlite database to .vcf (vCard File). | ||
| - | **This only works for DB Structures of SailfishOS and was especially tested with DBs of OS version 3.2.? and 3.3.?** | + | |
| + | **This only works for DB Structures of SailfishOS and was especially tested with DBs of OS version 3.2.X and 3.3.X** | ||
| + | |||
| + | <WRAP center round info 20%> | ||
| + | **Version 0.7 is the latest one.** | ||
| + | </ | ||
| ===== Implementation ===== | ===== Implementation ===== | ||
| Zeile 22: | Zeile 28: | ||
| |Organization name|{{: | |Organization name|{{: | ||
| |Organization parameters|{{: | |Organization parameters|{{: | ||
| - | |picture / foto|{{: | + | |picture / foto|{{: |
| - | |address|{{: | + | |address|{{: |
| + | |birthday|{{: | ||
| + | |URL|{{: | ||
| + | |Notes|{{: | ||
| + | ===== Requirements ===== | ||
| + | Install following Python Modules from PyPi | ||
| + | * vObject | ||
| + | * sqlite3 | ||
| + | * uuid | ||
| + | |||
| + | ===== execution Notes ===== | ||
| + | <code | Help>$ ./ | ||
| + | usage: ContactRestore.py [-h] --db DB --output OUTPUT [--outsinglefile OUTSINGLEFILE] [--avatars AVATARS] [--debug] | ||
| + | | ||
| + | |||
| + | Restore SailfishOS 3 Contacts | ||
| + | |||
| + | optional arguments: | ||
| + | -h, --help | ||
| + | --db DB, -d DB Sqlite3 Database file usually / | ||
| + | sqlite/ | ||
| + | --output OUTPUT, -o OUTPUT | ||
| + | Output directory for vcf files.' | ||
| + | --outsinglefile OUTSINGLEFILE, | ||
| + | If specefied, a file with that name is created under specified path, contianing all VCard | ||
| + | entrie. E.G. your address book | ||
| + | --avatars AVATARS, -a AVATARS | ||
| + | Avatar directory. If present otherwise we skip this block of avatars, means, no avatars at all | ||
| + | --debug | ||
| + | --version | ||
| + | |||
| + | This script was written to restore SailfishOS 3 contacts as VCF files. To see additional information, | ||
| + | https:// | ||
| + | |||
| + | <code | Execution> | ||
| + | $ ./ | ||
| + | exporting SiSo Emulator to file Testdata/ | ||
| + | exporting TestUserFirstName TestUserLastName to file Testdata/ | ||
| + | exporting 2nd Test *FN* User *LN* to file Testdata/ | ||
| + | exporting Phone Test to file Testdata/ | ||
| + | exporting Ludowig Adressuser to file Testdata/ | ||
| + | </ | ||
| ====== Database ====== | ====== Database ====== | ||
| ===== Schema ==== | ===== Schema ==== | ||
| Zeile 30: | Zeile 77: | ||
| ===== table descriptions ===== | ===== table descriptions ===== | ||
| + | |||
| + | ==== Addresses ==== | ||
| + | ==== subTypes ==== | ||
| + | The database is missing a table with subTypes to identify entries in Addresses. | ||
| + | To have a reference, here is a list of Types | ||
| + | |||
| + | ^subType^vCard/ | ||
| + | |Null|personal|Personal Address| | ||
| + | |0| |parcel| | ||
| + | |1|cell|Cell Phone| | ||
| + | |2|fax|Fax| | ||
| + | |3|pager|Pager| | ||
| + | |6|video|Video| | ||
| + | |10|?? | ||
| + | |||
| + | |||
| ==== PhoneNumbers ==== | ==== PhoneNumbers ==== | ||
| Zeile 46: | Zeile 109: | ||
| ==== subTypes ==== | ==== subTypes ==== | ||
| The database is missing a table with subTypes to identify entries in PhoneNumbers for example. | The database is missing a table with subTypes to identify entries in PhoneNumbers for example. | ||
| - | To have a databases, here is a list of Types | + | To have a reference, here is a list of Types |
| ^subType^vCard/ | ^subType^vCard/ | ||
| Zeile 81: | Zeile 144: | ||
| ====== external Links ====== | ====== external Links ====== | ||
| + | * great Fileformat description: | ||
| * FileFormatdescription: | * FileFormatdescription: | ||
| * Python vobject: http:// | * Python vobject: http:// | ||
| + | * vobject Code documentation: | ||
| * https:// | * https:// | ||
| ====== ToDo ====== | ====== ToDo ====== | ||
| - | - ORG-PARAM parameters associated with organisation like role, etc. pp. | ||
| - | - argparse implementation | ||
| - | - logger implementation | ||
| - | - DB Query, result and Object assignment to function | ||
| - fotos | - fotos | ||
| - | - addresses | + | - birthday |
| + | - missing parameters for names | ||
| + | - URL with parameters | ||
| ====== source ====== | ====== source ====== | ||
×
iphelper toolbox
you see this when javscript or css is not working correct
Untested