Importing Spreadsheets

 Align.png


 Persona-ArticleFor.pngPersona-Marketer.pngPersona-MarketingOps.png

Allocadia’s import feature allows you to quickly and easily import your data without hours of manual entry. Importing Spreadsheets can assist in adjusting bulk amounts of marketing spend data for different workspaces, and associate corresponding marketing activities with their POs and / or Actuals.

  1. On the Home Tab, click the Import button and click your desired selection
  2. On the Import page, select which workspace you would like to import into.
  3. Select the Browse button and upload your spreadsheet
    Note: You can also choose your Import Template, if pertinent
  4. On the Assign Fields window, assign the columns in your spreadsheet to Invoice panel fields in Allocadia. If you do not want to import a specific column from your spreadsheet do not match it to an Invoice panel field in Allocadia. Click Next when complete.
    Note: If you have not assigned a spreadsheet column to an Allocadia field, a notification will pop up advising you of unmapped fields. Click Cancel to review your mapping and click ok if you have assigning all the appropriate fields.
  5. On the Identify Duplicate Matching Fields page, select your options.
    Note: There are three options. These three options are as follows: 
    - All spreadsheet fields: All columns on the spreadsheet will be used to identify duplicates.
    - Specific spreadsheet fields: Choose which fields will be used to identify duplicates. Choosing Specific spreadsheet fields allows the application to use one or more specific field on the import spreadsheets in the matching process. When the Identify and Replace function is implemented you will be able to match one or more static fields and the unselected fields will be updated.
    - Allow duplicates: Disables the duplicate recognition function. We do not recommend allowing duplicates during PO import as each PO should be unique. 
  6. Create your Mapping Rules and click the Import button.
  7. Once you have confirmed that your mapping rules are correct decide if you would like to bypass the mapping confirmation.
    Note: Once you click import the invoices will be mapped to the budgets, categories, line items as per your mapping rules. Mapping confirmation forces the user to confirm that the mapping is correct before the import goes through. To bypass Mapping Confirmation, go to Advanced options and check the Bypass Mapping Confirmation box.
  8. Click the Import button and select Import.
    Note: If you want to save your import template, click Import and Save Template As… 
Was this article helpful?

Comments

0 comments

Please sign in to leave a comment.