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
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 Data Insights
Service

Data Insights

With Data Insights, we help you step by step with the appropriate architecture to use new technologies and develop a data-driven corporate culture

Produkt 2/25/25

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.

Produkt 2/25/25

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.

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.

Two people discussing in front of a computer
Lösung 2/25/25

The COBOL Survival Team for IBM i (AS400)

COBOL developers on IBM i (AS400) are a rare commodity. PKS provides a powerful team especially for this application!

Headerbild zu Cloud bei Versicherungen
Branche

Paths to the cloud for insurers

Cloud ist die Blaupause für eine moderne Nutzung von IT-Ressourcen. Doch traditionell scheuen viele Versicherer den Weg in die Cloud. Befürchtet werden Kontrollverlust oder fehlende Sicherheit für vertrauliche Daten. Doch all dies sind Themen, die technisch und organisatorisch gelöst sind. Es überwiegen die Vorzüge einer flexiblen und kostengünstigen Architektur.

App 2/25/25

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.

Kollaboration mit dem modernen Helpdesk
Produkt 2/25/25

Backup and recovery solutions for the cloud - HYCU in focus

Experience the ultimate cloud experience with the strong partnership of CLOUDPILOTS and HYCU. Our pioneering solutions are designed to meet all your cloud needs.

Teaserbild zu IT-Strategie Beratung
Service

IT strategy – A clear goal and the way to achieve it

The IT strategy provides you with the plan for the long-term development of your IT organisation, necessary technologies, processes and digital culture.

News 1/10/25

A new chapter for catworkx US

catworkx is excited to announce a new chapter in the USA: Nick Howser is our new CEO! With over 13 years of experience in the Atlassian ecosystem and a strong focus on customer success, Nick will continue to drive growth in the US.

App 2/25/25

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.

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.

Icon Trello
Produkt 2/25/25

Trello

Flexible project management that makes collaboration enjoyable

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.

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.

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.

Headerbild zu Intelligente Dokumentenverarbeitung / Intelligent Document Processing
Service 8/11/21

Intelligent Document Processing (IDP)

Intelligent Document Processing (IDP) involves the capture, recognition and classification of business documents and data from unstructured and semi-structured texts.

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.

Logo Atlassian Confluence
Technologie

Confluence from Atlassian

Create, organize, and collaborate on tasks - all in a single place. Confluence is a workspace for teams and organizations where you can store your documentation and collaboratively develop and share knowledge. Dynamic pages give your team a place to create, capture, and collaborate around projects or idea development.

Bleiben Sie mit dem TIMETOACT GROUP Newsletter auf dem Laufenden!