Take nodes from one DDBB to another DDBB

[aeixea]

Hi:

At work i use an HTML (pus php, plus JavaScript, plus CSS...)  program wich store all info about nodes into Postgresql DDBB.

I need to take the infro from this DDBB and put it into netxms mysql DDBB, the info runs from IP address to user and password list to access de node.

I know my own DDBB (Postgresql) but i don't know WHERE put de info in netxms DDBB (wich table, wich column...).

If this not work, i must insert MANUALLY more than 3000 nodes into netxms DDBB and then set the specific config for each one (IP, SNMP or NXAGENT, user, password...) manually too.

I will try do make templates for change the configuration as bit as posible but i need "speed" the insert part of equation.

Thnx in advance.

[tomaskir]

I suggest either using nxshell or NetXMS API to do this.
I personally use the NetXMS Java API to mass insert/update nodes in NetXMS programatically.

Documentation is available on the wiki.

[aeixea]

Hi,
Thanx for response, i discover csv-importer and works grate but... when i add or modify something in mysql database for netxms, the data not appear on webui (or nxmc).

The data are there but netxms ignore it.

Where can i found documentation abut java api?

Sound interesting...

[victor]

Hi,

you should not modify anything in database directly while server is running. Server caches lot of information in memory and do not expect changes in database. They will be either ignored or even rewritten. You should use Java API or Python scripts (nxshell) to manipulate data in NetXMS programmatically.

Best regards,
Victor