Exporting Fields in a DataModel that also contains a DataTable.

strotelli

How do I choose a DataModel as a Data Element in an Grooper Database Export step when my DataModel also contains tables?

RandoCalrisian

You need to have separate Export activities.
In my example, I'm using DatabaseExport.

One DatabaseExport's DataElement will be mapped to the DataTable object and be mapped to a table in a SQL database.

This DataModel also contains DataFields, and they are in a DataSection using a generic RegEx pattern of:
.*
This pattern simply lets the DataSection reference the whole document, as it is a requirement for a DataSection to have an extractor.
The second DatabaseExport activity's DataElement will be mapped to the DataSection. Each of the DataFields within this section will, as a result, be mapped to fields in a separate SQL table.

RandoCalrisian

I feel it necessary to expand on this idea.

The example I listed above is a specific case where the DataTable has to be mapped separately from the listed DataFields because the ContentModel contains multiple DataTables, and, the DataFields are not higher in the hierarchy than the table is.

In the example I have below, one could map the DatabaseExport step's DataElement property to the table01 DataTable.  As a result, the DataFields of table01, and all DataFields that are higher in the hierarchy than the DataTable, can be mapped in one DatabaseExport step.  However, were another DataTable to exist in this ContentModel, a separate DatabaseExport step would have to be used for it.

DungVu

Randell,

Where can I find the SQL export unattended activity library?

Thanks

DungVu

Sorry! I mean Randall.

DungVu

Never mind! I found it in Activity step. Thanks