Bluecoins Import Tool

Introduction

This is a little tool created for the import of transactions for the Bluecoins app.
As I am a lazy person, I would frequently gather a lot of receipts and do it in one go. Typing at phones proves to be a strain when there is a load.
Therefore, this tool is created. According to the prompts, you can input and select accounts' number as required, speeding up the input process. The inputted file will then be exported to a csv file that can be imported into the bluecoins app.

*Note: There is no support for advanced file type yet. You are welcome to fork this repo and add functionality.

Released by KwongTN under the MIT license. Contains code from https://github.com/nlohmann/json .

For the bluecoins import guide, refer to: http://www.bluecoinsapp.com/import-guide/

json file terminology

• jsonType simply means the type of the json file, there are simple and advanced. For more details refer to the bluecoins import guide.
• outFile describes the output file, which its members filePath signify the csv file path and defaultAppend determines if the default action is to append the existing file.
• presetLists is an array of objects consisting of account type and category list
• type is the type of account/transaction. Can be any value, but recommended values are Account, Expense, Income. You must have at least one category and child for each type.
• cat is the main category
• child is the child category

Creating the json file

Manual Creation

Simple json

This is a sample file for a simple json configuration. a(or, account) must be the first object in the presetLists array. Currently you are not required to fill in jsonType, but it is recommended for future releases.

{
    "jsonType" : "Simple",
    "outFile":[
    {
        "filePath" : "<Your csv file path>",
        "defaultAppend" : true / false
    }
    ],
    "presetLists":[
        {    
            "type" : "a",
            "catList" : [
                {
                    "cat" : "Category1",
                    "child" : [
                        "Child1.1",
                        "Child1.2"
                    ]
                }
            ]
        },
        {
            "type" : "e / i",
            "catList" : [
                {
                    "cat" : "Category2",
                    "child" : [
                        "Child2.1",
                        "Child2.2"
                    ]
                }
            ]
    ]
}

You may also refer to "./Tests/ktn.json" for a real life sample file.

(Future) Advanced json

To be announced, depending on project popularity.

(Future) Prompted json file creation

Depending the popularity of this project, a tool may be created to facilitate this use case. You are always welcome to fork my project.

Specifying default path

If you are compiling yourself, you may edit in your default path that you use to store your json and csv file so that you are not required to manual key in every time:

• In ".\BlueCoinsImportTool.h", you edit the following variable:

const string defaultJsonFileName = "<Your path>";

• Take note that you need to add extra backslashes for directory paths, e.g.: D:\Bluecoins-ImportTool\Tests\ktn.json would be D:\\Bluecoins-ImportTool\\Tests\\ktn.json

Split Transaction Support

Starting from v1.3, there will be suppot for split transactions. Just toggle option no. 6 at the main menu. You will see an extra section of text when the option is toggled to "true".

• Do take note that for split transactions to work, the following need to be the same. Future versions of the program will add functionality to lock in required lock-in :
  • Transaction Type
  • Title
  • Date, Time
• Using different label sets or status for each split is not currently supported. Only those from the first row will be used for each split transaction

No support / not tested

• Compilers other than the one default in Visual Studio 2019
• CMake. Not tried yet.

Project Milestones

• 23 July 2019, v1.3 released
• 5 July 2019, v1.2 released
• 1 July 2019, v1.1 released
• 27 June 2019, Project announcement to the BlueCoins Community
• 26 June 2019, Transfers logic completed
• 24 June 2019, Overall completed
• 21 June 2019, json file standard decided
• 16 June 2019, Project Started

License

This tool is licensed under the MIT License http://opensource.org/licenses/MIT.
Copyright © 2019 Kwong Tung Nan

Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the “Software”), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

---

This tool contains code from "json for modern C++" from Niels Lohmann which is licensed under the MIT License (see above).
Copyright © 2013-2019 Niels Lohmann , [email protected]