Skip to main content

Replies sorted oldest to newest

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"

Add Reply

Post
LEGAL INFO
CONTACT US
Copyright 2007-2018 Advoco Solutions Ltd. All Rights Reserved.
×
×
×
×
Link copied to your clipboard.
×