Page 1 of 1
Import from jGnash
Posted: Sat Mar 04, 2017 10:33 pm
by mbmb
How can I import from jGnash?
I have a exported a csv-file with this headers:
"Account","Number","Debit","Credit","Balance","Date","Memo","Payee","Reconciled"
Re: Import from jGnash
Posted: Sun Mar 05, 2017 7:41 am
by Nikolay
Use only
"Number","Debit","Credit","Date","Memo","Payee"
Others should be skiped
"Account","Balance","Date","Reconciled"
Re: Import from jGnash
Posted: Sun Mar 05, 2017 12:57 pm
by mbmb
How can I import the categories?
How can I handle split transactions?
This is a sequence of an xml-file I could export from jgnash (probably a split transaction)
<Transaction reference="116"/>
<Transaction id="131" uuid="cb1a33a4-df26-4f10-851b-ee478f1163dc">
<date id="132">2007-12-22</date>
<timestamp>1170198000000</timestamp>
<number></number>
<payee>Billa</payee>
<memo></memo>
<transactionEntries id="133">
<TransactionEntry id="134">
<transactionTag>BANK</transactionTag>
<debitAccount reference="66"/>
<creditAccount reference="120"/>
<creditAmount>1.6000</creditAmount>
<debitAmount>-1.6000</debitAmount>
<creditReconciled>RECONCILED</creditReconciled>
<debitReconciled>RECONCILED</debitReconciled>
<memo></memo>
</TransactionEntry>
<TransactionEntry id="135">
<transactionTag>BANK</transactionTag>
<debitAccount reference="66"/>
<creditAccount reference="110"/>
<creditAmount>0.6700</creditAmount>
<debitAmount>-0.6700</debitAmount>
<creditReconciled>RECONCILED</creditReconciled>
<debitReconciled>RECONCILED</debitReconciled>
<memo></memo>
</TransactionEntry>
</transactionEntries>
When I try to import the total xml-file I get a parsing error: File is not in Excel XML Spreadsheet 2003 format.
please help me...
Re: Import from jGnash
Posted: Sun Mar 05, 2017 1:52 pm
by Nikolay
Could you try to open jcash XML by by MS Excel. In case if one transaction will be one line with the same columns the it may be saved as csv or xls.
Re: Import from jGnash
Posted: Sun Mar 05, 2017 4:43 pm
by mbmb
excel doesn't load the file
Re: Import from jGnash
Posted: Fri Mar 10, 2017 9:00 am
by Nikolay
The sample you have provided has invalid structure
Code: Select all
<transactionEntries id="133">
<TransactionEntry id="134">
<transactionTag>BANK</transactionTag>
<debitAccount reference="66"/>
<creditAccount reference="120"/>
<creditAmount>1.6000</creditAmount>
<debitAmount>-1.6000</debitAmount>
<creditReconciled>RECONCILED</creditReconciled>
<debitReconciled>RECONCILED</debitReconciled>
<memo></memo>
</TransactionEntry>
<TransactionEntry id="135">
<transactionTag>BANK</transactionTag>
<debitAccount reference="66"/>
<creditAccount reference="110"/>
<creditAmount>0.6700</creditAmount>
<debitAmount>-0.6700</debitAmount>
<creditReconciled>RECONCILED</creditReconciled>
<debitReconciled>RECONCILED</debitReconciled>
<memo></memo>
</TransactionEntry>
</transactionEntries>
This xml may be opend in MS Excel then saved as csv
Re: Import from jGnash
Posted: Sun Mar 12, 2017 9:35 am
by mbmb
This is the official "shit" of jGnash.
The developers of jGnash are rather inapt I suppose...