Queries on databases and tables.

Databases

Extracting data from the backend database that stores all the content of your site is a very powerful feature to exploit. You can run calculations on this data and push it back to the front end of your site for visitors to see. 

FileMaker Pro

I work with FileMaker Pro, the desktop and mobile solution for quickly creating and deploying database Apps. These can be configured to access data from your WordPress website. 

I'm For Hire

When your agency is overrun with work and you need someone to complete that backlog of projects, I'm available as a front-end web developer and designer, an extra pair of hands.

Get in touch.

T: 353 87 2739203

E: sitedesign@vaughanprint.com

Inventory Database for SO Fine Art Editions

In 2013 I built an inventory database for So Fine Arts. in Dublin.

The Requirements

  • Record all consignments of work from artists (sale or return) with the appropriate documentation for this, printed or emailed to the artist
  • Record sales of work and issue either a sales receipt or an invoice.
  • Facilitate the payment for work purchased in instalments.
  • Calculate the VAT charged on the sales of work
  • Generate payments to artists for work sold reflecting the VAT and galley commission deducted. Documentation for this, printed or emailed.
  • Include non deductibles in payments to artists such as framing costs and bronze casting fees, not subject to gallery commission.
  • Record the return of unsold work to artists. Documentation for this, printed or emailed.
  • Generate sales reports and calculate VAT to be paid to Revenue.
  • Generate Credit Notes and log amounts in a Credit Control account for each customer where credit applies.
  • Generate return items where work is returned. Re-stocked works of art reflected in the stock table.
  • Issue gift vouchers and register them as sales.

 

So Fine Art Editions logo
Main Menu & Client/Artist Contact List

Main Menu & Client/Artist Contact List.

Layout for consignment docket and managemant of consinments to the gallery.

Layout for consignment docket and managemant of consinments to the gallery. 

Sales receipt and records of customer's sales.

Sales receipt and records of customer’s sales.

Web App Using PHP/HTML/CSS/JS With mySQL Database

As part of the Higher Diploma in computer science that I completed in 2014 at Carlow Institute of Technology I built an inventory system that was stored in a mySQL database, served through PHP server scripts to, presentation on screen with a web browser. This app required that users, logging in with secure passwords, would be locked out after three failed attempts.

Backend PHP and JavaScript files.

Backend PHP and JavaScript files.

Wire frames for web interface

I used a minimum wire-frame design for the web interface.

FileMaker Pro Integration

Additionally a FileMaker Pro file was created and configured with an ODBC driver. This permitted a desktop user to connect to mySQL on a remote server, an alternative way to access the inventory database.

WordPress Database Integrations

The WordPress REST API provides many ways to access the data held in the database and many plugin authors provide their solutions also

For less complex data collection, ODBC drivers can be configured in FileMaker Pro to access data stored in the WordPress tables by custom post type fields. Queries can be run in MySQLWorkbench to return the data in a presentable format as intermediary views. These views are saved to the database so that FileMaker can use them.

Data Buzz Integrations

Data Buzz produces a solution for FileMaker Pro to access orders placed online through WooCommerce  installed on a WordPress site.

Data Buzz Logo
fmEcommerce solution in FileMaker Pro

fmEcommerce Link (WooCommerce Edition) By Data Buzz