M2 database export into CSV
Accounts database:
(MaTi=XXX.PDB or XXX.PDB if launchable)
Payment modes database:
MaTi-Modes.PDB
mandatory only if field
[1]
selected
Transactions types database:
MaTi-Types.PDB
mandatory only if at least one of fields
[2]
selected
Currencies database:
MaTi-Currencies.PDB
mandatory only if field
[3]
selected
Available fields
Fields that will be in the final CSV files
Account name (can not be used for import)
Internal ID (used by transfers)
Date
Time
Amount
Checked or not
Flagged or not
Alarm or not
Mode (only index)
Mode (full name) [1]
Type (only index)
Type (full name) [2]
Description
Validity date or empty
Cheque number or empty
Repeat (type + frequency + end date) or empty
Transfer account or empty
ID of the linked transaction or empty
Statement number or empty
Currency (only index) + amount or empty
Currency (full name) + amount or empty [3]
Splits ((type index + amount + description) x n)
Splits ((full type name + amount + description) x n) [2]
Empty column
Add a file
Type.cvs
that contains types database
(need MaTi-Types.PDB)
Columns/fields separator:
; (semicolon)
, (comma)
TAB
End of line:
Windows (CRLF)
Mac (CR)
Un*x (LF)
Time format:
HH:MM am/pm
HH:MM
HH.MM am/pm
HH.MM
HH,MM
Date format:
M/D/Y
D/M/Y
D.M.Y
D-M-Y
Y/M/D
Y.M.D
Y-M-D
M-D-Y
Decimal separator:
, (comma)
. (dot)
Palm encoding:
Arabic
Arabic (ISO-8859-6)
Arabic (MacArabic)
Baltic
Baltic (ISO-8859-13)
Baltic (ISO-8859-4)
Baltic (Windows-1257)
Central European
Central European (ISO-8859-2)
Central European (Windows-1250)
Croatian (MacCroatian)
Chinese
Chinese Simplified (GB2312)
Chinese Simplified (GBK)
Chinese Simplified (HZ)
Chinese Traditional (Big5)
Chinese Traditional (Big5-HKSCS)
Cyrillic
Cyrillic (ISO-8859-5)
Cyrillic (ISO-IR-111)
Cyrillic (KOI8-R)
Cyrillic (MacCyrillic)
Cyrillic (Windows-1251)
Cyrillic/Ukrainian (KOI8-U)
Greek
Greek (ISO-8859-7)
Greek (Windows-1253)
Greek (MacGreek)
Hebrew
Hebrew (Windows-1255)
Hebrew (MacHebrew)
Visual Hebrew (ISO-8859-8)
Japanese
Japanese (ISO-2022-JP)
Japanese (Shift_JIS)
Japanese (EUC-JP)
Korean
Korean (EUC-KR)
Korean (UHC)
Korean (ISO-2022-KR)
Turkish
Turkish (ISO-8859-9)
Turkish (Windows-1254)
Turkish (MacTurkish)
Unicode
Unicode (UTF-8)
Vietnamese
Vietnamese (Windows-1258)
Vietnamese (VISCII)
Western
English (US-ASCII)
Western (ISO-8859-1)
Western (ISO-8859-15)
Western (Macintosh)
Western (Windows-1252)
Other
Celtic (ISO-8859-14)
Nordic (ISO-8859-10)
Romanian (ISO-8859-16)
Romanian (MacRomania)
South European (ISO-8859-3)
Thai (TIS-620)
Thai (ISO-8859-11)
Thai (Windows-874)
Host encoding:
Arabic
Arabic (ISO-8859-6)
Arabic (MacArabic)
Baltic
Baltic (ISO-8859-13)
Baltic (ISO-8859-4)
Baltic (Windows-1257)
Central European
Central European (ISO-8859-2)
Central European (Windows-1250)
Croatian (MacCroatian)
Chinese
Chinese Simplified (GB2312)
Chinese Simplified (GBK)
Chinese Simplified (HZ)
Chinese Traditional (Big5)
Chinese Traditional (Big5-HKSCS)
Cyrillic
Cyrillic (ISO-8859-5)
Cyrillic (ISO-IR-111)
Cyrillic (KOI8-R)
Cyrillic (MacCyrillic)
Cyrillic (Windows-1251)
Cyrillic/Ukrainian (KOI8-U)
Greek
Greek (ISO-8859-7)
Greek (Windows-1253)
Greek (MacGreek)
Hebrew
Hebrew (Windows-1255)
Hebrew (MacHebrew)
Visual Hebrew (ISO-8859-8)
Japanese
Japanese (ISO-2022-JP)
Japanese (Shift_JIS)
Japanese (EUC-JP)
Korean
Korean (EUC-KR)
Korean (UHC)
Korean (ISO-2022-KR)
Turkish
Turkish (ISO-8859-9)
Turkish (Windows-1254)
Turkish (MacTurkish)
Unicode
Unicode (UTF-8)
Vietnamese
Vietnamese (Windows-1258)
Vietnamese (VISCII)
Western
English (US-ASCII)
Western (ISO-8859-1)
Western (ISO-8859-15)
Western (Macintosh)
Western (Windows-1252)
Other
Celtic (ISO-8859-14)
Nordic (ISO-8859-10)
Romanian (ISO-8859-16)
Romanian (MacRomania)
South European (ISO-8859-3)
Thai (TIS-620)
Thai (ISO-8859-11)
Thai (Windows-874)
If you need an encoding that is not present in the lists,
contact me at info@Ma-Tirelire.net
so I can add it.