Graph XML

[xag]

Hello Ray,

I was wondering how easy it is to modify the SQL in the Graph_data page for graphs. I saw the tutorial and I change the line in SQL to a bit more complex SQL but still doesn't render. Can the Graph do the following SQL?

SELECT dbo.LOG_USER.LOG_BROWSER AS XLABEL, count(LOG_BROWSER) AS YVALUE
FROM dbo.LOG_USER GROUP BY dbo.LOG_USER.LOG_BROWSER

[Ray Borduin]

Yes. It should work. Try browsing the data file directly to see if there are any errors or issues with the data or query being used.

[xag]

Nope I even tested out in the Graph_data page in the record set and it returnd the correct values I wanted.

[xag]

so the SQL is good but when i view the graph site I get this /DynamicWebCharts/Data/Graph_dataparser8.asp?in the white area. when i go to the page all thats on the page is teh following code

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include virtual="wa_dfc_xmlVB.asp" -->
<%
Dim queryString : queryString = Request.QueryString()
Dim thisChartXML : thisChartXML = WA_DFC_getXMLFileContents("Graph_data8.asp", queryString)
Response.Write(WA_DFC_XML2ChartData(thisChartXML, queryString))
%>

[Ray Borduin]

What happens when you go to the page: Graph_data8.asp directly in the browser?

[xag]

I see my data that I want in a box


Y%20Axis%20Legend
X%20Axis%20Legend
Ball Valves 4 Brand/Subsidiaries 1 BVH Product Page 1 Certifications 1 Contact us Page 13
Culture & Values 2 Home Page 145 Value Proposition 4
Fluid Control Valves sub-menu page 1 Global Footprint 2 History 1 Level Gauge Manifolds 1
NEWS Menu 3.1 2 NEWS Spry Main Menu 8 Pressure Gauges 1
Products Root Level Tab 11

[xag]

hmm but when I go to this page DynamicWebCharts/Data/Graph_dataparser8.asp?

I get the following error

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'XAxisData'

/DynamicWebCharts/Data/wa_dfc_xmlVB.asp, line 422


Here is line 422

chartstr = chartstr & XAxisData(0)

[Ray Borduin]

Try:

chartstr = chartstr & cStr(XAxisData(0))

[xag]

Sorry Ray that didn't work and when I go to the page in the URL it still gives me the type mismatch error

[Ray Borduin]

Please post a support incident. Somebody will probably have to work with you directly to debug this issue.

[xag]

I submitted 2 support tickets concerning Web charts concerning this post and this post http://www.webassist.com/forums/showthread.php?t=1479 I have had no support contact since 06/05. Is there a hold up with support? I wish someone would just tell me there is and I can wait patiently but I badly needs these charts for performance metric. ticket numbers are 98046 and 97777.

[Ray Borduin]

Our head of support was out for two weeks and just returned today, so there could have been a slowdown during that period... according to the post it implies you are able to get it to work by changing the path manually. Is there another issue preventing it from working at all.

[xag]

No it still doesn't work with the changes you suggested in changing the webassist file wa_dfc_xmlVB.. Microsoft VBScript runtime error '800a000d'

Type mismatch: 'XAxisData'

/DynamicWebCharts/Data/wa_dfc_xmlVB.asp, line 422


I tried this on line 422:
chartstr = chartstr & cStr(XAxisData(0))
Edit/Delete Message

[xag]

So what if I haven't received a response on one of my tickets in the last 7 days?

[Ray Borduin]

What is the incident number? I can look into it for you.

It most likely means they are unable to reproduce the problem and so are having difficulty finding a solution. It may be escalated to needing engineering assistance and may eventually require a phone call with you directly to debug if we aren't able to reproduce the problem.

[xag]

#98046 and thanks Ray

[xag]

Hi Ray any news? I just posted another Log to Dani hoping he didn't forget about me! Thanks

[Ray Borduin]

I sent him a reminder just now. I'll check with him later to see the progress.

[xag]

Hi Ray I'm wondering if Dani has been out? I haven't heard from him since Thursday and I really need to get this working. Any way you can send him a quick reminder. I understand if his busy but any way I can get this expedited? Its' been 2 weeks now and I haven't progressed in this situation at all.

[xag]

Sorry to be such a pest I just have the big bosses asking what's going on

[xag]

So i'm really starting to feel like the child left behind. It's been almost a week since I have heard anything. I've posted serveral times in the log and nothing. Not even an update. Throw me a bone here at least let me know he got the files and is working on it or something... been 2 weeks since I first posted this and no help from you guys just told me to send you the files....

[mrosa1379967]

Hi, i have the same problem. Maybe does it could depend on the character set?
In the page wa_dwc.dtd you have set:
<?xml version="1.0" encoding="utf-8"?>

Maybe we have to modify it or to change the Server Character Set!? (Maybe the first solution is the best one...)

Please let us know,
Max

[xag]

Hello mrosa,

My problem was that I had an '&' in my text and it was messing up in displaying the graph. I'm using asp/vb so the tech guy that helped just added the replace cmd to replace the '&' with the word 'and' and it worked fine. if you need anything further just reply and i'll see if I can help you out. Or maybe Ray could.

[mrosa1379967]

Thank you for your help.

My data to be represented are:
#999933 #c8314b #b6b816 #dd545e #e6f99e #b8d249 N%C2%B0%20Prenotazioni Utente ANGURIA 122 DE LUCA BOSSA 117 FLORE 117 GILESTRO 118 LOPES 123 LORENZON 118 MANCINI 118 MASIELLO 121 NANNI 121 PIZZUTI 118 ROCCHI 117 SANTILLI 118

This string has been obtained by executing the file pren_odierne_data1.asp. Consider that i use asp/vbscript too.

Have you any idea?

[xag]

so I take it that when you go to /DynamicWebCharts/Data/Graph_dataparser1.asp that you see some of your data and what not. How about if you go to /Data/Graph_data1.asp do you see your data or does it throw back an error?

[mrosa1379967]

When i open the page xxx_dataparser1.asp, i get the error:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'XAxisData'

/mensa/DynamicWebCharts/Data/wa_dfc_xmlVB.asp, line 422



When i open the page xxx_data1.asp, i have the following data on the screen:

#999933 #c8314b #b6b816 #dd545e #e6f99e #b8d249 Prenotazioni Utente ANGURIA 122 DE LUCA BOSSA 117 FLORE 117 GILESTRO 118 LOPES 123 LORENZON 118 MANCINI 118 MASIELLO 121 NANNI 121 PIZZUTI 118 ROCCHI 117 SANTILLI 118



Any idea? :)

[xag]

Well i'm no expert but lets try this. In your Graph_data1.asp file go to the label around line 49. try doing this

<label><%=(Replace(WADWCdboLOG_USER.Fields.Item("XLABEL").Value, "#", "pound"))%></label>


My guess and my problem was the '&' like I said before. Maybe it is having trouble to with the '#' symbol...try that and let me know how it goes

[xag]

funny thing is that this fixed everything on my testing server and worked fine. then when i copied everything over to my live server it broke and gave me the same error you just got. I submit and ticket and they instructed me to also change on the page /Graph_data1.asp this line on line 1


<!--#include file="../../Connections/_ODBC32.asp" -->


To

<!--#include virtual="/Connections/_ODBC32.asp" -->


see if any of the two solutions work for you if not I will let you know later when support hits me back because neither worked for me on my live server.

[mrosa1379967]

Noone of these solutions goes well... :(
I don't know what to do...

[xag]

well go back and put back in the line for the include virtual to include file ... and just try the first solution with the replace and see if that did anything. Or did you already try that? Also make sure that you have the file path the right way. the only reason that works for me is because my connection folder is sitting at my root lever. if you have your connections folder sitting somewhere else the path will be different.

[mrosa1379967]

I have modified the path and the include virtual permit to me to get file. But i have the same error...

[xag]

same error meaning that you can't see the include file? or same type mismatch error? if its the type mismatch error then you and I are in the same boat and I would suggest to post a support ticket. Hopefully Jason from support gets back to me in a few hours and I will post the results here once he gets back to me. sry mrosa

[mrosa1379967]

Adding the string:
<!--#include virtual="/mensa/Connections/Conn.asp" -->
instead of
<!--#include file="../../Connections/Conn.asp" -->

I have the same results:
#999933 #c8314b #b6b816 #dd545e #e6f99e #b8d249 Prenotazioni Utente ANGURIA 122 DE LUCA BOSSA 117 FLORE 117 GILESTRO 118 LOPES 123 LORENZON 118 MANCINI 118 MASIELLO 121 NANNI 121 PIZZUTI 118 ROCCHI 117 SANTILLI 118

But executing xxx_dataparser1.asp, i get the same error:

Microsoft VBScript runtime error '800a000d'

Type mismatch: 'XAxisData'

/mensa/DynamicWebCharts/Data/wa_dfc_xmlVB.asp, line 422

Thanks

[Jason Byrnes]

xag:
I responded to your ticket just now. IT appears to be an issue with a special character in one of the records in your database breaking the XML.

mrosa1379967:
Please submit a support ticket so we can troubleshoot this issue with you. If you could include in the support ticket a link to your site so I can investigate the problem, we should be able to get your chart working.

~Jason

[xag]

yup special char aren't fun with the XML its fixed now thanks Jason I'll make sure to keep that in mind. Have a nice one Jason and good luck mrosa

[mrosa1379967]

Sorry, the support ticket is a new thread? I am a newbie of this site...

[mrosa1379967]

I have found the ticket submitting page. But in the product list i can't find any product. So, clicking Next, i can't post any message and upload any file.

Please, help...

Just know that the chart is for an intranet application and so i can't post the link but only the pages without the database...

[xag]

Hey mrosa When you submit the product just pick your suit that you purchased. and click on the radio button that says I am experiencing errors while using a webassist extension....My site was the same but what I did was just made up a new graph and let it sit out in the public so they can take a look at your code. Or else they will have to contact you remote in and work from your computer and calling you could take up to about a week

[mrosa1379967]

Hi,
i can't post any ticket because in the combobox there are no product listed.

What can i do? Do you have an email to which i can send the pages to be analyzed?

Thanks,
mrosa

[xag]

well did you purchase the extension under your log in name?

[mrosa1379967]

Yes, i bought the extension through SHI Company. They didn't provide to me an account with the extensions (buyed) linked to. So, SHI people contacted your colleagues in order to link my account (mrosa1) to the Suite. Your colleagues replied that i couldn't have this easily. So i don't know how to open a ticket for the issue.

If you have an email it should be easier.

Thanks

[xag]

My colleagues? I don't work for webassist lol... But ya I would call webassist when they open to try to link your account to your product that you purchased.. I don't know what to tell you. I'm sure Ray will be around in the next hr or so and will tell you what to do