Migrate Your Data Safely, Quickly, and Smarter with DATAshaper 1.7.3
🚀 Overview
We’re excited to introduce DATAshaper 1.7.3 – a release packed with new tools, smart upgrades, and important fixes to make moving your ERP data smoother, faster, and more reliable.
This version focuses on speed, clarity, and data quality. Whether you work in the business side, handle data every day, or manage migration projects, there’s something here to make your work easier.
🌟 New Features & Major Improvements
- Smarter, AI-Assisted Data Setup
- AI Automap for Legacy Mapping
Let AI do the heavy lifting by suggesting data connections automatically. Review and confirm them in seconds.
*Only available when AI use has been approved for your project.
- Automatic Quality Checks Based on Field Type
When setting up your data tables, DATAshaper now adds built-in rules for common types of information like email addresses, countries, languages, currencies, and websites. You can still adjust these rules as needed.
- Reference Fields & Dropdowns
Easily manage lists of approved values with built-in dropdown menus – available in both the main app and the Excel add-in.
- Better Data Connections & Reporting
- Dependency Tracking
Instantly see which records are linked to others (for example, all orders linked to a specific customer). This helps you clean and prioritise your data more effectively.
- Faster, More Efficient Reports
We’ve re-engineered how reports are stored and updated so you get results more quickly and with less waiting time.
- Table Setup & Data Validation Improvements
- Automatic Keys & Indexes
DATAshaper now creates important behind-the-scenes settings for your tables automatically, improving performance without extra manual work.
- Faster Processing of Large Data Sets
Data is now organised in smaller, more manageable sections for quicker results.
- Performance Enhancements
- Faster Mapping
The way mappings are grouped has been optimised, cutting down processing time.
- Partial Processing
You can now work with just the data you need instead of processing everything at once – ideal for smaller updates or event-driven changes.
- Overall Speed & Reliability
Background tasks and key screens now run faster and more smoothly.
- New Tools & Integrations
- Flexible Export Options
Export your data in multiple formats (CSV, Excel, JSON, XML, TXT, and more) and re-use your settings for future exports.
- Power BI Integration
View your Power BI reports directly inside DATAshaper, or add your own dashboards to your project.
- Data Lineage View
See exactly where a field’s data came from and how it was transformed – improving transparency and traceability.
- Improved Logging
Get clearer logs for automated tasks, showing both technical details and summary results side by side.
- Full Change History
Track who changed what and when – with the option to restore earlier settings if needed.
🛠 Other Enhancements & Fixes
- Clear Ownership of Issues: Every validation issue now has an assigned owner and person responsible for fixing it, improving accountability.
- Clustering Improvements: Choose the right data environment for each rule and easily replace special characters.
- Import/Export Reliability: Fixed edge-case errors involving table names, schemas, and validation during import.
- General Usability:
- Consistent dropdown menus and more intuitive workflows.
- Removed unnecessary “Are you sure?” pop-ups when nothing was changed.
- Fixed display issues such as overflowing tables and misaligned labels.
- Behind-the-Scenes Improvements:
- More efficient database connections.
- Automatic build numbers for API, Web, and Excel versions.
- Platform usage analytics.
- Better duplicate record handling.
🐞 Bug Fixes (Highlights)
- Resolved rare issues in data processing, clustering, imports, and automated tasks.
- Fixed crashes in dropdowns, pop-ups, and search boxes.
- Improved error handling in the Excel add-in for empty datasets, incorrect labels, and access permissions.
- Batch processing tasks no longer get stuck or fail to re-run.
📝 Known Issues & Recommendations
- SharePoint Source Support: The current method for connecting to SharePoint is outdated and not fully secure. We recommend avoiding it until a new version is available.
- Excel Add-In Performance: Large datasets may load slowly, especially when showing coloured highlights or checking for changes.
Tip:
- Filter your data before loading it.
- Use the “Download Issues” button to only bring in what you need.
- We are working on both improving Excel performance and exploring a faster, browser-based alternative.
