Allow .tsv files in the Cloudworks UI (again)

evanwalsem · 2023-05-11T08:32:53+00:00

There was an error rendering this rich post.

The Situation
Currently we import all our files as a tab separated file (tsv), bundle a set of import actions in a process and orchestrate these processes trough Cloudworks Integrations.

Tab separated files are one of the first possibilities in the file options:

To indicate such a file is tab separated all our files are saved as .tsv files on our cloud storage.

The Problem
Suddenly it is not possible anymore to select new tsv files in Cloudworks integrations. The Cloudworks UI blocks selecting tsv files, while excel and csv files are still possible. When someone wants to include a new action in a process it is not possible to select the corresponding tsv file in Cloudworks . Also, it is not possible to select another tsv file for an existing action. Existing integrations populated with old tsv files are still running perfectly. The Anaplan customer service described this behavior as wanted and explicitly not as a bug.

Why is this a problem?
As stated above it is not possible to edit existing integrations based on .tsv files, and we cannot maintain our way of working.
A solution proposed by customer service was to rename tsv files to .csv. This promotes bad practices since one expects a .csv file to be comma separated instead of tab separated.

The solution
Allow tsv files as possible inputs in the Cloudworks UI.

Comments

Stacey_Gibbens

Hello, Evan.

In my experience, .txt files with tab delimited text are easily used as data sources. I have not had cause to try this in CloudWorks, but it was my primary method when developing integrations using AnaplanConnect. I understand this is more of a naming convention thing that you're trying to resolve… maybe .txt is acceptable to use for distinguishing between tab and comma as the delimiter in the data file?

Best regards,

Stacey

Quick Links

New ideas

Status Log
Could you please allow me to see a log of the processing status of the workspace and model? Once this is achieved, it will be possible to identify the cause of the failure to some extent by checking the logs when it occurs, and the speed of response to the failure will increase.
Page Title Options
Could you please allow me to change the color and text information of the page title? If you can set the page title options according to the settings of the page's source model, you can easily determine which environment (e.g., production or development) you are now accessing.
Format Type: Integer
Could you please add type:integer as the format of the line item?