Projects

Mindfire has deep experience developing FileMaker desktop/server/web software applications. We describe some of these FileMaker database development project experiences below, and will be glad to share our expertise in detail with you.

You would also find these pages interesting:
   FileMaker development services
   FileMaker/PHP/Lasso web 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.

• B2B FileMaker plug-in
• Application for Law Firms
• Application for Cap Business
• Application for Garment Business
• Migration (FM6 to FM8)
• Patient & Resource Scheduling
• Event Management System
• Client Server Application in Filemaker 8.5 for Printing Industry
• Fire Safety Certification Management
• Contract Generation
• Publish Manager
• Client Server Application for a member of the Estate
• Client Server Office Management application in Filemaker 8.5
• Radiology report creation and archival system
• Application for Pathlogy Lab
• EMR software migration from FileMakerP6 to FileMakerP8
• Business Management System
• Television Show Builder
• Migration from FMP7 to FMP9 and MSQL Sync
• Dermatology Management
• Contact Management System
• Yearbook Publication Management System
• Micro Biotest
• Data Collection Application
• Project Management System
• Disease Information Search
• Contact Management Database
• Media Enterprise System
• Request Fulfilment System for Television
• Chocolate Recipe Builder System
• Building Sales Application
• Recruiter System
• Purchase Order Management System
• FM Data extraction
• Patient's Medical Information Recording Device
• Contact Data Profiling Application
• Application for labor coach
• Email Campaign System
• Order Management System
• Magazine Subscribers
• FileMaker Pro 11 Database Tool
• Bakery Distribution
• Crate Management Software
• ERP - A FileMaker Solution
• Report Optimization
• FileMakerGo Project Management System
• Event Management
• Task Management System
• FileMaker App for Garment Business
• Patient Relationship Management (PRM) with Psychologist
• Gynecology, Infertility EMR
• Event Management Database
• Point Of Sale Software
• Work Order Management Database
• Camp Management System
• FileMaker - CRM/ERP System
• Vehicle maintenance and overhaul contracts tracking system
• CRM database solution migration to Filemaker Pro 10
• FileMaker - Octink and Rep
• FileMaker - AIMS Eco System & AIMS Default System
• Job Tracking System
• FileMaker CRM
• Furniture iPad application

Client:
Distributor-Dealer system and Inventory software provider
Industry:
Furnishing
Technologies:
C++, wxWidgets, FileMaker SDK, FileMaker scripting

We developed a FileMaker plug-in which provides Electronic Data Interchange (EDI) facilities to the dealer/reseller software system extensively used in the industry. It provides facility for connecting to the FTP sites of various vendors that the dealer trades with, downloading and uploading electronic documents in the form of ANSI X12 transaction sets. Custom processing of the electronic documents is implemented for translation to and from the Dealers software system.

Client:
Lawyer Firm
Industry:
Legal Services
Technologies:
FileMaker Pro 8.5 Advanced, Plug-ins (Troi Menu control, Troi File Control, Ozium Portal Filter)

It's a powerful, configurable, predictive knowledge management system specifically designed for law firms, government lawyer offices and individual practitioners that captures and outputs the written and spoken words needed to represent any party in any jurisdiction in any area of law. It's the knowledge management system for the lawyer that uses the data captured in other cases to predict what the lawyer wants to do in the current case. The work of expressing the process of lawyering took place in one brain without the need for translation and communication between different parties trained in different disciplines.

Client:
Software solutions provider
Industry:
Textile - Apparel Clothing
Technologies:
FileMaker Pro 8.5 Advanced

This system contains the entire business process of a cap company.
Product Mgt: Varieties of cap styles available in the stores and different add-ons for the cap style are maintained in this module.
Contact Mgt: Detailed information of clients, customers, vendors, company staff, manufacturers, etc. are maintained in this module.
Sales Mgt: Cap quotations for the customers can be created in this module and then placed as an order to the cap company.
Inventory Mgt: After selling the caps, all the inventory details (such as cap availability, cost, etc.) for the particular cap is maintained in this module.
Production Mgt: This module contains all the steps to be followed during the production of a cap/order.
Payment: Payment for the order can be done via credit cards, cash, checks, etc.

Client:
Software solutions provider
Industry:
Textile - Apparel Clothing
Technologies:
FileMaker Pro 8 Advanced

This business system contains the entire business process of a Garment company having products of multiple stores.
Technologies: FileMaker
Product Mgt: Garments such as shirts, caps, etc. available in different stores and all the add-ons specifics for the above products are maintained in this module.
Contact Mgt: All the clients, customers, vendors, company staff, manufacturers, etc. detail information are maintained in this module.
Sales Mgt: Quotations for the customers can be created in this module and then placed as an order to the specific company. 
Inventory Mgt: After selling the garments the entire products purchase and availability details (such as product sold, availability, cost, etc.) are maintained in the inventory.

Client:
Estate and trust software provider
Industry:
Software Product and Services
Technologies:
FileMaker Developer 6, FileMaker Pro 8 Advanced, MetaDataMagic

This is an "Estates and Trusts Administration" software. We worked on migrating the application from FileMaker Pro 6 to FileMaker Pro 8. We used a migration tool MetaDataMagic to extract all Pre-Conversion and Post-Conversion issues related to FileMaker Pro 6 files and resolved them.

Client:
Dermatology group
Industry:
Healthcare
Technologies:
FileMaker Pro 8.5 Advanced, Plug-ins (Dacons Menu control, Dacons mail.it, S4HU_EventScript)

This application has multiple functionalities such as; calendar for scheduling, new appointment creation, change status of appointments, appointment cancellation, rescheduling, adding patients to the recall list, adding appointments to the wait list, reschedule appointments directly from recall list and wait list, resource scheduling, edit resource schedule on daily as well as monthly basis, reports generation, sending reports to email and ftp etc.

Client:
Software solutions provider
Industry:
Service provider for trade shows and events
Technologies:
FileMaker Pro 8.5 Advanced

This is an Event Marketing & Services business system which will organize different shows with its selected items either by promoter, exhibitor or Broker.  1. Product Mgt: Different items used in shows and decoration items such as table, chair, wastebasket etc. available in stores are maintained in this module.  2. Contact Mgt: All the customers, clients, exhibitor, promoter, brokers etc. detail information is maintained in this module.  3. Event Mgt: It mainly categorizes the events by company selected by the customers. In this module customer's show items have been loaded/unloaded on trucks of the route, and maintained in Inventory after return.  4. Invoicing: Once a show is organized and routed, its invoice is created with all details of the show items that were selected for organizing that particular event.

Client:
Specialized in Printing , Publishing , Travel and manufacturing Software in Filemaker 
Industry:
Software product for  print business
Technologies:
Filemaker 8.5

We developed functionality and features for a new version of the software. Features included file upload, multilevel reporting, separation of data and Interface file for security.

Client:
Client Server application in Filemaker Specialized in Public Relation Solutions
Industry:
Software product for  print business 
Technologies:
FileMaker

The Solution is developed in Filemaker 8.5. We added features like Dashboard Interface, validate certification requests of the user, functionality to validate exam requests of the user, notify the user about the reasons of rejection of his request for the exam and certification, search functionality,  audit log for all login, navigation  though the system, Custom menu for different user with different access. 

Client:
A client server solution in Filemaker specialized in developing solutions that are compliant with government regulations such as HIPAA compliance, or campaign fundraising compliance
Industry:
Public Relations
Technologies:
Filemaker 8.5.

This application specializes in tracking contracts, or prospective contracts, and then outputs different types of reports. It manages information about the contractors and contractees and their organizations. We developed features, to generate different contracts for different clients; to electronically send contracts to clients; custom menus to allow the user to use interface specific features, keep track of presentations, their locations and clients; keep track of clients and their organizations; separate data and interface files for security purpose etc.

Client:
A client server solution in Filemaker Specialized in Publishing and Printing  Software
Industry:
Publishing Industry
Technologies:
Filemaker 8.5 & IndesignCS2

Migrated the system from Filemaker 6 to filmmaker 8 and added new features to the migrated version of the application. We changed the Architecture, cleaned up the DB, removed the Table which were not required and consolidated the tables. Existing 64 Files were reduced to 1 file. We also implemented and integrated the management, advertising/subscription sales, distribution, production and editorial for magazine and newspaper publishing. It boasts full CRM with extensive reporting capability. We created a template in IndesignCS 2 to dynamically display classified advertisements, by importing an xml file generated by the FileMaker application. This xml file was generated through a script and contained all the data about classified ads like Section, Subsection, Display Image, Notes etc. To ensure that valid xml data is imported a DTD file was created.

Client:
Specializes in Printing, Publishing, Travel and Manufacturing Software in Filemaker & nbsp;
Industry:
RealEstate
Technologies:
FileMaker 8.5

The earlier version of the application was in FileMaker 6 and had 16 FileMaker files. We developed the software in FileMaker 8.5 and with one FileMaker file. Developed features were to; manage security guard shifts, book tennis court for the members of the apartment, manage visitors' car parking, file updated feature, multilevel in reporting and all the features in FileMaker 6.

Client:
Product Company specialized in office solution
Industry:
Public Relations
Technologies:
Filemaker 8.5

The application is an integrated office solution consisting  of several modules like Address, People, Correspondence, Project, Article, Order, Delivery note, Expenditure etc. The application was in Filemaker 6  and we migrated it to filemaker 8.5 and resolved all the issues produced during migration. The migration issues were analysed by MetaDataMagic (A product of New Millennium Communications Inc.).

Client:
Diagnostic  Radiology
Industry:
HealthCare
Technologies:
Filemaker 7, Dragon

The client server system we developed is a user-friendly, secure, radiology report creation and archival system that can be accessed by authorized users. The main features are Secure, Encryption of data at every step, Secure transmission of data, Retrieval of data only by authorized users, Complies with HIPAA standards (Health Insurance Portability and Accountability Act, a U.S. Law), enables radiologist to make his own reports using his own dictation codes in oral or written form, Providers' offices can do periodic searches of their  reports, e.g., twice daily, to make sure they have the reports on their patients that have been recently imaged. It can accommodate an unlimited number of institutions (imaging centers, referring providers, radiologists, institutions with prior studies, etc.)

Client:
Pathlab
Industry:
HealthCare
Technologies:
Filemaker 8, Dragon

We developed the client server application for pathological lab. The major features include barcode technology to be used to scan the paperwork allowing the case to show up in the system instead of entering the case number manually, etc. Searchable database that has the ability to search all fields, including free text. Statistical analysis of the clients, and also of the various antibodies, probes, etc. Faxing reports. The ability to incorporate a digital image in the case report, with a figure legend. Reagent and equipment purchasing and ordering log. Calling a client regarding a case from within the case (using plugin).

Client:
Heathcare Firm
Industry:
HealthCare
Technologies:
Filemaker 6, Filemaker 8, MetaDatamagic , Filemaker plugins ( Secure FM)

We migrated an Electronic Medical Record software from FileMaker 6 to FileMaker 8 and also consolidated the scripts. We used MetaDataMagic tool to generate the pre and post conversion issues and resolved them.

Client:
Software Solution Provider
Industry:
Software Product and Services
Technologies:
FileMaker 6, FileMaker 7, FileMaker 8, FileMaker 8.5, FileMaker 9,Plugins ( Mailit)

The application is a fully integrated multi-user database.  It helps to automate your business processes. We were involved in fixing bugs in FileMakerP6 and migrating the application from FileMakerP6 to FileMakerP7. In the migration process we used MetaDataMagic and FMrobot to generate pre and post conversion issues .  In phase 2 of Migration, our goal was to consolidate the migrated FileMakerP7 database application into a stable FileMaker 8 database application, retaining all similar functionality in 10 files (initially there were 64 files), consolidate the script and minimize the number of scripts and also integrate the new features of FMP8 e.g. tabbed layout, tool tips.  In phase 3 we added new features to the system and  customized the system for Industries like healthcare , International Printing, Concrete  and Tiles, Leather and Tack etc.

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Pro 9.0 Advanced, FileMaker Server 9.0 Advanced, Oracle 10i, SQL Server 2005

This system is based on building shows before they are aired live on television. It is used by the Live Television Shopping Network which runs live shows 24 hours a day, every day.  Initially the show is scheduled to air live on Television on a particular date and time. The show items, hosts and guests are decided by the planner. Once the show is planned for a date and time, it is sent to the run up system, where Supervising Producers and Associate Producers are assigned to the show to produce it. The producers do the modifications to the running sequence of the show segments. They also verify and add the required supports (B-Roll, Graphics, Audio, Stills, active/passive elements, etc.) for the show.  Once all the necessary digital/support items are gathered, the show is hand over to a Live Show Producer. The show runs live on television after reviewed by the Live Producer.

Client:
Tourism Company
Industry:
Tourism
Technologies:
FileMaker Pro 9 , ODBC , MySql

This project is to manage the clients, contract & booking of advisements in the travel directory published by the Tourism Company every year. We migrated the application from FileMaker Pro 7 to FileMaker Pro 9 by reducing the no. of layouts by using tabs and we also grouped scripts and used script parameters wherever applicable. We also minimized the use of global fields by introducing global variables and added a new functionality to sync with MYSQL by using the shadow tables of MYSQL ODBC 

Client:
Dermatology group
Industry:
Healthcare
Technologies:
FileMaker 9 Advanced, Plug-ins (Dacons Menu control, S4HU_EventScript, Troi File, e-sign)

The application was developed for Dermatology practice/clinic. It has been equipped with managing patient, insurance, patient visit, physicians and practices.  The application has a utility which allows the users to drag and drop dots to the images of the body part to record diagnosis and procedure during patient visit. It manages documents, instructions, letters, with the ability of e-signature. Other functionalities such has, mechanism to import scanned documents to the application, management of photographs are implemented with-in the application.  Application provides all information (date by date) related to patient and their visits are documented in PDF format (know as patient chart).

Moreover, the application has a functionality of interoffice email messaging in which the users can send and receive messages within the application environment. The application also has a functionality of transferring the requisitions (specimens report) to the FTP folder from where it can be picked up by the labs for processing and diagnosis.

The different PDF reports related to patients and their visits are stored in a centralized FTP folder thus making the application lightweight and the use of Internet Information Services (IIS) makes the viewing of the above PDF reports faster from within the application.

The application has auto-update functionality which automatically loads the different plug-ins required for the operation on the client machines from the server while starting the application.

Client:
Software Solutions Provider
Industry:
Non-Profit Organization
Technologies:
FileMaker Pro 9 Advanced

This is a multi-file Contact Management System developed using FileMaker Pro 9 Advanced - an application with data separation model concept used.  This system has been designed to store personal contacts and contact information, person's employment details, managing the company details in which the person works. It has the ability to group people and companies into different groups/communities. It has a module to track people and companies who have given pledge to donate and/or actual donations to the non-profit companies/organizations. It also stores events that are set up to generate money and donations for different projects, it also tracks attendee information for each event. Education module is maintained to store school, teachers, students, grants requested by teachers and scholarships applied by students. This CRM system has the feature of creating email and letter templates that can be reused and also tracks people that receive the letters and emails.

Client:
Software Solutions Provider
Industry:
Book Publications
Technologies:
FileMaker Pro 9 Advanced

This is a multi-file Yearbook Publication Management System developed using FileMaker Pro 9 Advanced with data separation model concept used. This system has been developed to be used by the publishers to manage books publishing each year. It has a repository for customers to order for the published books and the publication distribution list.

Client:
Software Solutions Provider
Industry:
Education
Technologies:
FileMaker Pro 9 Advanced

This is a multi file application with data separation model concept used. This system provides solution to the organization doing numerous studies for various sponsors (companies). System tracks information about each study on the materials maintained in the inventory, including the sponsor and the person from the sponsor who did the study, and also tracks the bunch of logging and test information used in the study.

Client:
Software Solutions Provider
Industry:
Museum
Technologies:
FileMaker Pro 9 Advanced

The Data Collection Application system was developed using FileMaker Pro 9 Advanced. It  collects demographic information for contacts of the institution. The system tracks contacts, newsletters, newsletters sent or to be sent, contact interests, and more. The system is designed for certain information to be made available through a website, including the possibility of allowing contacts to log into a website to update their own information.  The system stores contacts information, managing the company details in which the person works. This system has a feature of creating email and letter templates that can be reused and also tracks the people that receive the letters and emails. The system can groups people for a specific mailing type or interest type and can send letters/emails to only those group of people and admin can view the report to whom the letter/email has been send with its company name.  This is a multi file application with data separation model concept used.

Client:
Software Solutions Provider
Industry:
Software ISV
Technologies:
FileMaker Pro 9 Advanced

This is a Project Management System on FileMaker Pro Advanced. It uses multiple files and a data separation model concept. This system holds projects and its invoice items detail, staffs and labors working in the project and user information for that project. It has the ability to send email to all the staffs included in a project or to an individual staff. This system has been designed to store contacts information, person's employment details and to manage the company and project details in which the person works.

Industry:
HealthCare
Technologies:
FileMaker Pro 9

Disease Information Search, is a compilation of information on an existing Filemaker database on genetics and diseases. The tool provides different categories of information which it stores and maintains.

The different categories of information include:-
•People- This has all informaiton related to people in the database; people's address, organisations, events details.
•Organisation- This segment has information related to organisation; organisation's address, member list of organisation, events in which the orgnisation partcipated.
•Events- Events are very broad. This category was created so that anything that involves direct interaction with organisation members can be linked to a username.  This can be something as clear as a meeting or something more abstract like a web poll, or being registered to receive the weekly bulletin. Events have information on event details, Event activities, speakers.
•Event Activities- Activities are essentially events within events. For eg-ATCG Meeting. This meeting is made up of several activities: Content Workshop – Religion & Genetics, Quality Presentation, and Usability Presentations.
•Event Speakers- Speakers register with topics within each activity. .
•Conferences- Conferences are made up of Events. It is a just like an event, though here there are many events.
•Sponorships- Sponors are just details about Sponors who invest in events.
•Legislators- Legislatore have all contact and activity information related to United States congressmen (representatives and senators). Each Congressman (member of congress) will have his own record with associated addresses, staffers, committees, policy activities and legislative actions.

Industry:
Media
Technologies:
FileMaker Pro Version 7

This is a system developed in FileMaker Pro Version 7 that stores contact information of the members associated with the music shows to be performed. It stores detail account and contact information of the advertisers, artists, audiences, board members, contributors, grant makers, show presenters, sponsors, vendors and volunteers associated with a show. The system has the functionality of storing other contact names who are related to a member. It has the ability to allow a user to search by multiple contact/member names on individual accounts. For example user will be able to search for spouses or domestic partners individually, regardless of whether or not they share the same last name. The system has functionality to export the searched contacts to external file formats.

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Pro 10 Advanced, FileMaker Server 10 Advanced

This software is an enterprise level Project Management System designed to manage and streamline the day-to-day operations for Creative, Production and On-Air departments for Television and Radio Networks. It keeps the entire Promo Department informed, from Production Assistants to Producers and from Management to Accounting. It assists the whole staff in performing a variety of tasks and functions that keeps the production flow efficient.

The system manages all aspects of on-air programming such as adding promotional items, script management, adding music tracks to the promos, production planning, budget estimation, tape library management, music library management, session scheduling. It allows user to build premiere and episodes to air weekly or in day's interval for a show. It has user dashboard implemented which gives an overview of all the projects planning, approval of items, on-air planning, project management and project tools or documents used in the project. It has the server side emailing, reporting and printing features implemented. The software runs in real-time, supporting upto 250 simultaneous users across the company's WAN or LAN keeping the entire production team up-to-date in all aspects of production.

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Pro 9 Advanced, FileMaker Server 9 Advanced

This system is developed in FileMaker for television show production house. This system is cross platform compatible and developed to be used by both FileMaker Pro and IWP users. During the show building process there are requirements for supporting assets such as graphics, videos, animation, stills, for the show which the producer makes a request to the production house or creative department to build the asset for them.

This system keeps track of the tactics or requests made by different departments such as production, advance services, marketing, programming departments, etc. It provides a request or tactic form to the requesting departments to make a new request to other fulfilling departments. The system then redirects the requests to their respective fulfilling department managers. The managers can then assign staffs or resources to the tactic, who are going to work on the request and fulfill the requirements of the requesting department. The system has a communication portal built within it that will allow the resources and the fulfillment managers communicate with each other by sending messages and attachments on a particular tactic during the processing period which helps them. The system has user dashboard feature implemented in it which shows the lists of jobs assigned to the current user. It has an audio and visual alert on the user's dashboard if there is any new message for the user and also for a new message which comes in to user's dashboard. The resources can send message to requesting person asking for some other required detail to fulfill the request and vice versa. Once the resources finish their job, the system will automatically indicate the requesting persons or fulfilling managers that their request has been fulfilled and ask for their approval. It has the graphical chart feature implemented that draws the bar chart for the manager on the work progress of all the staffs and the staffs can see a graphical chart of their assigned tactics and their progress. The system has a section which allows Admin to manage the system configuration. It has a Contact Management module which stores all the contact details of the employees of the company. This system has the user's login via active directory groups. It has the report generation and printing the reports feature implemented for both FileMaker Pro and IWP users.

Client:
Software Development Company
Industry:
Media
Technologies:
FileMaker Pro 9 Advanced

This system is designed to be used by chocolate factory for keeping the track of  chocolate making processes. The system has cross platform usability, fonts, graphics and formats. It is designed to be used in touch screen monitors to entered extract data on a desktop workstation during the chocolate recipe building process. It is a relational database developed in FileMaker that keep track of the processes/steps followed during the building of different types of chocolate recipes with different flavors and tastes. The system uniquely identifies the beans and track how they are used.

Different Modules implemented in this application are as follows:

Inventory: This module allows new Batch entries in the inventory for different types of beans and inventory. It keeps track of relevant bean data, GPA Coordinate with Google map integration and the process control with several cut tests. It has the search functionality which allows the search for a particular batch or batches based on the user entered criteria. It has the printing functionality built which allows the users to print the inventory detail and to label printing features with barcode, the bar which is printed on each label for a batch.

LAB: This module consists of sub modules or processes which keep track of the Roasting, Liquor, Refining, Conching processes. The system keeps track of the moisture measurement, roasting temperature, and baking time, machine ID of the machine used in each roasting cycles, liquor processes, the ratio of all the ingredients added during refining process and tracks the temperature and humidity parameters and time taken by the conching processes. This system allows the lab users to maintain a checklist ofr all the above processes which the bean has under gone and print the checklists. It has the printing capability to print the Batch Processes, summary of Batch Process based on process data and characteristics of the process output.

RECIPE: This section allows building new chocolate recipes out of different ratios of samples. A new recipe can also be derived from other base recipes. It keeps track the formula of the recipes with a detailed path of origin to all beans and all measurements and specific information of all other ingredients used in a recipe.

TASTE: This is a section where the panel tasters can give ratings and comments on the prepared chocolate samples. They can fill up a feedback form on the mouth feel, experience, odor, color, appearance, smell, aspect, flavor, etc. on a chocolate sample or recipe.

CONTACTS: This is a contact management module developed in this system which stores all the organization, vendor, and company staff contact detail information.

ADMIN: This section allows administrator to add new users to the system and assign them to different roles. All the modules in this system are restricted to be accessed by users with specific roles. It has a dashboard which shows all the beans from the inventory with their Inventory status, lab stages, recipes and the taste stages added by tasters. It also shows a summary of complete path of processes a sample has followed. Also has a printing option to print labels for a sample.

Client:
Contact Data Management Service Provider
Industry:
Small/Medium Industries
Technologies:
FIleMaker Pro 10 Advanced, FileMaker Server 10 Advanced

The ALLSALES application use to manage the company, contact, projects and employee. The application is mainly developed to streamline the process, and get rid of spreadsheet usage. The application consists of following modules.

Employee Management Module : Accessible by only Super-users/admin - It stores all the employees information with the following functionalities – Employee Addition/Search, Show All and Record Navigation.

Company Management Module : Accessible by only super-users/admin - It is the master database to store the master list of companies and has the following functionalities – Add/Upload New Company, Merge Duplicate Companies, Show All, Export Companies

Contact Management Module: Accessible by only super-users/admin - It is the master database to store the master list of contacts and has following functionalities: Import Contacts, New Contact, Manage Duplicate Contacts, Show All, Export Contacts, Record Navigation

Project Tracking Module : Accessible by users having following roles: super-user/admin, manager, requestor, caller and QA. This section of the system holds each client requests as a project and track tasks related to staffs.

Super-user : The super-user can create a new project for the request made by a client by clicking the "New Project" link from the top header section on the Project Detail/List views.

The user can then import the Companies/Contacts list from an excel file given by the client for the project by clicking on an "Import Companies" or "Import Contacts" link from the top header section.

Once the project is created then the super-user will assign the project to the manager.

Following reports are available for the super admin: Caller Report, Manager & QA Team Report, Productivity Report

Manager:Once the project is assigned to the manager, it will be visible to his dashboard.Manager then can enter project related information, add researcher, caller, QA and assign tasks to them. A new functionality called Auto Assign Tasks', which enables the manager to auto-assign the tasks to caller / researchers

Researcher : When the task gets assigned to researcher, it will be visible under the project they are assigned to. Researcher will start working on the tasks, which will have a list of company assigned to them along with the target. Researcher will do web-search for contact information related to list of company assigned to them and enter into the system.

Caller : When the task gets assigned to caller, it will be visible under the project they are assigned to. Caller will start the verification process for the contacts they are assigned to. Caller will then mark the contact verified or error.

QA:When the task gets assigned to QA, it will be visible under the project they are assigned to. QA will each and every contact contacts they are assigned to. Caller will then mark the contact Approved or error.

Admin Settings / Configuration Module : Company Info: This tab is used to edit the company's information.

Employees: This tab is used to show all active employees

Custom value lists: This tab is used to edit the custom value lists used in the system.

Export: This tab has the functionalities to allow Super-user to Export Contacts by Project, Export Companies by Project, Export All Contacts, Export All Companies.

We have worked on enhancement of this project and added new functionalities such as:

1. A new user role "HR Manager" is introduced to the Salebuild application who will review the performance report.

2. The contacts will undergo Project Manager's approval once verified by caller. A portal has been developed to keep track of the contact rejection history. The rejected contacts will be reassigned to the Caller.

3. The contact will be locked for a resource once it moves to next stage of verification.

4. Different search options are provided to the users to find duplicate contacts or companies from the database by matching words or patterns and by phonetics.

5. Dynamic portal sorting has been implemented to sort the lists according to the users.

6. Integrated an email verification tool to verify contact email address.

Client:
On-line classifieds company
Industry:
HR Recruitment
Technologies:
FileMaker Pro Advanced 9

This is a contact management system developed in FileMaker Pro Advanced 9 that stores the companies, its related contacts, contact history, job orders, applicants and their detail information. We worked on the "Applicants" module to develop a feature that allows to assign candidates to different work locations with certain designations. The location and position assignment process has some validation rules to follow. For example not more than four applicants can be assigned to a particular location with a particular position. It has the flexibility of adding new other locations and positions under certain categories to the existing lists.

The system also has a cross tabular grid report to view the location and position allocation chart or applicant inventory chart based on the user selected position categories. The chart tool has pagination implemented on it. User can move back and forth between the chart pages by using next, previous arrows. This also has option to allow user to directly navigate to first and last pages of the chart views.

Client:
A Leading Logistics Company
Industry:
Logistics
Technologies:
FileMaker Pro Advanced 9/10

This is a system developed in FileMaker Pro Advanced 9/10 that keeps track of the Stores and their Purchase Orders from different Vendors. This system comprises of 3 main modules such as: Items, Vendors and Stores. The Items section stores all the items used in the system along with their detail information. There are options to add/edit/delete items from the system. The items are supplied by vendors which are maintained in Vendors section of the system. All the vendor information and their contact details are maintained in the system. The system has the functionality to add multiple vendors/suppliers for an Item and vice versa. The system has a module that keeps track of the Stores and the list of items purchased by the stores. The users can purchase/order new items for their stores using this system. The system allows the users to view the items and their prices available for different vendors and order the item from a vendor of their choice. The system has built in printing and reporting features that allows the store users to print their order reports sub summarized by the item category and order status or by vendors and send them to their franchise.

Client:
Publishing
Industry:
Publishing
Technologies:
FileMaker Pro 10 Advanced

This software is used by a publishing company which publishes and distributes magazines and books. This software allows the customers to subscribe the magazines and distributes the number of copies of the magazines to them. Customers can place their order for new subscription or renewal of magazines and do the payments in the system. The software also keeps track of yearly subscriptions and subscription offers that are valid for a time period.

Client:
Medical Devices Provider Company
Industry:
Healthcare
Technologies:
FileMaker Pro Advanced 10, Platforms: MAC and Windows

This is a cross platform runtime solution developed using FileMaker Pro 10 Advanced for both MAC and PC users. This software is developed for a marketing company that provides portable devices to record medical information (both current and past records) of an individual. The software has AutoRun feature built in for Windows version so that it will auto open the product, once the USB is plugged in to the Windows system. This product is purchased and used by individuals to maintain their medical records. The software allows to record patient personal information, emergency contact information, patient's medical history and past surgeries, medical conditions, alergies checks (if the patient has any) and immunization checks and also records medical insurance details. It has the ability to allow user to save the medical forms as PDF and take printout of the forms and send them to this company to get a quick medical advices.

Client:
Contact Data Management Service Provider
Industry:
SME
Technologies:
FileMaker Pro 10 Advanced, FileMaker Server 10 Advanced

This application is used by the sales team of a research company to discover contacts for a list of companies requested by their clients and do the contact data profiling by doing a survey with asking the contacts some pre-defined questions and answer choices set by the project managers. The application is mainly developed to streamline the process, and get rid of spreadsheet usage. The application defines the work flow of profiling process for different users based on their roles/privileges. It allows the super user to create new project for the client requests and upload a list of companies or a list of contacts with companies to the project that are provided by the client. Then the project is send to a research team by assigning a manager of the project. The manager assigns the companies to callers by creating multiple tasks and also defines a set of profiling questions and their answer choices which are to be asked by the callers while their verification process. The caller then verifies one contact per company based on the answers given by contacts and sends the verified contacts and their detail information to the manager for his approval. The manager then passes those searched contacts to the QA team to get their final approval on the contacts. Once the QA approves the contacts, the contacts will be uploaded to a master database. It also allows the managers to create a new project for contact discovery process from a profiling project and vice versa. The system has reporting capabilities to allow the higher level authorities to view the performance reports of researchers, callers, manager and QA team report and productivity report.

Client:
Software solution supporting labor coach business
Industry:
Healthcare
Technologies:
FileMaker Pro Advanced 10, Platforms: MAC OS X and Windows

This is a database tool developed to be used by the hospitals specifically for birth and postpartum doulas. This system is developed using FileMaker Pro 11 Advanced which runs on both Mac OSX and the Windows platforms.



The system comprises of several modules like: Calendar, Jobs, Clients, Resources, Service Lists and a Preference module. In Calendar module the user can view the events i.e meetings, appointments, client due dates, baby's birthday, etc. on specific dates in a monthly, weekly and daily calendar. The user can add new events to the calendar dates as well. It provides option to manage the holiday lists in the system and color code the holiday's in the calendar views with a user specified color. The user can categories the calendar events and define color codes for each categories in the user preferences so that in the calendar views the events with same category will be color coded as defined in the preference.



In Clients module the user can add/update client information in the hospital record. They can generate dynamic client list report based on user specified find criteria. User can add multiple find criteria and can dynamically change the columns in the client list according to their requirement.



The Jobs module keeps track of how much time spend with clients, the user can keep track of the work hours, birth data, immediate postpartum, postpartum charting etc. User can view the invoice reports by job number and the payments received for the job in this module. It has option to find jobs by job number and client name.



It has a section to manage the vendor and /or resource information. It has a section that allows the user to add goods or services to offer the clients. Once entered, invoices can be created with these items in the invoices module. In Invoices module, invoices can be created for clients by adding the invoice details and line items.

Client:
Tourism Service
Industry:
Tourism
Technologies:
FileMaker Pro Advanced 10, FileMaker Server Advanced 10

This system has been developed in FileMaker for a travel agency to allow them to create email templates which are to be used for their campaigning by sending a series of HTML formatted emails to a list of customers in the mailing list inviting them to look at or book travel offers. The system has an ability to allow users of this software to create and save several email templates with HTML formatted text as body content in the database. User can add dynamic tags to the email body which will be evaluated at the runtime when the email will be send to the customers. The user can also save one or more attachments to the email templates. This system has an admin panel where the user can set up the SMTP server information for outgoing emails.



It has a "Contact Management" module where the user can manage its customers list in the database. It provides the ability to search for a list of customers in the mailing list based on user entered search criteria and choose an email template from the available list of templates and send them to the customers filtered list. The system has a section where user can schedule/setup the follow up e-mails to be sent out to the customers after a certain period of days if they have not responded to the first/original email. It has an automation process to frequently send the follow up e-mails to the customers at the defined interval.

Industry:
Data Collection
Technologies:
FileMaker Pro 10, FileMaker Server Advanced 10, 360 Works SuperContainer, 360 Works ScriptMaster, 360 Works Email plug-in

This software is developed to be used as an Order Management System. The application is developed in FileMaker technology and 3rd party plug-ins are integrated with the solution to accomplish certain tasks inorder to meet the business requirement.



This system keeps track of the orders that comes in to the company from its clients and manages the order processing steps. It includes the processes starting from order import, vendor assignment, order documents received from vendors, examining the order documents and approval/disapproval of orders, send final order documents to data entry staffs, send final order pdfs to clients after completion by data entry staff.



The system is accessed by 4 different type of users such as: Admin, Manager, QA and Data Entry staff.



i)User Management Module: The system has a section where the Admin can manage the user privileges.



ii)Vendor Management Module: The system has a vendor management section where the inhouse/external vendors along with their fees and turn-around time for different states and counties are stored. The administrator can set the default vendor for a state or county or state & county.



iii)Order Management Module: The order management system is divided into 6 segments.



Import Order Process: The system provides functionality to allow the managers to import the list of orders from an excel sheet received from their clients into the order management solution.



Vendor Assignment Process: Once the orders are imported to the system the manager can assign the orders to their inhouse staffs to work on those orders or can also send out the orders to external vendors or contractors to fulfill the orders for their clients. The vendor assignment process allows the managers to see the vendor fees and turn-time available for a state/county and select a vendor to assign him to a group of selected orders at a time. The manager can assign the orders to the default vendors of their state/county. It provides the flexibility of re-assigning inhouse orders to the external vendors if they are not fulfilled by inhouse staffs. The system has automated email send functionality built-in to send email alerts to the vendors as soon as they are assigned to new orders.



Document Receiving Process: The vendors work on the orders and email the order related documents back to the manager. As automated server side script has been developed in this system which runs at a certain frequency reads the emails received from the vendors from a specified mailbox and downloads the attachments to the FileMaker application and attach them to the appropriate orders. The documents received from vendors are physically stored in a server path using 360 SuperContainer plug-in and a reference to those documents are maintained in the FileMaker application. The user can also manually upload documents to the FileMaker application and attach them to an order.



Examine Process: In this section it allows the quality analyst to open and view the vendor documents (PDF) in a viewer window inside FileMaker application. The QA person can download the PDF from FileMaker application to local filesystem,  highlight the pdf and upload the updated pdf as a new version to the FileMaker application for the order. The system allows QA to approve an order and send the order with finalized documents to data entry staffs or reject an order and send an email to vendor asking him for new documents.



Data Entry Process: In this process system allows the data entry staff to open and view the PDF finalized by QA in a viewer panel inside the application and fill up different types of order forms.



Client Delivery Process: Once the data entry job is finished the system allows the manager to print all the order forms in a single PDF and email the PDF with order forms and all the vendor documents to the clients directly from the application. The system provides a window to the manager to compose the email for the client.



Admin Settings: There is a section in the application where the admin can configure the SMTP server for outgoing emails, configure the mailbox from where the incoming vendor emails can be read. The admin can design email templates for all the types of emails that are send out from the application. In this section all the external tools settings are also done.

Client:
Publishing
Industry:
Publishing
Technologies:
FileMaker Pro 10 Advanced

This software is used by a publishing company that publishes and distributes magazines. This software is used to subscribe customers to the magazines and distributes number of copies of the magazines to them. It is used to manage the existing and new customers and their subscription details. It keeps track of the orders placed by the customers for new subscription or renewal of magazines and the payments done by the customers. The software also keeps track of yearly subscriptions and subscription offers that are valid for a time period. It has export records functionality implemented in the system to allow users to export sub set of records from database to an excel format file by using several filters. Mindfire has developed a "User Management" module in the system that offers an admin ability to manage (add/edit/delete) user accounts with their privileges in the system. Mindfire has developed a "Mail Merge" module in the system that offers the ability to the users of this system to compose several letter and form templates with dynamic tag insertion to the letter content. The users can choose a letter template and take printouts of the same letter for multiple customers or subscribers at a time. In the letter printouts the dynamic tags used in the letters are replaced with the actual values with context of each customers to whom the letter will be sent to. Advanced search options are provided in the system to filter the dynamic list of subscribers based on different search criteria. Mindfire has developed a web solution of the database using FileMaker IWP that allows the subscribers to access their own subscription data online.

Client:
Neurogenetics Laboratory
Industry:
Healthcare
Technologies:
FileMaker Pro Advanced 10/11, FileMaker Server 11, Platforms: MAC OS X and Windows

This is a database tool developed to be used by a Neurogenetics Laboratory to maintain their patient records. Previously the client was using excel spreadsheets to maintain the patient data which was difficult to manage and keep track of all the patient history records. Mindfire developed a database solution using FileMaker Pro 11 Advanced for the client which provided them a multi user accessibility with all the functionalities that they were able to do in excel.

This system has been developed using FileMaker Pro 11 Advanced which runs on both Mac OSX and the Windows platforms. It is a multi-user system with a UI designed much similar to a spreadsheet. It has the feature built in to allow users to import data from an excel file to the FileMaker application along with the rows and columns background and foreground formatting. It allows the user to insert a new row at any position of the list, edit the row data directly on the same list view and user can delete a row from any positions without affecting the other existing rows. All these above functionality works similar to excel. The user has the ability to re-arrange the row orders by moving a row directly above/below any specified row without affecting the order of existing rows. It provides the functionality to change the background color of row(s) and column(s) by choosing a color from a color picker. The user can also set conditional formatting on the columns to automatically change the background color and font style of the cell based on a user defined criteria. The system also has the ability to generate barcode for the rows based on the user customized formula set for the rows. It also allows users to export selected rows data from the FileMaker application to excel format file.

360 Works ScriptMaster plug-in has been integrated with FileMaker application to provide the ability to choose colors from a java driven color picker tool and generate the barcode.

Client:
Software Solutions Provider
Industry:
Small and Medium Industries
Technologies:
Filemaker Pro Advanced 11

The application is a fully integrated multi-user database. It helps to automate a Bakery business processes.

We created an unique worksheet for each day of the week for each customer account and automated the process. There are Standard customers whose orders are generally the same for each day of the week; any variation in their order for a given day is called or faxed to the Client. Otherwise, there's a set order for the Standard customer. About 75% of Client's customers are Special Order customers. Orders from each individual Special Order customer and changes from Standard customers are entered into the application as they come in, by an employee who goes into the application, pulls up that customer's individual worksheet for that particular day and enters the order. The application then generates and prints out a group of reports' in a date range format that literally are: The orders that will be placed with each one of Client's suppliers, a report for each of the nine route drivers telling them exactly what products they'll be picking up from each supplier that day and invoices for each driver that will be delivered to each customer with their order.

The application is able to generate any report that Client's management needs. The System currently provides them with a Weekly Vendor Report that tells what they are going to be billed by there vendors – before they bill them. They also generate a Collection Totals Report that tells them how much is due in receivables by customer, by delivery route, by any date range or any other way they want to sort the data. Each driver is given a Daily Collection Sheet Report that tells the driver what amount is due from any given customer owes in addition to the invoice due for that day; some customers are delivered to on a COD basis. The Daily Sales Report/Profit Margin Report gives them a look at the percentages by any date range they choose, by customer or by route. They get a Bagel report to tell them how many Bagels are needed on any day. They get a Production Report to be sent to the Vendor for productions of the products as per the ship-date entered.

Client:
Software Service Provider
Industry:
Crates
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11

This application manages crate design, quote, production and delivery. We have worked on some of the sections to enhance the functionalities, such as common graphics storage and comment repository, data import/export, reports, presentation, multi-lingual feature and help menu.

Client:
Retailer
Industry:
Retail
Technologies:
FileMaker Pro Advanced 9/10/11, FileMaker Server 11

This is a database system developed using FileMaker technology which runs on both Mac OSX and the Windows platforms. This software consists of several different modules. It has a Customer Relationship Management module, products and inventory management, sales order management, job tracking and task management module, invoicing and payment modules. It also has a system preferences section where admin user can manage the different settings for the application. The system also provides multi lingual feature, the user can choose their language preference (English/French) in the system. The system has seedcode calendar (daily, weekly and monthly) views implemented in it to add/edit/view appointment schedules. The calendar module also has the ability to create recurring events. The system also has the serverside script ability to integrate the FileMaker application data with PHP iCal website. It also has a server side script ability to import and export the invoice and payment data to an external Accounting module. The system has the diffrente kinds reporting functionality built in with the ability to print and export report data to external file format.

Client:
Software Service Provider
Industry:
Advisory Services
Technologies:
FileMaker Pro Advanced 10/11, FileMaker Server 11

This is an existing database solution developed in FileMaker Pro 11 Advanced on which Mindfire's FileMaker team worked on optimizing different types of reports used in the database. The system has the ability to run several kinds of reports on the data present in the database. Mainly the data shown in the reports are summary results grouped by different fields. Which was taking a very long time to load the entire report screen resulting a severe performance issue. Mindfire has optimized all the reports effectively to speed up the performance up to 96% to 98%. We have also enhanced the reporting tool in the system to allow users to generate yearly summarized reports for different modules.

  We have also done a database migration job for the same client. We have merged a multi-file FileMaker database system to a single database system in FileMaker Pro 11 Advanced with following proper FileMaker coding conventions and Anchor Buoy system for the relationship graph.

Client:
Software Service Provider
Industry:
Small/Medium Industries
Technologies:
FMGO, FileMaker Pro 11 Advanced

Designed a product to run in FileMakerGo in iPhone for client's existing product in FileMakerPro. We have designed all GUI and rebuild all functionalities to work well in iPhone. Now the solutions font looks good in iPhone and screen fits to iPhone. Here the products presentation style is different than its previous FileMakerPro application but functionalities are same in FMGo iPhone application.

Client:
Software Service Provider
Industry:
Small/Medium Industries
Technologies:
FileMaker Pro 11 Advanced

Implemented repeat events functionality in the existing system by daily/weekly/monthly/yearly. It will duplicate the event and create repeat events based on the daily/weekly/monthly/yearly.

In daily repetition user has to give the no. of days interval and stop on date or stop after some repeat repetition.

In weekly repetition user has to choose weekdays and interval of week with stop on date or stop after some repetition.

In monthly repetition user has to choose month names and interval with stop on date or stop after some repetition.

In yearly repetition user has to choose the month names and interval between years with stop on date or stop after some repetition.

Client:
Software Service Provider
Industry:
Small/Medium Industries
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server11

Integrated SeedCodeCalendar to Client's existing system to show the tasks in calendar grid by its task date. Modified all table occurrences of SeedCodeCalendar's Event table to Client's Task table. Modified the filter options in calendar grid. Modified all Contact, Projects detail in Calendar to show related contact and projects for that task. Implemented Zulu Calender in this application so that we can manipulate FileMaker calendar records from iCal.

Client:
Garment Showrooms
Industry:
Garment
Technologies:
FileMaker 11 Pro Advanced, FileMaker Server 11

This is a single file database solution developed in FileMaker 11 Pro Advanced. The system is used to keep track of the items in the inventory for several different garment stores or showrooms. The system manages different showrooms, the items or garments available for several different brands at the showrooms, the showroom items that are lend out by the clients, when the items are returned to the showrooms, creating invoices for the clients, etc.

The system allows the user to manage the relationship between Client, Showroom, Brands and Items. It provides the user to add/edit/delete the lendouts to the clients, add the delivery cost for the lendout items and also update the showroom inventory when the items are returned to the showroom. In this system the user can add expenses to the clients for different brand and currency. The system also allows to create new invoice to the client for all the unprocessed delivery costs and expenses added to the client. The system has the ability to keep track of different types of clients such as a client can be media, contact person, freelance, vip and incrowd. The client's lendout and invoice history are also recorded in the system which can be viewed later. The system has the admin ability to manage all the value lists used in the system, countries, types of currencies and their exchange rate, showrooms, items under brands, printing the labels, manage users of the system, etc.

The system has a built in admin ability to create/edit the e-mail templates to be send as reminder e-mails to the overdue lendouts on the showrooms.

There is a module developed in the system which give the user ability to do Media Analysis. In this section the user can register the press clippings that they get from the different magazines or on the web. The clips can be any type of image format files, pdf or small .mov files. While importing the clips to the database the system also pulls the information regarding the media from the media base.

Client:
Healthcare
Industry:
Healthcare
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server11

This system is developed to be used as a Patient Relationship Management (PRM) dealing with a psychology call-center that works exclusively with a military population. Using PRM software applications, psychologist can move beyond treating episodes of illness to enabling proactive care by establishing productive, long-term relationships with patients. Psychologist will fill all patient general info with reason for calling with symptoms. Then Psychologist will study the case, to find what are the diagnosis and problematic for the phenomenon and starts treatment for that patient and patient can call the Psychologist no. of times, here psychologist will find the unique patient based on the unique phone no. Psychologist and his chief can view patient reports by weekly/monthly/random date selection, then the system will show reports in chart formats, so it will be easy for Psychologist or his Chief to find no. of Patients for different reaction, priority, diagnosis, problematic, phone call made by one patient for how many times etc.

Client:
Healthcare Service
Industry:
Healthcare
Technologies:
Filemaker 11, MySQL, PHP

The application mainly caters the need of a gynecology practice helping patients deal with infertility and other gynecology related problems. It creates and coordinates ART (Assisted Reproductive Techniques) treatment calendars, prescriptions for patients with infertility complications. The system monitors the day-by-day progress of the patients undergoing reproductive treatment using cycle sheets and digital progress notes. Doctors constantly monitor the proceedings throughout the embryo retrieval to embryo transfer process. The system offers flexibility is maintaining and managing office and patient documents of a gynecology practice. Additional features include managing and maintaining the laboratory operations, online registration of patients and their treatment details to SART (US Govt. central database) etc. An iPhone and iPad version of the application has been developed to help doctors monitor their practice operations while outside office.

Client:
Software Service Provider
Industry:
Event Management
Technologies:
FileMaker 11 Pro Advanced, FileMaker Server 11

This is an Event Management database application developed for a small event organizer company ruled by a famous French magician. The database application is developed in FileMaker Pro 11 Adv.

The system is used to manage events before the contract is signed until invoices are recovered and real margin is measured. 

The system keeps track of all the events along with their estimated budget details and the real costs of the event and the margin. It also keeps track of the artist; technicians and suppliers associated with the event and also track their rate, budgeted cost and actual cost. The system also manages the detail information of all the contacts and suppliers and also tracks all the actions and activities such as e-mails, fax, telephone calls, etc. done with the event personnel. All the documents related to events, contacts, and companies or attached to any actions are tracked in the database and ties to respective records. 

The system provides a user dashboard ability to get an overview of the events and the upcoming actions to be done by the user.

Client:
Serial Entrepreneur
Industry:

Technologies:
FileMaker Pro 10 Advanced, FileMaker Server 10 Advanced, Platforms: MAC OS X and Windows

This system is developed to be used as a point of sale software in the beauty parlors by their customers, professional, store supervisors and the store owners. This system is developed using FileMaker Pro 10 Advanced providing client server architecture. The system is developed to be opened in Kiosk mode with touch screen interface. The application is both MAC OS X and the Windows compatible. 

The system provides high security to the data accessing depending on the access privilege of the users of this system. It is accessed by 5 different user roles such as: customers, professionals, store managers, store supervisors, store owners and administrator. It provides a highly secured login interface for the user to restrict user to log in to their store only and access the functionalities based on their privileges. The admin has the ability to add new owners with their detail information and register new stores for the owners in the database. Each store is assigned to a supervisor and the owner can add new staffs and managers to his stores. As the application is used by several different stores, it has the ability to auto login to the current store when the application is opened in a store. When the customers come in to the store they can sign in themselves by punching in their name and phone numbers and add themselves to the store queue. The store professional will then serve the customers in the queue one by one. The system has the ability to keep track of all the steps starting from customers sign in process, services given to them and payment process. The store staffs can punch their timecards in and out using this system. The system has a payroll system where store owner can define the payroll structure of their staffs and generate the payroll of a staff based on the total work hours tracked by the system. The system provides and interfaces to the admin, owners and supervisors to view their live store cameras and their customer queues from outside the store via web. The system provides daily, weekly and monthly calendar views to the manager so that they can view their store's staff schedules and add new schedules on a day. The staffs can also view their own schedules on calendar views. It has a web component for the web visitors where they can find the stores by location and view the store schedules on calendars. The system provides an inventory management module where the supervisor and manager of a store can keep track of the stocks in their store inventory and manage the stocks. If necessary the managers can notify the store owner if there is any item to be ordered by the owners. The system allows the owners to place purchase orders for their stores using this system and do the payment for the orders via PayPal. The system dynamically deducts the available stocks from the inventory as soon as an item is used in a customer's service. The system also provides a panel where the store owner and admin can add/edit/delete services in a store and adds special offers for the stores. The admin has an option to compose the templates for payment received emails, coupon reminder emails, and many other emails that are sent out from the system.

Client:
Product & Services
Industry:
Electrical
Technologies:
FileMaker Pro 11 Advanced, FileMaker Go

This is a Work Order Management database application developed for a company to manage their work orders for different customers. The database application is developed in FileMaker Pro 11 Adv and FileMaker Go for iPad. The system is used to keep track of work orders generated for the customers. Client Company provides different items to the customers and engaged one or more technicians with helper/associate technicians for any work orders. The system also has modules to manage the item and technician databases. The application provides an user friendly interface to add different items with quantity and prices, involving technician(s) with helper(s) for generating any work order. The application also keeps track of respective pricing details of each work order and wages calculation of technicians and helpers effectively. Digital signature capture ability is introduced in the application by which customers can able to capture their digital signature for each work order through iPad or through MAC system. The system also provides dynamic work order search option based on any customer with both detail view and list view. The application has print option to print any well designed work order report and also send the same report as PDF version to any technicians.

Client:
Camp organizers
Industry:
Event Management
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11

This is a FileMaker solution developed for the client to help them organizing and managing the Camps for their clients. Data separation model has been implemented in this application which adds easy maintainability to solution and also increases the security of the application. The application runs on a client-server architecture with multi-user access and user access restriction ability. The application has simple light weight and user friendly UI layout designed within it. The application provides interfaces to track and manage the clients and their in database, manage camps for the clients, manage the camp dates, process and program the camps, assign resources to the camps. There are interfaces designed to manage the resource 'To-do' list and manage the camp cost and billing. The client and camp history are tracked in the FileMaker application for any reference. The application has an admin console implemented where the admin user can manage the Staffs and control their access to the system by assigning them certain privileges/roles. The admin can able to add as many user roles as they want and define the areas and functionalities that are to be accessible by a user role dynamically. When the user logs in to the system the navigation menus, modules and functionalities are restricted as per the user's role/privilege defined by admin. The application provides letter and email campaigning ability, which allows the users to send campaigns/bulk emails to their clients periodically from one place in the system. The admin console provides the ability to compose the email and letter/envelop templates with the option to add merge dynamic tags which can be send out by staffs in the front end to multiple clients. The staff can use any predefined template and edit it at the runtime, add recipient list and send the campaign.

Client:
Solar systems design and installers
Industry:
Solar Technologies
Technologies:
FileMaker Pro 11 Advanced, FileMaker Server 11

This is a CRM/ERP system developed in FileMaker 11 to be used by a company that installs solar equipment at their client locations. This system has been developed to increase the efficiency and reduce costs in what is rapidly becoming a dynamic, volatile and exciting market. The system has following modules built into it. Such as: Lead Management, Quoting, Residential Account Management, Jobs, Lead Origins, Sales Dashboard, Scheduling Dashboard, Email Template etc.

Lead Management: This section is used to organize leads into categories, assign them to consultants and log contact history, appointment schedules, related quotes and jobs accounts.

Quotes:  This section keeps track of the lead quotes and converts them into Jobs and Accounts.

Account Management:  Here the company records the residential client details, link the account to multiple jobs to Accounts and log contact history.

Jobs:  All the quotes converted to job are tracked in this section. The jobs can any one of the following 4 types such as: Solar PV Installs, Solar PV Upgrades, and Solar Hot Water Systems.

Account Origin: Manage basic lead source information and assign leads and accounts to these records. Also manage referrals.

Sales Dashboard:  Here the overview of leads and sales related to sales representative/consultants are displayed. This is used as a user dashboard in the system.

Scheduling Dashboard:  This is a section which provides an easy portal for Schedulers to manage the installs jobs.

User Management: This place is accessed by admin only where the admin can add/edit the system users.

Administration: This is specifically accessed by the admin user where s/he can manage the product details, rebate and discount available geographic location wise, managing email templates for all types of outgoing emails from the system and also can do the other global settings applicable to the system.

Client:
Software Service Provider
Industry:
Automobile
Technologies:
FileMaker, PHP 5, jQuery Mobile framework

This PHP based web application is a front-end design of existing Filemaker Application with the purpose of improving speed, more user friendly, Add some extra features like PDF/excel export , upload images/video files to amazon server etc.

The Application starts with a login page where users authenticated through the FileMaker user Account details. After the successful login the user navigated to the dashboard page. The user can able to see all the records associated to that particular account. There is a search form using which some specific records can be found. Also user can search with multiple data by selecting more than one value from the dropdown list. An image search feature search all images associated with the input title. After search if the user wants to export the data then he/she can export all the search data to either PDF or excel format.

There is an Add Tag icon which takes the user (Inspectors) to create a new work order page. In the new work order page all the information of Car Defects are specified with the Contract name to whom the repair work is assigned. The users also can upload some images as well as videos to describe the defect more specifically. Upon submitting the work order a new Work order created in the FileMaker database, all the image/video files uploaded to the Amazon web server and emails are sent to the Admin as well as Contract email account.The contractor can find the details URL of the newly created work order through the email.

An Edit Work order page is there if the user (inspector) wants to change some data or need to upload images/video file later. Same way the Contractor can change the status, repair date etc. of the Car Defect details. Only after adding a work order the contractor can accept or reject it. All the users associated to that Contract can find the changed status of work order though the email. Also the contractor can check the images and can play the video files added for that particular Work Order.

Mobile Version:
A mobile version (for iPhone, iPad, Android Mobiles) of the above application created for the users with login and Add work order functionality using jQuery Mobile.

Client:
Software Service Provider
Industry:
SMB
Technologies:
FileMaker 10 Pro Advanced, FileMaker Server 10, Platforms: Windows, MAC OS X

The project is a multi-file CRM solution developed in FileMaker 6 and we have migrated the complete solution to FileMaker Pro 10 with fixing all the conversion issues in the new upgraded solution. We have consolidated the navigation menus present in all the different files layouts to a common hierarchical navigation menu bar window to appear always on the left side. We have also worked on restricting the Navigation menu items based on the logged-in user's role/privilege. Customized the headers of all the layouts to show all the title information and the action buttons. In this solution we have integrated the Active Directory login authentication in the whole application.

Client:
Software Service provider
Industry:
Oil and Gas Industry
Technologies:
FileMaker 11

This is an existing database solution developed in FileMaker Pro 11 Advanced on which Mindfire's FileMaker team worked on optimizing different types of reports used in the database. The system has the ability to run several kinds of reports on the data present in the database. Mainly the data shown in the reports are summary results grouped by different fields. This was taking a very long time to load the entire report screen, as a result severe performance issue has occurred. Mindfire has optimized all the reports effectively to speed up the performance up to 96% to 98%. We have also enhanced the reporting tool in the system to allow users to generate yearly summarized reports for different modules.

We have also worked on providing a feature to set user preference, ability to add new company and add it to several groups. Designed a place to see the company report status overview at a glance and provided a new area in the system to maintain the to-do checklist. We have designed several custom reports based on the template given by the client.

Client:
Software Service Provider
Industry:
Software ISV
Technologies:
FileMaker 11

This is a small CRM project developed in FileMaker. We have worked on few areas to design find screens, list views, navigation etc. functionality in the application. We have also developed a Task Management' system in FileMaker for client's internal use for his projects.

Client:
Software Service Provider
Industry:
Software ISV
Technologies:
FileMaker 11 Pro Advanced, FileMaker Server 11, Platforms: Windows and MAC OS X

This is a database system developed in FileMaker 11, which is used by a company to track their contracts and the detail information on all the contracts. The system keeps track of the contracts as new job by auto assigning a job number to it. It also tracks of the 3rd party contractor's information on the jobs. The user can add change orders to a job with the amount to be added or deducted from the total contract amount. The system provides ability to create invoice(s) for a job and also allows user to manage balance sheet against each job by tracking the total invoices generated for a job and total amount receivable from customer's payment till date. The user can also view/print the total change orders made on a job. Similarly user can also view/print all the invoices created for a particular job and also can print the balance sheet for the job. The system provides several reporting abilities based on different search criteria on jobs, change orders, invoices and account receivables.
 
The system has an address Book section where all the contractors and other client's records are maintained. The system has a user management module where the administrator can manage all the users of this system.

Client:
Printing Service
Industry:
Publishing
Technologies:
FileMaker 11 Pro Advanced, FileMaker Server 11, Platforms: Windows and MAC OS X

This is a system that is used by a company dealing with printing industries. The system keeps track of all the printers/vendors that the company deals with along with the printer address. The system allows the user to create new quotes or orders for their customers order and add the job specification for the customer's order from a set of pre available specs templates managed in a separate area in this application. After importing the spec template to a job user then modifies the spec details according to the job requirement. We have worked on a set of features like allowing the user to create and send quote request to the vendors that are appropriate for this order. After receiving the vendor bids the user can create customer bids and send them for customer's pricing approval. Once a vendor's pricing is approved by customer, the system will create/send a purchase order to the winning vendor. All the different forms and print screens have been developed for all the above described work flow.

Client:
iOS developments
Industry:
Service
Technologies:
FileMaker Pro 12 Adv. and FileMaker Go 12 for iPad

This is a prototype developed in FileMaker 12 for a demo purpose which is being used by iPad users using FileMaker Go 12. This application is designed completely for iPads, it has iOS style look and feel. The application has a gallery screen which shows the dynamic list view of thumbnails of the product images 6 thumbnails per row. The number of rows in this gallery grows as the number of product images added to the database. It has the ability to sort the gallery view by a selected category. Tapping on a thumbnail will show a full view of the image and tapping again on the full view image will show the detail view of the product. In product detail view it shows a medium size image of the product, product detail information and the product pricing in a spreadsheet like view. In the product full view and detail info view screens it has several icons in a customer designed menu bar. It has a List View' menu icon that pulls down a quick view product list with thumbnails, the menu provides ability to search a product in the list by typing on a search box. It searches the list as soon as the user types in. The menu lists are shown using FileMaker portal with zero scrollbar. The user can finger tap on the list and move the finger up/down to scroll through the list. The system is developed for multiuser environment. The application layouts are designed such that it gives a look and feel of iOS application with taking the application performance into account. The layouts are designed to fit properly into the horizontal and vertical orientations of iPad.

Please learn more about our FileMaker expertise:
   FileMaker development services
   FileMaker/PHP/Lasso web development
Mindfire is a FileMaker Business Alliance (FBA) partners alliance.

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