Compile Errors...Please help

Reply

Compile Errors...Please help

Mar 05, 2010 08:01 AM|papurajdas|LINK

Hi all,

I am facing some problem in writing code for some project.

Here is the full code which I downloaded from-http://biguru.wordpress.com/2008/04/26/export-data-out-of-your-xcelsius-dashboards/

But when I put it into C:\Inetpub\wwwroot it is giving compile errors like above,,

Can anyone help me rectify it??

The full code is written below--

<%@ Page Language="VB" aspcompat=true Debug="true" validateRequest="false" %>

<%@ Import Namespace="System.IO" %>

<%@ Import Namespace="System.Xml" %>

<%@ Import Namespace="System.Xml.XPath" %>

<%

'-----------------------------------

'Name: export2csv.aspx

'Author: Maloy Manna

'Date: 04.26.2008

'Purpose: To export data out of Xcelsius .swf in csv format

'Input: Xcelsius data manager Send ranges in XML format

'Output: CSV output file URI

'Last Modified:

'Modification:

'-----------------------------------

'Variable declarations

Dim sXMLString as String

Dim sFormitem as String

Dim sFileName as String

Dim sRPath as String

Dim sPath as String

Dim sXML as String

Dim iRangeLength As Integer

Dim iRowLength As Integer

Dim iRangeCounter As Integer

Dim iCounter As Integer

Dim oFile as File

Dim oWrite as StreamWriter

Dim oXML as Object

Dim oRNodeList as Object

Dim oRNode as Object

Dim oNodeList as Object

Dim oNode as Object

'Get XML that was sent from SWF file

For Each sFormItem In Request.Form

sXMLString = sXMLString & sFormItem & " = " & Request.Form(sFormItem)

oXML = Server.CreateObject("MSXML2.DOMDocument")

oXML.async = False

oXML.validateOnParse = False

oXML.loadXML(sXMLString)

'Create output file with timestamp in the name

sFileName = "Exported_Data_" & DatePart("m",Now()) & DatePart("d",Now()) &

DatePart("yyyy",Now()) & DatePart("h",Now()) & DatePart("n",Now()) &

DatePart("s",Now()) & ".csv"

oWrite= oFile.CreateText("C:\Inetpub\wwwroot\" & sFileName)

'Use XPath to get the data

'Find the number of ranges or variables to be exported

sRPath ="/data/variable"

oRNodeList = oXML.documentElement.selectNodes(sRPath)

iRangeLength = oRNodeList.Length

For iRangeCounter = 0 to iRangeLength - 1

oRNode = oXML.documentElement.selectSingleNode("/data/

variable["+CType(iRangeCounter,String)+"]/row")

'Write out the data set for the range

sPath = "/data/variable["+CType(iRangeCounter,String)+"]/row"

'Find the number of rows for the range

oNodeList = oXML.documentElement.selectNodes(sPath)

iRowLength = oNodeList.Length

For iCounter =0 to iRowLength - 1

oNode = oXML.documentElement.selectSingleNode("/data/

variable["+CType(iRangeCounter,String)+"]/row["+CType(iCounter,String)+"]/column")

oWrite.Write(oNode.text)

While Not(oNode.nextSibling Is Nothing)

oWrite.Write("," +oNode.nextSibling.text)

oNode = oNode.nextSibling

End While

oWrite.WriteLine

'Build XML data to return

sXML = "<data>"

'exportdataurl

sXML = sXML & "<variable name=" + chr(34) + "exportdataurl" + chr(34) + ">"

sXML = sXML & "<row>"

sXML = sXML & "<column>" & "http://localhost/" & sFileName & "</column>"

sXML = sXML & "</row>"

sXML = sXML & "</variable>"

'close out the XML data string

sXML = sXML & "</data>"

'Set the Response type

Response.Buffer = True

Response.ContentType = "application/vnd.csv"

Response.Write(sXML)

%>

But getting errors like this

C:\WINDOWS\system32> "C:\WINDOWS\Microsoft.NET\Framework\v4.0.20506\vbc.exe" /t:library /utf8output /R:"C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel\v4.0_4.0.0.0__b77a5c561934e089\System.ServiceModel.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel.Web\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Web.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.IdentityModel\v4.0_4.0.0.0__b77a5c561934e089\System.IdentityModel.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\Microsoft.CSharp\v4.0_4.0.0.0__b03f5f7f11d50a3a\Microsoft.CSharp.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.WorkflowServices\v4.0_4.0.0.0__31bf3856ad364e35\System.WorkflowServices.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel.Channels\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Channels.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Services\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.Services.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Web.Mobile\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.Mobile.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Activities\v4.0_4.0.0.0__31bf3856ad364e35\System.Activities.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.ServiceModel.Activities\v4.0_4.0.0.0__31bf3856ad364e35\System.ServiceModel.Activities.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Xaml.Hosting\v4.0_4.0.0.0__31bf3856ad364e35\System.Xaml.Hosting.dll" /R:"C:\WINDOWS\assembly\GAC_32\System.Web\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Web.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll" /R:"C:\WINDOWS\assembly\GAC_MSIL\System.Xaml\v4.0_4.0.0.0__b77a5c561934e089\System.Xaml.dll" /out:"C:\WINDOWS\Microsoft.NET\Framework\v4.0.20506\Temporary ASP.NET Files\root\26676eb7\92c7e946\App_Web_sjxddgtw.dll" /D:DEBUG=1 /debug+ /define:_MYTYPE=\"Web\" /imports:Microsoft.VisualBasic,System,System.Collections,System.Collections.Specialized,System.Configuration,System.Text,System.Text.RegularExpressions,System.Web,System.Web.Caching,System.Web.SessionState,System.Web.Security,System.Web.Profile,System.Web.UI,System.Web.UI.WebControls,System.Web.UI.WebControls.WebParts,System.Web.UI.HtmlControls  "C:\WINDOWS\Microsoft.NET\Framework\v4.0.20506\Temporary ASP.NET Files\root\26676eb7\92c7e946\App_Web_sjxddgtw.0.vb" "C:\WINDOWS\Microsoft.NET\Framework\v4.0.20506\Temporary ASP.NET Files\root\26676eb7\92c7e946\App_Web_sjxddgtw.1.vb"




Microsoft (R) Visual Basic Compiler Beta1 version 10.0.20506.1
Copyright (c) Microsoft Corporation.  All rights reserved.


c:\inetpub\wwwroot\export2csv.aspx(47) : warning BC42025: Access of shared member, constant member, enum member or nested type through an instance; qualifying expression will not be evaluated.


oWrite= oFile.CreateText("C:\Inetpub\wwwroot\" & sFileName)
        ~~~~~~~~~~~~~~~~
c:\inetpub\wwwroot\export2csv.aspx(54) : error BC30648: String constants must end with a double quote.


oRNode = oXML.documentElement.selectSingleNode("/data/
                                               ~~~~~~~
c:\inetpub\wwwroot\export2csv.aspx(55) : error BC30451: Name 'variable' is not declared.


variable["+CType(iRangeCounter,String)+"]/row")
~~~~~~~~
c:\inetpub\wwwroot\export2csv.aspx(55) : error BC30203: Identifier expected.


variable["+CType(iRangeCounter,String)+"]/row")
         ~
c:\inetpub\wwwroot\export2csv.aspx(62) : error BC30648: String constants must end with a double quote.


oNode = oXML.documentElement.selectSingleNode("/data/
                                              ~~~~~~~
c:\inetpub\wwwroot\export2csv.aspx(63) : error BC30451: Name 'variable' is not declared.


variable["+CType(iRangeCounter,String)+"]/row["+CType(iCounter,String)+"]/column")
~~~~~~~~
c:\inetpub\wwwroot\export2csv.aspx(63) : error BC30203: Identifier expected.


variable["+CType(iRangeCounter,String)+"]/row["+CType(iCounter,String)+"]/column")
         ~

Please help...

Reply

Re: Compile Errors...Please help

Mar 05, 2010 08:51 AM|kapilsanchihar|LINK

You are getting this error as the aspnet user on your machine does not have sufficient rights on "

c:\inetpub\wwwroot" folder. Update the security settings of the folder and allow write permission to aspnet user.

Don't forget to click "Mark as Answer" on the post that helped you.

Reply

Re: Compile Errors...Please help

Mar 05, 2010 09:10 AM|papurajdas|LINK

Thanks a lot Kapil for your reply,,

can you please clarify me what to do?

A step by step process will really help me.

Reply

Re: Compile Errors...Please help

Mar 05, 2010 09:27 AM|kapilsanchihar|LINK

right click the inetpub folder and go to properties. Now click on the security tab. Select the ASPNET user, if it is not there then go to advanced and add the user. Now grant proper permission to that user.

If this doesn't work, then try will the IIS user as well. You can get the user by clicking "Add" buton on the security tab.

Don't forget to click "Mark as Answer" on the post that helped you.

Reply

papurajdas

None

0 Points

5 Posts

Re: Compile Errors...Please help

Mar 05, 2010 09:39 AM|papurajdas|LINK

I have tried your instructions,

still same errors are coming.

I have even restarted IIS application and .Net too.

Is there some compile error in the code itself?

Reply

kapilsanchih...

Member

540 Points

206 Posts

Re: Compile Errors...Please help

Mar 05, 2010 09:48 AM|kapilsanchihar|LINK

I think code is correct. It is just a permission issue. Have u tried with both ASPNET and IUSR users?

Try and grant full control.

Don't forget to click "Mark as Answer" on the post that helped you.

Compile Errors...Please help [Answered]RSS

5 replies

Shortcuts

papurajdas

Compile Errors...Please help

kapilsanchih...

Re: Compile Errors...Please help

papurajdas

Re: Compile Errors...Please help

kapilsanchih...

Re: Compile Errors...Please help

papurajdas

Re: Compile Errors...Please help

kapilsanchih...

Re: Compile Errors...Please help