Automated Department Registration and Secure File Workflow (Excel-to-CSV) for JERA
This project involved developing a multi-lingual department application using the Joget low-code platform to automate the entire process of user registration, file submission (of business data in Excel format), approval workflows, and secure storage. The core functionality included the automatic conversion of submitted Excel files to CSV format and the secure transfer of these approved files to Azure Blob Storage via a Boomi API integration. The system was crucial for enhancing data integrity and simplifying administrative processes for a large global user base.
Client Overview
The client is JERA, Japan’s largest power generation company. Facing challenges with manual file handling, data duplication, and the need for seamless multilingual support (Japanese and English) for their large, diverse workforce, JERA required a reliable, automated system for internal department submissions.
Technical Stack
Industry
Energy, Power Generation & Utility
Region
Japan
Project-size
Non-Disclosable
Company size
Large Scale Company
Implementation Highlights
Implemented multilingual support (Japanese/English) using Joget’s i18n feature to cater to a diverse, global user base.
Integrated the Boomi API to ensure secure and reliable transfer of approved files from the Joget platform to Azure Blob Storage.
Developed a custom, instantaneous Excel-to-CSV conversion tool within the application to ensure format compatibility with external systems.
Created a one-level, email-notified approval workflow that tracks actions with timestamps for a full audit trail.
Applied custom validation rules to prevent data duplication upon file submission, ensuring data integrity.
Challenges & Solutions
Managing file transfers securely to external cloud storage and ensuring file format compatibility.
Solution: Integrated the Boomi API for secure file transfer to Azure Blob Storage, combined with an automatic, instantaneous Excel-to-CSV conversion process.
Preventing data duplication during submission and accommodating a multilingual user base.
Solution: Applied custom validation rules to flag and prevent duplicate records. Implemented Joget’s i18n feature for seamless Japanese and English language support.
1000+ Projects Experienced
Access Iqra Technology’s skilled developers and experts. Enjoy a risk-free two-week trial and take advantage of our cost-effective solutions.
8+
Years of Business
Experience
100+
Happy
Customers
15+
Countries with
Happy Customers
100+
Agile enabled
employees
Results & Impact
- Achieved 100% automated registration, submission, and approval workflow, minimizing manual intervention and errors.
- Guaranteed data integrity by enforcing custom validation rules against duplication.
- Ensured real-time communication via email notifications and provided a complete audit trail with timestamped approvals.
- Enabled a smooth user experience for Japanese and English-speaking employees, promoting cross-team collaboration.
Key Learnings & Next Steps
- Emphasized the importance of scalability and flexibility in systems like Joget to accommodate growing organizational and diverse user needs.
- Reinforced the necessity of custom validation rules for maintaining data integrity and preventing duplication in submission processes.
- Expand the approval flow to multiple levels, add support for more languages, and enhance reporting/analytics features to provide deeper insights into submission patterns and approval timelines.
