Case Study - XLSX ZIP to TXT ZIP
Archived a month ago
D
direct_x_34
Copy Paster!
Case Study - Process your Mockaroo-style XLSX datasets end-to-end with a single Spring Boot Application: XLSX ZIP ➜ TXT ZIP.
- ZIP ➜ ZIP Flow: Accepts a ZIP of XLSX files, processes them, and returns a new ZIP of TXT files.
- Mockaroo-Friendly: Converts multiple XLSX inputs into column-aligned TXT outputs.
- Column-Aligned TXT: Fixed-width TXT files that preserve column structure.
- REST API: Upload via /api/upload-zip (multipart) and receive an application/zip response.
- Log API: /api/logs/list for paginated & sortable logs with a clean JSON model.
- Error Semantics: Clear HTTP statuses (400, 500) and custom exceptions (InvalidZipContentException, ZipProcessingException).
- Spring Boot Based: Layered architecture with DTOs, entities, mappers, and room to extend.
- Docker & K8s: Ready-to-use container image and sample manifests.
- Observability & Quality: JUnit tests, Prometheus + Grafana metrics, and SonarQube code quality.
If you’d like to explore the details and review the code, check out the github repository via the link below.
Link: https://github.com/Rapter1990/xlsxziptotxtzip
