Questions tagged [csv]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
0 answers
22 views

Mismatched contacts SubTypes - Contacts will not be imported when Suptype is not the first Subtype

CiViCRM 5.65.1 on Drupal 9.5.10 PHP Version 7.4.30 When I import users from a CSV file to a certain contact subtype (I want to import or update data of all Supervisors) only those entries from the ...
Christoph Reuter's user avatar
1 vote
1 answer
99 views

CSV Download from a custom pop up

I have a function that lists score for a dog: <h3>Your Dog's Scores</h3> {crmButton href="#" class="button-name" title="Download CSV" icon="icon-class-...
Norm Dressler's user avatar
0 votes
1 answer
20 views

Contacts Import issue at CRM_Contact_Import_Form_MapField::getLocationTypeLabel

Not a question as such, rather an observation. WordPress contacts import from CSV, CiviCRM 5.61.2. (not reproduceable on dmaster). Uncaught TypeError: Return value of CRM_Contact_Import_Form_MapField::...
yurg's user avatar
  • 2,005
0 votes
1 answer
23 views

How to import contact via CSV and trigger CiviRule for Trigger "Address is added"

I set up a CiviRule that when an Address is added for a Contact some relationships are created depending on the zip code for that Contact. Now I create some Contacts via an import of a CSV file. I ...
mplh's user avatar
  • 121
1 vote
0 answers
26 views

web import fails because of empty "name" column in "civicrm_user_job" table

Drupal 9x, CiviCRM 5.56.0. Getting "Cannot execute queue "user_job_XXX". There is no associated UserJob." while contacts import from csv ( civicrm/import/contact?reset=1 ) Perhaps ...
yurg's user avatar
  • 2,005
2 votes
1 answer
107 views

Issue with API CSV importer and activity imports

WP 6.03, CiviCRM 5.51.3, API CSV importer 1.1. I'm attempting to import an activity via this extension since I need to include the assignee (which isn't included in the standard activity import). ...
Lesley Carter - BackOffice's user avatar
0 votes
1 answer
25 views

csv-import-helper extension not listed for installation

On my CiviCRM site (currently CiviCRM 5.42.1 on Drupal 7.82 & PHP 7.4.24 - I'm trying to get an upgrade process together for this site), the /admin/extensions page doesn't seem to list the csv-...
Ken Williams's user avatar
0 votes
1 answer
30 views

Using CSV file as datasource

I was trying to use the CSV file as a datasource but couldn't find documentation on how to form the URI. Having the CSV file hosted and using the URL https://... to refer to the csv doesn't work as ...
Clement Leong's user avatar
2 votes
1 answer
69 views

Custom Fields and new version of csvimporter aka API csv Importer

I installed CiviCRM 5.41.0 and csvimporter 1.7. My overall goal is to import data from csv files. I created some custom fields, imported the standard fields using the standard importer and then ...
EricHow's user avatar
  • 21
1 vote
1 answer
52 views

Is there a way to include group and tags on a contact report

I built a report off of the Constituent Summary report and I am wondering is there a way to include groups and tags in that report that will export as a csv? Also why are some reports only exportable ...
emptyhometax's user avatar
1 vote
2 answers
68 views

CiviBanking: CSV importer not reading the config as expected

Unfortunately, even after several attempts, we have not managed to configure the CiviBanking plugin so that the csv file can be imported. We use a file from "Deutsche Skatbank" but the ...
mgb-it-ag's user avatar
0 votes
1 answer
46 views

What does 'Number of Items to Process For Each Queue Item' mean when using the API Importer extension?

I'm using Civi 5.35 and Drupal 7. We've installed the API CSV Import extension. At ~/civicrm/index.php?q=civicrm/csvimporter/import , I see a place to enter "Number Of Items To Process For Each ...
Joe McLaughlin's user avatar
1 vote
1 answer
68 views

Export of custom multiple choice options to CSV files limited to 32 characters

A user is trying to export data from an advanced query on custom fields to a CSV file using the "Export contacts" action. This fails with a backtrace which is attached below. The error ...
Bond Keevil's user avatar
2 votes
1 answer
75 views

API csv Import GUI with Formprocessor fails with smarty errors

I created a rather complicated form processor which works (through api), but when I tried to clone it (rename it to create so csv api picks it up) and tried to do the csv import. I get the following ...
Marko's user avatar
  • 877
2 votes
1 answer
15 views

Importing Contacts from Access

I understand I need to convert a table into a csv file, but the contact table in question has both an individual and their spouse in the same record. Now I can build a query that would only show me ...
Arlyn Henken's user avatar
1 vote
1 answer
145 views

Exporting Contacts to a .csv file

How do I export all contacts to a .csv file?
Linda Stevenson's user avatar
1 vote
1 answer
90 views

I need some help resolving db error:unknown error CSV Import helper when selecting a CSV from my desktop

I prepared a CSV for upload. I'll have to make multiple passes on the upload because I have single entry items and multiple entry data in the spreadsheet. I have created all of my custom fields. I ...
LyonsDigital's user avatar
1 vote
1 answer
43 views

Current employer not exporting to CSV

I have tagged a group of contacts and am exporting them to a CSV file. When I do this, of the 30 contacts only about 25 show the current employer in the CSV file. I checked the remaining five and they ...
Phillip Money's user avatar
-1 votes
2 answers
44 views

CiviCRM isn't recognising CSV files as CSV files

How do I fix this? It's urgent! When I try to upload a CSV file, CiviCRM does not recognize it as such.
Augustus Oktavius's user avatar
3 votes
2 answers
79 views

Extracting a report/pulling a search result to CSV but setting an exported flag to indicate this

I am looking for a way to mark data as exported in some way. The scenario is that we are receiving and capturing data for enquirers (people making enquiries) on behalf of a third party. The 3rd ...
Hywel's user avatar
  • 31
2 votes
1 answer
55 views

Import Contacts from CSV

I am attempting to import a csv file that is both regular comma delimited and I have also tried one saved as CSV UTF-8 (Comma delimited). Each time I go through the steps, I get through the match ...
James Creen's user avatar
3 votes
0 answers
26 views

CSV GUI Import to api -- Set 'Last update date'?

I'm importing with "CSV GUI Import to api" extension about 6500 contacts. Is it possible to set 'Last update' date during the import from an in the original database existing data field's value? I can'...
Pál Rudan's user avatar
2 votes
0 answers
70 views

What permission allows a listing to be exported to a csv file

I can't seem to locate the permission that allows a report listing to be downloaded to a csv file. The Actions are present but they don't function. They work on some roles but I haven't been able to ...
Martin Fuggle's user avatar
0 votes
2 answers
117 views

How to export civievent participant list to a csv file?

How can I add the ability to export to a csv file? Right now the only export option on the actions menu is to a Microsoft Excel file.
kzburn's user avatar
  • 363
0 votes
2 answers
49 views

How can I export an Event Income Detail report to CSV/Excel?

We find the Event Income Detail report to be useful. But the Actions menu won't let me export this report into a CSV file for some reason. How can that be enabled?
Graham's user avatar
  • 4,025
3 votes
1 answer
209 views

How do I export my contacts as a .csv or .txt file?

How do I export my contacts as a .csv or .txt file? I need this for my records and can not find where I can do this. Please help. Thankyou.
noni's user avatar
  • 31
4 votes
2 answers
160 views

How to deal with problem data when importing CSV

My first time trying to import CSV data into CiviCRM. The data looks something like the below (changed to not reveal actual names etc). The lines in bold are not importing. I am guessing that in ...
user1147171's user avatar