bifbotkasql

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:

cd bifbotkasql

Set-up database:

mysqladmin -u root create bifbotkasql_development

rake db:migrate

TO RUN

Run rails:

ruby script/server

Go to website:

http://localhost:3000/sqlbifinfo

Use webpage to connect to Agresso and output tab delimited IBS file++

contact ezzy@digiworld.com for queries

( ++ IBS cash posting file CO-CASH-POSTING)

Tags

  tabdelimitedfile mssql ezzyelliott ibs agresso activescaffold rubyonrails sql

Share