Skip to main content

After last year the system update, I uploaded a file and then clicked the action button, which kept showing file status failed. I tried to use the file that successfully uploaded and generated the flowchart in studio, but it also showed failure. The failure reason of this case imageis in the picture below the text. Please see how I should deal with it. Could you please give me a copy of the latest template format file for reference.Many Thanks!

Hi @yuanyuan.zhang,

 

I think something is wrong with your column formatting. Before pressing the action button, please configure the column types by pressing the three dots:

Configure upload 

Follow the instruction until you reach the screen with the column type formatting.

Column Type Formatting 

Here you can specify which data type it should have. Note that some types might not accept empty values. If the problem persists, you can choose to read al values as Strings, but this is not ideal. For example, you have to create dates again from strings in the transformations.


Hi Jan-peter van der Steege

Thanks for your help!

 

I have already tried to click to configure date schema, and tried to set the date column as datetime, date and string, it all works out failed as the screenshot 1.screenshot 1 

Furthermore, here's the screenshot of my excel rawdata, it would be great if you could advise if i use the right format. (This is the file that uploaded and run sucessfully before the Celonis website updates, i don't know if the format has changed yet.) Thank you so much!

screenshot 2


Hi @yuanyuan.zhang,

 

Strange, especially when you make all columns strings, this should work.

However, I found this on the docs: File Uploads (celonis.com). It might be caused by the name of your file. Unfortunately, only latin characters are allowed here (no so inclusive.. whoops!). Maybe that is the problem?

 

Kind regards,

Jan-peter


Reply