Release 236 - September 2022

This release is a bit shorter but don’t let that fool you… there are some really exciting updates in this release! Rolling out to most accounts on 9/14, users can now upload PDFs and other file types into Tulip tables!

image

image

:iphone: App Editor

  • You can now add triggers to input components that fire when the enter key is pressed
  • This is a very exciting update… you can now store documents in Tulip tables! This includes PDF, XLSX, DOCX, STL files and more. Files can be uploaded directly to Tulip tables or from an app using the file input widget.
  • Added a FILETOTEXT() and TEXTTOFILE() functions so externally hosted files can be stored in tables.
  • Added support for over 20 new languages as well as improvements to translations around the app editor

:bar_chart: Analytics

  • The new file field type is supported in analytics
  • The title and content font sizes can be adjusted when showing a table-style analysis

:computer: Stations, Devices, and Machines

  • Mitutoyo caliper measurements can now be captured on EdgeMC devices
  • Warnings are now displayed on the machine configuration tab for mapped edge device tags that are out of date

:lady_beetle: Fixes, Bugs, and Performance Improvements

  • The app overview page allows you to add an app description
  • Here’s a quality of life improvement… you can delete all unused variables in a single click from the variable modal!
7 Likes

With a Node-Red flow or with a driver?

I guess a File Out widget is in the roadmap?

When you upload the file you can then view the table record field or variable (whichever is holding the file) just like you can view images or videos stored in variables. CSVs, for example, will show up as text that is scaled to fit and can be highlighted. You can also click on the file name and it will be opened up in another window.
image

Here is an .stl, clicking on the stl filename pops up a new window and asks me where I would like to save the file
image

Here is a pdf, clicking on the pdf link pops up a new window and allows me to print, download and so on
image

Does this match your expectations or were you imagining something else (like a button and a trigger that says “open up save modal for variable xyz”)?

1 Like

@youri.regnaud with regard to the Mitutoyo calipers, there are drivers that you can enable on the Edge device. I’ve uploading the documentation around our feature testing to provide more clarity.
PLAT-12613 Test Evidence - Google Docs.pdf (2.6 MB)

1 Like

Output HTTP connector support image with a url that can be use as a source for variable. If url is a pdf link can you be source for File widget/variable? In other work, can i show in Tulip a pdf store on a cloud storage (AWS S3 bucket, Windchill PLM) if I have a API that give me the link to the file?

Hey @youri.regnaud -

Both the file upload widget and the tables UI both support mapping to an eternally hosted pdf, for something like a connector return, a TEXTTOFILE() function exists:

Pete

TEXTTOFILE() is new?

Yes sir, and FILETOTEXT()

Pete

Just gotta say, you guys are killing it lately on features that excite me!!

1 Like

In 236 release also?

Yep. Along with files in tables and the app editor.

Pete

You make my day, or my night in EU! Maybe update release note?

2 Likes

Looking forward to using the enter key for improved UX. Thank you guys.

Would like this post a thousand times if I could! File upload is going to be fantastic

2 Likes

My feedback :slight_smile:

image

  • Some API returns directly a Content-Type = application/pdf response. WIll be nice if this new file variable can be also an output format available in HTTP connector and File URL

image

Thanks

1 Like

Hey @youri.regnaud

The Engineering team just checked into this. In short, when another service is hosting a PDF, we are reliant on them populating a content-type to determine if it can be rendered. For Tulip hosted PDFs, this will always be the case, but some other hosting platforms don’t populate this field. I wrote a feature request to guess the filetype based on the file extension (.pdf, for example) but that also comes with drawbacks.

  • Is it possible for the variable widget to think about enable/disable print and download options when the variable is a file?

Great idea, I just wrote a feature request for this. I see no reason technically this would be challenging.

  • Can you tell us max path size? (URL in a Windchill is quite long)

The table is just storing a reference to a URL (in text), so within some bounds you shouldn’t ever run into link length issues (if you do, let us know). Technically, when that URL gets above 1gb, Chrome might struggle with available memory, but that’s gigantic.

  • Some API returns directly a Content-Type = application/pdf response. WIll be nice if this new file variable can be also an output format available in HTTP connector and File URL

Native file support for both input and output of connectors is a hot topic right now. It isn’t something that we are currently working on, but bringing file support to apps and tables may justify the reprioritization of the next ~2 quarters of work.

Pete

I just make some tests by calling url with Postman

and I receive a Content-Type with application/pdf. So I don’t really understand

Hey @youri.regnaud -

Got a little more detail from the developers-

Its not just about whether the content type is set

Browsers don’t always let you read headers coming from another domain

So if our code from x.tulip.co tries to read a header from randomwebsite.com Chrome will not always let you access the value

Whether it does or not depends on specific cross-origin headers set by the external website

Pete

@freedman Is this “click-to-view” functionality only available for 24hr due to the use of an S3 Bucket?