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

learn more… | top users | synonyms

1
vote
1answer
20 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
31 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 ...
2
votes
2answers
34 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
30 views

Drupal 7 Views Data Export from a Block

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
56 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. ...
2
votes
1answer
32 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
20 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
25 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
45 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
15 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 ...
1
vote
0answers
41 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
46 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
0answers
22 views

Approach to process thousands of feed items

I have a Drupal Commerce site which needs to process thousands of feed items each night. Let me try to sketch the structure of the site. The data is provided in 10 different CSV files. I have 5 ...
1
vote
1answer
137 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
45 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
453 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 ...
0
votes
0answers
49 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 ...
0
votes
0answers
125 views

Automatic Mapping for Node processor in Feeds Import

I have a content type with the 35 fields in it. I need to populate the fields using a CSV file. So I went for Feed Import module. I created mapping for all the fields manually. Now I am in need to ...
1
vote
0answers
194 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
72 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
503 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
322 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
0answers
71 views

Feeds import CSV GeoNames

Current i import GeoNames tab delimited databases of all Countries, States/Regions and Cities of the world as Nodes. It works fine with Feeds. What for modules i use? Feeds Feeds Tamper Field ...
0
votes
1answer
247 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 ...
0
votes
0answers
127 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 HTTP ...
1
vote
1answer
1k 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
225 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
904 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
867 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 ...
-1
votes
1answer
562 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
429 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. ...
0
votes
1answer
55 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 ...
1
vote
0answers
19 views

Feeds: how to populate a 'File' field from a path/filename in csv file? [duplicate]

I've got a csv file I'm using the Feeds module to convert to nodes. It's going pretty well, but I have many documents (max of 1 per node, though) that need to be associated with my nodes. I have ...
0
votes
0answers
189 views

How to validate and collect errors from CSV import without submission failure

I have been tasked with creating a tool which accepts a CSV and presents it in a spreadsheet display with additional dialogues to explain and link to errors on the display. Have investigated / ...
4
votes
1answer
270 views

How to validate the headers of a csv uploaded with cck filefield?

I need my users to upload a csv, using a cck filefield. I then wish to confirm they have the correct order of columns. My research led me to believe that writing a custom validator for the filefield, ...
0
votes
1answer
386 views

Removing nodes using Feeds module

I am using Feeds module to create nodes with CSV import. Currently following patch Unpublish/Delete nodes not included in feed only provides the feature where if the entry is not there in the feed ...
0
votes
1answer
391 views

Output the file name of images using the views_data_export module?

I'm using the https://drupal.org/project/views_data_export module to export a Views list of content as a csv file. The content has a image field (multiple values in it) then the csv data show nothing ...
0
votes
1answer
350 views

Migrate module only imports first line of CSV file

I have a Migrate module class that works with CSV files and when I go through with the import it only goes through the first line of the CSV and then completes with a success message. That one line ...
2
votes
1answer
777 views

How to export recent logs report in csv file drupal 7

Download all recent logs messages into csv file which is stored in database in Drupal 7 admin can filters records and all records and filters records should be export in csv format
0
votes
0answers
310 views

Views Data Export - Individual records for each file path iteration

I'm exporting data through Drupal 7 Views 3 data export to CSV file. I've worked out most of the kinks, but cannot find a solution to the following: CSV file output contains iterations/rows of each ...
0
votes
2answers
748 views

Import issue in other languages using csv file to drupal node creations

I am trying to import a csv file using parsecsv-for-php library.The given csv file is in Catalan language. The thing is that when i just try to create nodes with given csv data it is throwing me this ...
1
vote
2answers
250 views

Feeds Importer Filters

I would like to import some nodes from csv file using feed_import module in Drupal 7. The original CSV file has around 500k entries and I have to do some filtering before importing. (the result will ...
1
vote
1answer
353 views

Import data from csv [duplicate]

I am new on Drupal. I have a csv where I want to upload on a drupal site every week. I tried to follow this tutorial enter link description here but "Data Processor" doesn't show. I have installed ...
0
votes
1answer
1k views

Sending webform submissions to email with csv export of submissions

I need help, because I dont know how to create csv file from submissions and send it as attachment in submission mail. I have form with some field and after sending webform I need to create custom ...
2
votes
1answer
868 views

How to export field collection with Drupal 7 views data export plugin?

The Views Data Export plugin appears to work perfectly with the data that I have, though I have a field called "Items Bought" consisting of fields ("Item Bought" and "Cost"). For each content type of ...
0
votes
2answers
205 views

feeds module cannot handle csv files exceeding 8gig?

I am trying to import a very big CSV file into my Drupal 7 site using the Feeds module, but I get the following error: Warming: POST Content-Length of 40245470 bytes exceeds the limit of 8388608 ...
0
votes
1answer
77 views

Generated CSV cannot be read by Feeds

Using Views Data Export module, I am generating a CSV file of the latest 10 content. Then on another Drupal site, I am trying to import those nodes with Feeds. The problem is when I give the url of ...
1
vote
2answers
289 views

How to use uc_csv module for getting reports in drupal 7

I am using the ubercart module for purchasing products. I want to export the order records/history as csv file and view it in spreadsheet. So I searched and got the uc_csv module. I have installed the ...
5
votes
1answer
455 views

Combine Webforms to export multiple form results in a single CSV

I need to be able to select multiple webforms and then be able to export all of their results in a single CSV download. I am considering using this module (Views data export) but I'm not yet sure it ...
3
votes
2answers
2k views

Drupal 7: Does Views Data Export Module support Exposed Filters

I am looking to use the Data Export Module to export data to CSV files. However I need the user to be able to filter the data first with exposed filters and then download the filtered results. From ...