🧹Validation results, reports and logs
In the previous articles, we successfully uploaded a database, mapped columns, and set up our cleaning rules. Now we move on to the grand finale. We will show you how to safely start the process, interpret visual reports, and most importantly – how to read the resulting cleaned file.
Summary, price estimate and launch
In the final step (Order), you will see a clear summary of what is about to happen. Even before sending the first request, the app will exactly calculate the estimated price in credits and show the time required. The precise estimate clearly breaks down the costs for individual services (e.g., names, addresses, phones).
If you haven't done so in the advanced settings, paste your API key from the Foxentry administration into the API key field now. Then, simply click the button to start the validation.
💡 Safely pausing and resuming work
Are you processing a massive file and need to turn off your computer? No problem. The process runs safely and writes data sequentially. If you close the app (or the browser window) at any time, you can start the process again later. The app will automatically resume exactly where it left off, and will not deduct credits again for already processed rows.
Visual cleaning report
Once the process is finished, the app instantly generates a clear HTML report and saves it in the results folder. Here, you will see a total summary at a glance and the "Foxentry impact" – you'll find out by what percentage the error rate of your database was reduced and how many records the system saved from being discarded thanks to automatic correction. You will also find clear charts of the final statuses for individual services.
How to read the resulting file
The Cleaner never overwrites your original input file. The result is saved in the output/ subfolder in the exact same format as the original (the original CSV remains a CSV, an Excel table remains an Excel table).
All your original columns remain completely untouched. Right next to them, the app adds new columns with the results. For each mapped group, you will see these new columns:
_result: an understandable text status of the record (e.g., valid, corrected, invalid),_updated: the value after a potential correction. If Foxentry fixed the value (e.g., a typo in an e-mail), you will find the clean version right here. If the value was correct, it equals the original,_suggestion: an alternative suggestion. If the value is invalid but the API found a likely candidate, it will be listed here,_note: a detailed error message (e.g., an explanation of why the address or phone is invalid).
💡 Data processing tip
We recommend sorting your original column and the new column ending in _updated side by side. This way, you'll immediately see which specific letters or details Foxentry corrected. For records marked with the status invalid (suggestion exists), check the value in the _suggestion column and decide for yourself whether you want to accept the fix manually.
Enriched data (full datascope)
If you enabled extended data enrichment for selected services in step three, Foxentry will append additional separate columns to the very end of the table. Depending on the validated service, you will find rich extra information here – for names, it can be the split first name and surname, the correct vocative case, or gender. For companies, you will get, for instance, the full NACE activity code and VAT status, while addresses will be supplemented with GPS coordinates, region, district, and other administrative details.
Technical logs for easy auditing
Foxentry Data Cleaner also offers a detailed request log viewer. By default, log saving is turned off to protect data and save disk space. You can easily turn it on using the checkbox at the very bottom of the Order page (step 4).
If you turn on logging for a given run, the complete request sent to the API and the full response from the server will be saved (your API key in the header remains masked for security reasons). You can then view these records in a clean interactive viewer (click the Logs button in the top bar). You can filter them by status codes (e.g., 2xx, 4xx, 5xx), search for faulty records, and examine the received JSON data in detail.
We hope this three-part series has helped you with a quick start. With Foxentry Data Cleaner, you now have a powerful and fully secure tool at your disposal to keep your customer database always up-to-date, error-free, and fully ready for further marketing activities.
