Article ID: 914694
Article Last Modified on 4/17/2007
APPLIES TO
- Groove Enterprise Management Server 2.0
- Groove Enterprise Management Server 2.1
- Groove Enterprise Management Server 2.5
- Groove Enterprise Management Server 3.0
- Groove Enterprise Management Server 3.1
- Groove Hosted Management Services 3.1
SYMPTOMS
When you import a comma separated values (CSV) file into Groove Enterprise Management Server or into Groove Hosted Management Services, the last column of the file may be lost.
CAUSE
This issue occurs if you created the CSV file in Microsoft Excel. Each line in the CSV file must end with a comma and with a carriage return. If you create the CSV file from the template in Groove Enterprise Management Server, a comma is automatically added after the last item in each line. If you create the file in Excel, the final comma is not automatically added. Therefore, when you import the file into Groove Enterprise Management Server or into Groove Hosted Management Services, the final field in each line will be dropped.
WORKAROUND
To work around this issue, use one of the following methods:
- Add a blank field at the end of each line in the Excel worksheet.
- Open the file by using a text editor such as Notepad, and then add a comma at the end of each line. For example, if you see the following line when you open the file in Notepad, add a comma after "cell":
- Full Name, First name, Last name, E-mail, Title, Company, Street, City, State, Postal Code, Country, Phone, Fax, Cell
Additional query words: TCN-00833
Keywords: kbexpertiseinter kbtshoot KB914694