ACTMate Excel Importer for ACT! 2007 1.0
ACTMate Excel Importer for ACT! 2007 Publisher's Description
Easily import Excel data into ACT using the ACTMate Importer and control precisely how each field is updated. You can define your own Excel formulas so that input data is validated and clean before you update ACT!. The preview mode allows you to see the impact of the import before you update any values. This allows you to fine-tune the mapping rules and not accidentally overwrite any valuable data.
You can define up to 5 separate lookups to narrow in on the exact records in ACT! For example, you could start with the phone number, then check the email address, company name, etc. If an single match is found, then that record will be update. If more than one record is found, you can decide how to proceed.
Using the advanced field options, you can tailor the import to meet you exact needs. For example, you can define your own Excel formula to combine two input fields into one field. Any Excel formula can be used, including the string functions and statements. Your Excel formulas can include data from the input file and existing data in Excel. For example, you can set up a formula that references one or more ACT fields (such as state, ID/Status), and then set the source field appropriately.
Product Features- Import into Contacts, Companies and Groups
- Support for all versions of Excel
- Choose which sheet to import
- Save/Load Field mappings
- Define field-level rules:
- Only update if source value is not empty
- Only update if target value is empty
- Merge or append values with existing values
- Append values to existing values
- Custom .Net script engine for complex rules
- Handle duplicate records (ignore, update all, choose)
- Control if new records are inserted
- Create and Save detailed or summary log files that show the changes for each field
- Set Default values in fields if input value is missing
- Stamp fields with user-defined values (i.e., Set Last Results with name of the import file)
Look for Similar Items by Category
Feedback
- If you need help or have a question, contact us
- Would you like to update this product info?
- Is there any feedback you would like to provide? Click here
Popular Downloads
- Athan 4.5
- Kundli 4.5
- Hill Climb Racing 1.0
- Cool Edit Pro 2.1.3097.0
- Macromedia Flash 8 8.0
- Grand Theft Auto: Vice City 1.0
- Grand Auto Adventure 1.0
- Cheat Engine 6.8.1
- Iggle Pop 1.0
- Tom VPN 2.2.8
- Vector on PC 1.0
- Ulead Video Studio Plus 11
- Zuma Deluxe 1.0
- MKV Player 2.1.23
- Netcut 2.1.4
- Windows XP Service Pack 3 Build...
- Minecraft 1.10.2
- Horizon 2.9.0.0
- Microsoft Office 2010 Service...
- Auto-Tune Evo VST 6.0.9.2