February 2015 In Brief

2113. Made minor revisions to MoneyBooks General Ledger 2.84, including correcting a bug on the Batch Transaction form.

2114. Began modifying the document management feature in MoneyBooks Data Manager (MBDM), adding a document owner group feature.

2135. Completed a useful feature in MBDM 2.1, document owner group entry. Began the new Fanbox features implementation starting with the transactions list with the ability to import from clipboard text copied off of the Fanbox screen. The Fanbox data is now stored locally in the MoneyBooks database for easier reference and analysis. A client came for the re-installation of MoneyBooks Payroll on their Lenovo laptop. Downloaded PostgreSQL for evaluation since it’s open-source, as a possible replacement for SQL Anywhere that is used for our applications when clients can’t pay for it.

2146. Put the new Fanbox transaction import feature of MBDM to live use, importing real Fanbox data, later considering other Fanbox features to implement. Tried installing PostgreSQL without success on a computer running Windows XP.

2150. Implemented Fanbox IPL fee transaction list in MBDM, also with clipboard data import ability. Successfully installed PostgreSQL 9.4.1 on a different computer running Windows 7.

2161. Spent most of the day implementing Fanbox posts data entry in MBDM, to record details about posts made on Fanbox such as status updates, photos, YouTube videos and blogs. Downloaded CHM documentation and an ODBC driver for PostgreSQL.

2172. Continued implementation of Fanbox posts in MBDM, completing the initial phase, including daily transactions summary list.

2183. Began live testing of the Fanbox features in MBDM. Implemented earnings summary report generation: For any given day or period the summarized Fanbox earnings and charges can be seen at a glance along with the net profit or loss.

2194. Continued live test and revision of the Fanbox features in MBDM.

2205. Continued more live data usage and revision of the Fanbox posts in MBDM.

2216. Spent most of the day working on the Fanbox feature in MBDM, entering live data and making the features easier and more convenient to use.

2220. Continued the Fanbox features implementation in MBDM (live data entry and revision).

2231. Spent most of the day going through PostgreSQL documentation and working with a test database, learning about the query and procedural language parts of the DBMS.

2253. Continued evaluation of PostgreSQL, getting PowerBuilder to use catalog tables and update a table in the test database via its datawindow object.

2264. Began conversion of the StatPrinta database for testing with PostgreSQL. StatPrinta is one of our demo applications for bank statement printing, with a very small database.

2275. Completed the PostgreSQL version of the StatPrinta database and got the application running against it, but with further tweaking to be done.

2286. Tweaked the PostgreSQL version of the StatPrinta database well enough to get the main report of the application being generated. This involved implementing in the database three SQL Anywhere functions that were called from the application, along with the string concatenation + operator. (This “overloading” feature is one useful thing that separates PostgreSQL from SQL Anywhere: You can implement your own versions of built-in functions and operators!)