Results 1 to 8 of 8
  1. #1
    Newbie nick_mayhem's Avatar
    Join Date
    September 18th, 2006
    Location
    India
    Posts
    19
    Pipe delimited Datafeed To MySQL
    Hello friends,

    I am new here.

    I got 5 datafeeds from SAS.

    But the prob is that is there anyway to import it in MySQL they are PIPE delimited and MS excel is not opening it properly.

    All help is appreciated.

    Thanks.

  2. #2
    ABW Veteran Mr. Sal's Avatar
    Join Date
    January 18th, 2005
    Posts
    6,793
    Quote Originally Posted by nick_mayhem
    Hello friends,

    I am new here.

    I got 5 datafeeds from SAS.

    But the prob is that is there anyway to import it in MySQL they are PIPE delimited and MS excel is not opening it properly.

    All help is appreciated.

    Thanks.
    Just do this:
    Attached Images Attached Images
    ...

  3. #3
    Newbie nick_mayhem's Avatar
    Join Date
    September 18th, 2006
    Location
    India
    Posts
    19
    I just got ftp details. I downloaded the text file. And also set 12000+ products manually.

    But now when I click on the link it shows me:

    The link is not currently active.

    There are a number of reasons that you may have received this message. The most common is that the merchant who was advertising is temporarily not-actively promoting that program. If, however, you feel you have reached this page in error, please let us know. Shareasale.com does not tolerate or send any SPAM mail to anyone. If you feel you have been targeted by a SPAM message, we would appreciate if you could forward the message to us at abuse at shareasale.com.

    Shareasale.com manages the relationships between advertisers and affiliates, which is why you were directed to our site. Since the link that you clicked is not currently active, you were not redirected to the site.

    If you are a new affiliate, your links will not be active until Shareasale.com gets a chance to review your account - you will receive an email when your account is approved and links are activated. This process generally takes around 24 business hours.
    Plus te option that MrSal told me I have never seen it in my shareasale.

    Thanks.

  4. #4
    Newbie nick_mayhem's Avatar
    Join Date
    September 18th, 2006
    Location
    India
    Posts
    19
    Okay if someone from Shareasale wants to review the site for the feeds then here it is.

    Sry link edited. Read the rules a bit late.

    Please let me know when the links will be online.

    Hoping that it will be soon online and I can start marketing it.

    Thanks a lot.

  5. #5
    Lite On The Do, Heavy On The Nuts Donuts's Avatar
    Join Date
    January 18th, 2005
    Location
    Winter Park, FL
    Posts
    6,930
    You need to search and replace the link code and insert your unique SAS affiliate id.

  6. #6
    Newbie nick_mayhem's Avatar
    Join Date
    September 18th, 2006
    Location
    India
    Posts
    19
    Quote Originally Posted by Donuts
    You need to search and replace the link code and insert your unique SAS affiliate id.

    WOW that worked. Thanks a lot.

    Also This forum had a topic of exporting Pipe delmited files in excel and from excel to MySQL was easy.

    Great community. I love it here.

    Thanks to all. Let me know if in anyway I can also be of help.

  7. #7
    Full Member
    Join Date
    January 16th, 2006
    Posts
    447
    Question
    Quote Originally Posted by Donuts
    You need to search and replace the link code and insert your unique SAS affiliate id.
    That doesn't come automatic with SaS?

  8. #8
    Lite On The Do, Heavy On The Nuts Donuts's Avatar
    Join Date
    January 18th, 2005
    Location
    Winter Park, FL
    Posts
    6,930
    If you're ftp'ing a datafeed, your just grabbing a static file prepped by the merchant. It's easy to script the replacement though because SAS requires it to be a standard format.

    All the other methods [that I can think of (example: deals database)] in SAS will have your SAS Aff ID auto injected.

+ Reply to Thread

Similar Threads

  1. Pipe Delimited to Comma Separated
    By knight01 in forum Programming / Datafeeds / Tools
    Replies: 12
    Last Post: March 30th, 2014, 12:57 AM
  2. javascript for PIPE DELIMITED (|) database
    By davon in forum ShareASale - SAS
    Replies: 0
    Last Post: December 29th, 2005, 05:33 PM
  3. Pipe delimited to tab
    By bbb in forum Programming / Datafeeds / Tools
    Replies: 10
    Last Post: August 30th, 2004, 05:03 AM
  4. Using an Affiliate Feed with Exel (Pipe Delimited)
    By jdsguam in forum Programming / Datafeeds / Tools
    Replies: 3
    Last Post: April 22nd, 2004, 08:57 AM
  5. tab or pipe delimited format in a .csv
    By hershey in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: July 17th, 2002, 07:52 AM

Posting Permissions

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