topic Re: Export text file from XMC in ExtremeCloud IQ- Site Engine Management Center

Export text file from XMC

Lunee — Tue, 21 Sep 2021 20:04:50 GMT

Hi,

I am new to XMC workflow.

I have created a workflow that list all the Non Eap ports with port name/descriptions. I need to export output in the form of text file for each switch. I can do it manually through workflow input. But I need to automate this process so that I can schedule workflow.

Re: Export text file from XMC

StephanH — Tue, 21 Sep 2021 20:16:17 GMT

Hello Lunee,

you have two options, among others:

For example, you can use the "Activity" mail in the workflow and send the information to you by mail.
Or you can save the text file in the file system of the Linux OS. If you include a network share in the Linux/XMC, then you can also store the text file there.

You can realize the whole thing easily with Python as a workflow.

Re: Export text file from XMC

Lunee — Tue, 21 Sep 2021 20:23:29 GMT

Thank you for the answer.

I am able to save the text file for one switch with the custom input. I need to do it for several switches and need to have a textfile for each switch.

Re: Export text file from XMC

StephanH — Tue, 21 Sep 2021 20:33:14 GMT

Ahh,

ok I asume you contact your switches via a python script. You can start your script against the first switch and than you can change the device focus to other switches with:

cli_result = emc_cli.setIpAddress(switchIp)

and close the session to the switch with

emc_cli.close()

In that way you can move thru your switches within a single workflow and you can write a file for every switch.

Does that help?

Re: Export text file from XMC

Lunee — Wed, 22 Sep 2021 14:23:46 GMT

from xmclib import logger
from xmclib import emc_vars
import json
import re

def wf_info(log):
    print 'INFO:' +log
    logger.info(log)

def execConfigCmd(cmd,Wait=True):
    wf_info("running cmd " + str(cmd))
    cli_results = emc_cli.send(cmd,Wait)
    if cli_results.isSuccess() is False:
        wf_error("ERROR EXECUTING COMMANDS")
    output = cli_results.getOutput()
    return output

execConfigCmd("enable")
execConfigCmd("terminal length 0")
text = execConfigCmd("show eapol multihost interface")
print(text)

import re
p = "(?<=Non-EAP RADIUS Authentication)(.*)(?=\n)"
matches = re.findall(p, text, re.MULTILINE)
print(matches)
port_pattern = "(?<=Port)(.*)(?=\n)"

portmatches = re.findall(port_pattern, text, re.MULTILINE)
#print(portmatches)
matches1 = [str(x.replace(":","").strip()) for x in portmatches]

count = 1
non_eap_port = []
for m in matches:
    status = m.strip().replace(":","").strip().lower()
    print("status", status)
    if str(status) != "disabled":
        emc_results.put("Finish", "True")
        non_eap_port.append(matches1[count])

    count +=1

print(non_eap_port) 

#varMatchedPorts = non_eap_port
#varMatchedPorts =[str(x) for x in eval(varMatchedPorts)]
port = ",".join(non_eap_port)
print("port", port)
out = execConfigCmd("show interface name %s"%port)
print ("out", out)

try:
    f = open(emc_vars["Attachments"], "w")
    f.write(execConfigCmd("show interface name %s"%port))
    f.close()
except:
    wf_error("Can't write to file %s" % emc_vars["Attachments"])
    status = emc_results.Status;
    emc_results.setStatus( status.ERROR )

Re: Export text file from XMC

Lunee — Wed, 22 Sep 2021 14:26:50 GMT

This is my script for workflow. From here I can save my file to /tmp/Switchname.txt from the custom input.

I want this custom input to be dynamic so that the filename is changed acording to the switch name.

Re: Export text file from XMC

StephanH — Wed, 22 Sep 2021 14:45:04 GMT

Hello Lunee,

it is not clear to me What is your question.
Do you want to know how to read the switch name or its IP?

Re: Export text file from XMC

StephanH — Wed, 22 Sep 2021 14:49:22 GMT

Here is a link to the API documentation: http://api.extremenetworks.com/

In addition have a look at Markus Nikulski's last entry here, please.

It is discouraged by Extreme to use the xmclibs direct.

Re: Export text file from XMC

Lunee — Wed, 22 Sep 2021 14:50:21 GMT

I want to export .txt file. for example if it is saved to x.txt file for one switch then next time when the workflow is run I want it to be saved to y.txt file.

Re: Export text file from XMC

StephanH — Wed, 22 Sep 2021 15:00:55 GMT

Ah ok,

Workflows can’t save data during different runs. In that case I use a file (in the file system).

At first run I save to the let’s say status.log the info X.

At the second run I save Y to the status.log.

At every run I open the status.log and check what is stored in.