Scheduled Job for importing a remote CSV file Fails with “Could not guess the delimiter”

[Hide_Kojima1]

Problem

When scheduling a Remote CSV Data Import, the job may fail with the following error:

Could not guess the delimiter.

Use `vroom(delim =)` to specify one explicitly.

This happens because the system cannot automatically detect the delimiter (such as a comma, tab, or semicolon) in your CSV file.

Workaround

To fix this, you need to manually specify the delimiter in the import dialog:

1. Open the Remote CSV Data Import dialog.

2. Select the correct Data Separator from the dropdown (e.g., comma, tab, semicolon):

   

3. Preview the data to ensure it displays correctly.

4. Click Update.

5. Republish the data to the server.

This ensures that the scheduler uses the correct delimiter during automated imports.