ACS 5.2 csv import fails

[fschramke]

Hi,

I'm trying the csv file import and getting some errors.

010-12-07 14:23:47: File Format Validation Completed
2010-12-07 14:23:47: Import Started

2010-12-07 14:23:47: Record number: 1, Host 01-02-03-04-05-06: Import Failed
2010-12-07 14:23:47: null Import process failed for unexpected reason: Unknown error has accurred.
2010-12-07 14:23:47: Import Completed With errors

-------- Summary --------
Total Number of Records Processed:1
Number of Records Failed:1
Number of Records Imported:1
---------- End ----------
Please refresh the table to see the changes.

On some other tries I get null field or missing fields.

It actually creates the host, but on editing it I get the following message:

An unexpected error has occurred.
To continue your work, reselect the option in the left navigation bar.
If you continue to receive the unexpected error message, close your browser and log in to ACS again.
If you still receive the unexpected error message, contact your system administrator or technical assistance.

MACAddress:String(64):Required,description:String(1024),"enabled:Boolean(true,false):Required",HostIdentityGroup:String(256),VLAN:String(256):Required,attr-Expiration Date:Date(yyyy-Mmm-dd)
01-02-03-04-05-06,AAATest,true,,Guest,2010-Dec-08

Any ideas?

Thanks,

Fabian

[Nicolas Darchis]

Hi Fabian,

Your example actually worked fine on my ACS ...

so your csv file is correct, something is fishy with your ACS...

I'd suggest opening a TAC case so that someone can dig in the logs to understand better the reason of the problem

Nicolas

===

Don't forget to rate answers that you find useful

[fschramke]

Hi Nicolas,

totally awesome...thanks for trying out the csv file.

Now I know I'm not going insane.

I'll check with TAC on it.

Fabian

[fschramke]

Just remembered this and figured I still owe an answer.

I had an identical variables 'VLAN' defined under

System Administration >

Configuration >

Dictionaries >

Identity >

Internal Users and Internal Hosts

This caused the CSV Import to fail; changing them to VLAN_User and VLAN_Host fixed the problem.