MMEX Discussion Forum

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"

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

Others should be skiped
"Account","Balance","Date","Reconciled"

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...

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.

excel doesn't load the file

The sample you have provided has invalid structure This xml may be opend in MS Excel then saved as csv 

This is the official "shit" of jGnash.

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