ESF Import: Feature to Import (Update) only object name

[manos@dynamitec]

Hello All,

Is there any way to import the ESF file to the LM but only update the names? Because the objects exists into the LM if I try to import the new file, with some GAs names changed, the objects will be discarded. I have already imported the ESF and proceeded with the visualization so I want to avoid retagging them, redefining the datatypes and visu parameters.

Regards,

[admin]

Enabled FTP server on LM, then upload data.esf to root directory (use ftp account). Then run this script once. ESF file will be deleted once this script runs.

Code:

data = io.readfile('/home/ftp/data.esf')

if data then
  lines = data:split('\n')

  for _, line in ipairs(lines) do
    props = line:split('\t')

    if #props >= 5 then
      addr = props[1]:match('[0-9]+/[0-9]+/[0-9]+$')

      if addr then
        name = props[2]:trim()
        id = buslib.encodega(addr)
        db:update('objects', { name = name }, { id = id })
      end
    end
  end

  os.remove('/home/ftp/data.esf')
end

[manos@dynamitec]

Enabled FTP server on LM, then upload data.esf to root directory (use ftp account). Then run this script once. ESF file will be deleted once this script runs.

Code:

data = io.readfile('/home/ftp/data.esf')

if data then
 lines = data:split('\n')

 for _, line in ipairs(lines) do
   props = line:split('\t')

   if #props >= 5 then
     addr = props[1]:match('[0-9]+/[0-9]+/[0-9]+$')

     if addr then
       name = props[2]:trim()
       id = buslib.encodega(addr)
       db:update('objects', { name = name }, { id = id })
     end
   end
 end

 os.remove('/home/ftp/data.esf')
end

GREAT!!! Worked like a charm  

Always giving solutions to us. Thank you again and again and again Admin...