Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListUser Defined Tables - Data Import Possible?User Defined Tables - Data Import Possible?
Previous
 
Next
New Post
11/9/2007 4:28 PM
 

As I am moving an existing website into DNN, one of the modules that I have needed to use is the User Defined Tables. It's a great module, and it very easily fits my need, save for one thing: Data Imports. The functionality that the module is replacing has a LOT of existing data, and I just don't fancy inputting all of it by hand. I can make an export routine that will export it into the XML format that DNN 4.6 uses, but I have a couple of questions that need to be answered before I go charging ahead.

  1. Do I need to worry about generating the uinque ID values in the <UserDefinedRowId> field?
  2. How exactly are the values in the "*UDT_Ticks" fields derived?
  3. Am I going to kill anything by importing a bunch of data?
 
New Post
11/9/2007 4:44 PM
 
  1. no
  2. DateTime.toTicks
     you don't need to provide every column, for example ticks is really not needed for import. The data that is used for import is either in  the element column or column_UDT_Original
  3. You might kill  the current module, not more
  • Most important for a successfull setup are the C&C columns: Created/changed/by/at
  • Please contact me per mail, I might be able to help you a step further.
 
New Post
11/19/2007 6:40 PM
 

Is it possible to schedule regular imports of data? If so, how is the specific module addressed in the scheduler?

Also, I'm not having much luck with the data import. I've gone through the XML file and it's laid out right, but when I try to import data there is nothing imported and no error messages are shown. If needed, I can post the formats of both the sample data XML and what my data export is generating.

 
New Post
11/21/2007 1:32 PM
 

Quick update on the import situation:

I've figured out the problem with getting files up be imported. Turns out that you need to have your file named a specific way, and I haven't found that in the docs yet. My tips for this would be:

  • Create some sample data and export it. When you do, you'll be asked for a file name. Give it a name WITHOUT an extension and remember what you've given it.  Write it down if you have to.
  • Find that file in the File Manager and download it to your desktop. It'll be called "content.DNNUserDefinedTable.YOURFILENAME.xml"
  • Create your file for the data to be imported.
  • Name your new file "content.DNNUserDefinedTable.SOMENEWFILENAME.xml"
  • Upload it into the file manager.
  • Go back to your module and choose to import data.
  • Look for SOMENEWFILENAME in the file list and import THAT file, not the one that is called YOURFILENAME.

Still no resolution on scheduling imports, but I think my case will be one-time things anyway. Still like to have an answer on that though...

 
New Post
11/21/2007 3:27 PM
 

Your problem is diveded in two parts, one is imprting UDT data, the other one is to schedule a job. This is not related aany more to the UDT module itself.

DotNetNuke has the capability to run scheduled jobs. Jobs need to inherit from DotNetNuke.Services.Scheduling.SchedulerClient. I hope that helps you for your next steps, I never went that way. Please try your luck inside the developing forum (and don't tell them any thing about UDT - now you need to unterstand scheduling first) 

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListUser Defined Tables - Data Import Possible?User Defined Tables - Data Import Possible?


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, 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 DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out