Imagen de proyecto de REF-TEC 1

Ref – Tec

Ref–Tec | Platform for managing and publishing technical project references

Centralized system to classify, validate, search, and export project fact sheets to PDF, Word, and Excel.

Client

INYSA

Icono de sector

Sector

Engineering / Technical Consulting / Professional Services

Icono de tecnología

Technology

Classic ASP

Icono de servicios

Services

Platform for managing and publishing technical reference sheets

CONTEXT


The client needed an internal system to organize and leverage its historical portfolio of technical project references. The goal was to standardize information, streamline commercial searches, and generate consistent documentation to support proposals and internal communication. The project emerged as part of a broader internal digitalization effort, aimed at improving control, classification, and publication of project fact sheets. Over time, the system became a key asset for activating the company’s internal knowledge—enabling its reuse across commercial, technical, and proposal processes

THE TECHNOLOGICAL CHALLENGE


From a CTO perspective, the challenge was to build an internal web application capable of importing data from CSV sources (Navision / Dynamics 365), validating and classifying it, enriching it with documentation, and publishing it in multiple formats—while ensuring permission control and full change traceability. All of this needed to run on the client’s existing environment (Windows / ASP and relational databases), guaranteeing stability, performance, and operational continuity within the corporate intranet.

Key challenges:

1

Importing and validating data from CSV sources (Navision / Dynamics 365)

2

Classification, enrichment, and publication with multiple output formats

3

Permission management and full change traceability

4

Advanced multi‑criteria search across primary and secondary reference sheets

5

Hierarchical content approval workflows prior to final publication

6

Export to Word, Excel, and PDF with consistent corporate branding

7

Integration with the client’s existing environment (Windows / ASP, relational databases)

8

Guaranteed stability, performance, and operational continuity within the corporate intranet

TECHNICAL AND BUSINESS OBJECTIVES


Icono de automatizar

Optimize the registration, validation, and publication of technical projects

Reduce time spent searching, classifying, and preparing commercial reference sheets

Icono ofrecer capacidad

Improve the consultation experience with homogeneous listings and visual project sheets

Enable automatic generation of commercial documentation in PDF, Word, and Excel

SOLUTION DELIVERED


An internal web platform for managing technical references was developed using an evolutionary monolith architecture, with functional modules to import, classify, validate, search, and export reports. The platform incorporates a staging database for review and a final database for publication, supported by role‑based approval workflows, editing, previewing, and document generation.

Keys aspects of the solution:

  • Evolutionary monolith architecture with decoupled functional modules
  • Time base + definitive base: enabling pre‑publication review
  • Iterative, product‑oriented approachwith editing and preview views
  • Role‑based approval workflows with hierarchical validation
  • Integrated generation of commercial and technical documentation
  • This is not just an application—it is an operational foundation that activates accumulated technical knowledge
  • Reusable knowledge across multiple areas of the organization (commercial, technical, and communications).

TECNOLOGIES USED


Icono de backend

Backend: Classic ASP, JavaScrip

Icono de frontend

Frontend: HTML, CSS, JavaScript

Icono de infraestructura

Infrastructure: Windows, Internet Information Server (IIS)

Icono base de datos

Databases: SQL Server

Icono de integraciones

Integrations: CSV (Navision / Dynamics 365), PDF generation, Word/Excel export, email delivery via CDONTS

Icono de seguridad

Security/DevOps: : Network Permission Control

WORKING METHODOLOGY


Icono de metodologia estructurada

Structured methodology: analysis, design, development, and validation

Icono diseño

Design approval prior to final implementation

Icono de desarrollo agil

Parallel visual and functional development

Icono reducir costes

Progressive deliveries leading to a fully tested final version within the agreed timeline

Icono de adaptación constante

Ongoing technical support, dedicated advisory, and post‑launch assurance

RESULTS ACHIEVED


  • Centralized system with homogeneous classification and advanced search capabilities
  • Commercial‑ready documentation outputs (PDF, Word, Excel)
  • Hierarchical approval control—no changes published without validation
  • Generation of comprehensive reference sheets and reports with attachments and images
  • Significant reduction in time required to prepare commercial proposals
  • Improved consistency of generated documentation
  • Increased reuse of historical project references in new business contexts

ADDED VALUE:


The project’s key differentiator was designing a solution that aligned technical, operational, and commercial processes within a single platform— eliminating information silos and transforming the system into a true business tool rather than a simple database.

What made the difference:

  • Alignment of technical, operational, and commercial workflows in one platform
  • Structured staging and production layers with traceable approval workflows, eliminating the dispersion of information.
  • Consistent, visually unified project sheetsoptimized for commercial use
  • A system that not only solves an operational need, but provides a solid foundation for improving commercial efficiency and knowledge management

Does your vision need a technology Partner to become a reality?

We can help you. Together we’ll build the strongest possible roadmap.

Imagen de apretón de manos de socios
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.