Export is MISSING DATA

[rocketscienceMA]

I use the export function to export transactions into a few different spreadsheets and reports. I've done this for several years. However, I just learned yesterday that the export is incomplete.

I run a query on our accounts, filtering by date and project, and get a list of 20 or so transactions. Then, I choose Export > Transactions. I tried exporting in both XL and text format, and in both cases the export skipped a couple of transactions.

I then found that oddly I can copy the transactions to the clipboard and paste them into a spreadsheet accurately. So the issue is in the export itself.

The big issue is that I have gone back to last year's accounts and notice that there are ones missing from my reporting there. I'm going to have to go through all of those statements line by line and see whats missing. Because iCash doesn't display line numbers or a count of displayed transactions, it's very difficult to compare the export to the query, so it's a time consuming process.

I don't see anything that would cause these transactions to get skipped. Any ideas?

 

[stanbusk]

Is there something in common with those transactions? Sorry to ask but I have never heard of such issue.

 

[rocketscienceMA]

Nope. I could send you the export and the cut and paste so you could compare if you like.

 

[stanbusk]

What I need actually is the exact step by step procedure you follow so I can try to reproduce here. I can fix something only when I can reproduce it here.

 

[rocketscienceMA]

I run a query on our accounts, filtering by date and project, and get a list of 20 or so transactions.

Then, I choose Export > Transactions

I have tried both txt and XL format and both are missing the same transactions.

 

[stanbusk]

Funny because the code go thru the list you see on screen and export each transaction to the file. The list an array of data with numerated rows. Is it possible some of those transactions are actually groups of transactions?

 

[rocketscienceMA]

Some of them are grouped, yes. That will break the export? I don't have "show groups" clicked, so I only get the transactions.

 

[stanbusk]

The very best would be to open a [URL http://newticket.maxprog.com/]Support request[/URL] and add a file to it, a simple file we could use here to reproduce the problem. It has to be something simple but right now I have no clue. Would you mind to do that for us?