LMS 3.2

lehmandnest · ‎12-23-2009

After importing a .csv device file into common services, the user defined fields are not displaying what I had entered in the .csv file. The other information comes over fine.

Any suggestions?

Thanks,

Dave Lehmann

Nael Mohammad · ‎12-23-2009

Hi Dave,

Here is an example of what the CSV file should look like:

http://www.cisco.com/en/US/docs/net_mgmt/ciscoworks_common_services_software/3.3/user/guide/dcr.html#wp1193611

How are defining the user_defined fields and what values are you inputing ?

-nael

Joe Clarke · ‎12-23-2009

Post a sample of the file you are uploading. Have you renamed your user defined fields in DCR?

lehmandnest · ‎12-23-2009

Here is .csv file in text form. Yes, user defined fields are renamed in the application.

Nael Mohammad · ‎12-23-2009

In the sample file you provided, you are missing your commas . The point of a CSV file is to have the fields separated by commas to map the fields with the values.

Joe Clarke · ‎12-23-2009

You are using the deprecated CSV version 2.0 format. This format will only work if the user-defined fields have their default names (and only works for the first four user-defined fields. If you want to be able to import values for renamed user-defined fields (or fields five through ten), you will need to use CSV version 3.0. Consult the online help for the format (or just export the existing DCR). Essentially, you will need to add fields in the header for your user-defined fields. Be sure to use the CURRENT NAMES, and not the default names.