webcamanna.blogg.se - Exporting contacts from producteev by jive

#EXPORTING CONTACTS FROM PRODUCTEEV BY JIVE DOWNLOAD#

I suppose I could filter on specific activities and then piece it all back together, but see above about not fun and not a productive use of my time. There are more than 50,000 rows of data for a single day in the Content file, but the smallest increment of data I can select is one day. Because of the 50k row limit, I can't get usable data for Content.Not fun and not a productive use of my time. Since there are four different types of file, that means four downloads for each day's data.

#EXPORTING CONTACTS FROM PRODUCTEEV BY JIVE DOWNLOAD#

It's a huge time suck to have to download file after file of daily data to try to make sure no records will be omitted. It looks like I'm going to have to build some way to match on username and look up in some other table the profile data I need. These fields are not part of the data set I can get from Jive DES. The most valuable attributes are our custom profile fields, of course, containing valuable data such as Business Unit.

I need to be able to filter my data based on attributes in our user profiles.

So I am challenged to join tables, after all.

I thought all of the data was going to be in one giant table, but the Jive DES Explorer offers four separate download options.

Is that possible, and if so, how is it done?

I thought I would be able to connect directly to the Jive Analytics database with a tool such as Tableau.

Here are the issues I am encountering and would love to have help resolving: Perhaps I just need simpler directions, which I would be grateful to follow. I'm sorry to say that my initial experience with the Jive DES has been underwhelming in terms of outcomes and overwhelming in terms of difficulty.

We just upgraded to Jive Cloud in November and this week is the first chance I have had to dig into the Jive DES. I also read and re-read Using the V2 Jive Data Export Service (Analytics) in the hope that it would walk me through what I needed to know. I even attended the JW14 session by John Hungerford and Dirk McNealy, Jive Data Export Service – Turbo-Charge Your Jive Integration with Analytics - THURSDAY, OCT 23RD 4:30 PM – 5:30 PM to learn more. It sounded like a terrific resource that would be easy to use. I've been looking forward to using the new Jive Data Export Service ever since Josh Richau first started telling me about it. I've added in updates to the original post that reflect my current understanding. It's important to note that with endlessly patient guidance from Dirk McNealy I eventually mastered getting data from the Jive DES and have found it to be extremely valuable.