topic Re: help me in pulling data into qlikview? in QlikView

help me in pulling data into qlikview?

durgabhavani — Fri, 22 May 2015 10:22:14 GMT

Hi All,

I have xml files in unix server. Now i need to pull the xml files into qlikview using winscp.

Can anyone help me to get he data?

This is highly appreciated.

Thanks,

Durga

Re: help me in pulling data into qlikview?

petter — Fri, 22 May 2015 10:31:53 GMT

You can use the EXECUTE statement in a load script to run WinSCP as a command line tool to retrieve the XML-files locally.

Re: help me in pulling data into qlikview?

petter — Fri, 22 May 2015 10:33:11 GMT

Alternatively you can schedule the command-line execution from your QMC if you have the QlikView Server Enterprise Edition.

Re: help me in pulling data into qlikview?

durgabhavani — Fri, 22 May 2015 10:38:05 GMT

Thanks for response petter!

Can you please make me clear with example using EXECUTE statement in loadscript. i am first time facing this type of loading data.

provide me screenshots. I have no access to qvw files.

Note: we have no QMC. so i need to implement at script level.

Thanks,

Durga

Re: help me in pulling data into qlikview?

petter — Fri, 22 May 2015 10:58:08 GMT

EXECUTE will send whatever is between EXECUTE and an ending semicolon as a command line to Windows. This command line will be executed and after completion of the command execution will contine on the next statement in your load script like:

EXECUTE c:\windows\system32\cmd.exe /c dir c:\ /s >directory-content.txt ;

This will start the Windows command processor and execute the DIR command which lists the file contenst and send the output to a file named directory-content.

In a similar fashion you could have an EXECUTE statement with WinSCP like this:

EXECUTE "c:\Program Files\WinSCP\winscp.com" /script=scp-script-to-do-the-retrieval-of-XML.txt ;

(don't try to run this without modification because this is only a made up example to give you an idea ...)

Re: help me in pulling data into qlikview?

petter — Fri, 22 May 2015 11:00:27 GMT

Here are some links that can help you get started:

Command-line Options :: WinSCP

Slicehost Articles: Automate File Transfer with WinSCP

Re: help me in pulling data into qlikview?

durgabhavani — Fri, 22 May 2015 11:40:05 GMT

Awesome Petter!

I got your points. I will try to implement the same from my side with modifications.

If i face any complications. I will get back to you.

Please provide me your mail id.

Thanks,

Durga

Re: help me in pulling data into qlikview?

petter — Fri, 22 May 2015 11:47:48 GMT

just send me messages directly via the forum if you need to - but the best is to post it on community anyway - I read and contribute almost daily anyway and you get the benefit of others competence to so they can contribute to solving your questions.