Set a date/lookup in ListInstance elements.xml

Question

I have two lists. The first one has customers and the second one has Orders. Now i want to add some (test) data in the elements.xml of the listinstances. For customers this works without a problem

    <Row>
      <Field Name="Id">1</Field>
      <Field Name="FirstName">Beni</Field>
      <Field Name="LastName">Egli</Field>
    </Row>

Now I want to do the same for the orders. An order is linked to a customer via a lookupfield. I also want to set the date to (for example) today.

    <Row>
      <Field Name="Id">1</Field>
      <Field Name="CustomerLookup">2</Field>
      <Field Name="Date">[today]</Field>
    </Row>

The Date=[Today] can't even deploy and when I remove the date line no entries are added (date is not required)

Answer 1

This will not work because Sharepoint will eventually put every list item in the same table in the database. The order item will not be added since an item with ID=1 already exists. (the customer item).

It is not recommended to add list items this way, and as suggested above you could use a feature event receiver to add items instead.

If you would like to use the xml make sure that the ids do not match. This can be tricky when you get a lot of lists and items in them.