Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Maximum ASP
  Ads  
Webhost4Life - $4.95 Windows Hosting
 


  Sponsors  

Meet Our Sponsors

Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
The Official Microsoft ASP.NET Website
Portal Webhosting - Hosting For Developers
Red-Gate Software
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  User Defined Ta...  Exporting Data from a UDT in readable form
Previous Previous
 
Next Next
New Post 8/26/2008 4:42 PM
User is offline Dale Burrell
224 posts
www.creative-dreaming.com
9th Ranked


Exporting Data from a UDT in readable form 

Hi Guys,

Is there a way to export the data from a UDT for use in say a spreadsheet?

I tried the export content module option, however the problem with that is it gives the encoded email address e.g. document.write(123,5,436,456) etc etc whereas I need the real email address.

Cheers,

Dale


www.creative-dreaming.com
 
New Post 8/27/2008 1:21 AM
User is offline Sebastian Leupold
15057 posts
www.deutschnetnuke.de
1st Ranked












Re: Exporting Data from a UDT in readable form 

you may either copy paste the output from the screen or use the "Show as XML" feature and import XML into Excel (though I never tried this).


Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
New Post 8/28/2008 6:05 AM
User is offline Dale Burrell
224 posts
www.creative-dreaming.com
9th Ranked


Re: Exporting Data from a UDT in readable format 

Unfortunately neither of those options work for me, the show in XML shows the javascript which hides the email address - otherwise it would be perfect - is that intentional? It would appear to me to make more sense to show the *real* email address in the XML document? And the copy and paste doesn't work because I don't display the email in text - for size reasons, so all the email addresses show as 'Email'.

Any other options?

 Sebastian Leupold wrote

you may either copy paste the output from the screen or use the "Show as XML" feature and import XML into Excel (though I never tried this).


www.creative-dreaming.com
 
New Post 8/28/2008 6:36 AM
User is offline Stefan Cullmann
1553 posts
5th Ranked








Re: Exporting Data from a UDT in readable format 

Yes, the purpose of the XML is not export but rendering support. If you look again at the XML, you will discover that there are more elements than columns defined - the "Hidden Columns". One of these Columns with the name "ColumnName"_UDT_Original contains the plain E-Mail address. On other way to get the plain data is to change the data type from E-mail to Text. It will not alter your data inside, only the way it gets returned to you.

 


Stefan Cullmann - stefan.cullmann [at] dotnetnuke.com
Form and List will be the successor of the User Defined Table module.
----------------------------------------------------------------------
Do you want to import external data to Form and List /User Defined Table?
Check out http://www.codeplex.com/Csv2UDTImport
 
New Post 8/28/2008 8:50 PM
User is offline Dale Burrell
224 posts
www.creative-dreaming.com
9th Ranked


Re: Exporting Data from a UDT in readable format 

Thanks for that - I see what you mean now - is there any way I can create a *different* view on the *same* data i.e. I could create a list of un-encoded email addresses which is only available to the admin login?


www.creative-dreaming.com
 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  User Defined Ta...  Exporting Data from a UDT in readable form
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


DNNhost Scandinavia
SUPER fast QuadCore DELL servers, MSSQL servers, DotNetPanel, daily backup, Check out our customers websites
DNNhost.dk
Personify Design, Inc.
Seattle-based Personify Design has developed customized DotNetNuke websites for a wide range of customers to meet many different types of needs, including distributed authorship across thousands of pages to integrated Verisign e-commerce capabilities.
www.personifydesign.com
DNN Outsourcing
50% more affordable services comparing to Western Europe and US: Custom DotNetNuke module development, skins, consulting, maintainence... Over 15.000 working hours of experience in custom DotNetNuke Solutions development, 8 years experience in outsourcing, excellent references!
www.dnnoutsourcing.com

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP