Trying to Create a Tab-delimited Text File Using the UIPath.CSV.Activities.WriteCSVFile - Error


#1

Hi, I’m trying to create a tab-delimited text file using the UIPath.CSV.Activities.WriteCSVFile activity.

When I run it locally on my laptop, it runs fine; the tab-delimited text file is created successfully, and everything is good.

When I packaged the workflow up, and added it to our production environment, and attempt to run it, I get an error message that “UiPath.Core.Activities : Failed to create a ‘Delimitator’ from the text ‘Tab’”.

The same version of the UIPath.Core.Activities package (ver. 17.1.6435.21841) is on both my PC and the robot server. The same version of MS Excel is installed on both my PC and the robot server.

Anyone else experience this issue? Any tips?


#2

Hi,

can you check with different delimiter instead of ‘Tab’.


#3

Running a local robot, I can use any of the delimiter options for the Write CSV action (tab, comma, semi-colon, caret, pipe), and they all work successfully.

Trying to run as a scheduled task on one of our Robot servers, I get the following results:
Pipe: “Invoke GatherData: UiPath.Core.Activities : Failed to create a ‘Delimitator’ from the text ‘Pipe’.”
Caret: “Invoke GatherData: UiPath.Core.Activities : Failed to create a ‘Delimitator’ from the text ‘Caret’.”
Tab: “Invoke GatherData: UiPath.Core.Activities : Failed to create a ‘Delimitator’ from the text ‘Tab’.”

The Semicolon and comma options didn’t cause an error, but I need the tab delimited file for another application to consume correctly…

Driving me crazy trying to find out what the difference is between the two environments. Checked Excel version, both running x64 Windows 10, the UIPath package is the same.


#4

.XLS by default is tab-delimitted. You could also use Write Text file with extension .XLS

So that’s just another way.


#5

Thanks!