Allow .tsv files in the Cloudworks UI (again)
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.
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.
Allow tsv files as possible inputs in the Cloudworks UI.
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?
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!