|Message: Re: How can we export data in .aida file into a spreadsheet?||Not Logged In (login)|
Click on the Forum title, e.g. on the "Forums by Category" page, to read a sequence of postings to the Forum and its threads all in one page. If you are only interested in one thread or the thread following a specific posting, click the thread or the posting, which takes you to a smaller page, which contains only the part you are interested in and may be easier to navigate.
Messages are "chained" if there are only replies at the first level, i.e. 1/1.html, 1/1/1.html etc. In case of "chained" messages the message number is replaced by the icon and there is no indentation.
Inline: Display the subject line only or also the text of the posting(s); for the choice "All" the "Outline" choices are switched off.
|1||0||1||no text / full text of posting|
|2||1||All||text for level 1 only / text for All postings|
Outline: Choose the depth of the posting thread, successive toggle controls provide increasing detail.
|1||2||1||2 levels / 1 level (original posting)|
|2||3||2||3 levels / 2 levels|
|3||3||All||3 levels / all levels (all postings)|
By "data stored in a .aida file", I assume that you mean a tuple, right ?
If so, we could imagine to provide a "csv like" output file (known by Excel) only in the case of a "flat booking", that is to say for a tuple with a list of columns not involving sub tuples (only basic types as int,double, float). In OpenScientist I handle the "ascii" format for this kind of tuple. If you use OSC, and have only one "flat booking" tuple attached to an AIDA::ITree (then attached to a file), you can try to use the "ascii" (or "hippodraw") file format string. In case of "ascii", in each row, data are "space separated". In case of "hippodraw" data are "tab separated" (then very close to a .csv format understood by Excel). (In both cases, I have a two lines header to save the Tuple title and the column string booking. For Excel, you may have to remove these two lines by hand).
Else what you can do also is to write an AIDA program that read your today .aida file, find the AIDA::ITuple and loop on the AIDA::ITuple rows and row items and then write a new file at the .csv format by using the standard C / C++ file and stream tools. It should not resist too much. (Huum, I think that we can even write a very general / generic program "over the AIDA API and C/C++ standard libs" that can do that... (That would then work with all AIDA implementations). We have the AIDA::ITuple::columnType, that would permit to handle all columns data types in a generic way. Could be a good exercise... Moreover you would have the full control of the kind of separator to use, and on the choice to include or not a header).