{"id":27606,"date":"2026-08-19T10:26:57","date_gmt":"2026-08-19T10:26:57","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=27606"},"modified":"2026-08-19T10:26:59","modified_gmt":"2026-08-19T10:26:59","slug":"how-to-configure-test-import-model-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-configure-test-import-model-in-idempiere\/","title":{"rendered":"How to Configure Test Import Model in iDempiere"},"content":{"rendered":"\n

Introduction<\/strong><\/h2>\n\n\n\n

The Test Import Model window in iDempiere lets business users load data into the system from an XML file, using a saved Export Format to match each piece of data to the right place.<\/p>\n\n\n\n

It is used whenever a business needs to bring in bulk data, such as testing a new data feed or re-loading records after a setup change, without entering them one by one.<\/p>\n\n\n\n

A completed import creates or updates records directly in the target area, which then feeds into everyday transactions, reports, and other business processes.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-SystemAdmin-TestImportModel-ProcessFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only active Export Formats are available for selection.<\/li>\n\n\n\n
  • The File Name must point to a valid XML file that the system can reach.<\/li>\n\n\n\n
  • The XML file content must match the fields defined in the chosen Export Format.<\/li>\n\n\n\n
  • Turning on Run as Job sends the import to run in the background instead of immediately.<\/li>\n\n\n\n
  • A completed import creates new records or updates existing ones in the linked area.<\/li>\n\n\n\n
  • The system keeps a log of what happened during each import for review.<\/li>\n\n\n\n
  • Records brought in through import follow the same rules as records entered manually.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • An Export Format already set up and linked to the correct business area.<\/li>\n\n\n\n
    • An XML file prepared with data that matches the Export Format layout.<\/li>\n\n\n\n
    • The XML file saved in a location the system can access.<\/li>\n\n\n\n
    • User access rights to run the Test Import Model process.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n
      Menu \u2192 System Admin \u2192 Data \u2192 Replication Data \u2192 Test Import Model<\/strong><\/code><\/pre>\n\n\n\n
      \"TenthPlanet-iDempiere-SystemAdmin-TestImportModel-1\"<\/figure>\n\n\n\n
      Opening this window shows the Test Import of XML Files screen, with fields for Export Format and File Name, plus a Run as Job option and OK\/Cancel buttons to start or exit the import.<\/p>\n\n\n\n
      \"TenthPlanet-iDempiere-SystemAdmin-TestImportModel-2\"<\/figure>\n\n\n\n
      Configuration Steps<\/strong><\/h2>\n\n\n\n
      Step 1: Select the Export Format<\/strong><\/h3>\n\n\n\n
      This tells the system how to read the XML file and where each value belongs, so the data lands in the correct fields.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Open the Export Format field, search for the format that matches your XML file, and select it before continuing.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Export Format<\/td>Sales Order Import<\/td>Sets the layout used to read and place the incoming XML data.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 2: Specify the File Name<\/strong><\/h3>\n\n\n\n
      This points the system to the exact XML file that holds the data to be imported.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click the file icon next to File Name, browse to the XML file, select it, and confirm the path shown is correct.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      File Name<\/td>\/data\/import\/orders.xml<\/td>Identifies the XML file the system will read during the import.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 3: Choose the Run Mode<\/strong><\/h3>\n\n\n\n
      This decides whether the import runs right away or in the background, which matters for larger files.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Leave Run as Job unchecked for small, quick imports. Check it for large files so the import runs in the background.<\/p>\n\n\n\n
      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Run as Job<\/td>Unchecked<\/td>Runs the import immediately; the window stays open until it finishes.<\/td><\/tr>
      Run as Job<\/td>Checked<\/td>Queues the import to run in the background, freeing the screen for other work.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Step 4: Run the Import<\/strong><\/h3>\n\n\n\n
      This starts the actual process of reading the file and creating or updating records.<\/p>\n\n\n\n
      Instructions<\/strong><\/h3>\n\n\n\n
      Click OK to start the import and review the result once it finishes. Click Cancel to close the window without importing.<\/p>\n\n\n\n
      Common Issues and Resolutions<\/strong><\/h2>\n\n\n\n
      Issue<\/strong><\/td>Cause<\/strong><\/td>Resolution<\/strong><\/td><\/tr><\/thead>
      Import fails right away<\/td>File Name path is wrong or the file is missing<\/td>Confirm the file exists and re-select it from the correct location.<\/td><\/tr>
      No records are created<\/td>XML file layout does not match the Export Format<\/td>Check that the Export Format fields line up with the XML file content.<\/td><\/tr>
      Export Format list is empty<\/td>No Export Format is set up for this area yet<\/td>Set up and activate an Export Format before running the import again.<\/td><\/tr>
      Duplicate records appear<\/td>The same file was imported more than once<\/td>Check existing records before re-running an import on the same file.<\/td><\/tr>
      Process stays In Process for a long time<\/td>A large file was run without Run as Job<\/td>Turn on Run as Job for large files, or allow more time to finish.<\/td><\/tr>
      Only some records come through<\/td>A few records in the file fail validation<\/td>Review the process log and correct the flagged records in the file.<\/td><\/tr>
      Access denied when selecting the file<\/td>User does not have rights to that file location<\/td>Save the file in a shared, accessible location and try again.<\/td><\/tr>
      Values land in the wrong fields<\/td>The Export Format mapping is outdated<\/td>Update the Export Format so it matches the current file layout.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Review and maintain the Export Format used for this import.<\/li>\n\n\n\n
      • Check the target window (for example, Sales Order or Business Partner) to confirm the imported records.<\/li>\n\n\n\n
      • Set up a recurring schedule if this import will run regularly.<\/li>\n\n\n\n
      • Use the Import Tables area to monitor and correct import results.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"
        Introduction The Test Import Model window in iDempiere lets business users load data into the system from an XML file, […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,94],"tags":[],"class_list":["post-27606","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-system-admin"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/27606","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/comments?post=27606"}],"version-history":[{"count":1,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/27606\/revisions"}],"predecessor-version":[{"id":27617,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/27606\/revisions\/27617"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=27606"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=27606"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=27606"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}