The INCITS Executive Board has approved the adoption of ISO/IEC IS29500 (Office Open XML) as an American National Standard this week (on April 15), and the document will be published soon by ANSI.  This action taken by INCITS is a relatively routine occurence, as the US typically adopts ISO/IEC standards as national standards.  As an INCITS V1 member, I was very excited to see this news.  It’s a positive step in the validation and global adoption of IS29500.

See the original post here:
IS29500 is an American National Standard

I’m currently using Excel XP (2003) and having been learning some tricks to get data out of HTML tables into an Excel document.  I stumbled onto a cool feature last night… Go to the Data menu > Import External Data > New Web Query.  What you get is effectively a web browser that lets you enter a web page or even login and navigate to a page of your choice.  The browser places little icons next to the tables in the web page, allowing you to copy that data across to your Excel spreadsheet.  This option also comes up when you have justed tried to paste table data and get the little popup to do with formatting. Also, if you’re interested, I see that in Firefox you can CTRL-Click on individual table cells and copy out the data from just those cells.  I’m sure you’ve found like me that it can be tricky copying just the column or row of data you need from a web page, and this might help you one day

Original post:
Copying HTML Table Data into Excel

In an earlier post, I said that key to government opening its data to citizens, being more transparent, and improving the relationship between citizens and government in light of our web 2.0 world was ensuring content on government sites could be easily found in search engines . Architecting sites to be search engine friendly, particularly sites with as much content and legacy code as those the government manages, can be a resource-intensive process that takes careful long-term planning.

View original here:
Practical Tips for Government Web Sites (And Everyone Else!) To Improve Their Findability in Search

How to Get a free website and blog Manual www.ucoz.com http

Here is the original post:
How to Create a free website and blog Screencast

Video Tutorial on Flash : Creating Flash Site with XML Menu [Actionscript version 2.0] Created bt flashmad : blog.browseforart.com …

See the rest here:
Creating Flash Template Part 1 – Creating Elements

It is a last minute announcement but consider making it to the first OW2 Annual Conference in Paris over the next two days: Open Source for the Computing Infrastructure MAKE A DATE TO ATTEND THE FIRST OW2 ANNUAL CONFERENCE Two days at no cost to you to discover the enterprise software that will set you free and boost your efficiency: come and take part in the first OW2 Annual Conference, April 1-2, in Paris, held during the Solutions Linux trade show. Optimize your time: attending the first OW2 Annual Conference will also offer you the opportunity to visit the Solution Linux trade show, discover the latest developments in the OW2’s leading projects and get to talk with the developers themselves

Link:
OW2 Annual Conference, April 1-2, 2009.

We had three days of WG4 face-to-face meetings in Prague last week, followed by the SC34 plenary on Friday at the same location.  As Jesper has noted, it was a tough week and we made an enormous amount of progress. For those who might not know, WG4 is the SC34 working group responsible for the maintenance of the Open XML spec, ISO/IEC 29500.  WG4 had its first meeting in Okinawa in January, and this time around in Prague we had more participants (31 the first day, as opposed to 22 in Okinawa) and worked through many more defect reports.  I’ve not seen project editor Rex Jaeschke’s official report yet, but we worked through over 30 defect reports ranging from simple editorial corrections to far-reaching changes such as the Swiss proposal to change the namespaces to distinguish them from ECMA-376 1st Edition.

See the original post:
WG4 meetings and SC 34 plenary, Prague

This week, request-log-analyzer obtained its 100th watcher on GitHub ! Bart and I have worked hard to make r-l-a a useful product for many people in various situations. The fact that more than 100 people are following the project’s progress and that at this moment, the gem has been download almost 200 times , shows that we are somewhat successful in this regard. Numbers like these, in combination with the e-mail messages we have received, motivate us to keep spending time on the project and keep improving it, even if these improvements are not directly useful for our own projects.

Read the original post:
Counter feedback

I want the XQuery to determine if the @maxOccurs attribute exists in an < xs:element > tag somewhere in the schema , and its value isn’t 1. If this is true, then, for all elements that have a @ref attribute in the schema (because we now know there’s at least one), the XQuery should get the string value of the element’s @ref attribute (what I wanted $name to be), along with the value of element’s @maxOccurs attribute (what i wanted $max to be), and lastly the string value of $max (what I wanted $index_max to be). Then finally, I just wanted to use these three values within an <xf:bind> tag that was to be returned.

Originally posted here:
returning elements without duplicates,
based on an XML schema and using an attribute as context node

Michael, Oh, yes…I forgot to mention earlier: I’d like no two <xf:bind> element tags to be the same; that’s why I was using the distinct-values() function. ~PJC On Thu, Mar 26, 2009 at 1:51 PM, Michael Kay <http://x-query.com/mailman/listinfo/talk> wrote: > > I want the XQuery to determine if the @maxOccurs attribute exists in > an < xs:element > tag somewhere in the schema , and its value isn’t 1. If this > is true, then, for all elements that have a @ref attribute in the schema > (because we now know there’s at least one), the XQuery should get the > string > value of the element’s @ref attribute (what I wanted $name to be), along > with the value of element’s @maxOccurs attribute (what i wanted $max to > be), > and lastly the string value of $max (what I wanted $index_max to be)

Read the original here:
returning elements without duplicates, based on an
XML schema and using an attribute as context node