E*Type Success Stories
The following is a selection of some of the more the 40 bespoke solutions we have developed for our client over the past 23 years for both PC and Mac based users...
2011
Electronic*Type developing a server based system for a Cambridge based law firm, tracking all related case data; plaintiff, defendant, court jurisdiction, lawyers, sheriff's, court awards etc, as well as all appropriate court required forms.
[Mac & PC].
2011
Electronic*Type developed a server based system for a company selling medical diagnostic and imaging equipment throughout Europe and North America. The database is designed to track customers, products and providing a variety of quote types in multiple currencies.
[Mac].
2010 - 20011
We are developing an in house database for a property management company, tracking corporate roofing, rain leaks and damage. This solution integrated with DayLite and DayLite Server tracks projects, customers, their repairs, invoicing etc. The next phase is to integrate FileMaker Go for iPhone for onsite data transfer (including pictures) back to the office. Cutting edge.
[Mac].
2009 - 2011
Developed a server based system for an environmental company tracking (toxic) waste, transportation and disposal. This solution tracks, disposal sites, waste analysis, vehicles, trips, quoting, invoicing and reporting to the provincial authorities. Reports analyse percentile breakdowns of compounds for regulatory authorities. Extremely complex.
[Mac & PC].
2010
A doctor requested a paperless office. We devised a solution, in conjunction with DocKeep & Fujitsu using the ADF fi-6130 scanner that is able to scan multiple pages (approx. 50 pages per minute) of any (letter/legal/card size) paperwork into the patients file for instant retrieval by any doctor on the networked system. This solution provides a complete 'one stop' patient history (archiving) and patient overview.
[Mac Only].
2008 - 2010
Electronic*Type developed a series of evolving solutions for the CMA to track all customers (physicians / medical centers etc), billing, staffing and equipment / software payment schedules.
[Mac & PC]
2005
Converted an existing 5.0 database into 8.0 as an interim measure.
We then developed a new 8.5 solution able to track customers, contacts, invoicing, quoting product sold, call tracking, help desk and numerous other company related tasks. Data from the old (converted) system was imported.
[PC].
2004 - 2011
Electronic*Type developed a server based system for a doctor who wanted a paperless office. We devised a solution in conjunction with the plug-in InsideScan (developed by PowerSolutions S.R.L.), for a flatbed scanner which is able to scan any (letter/legal size) paperwork durectly into the patients file for instant retrieval by any doctor on the networked system. This system provides a complete 'one stop' patient history and overview.
[Mac Only].
2003 -2011
A server based system was developed for a podiatrist requiring a patient tracking and analysis system. The solution tracks patient (contacts) details, suppliers, insurance companies, doctors reports, quoting, ordering and invoicing. The solution provides a comprehensive patient physical analysis and overview.
[PC].
2003 - 2011
Developed an a server based system for tracking advertising jobs (projects), account manager (a/c mgr) and employee project time spent. The system reports on all aspects of income and non-income work by a variety of criteria, allowing staff to track their own work flow and a/c managers to track entire projects and costs for which they are responsible. For added security, we used the plug in SecureFM (developed by New Millennium Communications).
[Mac & PC].
2003 - 2011
Required a system for a chimney sweep operation to track homeowners and corporate clients who need chimney / heating support, critter removal, ductwork installation and the like. The solution tracks technicians visits, scheduling (calendar support), and yearly alerts. The solution also provides quoting, invoicing as well as customer lists & summaries.
[Mac & PC].
2003 - 2004
Electronic*Type in conjunction with InvisibleBridges (of Toronto) developed a web hosted Employee Awards database tracking system for a major automotive manufacturer able to calculate, evaluate and display employee points awards based upon their length of service, job, successfully completed internal training course (among other criteria). Employees are awarded points depending on their results and are able to redeem, online, various rewards, which range from rings, mugs, rally jackets, barbecues, stereo systems, cameras etc.
Fully secure, the system is able to import new data monthly and calculate new points awards and integrate and update the employees award position. Various management reports are available as are year end reports for T4 (taxable income)inclusion.
[PC].
2001
Manufacturers of pneumatic and hydraulic products and control systems an engineering company required a database to enable their sales staff to create on screen quotes, based upon the individual parts that make up any one or series of components the company sells. The system allows the user to 'build' the product and track the costs associated with the product. On completion the product cost is transferred to a quote (or invoice) which may be emailed directly to the client. An automated parts update processing system is incorporated.
In addition a CD was developed using a FileMaker Pro runtime engine for staff in the field to quote in much the same way that their office brethren.
[PC].
2001
Electronic*Type developed a server based system for major automotive manufacturer, able to track all vehicles sold throughout Canada. The system tracks Customer purchases of new vehicles which are tracked by VIN. Every time a new or a previously owned vehicle is bought, through the dealership, the sale is tracked and entered into a customer file which at month end is imported into the database. Additionally, responses from customer survey reports are also collected on a monthly basis and the data imported into the database.
This system allows the manufacturer to analyze and provide approximately 50 summarized reports, covering everything from customer satisfaction to gender analysis by model to customer preferences allowing management to define sales approaches and target specific market segments.
Monthly updates. [PC].
2001
Developed a variety of in house tracking and reporting database systems able track and summarize print jobs (from four different print servers), media & delivery costs, usage etc. Able to export a variety of data sets to 'Connected' - the in house accounting system.
[Mac & PC]
2001
In 2001 a film equiment rental company required a system for tracking all shoot rentals . The database tracks, rentals, income, outstanding with report generation.
[PC]
1999 - 2011
An office furniture installation company required a system able to track all aspects of their administrative functions. This includes customers, suppliers, quoting, invoicing, scheduling & deliveries, sales order tracking, prospective customer contacts, letters... and more. The ability to integrate with sales reps Palm devices was later added as was management need to set, track and report sales targets and attainment.
[Mac & PC].
Additionally we have provided development and support for a variety of other automotive companies, as well as numerous small and medium size businesses including: engineering, boat building, computer store point of sale, kindergarten and charities.