Experimenter and Global Table Output

Question

question

Nicholas B asked Oct 20 2017 at 5:07 PM Nicholas B commented Nov 14 2017 at 5:42 PM

Experimenter and Global Table Output

I am wondering are global tables populated with data while using the experimenter? I am collecting data about a patient as they go through my logic and recording information into a global table. This data is then output to a database where I already have extensive reports designed for analysis. When I try to output the data from my global table to my database at end of replication using the experimenter it shows 0 rows of data.

global table experimenter database output

Answer 1 · 2017-10-20T17:50:22Z

Cliff King answered Oct 20 2017 at 5:50 PM Nicholas B commented Nov 14 2017 at 5:42 PM

Because the Experimenter creates multiples instances of the software to run the separate replications in RAM on each of your cpu cores, special handling is required to store off the information in the global tables at the end of each replication. This use to be a difficult task for users, but with the addition of a new pick list option in the "End of Replication" trigger found on the Experimenter's Advanced tab called "Dump Global Table Data To An External CSV File", it's now easy. This pick list option is only available in the latest (5.3.2) version of the software.

dumptabledatapickoption.png (53.5 KiB)

· 3

Nicholas B commented · Oct 20 2017 at 5:55 PM

Will there be any option in the future to output to a database? Output to a .csv is one step better than what is there currently, but it requires an extra step to get data into my database.

0 ·

Cliff King Nicholas B commented · Oct 20 2017 at 6:04 PM

There might be, but the problem I had trying to write to Excel for instance was in making connections to the same workbook from multiple cores on the same computer. Excel wouldn't let me do it.

0 ·

Nicholas B Nicholas B commented · Oct 20 2017 at 6:15 PM

Thanks for the information. I was sensing that was the problem when access was giving me the locked by another user error. But what your saying is that data is being recorded in the Global Tables even though when I check to see how many rows are in that table are 0?

0 ·

question