DejaOffice PC CRM - Importing and Exporting Tables

From CompanionLink Support
Jump to: navigation, search

You can easily Export any table in DejaOffice PC CRM to\from a CSV file or using Copy\Paste in the Grid View. For Import check the bottom of this page.

For a Video Guide to Importing and Exporting in DejaOffice PC CRM Click Here.

Exporting to Excel using Copy and Paste

Dpccopypaste2.png
  1. Open DejaOffice PC CRM.
  2. Select the table you want to Export. (Contacts, Calendar, Tasks, or Memos)
  3. In the top toolbar select 3 bars on the right and change the view to Grid. (Calendar Day View will change to List first, repeat this once more to change to Grid).
  4. Select the record or records you want to export. (You can select a record, then hold Shift on the keyboard, and select a lower record to select all records between your clicks).
  5. Open a blank Excel and Paste.







Exporting to a CSV

Dpcexport31111.jpg
  1. Open DejaOffice PC CRM.
  2. Select the table you want to Export. (Contacts, Calendar, Tasks, or Memos)
  3. In the top toolbar select 3 bars on the right and change the view to Grid. (Calendar Day View will change to List first, repeat this once more to change to Grid).
  4. Select the Export Icon on the toolbar.
  5. Select your destination folder for Export.













Importing from a File

When importing from a CSV file to DejaOffice PC CRM, to import correctly you will need to modify your current CSV to match the columns DPC uses.

  1. Click Here for an Excel Contacts Template with these columns preset.
  2. Click Here for an Excel Calendar Template with these columns preset.
  3. Click Here for an Excel Tasks Template with these columns preset.
  4. Click Here for an Excel Memos Template with these columns preset.



Once your formatting is correct in your CSV file, use the following steps to Import into DejaOffice PC CRM:

  1. Open DejaOffice PC CRM.
  2. Select the table you want to Import to.
  3. In the top toolbar select 3 bars on the right and change the view to Grid. (Calendar Day View will change to List first, repeat this once more to change to Grid).
  4. Select the Import icon on the toolbar.
  5. Navigate to your newly formatted CSV file and select it to Import.


Importing from a CamCard CSV File

  1. Open DejaOffice PC CRM.
  2. Select the Contacts.
  3. In the top toolbar select 3 bars on the right and change the view to Grid.
  4. Select the Import icon on the toolbar.
  5. Navigate to your CamCard CSV file and select it to Import.


Importing Expense from DejaOffice on Android

  1. Open DejaOffice, select Expense, tap the 3 dots in the top right and select Export.
  2. Send yourself the email template that opens with "expenses.zip" attached.
  3. Open the Email on the PC and save the .zip file and extract it.
  4. Open DejaOffice PC CRM, select Expense, select the 3 bars in the top right and choose Grid View.
  5. Select the Import option in the top tool bar, select the expenses.txt file.
  • Note: You need DejaOffice PC CRM Build 1274 or higher to import Expenses from DejaOffice Mobile.


Resolve Contact Linking in Event Import

If you import events from another source via a CSV and have linked contacts to the events, you can run a manual scan of the records to match the contacts to the event links.

  1. Open DejaOffice PC CRM (Build 1348 and above), select Calendar Day View, and change to the Grid View.
  2. Press Ctrl + Shift + R.


A new window will appear with "Resolving Contacts", when the scan is complete, any events that were imported with a link will be matched to the corresponding DPC Contact.

  • Note: The Contact linked to the event must exist in DPC for the scan to match it correctly.