Can't Import/Export

[Hank Arnold]

I've run into a problem that is preventing me from being able
to import/export my current file. I'm using Q99 (Fix R2 was installed,
R3 is now installed). I had problems with my JOINT2 file a couple of
months ago. After entering several transactions, I exited and then
opened the file. Most accounts were gone and the register for my main
account was empty. I restored the backup and replicated the problem. I
had data going back 7-8 years for most accounts and back to 84 on some
investment accounts. I assumed that it was some kind of file size or #
of transactions limit I had hit.

I did an archive of the data and (I forgot exactly how)
eliminated transactions from all non-investment accounts more than 5
years back. I kept all the Investment account transactions intact. The
other accounts (my main checking account, for example) now show a
starting balance on 12/31/93. All the balances and portfolio info are
correct.

I discovered during an attempt to evaluate Money98 that I had
a file validity problem (most likely what caused my earlier problems).
I validated the account and it seems OK. However, I found that Money
98 can't import Q99 files (way to go Intuit!!). so I tried the
export/import route. After getting the validation process done, it
seemed to work, except that balances were *WAY* off!! I looked at it
and found that what was causing the problem was the transfers from my
checking accounts into my investment accounts that had occurred
earlier than 1/1/94. The investment accounts still show the transfers
happening ( I had chosen to preserve transactions prior to 1/1/94).
Q99 seems to accept the fact that the transaction is there and it
looks like a transfer happened. However, if you try and go to the
transfer, it gives a message about it probably being related to a File
Save/Archive process (which it was).

However, if I try and export the file (all accounts) and then
import into a new file, the transfers shown in the investment
accounts are created in the respective checking accounts. Needless to
say, this totally wacks the balances. Any ideas on what to do would be
appreciated.

I have a couple of other problems with export/import, but I'll
post them in another note.

Hank Arnold

[Andrew DeFaria]

Hank Arnold wrote:

I've run into a problem that is preventing me from being able to import/export my current file. I'm using Q99 (Fix R2 was installed, R3 is now installed). I had problems with my JOINT2 file a couple of months ago. After entering several transactions, I exited and then opened the file. Most accounts were gone and the register for my main account was empty. I restored the backup and replicated the problem. I had data going back 7-8 years for most accounts and back to 84 on some investment accounts. I assumed that it was some kind of file size or # of transactions limit I had hit.

Wrong assumption.

I did an archive of the data and (I forgot exactly how) eliminated transactions from all non-investment accounts more than 5 years back.

Could it be File: File Operations: Year End Archive: Start New Year?

I kept all the Investment account transactions intact. The other accounts (my main checking account, for example) now show a starting balance on 12/31/93. All the balances and portfolio info are correct.

I discovered during an attempt to evaluate Money98 that I had a file validity problem (most likely what caused my earlier problems). I validated the account and it seems OK. However, I found that Money 98 can't import Q99 files (way to go Intuit!!).

Wait a second. Money 98 came out before Q99. So why would you expect it to be able to know the file format of software not yet released?!? And why would that be Intuit's fault?!?

so I tried the export/import route.

Bad option.

After getting the validation process done,

You mean File: File Operations: Validate?

it seemed to work, except that balances were *WAY* off!!

Define "seemed to work". Seems to me that it found corruption and deleted the parts it couldn't link up, thus making your balances off.

I looked at it and found that what was causing the problem was the transfers from my
checking accounts into my investment accounts that had occurred earlier than 1/1/94. The investment accounts still show the transfers happening ( I had chosen to preserve transactions prior to 1/1/94).

You don't have a choice as far as preservation of investment transactions. Quicken does not remove investment transaction.

Q99 seems to accept the fact that the transaction is there and it looks like a transfer happened. However, if you try and go to the transfer, it gives a message about it probably being related to a File Save/Archive process (which it was).

It is perfectly acceptable to have a transfer transaction whose transfer to account no longer has that transaction due to the Start New Year process. That's what it was telling you. Effectively this is not the reason your balances are off.

However, if I try and export the file (all accounts) and then import into a new file, the  transfers shown in the investment accounts are created in the respective checking accounts. Needless to say, this totally wacks the balances. Any ideas on what to do would be appreciated.

("Doctor, doctor! My arm hurts when I do this!". Doctor: "Well then stop doing that!")

Stop exporting and importing such old transactions! Why are you doing this? Effectively, export/import was not meant for such things.

---

And...@DeFaria.com http://www.defaria.com
Unofficial Quicken Web Page: http://www.defaria.com/Quicken
Newsgroup: news:alt.comp.software.financial.quicken
If it's too much work for you to filter spam,
it's too much work for me to fix your email address!

[Hank Arnold]

Posted this 2 weeks ago. Anyone have any ideas??

On Wed, 03 Mar 1999 13:14:45 GMT, ras...@ibm.net (Hank Arnold) wrote:

> I've run into a problem that is preventing me from being able
>to import/export my current file. I'm using Q99 (Fix R2 was installed,
>R3 is now installed). I had problems with my JOINT2 file a couple of
>months ago. After entering several transactions, I exited and then
>opened the file. Most accounts were gone and the register for my main
>account was empty. I restored the backup and replicated the problem. I
>had data going back 7-8 years for most accounts and back to 84 on some
>investment accounts. I assumed that it was some kind of file size or #
>of transactions limit I had hit.
>

> I did an archive of the data and (I forgot exactly how)
>eliminated transactions from all non-investment accounts more than 5

>years back. I kept all the Investment account transactions intact. The

>other accounts (my main checking account, for example) now show a
>starting balance on 12/31/93. All the balances and portfolio info are
>correct.
>
> I discovered during an attempt to evaluate Money98 that I had
>a file validity problem (most likely what caused my earlier problems).
>I validated the account and it seems OK. However, I found that Money

>98 can't import Q99 files (way to go Intuit!!). so I tried the
>export/import route. After getting the validation process done, it
>seemed to work, except that balances were *WAY* off!! I looked at it

>and found that what was causing the problem was the transfers from my
>checking accounts into my investment accounts that had occurred
>earlier than 1/1/94. The investment accounts still show the transfers
>happening ( I had chosen to preserve transactions prior to 1/1/94).

>Q99 seems to accept the fact that the transaction is there and it
>looks like a transfer happened. However, if you try and go to the
>transfer, it gives a message about it probably being related to a File
>Save/Archive process (which it was).
>

> However, if I try and export the file (all accounts) and then
>import into a new file, the transfers shown in the investment
>accounts are created in the respective checking accounts. Needless to
>say, this totally wacks the balances. Any ideas on what to do would be
>appreciated.
>

> I have a couple of other problems with export/import, but I'll
>post them in another note.
>
>Hank Arnold

Hank Arnold

[Andrew DeFaria]

Hank Arnold wrote:

I discovered during an attempt to evaluate Money98 that I had a file validity problem (most likely what caused my earlier problems).I validated the account and it seems OK. However, I found that Money 98 can't import Q99 files (way to go Intuit!!).

Way to go Intuit?!? Money 98 came out before Quicken 99. How would Money 98 engineers know what format Quicken 99 databases would be in? Cut Intuit a little slack here? (Now if you would have said that Intuit's new encrypting of Quicken 99 databases is a blatant attempt to make it hard for Money to convert Quicken databases then you might have a point - however I happen to be of the opinion that a company has every right to protect their intellectual property).

so I tried the export/import route.

You're exporting from Quicken 99 and importing to Money 98?

After getting the validation process done, it seemed to work, except that balances were *WAY* off!! I looked at it and found that what was causing the problem was the transfers from my checking accounts into my investment accounts that had occurred earlier than 1/1/94. The investment accounts still show the transfers happening ( I had chosen to preserve transactions prior to 1/1/94). Q99 seems to accept the fact that the transaction is there and it looks like a transfer happened. However, if you try and go to the transfer, it gives a message about it probably being related to a File Save/Archive process (which it was).

So you exported from Quicken 99 and imported to Quicken 99?!?

I suspect that you had data corruption which validate fixed, however what it fixed caused your balances to be way off. And the cause of the way off balances is probably not the dangling transfer that can legally occurs as a result of Year End Copy: Start New Year rather it's somewhere else.

However, if I try and export the file (all accounts) and then import into a new file, the  transfers shown in the investment accounts are created in the respective checking accounts. Needless to say, this totally wacks the balances. Any ideas on what to do would be appreciated.

Exportation of all account and re-importation is not intended to give you an exact or even a real close copy of your database. See FAQ: Export/Import.

I have a couple of other problems with export/import, but I'll post them in another note.

I'm beginning to form an opinion that large Quicken databases are dangerous because if you have corruption and need to validate, there's a good chance that you'll have a database with a few problems in it as you have found, and that it will be more difficult to hunt down what's causing the problem simply because of the mass of data.