Bifbotka SQL is an Active Scaffold Ruby on Rails web application that uses a SQL query, extracts transactions from Agresso then allows user to modify transactions and then outputs s friendly file such as a tab delimited text or Excel CSV file.
It is based on the highly successful Propmansheet web application and original bifBOTka application.
This example is used to post cash payments from the Agresso bank statement to the IBS Revenue and Benefits System.
You can use this code as a basis to make new applications to post different types of items.
screen print of original bifbotka
TO SET-UP (once only)
To install download and install instant rails (http://instantrails.rubyforge.org/wiki/wiki.pl).
Extract latest bifbotkasql zip (get from Downloads) to rails_app directory.
copy access details to Agresso database to by copying emailed "database.yml" to C:\InstantRails\rails_apps\bifbotkaSQL\config directory.
Open rails console window.
Change directory to bifbotkasql:
mysqladmin -u root create bifbotkasql_development
Go to website:
Use webpage to connect to Agresso and output tab delimited IBS file++
contact firstname.lastname@example.org for queries
( ++ IBS cash posting file CO-CASH-POSTING)
Copyright © 2013 Black Duck Software, Inc. and its contributors, Some Rights Reserved. Unless otherwise marked, this work is licensed under a Creative Commons Attribution 3.0 Unported License . Ohloh ® and the Ohloh logo are trademarks of Black Duck Software, Inc. in the United States and/or other jurisdictions. All other trademarks are the property of their respective holders.