#1 2011-08-09 06:59:56

**_vklym_**

Extract Data Via API

Hello All,

I am trying to extract data from the chat and/or note pods using the API's. Is there anyway that this can be done with the current API or do I need to make SQL query calls directly to the database?

Thanks,
Vlad

Last edited by **_vklym_** (2011-08-09 07:00:10)

**_bklaas_**

Re: Extract Data Via API

There's no API call at this time to do this. Additionally, chat history or note pad content is not stored in the database. Both are stored in remote shared objects that are created and managed by the Flash Media Interactive Server which powers Adobe Connect. These are binary objects and can't be simply decompiled into a text stream.

You may have to resort to some kind of automated UI interaction toolkit like Automator on the Mac to launch recordings, select the chat pod, do a "Select All," copy, then handle the resulting text as you see fit.

**_Jorma_at_RealEyes_**

Re: Extract Data Via API

If you are on a licensed deployment you may want to try turning on the Chat Log feature in Administration > Compliance and Control > Recordings and Notice.

If you do the chat logs should be stored here

Select Enable Chat Transcripts to log all chat messages on the server. The transcripts contain the name of the room, the name of the sender, the name of the recipient, the date and time, and the message body for each chat message. Transcripts are stored on the Adobe Connect server in the folder rootinstall\content\account-id\sco-id-version\output\ (for example, C:\breeze\content\7\21838-1\output). The file name format and type is roomname_date_time.xml. Chat transcripts do not log text in the Note pod and chat communication in breakout rooms. To record all text-based conversation, disable the Note pod and breakout rooms.

**_vklym_**

Re: Extract Data Via API

Hi Jorma,

We do have an on premise Adobe Connect setup and we have enabled chat transcripts already. I was just wondering if there was a systematic way, like using the Web Services, to make an API call to obtain necessary chat.

**_gajett_**

Re: Extract Data Via API

vlad,
while it isn't possible using just the connect api, chat transcripts are stored as .xml files, which you mentioned you would have access to since you are on-premise.
you could run a search/report on the hosting server to show new ftchatX.xml files (x is 1, or 2, or 3, etc....) since time x:xx then do something with those, since they are just xml.
maybe something with WSH, then bring them into whatever you want to view them with?

otherwise there are methods to find out which folder in /content/7/XXXXX (typical storage path) houses a particular meeting's data, if you just want to find/extract one at a time.

greg