Import from jGnash

Page 1 of 1
7 posts
Import from jGnash

mbmb
New MMEX User

Posts: 17
Joined: Mon Aug 04, 2014 1:02 pm
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

Nikolay
MMEX Developer

Posts: 2303
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Use only
"Number","Debit","Credit","Date","Memo","Payee"

Others should be skiped
"Account","Balance","Date","Reconciled"
Re: Import from jGnash

mbmb
New MMEX User

Posts: 17
Joined: Mon Aug 04, 2014 1:02 pm
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

Nikolay
MMEX Developer

Posts: 2303
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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

mbmb
New MMEX User

Posts: 17
Joined: Mon Aug 04, 2014 1:02 pm
excel doesn't load the file
Re: Import from jGnash

Nikolay
MMEX Developer

Posts: 2303
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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

mbmb
New MMEX User

Posts: 17
Joined: Mon Aug 04, 2014 1:02 pm
This is the official "shit" of jGnash.

The developers of jGnash are rather inapt I suppose...
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 2 guests