question

Nicholas B avatar image
0 Likes"
Nicholas B asked Nicholas B commented

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 tableexperimenterdatabaseoutput
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

1 Answer

Cliff King avatar image
0 Likes"
Cliff King answered Nicholas B commented

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
5 |100000
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Nicholas B avatar image Nicholas B commented ·

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 Likes 0 ·
Cliff King avatar image Cliff King Nicholas B commented ·

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 Likes 0 ·
Nicholas B avatar image Nicholas B Nicholas B commented ·

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 Likes 0 ·