Stephan Miller

Posts Tagged ‘datafeeds’

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:  Read more... (172 words, estimated 41 secs reading time)

• term_data
• node
• node_revisions

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.  Read more... (186 words, estimated 45 secs reading time)