Field Service built a data export tool that exports everything

“We just need it until SAP is updated.”— Ravi, Field Service

Reason:

Because the CRM needs 23 clicks and two approvals to add a supplier. With 2 users, one of whom is the CEO.

Built by:

Ravi, an analyst

Build time:

a long Thursday

Built with:

a no-code builder on a personal account

Database:

a production table with no primary key

Authentication:

the API key has existed since the prototype

Deployment:

deployed by copying files over RDP

Responsible:

Elena, who only knows the frontend

Documentation:

comments in the code, in a second language

Security situation:

passwords are "encrypted" with Base64

Future disaster:

It will be described as "legacy" before its first birthday.

Age: 3.5 years · originally expected to last 3 months · 2 owners so far · survived 1 reorganisation · last meaningful change 823 days ago

Rated common mostly because: 4 departments depend on it, alive 14x longer than intended, €7k per year.