Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | Tools - Import Tool |
| Version | 19.5 |
For Import Data and Excel Import, a new option under Data Options: Ignore rows with all NULL values
Under Data Options, we already have set value to NULL if cell is blank, in the same line if user has an Excel file with blank rows between, we can have an option to ignore those lines.
We can add the new “Ignore rows with all NULL values” option under the Options tab inside the Data Options, right below the “Set value to NULL if cell is blank” option, as in attached screenshot.
The option will basically ignore blank rows between data.
This option should be persisted across imports and ADS runs, just like the "Set value to NULL if cell is blank" option.
|
26 KB
|
|
102 KB
|
|
832 KB
|
|
17 KB
|
|
34 KB
|
|
28 KB
|
|
19 KB
|
|
41 KB
|
|
16 KB
|
|
73 B
|
|
29 B
|
|
84 KB
|
|
5 KB
|
|
87 KB
|
|
93 KB
|
|
102 KB
|
|
112 KB
|
|
90 KB
|
|
91 KB
|
|
80 KB
Set the Option on by Deault and see new mock-up below.
Hi Pankaj,
Please supply your unit test cases and data used to test it.
Thanks, Tom
Hi Pankaj,
Please supply your unit test cases and data used to test it.
Thanks, Tom
Hi Pankaj,
I attached Blank Data_xlsx_format2.xlsx and Blank Data_xlsx_format2.csv/ Please try your code changes with these files. Although, the records inserted into the database using csv are correct, the row count is wrong. See here. This is true even with your test data.
The Excel import records inserted and the row count are incorrect. See here and here.
Please have a look..
Thanks, Tom
Hi Pankaj,
I attached Blank Data_xlsx_format2.xlsx and Blank Data_xlsx_format2.csv/ Please try your code changes with these files. Although, the records inserted into the database using csv are correct, the row count is wrong. See here. This is true even with your test data.
The Excel import records inserted and the row count are incorrect. See here and here.
Please have a look..
Thanks, Tom
Hi Pankaj,
The middle word "Rows" in the sentence “Ignore Rows with all NULL values” should be in small letters. Replace "Rows" with "rows".
Expected: “Ignore rows with all NULL values”
Thanks, Juhi
Hi Pankaj,
The middle word "Rows" in the sentence “Ignore Rows with all NULL values” should be in small letters. Replace "Rows" with "rows".
Expected: “Ignore rows with all NULL values”
Thanks, Juhi
Just an fyi... When I test this with Blank Data_xlsx_format2.xlsx, it throws an exception caused by changes to #14932. Hussain will look into this.
Just an fyi... When I test this with Blank Data_xlsx_format2.xlsx, it throws an exception caused by changes to #14932. Hussain will look into this.
Tested on: ADS19.5_Dev12
Platform: Windows 10
Tested on: ADS19.5_Dev12
Platform: Windows 10
Issue: When destination table contains more columns than the columns in source file, then the "Ignore rows with all null values" feature is not working as in this case it adds <ignore> in the source name for that specific column.--Fixed
Issue: When destination table contains more columns than the columns in source file, then the "Ignore rows with all null values" feature is not working as in this case it adds <ignore> in the source name for that specific column.--Fixed
Hi Tom,
Added "Data Option: Ignore rows with all NULL values" functionality is working fine.
Observation: Providing constant value for a corresponding column, contains blank rows is not getting ignored.
Steps:
1. Import Excel sheet in the table (Make sure excel sheet contains column with blank rows in between)
2. Provide constant value for corresponding destination column
See attached links: 1. import file 2. Ignore row checkbox 3. Preview statement
Please let us know your feedback on this scenario.
Thanks, Juhi
Hi Tom,
Added "Data Option: Ignore rows with all NULL values" functionality is working fine.
Observation: Providing constant value for a corresponding column, contains blank rows is not getting ignored.
Steps:
1. Import Excel sheet in the table (Make sure excel sheet contains column with blank rows in between)
2. Provide constant value for corresponding destination column
See attached links: 1. import file 2. Ignore row checkbox 3. Preview statement
Please let us know your feedback on this scenario.
Thanks, Juhi
Hi Juhi,
This is acceptable behavior. When you add a constant, it is expected that it will get imported regardless of the incoming data. Note that if you set the field to <empty>, it honors the ignore rows with null values.
Thanks, Tom
Hi Juhi,
This is acceptable behavior. When you add a constant, it is expected that it will get imported regardless of the incoming data. Note that if you set the field to <empty>, it honors the ignore rows with null values.
Thanks, Tom
Its working fine with <empty> option too.
Done testing for "Data Option: Ignore rows with all NULL values" functionality. Hence, marking it verified.
1. Verified by importing excel (.xlsx and .xls) files
2. Verified by importing .csv files
Its working fine with <empty> option too.
Done testing for "Data Option: Ignore rows with all NULL values" functionality. Hence, marking it verified.
1. Verified by importing excel (.xlsx and .xls) files
2. Verified by importing .csv files
Issue #14042 |
| Verified |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS19.5.0-dev-24 |
| No time estimate |
Set the Option on by Deault and see new mock-up below.