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

learn more… | top users | synonyms

0
votes
1answer
12 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
12 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
15 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
69 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
111 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
65 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
72 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
93 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
116 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
331 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
91 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
145 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
0answers
110 views

Auto export of individual webform submissions to CSV files on server?

I need each webform submission to be saved/exported to CSV file in a directory on my server. Is that possible with this module, or through some kind of modification? Or is there another module that I ...
0
votes
1answer
340 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 ...
0
votes
0answers
80 views

Import multi-checkbox values in Feeds

I'm sorry if this is a dumb question, but I'm stuck. I have a content type called "Physicians". One of the fields is a checkbox field which allows multiple values to be selected. I am trying to use ...
1
vote
1answer
330 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
122 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
58 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
153 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 ...
2
votes
0answers
184 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 ...
2
votes
1answer
490 views

Can I map to Body Summary in Feeds Importer?

I'm setting up a Feeds Importer to pull in content form a previous CMS. To keep things manageable I'm setting up MySQL exports saved to CSV files per Content Type. In a content type of News we're ...
3
votes
1answer
940 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
256 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
235 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
185 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
58 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 ...
1
vote
1answer
1k 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
51 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
616 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 ...
1
vote
2answers
982 views

Import CSV with Single Quoted data

I need to use feeds importer to import csv file. But there's single quote in the values like doesn't. Is there anyway to escape the single quote? Thanks
0
votes
2answers
2k views

SQLSTATE[HY000]: General error: 1366

I'm using Feed Importer to import data from a csv file, and I got this error SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xA0 a TN...' for column 'message' at row 1 All values are ...
0
votes
1answer
413 views

Feeds CSV import error

I am trying to import a CSV from a url using the feeds module, I set everything up but when I start the import I get the following error: An AJAX HTTP error occurred. HTTP Result Code: 200 Debugging ...
0
votes
1answer
74 views

How can I automatically make term relations between all the terms with same term name?

I have multiple Taxonomy Terms which have the same "Term Name" (with different TID). And I need to make term relations between all the terms with the same term name. For example: term-A (tid=1) ...
1
vote
1answer
465 views

Data Tables and Chart using CSV content in drupal 7

I wish to generate a table and chart with the uploaded csv file. I have uploaded the file using Feed Importer Module and Created a View with Displaying format in Chart. I don't know how to apply this ...
-1
votes
1answer
2k views

Extra empty rows when serving CSV file

I'm building a CSV file and serving it up as a downloadable file. Pretty straightforward. Thing is, I get 18 leading empty rows in my csv file. Any ideas? I've stripped the code down to just about ...
2
votes
2answers
670 views

Import CSV/XLS data to Webform?

Is there a way to import records into webform database from user uploaded CSV/XLS?
1
vote
2answers
443 views

Error importing csv with batch API

I'm using this code in my batch job: <?php function my_module_csv_import() { $folder = "csv"; $files = scandir($folder); // define batch array structure // NOTE: minimal parameters ...
1
vote
1answer
424 views

Importing Nodes to D7 with all custom fields

I've got a Drupal site with an obscene about of content that has been given to me in CSV format. I'm toying with the idea of building a module to let me do this but if there's one already out there ...
0
votes
1answer
403 views

Import multiple node reference from CSV using feeds

I am trying to import multiple node references for one node using feeds. How should my CSV look like for that?? Will this work : ...
4
votes
1answer
922 views

OG: How to import 2 related nodes from CSV files using Migrate module?

I would like to import 2 related nodes (Organic Group and OG group content) from 2 CSV files using Migrate module but I cannot find a proper CSV migrate class example or module. I use Drupal 7. OG ...
9
votes
2answers
2k views

Importing large flat-file data sources with Drupal 7 with Views 3 integration

My goal is to produce a fast, reliable and automated method for accessing read-only data contained in several very large flat-file data sources (CSVs, Fixed Width and XML docs) using Drupal 7 that can ...
2
votes
2answers
3k views

Is there an alternative to the Node reference, and the Feeds modules?

I am using Drupal 7, Reference Module (references-7.x-2.x-dev), and Feeds Module (feeds-7.x-2.x-dev). I created 2 Content Types: Address Book, and City. The Address Book content type has a node ...
1
vote
1answer
566 views

Import site from HTML pages (currently static files in directories, not in a CMS)

I've taken over a small website (link here, in case it helps) which is currently composed of largely static HTML files (with a few PHP includes thrown in to generate menus and footers, etc). I want to ...
2
votes
1answer
4k views

How to generate a downloadable CSV file from a View table?

Is there any way to generate a downloadable CSV file from a View table? If not, how can I generate a CSV file in Drupal 7?
2
votes
1answer
1k views

Importing Feeds into an entity?

I am trying to create a store using Ubercart. like most other things on my site, I have a large amount of data stored on a csv file that I downloaded out of PHPmyAdmin from another site (the clients ...
1
vote
1answer
987 views

Importing data using Feeds into dropdowns/select lists/taxomony terms

I'm importing a set of users into my website using the Feeds module. The users have various details including company name. I wanted to make the company name field on the website a dropdown list ...
0
votes
1answer
756 views

Adding Table tools extension to Datatable module in View/Downloading User data as CSV file

I'm using D7 and I'm trying to create the functionality to download user data as a CSV file. The closest I have got is by creating a view using the Datatables module. Using the table tools extension ...
2
votes
1answer
1k views

Importing products via Feeds csv import is generating error: “General error: 1366 Incorrect string value:”

I'm trying to import products using the import via csv functionality within feeds and am getting the following errors: SQLSTATE[HY000]: General error: 1366 Incorrect string value: '\xB7 The ...' for ...
2
votes
1answer
265 views

Exporting nodes using Views Bonus Pack strips all formatting

I've exported all of my nodes using Views Bonus Pack Export CSV; it works rather nicely. The only trouble is that it strips all of the formatting on my nodes: no paragraphs, no bold text, nothing. The ...