export records with joins

[prophoto]

I have a large set of data (LIS Site, list #2) and I would like to export all records with the categories. Category lists are separate (#8 and #9) and assigned via CDD elements.

Not sure how else to explain what I need here...feel free to ask more questions! Thanks...

 

[cheesegrits]

Export how? CSV? Have you tried? If you export with both raw and non raw data, you should get a CSV which has the selected values/labels for your joins and CDD's.

If you need the entire categories lists, you'll need to export those as a separate operation.

-- hugh

 

[prophoto]

Yes, CSV. I have tried and it does not export any category info (CDD).

 

[prophoto]

bump

 

[cheesegrits]

I can't reproduce this,I just tried on three different lists with CDD's, and they all export both raw and non-raw data just fine.

Can you post a screenshot of your CSV export settings?

-- hugh

 

[prophoto]

 

[prophoto]

Also how do I export without the additional _raw columns if they are not necessary?

 

[cheesegrits]

Also how do I export without the additional _raw columns if they are not necessary?

Set the rather appropriately named "Include raw data" option to No should do it. Does that not work for you?

-- hugh

 

[prophoto]

I hate it when I miss the obvious! Damn!

 

[cheesegrits]

I did an export on that list, and unless I'm missing something obvious, it seems to be exporting all data? Which element(s) are you having issues with?

-- hugh

 

[prophoto]

34 & 45. category and subcategory.

 

[cheesegrits]

OK, I think this is because you have both "Show in list" and "Include in list query" set to No on the Category elements. So we simply aren't including it in the export.

-- hugh

 

[prophoto]

I read the tooltip for "Include in list query" but I don't quite follow what it does, can you explain?