[MGNLCTS-143] Import of Excel Translations Files failes if empty column Created: 05/May/21  Updated: 25/May/21  Resolved: 20/May/21

Status: Closed
Project: Content Translation Support
Component/s: None
Affects Version/s: 2.5.2
Fix Version/s: 2.5.3

Type: Bug Priority: Neutral
Reporter: Carlos Cantalapiedra Assignee: Teresa Miyar
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Problem/Incident
Template:
Acceptance criteria:
Empty
Task DoD:
[X]* Doc/release notes changes? Comment present?
[X]* Downstream builds green?
[X]* Solution information and context easily available?
[X]* Tests
[X]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[X]* Steps to reproduce, expected, and actual results filled
[X]* Affected version filled
Date of First Response:

 Description   

Steps to reproduce

  1. Create a Page which has a component like mtk:components\textImage
    and set some content (headline label) on two locales (like en and de
  2.  Move to Translation app, select the page created on step 1 and export as XLS.
  3. Modify the XLS (delete the DE content)
  4. Import the XLS again and check it fails

Expected results

The de content (actually null because it was deleted) gets also deleted on JCR

Actual results

The translation file is never imported and the following exception is thrown:

2021-05-04 10:38:17,330 ERROR lation.ui.action.TranslationFileUploadDialogAction: An error occurred when executing the command uploadTranslationFile from catalog translation
java.lang.NullPointerException: null
	at java.text.SimpleDateFormat.parse(SimpleDateFormat.java:1439) ~[?:1.8.0_191]

Workaround

N/A

Development notes

N/A



 Comments   
Comment by Teresa Miyar [ 19/May/21 ]

Problem only happens when using the pages app to export/import the data, for excel last line is a null line and for pages las line is null fields.

Generated at Mon Feb 12 00:33:39 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.