Output Report as .csv

  • Filter
  • Time
  • Show
Clear All
new posts

  • Output Report as .csv


    I need to get reports out of Quindos 7 in, preferably, .csv format (.nrp/.txt/.xml might do), can anyone point me in the right direction. I am a Quindos noob so go easy. Cheers.

  • #2
    The first thing you need to do is to open your csv file using on OPEN command. Once you have executed the OPEN command you can start to output data and there are several methods you could use. There is an OUTPUT command that will allow you to export object data from a Quindos database - for example ELE data from the LDB. You can also use LISEVA which essentially does the same thing as OUTPUT but is designed to output evaluation data or you can simply use the TEXT command and select the output device as the file you previously opened. With the TEXT command it will output a string. You can use variables to pull out the information you need and concatenate them together to form your csv file line by line. Be aware that if you use either the OUTPUT or LISEVA command you may also need to define a mask to format the data (I've attached a document explaining how to use masks).


    • #3
      Sorry, the file was too large to attach but if you let me know your email address, I can send it to you. Also, don't forget to close your csv file when you've finished exporting your data (using a CLOSE command).