Commodore
Commodore
355 views

Are there XML maps for Groupwise USER / GROUP etc..

Jump to solution

Hi.

Is there a XML Map for Groupwise 18.2 ?

So i've had some bits working and some not.... I'm trying to export my user / group / resources / nickname stuff to excel to be able to work out what i need to change as i need to change domain names for a load of users.

I can export the .csv files from the API but they don't have all the data that is within the XML files. Which is seriously annoying for example i really need the exclusive flag to see if they are known by one domain name or all domain names, we have over 130 domain names... 🙂

So the user.csv doesn't have the exclusive flag. BUT when you export the xml it does, or when you do it to a screen in the browser but the problem with all of these is then importing it into excel. When i do it either creates a load of lines for each user which isn't easily readable 30 lines for each user! or it doesn't import the data which is nested and of course that's the darn stuff i need.   I've never played with importing them before but i think if i had a map saying what each is i can then get them in a flat file instead of it ignoring the bits that are in tables.  I just want one long line for each user will all their info.

See below example of part of a user in the xml view. This one has the exclusive set so i know they only have one domain they are allowed to receive email on.

<name>FREDBLOGS</name>
<timeCreated>1572977612000</timeCreated>
<timeLastMod>1604224952000</timeLastMod>
<allowedAddressFormats>
<inherited>false</inherited>
<value>FULL</value>
<value>HOST</value>
<value>USER</value>
<value>LAST_FIRST</value>
<value>FIRST_LAST</value>
<value>FLAST</value>
</allowedAddressFormats>
<internetDomainName>
<inherited>false</inherited>
<value>RANDOMDOMAIN.COM</value>
<exclusive>true</exclusive>
</internetDomainName>
<preferredAddressFormat>
<inherited>false</inherited>
<value>FIRST_LAST</value>
</preferredAddressFormat>

0 Likes
1 Solution

Accepted Solutions
Commodore
Commodore
PS. I cheated....
I've got a colleague who is our data guy who works with Qlikview and dumped the file on him, took him about 5 minutes to drag out what i needed username and true into a file. HAHA

View solution in original post

0 Likes
3 Replies
Knowledge Partner Knowledge Partner
Knowledge Partner

Let's continue with your post at GroupWise Developer Discussions ...

Diethmar Rimser
This community is more powerful if you use Likes and Solutions
Commodore
Commodore
PS. I cheated....
I've got a colleague who is our data guy who works with Qlikview and dumped the file on him, took him about 5 minutes to drag out what i needed username and true into a file. HAHA

View solution in original post

0 Likes
Knowledge Partner Knowledge Partner
Knowledge Partner

@booktrunk 

When you get a solution to an issue you should mark the post "Accept as Solution" so others can easily identify it. This applies even when you post the solution yourself. 😀

_____
Kevin Boyle - Knowledge Partner - Calgary, Alberta, Canada
Who are the Knowledge Partners?
If you appreciate my comments, please click the Like button.
If I have resolved your issue, please click the Accept as Solution button.
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.