You are here Members OnyakTech Forums
Wednesday, June 19, 2013

Download All DotNetNuke Modules and Skins for Only $99
All OnyakTech DotNetNuke Modules are supported on DNN 4.5.3 and newer (Including 5.x and 6.x).

HomeHomeOnyakTech DotNe...OnyakTech DotNe...Modules & Relat...Modules & Relat...DataView fails to importDataView fails to import
Previous
 
Next
New Post
5/6/2012 7:00 PM
 

 

I am running into another issue:  When I use the DataView Module, I am receiving the following error.  I limited my data to less than 10 characters and the database extended it to 50 characters. 


 

The identifier that starts with '��ࡱ�................>..�� .........................����....����.......��������������������������������������������������' is too long. Maximum length is 128. '##0\)!...."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. Incorrect syntax near '\'. '##0\)"...."$"#,##0.00_);\("$"#,##0.00\)'..".."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\)7.*.2.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_("$"* "-"_);_(@_)..).).._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_(* "-"_);_(@_)?.' is an invalid name because it contains a NULL character or an invalid unicode character. '.:.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\);_("$"* "-"??_);_(@_)6.+.1.._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. The identifier that starts with '##0.00\);_(* "-"??_);_(@_)�......�� ...........� �.....�� ..�........� �.....�� ..�........� �.....�� ..�........� �...' is too long. Maximum length is 128. The identifier that starts with '.�� ..�........� �...*.�� ..�........� �... .�� ..�........� �.���.���.���.���..�.��.��`...�..7...' is too long. Maximum length is 128.The identifier that starts with '��ࡱ�................>..�� .........................����....����.......��������������������������������������������������' is too long. Maximum length is 128. '##0\)!...."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. Incorrect syntax near '\'. '##0\)"...."$"#,##0.00_);\("$"#,##0.00\)'..".."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\)7.*.2.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_("$"* "-"_);_(@_)..).).._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_(* "-"_);_(@_)?.' is an invalid name because it contains a NULL character or an invalid unicode character. '.:.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\);_("$"* "-"??_);_(@_)6.+.1.._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. The identifier that starts with '##0.00\);_(* "-"??_);_(@_)�......�� ...........� �.....�� ..�........� �.....�� ..�........� �.....�� ..�........� �...' is too long. Maximum length is 128. The identifier that starts with '.�� ..�........� �...*.�� ..�........� �... .�� ..�........� �.���.���.���.���..�.��.��`...�..7...' is too long. Maximum length is 128.The identifier that starts with '��ࡱ�................>..�� .........................����....����.......��������������������������������������������������' is too long. Maximum length is 128. '##0\)!...."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. Incorrect syntax near '\'. '##0\)"...."$"#,##0.00_);\("$"#,##0.00\)'..".."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\)7.*.2.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_("$"* "-"_);_(@_)..).).._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_(* "-"_);_(@_)?.' is an invalid name because it contains a NULL character or an invalid unicode character. '.:.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\);_("$"* "-"??_);_(@_)6.+.1.._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. The identifier that starts with '##0.00\);_(* "-"??_);_(@_)�......�� ...........� �.....�� ..�........� �.....�� ..�........� �.....�� ..�........� �...' is too long. Maximum length is 128. The identifier that starts with '.�� ..�........� �...*.�� ..�........� �... .�� ..�........� �.���.���.���.���..�.��.��`...�..7...' is too long. Maximum length is 128.The identifier that starts with '��ࡱ�................>..�� .........................����....����.......��������������������������������������������������' is too long. Maximum length is 128. '##0\)!...."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. Incorrect syntax near '\'. '##0\)"...."$"#,##0.00_);\("$"#,##0.00\)'..".."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\)7.*.2.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_("$"* "-"_);_(@_)..).).._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_(* "-"_);_(@_)?.' is an invalid name because it contains a NULL character or an invalid unicode character. '.:.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\);_("$"* "-"??_);_(@_)6.+.1.._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. The identifier that starts with '##0.00\);_(* "-"??_);_(@_)�......�� ...........� �.....�� ..�........� �.....�� ..�........� �.....�� ..�........� �...' is too long. Maximum length is 128. The identifier that starts with '.�� ..�........� �...*.�� ..�........� �... .�� ..�........� �.���.���.���.���..�.��.��`...�..7...' is too long. Maximum length is 128.The identifier that starts with '��ࡱ�................>..�� .........................����....����.......��������������������������������������������������' is too long. Maximum length is 128. '##0\)!...."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. Incorrect syntax near '\'. '##0\)"...."$"#,##0.00_);\("$"#,##0.00\)'..".."$"#' is an invalid name because it contains a NULL character or an invalid unicode character. '##0.00\)7.*.2.._("$"* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_("$"* "-"_);_(@_)..).).._(* #' is an invalid name because it contains a NULL character or an invalid unicode character. '##0\);_(* "-"_);_(@_)?.' is an invalid name because it contains a NULL character or an invalid unicode character. '.:.._("

 
New Post
5/9/2012 2:11 PM
 

What is your SQL for this and can you also post the TSQL to create the table your pulling from or list the columns and data types?

 
New Post
5/12/2012 7:37 PM
 

USE

 

[MyData]

 

ANSI_NULLS ON

 

QUOTED_IDENTIFIER ON

 

TABLE [dbo].[Users](

IDENTITY(1,1) NOT NULL,

(50) NOT NULL,

(50) NOT NULL

 

ON [PRIMARY]

GO

)

[Password] [nvarchar]

[Username] [nvarchar]

[ID] [int]

GO

 

CREATE

GO

 

SET

GO

 

/****** Object: Table [dbo].[Users] Script Date: 05/12/2012 18:36:18 ******/

 

SET

 
New Post
5/12/2012 7:37 PM
 

USE [MyData]
GO

/****** Object:  Table [dbo].[Users]    Script Date: 05/12/2012 18:36:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Users](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [Username] [nvarchar](50) NOT NULL,
 [Password] [nvarchar](50) NOT NULL
) ON [PRIMARY]

GO

 
New Post
5/19/2012 10:57 AM
 

That table already exists, it's a DNN table and the layout is different than what you have so you will have issues.  If your trying to import users then you should use the User Import module.

 
Previous
 
Next
HomeHomeOnyakTech DotNe...OnyakTech DotNe...Modules & Relat...Modules & Relat...DataView fails to importDataView fails to import


Fast Image 2.0 DotNetNuke Module Released
6/16/2013 12:00:00 AM
DotNetNuke MSV Kit - Modules, Skins and Training for DotNetNuke
6/8/2013 12:00:00 AM
SigmaLive 3.0 DotNetNuke Live Chat Available Now
6/1/2013 12:00:00 AM
DNN Forms 4.2 DotNetNuke Module Released!
5/12/2013 12:00:00 AM
PDF Reports 4.0 Released
5/6/2013 12:00:00 AM
File Search 2.7 Released with Advanced Searching
5/6/2013 12:00:00 AM
Customer Tracking for DotNetNuke
4/26/2013 12:00:00 AM
New DNN Module: Scrolling Text 3.3
4/13/2013 12:00:00 AM
Charts 2.2.9 for DotNetNuke Released
4/6/2013 12:00:00 AM
NEW MODULE: Fast Image 1.5 DotNetNuke Module
3/31/2013 12:00:00 AM
ReZults 5.2 Survey, Vote & Quiz Module for DotNetNuke Available Now
3/17/2013 12:00:00 AM
DotNetNuke Scrolling Content Module Released
2/24/2013 12:00:00 AM
Novus News Module 4.0 for DotNetNuke Released
2/17/2013 12:00:00 AM
Data Viewer 5.2 released for DNN 7 with Seven New Skins
2/2/2013 12:00:00 AM
Simple Free Help Desk for DotNetNuke
1/27/2013 12:00:00 AM
Novus 3.6 DotNetNuke Module for News Articles
1/14/2013 12:00:00 AM
Soma Elite Rich Content Processing for DotNetNuke
1/12/2013 12:00:00 AM
New DotNetNuke Module: Page Tools
1/7/2013 12:00:00 AM
Forms 4.0 for DotNetNuke Released
12/30/2012 12:00:00 AM
Four New DotNetNuke Modules
12/9/2012 12:00:00 AM
The "Ticker" above is the Novus News Ticker.  Novus is a news publishing module for DotNetNuke that was created to fill a need no other module provides. With Novus you can publish RSS Feeds in and out of your site, display messages across multiple portals, organize your articles into multi-level categories with images, automatic email notifications of new articles and so much more. You could even use Novus as a repository providing file downloads to specific roles while also allowing people to rate, comment and subscribe to your postings.

Where did all the old forum posts go? The OnyakTech Forums have been replaced with the latest DNN Forums module.  All posts from 2003 have been archived. 

Copyright 2003-2013 by OnyakTech LLC Privacy StatementTerms Of Use