Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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 ListCsv2UdtImport.exe CyrillicCsv2UdtImport.exe Cyrillic
Previous
 
Next
New Post
2/25/2010 6:43 AM
 
Dimitar Ivanov

Joined: 7/16/2009
Posts: 148

Hi Stefan,

Is there a way to make Csv2UdtImport.exe import cyrillic text? I still use UTD, and I need to import. I know FnL have csv import, but i'm still on DNN4.9.

Another option for me is to use SQL commands to import data directly to UTD tables. I know this won't be an easy task, because UTD uses 3 tables for its data - UserDefinedFields (only field IDs, not storing), UserDefinedData, UserDefinedRows table. Can you help me with example SQL statement I should use to import data to UTD.

Thanx in advance, DM
 
New Post
2/25/2010 7:16 AM
 
Dimitar Ivanov

Joined: 7/16/2009
Posts: 148

..only to add that the same thing is with this tool: http://www.codingstaff.com/products/d...
 
New Post
2/25/2010 8:07 AM
 
Stefan Cullmann


Stefan Cullmann's Avatar

Joined: 1/6/2005
Posts: 2867
Your file to import needs to be saved in UTF-8/Unicode. I suggest that you install DNN5 and Fnl5.1.2 (which is available as RC on Codeplex), import your CSV and export it later as module. Transfer the export to your DNN4.9 machine and import it in your UDT.
 
New Post
2/25/2010 9:34 AM
 
Dimitar Ivanov

Joined: 7/16/2009
Posts: 148

Hello Stefan,

Thanks for your answer. I found the solution, but it's not Save As csv file. If anyone want to use cyrillic characted from an Excel file he should save as ASCII text (txt) file and then rename it to csv. I tried save as csv file with additional options settings like Tools - Web Options -> Encoding and Fonts tabs but nothing helped.

More info: Cyrillic characters in cells in Excel using the Unicode character set can be pasted into a text file which can be renamed with a .csv extension and then opened by Excel as a csv file. The problem, and the reason for is that Excel will not save the unicode characters to a csv file--it will only save them if you use a "Unicode Text (*.txt)" file type.This is not actually much of a restriction (i.e., using .txt rather than .csv) because the .csv file type is an ASCII text file type just like a .txt file.

Stefan, if you think the solution is good and the problem is actual you may post this in a blog, in formandlist.com or anywhere else to help other DNN users.

DM

p.s. I'm still in DNN 4.9 and UTD, but i managed to add codingstaff control to UTD and use it. Just for other readers here - the same implementation you made for FnL. Is it working the same way as it's installed as an additional control in UTD and integrated in the new FnL?
 
 Page 1 of 1
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListCsv2UdtImport.exe CyrillicCsv2UdtImport.exe Cyrillic


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