Register | Log In
Download Contact
Resources > Forums
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsForm and ListForm and ListImporting Dataset From MS Excel into UDTImporting Dataset From MS Excel into UDT
Previous
 
Next
New Post
7/6/2008 7:03 PM
 
User is offline GPO706

Joined: 11/18/2007
Posts: 9

Hi All

I have an Excel spreadsheet containing 400+ rows of data (contacts list) that I would like to import into an existing contacts UDT.  Is this possible, looking at the import function on the UDT itseems to allow only a module??? to be imported, I need the data from the Excel sheet to be added.
 
New Post
7/6/2008 7:49 PM
 
User is offline Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 36759

there is no official UI, you can try to setup a UDT module with appropriate columns and 1-2 test rows, export the module, which will generate an XML file and replace your test rows with an xml export of your Excel table. save the file and re-import it. Make sure, to create valid XML and all field values match the column type.

Cheers from Germany,
Sebastian Leupold (DotNetNuke MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals
 
New Post
7/13/2008 5:43 AM
 
User is offline Paul

Joined: 6/23/2008
Posts: 2

HI Sebastian,

This is my first post to the DNN forums. Please forgive any obvious naivete.

I looked at DNN a couple of years ago, between versions 2 and 3 in development. I've recently taken on a project which has multiple architectural issues, and the possibility of importing Excel worksheets is one.

Is this response (above) the latest and final method? I will have Users who, after downloading and filling out worksheets, may want to upload the data for further processing.

Paul
 
New Post
7/13/2008 9:30 AM
 
User is offline jim gurley

Joined: 4/16/2008
Posts: 108

The XML approach is probably better if you're comfortable with it.  I did a similar thing (I had a 400 x 10 excel table) by saving the spreadsheet as a CSV file, then processing it with Autoit3, which is a simple scripting language for Windows that allows you to create keystrokes, mouse movements etc.  I just ran the script and it did the work in about 20 minutes while I walked the dogs.  I could provide the script I used (a whole 30 lines of 'code') if you're interested.  I wish there was a way to run Autoit3 scripts from within DNN, as it would make many onerous tasks trivial.
 
New Post
7/13/2008 11:46 AM
 
User is offline Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 36759

Hi Paul,

UDT does not support Excel import, if you need your users to upload files for further processing, you can use UDT or any other upload module like Repository to allow your users to upload Excel files, but you will not be able to display the content immediately. There used to be a module "MagicExcel" from www.portalfabrik.net, which is able to display content of a single XLS file, you might contact the developer Philipp Becker, if he is willing to combine his module according to your needs.

Cheers from Germany,
Sebastian Leupold (DotNetNuke MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group   European Network of DotNetNuke Professionals
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDotNetNuke Forg...DotNetNuke Forg...Module ForumsModule ForumsForm and ListForm and ListImporting Dataset From MS Excel into UDTImporting Dataset From MS Excel into UDT


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.

Attend A Webinar
Start Professional Edition Trial
Have Someone Contact Me

Like Us on Facebook Join our Network on LinkedIn Follow DNN Corporate on Twitter Follow DNN on Twitter

Advertisers

Sponsors

DotNetNuke Corporation

DotNetNuke (DNN) provides a suite of solutions that make designing, building and managing feature-rich sites and communities fast, easy and cost-effective. The DotNetNuke Platform CMS is the foundation for more than one million websites worldwide. DNN Social, our newest solution, enables businesses to create immersive, interactive communities. Thousands of organizations like True Value Hardware, Bose, Cornell University, Glacier Water, Dannon, Delphi, USAA, NASCAR, Northern Health and the City of Denver have leveraged DNN to deploy highly engaging business- critical websites. Our rapid growth in product sales and deployments resulted in DotNetNuke Corp. being named one of the fastest growing private companies in America by Inc. Magazine in 2011 and 2012.
Copyright © 2002-2013 DotNetNuke Corp. / Terms of Use / Privacy
Hosted by MaximumASP