Tuesday, November 22, 2011

Filemaker Database: Oil Field Services

Six months ago, Gennovacap Technology built a Filemaker Database for an oilfield service client.  The client had been running a MS Access database when the motherboard on their PC burned out.  We retrieved the lost information from their hard drive and set the clients up with new Apple computers.  We built a new database from scratch with Filemaker and manually entered the old data into the new system.  After we had the database set up, our client could access all of their client's data directly from their iPhones via a remote server hosting their new Filemaker database.

The database solution included simple addition of new customers without creating irrelevant information for existing customers. For example: Entering "Billy's BBQ" and then adding "Billy's"  to the customer list would create a repetition for clients.  We implemented a fail safe process which eliminated problems like this with other types of databases.  We also integrated Google Maps into the database so that the firm could keep track of job logistics when sending their field technicians out to service equipment.  The database also included inventory tracking to keep up with all items currently in use as well as the technician responsible for the equipment. 

In addition to building the database solution, we worked closely with external Filemaker Consultants to integrate the database into Quickbooks using a specialized protocol.  This additional consulting created a solution which eliminated double entry of data from the database to Quickbooks.  With one touch publishing implemented, the business only had to review the information before it was published into their accounting software and invoices were billed out to clients.

The new system we built for our clients made managing their business easier.  The Filemaker solution enabled our clients to easily track employees, account for equipment, handle logistics, and eliminated the need for double entry for the accounts receivable portion for their business.  Now with our solution, our client can do all of this from their iPhones. To find out how we can help your business contact us today.

E-commerce solutions

Creating an E-Commerce site is not as difficult as it used to be.  Since the World Wide Web first came online and the dot com era came and went, technologists came together to create online shopping vehicles which empowered retail establishments.  Vehicles like osCommerce, Magento, and ZenCart have made setting up an online store as simple as making chocolate chip cookies. We built a turnkey e-commerce solution for Mardi Gras Gemoworks using osCommerce.  You can see view it here Mar-di Gras Gemworks

There are many ways to build an e-commerce solution, but in this particular case we had the client pick out a pre-fabricated template from Template Monster and we customized the logo as well as the back-end of the site.  Although we used a template to create this site, we could have as easily created the graphics and layout using a custom design generated from our graphics design team.

We integrated PayPal as their preferred method of payment, but we can also implement Authorize.net as well as Google Checkout for clients. 

After we completed the development work for this client, we set hosted the site for them on monthly plan.  We offer competitive rates and can scale your site's bandwidth as you grow your store online.  Along with hosting your site we can implement search engine optimization strategies to target your customer base and make your online store grow over time.  Contact us today to find out how we can help you grow.