Solved

Mirapoint Calendar and Address Export

Posted on 2011-03-21
9
916 Views
Last Modified: 2012-05-11
Hello,
I need to export calendars and address books from a Mirapoint messaging server. I am not sure how to do this or which terminal to use. I was given the following commands. These commands show me the contents of the calendar or address books in the screen but the contents do not extract to file. I would like to do this for each person.

Calendar downsync mirapointusername vcal

 Or

User get wmaddrbook mirapointusername

Do you know what else I need to do in order to create a file for each user using the above commands?

Thanks,
John
0
Comment
Question by:jhieb
  • 5
  • 4
9 Comments
 
LVL 18

Expert Comment

by:TobiasHolm
Comment Utility
Hi!

Put a bracket at the end of the command, like:

yourcommand > outfile.txt

Regards, Tobias
0
 
LVL 18

Accepted Solution

by:
TobiasHolm earned 500 total points
Comment Utility
First, make a list of all users:

User List "" '' '' > userlist.txt

Open in new window


You might want to remove the last line in the userlist.txt (saying OK Completed).

Then you can use this script:

#!/bin/bash
while read LINE ; do
 USERNAME=`echo "$LINE" |awk '{print $3}'`
 `Calendar downsync $USERNAME vcal > $USERNAME.cal.txt`
 `User get wmaddrbook $USERNAME > $USERNAME.addr.txt`
done < userlist.txt

Open in new window


Run the script with 'sh' or set the execute flag on the script.

Regards, Tobias
0
 
LVL 1

Author Comment

by:jhieb
Comment Utility
TobiasHolm,

This looks very good. I just need to figure it out and test it. Unix is a new OS to me and I need to figure out how to do what you said. I am very glad you mentioned the user list. This was also something I needed to figure out. There are two commands I need to run and they are:

For Calendars:
Calendar downsync mirapointusername vcal

For Address Books:
User get wmaddrbook mirapointusername

The calendars, I believe, will be in vcal format which is ICS
The address books should be in LDIF format but I am not totally sure about this.

Would I run your script in Putty? If I am in terminal, which directory should I be in, and should I somehow create a text file (batch file) just like you posted? I need some more guidance on this, and if I need to create more questions so I can give you more points then please let me know.

I will be testing this later this morning, and am anxious to try this out.

Thanks,
John
0
 
LVL 18

Expert Comment

by:TobiasHolm
Comment Utility
You can log in to your server with PuTTY and then you can create a new folder in your home directory:

mkdir test
cd test

Open in new window

Then create the script. You can use 'vi'.

vi test.sh

Open in new window

Press 'i' in vi to start inserting text. Then copy my script above into your clipboard in Windows and paste the text in PuTTY by right clicking your mouse inside the window. Save the file in vi with the keys ESC + :wq

Make the script executable with

chmod u+x test.sh

Open in new window

Test the script

./test.sh

Open in new window

Regards, Tobias
0
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 
LVL 1

Author Comment

by:jhieb
Comment Utility
Outstanding! I am anxious to test this out. For address books, would I just modify your script and change the command to address books and reference userlist the same way? Is there anything I would need to change for address books?

I looked at the address book command again and it looks like the syntax given to me is to just get user names. So, for address books what should I use to export an address book to LDIF or some type of CSV?

0
 
LVL 1

Author Comment

by:jhieb
Comment Utility
ToBiasHom,

I am going to create a new question for the address book question so that you can also respond to that one and get points.

It will be titled: Mirapoint Address Book Export
0
 
LVL 18

Expert Comment

by:TobiasHolm
Comment Utility
also, before you test the script, I forgot to write that you should create the user list with the command I gave earlier. Run those commands in the 'test'-directory you created in your home directory.

User List "" '' '' > userlist.txt

Open in new window

Then use vi to delete the last line in the file:

vi userlist.txt

Open in new window

Go to the end of the file with you arrow keys and when the cursor is on the line you'd like to delete, type 'dd' (two D's). Then save the file with the keys ESC + :wq

Regards, Tobias
0
 
LVL 1

Author Comment

by:jhieb
Comment Utility
Is the user list only a list of users or will it contain all of their address book information? What I hope to get is the user's address books, such as name, email address, phone numbers, etc. Is that command different?
0
 
LVL 18

Expert Comment

by:TobiasHolm
Comment Utility
The user list is only a list of users.

Regards, Tobias
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Workplace bullying has increased with the use of email and social media. Retain evidence of this with email archiving to protect your employees.
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now