Exports data from wallet web app by budgetbakers

export-transactions-from-budgetbakers-wallet.js

// Wallet is a great app to track your expenses
// I just didn't want to buy premium subscription just to export my own data :shrug:

// First follow this gist to export all the data in indexeddb to console
// https://gist.github.com/harryi3t/d8779d3c0c0c4d41c37fdde81b268fd3

// I will be assuming from here on that the the entire data is in a variable `data`

// All the transactions are store in the table 'by-sequence'
let sequence = data[2]['by-sequence'];

// group all sequences by type of record. eg are 'account', 'category', 'record', 'currency', etc
// similar to _.groupBy(sequence, 'reservedModelType')
let groupedSequence = sequence.reduce((group, item) => {
 if (!group[item.reservedModelType]) 
    group[item.reservedModelType] = [];

 group[item.reservedModelType].push(item)
 return group;
}, {})

// Convert the category array into a map (key is category id and value is category item itself)
groupedSequence.categoryMap = groupedSequence.Category.reduce((group, item) => {
 let categoryId = item._doc_id_rev.split('::')[0];
 group[categoryId] = item;
 return group;
}, {})

// Sort the records by date
groupedSequence.Record = groupedSequence.Record.sort((a, b) => {
 return a.reservedCreatedAt.localeCompare(b.reservedCreatedAt)
})

function mapRecordWithCategory (item) {
 return {
  title: item.note,
  date: item.recordDate,
  category: groupedSequence.categoryMap[item.categoryId].name,
  amount: item.amount/100
 }
}

Thanks for this!

I extended your functions and added account names per transaction and a negative sign for debit amounts

Link here https://gist.github.com/eric-gm/9454490b22b3a5135fbccfe30e1ded08

That's awesome!

…

On Fri, 6 Sep, 2019, 8:34 PM Eric Githinji, ***@***.***> wrote: Thanks for this! I extended your functions and added account names per transaction and a negative sign for debit amounts Link here https://gist.github.com/eric-gm/9454490b22b3a5135fbccfe30e1ded08 — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <https://gist.github.com/8c439df8cee752f107824964a0d005fc?email_source=notifications&email_token=ABHXKI372UCYJGG6KPCAWYTQIJWRVA5CNFSM4IUKBAB2YY3PNVWWK3TUL52HS4DFVNDWS43UINXW23LFNZ2KUY3PNVWWK3TUL5UWJTQAFYH32#gistcomment-3018685>, or mute the thread <https://github.com/notifications/unsubscribe-auth/ABHXKI2F42L7N4NQYTHSU43QIJWRVANCNFSM4IUKBABQ> .