Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Location
    Huntington, IN
    Posts
    54

    Angry Unanswered: Using TransferText to create multiple files

    When I export my product table and try to upload it to my website, it bombs out after about 350 records. I delete the 1st 300, try again..etc until the entire file is uploaded.

    Instead, I would like export my product table into multiple files (prodfile_1.csv, prodfile_2.csv...) but do not know if this is possible using "transfertext" method.

    Does anyone know if this is possible? If not, how can I export my table to multiple files?

    TIA.

    Matt

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Export the full file locally then FTP the file to the server...


    ...or write a handful of queries, splitting the data into "manageable chunks" and call the TransferText method a few more times.

    I like option 1 best
    George
    Home | Blog

  3. #3
    Join Date
    Mar 2004
    Location
    Huntington, IN
    Posts
    54
    Interesting idea re: the FTP. I'll have to ponder that...sounds a bit risker than using PHPadmin to do the upload for me but it would be so much faster.

    If that doesn't work out, I'll likely write some code to read the first line of the 'transfertext' resulting file, then write that same line to newfile_1.csv for 300 records, then newfile_2.csv for 300, etc. Still makes uploading inefficient.

    Thanks for your idea George.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Let us know what method works for you, yeah?
    George
    Home | Blog

Posting Permissions

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