Wise csv file - how to match fields

[Thomas Baumgart]

On Sonntag, 5. März 2023 10:22:43 CET mh--- via KMyMoney wrote:

> On Sonntag, 5. März 2023 07:58:35 CET Thomas Baumgart via KMyMoney wrote:
> > On Samstag, 4. März 2023 16:40:25 CET Jack via KMyMoney wrote:
> [...]
> > > 
> > > Use the Settings/Configure Language menu.  Changing the language does
> > > not affect the data at all, just the display.
> > 
> > That is not 100% true as I kind of remember that the main account groups may
> > be renamed as part of the process and those names are kept within the data
> > file. OTOH, when you switch the language back to German, those names get
> > changed again.
> > 
> > p.s. I just noticed, that since the translations are synced into the git
> > repo I can switch my development version to German. So I might be able to
> > provide some answers. Looking at the original list Mike provided it might
> > be useful to know what information is kept in them. E.g. what's the
> > difference between Description and Note?
> 
> As for the existing transactions "note" is always empty, "description" 
> contains various strings, for example "Einzahlung von ...", "Kartentransaktion 
> über ..." and also "useful" information like "Keine Information" ;)

"Keine Information" and "useful" in the same sentence without negation, does that work?  :D 

Looking at your original mail, I would use the following mapping:

Nummer --> unused, leave empty
Datum --> Date
Empfänger/Beschreibung --> "Payer Name" (maybe "Payee Name" whereever you see data)
Kategorie --> unused
Notiz --> Description (you can also add Payee name or other fields here as well as
           description allows multiple mappings)
Saldo --> "Running Balance"  (not sure if that is used internally but eventually it will)
Betrag --> Amount

The other available fields in your CSV cannot be used by KMyMoney.

Does that make sense?


-- 

Regards

Thomas Baumgart

-------------------------------------------------------------
LINUX is like a wigwam.. no windows, no gates and apache inside.
-------------------------------------------------------------
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 868 bytes
Desc: This is a digitally signed message part.
URL: <http://mail.kde.org/pipermail/kmymoney/attachments/20230305/59be5f22/attachment.sig>