User (Legacy) Posted March 31, 2003 Report Share Posted March 31, 2003 Hey all, Back in July of 2002 (7/10/2002 to be exact), I posted the problem I'm having with the design of XML and real-world column names. The problem is summarized as follows: Column names in real life can contain spaces, and special characters such as "%" and "#". These are invalid characters in the XML definition: <?xml version="1.0"?> <DATA> <COLUMNS> <COLUMN NAME="Market" TYPE="STRING"/> <COLUMN NAME="Profit %" TYPE="FLOAT"/> <COLUMN NAME="Cost #" TYPE="FLOAT"/> </COLUMNS> <ROW Market="Acton" Profit %="1457.0" Cost #="12.0" /> <ROW Market="Akron" Profit %="3666.0" Cost #="13.2" /> <ROW Market="Albuquerque" Profit %="11264.0" Cost #="7.6" /> </DATA> For example, the above is invalid XML because Profit % is not a valid key name, and neither is Cost #. To work around this, I've had to make-up column names in both the column name definitions, and the Row specifications, and then pass my custom ASP the real names of the series in parameters. My ASP then has to troll the parameters looking for the replacements for the series legends. Software FX replied: " We will change our data provider so that it provides a Description attribute in the COLUMN tag e.g. <COLUMN NAME="Profit" TYPE="STRING" DESCRIPTION="Profit%"/> " Well, I've been anxiously waiting for this to either show up on a "Known Issues" or "Fixed issues" list for almost a year. Could someone give me a status on the progress of this item? Thanks, Marc Batchelor Link to comment Share on other sites More sharing options...
Software FX Posted April 3, 2003 Report Share Posted April 3, 2003 We have not modified the ChartFX IE XML data provider in quite a while but we did some work in the underlying libraries that we have not fully tested in this context, because of that I am attaching a tentative version of the XML data provider that supports the description attribute in a column. Note that if you are using the XML data provider in the client you will need to modify your HTML page to "push" the new version (1,0,0,10) to the clients. Please let us know if this build works for you so that we can add it to the current service pack. -- Regards, JC Software FX Support "Marc Batchelor" <PleaseReplyToGroup@nowhere.com> wrote in message news:97JynQ69CHA.1328@webserver1.softwarefx.com... > Hey all, > > Back in July of 2002 (7/10/2002 to be exact), I posted the problem I'm > having with the design of XML and real-world column names. The problem is > summarized as follows: > > Column names in real life can contain spaces, and special characters such as > "%" and "#". These are invalid characters in the XML definition: > > <?xml version="1.0"?> > <DATA> > <COLUMNS> > <COLUMN NAME="Market" TYPE="STRING"/> > <COLUMN NAME="Profit %" TYPE="FLOAT"/> > <COLUMN NAME="Cost #" TYPE="FLOAT"/> > </COLUMNS> > <ROW Market="Acton" Profit %="1457.0" Cost #="12.0" /> > <ROW Market="Akron" Profit %="3666.0" Cost #="13.2" /> > <ROW Market="Albuquerque" Profit %="11264.0" Cost #="7.6" /> > </DATA> > > For example, the above is invalid XML because Profit % is not a valid key > name, and neither is Cost #. To work around this, I've had to make-up column > names in both the column name definitions, and the Row specifications, and > then pass my custom ASP the real names of the series in parameters. My ASP > then has to troll the parameters looking for the replacements for the series > legends. > > Software FX replied: > > " > We will change our data provider so that it provides a Description attribute > in the COLUMN tag e.g. > <COLUMN NAME="Profit" TYPE="STRING" DESCRIPTION="Profit%"/> > " > > Well, I've been anxiously waiting for this to either show up on a "Known > Issues" or "Fixed issues" list for almost a year. Could someone give me a > status on the progress of this item? > > Thanks, > > Marc Batchelor > > Link to comment Share on other sites More sharing options...
User (Legacy) Posted April 4, 2003 Author Report Share Posted April 4, 2003 Thank-you for your reply. I am happy to try the provider and see if it works. Can you confirm that the syntax for defining a description is what was described in your reply a while ago? One suggestion for the future - Outlook Express will not "allow" you to detach .DLL's. So, I had to load up another newsgroup reader. I suggest that, in the future, you post .ZIP files instead... ;-) "Software FX Support" <support@softwarefx.com> wrote in message news:bYTEe0f#CHA.1248@webserver1.softwarefx.com... > We have not modified the ChartFX IE XML data provider in quite a while but > we did some work in the underlying libraries that we have not fully tested > in this context, because of that I am attaching a tentative version of the > XML data provider that supports the description attribute in a column. > > Note that if you are using the XML data provider in the client you will need > to modify your HTML page to "push" the new version (1,0,0,10) to the > clients. > > Please let us know if this build works for you so that we can add it to the > current service pack. > > -- > Regards, Link to comment Share on other sites More sharing options...
Software FX Posted April 4, 2003 Report Share Posted April 4, 2003 >> Can you confirm that the syntax for defining a description is what >> was described in your reply a while ago? Yes, it is something like <COLUMNS> <COLUMN NAME="Product" TYPE="String"/> <COLUMN NAME="Q1" TYPE="Integer" DESCRIPTION="Quarter 1" /> <COLUMN NAME="Q2" TYPE="Integer" DESCRIPTION="Quarter 2" /> <COLUMN NAME="Q3" TYPE="Integer" DESCRIPTION="Quarter 3" /> <COLUMN NAME="Q4" TYPE="Integer" DESCRIPTION="Quarter 4" /> </COLUMNS> Note that if DESCRIPTION is not found we fall back to NAME. >> Outlook Express will not "allow" you to detach .DLL's Sorry, you can always temporarily clear the checkbox in the Tools - Options - Security - "Do not allow attachments ..." -- Regards, JC Software FX Support "Marc Batchelor" <PleaseReplyToGroup@nowhere.com> wrote in message news:wPRo9Mr#CHA.1328@webserver1.softwarefx.com... > Thank-you for your reply. I am happy to try the provider and see if it > works. Can you confirm that the syntax for defining a description is what > was described in your reply a while ago? > > > One suggestion for the future - Outlook Express will not "allow" you to > detach .DLL's. So, I had to load up another newsgroup reader. I suggest > that, in the future, you post .ZIP files instead... ;-) > > > "Software FX Support" <support@softwarefx.com> wrote in message > news:bYTEe0f#CHA.1248@webserver1.softwarefx.com... > > We have not modified the ChartFX IE XML data provider in quite a while but > > we did some work in the underlying libraries that we have not fully tested > > in this context, because of that I am attaching a tentative version of the > > XML data provider that supports the description attribute in a column. > > > > Note that if you are using the XML data provider in the client you will > need > > to modify your HTML page to "push" the new version (1,0,0,10) to the > > clients. > > > > Please let us know if this build works for you so that we can add it to > the > > current service pack. > > > > -- > > Regards, > > Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.