Fix(TPS-3188)

PATCH_RELEASE_NOTE.md

@@ -0,0 +1,57 @@
+---
+version: 6.3.1
+module: https://talend.poolparty.biz/coretaxonomy/42
+product:
+- https://talend.poolparty.biz/coretaxonomy/23
+---
+
+# TPS-3188
+
+| Info             | Value |
+| ---------------- | ---------------- |
+| Patch Name       | Patch\_20190606\_TPS\-3188\_v1\-6.3.1 |
+| Release Date     | 2019-06-06 |
+| Target Version   | Talend-Studio-20161216_1026-V6.3.1 |
+| Product affected | Talend Studio |
+
+## Introduction
+
+This is a self-contained patch.
+
+**NOTE**: For information on how to obtain this patch, reach out to your Support contact at Talend.
+
+## Fixed issues
+
+This patch contains the following fixes:
+
+- TPS-3188 [6.3.1] Issue while Reading xlsx file using Dynamic Schema in tFileInputExcel Component (TDI-42407)
+
+## Prerequisites
+
+Consider the following requirements for your system:
+
+- Talend Studio 6.3.1 must be installed.
+
+## Installation
+
+### Installing the patch using Software update
+
+1) Logon TAC and switch to Configuration->Software Update, then enter the correct values and save referring to the documentation: https://help.talend.com/reader/f7Em9WV_cPm2RRywucSN0Q/j9x5iXV~vyxMlUafnDejaQ
+
+2) Switch to Software update page, where the new patch will be listed. The patch can be downloaded from here into the nexus repository.
+
+3) On Studio Side: Logon Studio with remote mode, on the logon page the Update button is displayed: click this button to install the patch.
+
+### Installing the patch using Talend Studio
+
+1) Create a folder named "patches" under your studio installer directory and copy the patch .zip file to this folder.
+
+2) Restart your studio: a window pops up, then click OK to install the patch, or restart the commandline and the patch will be installed automatically.
+
+### Installing the patch using Commandline
+
+Execute the following commands:
+
+1. Talend-Studio-win-x86_64.exe -nosplash -application org.talend.commandline.CommandLine -consoleLog -data commandline-workspace startServer -p 8002 --talendDebug
+2. initRemote {tac_url} -ul {TAC login username} -up {TAC login password}
+3. checkAndUpdate -tu {TAC login username} -tup {TAC login password}

main/plugins/org.talend.designer.components.localprovider/components/tFileInputExcel/tFileInputExcel_begin.javajet

@@ -515,7 +515,7 @@ if ((metadatas!=null)&&(metadatas.size()>0)) {
 				int fieldCount_<%=cid %> = row_<%= cid %>.length;
 				dynamic_column_count_<%=cid%> = dynamic_<%=cid %>.getColumnCount();
 				for (int i = 0; i < dynamic_column_count_<%=cid%> ; i++) {
-					if ((<%=dynamic_index%>+i) < fieldCount_<%=cid %>){
+					if ((<%=dynamic_index%>+i) <= fieldCount_<%=cid %>){
 						if(temp_row_<%= cid %>[<%=dynamic_index%>+i]<%=(isTrimAll || (!trimSelects.isEmpty() && ("true").equals(trimSelects.get(i).get("TRIM"))))?".trim()":"" %>.length() < 1){
 							emptyColumnCount_<%= cid %>++;
 						}
@@ -1081,7 +1081,7 @@ if ((metadatas!=null)&&(metadatas.size()>0)) {
 							}
 							dynamic_column_count_<%=cid%> = dynamic_<%=cid %>.getColumnCount();
 							for (int i = 0; i < dynamic_column_count_<%=cid%> ; i++) {
-								if ((<%=dynamic_index%>+i) < fieldCount_<%=cid %>){
+								if ((<%=dynamic_index%>+i) <= fieldCount_<%=cid %>){
 									if(temp_row_<%= cid %>[<%=dynamic_index%>+i]<%=(isTrimAll || (!trimSelects.isEmpty() && ("true").equals(trimSelects.get(i).get("TRIM"))))?".trim()":"" %>.length() < 1){
 										emptyColumnCount_<%= cid %>++;
 									}
@@ -1424,7 +1424,7 @@ if ((metadatas!=null)&&(metadatas.size()>0)) {
 							int fieldCount_<%=cid %> = row_<%= cid %>.size();
 							dynamic_column_count_<%=cid%> = dynamic_<%=cid %>.getColumnCount();
 							for (int i = 0; i < dynamic_column_count_<%=cid%> ; i++) {
-								if ((<%=dynamic_index%>+i) < fieldCount_<%=cid %>){
+								if ((<%=dynamic_index%>+i) <= fieldCount_<%=cid %>){
 									if(temp_row_<%= cid %>[<%=dynamic_index%>+i]<%=(isTrimAll || (!trimSelects.isEmpty() && ("true").equals(trimSelects.get(i).get("TRIM"))))?".trim()":"" %>.length() < 1){
 										emptyColumnCount_<%= cid %>++;
 									}