Troubleshooting Your CSV Export from Nureti

Published {$created} by Carsten Blum

Exporting your time tracking data to a CSV file is a core feature of Nureti, allowing you to analyze trends, integrate with other systems, and gain deeper insights into your team's productivity. However, like any data export process, things can sometimes go wrong. This guide addresses common problems encountered when generating a CSV export from Nureti and offers practical solutions.

Common CSV Export Issues & Solutions

1. Incorrect Date Range:

   • Problem: The exported CSV contains data from an unexpected timeframe.
   • Cause: You might have inadvertently selected the wrong date range when initiating the export. The date range selected directly impacts the data included in the CSV.
   • Solution: Double-check the start and end dates specified in the export options. Ensure they accurately reflect the period you wish to analyze. A good starting point is utilizing Nureti’s quick registration feature to gather quick, accurate timestamps.

2. Missing or Unexpected Columns:

   • Problem: Certain columns you expect to see (e.g., project name, task description, EU working time directive status) are absent from the exported CSV.
   • Cause: The selected export template may not include all desired fields. Custom fields created in Nureti might not be included by default.
   • Solution: Review the available export templates and select the one that best matches your requirements. If custom fields are missing, confirm they are enabled for export within the settings, or create a custom export template that includes them. Refer to the Nureti features page for a comprehensive list of available data points.

3. Encoding Problems – Garbled Characters:

   • Problem: The CSV file opens with strange characters instead of readable text.
   • Cause: The file encoding (e.g., UTF-8, ANSI) is incompatible with the application you're using to open it.
   • Solution: Try opening the CSV file with a different application (e.g., Microsoft Excel, Google Sheets, a text editor). When saving the file in your text editor, explicitly specify UTF-8 encoding. Some applications allow you to select the encoding when opening the file.

4. Incorrect Data Formatting:

   • Problem: Dates or numbers are displayed in an unexpected format within the CSV.
   • Cause: Regional settings or formatting options within Nureti might differ from the expectations of the application opening the file.
   • Solution: Adjust the date and number formatting options within your application. You might also try reformatting the CSV in a text editor and resaving it. Nureti’s advanced reporting features can also provide customized data views.

5. Large File Size & Performance Issues:

   • Problem: Exporting a large dataset takes a long time or causes performance issues.
   • Cause: The dataset is extensive, encompassing a substantial number of registrations.
   • Solution: Reduce the scope of the export by using a narrower date range. Export data in smaller chunks, if possible. For extremely large datasets, consider exploring API access to the data for more efficient processing. Check the pricing page for potential volume-based limits.

Staying Compliant with EU Regulations

If your business operates within the European Union, adhering to the EU Working Time Directive is crucial. Nureti is designed to assist with compliance. Using the EU working time directive compliance feature, you can configure your exports to specifically extract data relevant for demonstrating adherence to these regulations. Improper export settings can create audit challenges.

Getting Further Assistance

If you’ve tried these troubleshooting steps and still encounter issues with your CSV export, contact our support team. We’re happy to help you resolve the problem. Remember to clearly describe the issue and include details about your Nureti configuration and the application you're using to open the CSV file.