I want to export all items ticked within one User Defined Field, into an Excel spreadsheet, but when I try this only the first item ticked appears in the relevant column on the spreadsheet.

Is there any way of exporting all the items ticked within one User Defined Field?

That appears to be a limitation of exports which include table-type UDFs.

You could use the Maximizer ODBC driver and MS-Query to pull data into Excel via

Data > Get External Data...

but that might be more trouble than it's worth, particularly if you are working with a relatively small number of UDF values. If so, then one workaround would be to export each UDF value (and associated Address Book information) to a separate file, then pull each one into Excel, sorting and merging the data as you go.

.....great, thanks Gord for your suggestions, I'll give these a try!

Regards
Imelda

quote:

---

Originally posted by Gord Thompson:
That appears to be a limitation of exports which include table-type UDFs.

You could use the Maximizer ODBC driver and MS-Query to pull data into Excel via

Data > Get External Data...

but that might be more trouble than it's worth, particularly if you are working with a relatively small number of UDF values. If so, then one workaround would be to export each UDF value (and associated Address Book information) to a separate file, then pull each one into Excel, sorting and merging the data as you go.

---

A colleague showed me a workaround for this:

If you have a table-type UDF that can assume multiple values, simply repeat the field name in your export specification as many times as necessary to spit out all of the values. For example, an export specification like...

Last Name
First Name
Hobbies
Hobbies
Hobbies

...might yield an export file that looks like

"Adams","Amy","Hydroplane Racing","",""
"Bell","Bob","Gardening","Painting","Theatre"
"Carson","Carol","","",""
"Davies","Doug","Carousing","Fighting","Making Bail"

This is great Gord, thanks for your response, I have struggled around this problem for ages and this is the solution I needed, thanks again, much appreciated, Regards Imelda

quote:

---

Originally posted by Gord Thompson:
A colleague showed me a workaround for this:

If you have a table-type UDF that can assume multiple values, simply repeat the field name in your export specification as many times as necessary to spit out all of the values. For example, an export specification like...

Last Name
First Name
Hobbies
Hobbies
Hobbies

...might yield an export file that looks like

"Adams","Amy","Hydroplane Racing","",""
"Bell","Bob","Gardening","Painting","Theatre"
"Carson","Carol","","",""
"Davies","Doug","Carousing","Fighting","Making Bail"

---

Thank you so much for posting this. It saved my life!