Import from jGnash

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
mbmb
New MMEX User
Posts: 12
Joined: Mon Aug 04, 2014 7:02 pm
Are you a spam bot?: No

Import from jGnash

Post 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"
Nikolay
MMEX Developer
Posts: 1400
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Import from jGnash

Post by Nikolay »

Use only
"Number","Debit","Credit","Date","Memo","Payee"

Others should be skiped
"Account","Balance","Date","Reconciled"
mbmb
New MMEX User
Posts: 12
Joined: Mon Aug 04, 2014 7:02 pm
Are you a spam bot?: No

Re: Import from jGnash

Post 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...
Nikolay
MMEX Developer
Posts: 1400
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Import from jGnash

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

Re: Import from jGnash

Post by mbmb »

excel doesn't load the file
Nikolay
MMEX Developer
Posts: 1400
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Import from jGnash

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

Re: Import from jGnash

Post by mbmb »

This is the official "shit" of jGnash.

The developers of jGnash are rather inapt I suppose...
Post Reply