How to extract QVD data using .NET

[AlexUsov]

Is there any way to extract data from QVD file using .NET?

I need to get at least XML header to describe the fields in the table, the layout of the subsequent information and other meta-data

Thanks in advance.

[PiEye]

If you open a QVD in a text editor, you can see that the XML information is at the start of the file and easily readable. In C# .net, you can use xmlreader in a loop to parse the elements, stopping at the last element <\QvdTableHeader> 

See below c#

using System;

using System.IO;

using System.Xml;

public class Sample {

  private const String filename = "tesstQVD.qvd"; 

  public static void Main() {

     XmlTextReader reader = null;

     try {

        // Load the reader with the data file and ignore all white space nodes.

        reader = new XmlTextReader(filename);

        reader.WhitespaceHandling = WhitespaceHandling.None;

        var flag = true;

        while (reader.Read() & flag) {

           switch (reader.NodeType) {

             case XmlNodeType.Element:

               Console.Write("<{0}>", reader.Name);

               vlastXMLNode= reader.Name;

               break;

             case XmlNodeType.Text:

               Console.Write(reader.Value + "\r\n");

               break;

              case XmlNodeType.EndElement:

                if (reader.Name=="QvdTableHeader")

                    {

                        Console.Write("END OF QVD meta data xml");

                        flag = false;

                    }

                break;

             default:

                break;

           }

        }

     }

     finally {

        if (reader!=null)

          reader.Close();

     }

  }

} // End class

[AlexUsov]

Thank you @PiEye !

Your answer was very helpful, but that's not what I was looking for. This is my mistake in posing the question. I need to programmatically get QVD file from our QlikView servers and only then read the metadata.

Do you have information on how to do this?
Any answer would be appreciated.

Thanks in advance.

[PiEye]

Hi Alex!

Looks like I tackled the second bit, but not the first!

In this case you will need to find the path where the QVD's are stored, then loop through them and use the rest of my code above

If you change   the value in

private const String filename = "tesstQVD.qvd"; 

To the path  and filename of each QVD, it should then read the data from it.

Pi

[IllegalGoose]

---

@AlexUsov   wrote:         publix.org

Is there any way to extract data from QVD file using .NET?

I need to get at least XML header to describe the fields in the table, the layout of the subsequent information and other meta-data

Thanks in advance.

---

Thank you so much for sharing such a useful information.