Results 1 to 13 of 13
  1. #1
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts

    Sample data file with 125,000 records

    Hi

    This is a test for posting a large datafile to this forum.
    The sample file contains 125,000 records with these data columns:
    FirstName LastName Company Address City County State ZIP Phone Fax Email Web

    The actual file posted here as a .pdf file, is actually a .zip file containing a .csv file
    So, the test is to save the attached file.
    Then rename the attached file by changing the .pdf file extension to .zip, (ignore the expected warning messages when changing the file extension). Then finally, extract the csv file from the zip file.
    The csv file can be loaded directly into Excel2007 (or later).

    zeddy
    Attached Files Attached Files

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Zeddy,

    No problem at all. Can I ask the reason for the .pdf?
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi

    Well, the test worked for me.
    NOTE:
    Max size for posting a zip file here is 5.75MB
    Max size for a pdf file is 8.11MB

    So I saved the 7.53MB "pdf" file, renamed it as 125000.zip, then extracted the 125000.csv file and loaded OK into Excel.

    So, as Maud and I have been looking at ways of posting large Excel files in .xlsb format, it seems we can do this by camouflaging the file as either a zip file or pdf file.

    Thanks to Maud again.

    zeddy

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi RG

    The csv file is ~19MB in size.
    If I saved it in .xlsb format, it reduces to ~15MB
    zipping the csv file makes it ~7.7MB
    These are all too large for posting here.
    But, by disguising the file as a .pdf file, we are allowed to post up to 8.11MB here.

    zeddy

  5. #5
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,434
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Zeddy,

    Tricky VERY Tricky!

    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  6. #6
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,180
    Thanks
    47
    Thanked 983 Times in 913 Posts
    Or you could post it elsewhere and link here.

    cheers, Paul

  7. #7
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi Paul

    any suggestions where?

    Main reason for posting here is to provide this forum users with Excel sample data records.

    zeddy

  8. #8
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,180
    Thanks
    47
    Thanked 983 Times in 913 Posts
    There are plenty of file transfer sites out there. I thought you wanted more than a single file stored.

    The other issue is sites like this are databases and they are generally not good at storing files. The file store sites have a separate area for files and then keep links in the database.

    cheers, Paul

  9. #9
    New Lounger
    Join Date
    Mar 2015
    Posts
    15
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Zeddy,
    The only website that I can think of would be dropbox, which allows you to upload 10GB per each file.
    Che

  10. #10
    New Lounger
    Join Date
    Mar 2015
    Posts
    15
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by zeddy View Post
    Hi

    This is a test for posting a large datafile to this forum.
    The sample file contains 125,000 records with these data columns:
    FirstName LastName Company Address City County State ZIP Phone Fax Email Web

    The actual file posted here as a .pdf file, is actually a .zip file containing a .csv file
    So, the test is to save the attached file.
    Then rename the attached file by changing the .pdf file extension to .zip, (ignore the expected warning messages when changing the file extension). Then finally, extract the csv file from the zip file.
    The csv file can be loaded directly into Excel2007 (or later).

    zeddy
    If you really want to upload large files to the forum, I will recommend splitting the file 125000.csv into small files by using 7-Zip program and then upload your small files. Once upload in small files, any forum member can download the small files. Use 7-Zip program to combine all the files and then get the original file back easily. I just download your file 125000, split it into small files and combine it back to its original state with no problem. Give it a try and let me know what you think.
    Howtogeek.com demostrates how to achieve this taks nicely.
    http://www.howtogeek.com/howto/36947/how-to-upload-really-large-files-to-skydrive-dropbox-or-email/[/URL]
    Regards,
    Che

  11. #11
    WS Lounge VIP Browni's Avatar
    Join Date
    Dec 2009
    Location
    Rochdale, UK
    Posts
    1,651
    Thanks
    38
    Thanked 161 Times in 139 Posts
    Google drive allows up to 10GB per file...

    Need to correct that

    Quote Originally Posted by Google
    Size limits

    Documents: 1,024,000 characters, regardless of the number of pages or font size. Uploaded document files that are converted to the Google Docs format can’t be larger than 50 MB. If you're using an older version of Drive, you can't convert document files that are larger than 10 MB.

    Spreadsheets: 2 million cells. If you don't see a green checkmark at the bottom of your spreadsheet, it is using the old version of Sheets and there are different limits, listed in the expandable section below.

    Presentations: Presentations created in Google Slides can be up to 100 MB. Uploaded presentation files that are converted to Google Slides can also be up to 100 MB.

    Drawings: We’ve never seen anyone make a drawing that was too big (but that’s not a dare).

    Other files: Files that you upload but don’t convert to a Google Docs, Sheets, or Slides format can be up to 5 TB each.
    Source
    Last edited by Browni; 2015-04-05 at 23:26.

  12. #12
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    I think the point Zeddy is trying to make is often a solution to a problem may be disregarded only because a viewer has to go offsite to download a larger file. Many, like myself, are reluctant to do so. In addition, some may require you to create an account with yet another username and password that may be used one time. That means more junk mail. What is propose is a simple solution to upload a file in an unsupported format or with an exceeded file size by changing the extension and being able to stay within a trusted forum to do so.

  13. #13
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,824
    Thanks
    135
    Thanked 482 Times in 459 Posts
    Hi Maud

    ..you are bang on the money.

    zeddy

Posting Permissions

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