Automation lays foundation for smooth archive changeover for Rottendorf Pharma GmbH

Since 2015, companies have had a legal email retention obligation. This means that email archiving is no longer just part of professional risk management - companies are primarily complying with legal requirements. If a company wants to change its archiving system in compliance with the law, it is mandatory to restore the original emails with the attachments from the archive. For Rottendorf Pharma GmbH, the ECM experts of TIMETOACT GROUP have attached all file attachments from the archive to the corresponding e-mails in the mailing system. This was done automatically and with little manual effort using the specially developed Notes tool "ArchiveUsers".

Initial situation:

  • Decision to switch to a new archiving system
  • High manual effort required to switch without data loss

Core requirement: Automated reattachment of archived files from the archive to the corresponding e-mails

  • Use of "ArchivUsers" as a tool developed in-house by TIMETOACT on the basis of Notes
  • Automated recovery of original mails with low manual effort and transparency

Added value:

  • Full service by TIMETOACT
  • Reattachment of attachments from the Notes archive to the corresponding e-mail in the mail system
  • Report of successfully recovered attachments and attachments that cannot be recovered (error listing)
  • Low manual effort on the part of Rottendorf Pharma GmbH

It was the right decision to commission TIMETOACT GROUP again. Our positive experience has been confirmed once again and we are very satisfied with the result.

Project Manager at Rottendorf Pharma GmbH

Linking of 4.5 terabytes of archived file attachments

When using e-mail archiving, attachments to mailings are stored in a separate archive system and made accessible by means of a link. In addition to meeting legal requirements, companies also protect themselves against e-mail data loss and save storage space on the mail server. Rottendorf Pharma GmbH uses the "ContentManager" archive for this purpose, which contains file attachments from the mailboxes of over 800 users. Communication between the e-mail system and the archive is ensured by the product CommonStore for Lotus Domino (CSLD).

As part of a newly established digitization strategy, the pharmaceutical company decided to switch to a different archiving system. The problem: When switching, the interface between the e-mail system and the archive is lost, and with it the connection of the archived file attachments to the corresponding e-mail. To prevent this loss of data, a high level of manual effort is required.

The core requirement

The core requirement to enable Rottendorf Pharma GmbH to smoothly switch to a new archiving system was to re-attach archived files from the archive to the corresponding emails with as little manual effort as possible. This involved a total of 4.5 TB storage volume of file attachments.

Automation and transparency in the project

In addition to restoring the original emails, it was particularly important to us that the project be carried out as automatically as possible.

Employees at Rottendorf Pharma GmbH

This included keeping the manual effort on the part of the pharmaceutical company as low as possible. In addition to automatic execution, transparency also played a major role in the project. Although the overall control lay with the TIMETOACT GROUP, employees of Rottendorf Pharma GmbH should have the possibility to inform themselves about the progress of the project easily and quickly at any time.

The in-house development "ArchiveUsers" reduces the overall effort

The experts at TIMETOACT GROUP have already mastered the challenge of reattaching all attachments from the archive to the corresponding e-mails in numerous customer projects. For this purpose, the tool "ArchiveUsers" was specially developed on the basis of Notes for the automatic recovery of the original e-mails with a comfortable administration interface. The interface enables both the developers of TIMETOACT GROUP and the customer to keep an eye on the progress of the project.

What is ArchiveUsers?

ArchiveUsers is an in-house development for mail migration from Notes. The toolset serves as a basis for a new customer situation and is then adapted to the customer's individual requirements. The tool enables batch processing of mail databases and ensures error-free and complete mail migration.

Full Service of the TIMETOACT GROUP

Rottendorf Pharma and TIMETOACT GROUP have been working together since 2013. In an initial project, the Cologne-based IT group already provided support for data migration between different storage systems. In 2018, the "ArchiveUsers" tool was used for the first time in the recovery of mail attachments from the archive. Two years later, the same toolset was used to reattach the file attachments of the remaining source mails of the pharmaceutical company in Germany.

TIMETOACT GROUP took over the support and control of the entire process. With the help of the "ArchiveUsers" tool, all file attachments were reattached to the original emails without data loss. Successfully recovered data was deleted from the archive, which on the one hand resulted in more space being available again in the archive memory, and on the other hand made it possible to check whether all attachments had been transferred. Due to the many years of experience on the subject of e-mail archiving, the full service also included the processing and solution of any problems that arose. Since there were some documents that could not be reattached with "ArchiveUsers", employees of the pharmaceutical company occasionally had to decide manually which file attachments were still needed.

In summary, the following were implemented as part of the project:

  • Reattachment of attachments from the Notes archive to the corresponding email in the mail system.
  • Report of successfully recovered attachments
  • Report of attachments that could not be recovered (error listing)
  • Overview of mailboxes and number of archived and recovered attachments
  • Automatic error correction in case of errors in the database and in the archiving software
  • Automatic e-mailing to users with a list of documents to be manually cleaned up

Rottendorf Pharma is one of the leading contract manufacturers and developers and has been active for more than 90 years in the production and packaging as well as the development of formulations and analytical processes for solid oral dosage forms for the international pharmaceutical industry. The company produces more than 600 original and generic drug products annually. These include large, small, virtual and global pharmaceutical and biotechnology companies.

Feel free to contact me!

Frank Trila
Teamleiter Enterprise Content Management TIMETOACT Software & Consulting GmbH
App 8/9/22

Teamworkx Issue Publisher for Jira

Whether project documentation, knowledge management or quality manual - with the "Teamwork Issue Publisher for Jira", Confluence pages can be automatically published and updated from Jira.

App 8/9/22

Teamworkx OTRS Integration for Jira

The app "Teamworkx OTRS Integration for Jira" is an integration module with which processes can not only be automatically transferred from one system to another, but also synchronized.

Headerbild zu IBM Cloud Pak for Automation
Technologie

IBM Cloud Pak for Automation

The IBM Cloud Pak for Automation helps you automate manual steps on a uniform platform with standardised interfaces. With the Cloud Pak for Business Automation, the entire life cycle of a document or process can be mapped in the company.

Headerbild zu Managed Services
Service

Managed Services & Support

Our Managed Services ensure that applications are operated for you with a holistic understanding of infrastructure, licenses, support, applications and the corresponding expertise. This is done regardless of whether the application is to be operated at a hyperscale such as IBM Cloud, Google, AWS, Azure or onPrem.

Headerbild zu Digitalem Ökosystem
Service

Fit for the digital ecosystem

Insurers are digitally networking with their ecosystem to gain critical capabilities in a division of labor. Personal data, object data are securely exchanged via common digital interfaces.

Teaserbild Enterprise Content Management (ECM) Beratung
Service

Enterprise Content Management (ECM) & Archiving

With Enterprise Content Management (ECM), all data, information and documents are stored, archived and managed in a context-related manner on a single platform. ECM systems offer numerous advantages for managing the increasing number of (un)structured electronic documents and data.

Wissen 4/30/24

GPT & Co: The best language models for digital products

Our analysis based on real benchmark data reveals which solutions excel in document processing, CRM integration, external integration, marketing support and code generation. Find your ideal model!

Wissen 4/30/24

GPT & Co: The best language models for digital products

Our analysis based on real benchmark data reveals which solutions excel in document processing, CRM integration, external integration, marketing support and code generation. Find your ideal model!

Service

Enterprise Content Management (ECM) & Archiving

With Enterprise Content Management (ECM), all data, information and documents are stored, archived and managed in a context-related manner on a single platform. ECM systems offer numerous advantages for managing the increasing number of (un)structured electronic documents and data.

Referenz

Electronic archiving system at EDEKA Südwest

After the independent merchants, we took care of self-operated grocery stores: In the meantime, TIMETOACT GROUP has digitized business records for 1,200 stores of EDEKA Südwest.

Headerbild zu Cloud bei Versicherungen
Branche

Paths to the cloud for insurers

We accompany insurance companies on their secure path to the cloud ► Flexibility ✓ Innovation ✓ Cost and performance benefits ✓ Contact us now.

Produkt 4/11/23

Campaign management software for use in the cloud

Strengthen your innovative power with target Campaign Management - our campaign management tool for your successful innovation campaign.

Process Integration & Automation
Service

Process Integration & Automation

Digitizing and improving business processes and reacting to changes in an agile way – these are the challenges that more and more companies need to face.

Service

Decision Automation

We offer a comprehensive service in the field of decision automation, ranging from consulting and design to implementation and operation

Referenz

Digitized processes increase efficiency

TIMETOACT & X-INTEGRATE accompany energy supplier e-regio on the way to digitalization. The consulting services in the project included the fields of content management, archiving, collaboration and automation.

Training

Jira Automation (Cloud)

Over the course of the Jira Automation training participants will learn how to reduce project complexity through well-designed automations. With automation in Jira Cloud, you can create automation rules based on dozens of triggers, increasing the value of Jira and empowering your entire team to manage process consistency and productivity.

Blog

Your secure solution for the digital working world

Google Workspace: The secure alternative in today's threat landscape!

Headerbild zur Logistik- und Transportbranche
Branche

AI & Digitization for the Transportation and Logistics Indus

Digitalisierung und Transparenz der Prozesse sowie automatisierte Unterstützung bei der Optimierung können Logistikunternehmen helfen, den Spagat zwischen Kosten und Leistung besser zu bewältigen, um langfristig als wertvoller Partner der Wirtschaft zu agieren.

Produkt 4/11/23

Idea management software for use in the cloud

With our idea management tool target Idea Management (Cloud), we are expanding the functions of our on-premise solution with a hybrid cloud add-on.

Referenz

The digital customer file with IBM Content Manager

The prefabricated house specialist SchwörerHaus KG has relied on IBM technology for many years to set up a digital customer file.

Bleiben Sie mit dem TIMETOACT GROUP Newsletter auf dem Laufenden!