PDA

View Full Version : how can I extract data automatically from microsoft outlook .pst files?



zhaotianwu
July 8th, 2011, 11:31 PM
I'm currently building my own database for contacts and other stuff. I have some legacy data stored in Microsoft Outlook .pst files. Since it is proprietary, I was wondering if there is any means that allows me to automatically extract all the data from a .pst file, preferably into a xml database. Can anybody inform me of some known methods or software? Thanks.

Habitual
July 9th, 2011, 12:33 AM
VirtualBox + MSOffice > Outlook > export contacts.

haqking
July 9th, 2011, 12:40 AM
There are lots of tools to look inside and extract from . pst file.

here is the first link that came up in google

http://www.nucleustechnologies.com/pst-viewer.html

i used a similar tool years ago cant remember which one but i know there are lots out there

there are also various conversion tools out there also http://www.convertpstfiles.com/

zhaotianwu
July 9th, 2011, 06:25 AM
There are lots of tools to look inside and extract from . pst file.

here is the first link that came up in google

http://www.nucleustechnologies.com/pst-viewer.html

i used a similar tool years ago cant remember which one but i know there are lots out there

there are also various conversion tools out there also http://www.convertpstfiles.com/

Thank you. By the way, does anyone think there is ANY benefit leaving data there within .pst file? I mean, is there any merit in Microsoft's .pst database schema? Database experts please give me some advice.

haqking
July 9th, 2011, 12:47 PM
Thank you. By the way, does anyone think there is ANY benefit leaving data there within .pst file? I mean, is there any merit in Microsoft's .pst database schema? Database experts please give me some advice.


the merit would be using it with apps that support .pst such as outlook.

it is just PIM information, store it in whatever format you want based on how you interact with its contents or view it

zhaotianwu
July 11th, 2011, 01:55 AM
the merit would be using it with apps that support .pst such as outlook.

it is just PIM information, store it in whatever format you want based on how you interact with its contents or view it



Hi haqking, thank you. I'm a newbie to databse, am I correct to say that .pst is not very popular or friendly to open source community? Considering that both its data structure and applications are proprietary. What do you think? Thanks.

krazyd
July 11th, 2011, 08:52 AM
Install the readpst package - it includes the pst2ldif (http://manpages.ubuntu.com/manpages/natty/man1/pst2ldif.1.html) utility.

haqking
July 11th, 2011, 12:10 PM
also Evolution will import .pst files so you could import your it then re-back it up to a tar.gz or mbox format