fc: Data Manager - Powerful data cleansing, dedupe and audit utility

Find and remove duplications

This is one of the biggest problems you can have with data. Customers don't like receiving multiple communications but spotting the tiny differences that throw-up a duplicate is tedious and unproductive.

fc:DataManager ends this chore, kills duplicates and protects your company image. You save on postage and other overheads too!

• Eliminate duplicate entries caused by minor misspellings and data entry errors

• Find and separate potential duplicates  using multiple selection options

• Click and select function selects proper values to correct the group

• Select specific columns to de-dupe

• Quickly find duplicates and list them

• Duplicates can be deleted, saved as second record, or exported to separate file

Clean data by column, row or cell

Consistent presentation matters and that's what you get with fc:DataManager's
comprehensive data cleaning toolset.

• Data can be corrected for any incorrect group and set to any value

• Fields can be edited as found, in the grid list, or as a record

• Convert case to/from to upper case, lower case, sentence case

• Create new field from all or part of another field

• Convert data to/from different format by cell or column

Merge data

With its incredible power and speed, fc:DataManager allows you to bring data together from different files. Now you can create records that are ultra-useful and enriched with the data you really want!

• Data from several files and merged to a new file

• Match files on exact value or select from a list of fuzzy options and match on multiple fields

• Define output fields required to build a record

• Mix fields from different files

Combine files

Working with two or more files with different data structures? Want a new integrated file in a consistent format using all the data? fc:DataManager will do it fast!

• Take multiple files and combine

• Select required fields

• Concatenate records

Suppress records

When you need to cross-check your data against other lists 'gone aways', 'do not contact', and so on, this feature allows you to do so in seconds.

• Match records against predefined files

• Suppress records that are not required

• Extract customers, prospects or 'gone away' entries from a list

Identify and correct data problems

Can you always spot underlying problems with your existing data? fc:DataManager can examine files in detail to help you identify issues and correct them.

• Display number of populated fields to identify gaps in data

• See data in graph or number format  for instant analysis of any field

• Export graph or data to Microsoft paste format and use with other applications

Unwrap/Wrap records

Want to split information across several records, or bring multiple fields into one record? fc:DataManager does the job in seconds! You won't find another utility with this power, speed and flexibility.

• Unwrap/Wrap records from a common file. (Unique feature)

• Combine/Wrap fields from different records into one

• Unwrap single records containing several names or addresses to create separate records for each name or address

• Wrap multiple records containing the data you need into one record

• Select common information to go across all records

• Take information from a record and split into other records

• No complex program routines

• Enables users to insert correct data into file

Import and format data

Map and clean records as they are imported, for a file that's right first time!

• Import in delimited text format from Outlook, CRM and other applications

• Apply functions such as View, Edit, Correct, Cut/Paste, Copy/Paste, Find/Replace, Sort, Filter

• Clean records during import

• Separate first/last name, format postal/zip code, automatically add telephone number prefixes

• Map file structure manually using simple drag and drop, or allow system to define structure

• Work with any number of data files at the same time

Export data

fc:DataManager gives you the flexibility to share your cleaned data in the way that suits your business.

• Export file in text delimited or CSV format

• Select records to be exported

• Define output fields required in output file

Analyse data

fc:DataManager gives you this essential strategic view of your data at the click of a mouse, in seconds.

• Graphical display of data

• Compare columns in 'pivot' views

• Export analysed list to Microsoft® Office applications

Extra data handling power for your business!

fc:DataManager comes with a rich choice of additional features you'd normally only find in products costing hundreds of times more!

• Import and handle large data files

• Statistics module

• Case converter

• Advanced data filtering techniques

• Scheduled automatic backups

• Share data files with other users for concurrent editing

• Restrict users to specific files and fields