{"id":22228,"date":"2026-07-31T06:48:45","date_gmt":"2026-07-31T06:48:45","guid":{"rendered":"https:\/\/tenthplanet.in\/idempiere\/?p=22228"},"modified":"2026-08-20T09:00:12","modified_gmt":"2026-08-20T09:00:12","slug":"how-to-delete-import-data-in-idempiere","status":"publish","type":"post","link":"https:\/\/tenthplanet.in\/idempiere\/how-to-delete-import-data-in-idempiere\/","title":{"rendered":"How to Delete Import Data in iDempiere"},"content":{"rendered":"\n

The Delete Import Data window in iDempiere clears staging records from an Import Table (I_*) for the current client. It supports retail data loads such as product catalogs, business partners, sales orders, and GL journals brought in through CSV or Excel imports.<\/p>\n\n\n\n

Because the process only touches I_* staging tables, it has no impact on live Products, Business Partners, or Orders, keeping transactional and reporting data safe during cleanup.<\/p>\n\n\n\n

Process Flow<\/strong><\/h2>\n\n\n\n
\"TenthPlanet-iDempiere-Delete-Import-Data-WorkFlow\"<\/figure>\n\n\n\n

Business Rules<\/strong><\/h2>\n\n\n\n
    \n
  • Only tables whose name starts with I_ can be selected for deletion.<\/li>\n\n\n\n
  • Deletion applies only to records belonging to the current client.<\/li>\n\n\n\n
  • Master and transaction tables such as M_Product or C_Order cannot be targeted.<\/li>\n\n\n\n
  • The process permanently deletes staging rows; there is no undo.<\/li>\n\n\n\n
  • A success message reports the exact number of rows deleted.<\/li>\n\n\n\n
  • Running the process on an empty import table returns a zero-row result, not an error.<\/li>\n<\/ul>\n\n\n\n

    Prerequisites<\/strong><\/h2>\n\n\n\n
      \n
    • Import Table (I_*) populated through a completed or failed import run.<\/li>\n\n\n\n
    • User has access rights to the System Admin or General Rules menu.<\/li>\n\n\n\n
    • Correct Client and Organization context selected in the login window.<\/li>\n\n\n\n
    • Source file errors identified before re-importing corrected data.<\/li>\n<\/ul>\n\n\n\n

      Navigation<\/strong><\/h2>\n\n\n\n

      Menu \u2192 Data \u2192 Data Management \u2192 Delete Import Data<\/p>\n\n\n\n

      Configuration Steps<\/strong><\/h2>\n\n\n\n

      Step 1: Identify the Import Table to Clear<\/strong><\/h3>\n\n\n\n

      Open the source import window (e.g., Import Product) and note the table name shown in the window title or tab, such as I_Product.<\/p>\n\n\n\n

      \"TenthPlanet-iDempiere-Delete-Import-Data-1\"<\/figure>\n\n\n\n

      Step 2: Open Delete Import Data and Select the Table<\/strong><\/h3>\n\n\n\n

      Navigate to Delete Import Data, click the Table field, and choose the matching import table from the list, for example I_Product.<\/p>\n\n\n\n

      Field<\/strong><\/td>Sample Value<\/strong><\/td>Description<\/strong><\/td><\/tr><\/thead>
      Table<\/td>I_Product<\/td>Import staging table to be cleared for the current client.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Step 3: Verify Client Context Before Running<\/strong><\/h3>\n\n\n\n

      Check the client shown in the top toolbar (e.g., GardenWorld) matches the client that owns the import batch before starting the process.<\/p>\n\n\n\n

      Step 4: Run the Process and Review the Result<\/strong><\/h3>\n\n\n\n

      Click Start (OK). Review the result message, e.g., Import Product #542, confirming 542 rows were deleted before re-importing corrected data.<\/p>\n\n\n\n

      \"TenthPlanet-iDempiere-Delete-Import-Data-2\"<\/figure>\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>
      “Not an import table” error<\/td>Selected table does not start with I_ (e.g., C_Order)<\/td>Choose the correct I_* staging table from the dropdown.<\/td><\/tr>
      “No AD_Table_ID” error<\/td>Table parameter left blank or invalid table reference<\/td>Reselect a valid Import Table before running the process.<\/td><\/tr>
      Rows still appear after deletion<\/td>Records belong to a different client or organization<\/td>Confirm the active client matches the one that owns the import batch.<\/td><\/tr>
      Deleted rows reappear after re-import<\/td>Old import file re-uploaded instead of the corrected file<\/td>Verify the corrected source file before running the import again.<\/td><\/tr>
      Zero rows deleted<\/td>Import table was already empty or previously cleared<\/td>No action needed; proceed with a fresh import.<\/td><\/tr>
      Process runs but re-import still fails<\/td>Errors exist in source data, not in the staging table<\/td>Fix Product Category, UOM, or duplicate Value issues in the file first.<\/td><\/tr>
      Cannot find Delete Import Data in menu<\/td>User role lacks access to System Admin menu<\/td>Request access to General Rules \u2192 Data menu from the system administrator.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

      Next Steps<\/strong><\/h2>\n\n\n\n
        \n
      • Re-run the relevant Import window (Import Product, Import Business Partner, Import Order, etc.).<\/li>\n\n\n\n
      • Review Import Format definitions if recurring column mapping errors occur.<\/li>\n\n\n\n
      • Check Product, Business Partner, or Order windows to confirm the corrected data loaded correctly.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        The Delete Import Data window in iDempiere clears staging records from an Import Table (I_*) for the current client. It […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,92],"tags":[],"class_list":["post-22228","post","type-post","status-publish","format-standard","hentry","category-idempiere-product","category-idempiere-data"],"_links":{"self":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22228","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=22228"}],"version-history":[{"count":4,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22228\/revisions"}],"predecessor-version":[{"id":27883,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/posts\/22228\/revisions\/27883"}],"wp:attachment":[{"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/media?parent=22228"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/categories?post=22228"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tenthplanet.in\/idempiere\/wp-json\/wp\/v2\/tags?post=22228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}