Comma Separated Variable is a file format usually used for storing tabular data.

learn more… | top users | synonyms

1
vote
1answer
50 views

How do I programmatically export all webform submissions into a single csv? (multiple webforms)

I have hundreds of webforms created from a single webform template. How do I programmatically export all webform submissions into a single csv? Note that this is not possible via views out of the box. ...
0
votes
1answer
16 views

jQuery csv file export fires multiple times

I have a custom form, and I just want a button in the form that fires a jQuery plugin that generates a csv file for download. The problem I'm having is that it seems to fire multiple times for some ...
0
votes
1answer
22 views

Where is the target ISBN in feeds module?

I'm using an ISBN module that create a simple textfield with "ISBN" as a type (this module makes validation of the books ISBN when inserted on the textfield when creating a book) It's a pretty cool ...
0
votes
1answer
15 views

I'm looking for a way to force the migration to process entries with identical keys

The full scenario is as follows: We have two entities (Foo and Bar). Foo has a multi-value entity reference field to Bar entities. The migration source outputs each Foo-Bar pair in a single CSV line ...
0
votes
0answers
20 views

Feeds module doesn't return a field in the target list

i'm using feeds module to import csv. My csv is mapped to a custom content type i've created before, all fields are mapped except a field, the one corresponding to an ISBN module i've used too, this ...
0
votes
1answer
21 views

Feeds Import Alter for Multiple Fields

I am trying to setup a Feed Import from CSV. There is an images field in the content type which can have unlimited values. These images are in a folder and named in the following format: ...
0
votes
1answer
23 views

How to skip creating records with blank fields when migrating from csv file?

I have created a migration with the Migrate module that migrates data from a csv file into a custom entity. There are some rows in my csv file that don't have any data for the entity that I'm ...
3
votes
3answers
113 views

How to create a CSV file to migrate my Commerce Products with the Feeds module?

How do you create CSV files? I have a new Drupal Commerce website and I want to migrate all my products from my previous Drupal 7 Commerce site. I want to use the Feeds module to import my products. ...
0
votes
1answer
30 views

How to convert taxonomy term name to term id at time of importing and create custom node from csv in drupal?

I am creating content type programmatically. I am importing content from csv file.. Everything working fine. But I am not able to select category at the time of import like other fields.. and how to ...
0
votes
0answers
22 views

Taxonomy CSV Import will only import 6 rows at time?

I'm using the Taxonomy CSV Import/Export module (v 5.10) to import about 300 terms. When I give it the CSV (either pasted in the text box or uploaded), it successfully imports about 6 to 9 rows and ...
0
votes
2answers
113 views

How to import a Text File from feeds CSV and map it to a File upload field with multiple values?

EDIT: This issue is directly related to how the Acquia hosting Platform handles private files, not webforms / feeds or feeds tamper. I've got a site where I need to Migrate the users from a ...
2
votes
1answer
21 views

Import csv to cart [duplicate]

Is there a way to import from a cvs (or similar) to the cart? The csv could be very simple: sku and quantity. I'm using Drupal 7 with commerce. Thanks!
1
vote
0answers
51 views

Generate an order from a csv

I'm using Drupal 7 with commerce. Is there a way to generate an order from a csv or similar? the idea is that users could upload a csv (sku and quantity for now) with the items they want and the ...
1
vote
0answers
19 views

Import Feeds module & Tamper in combination with atypical csv file

I'm trying to do an import from a csv file using import feeds & tamper modules. I'm in a bit over my head though. The feed I need to import uses an atypical format. Instead of having a traditional ...
1
vote
1answer
21 views

How to create a query about users in a Drupal Commons group including their location (State)?

I need to create a MySQL query that will allow me to view the users in a specific Drupal Commons group and include their USA State location. I would like to be able to export this to a CSV file. Any ...
1
vote
1answer
165 views

How to display the value of a report parameter in a Forena Report and in a CSV export of it?

Using Forena Reports I'm wondering if it's possible to include in a report the PARAMETERS passed by the URL? I'd just like to output those parameters once in the report; probably at the top. ...
1
vote
1answer
139 views

How to add a link to the CSV download to my module page, for a report created with Forena?

How do I add a link to the CSV download created by the Forena module to my module page? Do I just copy the link in 'inspect element' and put that in my $output variable that I return on the ...
2
votes
1answer
282 views

How to transform the CSV link in the Views Data Export module in a non-image link display?

I'm using the Views data export module for my search interface so users can click a link to download the search results. It's working and displaying. But it's not pretty. My Data Export has the ...
1
vote
1answer
61 views

How to allow users to export data from custom module to a CSV file?

I have a custom module that's a multi-page form that collects one value from a user for each page of the form (3 pages, 3 total values collected). On the final page of the form (the recommendations ...
1
vote
1answer
121 views

How to get plain link with views-data-export module in CSV?

I have a view with field that provides a simple link to the content. Problem: When I export the data into a csv file there is only the word link instead of a link. How can I get there the content ...
1
vote
1answer
57 views

How to import Product Kit via CSV file?

I am trying to import product kit from CSV file but I am not getting how to import it as I need to link with products in product kit. I am using Ubercart, Feeds and Ubercart product mapper to import. ...
2
votes
1answer
405 views

Exporting results with Views Data Export not working as intended

I have a view-based search (drupal 7, newest version of Views) with several exposed filters. By default it shows all results and users have to use the filters to narrow down their search. I've added ...
3
votes
2answers
261 views

How can I import special characters using Feeds?

I am using the Feeds module to import data into my site from a CSV file. When I try to import a row that has the € character, nothing gets imported and I get an error message. error:General ...
0
votes
1answer
124 views

What's needed to get Views data export working with a Block view?

I have been successfully using the Views data export module to export "Page" data to CSV. However, when attempting to do the same thing from a "Block" view, the path (required by VDE) spec'd for the ...
2
votes
3answers
234 views

Is there any way to export data to CSV file and then import updated data?

I have a website I started to build couple years ago. But the website itself grew up to something bigger, with more fields and details - and old data are missing these. E.g., recently added Long./Lat. ...
1
vote
2answers
123 views

Download Views CSV automatically Daily

I have a bunch of views/reports built for my client. The reviewers then click download csv for the excel file. They asked if the views could download themselves daily to a folder. Is that possible? ...
2
votes
1answer
129 views

How can I list all the pages of a Drupal site in csv format?

My goal is to get a .csv file list of the titles/urls for all "pages" in a Drupal site, including all Views, panel pages, and nodes, etc. Potential incomplete solutions: Using the xmlsitemap ...
1
vote
0answers
25 views

Regularly update an 'adopted' table with a local CSV file

I need to regularly update a table from a CSV file located on my server. I'm using the data module to integrate it with views. I've researched the feeds module, and looks like it used to support a ...
1
vote
1answer
26 views

Importing data into specific fields from CSV - into pre-existing nodes?

I've used the Feeds module before to import nodes and users. I need to import data into new fields on pre-existing nodes - is that possible?
2
votes
2answers
128 views

How do I export all of my customers (not users) from Drupal into a CSV file?

I'm working on integrating a new accounting system and crm (Xero & Capsule) for a client - and they have just under 10,000 clients - only stored in their Drupal website. I need to export these ...
1
vote
0answers
19 views

Append a range to the end of a field

I'm working on a real estate site. We are importing the listings from a csv. In the file, one column is the url for the image and another column is the number of images for that listing. For example ...
2
votes
0answers
58 views

How to migrate File Entities - images and docs into D7 from .csv and attach them to nodes?

I've got a simple feature which creates a content type with title and fields - subtitle, body, images a documents. The main thing is that I use media module, so I actually attach file entities - image ...
2
votes
1answer
76 views

Error during Taxonomy CSV import

I am using the Taxonomy CSV import/export module to import and export taxonomy from my local installation to a fresh install on the staging. I export it on local, and import it using the same settings ...
1
vote
1answer
265 views

Job for create/import data from csv

I need to import a large amount of contents of a CSV file. The file is a bit complex and still have a folder with a lot of images that are associated with each line of the csv. As the file is complex ...
1
vote
1answer
85 views

Boolean field not in CSV views export

I have a boolean field (a checkbox) in my user profiles. I have left it with the default settings (1= ticked, 0=unticked). I have created an CSV export in Views of the user data. All the fields in ...
2
votes
2answers
1k views

How can I export all my blog posts as CSV?

I'm migrating my website from Drupal to WordPress, and the only content I have left to migrate over are all my blog posts. From my research, the easiest way to do this would be to export my blog ...
1
vote
0answers
128 views

How to import data into db using Feeds importers

I created a Feeds importer and when I try to run it, it gives this error SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1 What can ...
1
vote
0answers
406 views

Feeds large CSV import

I try to import a 1.2 GB CSV tab delimited without Headers file as nodes with Drupal Feeds, Feeds Tamper, Feeds Entity Translation. But it imports only on all my servers 1.799 items (without Erros in ...
0
votes
1answer
179 views

How do I change either the text in the views data export CSV button or the button completely

I have a view that exports data, so the csv button is displayed. I want the button to read "Export" instead of CSV - how can I change the text that displays on that button or display a different ...
2
votes
2answers
936 views

Feed Import Products ( Commerce ) and Products Category ( Node Page )

I need to create a CSV feed importer to import both Commerce products and products category node using single table and I am using Commerce Feed Module... when I create it using two different tables I ...
1
vote
2answers
971 views

Where can I save a CSV file that I construct dynamically to make it available for download?

I dynamically construct a CSV file following that method: $fp = fopen('export.csv', 'w'); foreach ($export as $fields) { fputcsv($fp, $fields); } fclose($fp); A file 'export.csv' appears in the ...
0
votes
1answer
574 views

Drupal CSV import and create nodes

I am trying to accomplish the following through feeds and want to know if this is possible. Setup a cron to pull a CSV file via ftp from another server daily Create a bunch of nodes with custom ...
1
vote
0answers
189 views

How to set limit for excel parser Drupal 7

I am importing users from Excel sheet with Feed importers. In my local WAMP server I can import more than 170 users. But when I am trying on my server, it is not working. It's showing: An AJAX ...
2
votes
1answer
3k views

Export data to CSV programmatically in drupal 7

I am using the following code to extract all the users belonging to a group: // Send response headers to the browser. drupal_add_http_header('Content-Type', 'text/csv; utf-8'); ...
0
votes
2answers
420 views

How to import a CSV with list field labels using Feeds?

I have a content type "Car". The fields are "Title", "Body" and "Gearbox". The "field type" of the field "Gearbox" is "List (integer)", and the "Allowed values list" for this field (in the "key|label" ...
1
vote
2answers
2k views

How can I export all users in a CSV format?

A site we have over 8000+ users with Views, Ctools and VBO installed. Is it possible to export all users data into 1 CSV file? We tired Views Data Export with no luck(memory limit), even we increase ...
0
votes
2answers
1k views

How does Feed import get a list of the CSV fields to map to content type fields?

I am using Feed import to load a CSV file exported from an SQL database into Drupal and I am stuck at the stage where I need to map the CSV field names to the Drupal content type field names. I ...
0
votes
1answer
893 views

How do I import a csv-file into a table via Drupal?

I would like to import a csv into a table via Drupal. I use Drupal 7. I create a content type 'Import', which contains a File field to upload a file to the server (destination: sites / default / ...
2
votes
1answer
728 views

Formatting Field Collection data with Views Data Export (CSV)

I've got a Field Collection on use in a basic page content type on my Drupal 7 site. I've built a view with the Data Export module that is outputting the data from nodes of this content type as a CSV. ...
1
vote
1answer
77 views

Advice on CSV import with taxonomy for data sanitaztion

i have a situation where users will be uploading csv files of the same format/columns but the data is not consistent...for example in the "state" field, one office might use "NC" and another might use ...