Fixed font
Subject: Re: automating contact + notes export
Author: David T-G Date: 23 Apr 2010
References: 1 2 3 4 5 6
Author: David T-G Date: 23 Apr 2010
References: 1 2 3 4 5 6
Karl, et al --
Karl Timmermans wrote:
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.
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.
Right.
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.]
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 :-)
Agreed; I think this is how I'll be moving forward. Thanks, too, for the
CG clarification; I appreciate it!
:-D
______________________________________
Posted from http://outlook-center.com
Outlook forums, articles, tips.
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.
> 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"
..> 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.
> 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
> 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
> 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
> 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.
> 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
> Karl
:-D
______________________________________
Posted from http://outlook-center.com
Outlook forums, articles, tips.
