Results 1 to 3 of 3
  1. #1
    Newbie
    Join Date
    September 26th, 2007
    Posts
    34
    Data feed to Excel problem
    I am having a devil of a time transferring a Duncraft data feed into Excel. I received the feed via email, in the actual body of the email, not as an attachment. I've messed with the data and tried a large variety of methods, from text files, tab deliminators, to importing web pages, xsl, more. Searching this forum has made me feel like I am the only person receiving data in the body of an email but this can't be so. I finally am breaking down to ask here.

    I have since changed my delivery method to FTP in case (hopes) it's my email system (gmail) but still am getting the email data and no FTP. I did email Performics about that - it is not the question here. I am confident that will be handled easily.

    My question is: what is the trick for transferring emailed data into Excel? I am new to Performics but not unfamiliar with data feeds. I know others are using this with no troubles so I'm pretty sure I am making a silly mistake. I appreciate any advice as to what to do with the email I receive.

  2. #2
    Full Member Tech Evangelist's Avatar
    Join Date
    March 16th, 2005
    Location
    Mesa, AZ
    Posts
    374
    It should be an attached file if it is arriving in an e-mail. Don't try using something embedded in an e-mail. That would be in an HTML format.

    For Duncraft files, if it is zipped, then unzip it. Open Excel, open the file from Excel (select All Files). The Text Import Wizard should start. Just make sure that you select Tab as the Delimiter.

    If you do not select All Files, you will not be able to see or select the file due to the strange file naming system used.

    BTW, the Duncraft data feed has been crap ever since they revised their product codes several months ago. I reported it, but it was never fixed. There isn't any useful product description. The LongDesc column is blank and the ShortDesc column contains truncated text.
    There's good, fast and cheap. Pick any two.
    [url=http://www.topranksolutions.com]Phoenix SEO[/url] :: [url=http://www.tech-evangelist.com/category/affiliate-marketing/]Affiliate Marketing Tutorials[/url]

  3. #3
    Newbie
    Join Date
    September 26th, 2007
    Posts
    34
    Thank you - I appreciate the answer and love Beaker. There is no attachment to the email, which is very much what I expected to see. It is embedded with a "view entire message" option which opens the feed in a new, html rich window. I've been all over the options on that one. This is why I switched to FTP delivery. Gmail does not allow me a plain text option even though I have html off by default. Once I get a text file I'm good with Excel, but I just didn't understand what the heck I was receiving.

    So at least I don't feel crazy when I have no clue what to do with this data. I thought I knew how to do this. Hopefully I'll start getting FTP and the problem is solved.

    Thanks for the data warning. I laughed - after I get through this headache I can worry about a couple thousand bland descriptions. Yay!

  4. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. LinkShare data feed problem
    By micheck in forum Rakuten LinkShare - LS
    Replies: 3
    Last Post: July 28th, 2010, 03:17 PM
  2. Problem with data feed import
    By admad1 in forum ShareASale - SAS
    Replies: 2
    Last Post: October 4th, 2005, 03:04 PM
  3. Opening data feed in MS Excel
    By gjab in forum Programming / Datafeeds / Tools
    Replies: 1
    Last Post: February 27th, 2004, 04:12 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •