Commandline way to have OE automate export of WAB to CSV?

  • Thread starter StargateFan
  • Start date Views 1,848
Status
Not open for further replies.
S

StargateFan

I'm thinking that if there were a commandline way to do this then I
could automate that with a script so that it could be done remotely or
automatically once a month or something.

Is there such a thing, though?

Thanks.

 
P

PA Bear [MS MVP]

Why would you wish to do this when Windows automatically maintains an
Address Book back-up for you?

StargateFan wrote:
> I'm thinking that if there were a commandline way to do this then I
> could automate that with a script so that it could be done remotely or
> automatically once a month or something.
>
> Is there such a thing, though?
>
> Thanks.


 
E

Ed

Where can you find the address book backup?

"PA Bear [MS MVP]" <PABearMVP@gmail.com> wrote in message
news:uEOSnyjLKHA.3740@TK2MSFTNGP04.phx.gbl...
> Why would you wish to do this when Windows automatically maintains an
> Address Book back-up for you?
>
> StargateFan wrote:
>> I'm thinking that if there were a commandline way to do this then I
>> could automate that with a script so that it could be done remotely or
>> automatically once a month or something.
>>
>> Is there such a thing, though?
>>
>> Thanks.

>


 
P

PA Bear [MS MVP]

1. Open a Windows Explorer search window (WinKey+F).

2. Check the Advanced option and the three (3) options directly beneath it.

3. In the topmost Search box, type or copy/paste...

*.WAB~

4. Press SEARCH NOW button.

By default, it's located in C:\Documents and Settings\User\Application
Data\Microsoft\Address Book <=this folder.

Also by default, the OE user files (DBX and WAB*) are hidden files. To
access/view these files in Windows Explorer, you must first enable Show
Hidden Files and Folders via Start | Control Panel | Folder Options | View
(cf. http://www.bleepingcomputer.com/tutorials/tutorial62.html).

Ed wrote:
> Where can you find the address book backup?
>
>> Why would you wish to do this when Windows automatically maintains an
>> Address Book back-up for you?
>>
>> StargateFan wrote:
>>> I'm thinking that if there were a commandline way to do this then I
>>> could automate that with a script so that it could be done remotely or
>>> automatically once a month or something.
>>>
>>> Is there such a thing, though?
>>>
>>> Thanks.


 
S

StargateFan

On Sat, 05 Sep 2009 10:08:31 -0500, StargateFan
<IDon'tAcceptSpam@NoJunkMail.com> wrote:

>I'm thinking that if there were a commandline way to do this then I
>could automate that with a script so that it could be done remotely or
>automatically once a month or something.
>
>Is there such a thing, though?
>
>Thanks.


Good Morning. Can this be done via commandline at all?

Thanks! :eek:D

 
S

StargateFan

On Sat, 05 Sep 2009 10:08:31 -0500, StargateFan
<IDon'tAcceptSpam@NoJunkMail.com> wrote:

>I'm thinking that if there were a commandline way to do this then I
>could automate that with a script so that it could be done remotely or
>automatically once a month or something.
>
>Is there such a thing, though?
>
>Thanks.


Just a note, I did find _some_ info re a vb-type of approach but this
is not ideal since it would be much harder for an external script to
perform the action which is what is required. But there is mention on
how to do something via vb here, in case it jobs anyone's memory on a
commandline approach <g>:
http://social.msdn.microsoft.com/forums/en-US/isvvba/thread/ccf85e06-6a6c-4795-bd78-e799303620e6/

Thanks. :eek:D

 
R

Robert Aldwinckle

"StargateFan" <IDon'tAcceptSpam@NoJunkMail.com> wrote in message news:rlv4a5t8gj8j6itju7leejfe5liogb2sab@4ax.com...
> I'm thinking that if there were a commandline way to do this then I
> could automate that with a script so that it could be done remotely or
> automatically once a month or something.
>
> Is there such a thing, though?


SendKeys()

But why do you want to export to .csv? It's not a complete backup.


>
> Thanks.
>


 
S

StargateFan

On Mon, 7 Sep 2009 12:20:30 -0400, "Robert Aldwinckle"
<robald@techemail.com> wrote:

>"StargateFan" <IDon'tAcceptSpam@NoJunkMail.com> wrote in message news:rlv4a5t8gj8j6itju7leejfe5liogb2sab@4ax.com...
>> I'm thinking that if there were a commandline way to do this then I
>> could automate that with a script so that it could be done remotely or
>> automatically once a month or something.
>>
>> Is there such a thing, though?

>
>
>SendKeys()
>
>But why do you want to export to .csv? It's not a complete backup.


Different processes involved here. Last week I was caught at work
with an WAB I couldn't work with. I'd quickly dumped it onto my flash
drive before running out the door in the morning having no idea it was
not a file that one could access easily if Outlook or OE were somehow
unable to make the addresses available. If I keep a CSV export on the
drive then I'd at least be able to send emails at work. They have 07
there so I can't even use my PAB so trying to figure out an easy and
quick way to have my agency email addresses on hand. If I at least
had had a CSV, there would have been no problem. But I know myself,
it would be nice to handle this all via a script since I already have
processes like that in place for other programs.

I'll have to look at this SendKeys() but I suspect it's still very
manual in that you have to launch OE, etc., ... not something that can
be done via commandline so that no user intervention needed? I
thought it was a long-shot but even though I couldn't find anything
googling, etc., there are sometimes utilities available that do things
that one wouldn't dream as being possible. Ah well ... I'll keep
trying to find a way to solve this. Too bad there just doesn't seem
to be a way to work with just the WABs themselves when OE isn't
installed on the host computer ... <sigh>

 
S

Steve Cochran

There is no way to do this via a command line to OE.

steve

"StargateFan" <IDon'tAcceptSpam@NoJunkMail.com> wrote in message
news:rlv4a5t8gj8j6itju7leejfe5liogb2sab@4ax.com...
> I'm thinking that if there were a commandline way to do this then I
> could automate that with a script so that it could be done remotely or
> automatically once a month or something.
>
> Is there such a thing, though?
>
> Thanks.
>


 
R

Robert Aldwinckle


"StargateFan" <IDon'tAcceptSpam@NoJunkMail.com> wrote in message news:b1hca513pdqvol2s20npdp5ap3ni3tadqr@4ax.com...
> On Mon, 7 Sep 2009 12:20:30 -0400, "Robert Aldwinckle"
> <robald@techemail.com> wrote:


>>But why do you want to export to .csv? It's not a complete backup.

>
> Different processes involved here. Last week I was caught at work
> with an WAB I couldn't work with.


That would be a symptom that you didn't describe. ; )
So you were giving us your problems with your self-prescribed solution
to your undisclosed problem.


> I'd quickly dumped it onto my flash
> drive before running out the door in the morning having no idea it was
> not a file that one could access easily if Outlook or OE were somehow
> unable to make the addresses available.


> If I keep a CSV export on the
> drive then I'd at least be able to send emails at work. They have 07
> there so I can't even use my PAB so trying to figure out an easy and
> quick way to have my agency email addresses on hand. If I at least
> had had a CSV, there would have been no problem. But I know myself,
> it would be nice to handle this all via a script since I already have
> processes like that in place for other programs.



>
> I'll have to look at this SendKeys() but I suspect it's still very
> manual in that you have to launch OE, etc., ... not something that can
> be done via commandline so that no user intervention needed?


More like a way of defining programmed keyboard macros.


> I
> thought it was a long-shot but even though I couldn't find anything
> googling, etc., there are sometimes utilities available that do things
> that one wouldn't dream as being possible. Ah well ... I'll keep
> trying to find a way to solve this.


> Too bad there just doesn't seem
> to be a way to work with just the WABs themselves when OE isn't
> installed on the host computer ... <sigh>


OE really doesn't have that much to do with it. wab.exe is a program
that should be available in the OS. Tell us what your problem was with
the .wab you saved...

<cmd_output OS="XPsp3">
E:\>assoc .wab
..wab=wab_auto_file

E:\>ftype wab_auto_file
wab_auto_file="F:\Program Files\Outlook Express\wab.exe" %1
</cmd_output>

Had someone deleted that program? Changed the filetype or association?

If you open that wab.exe in DependencyWalker you can see that
it is really more dependent on IE modules than OE modules.
So you might then find that a simpler workaround for the problem that
I think you may have been having would be simply to have your own copy
of wab.exe to carry with your .wab file (JIC).

HTH

Robert
-
 
S

StargateFan

On Tue, 8 Sep 2009 10:15:48 -0400, "Robert Aldwinckle"
<robald@techemail.com> wrote:

>
>"StargateFan" <IDon'tAcceptSpam@NoJunkMail.com> wrote in message news:b1hca513pdqvol2s20npdp5ap3ni3tadqr@4ax.com...
>> On Mon, 7 Sep 2009 12:20:30 -0400, "Robert Aldwinckle"
>> <robald@techemail.com> wrote:

>
>>>But why do you want to export to .csv? It's not a complete backup.

>>
>> Different processes involved here. Last week I was caught at work
>> with an WAB I couldn't work with.

>
>
>That would be a symptom that you didn't describe. ; )
>So you were giving us your problems with your self-prescribed solution
>to your undisclosed problem.


I obviously didn't want to confuse the issue and muddy the waters.
The question is self-explanatory. I only mentioned the above since
the question was directly asked re .CSV. Yes, I am aware that a .CSV
is not a complete backup. Just need access to the information which
changes frequently enough to need a solution to this.

[snip]

>> I'll have to look at this SendKeys() but I suspect it's still very
>> manual in that you have to launch OE, etc., ... not something that can
>> be done via commandline so that no user intervention needed?

>
>
>More like a way of defining programmed keyboard macros.


Exactly. But you still have to open OE and then invoke the macro ...
that's not anything commandline in nature. Like you might suspect, I
have no idea if OE has commands that it understands for work such as
this behind-the-scenes. It might be something it does even though
there is no reference on the web that I can find. I'm often very
surprised by what can be done that is obscure in Windows.

[snip]

>> Too bad there just doesn't seem
>> to be a way to work with just the WABs themselves when OE isn't
>> installed on the host computer ... <sigh>

>
>
>OE really doesn't have that much to do with it. wab.exe is a program
>that should be available in the OS. Tell us what your problem was with
>the .wab you saved...


It's not available on the host machine at all.

[snip]

><cmd_output OS="XPsp3">
>E:\>assoc .wab
>.wab=wab_auto_file
>
>E:\>ftype wab_auto_file
>wab_auto_file="F:\Program Files\Outlook Express\wab.exe" %1
></cmd_output>
>
>Had someone deleted that program? Changed the filetype or association?


No idea what they did but it's not there. And the computers at work
are locked down so I can't dump the files onto the hdd and change
associations (wouldn't work anyway, likely, see third para down).
That's why I need to find a way to quickly, with no muss, no fuss,
export a copy of the .WAB here at home to .CSV. I'd then likely
include an event that periodically and automatically checks for the
presence of the USB flash drive and copies such an export to the
stick. Since the .WAB itself is no good to use at work, yet I don't
want yet another hassle via doing yet another task manually re the
exporting, was looking for a way to do this remotely/automatically.
If anyone here says that OE cannot export the .WAB to .CSV via a
behind-the-scenes commandline approach, that's all I need to know. I
will cross the bridge of what to do then if that's the case, when I
get there.

I already have a script that makes an actual copy of the .WAB itself,
so that's covered; it's the export to .CSV that's not.

>If you open that wab.exe in DependencyWalker you can see that
>it is really more dependent on IE modules than OE modules.
>So you might then find that a simpler workaround for the problem that
>I think you may have been having would be simply to have your own copy
>of wab.exe to carry with your .wab file (JIC).


Well, I don't know what the problem is. Though they have IE7
installed, nothing to do with the Windows Address Book works properly.
I tried copying all the WAB files besides the EXE and took them all to
work but though the very same file launched here on the stick, it did
not there. And if that can happen at this job it may happen at
another, so must find a way to work with the .WAB since other than
this incident, is very simple to use under other circumstances.

I also found some apps that said they'd work with .WABs but they also
didn't function at work. They did the job here, some of them, more or
less, though none wanted to open up a loose .WAB, they all wanted to
go to an installed one, so that wouldn't have been a solution anyway.

But like I said, just need to know if OE has a commandline approach to
export the address book to .CSV.

Thanks. :eek:D

 
S

StargateFan

On Tue, 8 Sep 2009 08:20:05 -0400, "Steve Cochran"
<scochran@oehelp.com> wrote:

>There is no way to do this via a command line to OE.


Well, there we go. That's all I needed to know. I'll have to think
of something else.

Cheers and thanks; much appreciated!

:eek:D

>steve
>
>"StargateFan" <IDon'tAcceptSpam@NoJunkMail.com> wrote in message
>news:rlv4a5t8gj8j6itju7leejfe5liogb2sab@4ax.com...
>> I'm thinking that if there were a commandline way to do this then I
>> could automate that with a script so that it could be done remotely or
>> automatically once a month or something.
>>
>> Is there such a thing, though?
>>
>> Thanks.
>>

>


 
Status
Not open for further replies.

Similar threads

Top