Little box with ? being returned when using Create File plugin

OL Connect Professional Workflow
1

Hi - I have a script to set the variable in my workflow then I and using the Create File plugin to create a csv output. My first line of output is good but then I get a little box with ? then my out put. My data files are pdf’s. So, it looks like this -

123456 , 12343456
{little box w/?}456787, 54323125
{little box w/?}123456, 0987654

Why am I getting this and how do I get rid of it?

Thank You

2

By default, the Send to Folder you’re likely using after that Create File plugin is inserting \014 after each concatenate. You’ll want to remove that.

3

Thank you !! that worked!!

I have another question regarding the output. I am using the SetVariable to set two variables. I need a csv output. It works fine now but wondering how or if using this Watch Object to get the output in two different cells. I also tried using the SetJobInfos. I can set one job info but can’t get the syntax to set two of them in the same Run Script.

Thanks

4

You will use two Watch.SetJobInfo lines in your script and then use both in the Create File plugin. And looking at your original post you already have two cell output separated by a comma.

Regards,
S

5

Ok I will try the two lines. The output I indicated above was that format but only in one cell.

Thanks

6

I have the SetJobInfos working with multiple variables. Thank you very much - I tend to over think things and make it harder than it really is.

7

I tend to do the same LOL. Just never try creating a XLS/XLSX file via a script in Workflow. I learned that the hard way. Simply put, Microsoft does not allow automation software creating those files. (I have a post on here that explains it a little further.)

Regards,
S

1 Like