Results 1 to 8 of 8
  1. #1
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    UK
    Posts
    539
    Ok, I am very new to this, but I am learning bit by bit. I have been trying to get a datafeed into my database using phpmyadmin, I could not figure out how to get a tab delimited file in, it is giving me huge problems.
    I ended up trying to put ,', in between all the fields, which took ages, and then i got confused.

    I use mysql and my php skills are limited. All i want is to get the whole feed into the database, which I have made up. I tried automating it with the use of someones post, but that did not work either. It cannot be that hard to do.

    Once i get it in, then i will start playing with the php code to make my own script - which should take a while, but thats they way I learn, being hands on.

    all the posts i read are to learn php, which is fine, but there is no place that I can find which helps you get your info into the database.

    I have been working on this for months now, so I am now getting desperate for help.

    Thankyou for any info at all.
    I am practising on the mondera script, but have just asked cj for warner bros, and homevisions feed, now I am earning enough.

    And people say I'm just a housewife!!! ha ha

  2. #2
    ABW Ambassador Jane's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,350
    Maybe it's not you, maybe it's the web host?
    I say this because I tried to upload one to my account hosted at globat and it would not work, I then uploaded the same file with no problem to another host. Both were using phpmyadmin.
    It's been awhile and I am no expert at this, but why did it take forever to change the delimiter? You should be able to open the file in excel and export it the way you want.

  3. #3
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    UK
    Posts
    539
    Hi, thanks for that.

    I think to be honest, that I have absolutely no idea what I am doing, he he!!

    I leanr as I go along, and I thought I was ready to start playing, but maybe not.

    I have no idea what programs to open these feeds in, i have xls, txt and others and am very confused. So i think i shall just look into that aspect first. i need to learn abpout tabs and commas etc,

    And people say I'm just a housewife!!! ha ha

  4. #4
    ABW Ambassador sjangro's Avatar
    Join Date
    January 18th, 2005
    Location
    Boston
    Posts
    1,529
    Tamalyn,

    First, you should have no troube with a tab delmited file. It's easy to go down the wrong path and start experimenting with things that aren't causing you problems, so I thought I'd at least mention that. No need to change the delimiters.

    The problem is likely just with uploading through phpmyadmin. Datafeed files tend to be very large, and if they don't timeout the server, the PHP upload limit may be set at a number smaller than the size of your feed (the default in PHP is 2MB.)

    If you haven't already, try with just the first 10 rows of the feed file.

    When it comes time to load the whole file, you're likely going to need to do so with the mysql command line. Do you have shell access to your server?

    --scott

    --
    scott@befree.com

  5. #5
    Full Member
    Join Date
    January 18th, 2005
    Posts
    100
    My host doesn't allow uploading data from a file with phpMyAdmin, so you might be in a similar situation. I use SQLyog (a windows program) It uploads files with no problem.

    www.sqlyog.com

  6. #6
    Full Member
    Join Date
    January 18th, 2005
    Posts
    292
    I've tried uploading files to phpMyAdmin- it works once, then stops working forever! I've had to tell my host to fix it twice. What I finally did was switch to PostgreSQL. Of course, that may not be the best solution.

    Bryan Simonson
    email: bryan@smoothcorp.com
    phone: 425-460-4748

  7. #7
    ABW Ambassador FFoc's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,015
    Upload the file to the server, then insert via phpmyadmin -- your mysql user needs "global FILE" permissions, and you need to know the ABSOLUTE PATH to the datafeed file

    In the query box under phpmyadmin, use the SQL statement:

    <pre class="ip-ubbcode-code-pre">
    LOAD DATA INFILE '/path/to/datafeed.txt'
    INTO TABLE mytable
    FIELDS TERMINATED BY '\t'
    </pre>

    --
    "The greatest good you can do for another is not just to share your riches, but to reveal to him his own." – Benjamin Disraeli
    --
    Ford Fox-body Owners Club -- http://www.ford-fox.org

  8. #8
    ABW Ambassador
    Join Date
    January 18th, 2005
    Location
    UK
    Posts
    539
    Thanks guys, it was phpmyadmin not letting it go in!! there must be a bug in it, as it was looking elsewhere for the file.

    I have put it ther other way with insert into, and will be making a script to put it in from now on.
    Thankyou for all the tips,

    And people say I'm just a housewife!!! ha ha

  9. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. How to put CJ datafeed into database?
    By oxplode in forum Commission Junction - CJ
    Replies: 0
    Last Post: April 20th, 2014, 03:03 PM
  2. So i've got the datafeed into mysql database..
    By chillini in forum Programming / Datafeeds / Tools
    Replies: 10
    Last Post: December 2nd, 2008, 02:06 PM
  3. Did anybody here create datafeed from phpmyadmin?
    By sinpeople in forum Programming / Datafeeds / Tools
    Replies: 1
    Last Post: June 17th, 2007, 07:40 PM
  4. Integrating our datafeed without putting it into CJ?
    By Mr. B in forum Programming / Datafeeds / Tools
    Replies: 2
    Last Post: February 16th, 2007, 07:43 PM
  5. datafeed transfer into a database
    By tsmgroup2 in forum Programming / Datafeeds / Tools
    Replies: 11
    Last Post: December 10th, 2005, 10:31 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
  •