Membership import does not accept "tab" as import field separator but interprets it as the character “t”
In membership import, the help text mentions that users can enter
tab (literally those three characters) as “Import Field Separator” to configure it for tab-separated CSV files (see Screenshot 3 below). However, the system instead ends up using the single character
t as field separator, which leads to some funny column titles (see Screenshots 1 and 2). Copying an actual tab character into the “Import Field Separator” field works to let the system recognize tabs.
Interestingly, this bug is not present in contacts import, whose user interface looks exactly the same as the membership import.
- Click on Memberships -> Import Memberships.
- Use for example this tab-separated file test_bug_tab.csv as an example.
- Activate First row contains column headers
tabinto the field Import Field Separator
- Click Continue
As visible in Screenshot 1 and Screenshot 2 below, the cells (column titles and content) are split at every occurrence of the character
Cells (column titles and content) should be split at every occurrence of a tab. For example, the first column should be “id”, the second “Mitgliedsnummer”, and not “id Mi” and “gliedsnummer Ti”.
- Browser: Firefox 77.0.1
- CiviCRM: 5.26.1
- CMS: Drupal, WordPress
Screenshot 1: Tested on the Wordpress+CiviCRM 5 demo instance https://demo.tadpole.cc :
Screenshot 2: Tested on the Drupal+CiviCRM 5 demo instance https://demo.symbiotic.coop :
The https://demo.symbiotic.coop demo instance is not displaying its exact CiviCRM version number. Maybe they could add this?