09-01-2017 01:12 PM - edited 09-01-2017 01:15 PM
I'm a newbie trying to find out what to do next after importing contacts. I've taken a look around. Now I want to import data from Quickbooks via IIF files to create Company table records. Where do I learn how to do this, and other start-up/load activities?
09-01-2017 02:02 PM
To import into Act! you may want to convert the IIF file to a text, csv file
Open Microsoft Excel.
From the File menu, click Open
Choose the location where you saved the .IIF file.
In the file type field, choose All Files.
Select your IIF file then click Open.
Click Next > Next > Finish in the Text Import Wizard. The IIF file is now opened in Excel.
Make the necessary edits using Excel.
From the File menu, click Save As
select comma-separated values (CSV)
You will be prompted to save the IIF file again, click Don't Save.
Make a backup of databae for safety! File>backup
Go to File > Import
Type wanted is Text Seperated by Commas
Browse to your new csv file and import
Sounds like you want to import Company Records on next menu
09-05-2017 02:48 AM
Here is a link to training manuals etc -
Now to the importing, the advice of converting the files to one that ACT can import is sound but consider if you should import them as contacts and then create your companies. This means your will have the details of the person you deal with regarding invoices in your ACT database, if you import directly into companies this information will be lost.
Here is a link about managing and creating companies -
09-05-2017 10:00 AM