Importing CSV file in metadata not working

[romain_f]

Hello,

I would like to import a CSV file in metadata.

Here is the content :

123;ABC
456;DEF
789;IJK

I have tried click right on MetaData > Create a delimited file because I have an issue with creating an Excel too.

I've selected the CSV file in Explorer and chose "Windows" format.

It works until I reach third step with preview. At this moment, preview does not work. It tells me encoding is US-ASCII (and that is not in the available list).

Here you are the error message (Notice I have the french version of the software) :

Message d'erreur: The type java.lang.Object cannot be resolved. It is indirectly referenced from required .class files
Erreur de prévisualisation. Des paramètres doivent être modifiés`
Note : Les erreurs de prévisualisation sont généralement liées à un mauvais paramétrage de l'encodage.
org.talend.designer.runprocess.shadow.ShadowFilePreview.preview(ShadowFilePreview.java:90)
org.talend.metadata.managment.ui.utils.ShadowProcessHelper.getCsvArray(ShadowProcessHelper.java:383)
org.talend.repository.ui.wizards.metadata.connection.files.delimited.DelimitedFileStep2Form$PreviewProcessor.nonUIProcessInThread(DelimitedFileStep2Form.java:1309)
org.talend.commons.ui.swt.thread.SWTUIThreadProcessor$1.run(SWTUIThreadProcessor.java:74)

I have Talend Open Studio for Data Integration version 7.2.1.

Thanks for your help

[romain_f]

I've tried to install JDK8 in plus of JDK13, but in this case, Talend did not start anymore so I had to uninstall JDK8.

I've tried to create metadata from an xml file but I have problem generating preview when creating metadata element.

Here is the subject : Not generating preview with XML Input metadata creation 

I have Talend Open Studio for Data Integration  7.2.1.

[romain_f · Accepted solution]

Hi,

In fact, I've had to install JDK 8 and, in particular, jdk1.8.0_241, and select it to "default" in "Talend" > "Préférences" > "Java" > "Install JREs" in order to make Talend Open Studio for work.

Second point, i have had to create Excel metadata from a xls file in order to import data instead of take a CSV file.

I've resolved the problem alone but thanks to @shong , here is a link to documentation :

https://community.talend.com/t5/Installation-and-Migration/Specifying-another-JVM-to-launch-Talend-S...

Have a good day