XML / XSL Discussion Boards

How to Password Protect a XML SpreadSheet

ANSHUMAN44429-Oct-09 5:14

29-Oct-09 5:14

I am generating a Excel Sheet(XML SpraedSheet) through XSLT transform.How to password protect the XML SpreadSheet in XSLT.

Is there is any tag to password Protect?

Is there is any other solutions to password protect the XML Spreadsheet?

Best Regards

Re: How to Password Protect a XML SpreadSheet

Christian Graus1-Nov-09 9:30

Christian Graus

1-Nov-09 9:30

It's as if you understand XSLT, and yet somehow have no idea what XML is. How is that possible ?

XML is a string. You can write external code to encode the entire string ( meaning it won't be XML anymore ), or to encode the contents of the nodes. You'd then need corresponding code to decode the information. You can invent a 'password protect tag', but it's plainly not going to alter the fact that all you have is a plain text file.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

C# XML datagridview delete row

Wheels01227-Oct-09 3:38

Wheels012

27-Oct-09 3:38

Good morning.

I am populating a datagridview with a dataset from an XML file.

I now want to write some code to delete a row on the datagridview to simulate a user clicking on the row and hitting the Delete button.

Any ideas on how to accomplish this?

Thank you, WHEELS

C# Append XML File

Wheels01223-Oct-09 5:42

Wheels012

23-Oct-09 5:42

Good morning.

I have the following simple XML file.

<?xml version="1.0" standalone="yes"?>
<SHRPT_SITE>
  <RECORD>
    <Name>Apps (doc)</Name>
    <Address>http://unumtfsprod/sites/IServices/Apps/Forms/AllItems.aspx</Address>
  </RECORD>
  <RECORD>
    <Name>Internet Services Architecture (arch)</Name>
    <Address>http://teamspace/sites/iservices/architecture/default.aspx</Address>
  </RECORD>
  <RECORD>
    <Name>iServices Customer Self Service (staff)</Name>
    <Address>http://teamspace/sites/isgcrm/custselfsvc/default.aspx</Address>
  </RECORD>
</SHRPT_SITE>

I want the user to be able to click a (favorites) button and be able to add a site name and URL to the file. What would be the best code approach to accomplish this?

Thank you, WHEELS

Re: C# Append XML File

Christian Graus23-Oct-09 10:35

Christian Graus

23-Oct-09 10:35

Use an XmlDocument to create a new record, and then append it to the shrpt_site node.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

Re: C# Append XML File

Wheels01226-Oct-09 1:24

Wheels012

26-Oct-09 1:24

Thank you Christian.

Is it possible to call a comand line program from within an Xml File Preprocessor

ONeil Tomlinson23-Oct-09 1:09

ONeil Tomlinson

23-Oct-09 1:09

Is it possible to call a comand line program from within an Xml File Preprocessor. I have a connection string that is encrypted in a settings file and i want to decrypt it before assigning it to the conString value

<configuration>
  <appSettings>
    <!-- ifdef ${_xml_preprocess} -->
    <!-- <add key="conString" value="${connectionStringWithPassowrd}"/> -->
    <!-- else -->
    <add key="conString" value="connection string"/>
    <!-- endif -->
  </appSettings>
</configuration>

Re: Is it possible to call a comand line program from within an Xml File Preprocessor

Christian Graus23-Oct-09 10:44

Christian Graus

23-Oct-09 10:44

No. You should write code to decrypt it in a class and use that to access the values.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

XSL group [modified]

Clas Andersson22-Oct-09 21:26

Clas Andersson

22-Oct-09 21:26

Hi.

How can I group values in "Type" ( xmldatasource - fill dropdownlist with distinct values ) ?

XSL:

<?xml version="1.0"?>
<xsl:transform
version="1.0"
xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:msxsl="urn:schemas-microsoft-com:xslt"
>
<xsl:strip-space elements="*"/>
<xsl:output method="xml"
omit-xml-declaration="yes"
indent="yes"
standalone="yes" />
<xsl:template match="/">
<xsl:for-each select="dataroot">
<xsl:element name="dataroot">
<xsl:for-each select="Table_A">
<xsl:element name="Table_A">
<xsl:attribute name="Type">
<xsl:value-of select="Type"/>
</xsl:attribute>
</xsl:element>
</xsl:for-each>
</xsl:element>
</xsl:for-each>
</xsl:template>
</xsl:transform>

XML:
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata" generated="2009-10-21T09:21:31">
<Table_A>
<ID_I>100085004</ID_I>
<Type>GPS</Type>
<Value>0</Value>
<SDD_Date>1829-06-12T00:00:00</SDD_Date>
</Table_A>
</dataroot>

Thanks in advance !!

modified on Friday, October 23, 2009 3:43 AM

Re: XSL group

tassilo10-Nov-09 23:02

tassilo

10-Nov-09 23:02

Clas,

can you use XSLT 2.0 instead 1.0? (If you can control the XSLT engine you use, then switch to SAXON by M. Kaye, from the web-site, you can also download all you need for .NET reuse.)

If so, <xsl:key ...=""> and the so-called Muenchian method is your friend.
All you need to know you will find here:
http://www.jenitennison.com/xslt/grouping/muenchian.html[^]

Best regards,

Stefan

how to write to xml file! [modified]

live4u19-Oct-09 2:04

live4u

19-Oct-09 2:04

Hello community,

i am new user and its my first question that i seek an answer or some sort of answer that will help me with my work so please don't judge me Smile | :)

My problem is that i made html page and on that page i have form in witch i insert email/password.I want those informations to be inserted into Xml file file witch i already have in my project.I want this problem to be solved with javascript or jquery.(server environment not client if that is possible).

So if anyone is interested in solving my problem it will be from big help to me.

Thanks.

modified on Monday, October 19, 2009 8:16 AM

Re: how to write to xml file!

Christian Graus22-Oct-09 18:30

Christian Graus

22-Oct-09 18:30

live4u wrote:
I want this problem to be solved with javascript or jquery.(server environment not client if that is possible).

Um... I know you're new and all, but you just asked a dumb question. You want to use client side code, but you want it to run on the server ? How does that make sense ?

To manipulate XML, there's almost certainly a DOM implimentation in the framework you're using, but if you want specific code, the ASP.NET forum for ASP.NET or web dev for any other web platform, is the best place to ask this. Although it relates to XML, it's hard to know how to answer based on what you said. XmlDocument class if you're using .NET, otherwise I don't know. But, you can't use javascript or jquery ( which is just a javascript library, it's not a language ) on the server, nor should you want to.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

XML-RPC VERSUS JSON-RPC

cyrossis17-Oct-09 2:16

cyrossis

17-Oct-09 2:16

Hi am a LAMP developer and our team are about to embark on a version 2 of a web based application, with an upgrade of client tier to AJAX. For client-server communication we have narrowed down the options to XML and JSON was wondering what are the benefits and drawbacks of both. Right now am leaning towards JSON?

Regards

XML to link to Image location - Word 07 [modified]

Jerry Squires16-Oct-09 2:22

Jerry Squires

16-Oct-09 2:22

As opposed to embedding an image within a Microsoft Word 2007 document, I have been looking for the possibility of using XML to link to another location on the network where the image files would be stored locally.

Is this possible? If so, would anyone be able to help by pointing me in the direction of learning more knowledge on this subject?

Any and all help is greatly appreciated

jsquires

modified on Friday, October 16, 2009 10:57 AM

PROBLEM WITH HYPHEN (-) IN XML ELEMENT NODE

dsaikrishna14-Oct-09 21:24

dsaikrishna

14-Oct-09 21:24

HI,

I HAVE A XML FILE WITH HYPHEN(-) IN SOME ITS ELEMENTS FOR EXAMPLE

<NAME>
<FIRST-NAME>JOHN </FIRST-NAME>
<LAST-NAME>MILLER </LAST-NAME>
<AGE>25 <AGE>
</NAME>

I ALSO HAVE XSD FILE VALIDATING THIS XML FILE AND WHEN I BULKINSERT IT IN MY DATABASE ELEMENT NAMES WITH
HYPHEN ARE NOT INSERTING <FIRST-NAME>JOHN </FIRST-NAME> , <LAST-NAME>MILLER </LAST-NAME>
WHERE AS NON-HYPHEN ELEMENTS <AGE>25 <AGE> INSERTED FINE.

HOW CAN I VALIDTE THE HYPHENATED ELEMENTS WITH MY XSD AND THEN INSERT INTO DATABASE. PLS HELP

sai krishna

Re: PROBLEM WITH HYPHEN (-) IN XML ELEMENT NODE

Stuart Dootson14-Oct-09 21:32

Stuart Dootson

14-Oct-09 21:32

The validation is obviously not a problem - it's that your database doesn't allow/have fields with hyphens? How are you inserting into the database?

Java, Basic, who cares - it's all a bunch of tree-hugging hippy cr*p

Re: PROBLEM WITH HYPHEN (-) IN XML ELEMENT NODE

dsaikrishna15-Oct-09 0:02

dsaikrishna

15-Oct-09 0:02

HI STUART DOOTSON , THANKS FOR REPLYING

MY DATABASE IS SQLSERVER AND I AM BULK INSERTING MY XML FILE USING SQLXML3.0 FRAMEWORK . IHAVE A VB SCRIPT LIKE

OBJECT.Execute "MYSCHEMA.XSD" , "MYXMLFILE.xml"

AM ASLO MAPPING MY XML TAGS WITH SQLSERVER TABLE NAME IN MY XSD FILE

<xsd:element name="FIRST-NAME" sql:relation="FIRSTNAME" >
<xsd:complexType>
....................
..........................

</xsd:complexType>
</xsd:element>

sai krishna

help with SOAP

roba alchab12-Oct-09 23:23

roba alchab

12-Oct-09 23:23

hi,
i don't know if i'm posting at the right forum ....so plz be merciful
i'm not familiar with the SOAP protocol or with the web services....i searched ggogle did'nt foundsomething useful on how to work with web services and implement it in my desktop application or my web application ...so any links would be appreciated

Re: help with SOAP

Richard MacCutchan13-Oct-09 0:42

Richard MacCutchan

13-Oct-09 0:42

roba alchab wrote:
i'm not familiar with the SOAP protocol or with the web services....i searched ggogle did'nt foundsomething useful on

Are you sure you searched? What about all of these[^]?

how to pass the xml textbox value to php variable

jaraldumary11-Oct-09 23:54

jaraldumary

11-Oct-09 23:54

Hi,
I am new to xml,i have create a 3 textbox using xml,and i want to pass the user inputvalue to php variable and insert into db...
how to do this...

<samplefield1fromgroup4 translate="label">
<label>User Name</label>

<frontend_type>text</frontend_type>

<sort_order>1</sort_order>
<show_in_default>1</show_in_default>
<show_in_website>1</show_in_website>
<show_in_store>1</show_in_store>
</samplefield1fromgroup4>
need help....

gaming proiject with XML

msusmitha9-Oct-09 0:49

msusmitha

9-Oct-09 0:49

Hi,

please let me know wat are teh requirements required to develop a gaming project in XML....i mean along with XML what other technologies can be used.

Re: gaming proiject with XML

Richard MacCutchan9-Oct-09 1:22

Richard MacCutchan

9-Oct-09 1:22

Try this site[^] as a starting point.

Re: gaming proiject with XML

Christian Graus22-Oct-09 18:31

Christian Graus

22-Oct-09 18:31

XML is of no intrinsic value to writing games. It may be used as a way to store data, but there will NEVER be a book or article called 'using XML to write games'. XML is not even a language.

Christian Graus

Driven to the arms of OSX by Vista.

Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.

How to implement tokenize in XSLT

sito428-Oct-09 21:08

sito42

8-Oct-09 21:08

I am trying to use the tokenize function and I have tried many different namespaces but was unsuccessful. With the Xalan namespace, a call to function-available('xalan:tokenize') returns false.

With EXSLT, I get the error: Variable 'ctxN' has not been declared.

What does that mean? This is what I have for my stylesheet element:

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"<br />
  xmlns:msxsl="urn:schemas-microsoft-com:xslt"<br />
  xmlns:str="http://exslt.org/strings" exclude-result-prefixes="str"><br />
  <xsl:include href="str.tokenize.msxsl.xsl"/>

And then, when I switch to str.tokenize.template.xsl, I get the error:

Cannot find the script or external object that implements prefix 'http://exslt.org/strings'

What am I doing wrong? I am using Microsoft Visual Studio 2008 .NET. Any ideas?

Thanks!

Getting Values [modified]

sriharsha_127-Oct-09 18:20

sriharsha_12

7-Oct-09 18:20

Hi all...i'm new to xml...i'm displaying values from xml file to html using the below code...

HTML FILE

      &lt;form id="form1" runat="server"&gt;
            &lt;div&gt;
                  &lt;asp:TreeView ID="TreeView1" runat="server" DataSourceID="XmlDataSource1"&gt;
                        &lt;DataBindings&gt;
                              &lt;asp:TreeNodeBinding DataMember="Product" ValueField="ID" TextField="Name"&gt;&lt;/asp:TreeNodeBinding&gt;
                              &lt;asp:TreeNodeBinding DataMember="Desc" ValueField="Value" TextField="Value"&gt;&lt;/asp:TreeNodeBinding&gt;
                        &lt;/DataBindings&gt;
                  &lt;/asp:TreeView&gt;
                  &lt;asp:XmlDataSource ID="XmlDataSource1" runat="server" DataFile="~/XML/XmlFile_1.xml"&gt;
                  &lt;/asp:XmlDataSource&gt;
            &lt;/div&gt;
      &lt;/form&gt;

XML FILE:

&lt;?xml version="1.0" encoding="utf-8" ?&gt;
&lt;!-- This file represents a fragment of Product 
         store inventory database --&gt;
&lt;Products&gt;
   &lt;Product ID="1" Name="a" Price="5"&gt;
      &lt;Desc Value="5 boxes x 50 Bags"/&gt;
   &lt;/Product&gt;
   &lt;Product ID="2" Name="b" Price="10"&gt;
      &lt;Desc Value="24oz bottles"/&gt;
   &lt;/Product&gt;
   &lt;Product ID="3" Name="c" Price="15"&gt;
      &lt;Desc Value="40 kg pkgs"/&gt;
   &lt;/Product&gt;
&lt;/Products&gt;

Now i wanna use a text box in HTML and i need to store them in XML....how can i do that....

modified on Friday, October 9, 2009 11:39 PM

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.