mapping data in delicious or excell fields to fields in a custom node type

aascherson - October 10, 2008 - 17:14

Hey everyone, hope I'm posting this in the right place, we are new to drupal but have a rather complicated problem that we are trying to get to grips with.

Basically, we are trying to create an online database of links to online articles, and have created a custom node type with the fields:

Author:
Url:
Date:
where first published:
writer (this is a drop down menu from which we select one of the writers in our taxonomy)

What we have been doing is bookmarking the sites on delicious, then importing them as 'writerlink' nodes using feedapi. However, we have been having problems mapping the delicious information into the correct fields. For example, when using delicious, you have 5 fields -

url-
title-
keywords-
notes -
tags-

At the moment, the information we enter into the delicious bookmark notes section appears in the 'where first published' line on the node created by the feedapi. So we write the dates and the where first published info into notes, then have to go back and edit the node, copying and pasting the information into the correct field. Obviously this isnt ideal. In addition, the tags in the delicious bookmarks dont come through into the delicious tags field at all. So is there any way we can correct this and map, say, the keywords field on the delicious to the date field in our 'writerlinks form? ' Thus having a complete set of data ready to publish? We were thinking maybe we could import the delicious information into excel, make all the corrections we needed, then import it en mass as writerlink nodes as a csv or some such thing. At least that way we could make the corrections much faster, on mass rather than having to edit every link individually, which would save us alot of time.

We have been looking for clear ways to solve this problem, but so far the instructions and modules we have found (eg - delicious module) dont quite what we want. Is there something out there that explains clearly how to transfer infomation in excell to custom fields in drupal nodes? Any advice would be greatly appreciated!

 
 

Drupal is a registered trademark of Dries Buytaert.