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 ListUDT 3.05 Query string parameters change th resultUDT 3.05 Query string parameters change th result
Previous
 
Next
New Post
4/23/2009 6:58 PM
 

i am trying to use the same structure but it looks like when i export the data it adds element tags like this:

    <UserDefinedRowId>4</UserDefinedRowId>
    <Status>Passed</Status>
    <City>Imperial</City>
    <State>CA</State>
    <RegistryFee>TBD-Annual</RegistryFee>
    <FeedDueDate>January 1</FeedDueDate>
    <ProRated>No</ProRated>
    <ComplianceWindow>w/in 10 days of vacancy</ComplianceWindow>
    <Penalty>&lt;p&gt;Prosecution or administrative enforcement&lt;/p&gt;</Penalty>
    <SubmitPropertyManager>&lt;p&gt;Name, address &amp;amp; phone of property mgmnt company w/in 10 miles of property&lt;/p&gt;</SubmitPropertyManager>
    <SubmitDeed>Not discussed</SubmitDeed>
    <ContactInformation>&lt;p&gt;Jorge Galvan,&lt;br /&gt;
Planning Manager,&lt;br /&gt;
phone 760-355-3326, fax 760-355-4718, &lt;br /&gt;
&lt;a href="mailto:jgalvan@cityofimperial.org"&gt;jgalvan@cityofimperial.org&lt;/a&gt;&lt;br /&gt;
Edward Vasquex, Code Enforcment Officer, &lt;br /&gt;
phone 760-355-1064, fax 760-355-4718, &lt;br /&gt;
&lt;a href="mailto:evasquex@cityofimperial.orgcodeenforcment@cityofimperial.org"&gt;evasquex@cityofimperial.org&lt;br /&gt;
codeenforcment@cityofimperial.org&lt;/a&gt;&lt;/p&gt;</ContactInformation>
    <forms>&lt;!--http://Provided by the Planning Dept--&gt;&lt;a href="/fs2/LinkClick.aspx?link=http%3a%2f%2fProvided+by+the+Planning+Dept&amp;tabid=88&amp;mid=452" target="_blank"&gt;http://Provided by the Planning Dept&lt;/a&gt;</forms>
    <PostProperty>&lt;p&gt;Sign at least 18" x 24" showing PM's name &amp;amp; 24hr contact phone w/ "THIS PROPERTY MANAGED BY" &amp;amp; "TO REPORT PROBLEMS OR CONCERNS CALL." Affixed to interior window facing street or to building exterior&lt;/p&gt;</PostProperty>
    <MaintSchedule>&lt;p&gt;Inspections req prior to recording default notice; monthly inspections during default; weekly, during vacancy&lt;/p&gt;</MaintSchedule>
    <LiabilityInsurance>Not Discussed</LiabilityInsurance>
    <Ordinance>&lt;!--http://www.imperial.ca.gov/agenda/council/CC09-03-08/Docs/Consent%20Agenda%20C-4%209-3-08.pdf--&gt;&lt;a href="/fs2/LinkClick.aspx?link=http%3a%2f%2fwww.imperial.ca.gov%2fagenda%2fcouncil%2fCC09-03-08%2fDocs%2fConsent%2520Agenda%2520C-4%25209-3-08.pdf&amp;tabid=88&amp;mid=452" target="_blank"&gt;http://www.imperial.ca.gov/agenda/council/CC09-03-08/Docs/Consent%20Agenda%20C-4%209-3-08.pdf&lt;/a&gt;</Ordinance>
    <Changed_x0020_at>2009-04-20T19:45:52-04:00</Changed_x0020_at>
    <Created_x0020_at>2009-04-20T18:52:40-04:00</Created_x0020_at>
    <Changed_x0020_by>bmarick </Changed_x0020_by>
    <Created_x0020_by>bmarick </Created_x0020_by>
    <forms_UDT_Url>/fs2/LinkClick.aspx?link=http%3a%2f%2fProvided+by+the+Planning+Dept&amp;tabid=88&amp;mid=452</forms_UDT_Url>
    <forms_UDT_Caption>http://Provided by the Planning Dept</forms_UDT_Caption>
    <forms_UDT_Original>http://Provided by the Planning Dept</forms_UDT_Original>
    <Ordinance_UDT_Url>/fs2/LinkClick.aspx?link=http%3a%2f%2fwww.imperial.ca.gov%2fagenda%2fcouncil%2fCC09-03-08%2fDocs%2fConsent%2520Agenda%2520C-4%25209-3-08.pdf&amp;tabid=88&amp;mid=452</Ordinance_UDT_Url>
    <Ordinance_UDT_Caption>http://www.imperial.ca.gov/agenda/council/CC09-03-08/Docs/Consent%20Agenda%20C-4%209-3-08.pdf</Ordinance_UDT_Caption>
    <Ordinance_UDT_Original>http://www.imperial.ca.gov/agenda/council/CC09-03-08/Docs/Consent%20Agenda%20C-4%209-3-08.pdf</Ordinance_UDT_Original>
    <Created_x0020_by_UDT_Original>sadmin</Created_x0020_by_UDT_Original>
    <Created_x0020_by_UDT_Caption>bmarick </Created_x0020_by_UDT_Caption>
    <Created_x0020_by_UDT_Value>sadmin</Created_x0020_by_UDT_Value>
    <Created_x0020_by_UDT_Url>/fs2/LinkClick.aspx?userticket=iUx7%2flxxlUE%3d&amp;tabid=88&amp;mid=452</Created_x0020_by_UDT_Url>
    <Created_x0020_at_UDT_Value>4/20/2009 6:52 PM</Created_x0020_at_UDT_Value>
    <Created_x0020_at_UDT_Ticks>633758503600000000</Created_x0020_at_UDT_Ticks>
    <Changed_x0020_by_UDT_Original>sadmin</Changed_x0020_by_UDT_Original>
    <Changed_x0020_by_UDT_Caption>bmarick </Changed_x0020_by_UDT_Caption>
    <Changed_x0020_by_UDT_Value>sadmin</Changed_x0020_by_UDT_Value>
    <Changed_x0020_by_UDT_Url>/fs2/LinkClick.aspx?userticket=iUx7%2flxxlUE%3d&amp;tabid=88&amp;mid=452</Changed_x0020_by_UDT_Url>
    <Changed_x0020_at_UDT_Value>4/20/2009 7:45 PM</Changed_x0020_at_UDT_Value>
    <Changed_x0020_at_UDT_Ticks>633758535520000000</Changed_x0020_at_UDT_Ticks>

notice the <Ordinance_UDT_Caption> tag???

looks like DNN does something with the original column of <Ordinance>

being that this is new data what do i put in place???????

please help!

thx,

riz

 
New Post
4/24/2009 5:37 PM
 

Nothing, all *_UDT_Columns beside from *_UDT_Original gets ignored on import. You can remove them.

 
New Post
8/26/2009 5:01 AM
 

riz wrote
 

i already have the xml file ready to upload to UDT module. i do not know the steps to get the xml file into the database?

i also tried to use the http://www.codeplex.com/Csv2UDTImport.

how does this exe run?

i downloaded the exe to my desktop and tried to drag a csv file with ";" delimeter and i get an unsuspected error and it says it needs to close down?

please advise,

riz

 

I just used this application too, and it worked fine for me. Except: I couldn't get it working from within Windows (XP), no file was created. So I open a CMD-box en typed "csv2udtimport.exe mycsvfile.csv". Then it worked fine. After a few hours of muddling with the xml-import I gave up on that and found this link. Really great, thanks for giving this link!

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListUDT 3.05 Query string parameters change th resultUDT 3.05 Query string parameters change th result


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