Uploaded image for project: 'iDempiere'
  1. IDEMPIERE-3805

Query gets lost when Importing a csv file from the toolbar button


    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects versions: None
    • Fix versions: None
    • Components: None
    • Labels:
    • Sprint:


      Contributed by TrekGlobal.

      When you import a csv files from the 'CSV Import File Loader' in the toolbar, after the process finishes the window shows only the last imported record and the search button and refresh do not work. The reason is because while importing the class GridTabCSVImporter calls gridTab.getTableModel().dataRequery() but that where clause is not cleaned after the process finishes, which leaves the window with an undesired MQuery.

      Steps to Reproduce:
      a) Create a new Import Template for the 'Product Category' window, for example, Product Category UTF-8 (See the screenshot below)

      b) Go to the menu list to find and select the 'Product Category' window. Then, push the CSV import button. The 'Import File Loader' dialog will open. In this dialog, choose the newly created import template, the 'Insert' mode and upload the below file to be imported. ImportProductCategory.csv

      c) After importing the template file, the 'Product Category' window is refreshed and show only the last imported line record (See the screenshot below). If I keep clicking Refresh or Lookup All Records, but this window doesn't actually do anything (Always show the last imported line).


        1. IDEMPIERE-3805.patch
          2 kB
        2. IMportPC.png
          61 kB
        3. ImportProductCategory.csv
          0.2 kB
        4. ImportTemplayte.png
          51 kB
        5. PCafterImport.png
          54 kB
        6. PCbeforeImport.png
          49 kB



            • Assignee:
              d_ruiz Diego Ruiz
              d_ruiz Diego Ruiz
            • Votes:
              0 Vote for this issue
              1 Start watching this issue


              • Created: