Skip to main content

Save yourself from text file wrangling using FME : Case Study

Context

A lot of people might not know but, at Spatialworld, we also offer hardware to monitor power stations. The other day, Timo, in charge of this part of the business, came to Petri because he was struggling with some text file report. Indeed, Utility sector is often conservative in terms of formats and it makes sense. Who wants a monitoring to fail and miss a critical situation in a power plant?

How FME saved the day

Of course a coder could have created an obscure bat file in a corner of Timo’s computer. But what about its maintenance, updates, visibility?

As we all know, the colleague who comes with a file to fix, will come again with another, a bit different, and then another colleague will come… FME combines the speed and easiness of deployment with the robustness scalibility needed for automations on the long run.

Building the pipeline

With FME, Petri effortlessly constructed a pipeline that transformed the cumbersome text file into a streamlined format that precisely met our monitoring needs. Here’s where the magic of FME truly shines:

  • Self-documentation: The entire process became self-documented, eliminating ambiguity and facilitating seamless maintenance.
  • No coding required: By leveraging FME’s intuitive interface, we bypassed the need for intricate coding, thus saving time and resources.AI-assisted Regex: FME’s AI assistant generated Regex expressions, further enhancing the efficiency of our data processing.
  • Caching mode: Data monitoring along the pipeline was optimized thanks to FME’s caching mode, resulting in faster testing.
  • Scalability: The solution proved to be scalable, capable of accommodating future expansions or modifications effortlessly.

Publishing as a service

To streamline operations further, we didn’t stop at mere automation. Instead, we elevated the solution by publishing it as an app through FME Flow. Here are the benefits:

  • Fast Publishing Process: With a few clicks, we published the workflow to FME Flow, transforming it into a user-friendly application.
  • Sharing and Collaboration: The app’s link was shared with Timo and other stakeholders, enabling seamless collaboration and eliminating manual file transfers.
  • Monitoring and Maintenance: FME Flow’s admin features enabled us to monitor the application’s performance and swiftly address any maintenance needs.

Conclusion

In just 15 minutes, Petri crafted a sustainable app and resolved Timo’s recurring issue 🥳.

With the FME integration platform, handling daily data challenges becomes swift and efficient, requiring minimal coding. It prioritizes crucial factors like security, scalability, and easy maintenance, extending its usefulness well beyond spatial data applications.

Most importantly, it turns you into a hero among your colleagues by effortlessly addressing their urgent needs, freeing you from the endless stream of demands and letting you concentrate on what truly counts. This capability to deliver immediate solutions without sacrificing long-term development standards is truly invaluable.