12-23-2009 12:11 PM
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
12-23-2009 12:51 PM
Hi Dave,
Here is an example of what the CSV file should look like:
How are defining the user_defined fields and what values are you inputing ?
-nael
12-23-2009 12:54 PM
Post a sample of the file you are uploading. Have you renamed your user defined fields in DCR?
12-23-2009 01:25 PM
12-23-2009 03:02 PM
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.
12-23-2009 05:58 PM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide