Add export/import to/from text files for purpose of identifying and removing corruption

import those files as new data into Quicken. (Attachments would need to
be exported/imported in their native formats.)
My production
data file is irreparably corrupted. I keep using it because creating a
fresh data file would be a huge amount of work. I work around the
corruptions when they occur because I know when and where they manifest
themselves.
If I could export all the data to a set of text
files, I could examine them in a text editor and possibly correct the
corruption. Then importing the corrected files back into Quicken as a
new data file would eliminate my corruption issues.
Comments
-
Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.
0 -
UKR said:
Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.Isn't that where the QXF file transfer format would come in
About the best you can say about the QXF format even if it worked perfectly is it is "better" than nothing. But the main problem with it is that it is a "closed format" and as such there isn't any way for the person to try to edit the dumped data. It is sort of like validate and repair. If it works great, if doesn't, you don't even know why it doesn't.0 -
BTW I voted on this but I think that snowball has a better chance.UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.0 -
Same here, I have been asking for any usable import/export that could handle rebuilding a file by account.UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.
Seems extremely unlikely.0 -
You can't get there with QIF? Or at least a good portion of the export/import?UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.Quicken user since Q1999. Currently using QW2017.
Questions? Check out the Quicken Windows FAQ list0 -
I just took a couple of minutes to look at things ...UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.
The QXF file format appears to be encrypted and/or binary data. That means, one can't edit it to fix anything. :-(
An unload file format that can be edited, similar to QIF, CSV or HTML would definitely be preferable.0 -
The big stumbling block for RJS is going to be his security options.UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.
The QIF format has Grant/exercise and such, but it has nothing to keep track of security lots. That is required for any option to be properly "connected".
In my case about the only options I had were long closed employee stock options. And in that case it really didn't matter. But it would royally mess up any open options.
Another thing that might come up rarely is if the person used splits in an investment transaction. I'm talking about like a split transaction you would have in a non investment account. It is possible to have them in Quicken, but the QIF format doesn't have them.0 -
You can’t get there with QIF or QXF or any of the above-mentioned formats. Remember, I want this for the purpose of correcting data corruption. XML could work, though.UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.
But conforming to a standard format is unnecessary, and XML can get complicated. I want any form of plain text which, when imported, recreates the entire QDF file, accounts, attachments., transfers, investment lots, and everything else.Quicken user since version 2 for DOS, now using QWin Premier Subscription (US) on Win10 Pro.0 -
I hear a lot of people WANT to win the lottery too...UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.
Frankly if I was the product manager I wouldn't authorize such a project.
Dumping everything out like that and importing it back in would be a complicated time consuming projects, that would have a heavy maintenance cost.
What's more they only people that could really benefit from it being in a text format so that it can be edited would VERY high skilled individuals. For the average person it would be an invitation to support calls as they hacked at in and got bad results.
So basically the feature would be very costly, and really only benefit a very small percentage of Quicken users.0 -
I would pay extra for it, and show them my MIT Computer Science diploma to get it.UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.
There’s a non-technical, business reason for Q not to take on this idea. I won’t mention it, use your imagination.Quicken user since version 2 for DOS, now using QWin Premier Subscription (US) on Win10 Pro.0 -
It wouldn't have to be a text-format unload / reload method to try and ferret out data file corruption. I would be very happy to have a stand-alone data file debug tool available to the programmers and Quicken Support Level 2 or 3 specialists so that they can intelligently see every single database record in a human-readable format. That would make it possible to identify and repair corruption and return a broken data file to service. It would also make it possible for them to determine if there's a bug in the Quicken code that needs fixing.UKR said:Isn't that where the QXF file transfer format would come in, if the bugs in it could be fixed once and for all?
A utility or function to unload and reload a Quicken data file, whether it contains damaged records or not, is sorely needed.0 -
Adobe Lightroom also uses the Sqlite3 database utility for its catalog function. Lightroom can"optimize" the catalog whenever you exit the program. This function also cleans up most catalog corruption.
Adobe support will accept a corrupted catalog that requires manual review to eliminate the corruption. Can Quicken support engineers do the same?Been using Quicken (and TurboTax) since DOS days in 1990s.0