function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Admin FactorAdmin Factor 

[Pentaho] I can't insert a file correctly

Hey everyone,

I was trying to insert a file to Salesforce (SObject: ContentVersion) in the simplest way possible:

User-added image
filetest.pdf is a 378 KB PDF archive, I can open it, etc.

1. CSV file input, data:
Title, Description, PathOnClient, VersionData
filetest, trial, c:\files\filetest.pdf, c:\files\filetest.pdf

2. Salesforce Upsert
Title => Title
Description => Description
PathOnClient => PathOnClient
VersionData => VersionData
It inserts a file with the same name, but it does not has the same content as 'filetest.pdf'. Its size is almost 0 KB and I cannot open it. 

The "funny" thing is I can do the same with Data Loader (Salesforce App) and it does work. I cannot find the difference between them, but Pentaho is not working though.

Do I have to escape the path c:\files\filetest.pdf path? Does anyone know the trick?

Thank you very much.