search

vmkernel / expense-iq

A set of scripts designed to decode and encode Expense IQ (ex. Easy Money) backup file. Primarily to fix backup restoration errors caused by special symbols stored in text strings (in transaction/account description).
GNU General Public License v3.0
0 stars 2 forks source link

how to decode bak to sql query format #1

Closed antoinekondoh closed 1 year ago

antoinekondoh commented 3 years ago

Hello, I would kindly like some help in the process to decode my expense iq .bak to sql querry so I can use your tool.

vmkernel commented 3 years ago

Hi, what kind of problem do you have with deciding?

antoinekondoh commented 3 years ago

I only know basic programming in python so my challenge was with powershell scripts and how to run them. However these are the steps I took to successfully get the bug fixed.

1.I edited the decrypt.py shared by raphaelm to create an sql copy of the database identifying the indexes of the lines with the 's issue.

  1. I opened this .bak file with Notepad++. I showed me all the lines representative of the tables from my backup but in Hexadicmal format.

  2. I run each of the functions in the expense-iq-backup.ps1 directly in the powershell prompt. thereafter I edited and run the lines of code in the fault-line-fix.ps1 to correct the lines with the 's identified from step 1.

  3. for each of these new Hex lines outputted from your fault-line-fix.ps1, I copied and pasted them in the original .bak file opened in Notepad++.

  4. Finally I put the in the expense-iq folder on my new phone and voila, the backup restored everything as expected.

I am very grateful for your skill and that of raphaelm in coding this solution.

NB: Please in your script there is a comment under the encode-expenseiqbackup function that says

TODO: Implementation

I would kindly like to know what that meant. Thank you.

With Regards, Antoine

On Sun, 7 Feb 2021, 6:42 am Aleksey Ivanov, notifications@github.com wrote:

Hi, what kind of problem do you have with deciding?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/vmkernel/expense-iq/issues/1#issuecomment-774615581, or unsubscribe https://github.com/notifications/unsubscribe-auth/AMIPAFLTB7FXOZHWGVAW7T3S5YY53ANCNFSM4XGHDWPA .

vmkernel commented 3 years ago

So, if I've understood correctly, you've managed to fix the issue(s) in your backup? In this case - congratulations! ))

I would kindly like to know what that meant.

TODO: Implementation

It's a comment for myself to actually write logic of this function, cause for now it does literally nothing. Originally I wanted it to automatically convert a whole sql file back to a file in obfuscated backup format of Expense IQ. It ment to be an "opposite" function of Decode-ExpenseIqBackup. But since I'd managed to fix my backup file in the same way you did, I decided to do it later. That was two and a half years ago :))

antoinekondoh commented 3 years ago

Well after you've solved the problem that got you coding in the first place, it's understandable that you've not gone back to it. Thanks again for the assistance

On Thu, 11 Feb 2021, 6:52 pm Aleksey Ivanov, notifications@github.com wrote:

So, if I've understood correctly, you've managed to fix the issue(s) in your backup? In this case - congratulations! ))

I would kindly like to know what that meant.

TODO: Implementation

It's a comment for myself to actually write logic of this function, cause for now it does literally nothing. Originally I wanted it to automatically convert a whole sql file back to a file in obfuscated backup format of Expense IQ. It ment to be an "opposite" function of Decode-ExpenseIqBackup. But since I'd managed to fix my backup file in the same way you did, I decided to do it later. That was two and a half years ago :))

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/vmkernel/expense-iq/issues/1#issuecomment-777711114, or unsubscribe https://github.com/notifications/unsubscribe-auth/AMIPAFNVJ6ANF2NVX523D6TS6QRNLANCNFSM4XGHDWPA .

vmkernel commented 1 year ago

(Finally) implemented in fix_and_update branch. Will be merged in the master soon.