• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 983
  • Last Modified:

Mirapoint Calendar and Address Export

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
jhieb
Asked:
jhieb
  • 5
  • 4
1 Solution
 
TobiasHolmCommented:
Hi!

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

yourcommand > outfile.txt

Regards, Tobias
0
 
TobiasHolmCommented:
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
 
jhiebAuthor Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
TobiasHolmCommented:
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
 
jhiebAuthor Commented:
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
 
jhiebAuthor Commented:
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
 
TobiasHolmCommented:
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
 
jhiebAuthor Commented:
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
 
TobiasHolmCommented:
The user list is only a list of users.

Regards, Tobias
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now