Friday, March 23, 2007

You have Office, You have Tools to Edit Database through ODBC - MSQRY32.EXE

C:\Program Files\Microsoft Office\OFFICE11\MSQRY32.EXE
 
メニュー
レコード −> 編集の許可

Friday, March 02, 2007

Archive My Directory for Mediamax - Less than 10M per file ;-)

winrar_path = "C:/sunfmin/Programs/WinRAR"
rar_root_path = "C:/sunfmin/Install/Books"
#Mb
split_size = 8 #Mb

#============================================

require 'find'

split_size_byte = split_size * 1024 * 1024
Find.find(rar_root_path) do |f|

    if File.file?(f) and File.size(f) > split_size_byte
        dirname = File.dirname(f)
        Dir.chdir(dirname)
        file_name = File.basename(f)

       
        rar_file_name = file_name[0, file_name.rindex('.')] + ".rar"
       
        winrar_exe = winrar_path + "/Rar.exe a -o+ -v#{split_size}m \"#{rar_file_name}\" \"#{file_name}\""
        puts "=========================================================="
        IO.popen(winrar_exe) do |out|
            puts "OOOOO======>>> #{rar_file_name}"
            puts out.readlines
        end


    end
end