CSV mass import failing to add nodes, can be added manually.

Hi all,

I have a few hundred servers I need to import into LogicMonitor.

I think the best approach is to add them wholesale via CSV file.

I ran a test batch CSV file with 4 servers. 3 of them added successfully, the failed one I added via gui without incident. Strange.....

I ran a 2nd batch with 7 servers. Of these, only 2 were added into LogicMonitor.

I find it unlikely this is a syntax error seeing as at least some are being added, but I can see no good explanation why it is not adding all entries from CSV file.

Robert_Apodaca

Posted 6 years ago·Last reply 4 years ago

4 comments

LM User

·4 years ago

The syntax looks like this:

<span class="pln">IP,displayname,hostgroup,properties
10.0.0.10,Device from CSV,New Target Group,"prop.one=firstproperty
prop.two=secondproperty"
10.0.0.11,Another Device from CSV,New Target Group,"prop.one=firstproperties
prop.two=secondproperties"</span>

Notice how the properties are separated by a newline. Seems odd to me, but it should be doable. Even in Google Sheets, i was able to insert a carriage return in the properties column and it exported with the correct syntax that I could then import into LM.

Rakzskull

·4 years ago

@Stuart Weenig I'm having the same issue while adding multiple properties or not sure how define multiple properties in correct way. :)/emoticons/smile@2x.png 2x" title=":)" width="20" /> Your guidance would be appreciated. Thanks in advance.

LM User

·6 years ago

Covering bases here:

you've read https://www.logicmonitor.com/support/settings/netscan-policies/creating-netscan-policies-copy
your csv has both IP and displayName headers

Are there any other fields in your csv?
Are you passing in multiple properties?
Is there a carriage return after the last line (shouldn't be needed, but might be)?

Joe Williams

·6 years ago

Did it add them into unmonitored? Or just not add them at all?

1	SUYASH GAIKWAD
2	KV karthikeyan VG
3	ME Mir Ehtesham Ali
4	SN Sangeetha Nataraj
5	FG Feng Guo
6	SR Shankar Raman M