Results 1 to 14 of 14
  1. #1
    Full Member dak142's Avatar
    Join Date
    January 18th, 2005
    Posts
    386
    I am just looking for the basic command sequence. I know how to use FTP, but I can not seem to find a way to transfer the feed directly to my server. As of so far I have only been able to download the feed onto my desktop from the ftp site, and then load it onto the mysql server from my desktop.

    I would like to write some code that would enable me to take the feed directly from the ftp site to the my SQL server without manually downloading it onto my computer. What commands would I need to use to accomplish this?

  2. #2
    Newbie
    Join Date
    January 18th, 2005
    Posts
    3,219
    <BLOCKQUOTE class="ip-ubbcode-quote"><font size="-1">quote:</font><HR>Originally posted by Dak142:
    I would like to write some code that would enable me to take the feed directly from the ftp site to the my SQL server without manually downloading it onto my computer. What commands would I need to use to accomplish this? <HR></BLOCKQUOTE>

    You cannot write the code if you do not know the commands. Go into the data feed forum and ask with the hopes of getting that information for free. Your best chance is PAYING for the information you are requesting like everyone else. This forum gives free information not free work, dang!

  3. #3
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    Location
    Virginia
    Posts
    5,303
    I don't know how comfortable you are with PHP, but you can do this quite easily if you read this URL: http://us4.php.net/manual/en/function.ftp-fget.php
    Once you've downloaded the file, you just need to loop through it and insert into mysql with several queries. I do this for all my sites, in my mind there's no other way to do it. I just can't stand any sort of manual process when it comes to updating products and prices.

    Good luck!
    - Scott
    Hatred stirs up strife, But love covers all transgressions.

  4. #4
    Full Member garystarling's Avatar
    Join Date
    January 18th, 2005
    Posts
    277
    If you use telnet or ssh to access mysql then you can also ftp within telnet to directly get the datafeed. Providing it is formated correctly you can then use the mysql 'load data infile' command. This would cut out downloading the file to your computer then uploading it to the server.

  5. #5
    ABW Ambassador Sam Bay's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,603
    &lt;'&data/feed -- go-to!= +MY- $SQL (-/+)"now"&gt;

  6. #6
    ABW Ambassador CrazyGuy's Avatar
    Join Date
    January 18th, 2005
    Posts
    1,463
    @SamBay - no error trapping.

    Should be:

    &lt;'&data/feed -- go-to!= +MY- $SQL (-/+)"now"&gt; || die

  7. #7
    ABW Ambassador CDC's Avatar
    Join Date
    January 18th, 2005
    Posts
    751
    You're Killing Me

    CDC
    I can't complain but sometimes I still do...

  8. #8
    ABW Ambassador Ron Bechdolt's Avatar
    Join Date
    January 18th, 2005
    Location
    Affiliateville, USA
    Posts
    7,927
    Oh, you guys are too much!!!

    Thanks, I needed a laugh today.
    Ron Bechdolt | Affiliate Program Management Consultant
    7 Days A Week Marketing

  9. #9
    notary sojac Herb ԿԬ's Avatar
    Join Date
    January 18th, 2005
    Location
    Central/Western NY State
    Posts
    7,741
    let's hope the victim appreciated it

  10. #10
    ABW Ambassador
    Join Date
    January 18th, 2005
    Posts
    1,663
    Does anyone actually upload & read an unaltered text file instead of converting it into a database format?

    Wayne

  11. #11
    Full Member dak142's Avatar
    Join Date
    January 18th, 2005
    Posts
    386
    It's all good, I thought I may have been asking for a little to much. Someone needs to set me straight once in awhile. I was just looking to get pointed in the right direction. Thanks a million Snib, that page was just what I needed!

  12. #12
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    Location
    Virginia
    Posts
    5,303
    Not a problem, never underestimate the power of php.net, it's my #1 programming resource.
    Hatred stirs up strife, But love covers all transgressions.

  13. #13
    Newbie Hoser's Avatar
    Join Date
    January 18th, 2005
    Location
    Yorba Linda, CA.
    Posts
    3
    Don't|you|all|read|and|write|in|this|format|?|I|just|assumed|.|.|.|but|you|know|what|they|say|,|when|you|assume|you|make|an|a$$|out|of|u|and|me|

  14. #14
    ABW Ambassador Snib's Avatar
    Join Date
    January 18th, 2005
    Location
    Virginia
    Posts
    5,303
    Wayne,

    I like to open a feed in Excel to see what the data looks like. Let's me know how many products there are and if it has all the information I need to implement it.

    - Scott
    Hatred stirs up strife, But love covers all transgressions.

  15. Newsletter Signup

+ Reply to Thread

Similar Threads

  1. Requesting information to Upload data feeds through url to FTP automatically
    By gdi_fortune in forum Programming / Datafeeds / Tools
    Replies: 1
    Last Post: June 26th, 2007, 02:06 AM
  2. Reading Data Feed from txt, CSV, MS-Accees or SQL??
    By kse in forum Programming / Datafeeds / Tools
    Replies: 16
    Last Post: August 28th, 2006, 10:07 PM
  3. Data transfer ?
    By purplebear in forum Domains & Hosting
    Replies: 5
    Last Post: June 21st, 2006, 10:19 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
  •