Skip to main content
Kofax

Tips and Troubleshooting AP Agility Data Import

Article # 3029491 - Page views: 55

Issue

How can I troubleshoot AP Agility data import? What should I check to confirm my data import? 

Solution

The following steps can be followed to run and confirm data import for AP Agility: 

  1. Preparing & checking your csv files and data. 
    1. Confirm the location of your Import directory. For example: C:\Agnostic\Import\. Files include po_headers.csv and po_lines.csv. 
      1. Ensure the data fits the fields/columns. (Example: do not put an address into the vendorsitecode field for po_headers.csv). If you don't have a proper code, leave the field blank instead. 
  2. Check that your Web.config file has the correct import path set. For example, this file may be located in C:\Program Files (x86)\Kofax\APAgility\Web. apa_article_8.PNG
  3. Once the data has been reviewed & cleaned, and you confirm your Web.config file has the correct input path, ensure you have the correct Business Units for the test data you are working with. For example, if testing an import with 2 rows of data, ensure that you have Business Units in the test environment that match the ErpBusinessUnitId value from your test data (such as from po_headers.csv). 
    1. Login to the APA Workspace. 
    2. Get an example business unit id to use from the po_headers.csv file by opening it in Notepad: apa_article_14.PNG
    3. Open AP Agility Workspace to create a business unit for testing the import: apa_article_9.PNG
    4. In this example we are using Agnostic. Click on that name. apa_article_10.PNG
    5. On the new page, click the Business Units menu: 
    6. apa_article_11.PNG
    7. This displays the list of Business Unit Names. In our example, we have a name using the value from the po headers file:  
    8. apa_article_12.PNG
    9. In the following screen, you can see how we used that value to populate certain fields for our test. We also selected the Country and Currency LOV's and chose a Default Routing Order: 
    10. apa_article_13.PNG
  4. Once completed, you can then create the job.
    1. Login and go to Jobs > Create. apa_article_5.PNG
    2. Click the job id to get more details. apa_article_6.PNG
    3. View the Status and click Refresh to confirm the job has completed. apa_article_7.PNG
  5. You can check the import results in the database as well. 
    1. In SQL Server, as the Admin user, under Databases > APAgility >Tables, right-click on ERP_IMPORT_JOB_STATUS and click Select Top 1000 Rows: apa_article_1.PNG apa_article_2.PNG apa_article_3.PNG

The IMPORT_ERRORS_MESSAGE column will show any errors raised for your import. You can copy and paste this into Notepad to view the full details. For example, we see in the example screen shot above there were errors in the PO Headers and PO Lines import attempts. The PO Headers full error when copied to Notepad shows: 

 

apa_article_4.PNG

Level of Complexity 

Moderate

Applies to  

Product Version Build Environment Hardware
AP Agility  2.3+