topic Re: convertir PDF en base64 in Talend Studio

convertir PDF en base64

Anonymous — Sat, 20 Oct 2018 23:54:57 GMT

Bonjour,
Je souhaite pouvoir classer des PDF issus d'un scanner, dans des répertoires spécifiques d'après un mot clé. A priori, il me faut d'abord convertir le pdf en base64.
Auriez-vous une solution à m'apporter ?
Merci
--------------------- I am not very good in English but I try it--------------------
Hello,
I wish dispatch PDF's files from my scanner, in specific directories. It would seems, I have to convert the pdf's file to base64.
Would you have a solution to bring me ?
Thanks

Bonjour,Je souhaite pouvoir classer des PDF issus d'un scanner, dans des répertoires spécifiques d'après un mot clé. A priori, il me faut d'abord convertir le pdf en base64.Auriez-vous une solution à m'apporter ?Merci--------------------- I am not very good in English but I try it--------------------Hello,I wish dispatch PDF's files from my scanner, in specific directories. It would seems, I have to convert the pdf's file to base64.Would you have a solution to bring me ?Thanks

Re: convertir PDF en base64

TRF — Sun, 21 Oct 2018 07:49:27 GMT

Here a post I replied with an other pseudo https://community.talend.com/t5/Design-and-Development/resolved-Upload-Attachment-into-Salesforce/m-p/64490
The purpose was to convert documents to Base64 before to upload them into Salesforce. Anyway, you get the piece of code you need for your use case.
I don't know why you have to convert files, maybe you could explain this point.
Try to continue in english, it's better for sharing reason.
If it's not possible, send me a PM in french.

Re: convertir PDF en base64

Anonymous — Sun, 21 Oct 2018 21:44:21 GMT

Hi TRF,

thank's for your answer.

Maybe it's not necessary to convert files to base64. In fact, i just want recup pdf's files from my scanner and dispath them in proper repertories.
Tehe base64 conversion was for use Elasticsearch which associated with Kibana allowed to read the pdf and thus to detect a key word.
I'm open to any solution...

Re: convertir PDF en base64

TRF — Sun, 21 Oct 2018 21:54:53 GMT

So you have a method to convert your files to Base64 with my previous answer.
It the result is as expected, don't forget to give your feedback and to mark your case as solved.

Re: convertir PDF en base64

Anonymous — Tue, 23 Oct 2018 13:02:09 GMT

Hi TRF,

I haven't seen your answer, I start on the Forum 🙂

I followed your explanations, but I have this error : Syntax error, insert "Dimensions" to complete Expression

I think it's due to a bad format but I dont find where ?

Bellow, the impacted code :
row3.Parent_ID = row2.Parent_ID; // Related object's Id
row3.Name = row2.Name; // The document's name such as xxxxx.docx or yyyyyy.xlsx or anything else
row3.ContentType = row2.ContentType; // Object's name such as Account, Task and so on
row3.Body = null; // The place to put the conversion result
// In this case, I iterate over the input directory using a tFileList
File file = new File((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"));
try {
// Read file
documentInFile = new FileInputStream(file);
byte documentData[] = new byte;
documentInFile.read(documentData);
// Convert bytes array to Base64 string to fill Body field
row3.Body = new String(Base64.encodeBase64(documentData));
System.out.println("+++ File converted "+(String)globalMap.get("tFileList_1_CURRENT_FILEPATH"));
} catch (FileNotFoundException e) {
row3.conversionCode = "FILE_NOT_FOUND";
row3.conversionMessage = "File not found "+(String)globalMap.get("tFileList_1_CURRENT_FILEPATH");
System.out.println("*** File not found "+(String)globalMap.get("tFileList_1_CURRENT_FILEPATH")+"\n"+e);
} catch (IOException ioe) {
row3.conversionCode = "CONVERSION_ERROR";

Re: convertir PDF en base64

TRF — Tue, 23 Oct 2018 21:07:55 GMT

Not sure the problem comes from this piece of Java code. To be sure of what's wrong, click on the Code tab, then click on the red cross in the right margin. You will be redirected on the source line where the error is located. Move the mouse pointer over the symbol representing the compilation error to discover the full error message.

Re: convertir PDF en base64

Anonymous — Wed, 24 Oct 2018 10:23:33 GMT

Hi TRF,

Here my job with an error message on the Sleep.

I don't understand how tSalesForceOutput works ?

Furthermore, here the message after running job :

Re: convertir PDF en base64

TRF — Wed, 24 Oct 2018 10:52:56 GMT

Not the same subject.

Anyway, the message is clear, you cannot have a main row after a component which doesn't have an input row.

Change the main row after tSleep by an onComponentOk trigger.

Re: convertir PDF en base64

Anonymous — Wed, 24 Oct 2018 12:00:13 GMT

I can only attach main row after tSleep. I don't know why !!

I think I have to learn English before use Talend successfully 🙂

Re: convertir PDF en base64

TRF — Wed, 24 Oct 2018 12:27:49 GMT

Because the component (tJavaRow) requires an input row.

So you have to change for a tJava (I assume you don't have anything you expect from a row in the actual tJavaRow component).

If you are not sure of how to write what you expect, you can write your message in english + french (I'm french), but english is better on this forum (elsewhere this is an other question).

Re: convertir PDF en base64

Anonymous — Wed, 24 Oct 2018 20:55:53 GMT

Good evening
I replaced the tJavaRow with a tJava, copied in the tJava the code you had given previously but unfortunately, the only possible link between the tJava and the tFilterRow remains the Main row

As a reminder, the purpose of all this, allow me to read PDF (or JPG) from a scanner and be able to sort into specific folders based on a keyword that would be detected in the text.

-------------------------------------------------------------------------------------------------------------

Bonsoir
J'ai remplacé le tJavaRow par un tJava, recopié dans le tJava le code que vous aviez donné précédemment mais malheureusement, le seul lien possible entre le tJava et le tFilterRow reste le Main row.

Je rappelle le but de tout ceci, me permettre de lire des PDF (ou des JPG) issus en masse d'un scanner et pouvoir les trier dans des dossiers spécifiques en fonction d'un mot clé qui serait détecté dans le texte.

Re: convertir PDF en base64

Anonymous — Tue, 27 Nov 2018 13:58:17 GMT

hi,

i am trying to Insert PDF Attachments into Salesforce.com, and i follow your process, i have this error in the your java code :

in : documentInFile = new FileInputStream(file);

--> documentInFile cannot be resolved to a variable

and : byte documentData[] = new byte;

--> Syntax error, insert "Dimensions" to complete Expression