0Batch converter documentos antigos do MS Office

Estive try-ing para resolver uma enorm-ous (100+GB) ou recursos de ensino que eu construí-up ao longo dos anos. Após os passos óbvios (delet-mento vazio, temperatura e arquivos duplica-ciado) e classificar-ção das grandes arquivos (e.g. vídeos, instaladores aplicáveis-a-ção) Fiquei com um grande número de documentos de escritório. Estou trabalhando lentamente através destes, mas muitos deles são 2003 ou documentos de formato ainda mais antigos - alguns tão antiga quanto a Palavra 6!  Toda vez que abrir um desses arquivos sou solicitado com vários avisos de segurança. Whist estes podem ser desligados (see below) é mais seguro para deixá-los em, e eu queria converter todos os arquivos para escritório 2007 (docx, xlsx etc) formatos. A conversão do grupo foi definitivamente o caminho a percorrer.

There are sev­er­al advant­ages to con­ver­sion bey­ond the prob­lems with secur­ity warn­ings. Doc­u­ments saved in the new­er formats are sig­ni­fic­antly smal­ler, e como eles são baseados em formatos abertos, are much more com­pat­ible, e.g. with google docs and open office. This may prove very advant­age­ous in the future. I dis­covered that the size reduc­tion alone makes going to the trouble worth­while — first 220 word doc­u­ments i con­ver­ted were reduced from 63Mb to 25Mb. You may think sav­ing 175k per file isn’t worth­while, mas se você tiver 110,000 arquivos (como eu fiz) you will save around 18Gb — a big sav­ing if you’re using a a USB Pen drive, older extern­al HDD ou SSD systemdrive.

Microsoft offer a util­ity called OFC to batch con­vert office doc­u­ments so this seemed the obvi­ous way to pro­ceed. OFC is part of the Microsoft Office Migra­tion Plan­ning Man­ager.  To util­ise it fully you will also need to down­load the Escritório 2007 Com­pat­ib­il­ity Pack, which includes lots of file-format con­vert­ers. Install the com­pat­ib­il­ity pack first, then run the installer for the migra­tion plan­ning man­ager. You will be promp­ted to pick a loc­a­tion to extract to — I’d put it in your doc­u­ments or down­loads folder as it makes file edit­ing easier.

To run the con­vert­er you simply open the extrac­ted path, open the tools dir­ect­ory and run ofc.exe. How­ever, You wont achieve much this way as OFC does­n’t have a GUI — it uses ini files. There will be an OFC.ini file included in the tools folder as an example. You will need to edit it — you can use note­pad or any text edit­or to do so.

There are actu­ally lots of options for con­fig­ur­ing ofc.ini, but I’m just inter­ested in con­vert­ing all the files in a par­tic­u­lar folder (and sub­folders) into new­er file formats. To do this make the fol­low­ing edits. Isto irá owrk com trajeto de-profundidades de até 9 sub­folders deep — there seems to be a bug that pre­vents it work­ing bey­ond that.

[Con­ver­sion­Op­tions]
FullUpgradeOnOpen = 1
CABLogs = 0
MacroControl = 0

[Folder­sTo­Con­vert]
fldr = full-path-to-your-pasta-with-arrastando-slash
ConvertSubfolders = 1

[Con­ver­sion­Info]
SourcePathTemplate=*\*\*\*\*\*\*\*\*\
DestinationPathTemplate=*1\*2\*3\*4\*5\*6\*7\*8\*9\

Note — If you just want to dis­able secur­ity warn­ings (e.g. em palavra) em seguida, consulte o help­ful instruc­tions fornecida pela Microsoft.

Graças à Eric White for the ini­tial links and clues