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

learn more… | top users | synonyms

1
vote
1answer
14 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 ...
0
votes
0answers
9 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 ...
0
votes
0answers
11 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 ...
1
vote
1answer
28 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 ...
0
votes
0answers
15 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 ...
0
votes
1answer
48 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 ...
0
votes
1answer
19 views

Boolean field not in CVS 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
135 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
32 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
63 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 ...
0
votes
0answers
102 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
39 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 ...
1
vote
2answers
254 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
111 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
23 views

Pass views result to CSV based on date selected in Drupal 7

I want to be able to export the results from the date selected in my view from my Drupal 7 application. I am using entityfield and fieldcollection modules to create a form that gathers user info. Not ...
0
votes
0answers
48 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
107 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
86 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 ...
0
votes
1answer
459 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
134 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" ...
0
votes
1answer
476 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
595 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
370 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 / ...
0
votes
1answer
260 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
48 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 ...
0
votes
0answers
89 views

simplenews e-mail address import from file

just looking for a solution to import e-mail addresses during 'simplenews' installation. The simplenews module just offers importing addresses by copy and paste. I would like to prefer a solution ...
1
vote
0answers
17 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
147 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
225 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
298 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
293 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
297 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 ...
0
votes
0answers
232 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
625 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
185 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 ...
0
votes
1answer
309 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
910 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 ...
1
vote
1answer
719 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
184 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
69 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
245 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 ...
4
votes
1answer
322 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 ...
0
votes
3answers
388 views

Custom CSV Importer

I decided to write my own csv node importer since Feeds did not give me the functionality I needed. I have about 500 nodes to create each month and from that node it needs to create another node. I ...
0
votes
1answer
425 views

Can I use the feeds module to import csv data to 2 different content type?

I have 2 content types, account and contact. I have a .csv file which contains the data. In the Account table we have: name street address postcode city province country created lastModified and ...
0
votes
1answer
264 views

selecting hierarchical select values during migration

I want to select the values of a taxonomy which is being shown by heirachical select. These values are to be selected while importing the data through csv by using migration module. right now i am ...
1
vote
0answers
73 views

Importing forms using feeds?

What is the proper way to expand feeds to import the entities themselves instead of the values for already existing entities (like a node type). For example let's say we have various forms collected ...
2
votes
2answers
3k views

How to setup a csv-file to import image-paths into an image-field via Feeds-module?

I import a csv-file via Feeds-module and got stuck with the images for a node. All the other fields are importet as wanted, except the path for the image-field. The images are already uploaded to the ...
1
vote
1answer
56 views

Feed importer View

I have created a Feed Importer with CSV as Parser and Proccesor as Self Node processor which is attached to a content type. The feed works fine when importing to the content type, however I would like ...
3
votes
1answer
1k views

Add extension .csv to file created with Views Data Export

To export user data into a csv I've setup a view display of type data export succesfully. I've setup a path "admin/people/export" and when visiting it will return a file. The file is a csv file but ...