0MS Office LogoBatch convertire vecchi documenti MS Office

I’ve been try­ing to sort out an enorm­ous (100+GB) or teach­ing resources that I’ve built-up over the years. After the obvi­ous steps (delet­ing empty, temp and duplic­ated files) and sort­ing the big files (e.g. Video, applic­a­tion installers) I was left with a large num­ber of office doc­u­ments. I am slowly work­ing through these, ma molti di essi sono 2003 or even older format doc­u­ments — some as old as Word 6!  Every time I open one of these files I am promp­ted with vari­ous secur­ity warn­ings. Whist these can be turned off (vedi sotto) è più sicuro di lasciare loro su, and I wanted to con­vert all the files to office 2007 (docx, xlsx ecc) formats. Batch con­ver­sion was def­in­itely the way to go.

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 poiché si basano su formati aperti, 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, ma se avete 110,000 file (come ho fatto io) you will save around 18Gb — a big sav­ing if you’re using a a USB thumbdrive, older extern­al HDD o SSD sys­tem­drive.

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­agerTo util­ise it fully you will also need to down­load the Ufficio 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 easi­er.

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. Ciò owrk con il percorso-profondità fino a 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-cartella-con-trailing-slash
ConvertSubfolders = 1

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

Note — If you just want to dis­able secur­ity warn­ings (e.g. in parola) quindi si prega di fare riferimento alla help­ful instruc­tions fornito da Microsoft.

Grazie alla Eric White for the ini­tial links and clues

Ha ottenuto alcuni pensieri della propria? Concedetevi sotto commentando! Se si desidera iscriversi si prega di utilizzare il link iscriviti sul menu in alto a destra. È inoltre possibile condividere con i tuoi amici usando i link sottostanti sociali. Saluti.

lascia un commento