CreativePro Forum

Return to Member Forum

• Author
  Posts
• • July 20, 2010 at 8:02 am #56408
    Jaime de Vos

    Member

    Hello everyone!

    I need to create an A5 spread booklet that contains price lists and product specifications. (see example.) The content will be available in different languages and for different regions.

    The content on the left is always the same, the content in the tables on the right is variable. (Price differences between Canada, Germany, France or even North- and South France etc.)

    I'd love to be able to “data merge” the content into the tables. But I do not how to combine datamerging and Tables. Heck I'm not even sure if that's the preferred way of doing things.

    Another kicker, I don't always know the amount of rows/columns needed beforehand.

    Example:

    

    I reckon there is no need for reinventing the wheel. Can you guys to help me out?

    Thanks!

    Jaime

  • July 20, 2010 at 3:29 pm #56411
    David Blatner

    Keymaster

    This is probably better handled via excel import or XML. Data Merge isn't really made for this.

  • July 20, 2010 at 7:54 pm #56414
    Anne-Marie Concepcion

    Member

    If you were using InDesign CS4 or CS5, there's probably a way to do this with conditional text. (You can “pre-tag” the prices with the conditions before you import them.)

    AM

  • July 22, 2010 at 4:24 am #56432
    Jaime de Vos

    Member

    I´ve delved into XML and have written the code shown below.

    I've been able to import all the data into a bunch of replicated text frames using tags .
    But I've been unable to repeat the process with Tables. On top of that, when adding a Tag to text in a table, a couple of new Tags are created, like “Cell”, “Story” and “Table”. I'm not sure what use they are, as they're not listed in my XML code.

    Is it not possible to populate a table in this manner, or am I missing something?

    <?xml version=”1.0″ encoding=”UTF-8″ standalone=”yes”?>
    <Article01>
    <ArticleData>
    <ArticleNumber>GH0211</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 1</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0212</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 2</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0213</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 3</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0214</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 4</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0215</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 5</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0216</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 6</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0217</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 7</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0218</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 8</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0219</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 9</Description>
    <Price>20.000</Price>
    </ArticleData>
    <ArticleData>
    <ArticleNumber>GH0220</ArticleNumber>
    <Description>Lely Bla Bla Bla XX 10</Description>
    <Price>20.000</Price>
    </ArticleData>

    </Article01>

• Author
  Posts