• Subject: Re: automating contact + notes export
  • Author: David T-G
  • Date: 23 Apr 2010
  • References: 1 2 3 4 5 6
Karl, et al -- Karl Timmermans wrote:
> > Curious as to what you would consider a "portable" database format that > wouldn't require some kind of 3rd party program to access "and" would be > widely accepted by other programs for the purposes of manipulation.
Pretty much anything manageable with a text editor under Linux would do :-) To get really fancy, I'd go with mysql or something that can handle binary data -- but the end goal is still to not be locked into some proprietary format. I don't know what phone I'll have after I leave my current company someday, so I can't say how I'll need to massage the data, so I'll need to be sure that I can get to the data to have my way with it.
> > Can't think of anything beyond CSV that could be considered a "universal"
..
> DB" with export functionality should you want to use your data in some > other program.
Agreed; CSV is pretty basic and very straightforward. Parsing it isn't all that friendly, but since it's possible to make it properly it's possible to parse it properly.
> > Just as an aside, if you export your contacts/notes once a week - the > resulting file is always going to contain the most current info since you
Right.
> can't select "only new stuff since" - all you have to do is name the output > file to whatever you want (i.e. Notes-20100422.csv). You just need to
Agreed. Unfortunately, Outlook Export (which does a good job of exporting to CSV; I haven't found any errors or glitches in what I've dumped so far) doesn't remember what file name I used for Contacts vs Notes, so I have to keep renaming. [What I'll actually do, I think, is just dump to a static filename and then rename that when it lands; it's an extra window to have open but it will be much quicker.]
> remember to do it but that max you would ever lose should you forget are > the changes/additions from the last time you exported your data. Set up a > recurring reminder in Outlook to remind you to do this 5 minute process on
Me take 5 minutes? Arrrgh! That's way too long ;-) Once I whip up a script to handle the dump file I should be able to get it down to 2 minutes or just maybe even 1. We'll see :-)
> whatever recurring schedule you want and it just may be all you need for > what you're looking to achieve.
Agreed; I think this is how I'll be moving forward. Thanks, too, for the CG clarification; I appreciate it!
> > Karl
:-D
______________________________________ Posted from http://outlook-center.com Outlook forums, articles, tips.
21 Apr 2010automating contact + notes export.David T-G
21 Apr 2010|- Re: automating contact + notes export.Brian Tillman [MVP-Ou...
22 Apr 2010|  \ Re: automating contact + notes export.David T-G
22 Apr 2010|     \ Re: automating contact + notes export.Brian Tillman [MVP-Ou...
23 Apr 2010|        \ Re: automating contact + notes export.David T-G
23 Apr 2010|           \ Re: automating contact + notes export.Karl Timmermans
23 Apr 2010|              \ Re: automating contact + notes export.David T-G
22 Apr 2010\ Re: automating contact + notes export.Karl Timmermans
23 Apr 2010   \ Re: automating contact + notes export.David T-G
23 Apr 2010      \ Re: automating contact + notes export.Karl Timmermans
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)