How To Create A CSV File To Import Into Vertigo

  • 7019955
  • 08-Oct-2009
  • 07-Aug-2017

Environment

Vertigo (all builds)

Situation

How do you create a CSV file to import  and change the User Properties using Vertigo?

Resolution

Importing a CSV file into Vertigo is a simple and quick feature to change multiple User Properties at once. However, the CSV file must be setup a specific way before the changes will take affect in Vertigo. To setup a CSV follow these instructions: 1)  Connect to the GroupWise system using Vertigo. 2)  Select the system name at the top of the tree. 3)  Click the users tab. Within this window will show all of the users with the User Properties. Take note of the category or categories you wish to change for each user. 4)  Open up a blank text document (notepad, workpad, textpad etc...) 5) The very top line of this file will be the categories you wish to modify. It is required to have an "Account" category, so type that first. Type the categories in with quotes surrounding them and each category separated by a comma. The categories must be exact with the categories within the Vertigo program. Note: The categories are case sensitive. 6) Underneath each category enter in the new data surrounded by quotes for each Account. It will look something like this: "Account",    "Department",      "Preferred EMail ID" "user1",        "Sales",                    "user1.com" "user2",        "Sales",                    "user2.com" "user3",        "Sales",                    "user3.com" "user4",        "Sales",                    "user4.com" "user5",        "Sales",                    "user5.com" "user6",        "Management",       "user6.com "user7",        "Sales",                    "user7.com" "user8",        "Support",               "user8.com" Note: Make sure you have quotes around each value and each one must be separated by a comma. 7) Save the file as a CSV file. 8) Import the CSV file into Vertigo. To import click here.

Additional Information

This article was originally published in the GWAVA knowledgebase as article ID 1492.