Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Mirapoint Calendar and Address Export

Posted on 2011-03-21
9
Medium Priority
?
964 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
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
Industry Leaders: 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!

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Google Drive is extremely cheap offsite storage, and it's even possible to get extra storage for free for two years.  You can use the free account 15GB, and if you have an Android device..when you install Google Drive for the first time it will give…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
To show how to generate a certificate request 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 Servers >> Certificates…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Suggested Courses
Course of the Month12 days, 11 hours left to enroll

971 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