Menu
Home
People
Places
Arts
History
Plants & Animals
Science
Life & Culture
Technology
Reference.org
filePro
open-in-new
<h2 id="current-status">Current status</h2> <p>A Robust, Cross Platform 4GL Database Development and Management System with exciting new features. It is a perfect choice for small to medium-sized businesses who need a customizable and powerful database package. </p><p>The product no longer ships with a printed user manual; however, there is a manual available online at fpTech's website. As well, there is a single third-party full reference book available, written by the late Stuart Werner of STN<a class="footnote-ref" id="fnref:1" href="#fn:1"><sup>1</sup></a> along with a single third-party quick-reference guide written by Laura Brody (former programmer) and Ken Brody (senior programmer of filePro) "Laura's filePro Quick Reference Guide for v5.0, " . Laura and Ken Brody also published 5 issues of the "filePro Developer's Journal" <a class="footnote-ref" id="fnref:2" href="#fn:2"><sup>2</sup></a> </p><p>There are several filePro resources available online including a user maintained mailing list—for more information, visit <a href="http://lists.celestial.com/mailman/listinfo/filepro-list">http://lists.celestial.com/mailman/listinfo/filepro-list</a> </p> <h2 id="history">History</h2> 1978 Howard Wolowitz develops Electric File Clerk for the <a href="/facts/TRS-80/zNfQKxnQ">TRS-80</a> Model II. 1979 <i>The small Computer Company</i> is founded. 1980 <a href="/facts/Tandy_Corporation/QbPKovTg">Tandy Corporation</a> publishes it as <i>Profile II</i>. ???? <i>Profile II Plus</i> is released. 1983 <i>Profile 16</i> is released for the <a href="/facts/TRS-80/zNfQKxnQ">TRS-80</a> Model 16 running <a href="/facts/Xenix/G8sH08Tp">Xenix</a>. ???? <i>Profile 16 Plus</i> is released. ???? <i>filePro 16</i> and <i>filePro 16 Plus</i> are released by <i>The small Computer Company</i> for non-Tandy computers. (<i>Profile</i> was a trademark licensed by Tandy.) 1986 Version 3.0 released for both <i>filePro 16</i> and <i>filePro 16 Plus</i>. This was the last version for the non-Plus <i>filePro 16</i>. Further versions also dropped the <i>16</i> part of the name. ???? <i>filePro Plus</i> Version 4.0 released. ???? <i>The small Computer Company</i> is bought by another company (Athena Investment Group), and becomes a subsidiary of that company. Over the next years, the parent company itself changes hands several times. ???? Version 4.5 released. ???? Version 4.8 released. 1998 fPTechnologies, Inc. is founded by the filePro employees, and buys the rights to filePro. ???? Version 5.0 released. 2006 Version 5.6 released. 2009 Reorganized and renamed fP Technologies of Ohio, Inc. <h2 id="future">Future</h2> <p>While there is an fpGUI add-on for <a href="/facts/GUI/wBlQFWDP">GUI</a>-based access, filePro is still primarily character-based, which some users[<i>who?</i>] assert makes for faster and more efficient data entry. </p><p>There are several people[<i>who?</i>] who have created <a href="/facts/XML/clNgUfWk">XML</a> and <a href="/facts/SQL/UjQLJcYm">SQL</a> bridges that allow cross-communication with legacy systems. </p> <h2 id="database-features">Database Features</h2> <h3>Strengths</h3> <ul><li>Fast data lookups</li> <li>Short <a href="/facts/Learning_curve/EQvMC9lK">learning curve</a> (for programmers, user experience is software dependent).</li> <li>Data entry system allows for quick familiarity with keyboard shortcuts, and as such, typists do not have to rely on mouse acquisition</li> <li>Provides version updates and bug releases for operating systems for more than a decade<a class="footnote-ref" id="fnref:3" href="#fn:3"><sup>3</sup></a></li> <li>Ability to create PDF outputs and reports automatically. (filePro version 5.8)</li> <li>Excellent for performing data imports and data manipulation.</li> <li>Able to connect to MySQL and utilize the power of filePro to read / write / report data from MySQL data. (Linux filePro 5.7 and higher)</li> <li>Dual write capabilities. (Redundant mirror backup) (filePro 5.8.01.03)</li> <li>Data Encryption at field and table level. (filePro 5.8.00.03)</li> <li>Multi Platform - applications created on one operating system can be converted to other platforms easily. (Support for: Windows (32 and 64 Bit), SCO Openserver Unix/Unixware, Linux (32 and 64 Bit), Sun, HP-UX, IBM AIX, IBM eServer iSeries Linux and FreeBSD (64 Bit))</li> <li>26 Available Automatic Indexes with 10 Demand Index options</li> <li>Mathematical Precision - 16 Places to left. 8 places to right of decimal.</li></ul> <h3>Weaknesses</h3> <ul><li>fP SQL support is read-only<a class="footnote-ref" id="fnref:4" href="#fn:4"><sup>4</sup></a> ( fP SQL Query and Report Generator )</li> <li>Only supports 24 lines of 80 characters</li> <li>Maximum print width of 255 characters per line<a class="footnote-ref" id="fnref:5" href="#fn:5"><sup>5</sup></a></li></ul> <h2 id="trivia">Trivia</h2> <ul><li><i><a href="/facts/The_Big_Bang_Theory/xxPyPod6">The Big Bang Theory</a></i> pays homage to one of the founding partners of the small Computer Company by naming one of the characters "Howard Wolowitz". (Showrunner Bill Prady was a business partner of Wolowitz's at one time; the actual Wolowitz has appeared in a cameo on the show.)</li></ul> <h2 id="external-links">External links</h2> <ul><li><a href="http://www.fptech.com/">fPTechnologies Official Site</a></li> <li><a href="http://mailman.celestial.com/mailman/listinfo/filepro-list">filePro Developer's mailing list</a></li> <li><a href="http://www.fileprotraining.com">Training Options</a></li></ul> <h2 id="contact-information">Contact Information</h2> <p>Phone: (800) 847-4740 </p> <h2 id="references">References</h2> <ol> <li id="fn:1"><p>Werner, Stuart L. (January 1999). Stn, Inc. Presents Filepro Plus Developer's Reference: Includes Filepro Version 4.8 (3rd ed.). Stn Inc. ISBN 978-0-9660696-1-7. OL 11739050M. <a href="978-0-9660696-1-7" target="_blank">978-0-9660696-1-7</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></p></li> <li id="fn:2"><p>"Hudson Valley Computer Associates, Inc. - filePro Developer's Journal". www.hvcomputer.com. Retrieved 2024-03-06. <a href="http://www.hvcomputer.com/old/fpdj/index.html" target="_blank">http://www.hvcomputer.com/old/fpdj/index.html</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></p></li> <li id="fn:3"><p>"FP Technologies - Products - filePro Plus 5.7". Archived from the original on 2011-07-11. Retrieved 2010-01-16. <a href="https://web.archive.org/web/20110711022048/https://www.fptech.com/Products/fpplus.shtml" target="_blank">https://web.archive.org/web/20110711022048/https://www.fptech.com/Products/fpplus.shtml</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></p></li> <li id="fn:4"><p>"FP Technologies - Products - fP SQL". Archived from the original on 2011-07-11. Retrieved 2010-01-16. <a href="https://web.archive.org/web/20110711022610/https://www.fptech.com/Products/fpsql.shtml" target="_blank">https://web.archive.org/web/20110711022610/https://www.fptech.com/Products/fpsql.shtml</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></p></li> <li id="fn:5"><p>"FP Technologies - Products - filePro Plus 5.7". Archived from the original on 2011-07-11. Retrieved 2010-01-16. <a href="https://web.archive.org/web/20110711022048/https://www.fptech.com/Products/fpplus.shtml" target="_blank">https://web.archive.org/web/20110711022048/https://www.fptech.com/Products/fpplus.shtml</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></p></li> </ol>