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

learn more… | top users | synonyms

2
votes
0answers
32 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 ...
0
votes
0answers
4 views

Can I use Feeds Import to import directly from a Google Sheet CSV?

We need to import data into Drupal from a Google Sheet (published to the web as a CSV) directly using its published URL. We can import the data from a CSV that has been downloaded, but it doesn't work ...
1
vote
1answer
46 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
61 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
46 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
80 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
63 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
43 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
81 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
46 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
23 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
61 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
48 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
51 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
25 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
163 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
54 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
614 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
74 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
144 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
238 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
95 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
617 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
449 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
76 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
305 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
141 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 ...
2
votes
1answer
2k 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
274 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
1k 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
996 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
629 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
496 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
61 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
223 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
308 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
422 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
458 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
373 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
897 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
346 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
789 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
272 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
368 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
938 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
213 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 ...