Projects

Mindfire has deep experience developing FileMaker database-driven web sites and web applications, with PHP or Lasso programming. We describe some of these FileMaker web development project experiences below, and will be glad to share our expertise in detail with you. Learn more about our FileMaker expertise here:    FileMaker development services    FileMaker database development To discuss about our services and how we could work together, please contact us on sales@mindfiresolutions.com or call 1-248-686-1424.

  • Shopping Cart – Songs & Albums
  • Manage Fund over Web
  • Commercial web-site
  • Online Shopping Cart
  • Product Management for Dealers/Customers
  • FileMaker Web Admin
  • Online garment store
  • EMAS (European Environmental Audit System)
  • Php based application Manage Hosted file on FMP server
  • Conversion of a CDML based  website to php
  • Conversion - CDML to Lasso
  • Shopping cart to sale antique products
  • Web application to buy or sell crate products
  • Media Project Approval System
  • Manufacturing Process Application
  • Customer Worksheet Integration
  • Customized Content Management System
  • iPhone Web Application
  • Business Management Application
  • FM Web Admin
  • Event Management System
  • Customer Portal
  • Vehicle mentainance and overhaul contracts tracking system
  • Filemaker PHP Web Portal
  • RusselB_PHP_HO
  • Online Music
  • Lasso - Wind Tunneling
  • Retail And Shop Management System
  • Order Management Application
  • Application for Tour Booking
  • Online Booking management of Shipments
  • Online Apartment Catalog
  • Job Estimator
  • Enhancement to Media Asset Management System
  • Book a trip Online
  • Task Management System
  • Candidate referencing system
  • Customer And Sales Management
  • Application for managing electrical projects and resources
  • Shipping Software Application
  • Shopping Cart Application driven by FileMaker
  • Bi-directional Synchronization via WCF services
  • Labs and Billing for Gynaecology Specialists and Practitioners
  • POS System for Jewelry Designers


Shopping Cart – Songs & Albums

Client:
Music Store
Industry:
Music Store
Technologies:
PHP 5, FileMaker Server 8, FileMaker Pro 8.5 Advanced

The web application manages shopping cart and communicates with the FileMaker database for information of the products and processing of the orders. It is also equipped to process online payment through Authorize.Net and PayPal. The application is structured as modules: administrator, user cart, payment processing, shipping, reports and database loading.


Manage Fund over Web

Client:
FileMaker database/web solutions provider
Industry:
Software Product and Service
Technologies:
PHP, HTML, JavaScript, Filemaker Pro 8 Advanced, Filemaker Server 8 Advanced

This is a web application that acts as a middleware between the bank clients and the Borrower, Inspector and Contractors.

The borrowers take the construction loan from the bank. The loan is divided into several Budget Codes, which are pre defined by the bank. The loan amount is then divided between the budget codes. The borrower can reallocate the loan amounts between the budget codes (Budget Reallocation). The bank has given some pre defined checks for the borrower i.e. Vouchers. The borrower can issue the vouchers to contractors. The role of the inspector is to verify the construction progress and submit his report on the construction to the system. FCW uses the Fund Control Web FileMaker Database.


Commercial web-site

Client:
FileMaker database/web solutions provider
Industry:
Software Product and Service
Technologies:
PHP, HTML, JavaScript, Filemaker Pro 8 Advanced, Filemaker Server 8 Advanced

This website was basically developed for commercial use by the client. The website has all products demonstrated, place for the latest news, information related to consultation, supports and about the company etc. The look and feel of the website content is managed by the FileMaker database. It is therefore now easy for the user to make changes as required.


Online Shopping Cart

Client:
Software solutions provider
Industry:
Software Product and Service
Technologies:
Lasso 8.1, FileMaker Server 8 Advanced

This is a web application, manages shopping cart and communicates with the core FileMaker application for information related to products and processing of orders. The application can be customized easily as per the business requirement. It is also equipped to process online payment through Authorize.Net and PayPal.


Product Management for Dealers/Customers

Client:
Software solution provider
Industry:
Diamond wholesale
Technologies:
PHP, AJAX, CSS, MySQL, FielMaker 8.5 Advance

This website has been used by the dealers/customers to search for products by different criteria. Dealer's can login to their respective accounts and set markup prices for the products they are associated with. When the customer visits the website through the dealer's web-site then the price shown to the customer will be dealer specific. The dealer and the customer can request for the products they are looking for using the application.


FileMaker Web Admin

Client:
Software product and services
Industry:
FileMaker web hosting
Technologies:
PHP 5, FileMaker Server 8 Advanced

This application has been designed for the customers, who have taken a space to host the filemaker databases. This application allows the users to upload, download, opening, closing of the FileMaker databases. Also, customer can take back-up of their own databases.


Online garment store

Client:
Software solutions provider
Industry:
Garment Business
Technologies:
Lasso 8.1, FileMaker Server 8 Advanced

The online web store was developed for a Garment Business System, where all the garments are available for online shopping. The payment is done through the Authorize.Net transaction gateway. There is synchronization between the web store and the FileMaker stand alone database via which the shopping cart details are transferred to the local business system based in the store to which the cart product belongs.


EMAS (European Environmental Audit System)

Client:
Digital Multimedia
Industry:
Multimedia and Animation
Technologies:
PHP 4.3, MySQL 5

The background of this project is a European environmental audit system (EMAS) roughly comparable to ISO14000. Companies that are certified for EMAS are obligated to do many audits on a regular basis (machines have to be checked, processes have to be controlled, and so on).

The goal of this project was to create a web based notification system that helps companies to keep track of their EMAS audit cycles. The system will allow to feed a company's audit cycles into a database using an HTML based web front-end, and to remind the responsible person(s) of each audit that becomes due by sending out emails.  The system tracks all the audits in its database and sends out email notifications when an audit deadline approaches, when the audit becomes due and when it has become overdue without being handled. It also provides the possibility to enter a correction cycle when the auditing was done but the result was negative. The correction cycle also has a set of notifications that are sent out when the certain time limits are reached.


Php based application Manage Hosted file on FMP server

Client:
Custom database solution provider
Industry:

Technologies:
Filemaker 8.5., Filemaker Server 8, PHP

We developed functionality to have FileMaker hosting service to upload, turn on, and turn off their FileMaker files from the web. The other features support multiple server for hosting, user can sign up and login for the trial filemkaer file hosting, user is acknowledged about the demo access, user can turn on and turn off the Filemaker file hosted on the server, can upload file to the server and host it on the server, can download the hosted file from the daily backup folder to the local machine.


Conversion of a CDML based  website to php

Client:
Custom database solution provider
Industry:

Technologies:
Filemaker 7., Filemaker Server 7, PHP

We converted the functionality written in CDML to php to make  it compatible with the updated version of the databse Filemaker 7.


Conversion - CDML to Lasso

Client:
Software products and services
Industry:
Healthcare
Technologies:
Lasso, JavaScript, FileMaker 9

The website is used to track and manage events. The site was previously developed in CDML, ASP.NET & FileMaker 6, which we have converted to Lasso, FileMaker 9 by keeping all the previous functionalities as it is.


Shopping cart to sale antique products

Client:
Software Service Provider
Industry:
Antique industry
Technologies:
PHP, MYSQL, AJAX, JavaScript, HTML, CSS, FileMaker

This first version of web application has been developed to serve as SaaS. It allows visitors to get detail information about the antiques/products with a categorized tree structure. Visitors can add their favorite products to the favorite list and later buy it with a secure payment transaction process. The optimized calculation process provides complete information about the quantities, amounts for Products, Vats (As per Countries), and Discounts and shipping prices (as per the buyer's information) in buying transactions. Users has the option to check and print their orders.

FileMaker application has been developed to manage company, product, price, tax, discount and shipping related information. Several processes have been written to synchronize data between the two applications. Company administrator has the option to change the complete look and feel of the web application on the fly.


Web application to buy or sell crate products

Client:
Software Service Provider
Industry:
Crates
Technologies:
PHP, FileMaker

It is a web community that's designed just for crate makers and crate buyers.

A complete dynamic website where the administrator has the control to decide which data need to be displayed and which is not.

The user can add/update the sponsor ad for their company, add/update articles, add/update personal resume, add/update events etc., and all these things have been implemented using FCKeditor and CKFinder. The company can pay for the sponsor / banner ads online using paypal.

The website provides information on crating standards, regulations and terminologies. Searching options are there for the crating companies for particular type like crater, distributor, wood, foam, eradicator etc. and zone/state/country, as well as distance range search option.

Also one can find the Employment Opportunities in Packing & Crating through this website.


Media Project Approval System

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Server 10 Advanced, PHP 5 using PHP FileMaker API, HTML, CSS, JavaScript, and JQuery

This is a web solution sharply designed to be used by the executives, on-air schedulers, power users of a television and radio network. It allows the executives to approve the promotional items and scripts for a project created by the Creative, Production and On-Air departments for Television and Radio Networks. This shows the list of promos and scripts awaiting approvals from the vice presidents and directors of On-Air departments. It allows the executives to view the assets, documents, still photos, audio files or videos uploaded for the promos or scripts in the FileMaker application using 360 Works SuperContainer plug-in. It has the functionality to allow executive users to approve or decline the promo or script. The other users can use this solution to upload assets such as graphics, animation, audio files, videos and documents for the promos and scripts which is then approved by the executive users. The user login authentication is done via Active directory groups.


Manufacturing Process Application

Client:
Software Solution Provider
Industry:
SME
Technologies:
FileMaker Pro 9/10 Advanced, FileMaker Server 9/10 Advanced, Lasso, PHP, Base Element tool

This application manages the manufacturing process more effectively with multi-level BOM tracking, scheduling of each stage of the production process, and tracking progress. Easily handle the complexity of multi-level BOM with powerful tools to build, edit, and revise it. Automatically creates production orders and production schedule. Manage the production process more efficiently and effectively which allows to know the up to date status of items. Manage purchase orders and change orders to keep the production process on track.

Multi-Level Bill of Materials

Design, edit, duplicate, and revise unlimited bill of materials with easy design tool to build and manage the complexity of a multi-level BoM. BoM is automatically converted into production orders and schedule based on logical sequence of producing it from the bottom up.

1.Handle the complexity of multi-level bill of materials with special tools to build, edit, revise, and process them.

2.Auto Convert BoM from Sales to Production Orders and Production Schedule Expandable.

3.Unlimited levels for building BoM's.

4.Easily move around items within the BoM.

5.Ability to create auto create revisions of BOM when changes are made.

6.Create BoM's fast with pick lists.



Production Orders

1. Automatically creates production orders from sales based on inventory levels.

2. Auto creates production orders based on sales or manually based on replenishment of inventory stock.

Production Schedule

Automatically schedule production orders based on preset production stages and intervals. Ability to assign the production schedule for each day for each phases of production process.

1.Powerful tools to define unique production process and to manage it.

2.Auto schedule items from Sales based on preset parameters.



Manage each stage of manufacturing process with management screen to know what to produce on each day, how many are left to produce, and the history of what has been produced so far. Easily post the consumption of raw material inventory, as well as posting the finished goods to fulfillment.

1.Track consumption of raw material inventory.

2.Get quick overviews of production status of items.

3.Create and manage change orders.

4.Easily transfer inventory between warehouse locations.

5.Monitor the status of purchase orders to make sure that the materials will arrive in time for production requirements.


Customer Worksheet Integration

Client:
Software Solutions Provider
Industry:
SME
Technologies:
FileMaker Pro 9/10 Advanced, FileMaker Server 9/10 Advanced, Lasso, PHP, Base Element tool

Customer worksheet has been used to store multiple items which is then processed as sales order on daily basis. It keeps the information about item number, description, quantity and price.

Multiple worksheets can be maintained against a singe sale i.e. for one sale it can maintain maximum 7 different worksheets with different items and quantities. Basically these 7 worksheets indicates to 7 different days of a week.


Customized Content Management System

Client:
Software Solutions Provider
Industry:
SME
Technologies:
FileMaker Pro 9/10 Advanced, FileMaker Server 9/10 Advanced, Lasso, PHP, Base Element tool

The website is built for a company to sell their own software product, developed in PHP and FileMaker using FileMaker API for PHP.

The main focus of this website is to provide all possible details of their products and services to the visitors. Also special attention is given on Case Studies and Testimonials pages to display the feedbacks from the clients who are already using their products.

All the contents of the website are dynamic, database driven, so that it can be modified easily.


iPhone Web Application

Client:
Software Solutions Provider
Industry:
SME
Technologies:
FileMaker Pro 9/10 Advanced, FileMaker Server 9/10 Advanced, PHP, Base Element tool

This application is developed in PHP and FileMaker using FileMaker API for PHP. This is a web application for iPhone browser. So iPhone specific CSS has been used to develop this application. This Mobile application enables the users to create, edit, and view contacts, products, and sales on the iPhone. So the user can work when they are not in the office and can be still connected to the application.

Also the user can send the sales quote as PDF attachment in an e-mail from the iPhone to their clients. Search and advanced search functionality is also available in this application.


Business Management Application

Client:
Software Solutions Provider
Industry:
SME
Technologies:
FileMaker Pro 9/10 Advanced, FileMaker Server 9/10 Advanced, Lasso, PHP, Base Element tool

This is a very vast application developed for a business. Different Modules implemented in this application are as follows:

Product Module: It allows to synchronize items and its detail information from product file to the external data source FileMaker file hosted at client end.

Purchase Module: Added functionality to compare and check expected serial numbers entered for a serialized item and post them to the Inventory.

Contact Module: Added functionality such as Date import, import emails from a template and export it and changed the 8 module navigation system to 16 module navigation.

Sales Module: Added feature of Product options in Product section and allow filtering the items in Sales module with multiple value selection. It has various other functionalities also.

Event Module: Added the feature to revise and duplicate a contract, which enable the functionality to add items along with their parts to a contract.

Accounting Module: Designed a new screen to display all the Posting areas from where items are posted to General/Ledger of Accounting section.

Production Management Module: Added functionality for adding the components to a Production Order by select an item which have components and when that item has been produced, then posting the finished goods to the inventory which will update the Inventory as per number of parts/component utilized.

Sample Data Module: Added functionality to import data (all modules) from an external sample data file to the main application system and vice-versa.

Website Changes: Added functionality to fetch all active and new products, promotional items and active news item to be displayed on the website. Also implemented email functionality.

Ecommerce Module: Integrated the download project from older version of the application to the new version with enabling the ecommerce module with the modification done in the older version of the application.

Administration: Added a new master script to import data from an Excel sheet with different worksheets such as Product, Contact & Accounting, which is present in a specific location in application folder. This will allow importing all the data from the respective worksheet to the corresponding files automatically.

Purchase Requisition Module: Implemented AJAX in Purchase, Pricing page and most of its related pages for enhance the execution speed. Also, we have optimized the code to minimize the database connection from LASSO to FileMaker.

Sample Company Module: Created a new file as a separate module, which will be used to store the good sample data by a single button click from our current system to this file and at the time we need this we can restore them in our current system from this sample file.

Clean Up: Clean up unnecessary fields, table occurrences, value-lists, scripts etc in the application (all modules) using Base Element tool.

Main Module: As per the Business Process selected in Main Menu it will highlight the navigation module icons.


FM Web Admin

Client:
Software service provider
Industry:
Software
Technologies:
Lasso 9.0, MYSQL

Filemaker Web Admin has been developed in Lasso to administered FileMaker server on web. Multiple users can have access to the same FileMaker server to host their files with the limits as per there agreement.


Event Management System

Client:
Software service Provider
Industry:
Food and Beverages
Technologies:
PHP 5, FileMaker Pro 11, FileMaker Server 11, FileMaker API for PHP

The project is basically an Event Management project, where each event will have its own URL but all events will talk to the same FileMaker database file. The application has been developed in two versions: Web version in PHP & FileMaker and the desktop version in FileMaker.

The project consists of following modules:

Login: In the login process it calls a SOAP function to connect to the login API which validates the user credentials and returns information about the partner which is retrieved and stored in the FileMaker database.

Registration: The partner is bound to complete the registration process before moving forward for other modules of registration. There is also a provision of Add Guest in the registration process.

Emergency Contact: The emergency contact information has to be filled up for attendee and guest (if registered) for any emergency situation.

Hotel Information: There is an option for choosing the host hotel or making other arrangements. If host hotel is selected then the partner has to choose the room type, check in, check out dates etc. The price is calculated per night basis.

Travel Information: The partner and guest have to choose the inbound and outbound travel information.

Continuing Education: The partner and guest have to choose the classes they want to attend and the timing (session) of that class.

Meal Choice: The partner and guest have to choose the meal type, dish for Friday dinner and dish for Saturday lunch.

Payment: The payment process is using Authorize.net as the payment gateway. The payment is made after all the registration steps are completed. The payment is made for "Partner registration", "Guest registration" and "Hotel registration". After paying for the hotel if the partner wants to extend its night then he can extend and pay for it.


Customer Portal

Client:
Hardware and Software Services
Industry:
Consumer Goods & Services
Technologies:
PHP, Filemaker, HTML,  Ajax,  CSS & Javascript

This application has 2 parts as follows:

I  Users

II Administrator

User has following functionalities as mentioned below:

Create a new account: A user can register to application to make any purchase. After successful registration with application, it sends the log-in credentials to user in a mail and also notify the admin about new registration of user with application.

New Order: The user can purchase the goods by selecting and placing an order.

Payment for Order: A user can make payment online. The application uses authorize.net payment gateway to make the payment of the orders. After making successful payment application, sends an email notification to the user & administrator about the new order.

List Orders: A user can view all his orders made by him.

Edit Or Re-Order: User can edit his older orders and if he wants he can reordered it. He can also make changes like increasing or decresing the number of quantity, add ir remove products.

Administrator has following functionalities:

I Search users.

  - View Orders of users.

  - Edit user detail.

II List Orders in a date range.

III Get Order total and payment total in a date range.

IV Search a particular order.

Search Users: Users can be searched by their contact name either by partial name or by full name functionality available on Ajax as well with normal post method also.

   View Orders: List orders can be viewed from an user and can be edited also. Administrator can also create invoice for the order by viewing the order.

   Edit User information: Administrator can edit the user information.

List Order in a date range: Administrator can list the orders by selecting a date range, application displays a list of orders made by all the users of the application in a date range selected by administrator.

Order Total & Payment total: Administrator can view a total summation of the order made and the total payment made in a date range selected by administrator.

Search a Particular Order: the order can be edited or viewed.


Vehicle mentainance and overhaul contracts tracking system

Client:
Software Service Provider
Industry:
Automobile
Technologies:
PHP, FileMaker Server 11, FileMaker API for PHP, HTML, JQuery, CSS & JavaScript

This is a website developed in PHP that communicates with a FileMaker database system hosted at FileMaker 11 Server. The client has a FileMaker database system which is used to keep track of the periodic maintenance on vehicles and the contracts. It tracks all contract and warranty related defects for assistance in managing inspections, identifying trends in managing warranties, penalties and rewards on any rail equipment contract. The system also tracks the penalties and rewards associated with equipment related contracts.



  The system is being accessed by the desktop users by using FileMaker Pro 11 and also the system has web users who access the system by opening webpage in web browsers. Formerly the web access was done by using FileMaker Instant Web Publishing solution, which was too slow to access and resulting performance issues as the data in the database grow day by day. As a solution to the slower web accessibility, Mindfire has built a cross browser compatible web application using PHP, HTML, CSS, JavaScript, JQuery technologies which has highly improved access speed as compared to the former IWP solution. The website communicates to the FileMaker database system using FileMaker API for PHP to fetch, add and update the data. The website has a user login form that validates the login information that matches the FileMaker account names and passwords of the database. After successful login the user is taken to his dashboard where s/he can see an overview of all the tags and contracts added by the current user. The list view of tags has been pulled and shown from database using Ajax driven JQuery Grid. An advanced search form is provided in the dashboard web page with the ability to filter the list view grid based on several find criteria. The user can add new tags or contracts to the system directly from the web site. The user can view/edit the tag record detail by clicking on a tag row in the grid, which will show the tag detail information form in a web interface. The web application also provides a reporting ability to the web users. The user can export the filtered rows in the grid to an Excel and PDF format files.


Filemaker PHP Web Portal

Client:
Software Service Provider
Industry:
Oil & Gas Energy
Technologies:
PHP, FileMaker API, HTML, CSS, JS, JQuery, FileMaker 11 Server as backend database

This is a proof of concept built for the client which has mainly the different kinds of reporting and graphic features developed in a PHP that are already available within their FileMaker database. It is a FileMaker custom web publishing (CWP) solution developed using PHP. The reason behind developing a PHP web portal for the reporting and graphic features is the client wants to reduce the number of FileMaker Pro client license to the staffs who only need to review the exploration reports. These users can access the reports using the web browsers. The reports built in PHP web portal are highly robust and faster to access. JQuery grid has been integrated for presentation of the report table with having column header sorting, fixed table header with vertical and horizontal scrolling abilities, and export report tables to excel and PDF output files.


RusselB_PHP_HO

Client:
Software Services Provider
Industry:
Software Services
Technologies:
PHP, FileMaker, HTML, CSS, Javascript, Smarty

For this application Filemaker is used as database. And the admin section is designed in filemaker.

Using this web application the user can buy semiconductor parts and tools. To book any parts or tools, user needs to pay an amount online. This amount includes price of the product, shipping price and tax(if applicable). All payments are done using paypal. For shipping the product, fedex service is being used. User can choose the shipping method from the available list.


Online Music

Client:
Online Music
Industry:
Entertainment
Technologies:
PHP, FIlemaker, Jquery, Sencha touch

Implemented new features to the old site so that products work with new one. Replaced audio player with a non flash,jplayer plugin used to implement the same functionality. Tracked the number of views to define the popular products. Improved the search functionality. Modified the home page view. New pagination added to the search page. And added ajax cart.

Solved many issues such as register verification, forgot password. Fixed bugs and few improvements on product register process.

For Mobile website various functionalities were implemented, like displayed new releases in the home page. On clicking a particular album, details of the album were displayed. Search functionality was implemented at the bottom of every page, a search field was present where a user can put any album title, artist, record label and view all records.


Lasso - Wind Tunneling

Industry:

Technologies:
Lasso 9, LassoApps, PostgreSQL, HTML, JQuery, CSS & Javascript

This is a website developed using LassoApps running on a Lasso 9 server and communicating to the PostgreSQL database at the back end. The lassoapp website is used by a company that helps their customers to release what is known and imagined among participants throughout their organization, creating maps of the future that reduce risk while enhancing adaptability and resilience.

The system allows four types of user access such as Administrator, Coordinator, Facilitator and User or Participants.
1. Administrator has the ability to add a new customer to the database and assign a coordinator for the customer. Admin can activate the new customer and can further configure the customer's permissions. Admin can manage (add, edit, reset password and delete) the users of the system. The system also provides the option to import the users data from external format files such as xls, csv, tab delimited files etc.

2. Coordinators are the persons who will coordinate the customer's project. Using this a system coordinator can add/invite facilitators for the customers, who will then operate on those customers' project. The coordinator(s) can also view the last activity logs of the facilitators whom they have assigned to the customers.

3. Facilitator can log in to the website and create/modify the projects for the customers for whom they facilitate. The facilitator can schedule the future events for each project and can also add/invite participants to the project who can contribute their imagination on the future events. The facilitator can change the stage of the project and move to next steps to complete the project. Provided the text editing ability to the Facilitators so that they can change the text paragraphs, field labels, tabular view column headers in a web page and also can rename the buttons displayed in the forms, change the text in the dialog messages for a particular Project Record. So that the Participants can get a better understanding on the Project.

4. Participants can log in to the website and contribute their visions on the future events.


Retail And Shop Management System

Client:
Software consultant
Industry:
Retail Industry
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11 Advanced, PHP, HTML, CSS, Javascript, JQuery, LDAP auth integration in PHP

This is a complete desktop based FileMaker application to handle day-to-day business process of the company like to gather information regarding new shop of client, shop building and shop maintenance process, customer management, employee management etc. This system comprises of many modules such as project management module, people management module, company management module, web admin console module, MS AX integration module, time billing module and handover module.

The company has PHP based web application where their clients added the upcoming shops. Previously the web application was static one where every forms are based for only one client. We have made the web application completely dynamic for different clients. Now the admin user is controlling and customizing the web application forms and tabs dynamically according to the requirement of their clients inside web admin console module present in the FileMaker application. Also user login and privilege management is also integrated in that so that user security can be maintained as well. Web application is using same FileMaker database in back-end and store every information of project in the database. After shop information has been filled up and verified by the web user, now it sends to the project management module.

The project management module is the core module, which deals with the each and every shop, partner and project information. Now it has been verified by assistant and set up the project flow. It includes different tasks management, project flow management, resource utilization, planning the project with proper documentation, project confirmation etc. After these processes, it is now exported to MS Axapta.

By people management module they can manage their employee information with their login process as well. Users, which are dealing with web application, are maintained separately.
br> Company management module deals with their client information. Each client is having different set up brands, concept and service and these are well maintained inside this module. Each and every task after completion by assistants are recorded in timesheet and is managed in time billing Module. After shop building is completed it is now handed over to their client and all these process are managed in handover module for maintenance.

They have another CRM system in MS Axapta where each every project information is getting stored and this has been performed in MS AX Integration Module. This is a two-way communication between FileMaker and MS AX via Webservice. Ax is providing Webservice for some of their methods, which are called, from FileMaker by using 360 Scriptmaster plugin. The reverse communication is established by 360 webservice manager. Similarly they have some database in SQL server, which is used as External data sources for FileMaker application to fetch data.

It has a nice reporting section where users can generate customized excel report dynamically. There are several opening list templates are created according to the requirement of the users and the excel reports are generated.


Order Management Application

Client:
Software Service
Industry:
Software Services
Technologies:
FM, PHP, Filemaker API 

Here we have created the web interface for an existing FileMaker application. After login, user will get to home page where he has the ability to do searches and six different functionalities associated with search. Here are the 6 features which have been implemented:

1. Search Box: In search box user can search job/qoute number, job/qoute title and product type.
2. My Saved Quotes Button : It will display list of "Saved Quotes" (Show last 30 days data ).
3. My Work In Progress Button : Display list of Jobs which is in progress( Show last 90 days data ).
4. New Quote Button : Here user can create "New Quote".
5. View Re Order Past Jobs Button : It will display list of all past jobs.
6. View Quotes  Button : It will display list of all Quote which is in progress.
7. Exit Button : For Logout the application.


Application for Tour Booking

Client:
Software Services
Industry:
Travel
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11, PHP 5

This web application is used to book the available tours by the client and to check the booking details of clients by the agents. Client can search for all the tours available for a specific period with details of pricing for each tour. Then the client can book a specific tour with the proper credentials. A new user needs to register first and then only he/she can go to the booking details page. After the booking is confirmed, the booking details are sent to the client through email.


Online Booking management of Shipments

Client:
Logistics Services
Industry:
Logistics
Technologies:
PHP, MySQL, Jquery, Linux System Commands

It's an application to be used within the organization. This provides exact current status of booking along with step by step process history. There is also an option for user by which one can get the graphical report for number of bookings from a particular customer in a specific time period which will help them to keep track of their business flow. Also user can customize the chart by selecting different Chart types (Yearly, Monthly, Weekly etc.) User can save the reports as PDF, can send reports as email to one or more mail ids or directly print them. Also user can download the booking request and booking confirmation related data for a selected booking.


Online Apartment Catalog

Client:
Software Service Provider
Industry:
Real Estate
Technologies:
PHP, HTML, CSS, JavaScript, JQuery, Photoshop CS4 

Complete Website was developed with the apartment catalog for different properties on different locations. The web application works for both portrait and landscape modes in iPhone and Android devices with separate CSS for both the views.

We have also added Google Maps and Facebook like & share functionalities in the app.  PHP functionality is added to send email to friends and for asking their opinion about any particular property. JavaScript and jQuery added for redirecting and orientation of the website on Mobile devices.

Photoshop CS4 used for making changes to change design and many artwork required for the project.


Job Estimator

Client:
Software Service Provider
Industry:
Energy
Technologies:
PHP, HTML, CSS, JavaScript, JQuery Ajax, MySQL 

We developed this application for making estimates about paintings and respective maintenance jobs. The application has both admin as well as user features. Basically, the application works on different types of forms.

The admin has flexibility of managing users and setting up permissions along with the ability to manage categories, items and sub-items and their respective parameters for different forms.

The user portal is basically meant for iPad use and is made compatible with iPad's Safari browser. Users can make estimations using the forms along with the respective categories and items and their various parameters. The user can also make job risk assessment using the user portal.


Enhancement to Media Asset Management System

Client:
Software Service Provider
Industry:
Publishing
Technologies:
Lasso 8.6, MySQL

This is an online system developed for uploading, reviewing and approving the artwork by created by the design agencies. The artwork goes through a number of review stages and gets the approvals from each stage. The online website has a section which shows the details of all the products in a tabular structure. The table has lots of columns which usually overflows out of the browser window, and a horizontal scroll bar is added to the browser window. If the table contains more rows, then a vertical scroll bar is added to the browser window.

We changed the design of the table with look and feel much like Google doc spread sheet with adding the horizontal and vertical scroll bars to the table. We have made the header row and first column of the table fixed. With horizontal scroll, the first column of the table remains fixed and with vertical scroll, the header row of the table remains fixed. We have locked the horizontal and vertical scroll bar of the browser window and made adjustment with the table, so that the table will be resized automatically with the resizing of the browser window.


Book a trip Online

Client:
Software Service
Industry:
Tourism
Technologies:
FileMaker(Database), PHP, jQuery, Javascript.

The application is helpful to book a trip online. This application contains easy and simple way to find hotels/holidays as per your need.  Option is there to book travel services as well. You can find holidays and hotel room that suites your need, then can add them to your cart. Once you have booked a product (hotel/holiday), you can add some extra items for this. Ex: If you have booked a hotel room, then you can book breakfast, taxi services as extra for this room.

You can save your cart as quote for future booking or can book your cart immediately by paying a minimum deposit (online direct post method). Minimum deposit will be calculated by the application depending on the products you have selected, the price of the selected product, start date of the trip. You can also edit a quote in future.

This application also has the option for third party agent booking a trip for others. They can have their commission for this from admin. Agents need to login separately for their transactions. They will have commission for each booking.

For admin section FileMaker interface is used. Database will be used by admin to add different products, to create trips for users, to reply questions asked by web user. Database contains all settings for admin tasks. Admin can generate invoice for booked trip and can save it as PDF. They can also generate reports for all the booked trips (based on start month or year, Booked Currency etc), all payments (based on transaction month, year, Currency), according to his requirements.


Task Management System

Client:
Business Process Management Solutions
Industry:
Publishing
Technologies:
Lasso 8.6, Apache 2.2, MYSQL

The project has been built to manage tasks efficiently with the customized workflow management ability. The core part of workflow is to create a new task by uploading an artwork related to Project or Products, which has 2 levels, project level and product level. A project level has multiple product levels.

Different types of users are associated with these levels. Such as Design Project Manager, Designer, Supplier, Printer etc. After adding products, a task to upload an artwork gets activated for a particular user. The uploaded artwork moves through the workflow, generate tasks for approved users to review and takes the approval or rejection as input.

There is a feature used to accomplish approval tasks which is handled by Annotation Module. This project has two implementations i.e. V1 and V2. Flex is used in the annotation module in V1 and Java is used in V2. And these annotation module has following functionalities:

•to approve the artwork
•to reject the artwork
•to download artwork
•to print artwork
•to zoom-in and zoom-out
•to add comments

According to the approval and rejection of the artwork, the workflow moves forward and next set of tasks gets created. This process takes the inputs from the finished review and decides the next step. Some additional features of the application listed below:

• Search
• Project Status Tracker
• Product Status Tracker
• Project/Product Asset Management
• Lifecycle Report
• Late Report
• Delegate Tasks
• Estimation work


Candidate referencing system

Client:
Software Service
Industry:
IT
Technologies:
FileMaker, PHP, FileMaker API for PHP

It's a complete job portal system, where different registered candidates are refereed to client companies for the placement. Admin or client company  add their job requirement and head count detail into the system. Then they need to add different applicants and their details into the system. After creating applicants, candidates are suppose to login to the system with the credential sent after registration and fill the details, previous employment history etc. at the same time. PHP is used for the front end and FileMaker pro was used as database.

In this project we have done  several modification into the existing system as mentioned below.
1.  Added Criminal Record Check request for the candidates.
2.  Previously the uploaded documents done by candidate are stored on their PHP server at a particular place. But we have added a new way to store the uploaded documents securely. Instead of storing  documents at PHP server, we are storing the documents in FileMaker server secured path. One can fetch those documents more securely from  FileMaker server secured path.
3.  Previously admin user couldn't able upload any document against any candidate by the system. We have added the same document upload functionality for Admin user, to upload document against any candidate. The system is designed like that, the document uploaded by admin user are only visible to admin person but not visible to the respective candidate.
4. A new mailing system is added. After uploading document, an email will be fired to the admin or candidate whoever uploading document with the text message maintained in the template section of FileMaker application.
5.An Admin applicant can view and can makes changes to the pages to make it look good.


Customer And Sales Management

Client:
Salon Cosmetics Distributor
Industry:
Fashion Design
Technologies:
FileMaker Pro 12 Adv, FileMaker Go 12, iPad, FileMaker Server 12 and PHP

This application handles all customers, all stores, all store related staffs, store related services, store related customers, store related transactions and after all it summarize total transaction on daily, weekly, monthly and yearly. So this application can be called as one solution for all requirements.

It helps to keep track of all part of a business. It helps us to track number of customers on each day per individual store. Not only customers but also we can track all other things as well like total revenue per store, top selling services, growth rate of business etc. We can keep track of financial detail with this application. It run in iPads, Mac and PCs. It is  a light weight application. The UI is so simple and light weight.

Customer Check-In Check-Out

Customers need to check-in with there phone number, first name and email address. Email address is not compulsory here. After check-in, the system will put them in queue.  Customers in queue will be served when a staff will be ready. Once the customers are served, they need to check out. This application provides the facility to pay the amount as it suits the customers. They can pay by Credit Cards, Gift Cards, Loyalty Cash, Cash or Combination of all or some of these payment process. On each transaction, customers get some loyalty points  and after accumulating some point they can avail loyalty cash. That cash can be used in payment. 

Admin Section

Admin always have the full privileges. He can view, delete, create and edit any partners, stores, staffs etc. Admin can view all stores transaction details. He also can assign services to individual stores and set their prices.

Partner Section

Partners are also known as owner. Here a partner can own one or more stores. He can view store details, add, edit his(his stores only) staff details. Owner can see only his store's transaction details on daily, weekly, monthly and yearly basis.


Application for managing electrical projects and resources

Client:
Electrical contractor
Industry:
Electrical Power Supply Installation
Technologies:
FileMaker Pro 12 Advanced, FileMaker Server 12, Filemaker Go 12

This is an application designed to run both on desktop and ipad. This application is designed for an electrical company to create electrical bids by gathering information and calculating and comparing the cost and manage the employee work after that bid get converted to active jobs. Various modules of this project are Crew, Unit, Bid, Job, Timesheet, Survey, Scheduling, Change Order,Email and reports.

In the crew module user creates crew by adding employees,equipments and tools. In the unit module the user keeps a list of all the units which are basically  work types. For each unit the user assigned a crew and all the information gets attached to the unit.

In the bid the user adds all the required units from the unit table to the location table. After the user adds all the locations  the cost related to each location gets evaluated according to the client specified logic.Additional costs and other information can also be added. Then the user converts a bid to an active job in the job module.In the job page the user can schedule the locations for different days.The user can compare the cost for scheduled location for each day.

In the timecard the user can add the employees and equipment by selecting a crew and also the locations scheduled for that day gets added.The user can enter the work details for the locations and all the costs and bill to the location and crew gets calculated automatically and also the location status gets updated in the job page(which list out all the location details). In the change order module the user can add the extra works or locations that are missed in the bid module.User can also calculate the estimate cost and billing amount by adding the employee and equipment to this module. This module can also be added to the timesheet table.

In the survey module the user can store the data regarding the survey for a location and can generate reports on it. There are also features like sending emails and generating reports, job status reports and invoices.


Shipping Software Application

Client:
Software Service Provider
Industry:
Shipping and Logistics
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11, PHP Webservice calls from FileMaker

Designed and developed a shipping software application for a software services provider catering specifically to the shipping and logistics industry. This software helps to effectively address the "last mile" gap from order processing to shipping. It tracks the shipping details of an order by partnering with major US shipping and logistics services providers like UPS, FedEx etc. It is also connected to various e-commerce websites like Volusion, Amazon, BigCommerce etc.


Shopping Cart Application driven by FileMaker

Client:
Software Services Provider
Industry:
Software
Technologies:
X-CART, PHP, MySql, HTML, CSS, Javascript, FileMaker

Developed a shopping cart application where x-cart is integrated with FileMaker. Here all the back-end data is managed in a FileMaker application.

All the contents of the x-cart website like products, categories, manufacturers, contacts, product images etc. are uploaded from FileMaker application to the x-cart application, so that both applications are in sync.

The x-cart application has been customized so that customers can only request for a quote, and there won't be any actual sale through the x-cart application. The product price is hidden in the x-cart application. The quote request can be added for a single product or for multiple products by adding multiple products to the shopping cart.

All the quote requests along with the customer info can be fetched into the FileMaker application by hitting a fetch button.

Also a predictive search functionality has been integrated in the x-cart application where keywords can be assigned to products by the admin and while typing to search for a product by the customers the suggested list is displayed in a drop-down menu just like google search. The product keywords are also driven by FileMaker application.


Bi-directional Synchronization via WCF services

Client:
Information Technology
Industry:
Media/Entertainment
Technologies:
FileMaker Pro/Server 13, ODBC, PHP, NuSOAP, CodeIgniter, MySQL, WCF Web Service

Designed and implemented an application that allows for bi-directional sync between FileMaker and MSSQL via WCF Web services. The application acts as a bridge for a Media house desktop application to schedule and track their campaigns, projects and assets online.

The application synchronizes data with another .NET CRM web application by talking to WCF Web Services via PHP SOAP client calls. The application is developed using PHP CodeIgniter framework and using FileMaker for the backend. We used MySQL which is used as an external data source for the FileMaker application to fetch data. Also this DB is used to record all the status logs and processed data for each service call made.


Labs and Billing for Gynaecology Specialists and Practitioners

Client:
Doctor
Industry:
Healthcare
Technologies:
ExtJS, PHP, mySQL, Stored procedures, XML, JSON, Mercurial, FileMaker

Worked on an existing practice management system in FM and implemeted a web version using ExtJS, PHP and mySQL app. Implemebted a lab wizard and related modules like embryo grading system, andrology, specimens log. The Laboratory Wizard supports a full range of IVF lab activities. This wizard helps setting up lab's embryo grading system followed by using Laboratory Wizard to track material from egg retrieval to transfer and cryopreservation. It also generates XML reports by analyzing and comparing data for a patient.

Implemented an extension to the billing module that allows the practice to submit electronic claims via Emdeon. Created the 837 (claim) format based on specifications from Emdeon for claim submission via a custom SOAP based client. Implemented parsing of 835 (ERA) and 999 (ACK) response formats which notifies the practice system about the status of payments on behalf of the claim.

Implemented a custom interface using extJS for the billing module and payer module. Also implemented interfaces for management of CPT and ICD9 codes, various report prints and other search utility tools.


POS System for Jewelry Designers

Client:
Software Product
Industry:
Jewelry
Technologies:
FileMaker Pro 13 Advanced, FileMaker Runtime for WIN and MAC, FileMaker Go 13, FileMaker PlugIns, Facebook API, PHP

This is a single file database application designed in FileMaker for Jewelry Designers to manage their parts, assembled pieces, customers, vendors, invoices, consignments and bills of material(BOM). This application helps Jewelry Designers to keep track of their inventory and pricing. This application also offers many different kind of reports and Dymo labels.

The application uses FileMaker BaseElement and 360Works ScriptMaster plugin to enhance some functionality to allow user to go beyond FileMaker limitations. This application has functionality to take Backup and Restore user data which helps many user to manage their data and upgrade to new versions of this software with ease.

This application is integrated with Facebook which allow users to share their assembled pieces directly on their Facebook profile and related pages.


Please learn more about our FileMaker expertise:
   
FileMaker programming services
   FileMaker application programming

To discuss about our services and how we could work together, please contact us on sales@mindfiresolutions.com or call 1-248-686-1424.

News & Updates

  • January 17

    DDM IT Quiz, Inspired by Mindfire, is Spreading its Wings!

  • December 16

    Santa in a different Avatar- International vacations gifted to All Mindfireans!

Let us Connect!

Related Pages

  • FileMaker Development Services
  • PHP Development Services
  • Java Development Services
  • Lasso Development Services
  • FileMaker Business Alliance

Awards and Achievements

Red Herringcolor DeloitteFast50 DB ZInnov1   Nascome  DB Stpi

This site uses cookies. We respect your privacy.copyright (c) Mindfire Solutions 2007-2018. Login