Skip to main content
Solved

How to read attachment data in a workflow/event action?

  • April 23, 2025
  • 3 replies
  • 75 views

Forum|alt.badge.img+17

Hello,

We currently store our emails to customers as attachments on case contact log entries. Is there a way in a workflow or event action to open that file, read the data in that email attachment? I just need the exact date the email was sent, which if you open up a .eml file, it saves it on the 3rd line. I’m very new to document management but I thought I’d ask and see if this is possible in IFS Cloud.

Thanks,

Bryan

Best answer by Mathias Dahl

If you keep the files in a database repository, it's stored in EdmFileStorage. The file information can be found always in EdmFile and the repository information in EdmLocation.

3 replies

Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2901 replies
  • April 24, 2025

If the file is stored in the database, it should be doable using a custom event action with PL/SQL code. If it's in File Storage, you need to first move it to the database, read it, then move it back. A bit messy but should be doable too.


Forum|alt.badge.img+17
  • Author
  • Superhero (Customer)
  • 254 replies
  • April 24, 2025

Thanks ​@Mathias Dahl,

Do you know where I can find more about accessing it in IFS? Anything that you’d suggest I look at first?

I can’t seem to find any data concerning extracting that file data nor where in the database it actually lives. Whenever I call functions for fetching the address location, I get /temp/ back.

Thanks again,
Bryan


Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2901 replies
  • Answer
  • April 24, 2025

If you keep the files in a database repository, it's stored in EdmFileStorage. The file information can be found always in EdmFile and the repository information in EdmLocation.