Coding Global Background
Coding Global

Case Study - XLSX ZIP to TXT ZIP

Archived a month ago
1 messages
2 members
2 months ago
Open in Discord
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

Replies (1)