Try to put first, second and third into the same cell in the {child}
column, separated by semicolons
first; second; third
David
mowi wrote:
> Hi David,
>
> Thanks for making a quick example. I understand how my JSON file
> should look like but I do not make my JSON by hand, that would be too
> much work..
> I generate my JSON file with babel from an excel sheet.
> I cannot figure out how I can get babel to generate a file like
> your .js file
>
> my excel file looks like this:
> http://spreadsheets.google.com/pub?key=pEBZe9K5tabOdZXuL1uEoRQ
>
> and the JSON that is generated by Babel like this.
> http://www.moniquedewilt.com/test/manytomanytest.js
>
> I have tried making to seperate JSONs, one with the items and one with
> the connections but that did not work either. Babel only makes one
> "record" for each item and only one value in each field. when the item
> appears multiple times in excel with the same field, babel only uses
> the last value for that field.
> Any clues how to get Babel to do this?
>
> On Feb 26, 4:21 pm, David Karger <[email protected]> wrote:
>
>> Take a look at
>> http://people.csail.mit.edu/karger/Exhibit/example.html
>> and you'll see that "thing" has three children first, second, and
>> third. If you look at the data file
>> http://people.csail.mit.edu/karger/Exhibit/data.js
>> you will see that those children were introduced using two separate
>> mentions of "thing"
>>
>> mowiwrote:
>>
>>> Hi David,
>>>
>>> I tried it like you said and made a third excel sheet for the
>>> connections. The authors are now connected to the articles but
>>> instead of multiple authors only the last author got connected to the
>>> article in the JSON file. I used Babel to convert the excel file to
>>> JSON. I have also tried to convert to JSONP but that didn`t matter.
>>> Any ideas?
>>>
>>> On Feb 19, 2:52 pm, David Karger <[email protected]> wrote:
>>>
>>>> It's ok; you can use author and article as ID even if they appear
>>>> multiple times. First do the obvious thing, creating items for the
>>>> exhibit corresponding to the authors and articles (using author name as
>>>> id for the authors, and article title as id for the articles):
>>>> {type: "Author", id: "name of author", affiliation: "affiliation of
>>>> author"...}
>>>> {type: "Article", id: "title of article", year: "year of publication",
>>>> ....}
>>>>
>>>> Finally, take your relationship table. Suppose it has a row (authorX,
>>>> articleY)
>>>> add another fragment of json to the collection of "items":
>>>> {id: "articleY", author: "authorX"}
>>>> Do this for every row. This will accomplish what you want.
>>>>
>>>> To understand what is going on, note how exhibit will interpret these
>>>> final fragments from the relationship table. It will say "ok, this
>>>> person is specifying an item whose id is articleY and has an author
>>>> property with value authorX. But I already know about an item whose id
>>>> is articleY---namely, the one that was defined at the beginning of type
>>>> "Article". So, I'm not going to create a new item with id articleY.
>>>> Instead, I will _merge_ the attributes of the new item (in particular,
>>>> the author relationship to authorX) into the already existing item. And
>>>> if that item already has a value of the author property, because I
>>>> already saw an author of that article, then I will _add_ authorX as an
>>>> additional value for the now-multivalued author property on articleX."
>>>>
>>>> mowiwrote:
>>>>
>>>>> hi,
>>>>> I have some data with many to many relationships just like the
>>>>> articles and authors in the example website about ISWC 2007 + ASWC
>>>>> 2007.http://people.csail.mit.edu/dfhuynh/projects/graph-based-exhibit/grap...
>>>>>
>>>>> there it is solved by putting multiple persons in the "author" field.
>>>>>
>>>>> I have a problem getting multiple values in one field because the
>>>>> data is from acces 2003. I have got one table with articles, one with
>>>>> authors and one with relationships. The relationship list has three
>>>>> columns:id (which I do not really use), author and article. Can i also
>>>>> do it like that in exhibit? how can I do that?
>>>>> In the example you use ".author.affiliation" to get a value from the
>>>>> author list in the article overview. Author is an id there. In my
>>>>> relationship list both author and article cannot be id because they
>>>>> appear multiple times.
>>>>>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SIMILE Widgets" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/simile-widgets?hl=en
-~----------~----~----~----~------~----~------~--~---
