By deeve on

I'm trying to use Feeds mod to import a CSV file but it requires a GUID column. I'm used to using Primary Keys in databases & have Googled GUID but am unclear as to what Feeds requires? Tried searching on here & get a lot of 'Guides'. Can anyone please point me towards a good tutorial?

Thanks.

⋅ Categories: Drupal 7.x

Comments

ayesh’s picture

ayesh commented

See Feeds module's doc.
GUID is just a small piece of data to find duplicates. There's no need to create a GUID.
OPen your CSV files and see if it has a unique identifier. For an example, item serial number, etc.
Feeds module only create one entry(node, user, etc) per a GUID.

What's new and changing in PHP 8.4

deeve’s picture

deeve commented

Hi Ayesh,
are you saying map an existing, unique column to GUID? Only problem with that for me is I need to reference all of my data. My idea was to create a new column called GUID & use Excel's =ROW() formula which then would create a faux Primary Key for each row (as you would in Access or mySQL)..

deeve’s picture

deeve commented

I've tried to import several times now & keep getting the following error:
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=20&op=do StatusText: Internal Server Error ResponseText:

Thought I'd followed the tutorial on how to declare Content Type correctly & map the Node Processor. Thing is, the tutorial is for Drupal 6.x & 7.x is somewhat different in Structure. It's all very confusing for a newbie! Isn't there a way to have auto-mapping? Is my error something to do with the order of the mappings? There seems to be no way to move these up or down, only delete.

Also, why are the default field requirements: Title, Body, Date Published when my db entries are not 'Stories' or 'Articles'?

I need my CSVs 'Name' field to map to Locations.name rather than 'Title' as want to use Locations mod to perform a postcode radius search..

Sorry for so many questions but this is frustrating!

deeve’s picture

deeve commented

I'm now wondering whether my import errors are due to either my .htaccess file permissions being incompatible or because my site appears to default to an https secure connection when I'm logged in as admin & therefore doesn't permit uploads?

Any ideas anyone?

tinem’s picture

tinem commented

Maybe using Location feeds module too will help http://drupal.org/project/location_feeds