topic Re: Load Data from MongoDb with connector QvSource in Qlik Learning Discussions

Load Data from MongoDb with connector QvSource

Wed, 26 Nov 2014 08:27:09 GMT

I am connected to MongoDb with Qvsource.

I need to pull data from which sits array

Re: Load Data from MongoDb with connector QvSource

chrisbrain — Thu, 27 Nov 2014 07:16:09 GMT

HI Alex, can you provide more detail about the issue, are you getting an error or just finding you are unable to achieve what you want?

Re: Load Data from MongoDb with connector QvSource

Tue, 02 Dec 2014 07:47:34 GMT

Hi Chris.

I connected to mongodb with Qvsource. I need Bring data from 2 levels.

1 level with data type is array, I can load.

2 level data type array from 1 level when data type array.

qvsource bring empty data

Re: Load Data from MongoDb with connector QvSource

chrisbrain — Tue, 02 Dec 2014 08:06:53 GMT

HI Alex,

could you send the above info to support@qvsource.com and I will arrange a time to look at this over a screenshare with you?

Re: Load Data from MongoDb with connector QvSource

Tue, 02 Dec 2014 10:19:28 GMT

{

"_id" : "67_1049_1390845702446",

"_class" : "com.t2k.dtp.lms.model.classmanagement.rtcm.RtcmSessionProgressData",

"sessionTimestamp" : NumberLong(1390845702446),

"schoolId" : NumberLong(67),

"studyClassId" : NumberLong(1049),

"lessonsProgressData" : [

{

"lessonCid" : "ac3a3d40-ef94-4768-a8bb-ea99f4026db0",

"lessonVersion" : "1.0.6",

"courseId" : "cls_6ca7a46c-77dc-407c-b3b7-9a6d285ad89f",

"rtcmStudentSequenceProgresses" : [],

"rtcmTaskProgresses" : [],

"rtcmStudentOnSequences" : [

{

"studentId" : NumberLong(7947),

"sequenceId" : "c5e4ea33-8a40-44ab-956c-1e48bd2793cf",

"endTaskTimestamp" : NumberLong(1390845714394),

"endSequenceTimestamp" : NumberLong(1390845835159),

"lessonCid" : "ac3a3d40-ef94-4768-a8bb-ea99f4026db0"

{

"studentId" : NumberLong(7947),

"sequenceId" : "0b0a3f3f-adfe-4ce6-b258-451ac976cd1f",

"endTaskTimestamp" : NumberLong(1390845711878),

"endSequenceTimestamp" : NumberLong(1390845714202),

"lessonCid" : "ac3a3d40-ef94-4768-a8bb-ea99f4026db0"

}

]

}

]

}

I need Data from rtcmStudentOnSequences

Re: Load Data from MongoDb with connector QvSource

chrisbrain — Tue, 02 Dec 2014 10:22:45 GMT

Hi Alex - I am keen to help you with this but I don't think I can do unless we can do a quick screen share - is this not something you can do?

Re: Load Data from MongoDb with connector QvSource

Tue, 02 Dec 2014 10:24:57 GMT

I can't make sharing.

Re: Load Data from MongoDb with connector QvSource

chrisbrain — Tue, 02 Dec 2014 10:35:19 GMT

Do you mean because you are blocked somehow? We use Go2Meeting which we generally do not find users have a problem with.

If you could email us at support@qvsource.com then maybe we could at least try this out to make sure it won't work.

Re: Load Data from MongoDb with connector QvSource

Tue, 02 Dec 2014 11:28:38 GMT

it is not my data base and not my computer

Re: Load Data from MongoDb with connector QvSource

chrisbrain — Tue, 02 Dec 2014 11:30:37 GMT

Hi Alex,

I'm sorry it's a little difficult to help you. All I would need is a short session to be able to see what you are seeing and troubleshoot a little bit.

Re: Load Data from MongoDb with connector QvSource

Tue, 02 Dec 2014 12:37:44 GMT

I need the correct syntax. Qvsource call array from array

Re: Load Data from MongoDb with connector QvSource

chrisbrain — Tue, 02 Dec 2014 13:03:30 GMT

Could you confirm that you have read the notes here:

http://wiki.qvsource.com/MongoDB-Connector-For-QlikView.ashx#Extracting_Sub_Documents__Arrays_5

And let me know what you are entering for the sub document inputs?

Re: Load Data from MongoDb with connector QvSource

Wed, 03 Dec 2014 05:39:28 GMT

Hi Chris.

If array in sub document or item I can Load data.

My problem is when I need load data from array in array.

Re: Load Data from MongoDb with connector QvSource

chrisbrain — Wed, 03 Dec 2014 07:31:12 GMT

Hi Alex,

As per the docs there is limited support for this:

This connector has limited support for extracting arrays from MongoDB to QlikView and Qlik Sense...

It is still possible for MongoDB to have more complex nested array structures which QVSource is not able to deal with effectively but the above should allow users to get the required data in a large number of cases.

However - the very latest version of the connector does include limited support for including array indexes in sub key document path, for example you should be able to enter '/subkey1/subkey2[3]/subkey3'. This will not let you enumerate arrays of arrays in QlikView/Qlik Sense from MongoDB but it should let you enumerate arrays at certain indexes of sub arrays.

If this might help and you would like to try out this feature please send me a note at our support address referring to this post and I will send you a preview build (otherwise it will be included in the next official release, likely later this Month or in January).