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
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.
Application for Law Firms
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.
Application for Cap Business
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.
Application for Garment Business
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.
Migration (FM6 to FM8)
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.
Patient & Resource Scheduling
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.
Event Management System
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 Server Application in Filemaker 8.5 for Printing Industry
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.
Fire Safety Certification Management
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.
Contract Generation
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.
Publish Manager
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 Server Application for a member of the Estate
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 Server Office Management application in Filemaker 8.5
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.).
Radiology report creation and archival system
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.)
Application for Pathlogy Lab
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).
EMR software migration from FileMakerP6 to FileMakerP8
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.
Business Management System
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.
Television Show Builder
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.
Migration from FMP7 to FMP9 and MSQL Sync
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
Dermatology Management
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.
Contact Management System
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.
Yearbook Publication Management System
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.
Micro Biotest
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.
Data Collection Application
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.
Project Management System
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.
Disease Information Search
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.
Contact Management Database
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.
Media Enterprise System
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.
Request Fulfilment System for Television
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.
Chocolate Recipe Builder System
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.
Building Sales Application
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.
Recruiter System
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.
Purchase Order Management System
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.
FM Data extraction
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.
Patient's Medical Information Recording Device
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.
Contact Data Profiling Application
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.
Application for labor coach
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.
Email Campaign System
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.
Order Management System
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.
Magazine Subscribers
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.
FileMaker Pro 11 Database Tool
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.
Bakery Distribution
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.
Crate Management Software
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.
ERP - A FileMaker Solution
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.
Report Optimization
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.
FileMakerGo Project Management System
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.
Event Management
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.
Task Management System
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.
FileMaker App for Garment Business
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.
Patient Relationship Management (PRM) with Psychologist
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.
Please learn more about our FileMaker expertise:
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..
