Skip to content
  • There are no suggestions because the search field is empty.

Troubleshooting CSV Import Issues: Language & Batch Size

This article explains practical steps to troubleshoot CSV import issues and improve success when importing large numbers of tasks or CRM records.

Summary

  • If a CSV import does not import all records, verify the system language used during import and reduce the import batch size to avoid timeouts caused by address geocoding.

Common causes and checks

  • System language mismatch: Ensure the system language used during the import matches the expected language for the import process.
  • Import size and timeouts: Large imports can trigger timeouts because the system performs geocode calculations for addresses. Large numbers of records increase processing time and can cause incomplete imports.

Step-by-step troubleshooting

  1. Re-run the import with the correct system language

    • Before starting the import, set the application/system language to the language required by the import process (for example, German).
    • Run the same CSV import again and verify whether more records are imported.

  2. Reduce the number of rows per import

    • Split large CSV files into smaller batches and import them separately.
    • Use batches of approximately 2,500 records or fewer when importing tasks or CRM records to reduce the likelihood of timeouts during geocode calculations.
    • Monitor each batch to confirm successful import before proceeding to the next.

  3. Retry failed or partial imports

    • If an import completes only partially, split the remaining records into smaller batches and re-import.
    • Confirm system language and batch size before retrying.

Troubleshooting tips

  • If you suspect a timeout (large file, slow progress, or only a portion of records imported), reduce batch size and retry.
  • Always verify the system language setting immediately before starting an import.
  • Import a small test file first to confirm language and format settings are correct before running larger batches.

Conclusion

  • To maximize success when importing CSV files with address geocoding: ensure the correct system language is selected for the import and limit each import to smaller batches (around 2,500 records) to avoid timeouts and incomplete imports.