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
-
- New User
- Posts: 12
- Joined: Mon Aug 04, 2014 7:02 pm
- Are you a spam bot?: No
-
- 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"
-
- New User
- Posts: 12
- Joined: Mon Aug 04, 2014 7:02 pm
- Are you a spam bot?: No
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.
-
- New User
- Posts: 12
- Joined: Mon Aug 04, 2014 7:02 pm
- Are you a spam bot?: No
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>
-
- New User
- Posts: 12
- Joined: Mon Aug 04, 2014 7:02 pm
- Are you a spam bot?: No
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...