?
Solved

Mirapoint Calendar and Address Export

Posted on 2011-03-21
9
Medium Priority
?
959 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 
LVL 18

Expert Comment

by:TobiasHolm
ID: 35186690
Hi!

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

yourcommand > outfile.txt

Regards, Tobias
0
 
LVL 18

Accepted Solution

by:
TobiasHolm earned 2000 total points
ID: 35187148
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
ID: 35190383
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
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
LVL 18

Expert Comment

by:TobiasHolm
ID: 35190749
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
 
LVL 1

Author Comment

by:jhieb
ID: 35191210
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
ID: 35191264
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
ID: 35193003
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
ID: 35193554
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
ID: 35194282
The user list is only a list of users.

Regards, Tobias
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Fine Tune your automatic Updates for Ubuntu / Debian
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…
Suggested Courses

718 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