Deploying and Managing Apama Applications > Using the Apama Database Connector > Format of events in .sim files
Format of events in .sim files
In Apama 4.1 and earlier, Apama captured data streaming through the correlator into proprietary .sim files. These files consist of comma-delimited values. You can use the Apama Studio Data Player to play back event data from existing .sim files. Note, however, that the ADBC does not write data in .sim format.
Apama .sim files contain string versions of events and can also contain an optional header that specifies the default timezone for the series. The timezone identifiers can be any supported by Java 1.7. The format of the events contained in a .sim file is:
*timestamp — a float specifying UTC seconds since 01/01/1970.
*event origin — a string specifying whether the event is an internal or external event.
*event — a stringified version of the event itself.
Elements of the exported event are separated by commas.
The following is an example of an external event from a .sim file (each event is stored on a single line, here they are shown on separate lines for clarity):
1161287634.200,
    external,
    com.apama.backtest.RawTick(
        com.apama.marketdata.Tick("RACK",34.97,11,{}))
The following is an example of an internal event from a .sim file:
1161287629.600,
    internal,
    com.apama.backtest.RawTick(
        com.apama.marketdata.Tick("RACK",34.96,64,{}))
The events in the example are RawTick events with embedded Tick events.
The following is an example of the optional header containing a specified default timezone:
#
# <Timezone=America/New_York>
#
Comments in .sim files
You can add comments when you edit .sim files. Introduce lines containing comments with either # or //.
Copyright © 2013 Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.