Changing the default delimiter in exported CSV files

Created on 1 December 2016, almost 8 years ago
Updated 27 March 2024, 8 months ago

Hello,

I use this module to export contents of a particular Content type as a CSV file, using a Serialized view. There is no way to change easily the default CSV columns delimiter, which is a comma.

When trying to import (with the Migrate Source CSV module) contents from a CSV file that uses other delimiters, the migration insert sql query use a malformed string as the 'source id' field (concatenation of all the content fields datas) which is far too long for the sourceid1 (varchar 255) field of the mapping sql table.

The result of this is a PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'sourceid1' at row 1 issue in the terminal (using drush).

That will be great if we could change this view default delimiter (in the View format settings maybe), to match with the delimiter used in the imported CSV file.

✨ Feature request
Status

Closed: outdated

Version

1.0

Component

User interface

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Production build 0.71.5 2024