Custom Development Services
Newspaper Circulation Management:
This was a Helix Express database that managed a weekly newspaper's circulation, accounting, advertising reports, editoral to advertising ratio reports, etc. This system was designed for a small to mid-sized newspaper.
Sales Force Automation:
This was a Helix Express database that was used to track daily calls, follow-ups, sales paperwork, daily and weekly reports, customer data, follow-up letters, geographical prospecting, proposals, contact management, daily tasks, etc.
Catalog Publishing System:
This system was designed for a multi-billion dollar corporation that produces hundreds of catalog pages a year. The system was a combination of a series of Filemaker Pro databases that organized the client's description of the products they sold, a Cumulus database that organized their graphics and a FaceSpan User Interface that allowed the user to create QuarkXPress pages, HTML files for each item requested, HTML e-mails with selected products. When the files were placed on QuarkXPress pages they were tagged with Em Data's XTags and XCatalog so that prices could be automatically be updated at anytime directly on the page.
Advertising Tracking System:
This Helix Express database is used to keep track of ads as they flow through the production system. This tracking system was developed for small to mid-sized newspapers and magazines.
Advertising Makeup XTension:
We helped spec and test the development of an XTension designed for advertising makeup, the AdCreation Toolkit from Vision's Edge and Metro Creative Graphics.
Newspaper Production XTensions:
These XTensions were developed to aid advertising departments with their production. These functions included horizontally and vertically centering an object on a page, a dialog box to numerically position guidelines on a page, etc.
Supermarket Circular Transmission Automation:
This project involved a series of AppleScripts that automated the preparation of pages for electronic transmission to the client's printers. The scripts took the raw files and created PDFs, then transferred those files into the transmission system and prepared them for that transmission. This script automated a process that took a production person about 20 hours a week, down to a total of 15 minutes of actual work. Once the files were set up and in the system all that needed to be done was make sure the system was still operational and to confirm that the printers received the files.