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"
Import from jGnash
Moderator: Renato
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Import from jGnash
Use only
"Number","Debit","Credit","Date","Memo","Payee"
Others should be skiped
"Account","Balance","Date","Reconciled"
"Number","Debit","Credit","Date","Memo","Payee"
Others should be skiped
"Account","Balance","Date","Reconciled"
Re: Import from jGnash
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...
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...
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Import from jGnash
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
excel doesn't load the file
-
- Developer
- Posts: 1535
- Joined: Sat Dec 06, 2008 2:27 pm
- Are you a spam bot?: No
- Location: Sankt-Petersburg, Russia
Re: Import from jGnash
The sample you have provided has invalid structure
This xml may be opend in MS Excel then saved as csv
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>
Re: Import from jGnash
This is the official "shit" of jGnash.
The developers of jGnash are rather inapt I suppose...
The developers of jGnash are rather inapt I suppose...