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
Solved

Mirapoint Calendar and Address Export

Posted on 2011-03-21
9
937 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 500 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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Granting full access permission allows users to access mailboxes present in their database. By giving full access permission one can open and read the content of any mailbox but cannot send emails from that mailbox.
Resolve DNS query failed errors for Exchange
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…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

808 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