Datafeeds

Importing ShareASale Datafeeds into Drupal Part 2

Published June 12, 2007 | By admin

Okay, there is an issue using Node Import to import ShareASale datafeeds.

Either the datafeed itself or the import process makes characters like “&” come up as character codes. I have had the same issue before with xml files, but now is not the time to investigate, just to fix the issue.

My solution, though a little hacky, was to create a page in Drupal with the import format set to “php code” and then paste code to clean these characters.

The three tables to focus on are:

term_data
node
node_revisions

Here is the code: Read more... (171 words, estimated 41 secs reading time)

Posted in Affiliate Programs, Drupal | Tagged datafeeds, Drupal, shareasale | 1 Comment

Importing ShareASale Datafeeds into Drupal Part 1

Published June 5, 2007 | By admin

I finally cracked this code. Well, almost. I still have to create a template for the new nodes. I still have to clean up the taxonomy a little. Hopefully, I find a little tool for that, because yesterday I imported over 1000 products in less than five minutes.

Using a highly underpriced piece of software called Macro Express, I wrote a script that downloads datafeeds from from the ShareaSale ftp site and then breaks them into uploadable sized chunks.

The Drupal part of the process is still manual though. I am playing with the iOpus iMacros Firefox extension, but haven’t quite got it down yet. It’s a great extension. I have used it for other internet macros before. Read more... (185 words, estimated 44 secs reading time)