Importing and exporting markup language data in a...

Details Importing and exporting markup language data in a... Importing and exporting markup language data in a...

2007-07-24

2007-07-24

Bashore, William (Department: 2176)

Data processing: presentation processing of document, operator i

Presentation processing of document

Layout

C715S252000, C715S252000, C715S252000, C707S793000, C707S793000

Reexamination Certificate

active

11328042

ABSTRACT:
Methods and systems are provided for importing markup language formatted data into a spreadsheet document and for exporting markup language formatted data from a spreadsheet document. XML data is associated with an XML schema file defining XML data types and data type definitions for applying the XML data to the document. An XML data map is prepared that relates any XML data applied to the document back to corresponding XML elements or attributes defined in the associated schema file. When the document is imported into a spreadsheet application grid, the data map is parsed to find XPATHs in the imported spreadsheet document of XML data and the user entered data. After an imported document has been edited, the document may be exported such that the XML data applied to the document is maintained for subsequent import and use of the document.

REFERENCES:
patent: 6138130 (2000-10-01), Adler et al.
patent: 6347307 (2002-02-01), Sandhu et al.
patent: 6356901 (2002-03-01), MacLeod et al.
patent: 6418446 (2002-07-01), Lection et al.
patent: 6476833 (2002-11-01), Moshfeghi
patent: 6480860 (2002-11-01), Monday
patent: 6480865 (2002-11-01), Lee et al.
patent: 6487566 (2002-11-01), Sundaresan
patent: 6502098 (2002-12-01), Lau
patent: 6502101 (2002-12-01), Verprauskus et al.
patent: 6502112 (2002-12-01), Baisley
patent: 6631497 (2003-10-01), Jamshidi et al.
patent: 6640234 (2003-10-01), Coffen et al.
patent: 6973618 (2005-12-01), Shaughnessy et al.
patent: 7007033 (2006-02-01), Rothschiller et al.
patent: 2002/0129054 (2002-09-01), Ferguson et al.
patent: 2003/0046317 (2003-03-01), Cseri et al.
patent: 2003/0163585 (2003-08-01), Elderon et al.
patent: 2004/0054675 (2004-03-01), Li
patent: 2004/0237045 (2004-11-01), Meltzer
patent: 2005/0015379 (2005-01-01), Aureglia et al.
patent: 2005/0022111 (2005-01-01), Collet et al.
S. Khor, “Microsoft Office Excel 2003 Preview,” Jun. 2003, pp. 1-19.
F. Rice, “Transformation XML Files with XSLT When Importing into Microsoft Excel 2002,” pp. 1-11.
K. Lai et al., “Object Lens: A “Spreadsheet” for Cooperative Work,” ACM Transaction on Office Information Systems, vol. 6, No. 4, Oct. 1988, pp. 332-353.
Amer-Yahia et al., “A Mapping Schema and Interface for XML Stores,” ACM, Nov. 8, 2002, pp. 23-30.
R. Leif, “Creating a Symbiotic Relationship between XML and Ada,” Sep. 2002, Ada Letters, vol. XXII, No. 3, pp. 24-41.
E. Simpson, “From Excel to XML,” retrieving from <www.google.com>, Jan. 2002, pp. 1-7.
“Integrating with External Systems: iPlanet™ Unified Development Server”, Sun Microsystems, Inc., Ver. 5.0, Aug. 2001, pp. 127-156.
Sperberg-McQueen, C.M. and Thompson, Henry, “XML Schema”, W3C Architecture Domain, 2000-2002, pp. 1-10.
Quin, Liam, “Extensible Markup Language (XML)”, W3C Architecture Domain, 1996-2002, pp. 1-3.
Clark, James, and DeRose, Steve, “XML Path Language (XPath), Version 1.0”, W3C, 1999-2000, pp. 1-31.
“Microsoft BizTalk Server 2002—Using BizTalk Mapper”, Microsoft Corporation, 1999-2001, pp. 1-2.
“BizTalk Server 2002 Mapper User Interface”, Microsoft Corporation, 1999-2001, pp. 1.
“BizTalk Server 2002 Compiling Data”, Microsoft Corporation, 1999-2001, pp. 1.
“BizTalk Server 2002 Testing Maps”, Microsoft Corporation, 1999-2001, pp. 1-2.
“BizTalk Server 2002 View Links and Functoids By Using Grid Preview”, Microsoft Corporation, 1999-2001, pp. 1.
“The StarOffice™ 6.0 Suite: New Features Guide”, Sun Microsystems, V. 1.1, Jul. 2002, pp. 1-31.
“New Microsoft Office Family Application Taps Power of Industry-Standard XML”, Microsoft Corporation, Oct. 2002-Feb. 2003, pp. 1-2.
“Q&A: How ‘XDocs’ Alters the Paradigm for Gathering Business-Critical Information”, Microsoft Corporation, Oct. 2002-Feb. 2003, pp. 1-4.
“InfoPath: Microsoft Names New Product from Office Group”, Microsoft Corporation, Oct. 2002-Feb. 2003, pp. 1-4.
“Microsoft Unveils Visual Studio.NET Enterprise Tools”, Microsoft Corporation, May 2001, pp. 1-4.
“Microsoft Extends XML Web Services Support in .NET Enterprise Servers Through Visual Studio .NET”, Microsoft Corporation, Feb. 2002, pp. 1-3.
“How to Use XSL to Transform Excel XML Spreadsheet for Server-Side Use”, Microsoft Corporation, Aug. 2004, pp. 1-7.
“Integrated Development Environment (IDE)”, Jun. 2002, pp. 1-2.
“Altova markup your mind!”, Dec. 2002, pp. 1-3.
“Arbortext and Accessibility”, Dec. 2002, pp. 1-5.
“XML Compliance, 100% Pure XML”, Dec. 2002, pp. 1-3.
“Schemas”, Dec. 2002, pp. 1-3.
“Arbortext's Support for XSL-FO”, Dec. 2002, pp. 1-4.
“Corel XMetal4, Making XML Content Creation Easy”, Nov. 2003, pp. 1-2.
“Corel XMetal 4 and Interwoven TeamXML”, Aug. 2003, pp. 1-2.
“The Corel-XyEnterprise XML Solution”, Aug. 2003, pp. 1-2.
Chee-Yong Chan et al., “Efficient Filtering of XML Documents with XPath Expressions”, IEEE, Proceedings of the 18th International Conference on Data Engineering, Feb. 26, 2002, 10 pgs.

Affiliated with

Also associated with

Rating

Importing and exporting markup language data in a... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Importing and exporting markup language data in a..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Importing and exporting markup language data in a... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3741741