Moving off a system
Migrating from filePro Plus
A long-established database and application development tool, on which developers built custom office systems that some firms still run. This page sets out what filePro Plus holds, what moving off it involves and where its records can go.
Where it can go
Routes from filePro Plus
Each route has a page of its own: what moves, what has no place in the destination and how the move is run.
Practice management systems
Actionstep1 of 14 kinds of record has a place
Centerbase1 of 14 kinds of record has a place
Clio Manage1 of 14 kinds of record has a place
MyCase1 of 14 kinds of record has a place
Rocket Matter1 of 14 kinds of record has a place
SimpleLaw1 of 14 kinds of record has a place
Smokeball1 of 14 kinds of record has a place
SurePoint Finance EnterpriseWhat has a place is confirmed in the analysis
Case management systems
Document management systems
Accounting and billing systems
CRM and intake systems
File storage
Box1 of 14 kinds of record has a place
DropboxWhat has a place is confirmed in the analysis
Google DriveWhat has a place is confirmed in the analysis
OneDriveWhat has a place is confirmed in the analysis
Server drivesWhat has a place is confirmed in the analysis
SharePoint1 of 14 kinds of record has a place
Sync.comWhat has a place is confirmed in the analysis
What it holds
The records filePro Plus keeps
Fourteen kinds of record matter to a move. filePro Plus keeps one of them, and thirteen could not be confirmed from its maker’s own material.
- MattersTo be confirmedDepends on the application written for the firm.
- ContactsTo be confirmedClients, other parties and referrers
- DocumentsTo be confirmedConfirmed per application; a character-based system may hold none.
- EmailsTo be confirmedEmails saved to matters or to the store
- NotesTo be confirmedFile notes, matter notes and contact notes
- CalendarTo be confirmedAppointments, court dates and deadlines
- TasksTo be confirmedTo-dos and workflow steps assigned to people
- Time and expensesTo be confirmedTime and expense entries, billed and unbilled
- BillingTo be confirmedInvoices, payments and debtor balances
- Trust moneyTo be confirmedTrust or client account ledgers and balances
- Firm accountsTo be confirmedGeneral ledger, office account and payables
- Custom fieldsYesEvery file, field and screen was defined by the application’s developer.
- TemplatesTo be confirmedOutput formats produce letters and forms; whether they are worth moving is per system.
- IntakeTo be confirmedLeads, enquiries, intake forms and pipelines
Moving off it
Leaving filePro Plus
A filePro application has often been in service for decades, and one person in the office knows its menus by heart. Moving off it means recovering a description of the data from the application itself and from whoever still supports it, then checking the extracted figures against reports the old system prints.
Find who wrote the application
The firm’s supplier is often a small developer or reseller, not fP Technologies. Where they are still trading, their knowledge of the file layouts saves a good deal of time. If not, the analysis establishes whether the definitions can be read from the application’s own design screens. The firm is asked early for any contract, manual or contact name it still has.
Each file has its own layout
A filePro application is a collection of files, each with a defined list of fields, lengths and edit types, up to 999 fields in a record. There is no single schema document unless the developer wrote one. The layouts are captured file by file and turned into a data dictionary the firm can read.
Logic sits in processing tables
Balances, ageing and totals are often worked out by processing code when a screen opens or a report runs, and are not stored. Links between files are also expressed there as lookups. The code is read to find them, and calculated figures are taken from printed reports as control totals.
Fixed-length fields
Fields are fixed in length, so names and addresses may be cut short or split across lines in ways the developer chose. Dates and money follow the edit rules set for each field. Every field type is converted by a stated rule, and a sample of converted records is read against the old screens.
The machine it runs on
Some installations run on a Unix or Linux server reached through terminal software, which the firm’s current IT provider may never have managed. The analysis records where the application and data directories are, and the firm’s IT provider is asked whether the server can stay powered until the fall-back period ends.
The system
What filePro Plus is
filePro is a database management and application development tool from fP Technologies of Ohio, sold for more than thirty years. It is a tool, not a legal product. A firm running filePro is running an application that a developer or reseller wrote with it, covering whatever that firm asked for at the time: often clients, files, billing and a diary.
The software runs on Windows, Linux and several Unix systems, traditionally through character-based screens, with fileProGI and fileProWeb offering graphical and browser front ends. An application is made of files, which are its tables, together with screens, output formats, indexes and processing tables that carry the program logic. The vendor supplies an SQL extraction tool, fPSQL, as a separate product.
- Kind
- Database or export
- Runs as
- On the firm’s server or a hosted server
- Made by
- fP Technologies
- Mainly used in
- The United States
- Also known as
- FilePro, filePro, filePro Plus, fileProGI, fileProWeb
How NewLaw runs it
Four steps, in this order.
Nothing financial lands in the new system on most routes, which makes it repeatable: a load can be run again until it is right.
Analysis
We read what filePro Plus holds and how it is organised, then agree with you where each kind of record will sit in the new system. Anything with no place there stays behind or is archived, and you see which before the move.
Clean-up
Duplicate clients, matters and folders are merged where they can be identified, and naming is put into one format, before anything is copied. It is not always possible to find every one, so some may carry across.
Trial load
A trial is loaded into the new system and checked against filePro Plus: record and file counts, the links between records, document dates, and a sample opened by your own people. Exceptions are listed for you to decide.
Cutover
There is no financial cutover on this route. After a short freeze on changes in filePro Plus, a final pass over a weekend picks up what changed since the trial. filePro Plus is kept read only as the fall-back record.
Fixed price, agreed after the analysis. How NewLaw moves legal data
Start
Start this migration
Choose where the filePro Plus data is going, or tell us you have not decided. The first step is the analysis, and the price is fixed once it is done.
Step 1 of 5
What happens after you send it
- A free first call
We go through your answers with you and ask about anything they leave open.
- An analysis of what filePro Plus holds
What is in it, how its records link, and where each piece would sit in the new system. Anything with no place there comes across as a note or stays behind, and you see which before the move.
- A fixed price in writing
Set after the analysis, so it reflects what is in your data. You have it before any work starts.
After the move
Setting up the system you move to
A migration ends with data in a new system. Whether people can work in it on the first day depends on how that system was set up: matter types, templates, billing, permissions. NewLaw does that work as well, and each destination’s page says what its set-up involves.
Set-up, by destination
- Actionstep
- Box
- Centerbase
- Clio Manage
- Dropbox
- Filevine
- Full data export
- Gladiate
- Google Drive
- iManage Cloud
- Lawmatics
- LexWorkplace
- Litify
- Microsoft SQL Server
- MyCase
- Neos
- NetDocuments
- OneDrive
- QuickBooks Online
- Rocket Matter
- Server drives
- SharePoint
- SimpleLaw
- SmartAdvocate
- Smokeball
- Soluno
- SQLite
- SurePoint Finance Enterprise
- Sync.com
Questions
Moving off filePro Plus: what firms ask
Nobody supports our filePro system any more. Is the data recoverable?
Often, as long as the system still starts and someone can sign in. The data is on the server in the application’s files. What is confirmed in the analysis is whether the field definitions can be read from the application, and how much of the meaning can be recovered: which codes mean what, and which files are still in use.
How do we know nothing was lost in the conversion?
By comparing against the old system’s own reports. Before extraction the firm prints the reports it trusts: client list, open files, debtors, trust balances if the system holds them. After each trial load the same totals are produced from the new system. Differences are traced record by record until they are explained.
Does the old system hold our documents as well?
That depends on the application. Many character-based systems hold only data, with letters produced by merging into a word processor and saved on a server drive. If so, the documents are a separate source to be matched to the client and file numbers that come out of filePro. The analysis checks both.
Where to start
Still deciding where to move?
Choose the system before you plan the move, and see where AI fits once your data is in it.
Choose your systems
Technology stack selection
Decide which practice management system your firm runs, with the evidence and the cost beside it.
About four weeks for a firm of about 15 people. Fixed price, set after a free first call.
Move your data
Data migration
Your data is cleaned up before anything moves, then a trial load is checked against the old system.
Fixed price, agreed after the analysis.
Set up your new system
Implementation
Your new system set up around the way your firm works: configuration, document automation and training.
A small firm of 1 to 10 users typically takes 4 to 8 weeks. A mid-sized firm of 10 to 50 users takes 8 to 16 weeks.
Put AI to work
AI advisory and enablement
A small group of your people learn to use an approved AI tool on real work, under written rules.
Two to four weeks for a small first group. Fixed price, set after a free first call.
filePro Plus and the other product names and logos on this page belong to their owners and are used only to identify the systems.
Moving off filePro Plus?
Tell us what you are moving. You get a plan and a fixed price after the analysis.
We reply within one business day.