![]() ![]()
Please test this out, and let me know if this works or breaks in any way, I am happy to adjust it. I have also attached an example "use split and zip.yxmd" to test this out with some generated data. Add to Archive Dialog Box Extract Dialog Box 7-Zip Plugin Options Command Line Version. Menu Items and Shortcut Keys Options Dialog Box Benchmark About Dialog Box Plugins. 7ZIP COMMAND LINE SPLIT ZIP CODES ZIP FILESelect to keep just the Zip File Size field Supported formats 7z format Performance Frequently Asked Questions License Register 7-Zip Thanks File Manager. Formula to keep just the file size number Filter to pull out the line with the zip file size Run Command using cmd.exe to execute the 7-Zip command (7za a "out.zip" "out.csv" > "zipmessage.csv") so we can pipe ">" the results to a text file to read back in (note the "/c" command prefix) Join by record position to combine with Input data ![]() Directory configured with control parameters, so to pulls info on a specific file 7ZIP COMMAND LINE SPLIT ZIP CODES UPDATEFormula to update the FullPath and Record count for each file Generate Row for each needed File Number (counts from zero to "Record Count"/"Records per File" rounded up) Output Data tool, configured to split or not based on control parameters (if you need a different file type, you would change the config of this tool) Formula to swap out the extension for zip After the backup i have a scheduled task (.bat) that compresses the files with 7z such as below. Save File with Split using calculated "Records per File" I have split these 100GB into 4 different backup jobs. Interface elements and a Formula tool to calculate the desired "Records per File" Get File Size macro to get the file size Save File to a file in the temp directory (uses macro with "Records per File" parameter set to zero so there is no split) Here is a quick breakdown of what each macro is doing: Place "7za.exe" in the same directory as these macros 7ZIP COMMAND LINE SPLIT ZIP CODES 64 BIT7z file, extract and pull out the file "7za.exe" from the 圆4 folder (if you are on a 64 bit OS) Find the non-beta "7-Zip Extra: standalone console version, 7z DLL, Plugin for Far Manager" You will need to download the command line tool for 7-Zip and place it in the same directory as these macros. I also made zipping the output files optional since zipping can take a long time. There is also a buffer option because sometimes the sample may under represent (randomly picking the smallest records), and the buffer helps ensure the files will be smaller then the set size, but there is no 100% guarantee.Īs for the File Name, for an example, when you set the filename to "out.csv" and three files get generated, they will be named: You can specify how much data you would like to sample to generate the average record size estimate from (the higher percent, the greater the accuracy, but it will take longer). csv files, but you could change the config of one tool (noted below) and generate any file type you need. Attached is a macro that builds off of The attached Macro "Split and Zip" has three supporting macros, and uses the command line tool from 7-Zip. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |