Re: exhibit, many to many without multiple entries in one field

2009-03-17 Thread David Huynh
mowi wrote: Hi David H, I have just tried that. It merged the rows but it has only put the last value in the field, not multiple values. so i have changed the excel so it looks like this: http://spreadsheets.google.com/pub?key=pEBZe9K5tabOdZXuL1uEoRQ Babel translates it to this .js:

Re: exhibit, many to many without multiple entries in one field

2009-03-05 Thread mowi
Hi David H, I have just tried that. It merged the rows but it has only put the last value in the field, not multiple values. so i have changed the excel so it looks like this: http://spreadsheets.google.com/pub?key=pEBZe9K5tabOdZXuL1uEoRQ Babel translates it to this .js:

Re: exhibit, many to many without multiple entries in one field

2009-02-26 Thread mowi
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

Re: exhibit, many to many without multiple entries in one field

2009-02-26 Thread mowi
Hi David, I know it works when I put multiple values in one excel field but I cannot do that because I am also using the same data in Access 2003. Access cannot handle multiple values in one field. On Feb 26, 5:08 pm, David Huynh dfhu...@alum.mit.edu wrote: Try to put first, second and third

Re: exhibit, many to many without multiple entries in one field

2009-02-19 Thread David Karger
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