Find User
here you can look for a user
I had a request from an EZ Register user to be able to import data from a now defunct Android app called simply Checkbook, created by Digital Life Solutions, LLC. I looked into the Checkbook app, and saw that when you exported the account data as a spreadsheet, you were actually given a standard .csv file. EZ Register v1.14.0 and above now has the ability to import this .csv data directly into an account. Although this feature was designed specifically to import data from the Checkbook app, it can be used to import any data that is saved in .csv format, so long as the data is arranged in the same way.
The only real requirement is that your .csv columns (fields) be arranged in the following order: "category","description","value","date","check number","memo". The export on the old Checkbook app does this automatically, but you can also create data in a standard spreadsheet application like Excel or Libreoffice Calc and save it as a .csv file, and EZ Register will be able to import it, so long as the columns are arranged in the same order. Below is some sample .csv data:
Either way, once you have your *.csv file, importing it into EZ Register is fairly straight forward. Create a new account in your ledger for the data, and then once in the account, select Import .csv from the menu, and choose your data. Your account will be populated with your exported transactions.
That's all there is to it! If you have issues or questions with this feature, feel free to reply to this thread.
The only real requirement is that your .csv columns (fields) be arranged in the following order: "category","description","value","date","check number","memo". The export on the old Checkbook app does this automatically, but you can also create data in a standard spreadsheet application like Excel or Libreoffice Calc and save it as a .csv file, and EZ Register will be able to import it, so long as the columns are arranged in the same order. Below is some sample .csv data:
"category","description","value","date","check number","memo"In a spreadsheet application, the same data may look like this:
"Starting Balance","Starting Balance","20.23","Mon May 31 09:09:41 CDT 2021","","null"
"Allowance","a cool deposit","52.0","Mon May 31 09:39:41 CDT 2021","",""
"Food","mcdonalds","-16.25","Mon May 31 09:40:41 CDT 2021","13",""
| category | description | value | date | check number | memo |
|---|---|---|---|---|---|
| Starting Balance | Starting Balance | 20.23 | Mon May 31 09:09:41 CDT 2021 | ||
| Allowance | a cool deposit | 52.00 | Mon May 31 09:39:41 CDT 2021 | ||
| Food | mcdonalds | -16.25 | Mon May 31 09:40:41 CDT 2021 | 13 |
Either way, once you have your *.csv file, importing it into EZ Register is fairly straight forward. Create a new account in your ledger for the data, and then once in the account, select Import .csv from the menu, and choose your data. Your account will be populated with your exported transactions.
That's all there is to it! If you have issues or questions with this feature, feel free to reply to this thread.
Owner of Ape Apps, LLC
