US20140164163A1 - Importable template - Google Patents
Importable template Download PDFInfo
- Publication number
- US20140164163A1 US20140164163A1 US14/020,437 US201314020437A US2014164163A1 US 20140164163 A1 US20140164163 A1 US 20140164163A1 US 201314020437 A US201314020437 A US 201314020437A US 2014164163 A1 US2014164163 A1 US 2014164163A1
- Authority
- US
- United States
- Prior art keywords
- template
- importable
- electronic template
- general purpose
- purpose electronic
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Abandoned
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/08—Auctions
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Definitions
- the present invention is directed to a template and, in particular, a template that may be locked so that it cannot be altered and imported into a template having elements in addition to the imported template.
- data may be entered into spreadsheets, or templates, using a variety of different computer programs.
- These templates may have two different types of data.
- the templates may receive data that is entered by a party and becomes integrated with that template so that whenever a user accesses the template, the data will be provided. This data may also be locked, or remain permanent, such that a user may not be able to change any of the data.
- the template may receive data that is entered by a user, but does not remain with the template. Rather, the user must re-enter or enter new data each time the user accesses the template.
- template building software is object based, which implies that the user would create many small templates and piece them together to create an overall template.
- This software is database centric, where all properties of the templates are stored in a database. It is believed that the algorithms and reliance on computer hardware make its solution unable to scale. Thus, there is a need to develop a system that has less reliance on computer hardware and different algorithms.
- the invention is directed to an importable electronic template executable by a processor.
- the template includes an alphanumeric field created by a template creation entity and a response field created by the template creation entity. Data is electronically entered into the response field by a responding entity.
- the importable electronic template is incorporated into a general purpose electronic template by including a reference to the general purpose electronic template in the general purpose electronic template.
- the invention also provides a method of creating a general purpose electronic template that includes an importable electronic template, wherein the importable electronic template has a text field and a response field.
- the method includes inserting a reference to the importable electronic template into a code that creates the general purpose template when executed by a processor, retrieving the locked importable template, and displaying the locked importable template as a portion of the general purpose template.
- the templates of the present invention beneficially minimize the time required to create templates because many locked templates can be used to create a general purpose template.
- the templates of the present invention also beneficially enable searching data across multiple templates related to a standardized portion of a template.
- FIG. 1 is a schematic illustration of entities involved in an embodiment of an auction
- FIG. 2 is a schematic illustration of an embodiment of an auction network
- FIG. 3 is one embodiment of a sample general purpose template with an incorporated importable template
- FIG. 4 is one embodiment of a sample importable template.
- FIG. 5 is a flow diagram of creation, use and modification of a locked importable template
- FIG. 6 is a sample template creation screen display used to practice an embodiment of the invention.
- FIG. 7 is a sample template editing screen display that may be used to practice the embodiment of the invention of FIG. 6 ;
- FIG. 8 is another sample template editing screen display.
- any reference in the specification to “one embodiment” or “an embodiment” means that a particular feature, structure or characteristic described in connection with the embodiment is included in at least one embodiment of the invention.
- the appearances of phrases such as “in one embodiment” in various places in the specification are not necessarily all referring to the same embodiment.
- Templates in the present invention, refer to electronic forms having elements, such as comments and questions, which may be in fields, as well as blank response fields, and are created by a template creator.
- the electronic templates are saved in a memory device and may be accessed by responding entities.
- the responding entities reference the instructions, comments, and questions and provide appropriate responses in the response fields.
- Such templates are useful in many applications including, for example, purchaser sponsored or reverse electronic auctions.
- electronic auctions as developed by the Assignee of the present invention, are described in U.S. Pat. No. 6,230,146, issued on May 8, 2001, which is hereby expressly incorporated in its entirety by reference.
- a purchaser sponsored auction a purchaser, or sponsor, 10 desires to purchase goods and/or services from one or more suppliers 12 , 14 and 16 who bid seeking a contract award to provide those goods and/or services.
- the purchaser will award a contract to the lowest bidding qualified suppliers 12 , 14 and 16 .
- Templates are useful in qualifying suppliers to participate in the auction.
- the purchaser sponsor 10 in such a purchaser sponsored auction often compiles a list of qualification requirements prior to the auction.
- qualifications may include specifications for the type and quality of goods to be provided, logistical requirements, and delivery schedule requirements.
- These requirements may be placed in a template with fields included where responses from potential bidders are to be provided.
- Information to be inputted into the fields might include, for example, binary confirmation that the potential bidders 12 , 14 and 16 are capable of meeting a requirement, numeric information, such as a delivery date, and textual information, such as a location of a factory where the potential bidder will manufacture the desired goods.
- the template may then be stored at a location in a memory device that is accessible to potential bidders 12 , 14 and 16 .
- a location in a memory device that is accessible to potential bidders 12 , 14 and 16 .
- the template may be created by a sponsor 10 at the production server 77 or training and reporting server 80 and stored in the production database 84 or the reporting and training database 86 .
- That memory location may, furthermore, be protected by, for example, a password so that only selected potential bidders 12 , 14 and 16 are permitted to access the template.
- the directory, login and reporting servers 90 may act as a portal for access to the auction network 70 and any templates.
- Potential bidders 12 , 14 and 16 are then invited to access and respond to the templates. Those potential bidders 12 , 14 and 16 may, for example, utilize a client machine 72 to access the template through the primary communications servers 74 or secondary communications servers 75 . While there are many other uses for the templates of the present invention, the supplier/bidder scenario is utilized as the scenario in which the template of the present invention is utilized in the examples provided herein.
- Qualified bidders 12 - 16 are notified (i.e., via an e-mail) of the start and finish times for the auction.
- the auction may terminate earlier than its intended finish time if, for example, the sponsor 10 so instructs or if the auction coordinator 20 notices illegal actions or irregularities from one or more bidders during the auction.
- a bidder may be disqualified for any irregularities and blocked from participating in the current as well as future auctions. In that case, the auction may continue, but without the disqualified bidder.
- an auction may be extended beyond its scheduled finish time if, for example, a bidder has requested such an extension or to accommodate bids received after the official finish time for the auction.
- each bidder 12 - 16 may place as many bids as the bidder desires for the price and non-price bid parameters.
- a client module of communication software on a bidder's computer terminal may provide the necessary communication tool for the bidder to transmit its bids to the bid servers 77 , 80 .
- the bidder may be required to access a pre-designated web site where an auction data entry form or web page may be presented to the bidder to enter that bidder's bid data therein.
- the data entry form or page may be included as part of the client module of the communication software and may be locally displayed on the bidder's computer terminal without requiring the bidder to access a remote web site.
- the data entry form displays fields for price and non-price bid parameters where the bidder can enter the bidder's bid using a data entry device such as, for example, a computer keyboard.
- the production servers 77 receive the bids placed by the bidders 12 - 16 and forward the received bid data to the bidding software running on the production servers 77 .
- the embodiments described herein utilize an online reverse auction, wherein the present invention is performed by a computer processor, as an example.
- suppliers 12 - 16 bid to supply goods or services to a purchaser 10 and the purchaser 10 typically purchases the goods or services from the lowest priced qualified bidder 12 - 16 .
- the present invention may be used in other applications, such as, most generally, preparing databases, collecting information, requesting data, and any other applications involving entry or display of data.
- the auction would not necessarily occur online and the present invention may be performed by other than a computer processor.
- the present invention may also be utilized in connection with auctions other than reverse auctions.
- the present invention may be advantageously utilized with forward auctions, wherein the party offering the highest priced qualified bid, rather than the lowest priced qualified bid, is awarded the goods or services being sold.
- the leading bid is the highest amount offered and the leading bidder 12 - 16 is the purchaser party 10 making that highest offer
- the leading bid is the lowest amount offered and the leading bidder 12 - 16 is the supplier party 12 - 16 making that lowest bid.
- placing a “better bid” in a reverse auction indicates placing a lower bid
- placing a “better bid” in a forward auction indicates placing a higher bid.
- the template of the present invention may be imported into a template having elements in addition to the imported template and may also be locked so that it cannot be altered or modified.
- An importable template is designed for the purpose of being merged into a general purpose template.
- a general purpose template is a template into which an importable template may be imported.
- a general purpose template therefore, typically contains elements such as text or data entry fields in addition to the elements contained in any particular importable template.
- a general purpose template may contain multiple importable templates and/or multiple occurrences of a single importable template.
- Both general purpose templates and importable templates contain two types of data; (i) template creation data that defines such things as elements in the template and is input by the template designer, and (ii) response data that is entered into one or more response fields by a responding entity party to whom the template is provided.
- the present invention contemplates two types of importable templates: locked and unlocked.
- Locked importable templates have template creation data that cannot be changed by the user.
- Unlocked importable templates have template creation data that can be changed by the user. Importing an unlocked template into a general purpose template may be likened to taking a copy of the unlocked importable template and placing that copy in the general purpose template.
- the template creation data copied into the general purpose template from the unlocked importable template may be modified by the general purpose template user or creator after importation.
- Unlocked importable templates provide the benefit of permitting the template creator to copy sections of template creation data into the general purpose template and make modifications rather than recreate all the data contained in the unlocked importable template.
- locked importable templates maintain standards within general purpose templates because they cannot be changed by the creator of the general purpose template.
- a locked template offers the advantage of keeping aspects of a general template into which the locked template is imported standard.
- the aspects of the general template that are maintained as standards are those portions contained in the locked template.
- An importable template offers the advantage of not having to reenter data contained in a portion of a template that is contained in the importable template repeatedly. Once the data has been entered once into the importable template, it may thereafter be simply entered in a general template by importing the importable template.
- Locked importable templates also offer the benefit that response data entered into such a template meet certain standards.
- Such standard response data may be entered into a database. Because all responses to a locked importable template are provided in response to an unmodifiable and, therefore, identical inquiry, the database containing responses to a particular locked importable template may be searched for one or more characteristics or a range of characteristics. That database may also be searched in conjunction with other responses stored in a database or elsewhere.
- Such response data may also be formatted in the same way to facilitate searching.
- the template may ask, among other things, for a company to input the number of years the responding entity has been in business and permit a two digit integer representing years to be entered in a response field of the template. If it is later desired to allow only entities that have been in business to participate as, for example, bidding suppliers 12 - 16 , the template creator can search for all responding entities that have been in business for at least five years in that field and quickly eliminate the remaining suppliers from contention.
- a creator of a locked importable template may be permitted to alter the template creation data in the locked importable template, thereby changing the locked importable template in all general purpose templates in which it exists.
- the template, once created, is stored electronically, and completed by a responding entity electronically in a single computer network.
- the network may, for example, be a local area network, a wide area network, or the Internet and may be a network depicted in FIG. 2 .
- a link to a single storage area containing the locked importable template is placed in the general purpose template so that every use of the locked importable template in a general purpose template causes those general purpose templates to pull the template creation data associated with the locked importable template from that single storage location.
- That link may, for example, be a template identification number that is saved in a directory and associated with the memory location in which that locked importable template is stored.
- an identifier of each use of a locked importable template may be saved as a use attribute or metadata along with the locked importable template.
- a change in the locked importable template may be propagated to all general purpose templates in which the locked importable template is used. Propagation may be accomplished by accessing each template listed in the modified template use metadata and updating the locked importable template at each of those locations.
- the template creation data is defined in Extensible Markup Language (“XML”) and stored in a memory device as XML code.
- Response data is stored separately in the same or a different database.
- XML Extensible Markup Language
- the general purpose template contains a link to the appropriate XML code for the locked importable template
- the locked importable template XML code is retrieved from the memory device
- the locked importable template is displayed to the responding entity as a portion of the general purpose template
- the responding entity inputs requested response data into predefined fields of the template
- the response data is saved to the database.
- Schema 1 is a listing of an XML code for a general purpose template that, when executed by a processor, creates a general purpose template that utilizes an importable template.
- the general purpose template of schema 1 incorporates the importable template of schema 2.
- a user creates a general purpose template by importing a locked template. As shown in FIG. 3 , the imported locked section indicates that it is not able to be edited within this general purpose template by being in a different color, different font, or any other chosen indication.
- XML Schema 1 depicts the XML of FIG. 3 , which represents a general purpose template 100 that references a locked importable template. Details of the locked importable template are later explained in reference to FIGS. 6-8 .
- Schema 2 is a listing of an XML code for an importable template that, when executed by a processor, creates an importable template.
- the importable template may be incorporated into a general purpose template as shown in connection with Schema 1.
- the importable template may be either a locked or unlocked importable template.
- the template 102 created by the code in Schema 2, which is shown in FIG. 4 is a locked template.
- the XML structure of Schema 1 and Schema 2 is an example of how a locked template is referenced from another template.
- the locked importable template appears as a templateElement node in the XML structure of Schema 1, which is the XML Schema for the general purpose template. Since this is only a reference, the actual XML of the locked template is seen in Schema 2.
- a templateElement is a node in the XML schema that represents any question or imported locked template.
- Each question style i.e., checkbox, text box, radio button, geography, min/max, and select list
- This code can be seen in the schemas questionType node.
- a reference to a locked importable template has a special question type of ‘IM’, as may be seen toward the end of Schema 1.
- the “IM” question type designates that the general purpose template is referencing an importable template.
- a series of template Elements are included in Schema 1 and labeled as such.
- templateReference Within the templateElement block in Schema 1, there is a node named templateReference that designates which template is being imported into the general purpose template.
- the reference number associated with the templateReference 74 identifies the template of Schema 2. As may be seen by reference to Schema 2, the templateID is identified as 74 .
- Schema 2 is the XML for an importable template that is to be imported into the general purpose template of Schema 1.
- the XML of Schema 2 is in a format similar to a general purpose template, however, when a template that imports the template of Schema 1 is rendered, the imported template is accessed and the templateElements of the imported template are rendered as if they were part of the general purpose template. This gives the impression that the imported template is part of the importing general purpose template because there are no visual differences between template creation data on the importing general purpose template and the template creation data imported from the importable template.
- the template creation data is stored in a relational database, such as a Microsoft® SQL Server.
- a relational database such as a Microsoft® SQL Server.
- This solution eliminates the use of XML.
- the embodiment has similar functionality to the solution using XML, except that the data contained in the XML is stored in a relational database.
- the rendering of the templates is also treated differently. Implementations utilizing XML also utilize a XSL transformation, while implementations using the relational database require a rendering object to interrupt the data returned from the database.
- the details of the rendering object are dependent on the code base of the application. For instance, if the code base was Microsoft® C#, the rendering object may be a class or set of classes that interrupt the data and render the correct controls onto the page.
- a relational database implementation would also further facilitate flexibility of the templates created.
- a database facilitates customizing because columns in a database table may be ignored if they are null (empty). This is not possible with an XML structure because the outer node of the XML must be present.
- This implementation facilitates more scalable internationalization due to the nature of a relational database. Relational databases allow for tables to have multiple language representations of the same data based on the same Ids. Therefore, with the addition of a language identifier the database may return data in any language that is supported by the application.
- the XML implementation templates may be imported as locked or unlocked, while the relational database implementation templates are imported (attached) in only one manner. However, attached templates may still be automatically updated as in the XML implementation. This is accomplished through a versioning style, which is synonymous with locked and unlocked.
- the versioning styles include smart versioning and simple versioning. If a template is ‘smart’ versioned then it will behave identical to a locked template. If the attached template is ‘simple’ versioned than it will act according to the rules defined by an unlocked template. Smart versioning is only applicable to implementations that utilize a relational database. A smart-versioned template may be automatically updated when a new version is published (made available for general use). A simple versioned template will not be updated.
- Simple-versioned instances will always reflect the version of the template at the time it was created no matter how many versions of the template are created.
- Smart version templates may be used to standardize sections or template types, while simple-versioned templates may maintain a snapshot, which may be used in such instances as legal agreements.
- FIG. 5 illustrates a template creation, use, and modification flow chart 200 .
- an importable template creator creates Template 1 and indicates that it is importable and locked.
- a third class of template creator may also be established to approve modifications to locked importable templates. It should be noted that one person may have authority in more than one class.
- a general purpose template creator incorporates locked importable Template 1 into general purpose Template 2.
- a responding entity views general purpose Template 2.
- an importable template creator edits Template 1.
- approval is provided to propagate the proposed change made at 208 through all general purpose templates incorporating locked importable Template 1.
- approved edited Template 1 is propagated to all general purpose templates incorporating Template 1. Accordingly, general purpose Template 2 is modified and any responding entity that views Template 2 thereafter will see Template 2 with the modifications made to Template 1 at 208 .
- the new version may replace the previous version, or the new version may be saved in a memory device as a separate version to facilitate reversion to a previous version.
- the latest version may always be the version provided to general purpose templates incorporating the locked importable template.
- FIG. 3 illustrates a general purpose template containing a locked importable template.
- This general purpose template is created for use in a request for information related to the purchase of goods or services in an auction.
- the template furthermore, includes an importable template and that importable template is locked in this embodiment.
- the locked importable template is a block that has been inserted into the general purpose template.
- the locked importable template block contains elements. These elements include a section header, a textbox question and minimum and maximum questions. Other elements that may be present in a template include, for example, radio button questions that would be posed to responding entities and response fields in which responses may be entered by responding entities.
- Templates may be provided with unique identifiers by way of which, for example, an importable template may be referenced in a general purpose template and by way of which an importable template may be imported into a general purpose template. Elements within the template may be provided with unique identifiers as well.
- a response field in a locked importable template may have a unique identifier that is associated with that field every time response data for that field is received.
- a separate owner identifier may also be associated with each field. That owner identifier will be the same for every response entered into any field in a particular template by that responding entity and may be the same for every response entered into any field in any template by that responding entity.
- a particular field of a template may be searched across all of responding entities by searching respondent entries having the element identifier associated with that field.
- a particular field of a locked importable template may be searched across a range of responding entities by searching respondent entries with the element identifier associated with that field and a range of owner identifiers.
- a template may be stored in a database to improve retrieval speed over storage in a file system.
- a template may also be stored in a database to provide additional flexibility over file systems in the backup process. Storing the XML in a database also allows for easy collection of additional data regarding the template. This data may be used for searching or reporting. In addition, there may be other uses for additional data.
- the template is stored in XML format, however, the template may alternately be stored in another source code or an object code format.
- the template may be stored in the database as a text field of unspecified size so that the template code can be modified and can grow as needed.
- the template may be stored as a database context, for example, as a text blob in Microsoft® SQL Server 2000TM.
- a “text blob” is a common name for the SQL Server ‘text’ data type, which may be used to store XML for large amounts of text.
- Tables may be required to support the database structure for the template and the tool to search responses given by a responding entity.
- the template detail table as shown in Table 1, is a table in which the XML Schema are stored. Each change to a general purpose template or an importable template would be written to this table. Responses provided by a responding entity are stored in the AttrValue table, as shown in Table 2. Metadata that is collected about the template is stored in a Template table, as shown in Table 3. This data includes whether it is an importable, locked, unlocked or general purpose template. Whenever there is a list of templates, it is retrieved from this table. Other tables, including Tables 3, 4, and 5, are used for reference or desired functions.
- FIG. 6 is a sample template creation screen display 500 for an embodiment of the present invention.
- This screen 500 may be used to create a general purpose template or an importable template and an importable template created through this screen may be either locked or unlocked.
- a title is entered for the template.
- the title is stored in a directory so that users may identify templates by title.
- a title is a field that is required to be entered by the template creator.
- a description of the template being created is entered. That description may briefly indicate, for example, the purpose of the template or the type of use for which the template is intended.
- the template description may also be viewed by potential users when the template title is selected.
- a template description is also a field that is required to be entered by the template creator.
- Import functionality of the sample template creation screen display 500 is defined at 508 , 510 , and 512 .
- a binary selectable area or “check box” appears next to the word “Importable.” If the template being created is intended to be an importable template, the box in this embodiment is selected and a check appears to indicate that it is importable. If the template being created is not intended to be an importable template, the box in this embodiment is either not selected or is deselected and a blank box appears to indicate that the template is not importable. If a non-importable file is indicated at 506 , the “Locked” and “Unlocked” selection areas at 508 and 510 are not selectable because locking and unlocking is only applicable to importable templates.
- the “Detail Page” selection box at 512 may be selected to indicate that the template will be used as a detail page or deselected to indicate that the template will not be used as a detail page.
- a detail page can only be displayed as a secondary page, which means a general purpose template creator must specify that a question links to a given detail page.
- a non-detail page represents a general purpose template.
- FIG. 7 is a sample template editing screen display 530 that may be used in conjunction with the embodiment of the present invention illustrated in FIG. 6 .
- This screen 530 may be used to create template segments such as text and fields in a general purpose template or an importable template.
- the template editing screen 530 illustrated in FIG. 7 is based on the template created in the template creation screen display 500 of FIG. 6 .
- information is displayed in the template block 540 and that information is drawn from the template creation screen 500 : the template title is displayed at 532 , the template description is displayed at 534 , the import status is displayed at 536 , and the detail information is displayed at 538 .
- Fields are created in the “Build Fields” block 550 .
- the type of field desired is selected from the “Field Type” pull down menu 552 .
- Field types include checkbox, radio button, text box, geography, select list and min/max.
- a “Hints” area is provided to provide information to assist in selecting a field type.
- a text field may be formed by selecting “text box” from the field types menu and then completing any additional fields that may appear.
- a select list in which a responding entity would choose response data, may be formed by selecting “select list” from the field type menu.
- a “Template Preview” box 560 is provided and depicts fields created for the template thus far. As may be seen at 562 , the text field “Example Question *” has been created in the template and a response data field has been created at 564 . At 566 , an edit selection object is provided for the “Example Question *” field 562 and response data 564 field on the same line. The edit selection object 566 may be selected by a user and permits the user to edit the fields on the same line and to the right of that object 566 , or in this example, the fields shown at 562 and 564 .
- a delete selection function 568 is provided and may be selected by a user to delete the fields to the right of that function 568 , or in this example, fields 562 and 564 .
- a comment or hint may be provided by the template creator for display to the responding entity. In this example, the hint indicates that the associated fields 562 and 564 are part of an importable template.
- a scroll control function is included to permit the user to scroll up or down to view other fields.
- the language in which the template is to be displayed may be modified at a language drop down box 574 of the “Template Preview” box 560 .
- FIG. 8 is a sample template editing screen display 600 that may be used to create fields in a general purpose template.
- This screen 600 may, moreover, be used to insert an importable template into a general purpose template.
- the template editing screen 600 displays a template title at 632 , a template description at 634 , an import status at 636 , and detail information at 638 in a template description box 630 .
- Fields are created in the “Build Fields” block 650 as they are in the “Build Fields” block 550 of screen 530 .
- a “Template Preview” box 660 is provided and depicts fields created for the general purpose template thus far.
- the “Template Preview” box 660 is divided into two sections, an imported element section 662 and a non-imported element section 664 .
- One imported element 666 which is the same element created in the create new template screen 500 and the edit template screen 540 , is illustrated. It should be noted that the imported element 666 provides only an option for removal of that element and does not permit editing of that element. This is because the imported element 666 is locked and, therefore, not editable.
- a non-imported element 668 is also depicted and may be either edited or deleted. Each of the elements, both imported and non-imported, may include “Hint” areas 670 and scroll areas 672 .
- the language in which the template is to be displayed may also be modified at a language drop down box 674 of the “Template Preview” box 660 .
- a Search view is automatically generated for the template.
- a template is published (available for general use), the user may go to a search page and choose a template.
- a view of the template that will allow the user to search for data entered against the chosen template is provided.
- An example of a search algorithm is shown in Schemas 3-6 below. This algorithm uses Tables 1-7 above and stored procedures that exist in the database. Stored procedures are files that contain code that retrieves and manipulates data from a relational database.
- Searches comprise multiple micro-queries, where each query is a combination of Template Id and Attribute ID and perhaps also Attribute Value.
- the server will return a list of owners. The server will then perform set operation and return a caller with either a union or intersection of those results.
- Schema 3 illustrates a stored procedure that implements micro-query.
- Schema 3 The stored procedure of Schema 3 relies on a presence of InterMedResults static table created in TempDB, as shown in Schema 4.
- the procedure of Schema 4 will be executed from a new batch, as shown in Schema 5.
- micro-criteria may be called with a single stored procedure call, as shown in Schema 6.
Abstract
An importable electronic template and methods of creating and utilizing the importable template. The template includes an alphanumeric field created by a template creation entity and a response field created by the template creation entity. Data is electronically entered into the response field by a responding entity. The importable electronic template is incorporated into a general purpose electronic template.
Description
- The present invention is directed to a template and, in particular, a template that may be locked so that it cannot be altered and imported into a template having elements in addition to the imported template.
- In using a computer system, data may be entered into spreadsheets, or templates, using a variety of different computer programs. These templates may have two different types of data. First, the templates may receive data that is entered by a party and becomes integrated with that template so that whenever a user accesses the template, the data will be provided. This data may also be locked, or remain permanent, such that a user may not be able to change any of the data.
- Second, the template may receive data that is entered by a user, but does not remain with the template. Rather, the user must re-enter or enter new data each time the user accesses the template.
- It is believed that, presently, template building software is object based, which implies that the user would create many small templates and piece them together to create an overall template. This software is database centric, where all properties of the templates are stored in a database. It is believed that the algorithms and reliance on computer hardware make its solution unable to scale. Thus, there is a need to develop a system that has less reliance on computer hardware and different algorithms.
- The invention is directed to an importable electronic template executable by a processor. The template includes an alphanumeric field created by a template creation entity and a response field created by the template creation entity. Data is electronically entered into the response field by a responding entity. The importable electronic template is incorporated into a general purpose electronic template by including a reference to the general purpose electronic template in the general purpose electronic template.
- The invention also provides a method of creating a general purpose electronic template that includes an importable electronic template, wherein the importable electronic template has a text field and a response field. The method includes inserting a reference to the importable electronic template into a code that creates the general purpose template when executed by a processor, retrieving the locked importable template, and displaying the locked importable template as a portion of the general purpose template.
- Accordingly, the invention provides solutions to the shortcomings of prior templates. The templates of the present invention beneficially minimize the time required to create templates because many locked templates can be used to create a general purpose template. The templates of the present invention also beneficially enable searching data across multiple templates related to a standardized portion of a template.
- Those of ordinary skill in the art will readily appreciate, therefore, that those and other details, features, and advantages will become further apparent in the following detailed description of the preferred embodiments.
- The accompanying drawings, wherein like reference numerals are employed to designate like parts or steps, are included to provide a further understanding of the invention, are incorporated in and constitute a part of this specification, and illustrate embodiments of the invention that together with the description serve to explain the principles of the invention.
- In the drawings:
-
FIG. 1 is a schematic illustration of entities involved in an embodiment of an auction; -
FIG. 2 is a schematic illustration of an embodiment of an auction network; -
FIG. 3 is one embodiment of a sample general purpose template with an incorporated importable template; -
FIG. 4 is one embodiment of a sample importable template. -
FIG. 5 is a flow diagram of creation, use and modification of a locked importable template; -
FIG. 6 is a sample template creation screen display used to practice an embodiment of the invention; -
FIG. 7 is a sample template editing screen display that may be used to practice the embodiment of the invention ofFIG. 6 ; and -
FIG. 8 is another sample template editing screen display. - Reference will now be made in detail to the preferred embodiments of the present invention, examples of which are illustrated in the accompanying drawings. It is to be understood that the Figures and descriptions of the present invention included herein illustrate and describe elements that are of particular relevance to the present invention, while eliminating, for purposes of clarity, other elements found in typical computer networks.
- Any reference in the specification to “one embodiment” or “an embodiment” means that a particular feature, structure or characteristic described in connection with the embodiment is included in at least one embodiment of the invention. The appearances of phrases such as “in one embodiment” in various places in the specification are not necessarily all referring to the same embodiment.
- Templates, in the present invention, refer to electronic forms having elements, such as comments and questions, which may be in fields, as well as blank response fields, and are created by a template creator. The electronic templates are saved in a memory device and may be accessed by responding entities. The responding entities reference the instructions, comments, and questions and provide appropriate responses in the response fields.
- Such templates are useful in many applications including, for example, purchaser sponsored or reverse electronic auctions. For example, electronic auctions, as developed by the Assignee of the present invention, are described in U.S. Pat. No. 6,230,146, issued on May 8, 2001, which is hereby expressly incorporated in its entirety by reference. As shown in
FIG. 1 , in a purchaser sponsored auction, a purchaser, or sponsor, 10 desires to purchase goods and/or services from one ormore suppliers qualified suppliers - The purchaser sponsor 10 in such a purchaser sponsored auction often compiles a list of qualification requirements prior to the auction. Those qualifications may include specifications for the type and quality of goods to be provided, logistical requirements, and delivery schedule requirements. These requirements may be placed in a template with fields included where responses from potential bidders are to be provided. Information to be inputted into the fields might include, for example, binary confirmation that the
potential bidders - The template may then be stored at a location in a memory device that is accessible to
potential bidders auction network 70, which contains aclient access network 71,communication network 73, anddata processing network 76, as shown inFIG. 2 , the template may be created by asponsor 10 at theproduction server 77 or training and reportingserver 80 and stored in theproduction database 84 or the reporting andtraining database 86. That memory location may, furthermore, be protected by, for example, a password so that only selectedpotential bidders reporting servers 90 may act as a portal for access to theauction network 70 and any templates. -
Potential bidders potential bidders client machine 72 to access the template through the primary communications servers 74 orsecondary communications servers 75. While there are many other uses for the templates of the present invention, the supplier/bidder scenario is utilized as the scenario in which the template of the present invention is utilized in the examples provided herein. - Qualified bidders 12-16 are notified (i.e., via an e-mail) of the start and finish times for the auction. However, the auction may terminate earlier than its intended finish time if, for example, the
sponsor 10 so instructs or if theauction coordinator 20 notices illegal actions or irregularities from one or more bidders during the auction. A bidder may be disqualified for any irregularities and blocked from participating in the current as well as future auctions. In that case, the auction may continue, but without the disqualified bidder. On the other hand, an auction may be extended beyond its scheduled finish time if, for example, a bidder has requested such an extension or to accommodate bids received after the official finish time for the auction. - Once the auction commences, each bidder 12-16 may place as many bids as the bidder desires for the price and non-price bid parameters. A client module of communication software on a bidder's computer terminal may provide the necessary communication tool for the bidder to transmit its bids to the
bid servers production servers 77 receive the bids placed by the bidders 12-16 and forward the received bid data to the bidding software running on theproduction servers 77. - The embodiments described herein utilize an online reverse auction, wherein the present invention is performed by a computer processor, as an example. In the online reverse auction, suppliers 12-16 bid to supply goods or services to a
purchaser 10 and thepurchaser 10 typically purchases the goods or services from the lowest priced qualified bidder 12-16. It is to be understood, however, that the present invention may be used in other applications, such as, most generally, preparing databases, collecting information, requesting data, and any other applications involving entry or display of data. The auction would not necessarily occur online and the present invention may be performed by other than a computer processor. - The present invention may also be utilized in connection with auctions other than reverse auctions. For example, the present invention may be advantageously utilized with forward auctions, wherein the party offering the highest priced qualified bid, rather than the lowest priced qualified bid, is awarded the goods or services being sold. In the case of a forward auction, the leading bid is the highest amount offered and the leading bidder 12-16 is the
purchaser party 10 making that highest offer, while in a reverse auction, the leading bid is the lowest amount offered and the leading bidder 12-16 is the supplier party 12-16 making that lowest bid. Similarly, placing a “better bid” in a reverse auction indicates placing a lower bid, while placing a “better bid” in a forward auction indicates placing a higher bid. - The template of the present invention may be imported into a template having elements in addition to the imported template and may also be locked so that it cannot be altered or modified.
- An importable template is designed for the purpose of being merged into a general purpose template. A general purpose template is a template into which an importable template may be imported. A general purpose template, therefore, typically contains elements such as text or data entry fields in addition to the elements contained in any particular importable template. A general purpose template may contain multiple importable templates and/or multiple occurrences of a single importable template.
- Both general purpose templates and importable templates contain two types of data; (i) template creation data that defines such things as elements in the template and is input by the template designer, and (ii) response data that is entered into one or more response fields by a responding entity party to whom the template is provided.
- The present invention contemplates two types of importable templates: locked and unlocked. Locked importable templates have template creation data that cannot be changed by the user. Unlocked importable templates have template creation data that can be changed by the user. Importing an unlocked template into a general purpose template may be likened to taking a copy of the unlocked importable template and placing that copy in the general purpose template. The template creation data copied into the general purpose template from the unlocked importable template may be modified by the general purpose template user or creator after importation. Unlocked importable templates provide the benefit of permitting the template creator to copy sections of template creation data into the general purpose template and make modifications rather than recreate all the data contained in the unlocked importable template. Conversely, locked importable templates maintain standards within general purpose templates because they cannot be changed by the creator of the general purpose template.
- A locked template offers the advantage of keeping aspects of a general template into which the locked template is imported standard. The aspects of the general template that are maintained as standards are those portions contained in the locked template. An importable template offers the advantage of not having to reenter data contained in a portion of a template that is contained in the importable template repeatedly. Once the data has been entered once into the importable template, it may thereafter be simply entered in a general template by importing the importable template.
- Locked importable templates also offer the benefit that response data entered into such a template meet certain standards. Such standard response data may be entered into a database. Because all responses to a locked importable template are provided in response to an unmodifiable and, therefore, identical inquiry, the database containing responses to a particular locked importable template may be searched for one or more characteristics or a range of characteristics. That database may also be searched in conjunction with other responses stored in a database or elsewhere. Such response data may also be formatted in the same way to facilitate searching. For example, the template may ask, among other things, for a company to input the number of years the responding entity has been in business and permit a two digit integer representing years to be entered in a response field of the template. If it is later desired to allow only entities that have been in business to participate as, for example, bidding suppliers 12-16, the template creator can search for all responding entities that have been in business for at least five years in that field and quickly eliminate the remaining suppliers from contention.
- In one embodiment, a creator of a locked importable template may be permitted to alter the template creation data in the locked importable template, thereby changing the locked importable template in all general purpose templates in which it exists. In that embodiment, the template, once created, is stored electronically, and completed by a responding entity electronically in a single computer network. The network may, for example, be a local area network, a wide area network, or the Internet and may be a network depicted in
FIG. 2 . When the locked importable template is inserted into a general purpose template, a link to a single storage area containing the locked importable template is placed in the general purpose template so that every use of the locked importable template in a general purpose template causes those general purpose templates to pull the template creation data associated with the locked importable template from that single storage location. That link may, for example, be a template identification number that is saved in a directory and associated with the memory location in which that locked importable template is stored. Thus, any change made to the template saved at the single storage location is propagated through every general purpose template that draws upon that locked importable template. - In another embodiment, where the locked importable template is copied into general purpose templates, an identifier of each use of a locked importable template may be saved as a use attribute or metadata along with the locked importable template. In an embodiment where such use metadata is utilized, a change in the locked importable template may be propagated to all general purpose templates in which the locked importable template is used. Propagation may be accomplished by accessing each template listed in the modified template use metadata and updating the locked importable template at each of those locations.
- In one embodiment, the template creation data is defined in Extensible Markup Language (“XML”) and stored in a memory device as XML code. Response data is stored separately in the same or a different database. When a responding entity accesses a general purpose template containing a locked importable template in order to input response data, (i) the general purpose template contains a link to the appropriate XML code for the locked importable template, (ii) the locked importable template XML code is retrieved from the memory device, (iii) the locked importable template is displayed to the responding entity as a portion of the general purpose template, (iv) the responding entity inputs requested response data into predefined fields of the template, and (v) the response data is saved to the database.
-
Schema 1, as shown below, is a listing of an XML code for a general purpose template that, when executed by a processor, creates a general purpose template that utilizes an importable template. The general purpose template ofschema 1 incorporates the importable template ofschema 2. A user creates a general purpose template by importing a locked template. As shown inFIG. 3 , the imported locked section indicates that it is not able to be edited within this general purpose template by being in a different color, different font, or any other chosen indication.XML Schema 1 depicts the XML ofFIG. 3 , which represents ageneral purpose template 100 that references a locked importable template. Details of the locked importable template are later explained in reference toFIGS. 6-8 . -
XML Schema 1 <TEMPLATE> <templateInformation> <version>0</version> <templateName>General Purpose Template</templateName> <modifiedBy>{E2206A1D-00E0-1000-006B- 0A0840328C00}</modifiedBy> <referenceBy /> <importable>N</importable> <locked>N</locked> <detail>N</detail> <description>This will contain a Locked importable template.</description> <templateID>75</templateID> </templateInformation> <templateElement> <questionLocation>1</questionLocation> <questionType>H</questionType> <questionText> <questionLabel language=“EN”>General Section</ question Label> <questionLabel language=“FR”>FR</questionLabel> <questionLabel language=“DE”>DE</questionLabel> <questionUOM /> <uomID /> <uomConvME /> <uomConvEM /> <uomTextEng /> <uomTextMet /> </questionText> <questionGUID>834</questionGUID> </templateElement> <templateElement> <questionLocation>2</questionLocation> <questionType>SL</questionType> <questionText> <questionLabel language=“EN”>Choose at least one option</questionLabel> <questionLabel language=“FR”>FR</questionLabel> <questionLabel language=“DE”>DE</questionLabel> <questionUOM /> <uomID /> <uomConvME /> <uomConvEM /> <uomTextEng /> <uomTextMet /> </questionText> <optionList> <option> <detailInfo> <linkTo /> <linkEqual /> </detailInfo> <optionText> <optionLabel language=“EN”>Option 1</ optionLabel> <optionLabel language=“FR”>FR</optionLabel> <optionLabel language=“DE”>DE</optionLabel> </optionText> <optionID>836</optionID> </option> <option> <detailInfo> <linkTo /> <linkEqual /> </detailInfo> <optionText> <optionLabel language=“EN”>Option 2</ optionLabel> <optionLabel language=“FR”>FR</optionLabel> <optionLabel language=“DE”>DE</optionLabel> </optionText> <optionID>837</optionID> </option> <option> <optionText> <optionLabel language=“EN”>Option 3</ optionLabel> <optionLabel language=“FR”>FR</optionLabel> <optionLabel language=“DE”>DE</optionLabel> </optionText> <detailInfo> <linkTo /> <linkEqual /> </detailInfo> <optionID>838</optionID> </option> </optionList> <validationType /> <requiredFlag>off</requiredFlag> <hintText> <hintLabel languag=“EN”>You should choose at least one.</hintLabel> <hintLabel language=“FR”>FR</hintLabel> <hintLabel language=“DE”>DE</hintLabel> </hintText> <questionGUID>835</questionGUID> </templateElement> <templateElement> <questionLocation>3</questionLocation> <questionType>IM</questionType> <templateReference>74</templateReference> <questionGUID>839</questionGUID> </templateElement> </TEMPLATE> -
Schema 2, as shown below, is a listing of an XML code for an importable template that, when executed by a processor, creates an importable template. The importable template may be incorporated into a general purpose template as shown in connection withSchema 1. The importable template may be either a locked or unlocked importable template. Thetemplate 102 created by the code inSchema 2, which is shown inFIG. 4 , is a locked template. -
XML Schema 2 <TEMPLATE> <templateInformation> <version>0</version> <templateName>Patent Example</templateName> <modifiedBy>{E2206A1D-00E0-1000-006B- 0A0840328C00}</modifiedBy> <referenceBy> <referenceID>75</referenceID> </referenceBy> <importable>Y</importable> <locked>Y</locked> <detail>N</detail> <description>Locked Importable Template.</description> <templateID>74</templateID> </templateInformation> <templateElement> <questionLocation>1</questionLocation> <questionType>H</questionType> <questionText> <questionLabel language=“EN”>Top Level Heading</questionLabel> <questionLabel language=“FR”>FR</questionLabel> <questionLabel language=“DE”>DE</questionLabel> <questionUOM /> <uomID /> <uomConvME /> <uomConvEM /> <uomTextEng /> <uomTextMet /> </questionText> <questionGUID>825</questionGUID> </templateElement> <templateElement> <questionLocation>2</questionLocation> <questionType>SI</questionType> <questionText> <questionLabel language=“EN”>Answer this textbox question</questionLabel> <questionLabel language=“FR”>FR</questionLabel> <questionLabel language=“DE”>DE</questionLabel> <questionUOM /> <uomID /> <uomConvME /> <uomConvEM /> <uomTextEng /> <uomTextMet /> </questionText> <validationType>String</validationType> <requiredFlag>on</requiredFlag> <hintText> <hintLabel language= “EN”>Please enter some string in this text box.</hintLabel> <hintLabel language=“FR”>FR</hintLabel> <hintLabel language=“DE”>DE</hintLabel> </hintText> <questionGUID>826</questionGUID> <range> <minimumMet /> <maximumMet /> <minimumEng /> <maximumEng /> <minimum /> <maximum /> </range> <precision /> <detailInfo> <linkTo /> <linkEqual /> </detailInfo> <uom>−1</uom> <uomTextEng /> <uomTextMet /> <uomConvMe /> <uomConvEM /> </templateElement> <templateElement> <questionLocation>3</questionLocation> <questionType>MM</questionType> <questionText> <questionLabel language=“EN”>Length</questionLabel> <questionLabel language=“FR”>FR</questionLabel> <questionLabel language=“DE”>DE</questionLabel> <minID>828</minID> <maxID>829</maxID> <questionUOM>mm</questionUOM> <uomID /> <uomConvME /> <uomConvEM /> <uomTextEng /> <uomTextMet /> </questionText> <questionText> <questionLabel language=“EN”>Width</questionLabel> <questionLabel language=“FR”>FR</questionLabel> <questionLabel language=“DE”>DE</questionLabel> <minID>830</minID> <maxID>831</maxID> <questionUOM>mm</questionUOM> <uomID /> <uomConvME /> <uomConvEM /> <uomTextEng /> <uomTextMet /> </questionText> <questionText> <questionLabel language=“EN”>Height</questionLabel> <questionLabel language=“FR”>FR</questionLabel> <questionLabel language=“DE”>DE</questionLabel> <minID>832</minID> <maxID>833</maxID> <questionUOM>mm</questionUOM> <uomID /> <uomConvME /> <uomConvEM /> <uomTextEng /> <uomTextMet /> </questionText> <validationType /> <requiredFlag>on</requiredFlag> <hintText> <hintLabel language=“EN”>You must enter the deminsion of this object.</hintLabel> <hintLabel language=“FR”>FR</hintLabel> <hintLabel language=“DE”>DE</hintLabel> </hintText> <questionGUID>827</questionGUID> </templateElement> </TEMPLATE> - The XML structure of
Schema 1 andSchema 2 is an example of how a locked template is referenced from another template. The locked importable template appears as a templateElement node in the XML structure ofSchema 1, which is the XML Schema for the general purpose template. Since this is only a reference, the actual XML of the locked template is seen inSchema 2. A templateElement is a node in the XML schema that represents any question or imported locked template. Each question style (i.e., checkbox, text box, radio button, geography, min/max, and select list) has its own question type code. This code can be seen in the schemas questionType node. A reference to a locked importable template has a special question type of ‘IM’, as may be seen toward the end ofSchema 1. The “IM” question type designates that the general purpose template is referencing an importable template. A series of template Elements are included inSchema 1 and labeled as such. Within the templateElement block inSchema 1, there is a node named templateReference that designates which template is being imported into the general purpose template. The reference number associated with the templateReference 74 identifies the template ofSchema 2. As may be seen by reference toSchema 2, the templateID is identified as 74. -
Schema 2 is the XML for an importable template that is to be imported into the general purpose template ofSchema 1. The XML ofSchema 2 is in a format similar to a general purpose template, however, when a template that imports the template ofSchema 1 is rendered, the imported template is accessed and the templateElements of the imported template are rendered as if they were part of the general purpose template. This gives the impression that the imported template is part of the importing general purpose template because there are no visual differences between template creation data on the importing general purpose template and the template creation data imported from the importable template. - In another embodiment, the template creation data is stored in a relational database, such as a Microsoft® SQL Server. This solution eliminates the use of XML. The embodiment has similar functionality to the solution using XML, except that the data contained in the XML is stored in a relational database. The rendering of the templates is also treated differently. Implementations utilizing XML also utilize a XSL transformation, while implementations using the relational database require a rendering object to interrupt the data returned from the database. The details of the rendering object are dependent on the code base of the application. For instance, if the code base was Microsoft® C#, the rendering object may be a class or set of classes that interrupt the data and render the correct controls onto the page.
- A relational database implementation would also further facilitate flexibility of the templates created. A database facilitates customizing because columns in a database table may be ignored if they are null (empty). This is not possible with an XML structure because the outer node of the XML must be present. This implementation facilitates more scalable internationalization due to the nature of a relational database. Relational databases allow for tables to have multiple language representations of the same data based on the same Ids. Therefore, with the addition of a language identifier the database may return data in any language that is supported by the application.
- The XML implementation templates may be imported as locked or unlocked, while the relational database implementation templates are imported (attached) in only one manner. However, attached templates may still be automatically updated as in the XML implementation. This is accomplished through a versioning style, which is synonymous with locked and unlocked. The versioning styles include smart versioning and simple versioning. If a template is ‘smart’ versioned then it will behave identical to a locked template. If the attached template is ‘simple’ versioned than it will act according to the rules defined by an unlocked template. Smart versioning is only applicable to implementations that utilize a relational database. A smart-versioned template may be automatically updated when a new version is published (made available for general use). A simple versioned template will not be updated. Simple-versioned instances will always reflect the version of the template at the time it was created no matter how many versions of the template are created. Smart version templates may be used to standardize sections or template types, while simple-versioned templates may maintain a snapshot, which may be used in such instances as legal agreements.
-
FIG. 5 illustrates a template creation, use, andmodification flow chart 200. At 202, an importable template creator createsTemplate 1 and indicates that it is importable and locked. Two classes of template creators exist in the present embodiment: a general purpose template creator that has authority to create general purpose templates that may include both locked and unlocked importable templates and a locked importable template creator that has authority to create and modify locked importable templates. A third class of template creator may also be established to approve modifications to locked importable templates. It should be noted that one person may have authority in more than one class. - At 204, a general purpose template creator incorporates locked
importable Template 1 intogeneral purpose Template 2. At 206, a responding entity viewsgeneral purpose Template 2. At 208, an importable templatecreator edits Template 1. At 210, approval is provided to propagate the proposed change made at 208 through all general purpose templates incorporating lockedimportable Template 1. At 212, approved editedTemplate 1 is propagated to all general purposetemplates incorporating Template 1. Accordingly,general purpose Template 2 is modified and any responding entity that viewsTemplate 2 thereafter will seeTemplate 2 with the modifications made toTemplate 1 at 208. - When a template is edited, the new version may replace the previous version, or the new version may be saved in a memory device as a separate version to facilitate reversion to a previous version. The latest version may always be the version provided to general purpose templates incorporating the locked importable template.
- As discussed above,
FIG. 3 illustrates a general purpose template containing a locked importable template. This general purpose template is created for use in a request for information related to the purchase of goods or services in an auction. The template, furthermore, includes an importable template and that importable template is locked in this embodiment. The locked importable template is a block that has been inserted into the general purpose template. The locked importable template block contains elements. These elements include a section header, a textbox question and minimum and maximum questions. Other elements that may be present in a template include, for example, radio button questions that would be posed to responding entities and response fields in which responses may be entered by responding entities. - Templates may be provided with unique identifiers by way of which, for example, an importable template may be referenced in a general purpose template and by way of which an importable template may be imported into a general purpose template. Elements within the template may be provided with unique identifiers as well. Thus, for example, a response field in a locked importable template may have a unique identifier that is associated with that field every time response data for that field is received. A separate owner identifier may also be associated with each field. That owner identifier will be the same for every response entered into any field in a particular template by that responding entity and may be the same for every response entered into any field in any template by that responding entity. Therefore, a particular field of a template may be searched across all of responding entities by searching respondent entries having the element identifier associated with that field. Moreover, a particular field of a locked importable template may be searched across a range of responding entities by searching respondent entries with the element identifier associated with that field and a range of owner identifiers.
- A template may be stored in a database to improve retrieval speed over storage in a file system. A template may also be stored in a database to provide additional flexibility over file systems in the backup process. Storing the XML in a database also allows for easy collection of additional data regarding the template. This data may be used for searching or reporting. In addition, there may be other uses for additional data.
- In one embodiment, the template is stored in XML format, however, the template may alternately be stored in another source code or an object code format. The template may be stored in the database as a text field of unspecified size so that the template code can be modified and can grow as needed. For example, the template may be stored as a database context, for example, as a text blob in Microsoft® SQL Server 2000™. A “text blob” is a common name for the SQL Server ‘text’ data type, which may be used to store XML for large amounts of text.
- Tables may be required to support the database structure for the template and the tool to search responses given by a responding entity. For example, the template detail table, as shown in Table 1, is a table in which the XML Schema are stored. Each change to a general purpose template or an importable template would be written to this table. Responses provided by a responding entity are stored in the AttrValue table, as shown in Table 2. Metadata that is collected about the template is stored in a Template table, as shown in Table 3. This data includes whether it is an importable, locked, unlocked or general purpose template. Whenever there is a list of templates, it is retrieved from this table. Other tables, including Tables 3, 4, and 5, are used for reference or desired functions.
-
TABLE 1 Template PK Template Id PK Version Template Xml -
TABLE 2 AttrValue PK Template Id PK Attr Id PK Owner ID Attr_Value Instance_Id -
TABLE 3 Template PK Template Id name description last_modified modified_by template_type -
TABLE 4 Attr PK AttrId AttrName Instance_Id -
TABLE 5 AttrValueDeleted PK Template Id PK Attr Id PK Owner Id Attr_Value Instance_Id -
TABLE 6 AttrValueSearch PK Template Id PK Attr Id PK Owner Id Attr_Value Instance_Id -
TABLE 7 AttrValueDeleted PK Owner Id Template_Id Template_Status -
FIG. 6 is a sample templatecreation screen display 500 for an embodiment of the present invention. Thisscreen 500 may be used to create a general purpose template or an importable template and an importable template created through this screen may be either locked or unlocked. At 502, a title is entered for the template. When the template is stored, the title is stored in a directory so that users may identify templates by title. As indicated at 502 by the asterisk, a title is a field that is required to be entered by the template creator. At 504, a description of the template being created is entered. That description may briefly indicate, for example, the purpose of the template or the type of use for which the template is intended. The template description may also be viewed by potential users when the template title is selected. As indicated at 504 by the asterisk, a template description is also a field that is required to be entered by the template creator. - Import functionality of the sample template
creation screen display 500 is defined at 508, 510, and 512. At 508, a binary selectable area or “check box” appears next to the word “Importable.” If the template being created is intended to be an importable template, the box in this embodiment is selected and a check appears to indicate that it is importable. If the template being created is not intended to be an importable template, the box in this embodiment is either not selected or is deselected and a blank box appears to indicate that the template is not importable. If a non-importable file is indicated at 506, the “Locked” and “Unlocked” selection areas at 508 and 510 are not selectable because locking and unlocking is only applicable to importable templates. If, however, an importable template is indicated at 506, then either the locked selection area of 508 or the unlocked selection area at 510 must be selected. In this embodiment, when “Locked” is selected at 508, “Unlocked” is deselected at 510 and when “Unlocked” is selected at 510, “Locked” is deselected at 508. - The “Detail Page” selection box at 512 may be selected to indicate that the template will be used as a detail page or deselected to indicate that the template will not be used as a detail page. A detail page can only be displayed as a secondary page, which means a general purpose template creator must specify that a question links to a given detail page. A non-detail page represents a general purpose template.
-
FIG. 7 is a sample templateediting screen display 530 that may be used in conjunction with the embodiment of the present invention illustrated inFIG. 6 . Thisscreen 530 may be used to create template segments such as text and fields in a general purpose template or an importable template. Thetemplate editing screen 530 illustrated inFIG. 7 is based on the template created in the templatecreation screen display 500 ofFIG. 6 . In thetemplate editing screen 530, information is displayed in thetemplate block 540 and that information is drawn from the template creation screen 500: the template title is displayed at 532, the template description is displayed at 534, the import status is displayed at 536, and the detail information is displayed at 538. Fields are created in the “Build Fields”block 550. The type of field desired is selected from the “Field Type” pull downmenu 552. In this embodiment, it is required that the person creating the template select a field type. Field types include checkbox, radio button, text box, geography, select list and min/max. A “Hints” area is provided to provide information to assist in selecting a field type. - For example, when creating a field for a template, a text field may be formed by selecting “text box” from the field types menu and then completing any additional fields that may appear. A select list, in which a responding entity would choose response data, may be formed by selecting “select list” from the field type menu.
- A “Template Preview”
box 560 is provided and depicts fields created for the template thus far. As may be seen at 562, the text field “Example Question *” has been created in the template and a response data field has been created at 564. At 566, an edit selection object is provided for the “Example Question *”field 562 andresponse data 564 field on the same line. Theedit selection object 566 may be selected by a user and permits the user to edit the fields on the same line and to the right of thatobject 566, or in this example, the fields shown at 562 and 564. At 568, adelete selection function 568 is provided and may be selected by a user to delete the fields to the right of thatfunction 568, or in this example, fields 562 and 564. At 570, a comment or hint may be provided by the template creator for display to the responding entity. In this example, the hint indicates that the associatedfields box 574 of the “Template Preview”box 560. -
FIG. 8 is a sample templateediting screen display 600 that may be used to create fields in a general purpose template. Thisscreen 600 may, moreover, be used to insert an importable template into a general purpose template. Thetemplate editing screen 600, displays a template title at 632, a template description at 634, an import status at 636, and detail information at 638 in atemplate description box 630. Fields are created in the “Build Fields”block 650 as they are in the “Build Fields”block 550 ofscreen 530. - A “Template Preview”
box 660 is provided and depicts fields created for the general purpose template thus far. The “Template Preview”box 660 is divided into two sections, an importedelement section 662 and anon-imported element section 664. One importedelement 666, which is the same element created in the createnew template screen 500 and theedit template screen 540, is illustrated. It should be noted that the importedelement 666 provides only an option for removal of that element and does not permit editing of that element. This is because the importedelement 666 is locked and, therefore, not editable. Anon-imported element 668 is also depicted and may be either edited or deleted. Each of the elements, both imported and non-imported, may include “Hint”areas 670 and scrollareas 672. The language in which the template is to be displayed may also be modified at a language drop downbox 674 of the “Template Preview”box 660. - When the template is created, a Search view is automatically generated for the template. Once a template is published (available for general use), the user may go to a search page and choose a template. A view of the template that will allow the user to search for data entered against the chosen template is provided. An example of a search algorithm is shown in Schemas 3-6 below. This algorithm uses Tables 1-7 above and stored procedures that exist in the database. Stored procedures are files that contain code that retrieves and manipulates data from a relational database.
- Searches comprise multiple micro-queries, where each query is a combination of Template Id and Attribute ID and perhaps also Attribute Value. After each micro-query is processed, the server will return a list of owners. The server will then perform set operation and return a caller with either a union or intersection of those results.
Schema 3 illustrates a stored procedure that implements micro-query. -
Schema 3ALTER procedure ap_AttrValueSearhByTemplIdAttrId_List_Intermed Results -- Returns intersection of set of OwnerIds that are already in #Owner -- and OwnerIds which satisfy the new @Where clause. -- counts on the existence of #Owner table that is created by caller @TemplateId int, @AttrId int, @RowCount int output as set nocount on declare @temp table (ownerid int) declare @intersection table (ownerid int) declare @spid int set @spid = @@spid if not exists(select spid from tempdb.dbo.IntermedResults where spid = @spid) begin insert into tempdb.dbo.IntermedResuts (spid, OwnerId) select distinct @spid, OwnerId from AttrValueSearch (nolock) where TemplateId = @TemplateId and AttrId = @AttrId set @RowCoount = @@Rowcount return end insert into @tmp select OwnerId from AttrValueSearch (nolock) where TemplateId = @TemplateId and AttrId = @AttrId insert into @intersection(OwnerId) select distint tempdb.dbo.IntermedResults.ownerID from tempdb.dbo.IntermedResults (nolock) inner join (select * from @tmp) tmp on tempdb.dbo.IntermedResults.OwnerId = tmp.OwnerId and tempdb.dbo.IntermedResults.spid = @spid --truncate table #Owner delete tempdb.dbo.IntermedResults where spid = @spid insert into tempdb.dbo.IntermedResults (spid, OwnerId) select * from (select distinct @spid spid, OwnerId from @intersection ) a set @RowCount = @@Rowcount return - The stored procedure of
Schema 3 relies on a presence of InterMedResults static table created in TempDB, as shown in Schema 4. -
Schema 4 CREATE TABLE [InterMedResults] ( [spid] [int] NOT NULL , [OwnerId] [int] NOT NULL , CONSTRAINT [PK_InterMedResults] PRIMARY KEY CLUSTERED ( [spid], [OwnderId] ) ON [PRIMARY] ) ON [PRIMARY] GO - In one embodiment, the procedure of Schema 4 will be executed from a new batch, as shown in Schema 5.
-
Schema 5 set nocount on declare @rc int exec ap_AttrValueSearhByTemplIdAttrId_List_IntermedResults 99, 333, @rc output if @rc = 0 goto BATCH_END exec ap_AttrValueSearhByTemplIdAttrId_List_IntermedResults 99, 334, @rc output if @rc = 0 goto BATCH_END exec ap_AttrValueSearhByTemplIdAttrId_List_IntermedResults 99, 335, @rc output if @rc = 0 goto BATCH_END select ownerId from tempdb.dbo.IntermedResults where spid = @@spid BATCH_END: delete tempdb.dbo.IntermedResults where spid = @@spid Other Modification: ALTER Proc _New_AttrSearch @TemplateId int, @Where varcher(1000), @NumMatching int as set nocount on Declare @SQL varchar(2000) select @SQL = ’ select OwnerId,count(*) as NumMatching From AttrValues_Comma where TemplateId = ’+ convert(varchar(15),@TemplateId) +’ and (‘+ @Where +’) Group by OwnerId Having count(distint AttrId) >= ‘+ convert(varchar(15),@NumMatching) exec (@SQL) - Finally, multiple micro-criteria may be called with a single stored procedure call, as shown in Schema 6.
-
Schema 6 Exec _New_AttrSearch 200, ‘(AttrID = 3422 and AttrValue > 35) or (AttrID = 2349 and AttrValue = 333)’ , 2 - While the invention has been described in detail and with reference to specific embodiments thereof, it will be apparent to one skilled in the art that various changes and modifications can be made therein without departing from the spirit and scope thereof. In particular, it should be noted that while the templates described above have been described in the context of auctions, the templates may be used in any non-auction situations. Thus, it is intended that the present invention cover the modifications and variations of this invention provided they come within the scope of the appended claims and their equivalents.
Claims (20)
1. A system, comprising:
an interface configured to:
receive a request for a general purpose electronic template including a first set of elements, wherein the general purpose electronic template includes a reference to an importable electronic template to be imported into the general purpose electronic template; and
in response to receiving the request, obtain the importable electronic template based at least in part on the reference included in the general purpose electronic template, wherein the importable electronic template includes a second set of elements including:
a text field; and
a response field:
a processor configured to:
render the obtained importable electronic template as a portion of the general purpose electronic template at least in part by importing the obtained importable electronic template into the general purpose electronic template such that the general purpose electronic template includes at least a portion of the second set of elements included in the importable electronic template in addition to the first set of elements; and
a memory coupled to the processor and configured to provide the processor with instructions.
2. The system recited in claim 1 , wherein the importable electronic template is locked such that a user of the general purpose electronic template is prohibited from modifying the importable electronic template.
3. The system recited in claim 2 , wherein the interface is further configured to receive an indication of a change to the importable electronic template, wherein the change is caused at least in part by a second user that is permitted to modify the importable electronic template.
4. The system recited in claim 1 , wherein the reference to the importable electronic template includes a reference to a location in a data storage in which the importable electronic template is stored.
5. The system recited in claim 1 , wherein at least one of the text field and the response field are referenced by the general purpose electronic template.
6. The system recited in claim 1 , wherein the text field of the importable electronic template is modified after the importable electronic template is imported into the general purpose electronic template.
7. The system recited in claim 6 , wherein the modification to the text field is rendered in the general purpose electronic template.
8. The system recited in claim 6 , wherein the modification to the text field is propagated to a second general purpose electronic template that includes a reference to the importable electronic template.
9. The system recited in claim 1 , wherein the response field is modified after the importable electronic template is incorporated into the general purpose electronic template.
10. The system recited in claim 9 , wherein the modification to the response field is rendered in the general purpose electronic template.
11. They system recited in claim 9 , wherein the modification to the response field is propagated to a second general purpose electronic template that includes a reference to the importable electronic template.
12. The system recited in claim 1 , wherein the text field is configured to receive template creation data stored in at least one of a relational database and a memory device of XML code.
13. The system recited in claim 1 , wherein the processor is further configured to render a search view that permits a user to search for the importable electronic template and data entered against the importable electronic template.
14. A method, comprising:
receiving a request for a general purpose electronic template including a first set of elements, wherein the general purpose electronic template includes a reference to an importable electronic template to be imported into the general purpose electronic template; and
in response to receiving the request, obtaining the importable electronic template based at least in part on the reference included in the general purpose electronic template, wherein the importable electronic template includes a second set of elements including:
a text field; and
a response field; and
rendering the obtained importable electronic template as a portion of the general purpose electronic template at least in part by importing the obtained importable electronic template into the general purpose electronic template such that the general purpose electronic template includes at least a portion of the second set of elements included in the importable electronic template in addition to the first set of elements.
15. The method of claim 14 , wherein the importable electronic template is locked such that a user of the general purpose electronic template is prohibited from modifying the importable electronic template.
16. The method of claim 14 , wherein the reference to the importable electronic template includes a reference to a location in a data storage in which the importable electronic template is stored.
17. The method of claim 14 , wherein at least one of the text field and the response field of the importable electronic template is modified after the importable electronic template is imported into the general purpose electronic template.
18. A computer program product, the computer program product being embodied in a tangible computer readable storage medium and comprising computer instructions for:
receiving a request for a general purpose electronic template including a first set of elements, wherein the general purpose electronic template includes a reference to an importable electronic template to be imported into the general purpose electronic template; and
in response to receiving the request, obtaining the importable electronic template based at least in part on the reference included in the general purpose electronic template, wherein the importable electronic template includes a second set of elements including:
a text field; and
a response field; and
rendering the obtained importable electronic template as a portion of the general purpose electronic template at least in part by importing the obtained importable electronic template into the general purpose electronic template such that the general purpose electronic template includes at least a portion of the second set of elements included in the importable electronic template in addition to the first set of elements.
19. The computer program product of claim 18 , wherein the importable electronic template is locked such that a user of the general purpose electronic template is prohibited from modifying the importable electronic template.
20. The computer program product of claim 18 , wherein at least one of the text field and the response field of the importable electronic template is modified after the importable electronic template is imported into the general purpose electronic template.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US14/020,437 US20140164163A1 (en) | 2002-07-31 | 2013-09-06 | Importable template |
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/210,898 US8554650B1 (en) | 2002-07-31 | 2002-07-31 | Importable template |
US14/020,437 US20140164163A1 (en) | 2002-07-31 | 2013-09-06 | Importable template |
Related Parent Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/210,898 Continuation US8554650B1 (en) | 2002-07-31 | 2002-07-31 | Importable template |
Publications (1)
Publication Number | Publication Date |
---|---|
US20140164163A1 true US20140164163A1 (en) | 2014-06-12 |
Family
ID=31187458
Family Applications (2)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/210,898 Active 2028-04-14 US8554650B1 (en) | 2002-07-31 | 2002-07-31 | Importable template |
US14/020,437 Abandoned US20140164163A1 (en) | 2002-07-31 | 2013-09-06 | Importable template |
Family Applications Before (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
US10/210,898 Active 2028-04-14 US8554650B1 (en) | 2002-07-31 | 2002-07-31 | Importable template |
Country Status (3)
Country | Link |
---|---|
US (2) | US8554650B1 (en) |
AU (1) | AU2003257076A1 (en) |
WO (1) | WO2004012081A2 (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20170171102A1 (en) * | 2015-12-10 | 2017-06-15 | Affirmed Networks, Inc. | Data driven automated provisioning of telecommunication applications |
Families Citing this family (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7607084B2 (en) * | 2003-10-03 | 2009-10-20 | Vistaprint Technologies Limited | Electronic product design |
US8463667B2 (en) | 2008-01-11 | 2013-06-11 | Microsoft Corporation | Exporting and importing business templates |
US9361396B2 (en) | 2008-01-31 | 2016-06-07 | Microsoft Technology Licensing, Llc | Adaptation of display pages for client environments |
US10242069B2 (en) | 2015-03-13 | 2019-03-26 | Microsoft Technology Licensing, Llc | Enhanced template curating |
Citations (19)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4745559A (en) * | 1985-12-27 | 1988-05-17 | Reuters Limited | Method and system for dynamically controlling the content of a local receiver data base from a transmitted data base in an information retrieval communication network |
US5987480A (en) * | 1996-07-25 | 1999-11-16 | Donohue; Michael | Method and system for delivering documents customized for a particular user over the internet using imbedded dynamic content |
US20010035875A1 (en) * | 1996-01-11 | 2001-11-01 | Kenji Suzuki | Image edit device adapted to rapidly lay-out photographs into templates with means for preview and correction by user |
US20010047297A1 (en) * | 2000-02-16 | 2001-11-29 | Albert Wen | Advertisement brokering with remote ad generation system and method in a distributed computer network |
US20010045963A1 (en) * | 1997-04-14 | 2001-11-29 | Apple Computer, Inc. | Method and apparatus for binding user interface objects to application objects |
US20010049681A1 (en) * | 2000-02-09 | 2001-12-06 | Bova G. Steven | Integrated multidimensional database |
US20010051964A1 (en) * | 1995-06-07 | 2001-12-13 | R.R. Donnelley & Sons Company | Imposition process and apparatus for variable imaging system |
US20010050681A1 (en) * | 2000-03-31 | 2001-12-13 | I-Media World.Com | Method and system for creating and delivering electronic, multi-media presentations |
US20010052910A1 (en) * | 1999-11-29 | 2001-12-20 | Parekh Dilip J. | Method and system for generating display screen templates |
US20020001307A1 (en) * | 2000-05-20 | 2002-01-03 | Equipe Communications Corporation | VPI/VCI availability index |
US20020059327A1 (en) * | 2000-07-31 | 2002-05-16 | Starkey James A. | Method and apparatus for generating web pages from templates |
US20020095654A1 (en) * | 2000-09-06 | 2002-07-18 | Ns Solutions Corporation | Program generating support system, program generating method, storage medium and program |
US20020161602A1 (en) * | 2001-01-27 | 2002-10-31 | Dougherty Karen Ann | Methods and systems for identifying prospective customers and managing deals |
US20030014442A1 (en) * | 2001-07-16 | 2003-01-16 | Shiigi Clyde K. | Web site application development method using object model for managing web-based content |
US20030221162A1 (en) * | 2000-03-20 | 2003-11-27 | Sridhar Mandayam Andampillai | Meta-templates in website development and methods therefor |
US6789252B1 (en) * | 1999-04-15 | 2004-09-07 | Miles D. Burke | Building business objects and business software applications using dynamic object definitions of ingrediential objects |
US7136916B2 (en) * | 2002-03-08 | 2006-11-14 | Siemens Aktiengesellschaft | Method for event management |
US7213202B1 (en) * | 1998-12-11 | 2007-05-01 | Microsoft Corporation | Simplified design for HTML |
US8321457B2 (en) * | 2000-09-08 | 2012-11-27 | Oracle International Corporation | Techniques for automatically developing a web site |
Family Cites Families (76)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US3581072A (en) | 1968-03-28 | 1971-05-25 | Frederick Nymeyer | Auction market computation system |
US3863060A (en) | 1972-10-30 | 1975-01-28 | Hewlett Packard Co | General purpose calculator with capability for performing interdisciplinary business calculations |
JPS58189761A (en) | 1982-04-30 | 1983-11-05 | Casio Comput Co Ltd | Processor for totalization of table data |
US4674044A (en) | 1985-01-30 | 1987-06-16 | Merrill Lynch, Pierce, Fenner & Smith, Inc. | Automated securities trading system |
JPH0743748B2 (en) | 1986-02-17 | 1995-05-15 | 株式会社オークネット | Information transmission processing method of auction information transmission processing system |
US4799156A (en) | 1986-10-01 | 1989-01-17 | Strategic Processing Corporation | Interactive market management system |
US4845625A (en) | 1987-04-29 | 1989-07-04 | Stannard Louis A | Flight bidding system or the like especially for airline personnel |
US4992940A (en) | 1989-03-13 | 1991-02-12 | H-Renee, Incorporated | System and method for automated selection of equipment for purchase through input of user desired specifications |
US5136501A (en) | 1989-05-26 | 1992-08-04 | Reuters Limited | Anonymous matching system |
US5367619A (en) * | 1990-04-27 | 1994-11-22 | Eaton Corporation | Electronic data entry system employing an expert system to facilitate generation of electronic data forms with complex interrelationships between fields and subforms |
US5243515A (en) | 1990-10-30 | 1993-09-07 | Lee Wayne M | Secure teleprocessing bidding system |
CA2054026A1 (en) * | 1990-10-31 | 1992-05-01 | William Monroe Turpin | Goal oriented electronic form system |
GB9027249D0 (en) | 1990-12-17 | 1991-02-06 | Reuters Ltd | Offer matching system |
US5297032A (en) | 1991-02-01 | 1994-03-22 | Merrill Lynch, Pierce, Fenner & Smith Incorporated | Securities trading workstation |
GB9103907D0 (en) | 1991-02-25 | 1991-04-10 | Beaumont Maxin International L | Interactive transaction processing system |
US5193056A (en) | 1991-03-11 | 1993-03-09 | Signature Financial Group Inc. | Data processing system for hub and spoke financial services configuration |
US5375055A (en) | 1992-02-03 | 1994-12-20 | Foreign Exchange Transaction Services, Inc. | Credit management for electronic brokerage system |
US5794219A (en) | 1996-02-20 | 1998-08-11 | Health Hero Network, Inc. | Method of conducting an on-line auction with bid pooling |
US5402336A (en) | 1993-01-15 | 1995-03-28 | Ss&D Corporation | System and method for allocating resources of a retailer among multiple wholesalers |
US5802502A (en) | 1993-05-24 | 1998-09-01 | British Telecommunications Public Limited Company | System for selective communication connection based on transaction pricing signals |
US5794207A (en) | 1996-09-04 | 1998-08-11 | Walker Asset Management Limited Partnership | Method and apparatus for a cryptographically assisted commercial network system designed to facilitate buyer-driven conditional purchase offers |
US5394324A (en) | 1993-12-08 | 1995-02-28 | Xerox Corporation | Auction-based control system for energy resource management in a building |
US5799151A (en) | 1994-04-04 | 1998-08-25 | Hoffer; Steven M. | Interactive electronic trade network and user interface |
US5809483A (en) | 1994-05-13 | 1998-09-15 | Broka; S. William | Online transaction processing system for bond trading |
US5915209A (en) | 1994-11-21 | 1999-06-22 | Lawrence; David | Bond trading system |
US5684963A (en) | 1995-03-20 | 1997-11-04 | Discreet Logic, Inc. | System and method for distributing video from a plurality of video providers |
US5553145A (en) | 1995-03-21 | 1996-09-03 | Micali; Silvia | Simultaneous electronic transactions with visible trusted parties |
US5689652A (en) | 1995-04-27 | 1997-11-18 | Optimark Technologies, Inc. | Crossing network utilizing optimal mutual satisfaction density profile |
US5640569A (en) | 1995-04-28 | 1997-06-17 | Sun Microsystems, Inc. | Diverse goods arbitration system and method for allocating resources in a distributed computer system |
US5664115A (en) | 1995-06-07 | 1997-09-02 | Fraser; Richard | Interactive computer system to match buyers and sellers of real estate, businesses and other property using the internet |
US5765138A (en) | 1995-08-23 | 1998-06-09 | Bell Atlantic Network Services, Inc. | Apparatus and method for providing interactive evaluation of potential vendors |
US5826244A (en) | 1995-08-23 | 1998-10-20 | Xerox Corporation | Method and system for providing a document service over a computer network using an automated brokered auction |
US5832496A (en) | 1995-10-12 | 1998-11-03 | Ncr Corporation | System and method for performing intelligent analysis of a computer database |
US5758327A (en) | 1995-11-01 | 1998-05-26 | Ben D. Gardner | Electronic requisition and authorization process |
US5606602A (en) | 1995-11-06 | 1997-02-25 | Summit Telecom Systems, Inc. | Bidding for telecommunications traffic |
US5715402A (en) | 1995-11-09 | 1998-02-03 | Spot Metals Online | Method and system for matching sellers and buyers of spot metals |
US5905975A (en) | 1996-01-04 | 1999-05-18 | Ausubel; Lawrence M. | Computer implemented methods and apparatus for auctions |
US6055518A (en) | 1996-02-01 | 2000-04-25 | At&T Corporation | Secure auction systems |
US5758328A (en) | 1996-02-22 | 1998-05-26 | Giovannoli; Joseph | Computerized quotation system and method |
US5835896A (en) | 1996-03-29 | 1998-11-10 | Onsale, Inc. | Method and system for processing and transmitting electronic auction information |
IL126793A (en) | 1996-03-29 | 2000-10-31 | Onsale Inc | Method and system for processing and transmitting electronic auction information |
US5774873A (en) | 1996-03-29 | 1998-06-30 | Adt Automotive, Inc. | Electronic on-line motor vehicle auction and information system |
US6023685A (en) | 1996-05-23 | 2000-02-08 | Brett; Kenton F. | Computer controlled event ticket auctioning system |
US5799285A (en) | 1996-06-07 | 1998-08-25 | Klingman; Edwin E. | Secure system for electronic selling |
US5897621A (en) | 1996-06-14 | 1999-04-27 | Cybercash, Inc. | System and method for multi-currency transactions |
US5890138A (en) | 1996-08-26 | 1999-03-30 | Bid.Com International Inc. | Computer auction system |
US5862223A (en) | 1996-07-24 | 1999-01-19 | Walker Asset Management Limited Partnership | Method and apparatus for a cryptographically-assisted commercial network system designed to facilitate and support expert-based commerce |
JP3407561B2 (en) | 1996-09-04 | 2003-05-19 | 株式会社日立製作所 | Auction apparatus and method |
US5966699A (en) | 1996-10-11 | 1999-10-12 | Zandi; Richard | System and method for conducting loan auction over computer network |
EP0843266A3 (en) * | 1996-11-18 | 2000-01-19 | Adobe Systems, Inc. | Dynamic incremental updating of electronic documents |
US5905974A (en) | 1996-12-13 | 1999-05-18 | Cantor Fitzgerald Securities | Automated auction protocol processor |
US5797127A (en) | 1996-12-31 | 1998-08-18 | Walker Asset Management Limited Partnership | Method, apparatus, and program for pricing, selling, and exercising options to purchase airline tickets |
DK10797A (en) | 1997-01-30 | 1997-01-30 | Autocom Aps | Procedure for holding an auction, as well as uses of the method |
US5803500A (en) | 1997-03-27 | 1998-09-08 | Mossberg; Bjoern E. F. | Method and kit for conducting an auction |
US6119229A (en) | 1997-04-11 | 2000-09-12 | The Brodia Group | Virtual property system |
US6161099A (en) * | 1997-05-29 | 2000-12-12 | Muniauction, Inc. | Process and apparatus for conducting auctions over electronic networks |
US6308188B1 (en) * | 1997-06-19 | 2001-10-23 | International Business Machines Corporation | System and method for building a web site with automated workflow |
US6058379A (en) | 1997-07-11 | 2000-05-02 | Auction Source, L.L.C. | Real-time network exchange with seller specified exchange parameters and interactive seller participation |
US6061663A (en) | 1998-04-21 | 2000-05-09 | The Nasdaq Stock Market, Inc. | Index rebalancing |
US6415269B1 (en) | 1998-05-29 | 2002-07-02 | Bidcatcher, L.P. | Interactive remote auction bidding system |
US6151589A (en) | 1998-09-10 | 2000-11-21 | International Business Machines Corporation | Methods for performing large scale auctions and online negotiations |
US6230146B1 (en) | 1998-09-18 | 2001-05-08 | Freemarkets, Inc. | Method and system for controlling closing times of electronic auctions involving multiple lots |
US20020026321A1 (en) * | 1999-02-26 | 2002-02-28 | Sadeg M. Faris | Internet-based system and method for fairly and securely enabling timed-constrained competition using globally time-sychronized client subsystems and information servers having microsecond client-event resolution |
JP2000250841A (en) * | 1999-03-02 | 2000-09-14 | Hitachi Ltd | Method and device for generating page, storage medium recorded with the page generation program and electronic mole system |
US20010032092A1 (en) * | 2000-02-07 | 2001-10-18 | James Calver | Small business web-based portal method and system |
US6366891B1 (en) | 2000-02-08 | 2002-04-02 | Vanberg & Dewulf | Data processing system for conducting a modified on-line auction |
US20020091582A1 (en) * | 2000-05-11 | 2002-07-11 | Palmer John F. | Systems and methods for e-commerce facilitation and implementation |
WO2001088818A2 (en) * | 2000-05-18 | 2001-11-22 | Treasuryconnect Llc | Electronic trading systems and methods |
JP2002183504A (en) * | 2000-06-27 | 2002-06-28 | Tadashi Goino | Auction method, auction system and server |
US20020062276A1 (en) * | 2000-08-03 | 2002-05-23 | Craig Krueger | Wireless distributed certified real time bidding and tracking system for live events |
US20020059132A1 (en) * | 2000-08-18 | 2002-05-16 | Quay Steven C. | Online bidding for a contract to provide a good or service |
US20020035483A1 (en) * | 2000-09-20 | 2002-03-21 | Patel Kirtikumar Natubhai | Multiple portal distributed business/information system and method |
US20020065769A1 (en) * | 2000-11-30 | 2002-05-30 | Roberto Irribarren | Method and apparatus for processing unmet demand |
US8719703B2 (en) * | 2000-12-08 | 2014-05-06 | Xerox Corporation | Systems and methods for editing a web page |
US20020099638A1 (en) * | 2001-01-03 | 2002-07-25 | Coffman Kathryn D. | Method and system for electronically communicating with suppliers, such as under an electronic auction |
US20030220879A1 (en) * | 2001-11-21 | 2003-11-27 | Gaughan Breen P. | System and method for electronic document processing |
-
2002
- 2002-07-31 US US10/210,898 patent/US8554650B1/en active Active
-
2003
- 2003-07-31 WO PCT/US2003/023947 patent/WO2004012081A2/en not_active Application Discontinuation
- 2003-07-31 AU AU2003257076A patent/AU2003257076A1/en not_active Abandoned
-
2013
- 2013-09-06 US US14/020,437 patent/US20140164163A1/en not_active Abandoned
Patent Citations (19)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4745559A (en) * | 1985-12-27 | 1988-05-17 | Reuters Limited | Method and system for dynamically controlling the content of a local receiver data base from a transmitted data base in an information retrieval communication network |
US20010051964A1 (en) * | 1995-06-07 | 2001-12-13 | R.R. Donnelley & Sons Company | Imposition process and apparatus for variable imaging system |
US20010035875A1 (en) * | 1996-01-11 | 2001-11-01 | Kenji Suzuki | Image edit device adapted to rapidly lay-out photographs into templates with means for preview and correction by user |
US5987480A (en) * | 1996-07-25 | 1999-11-16 | Donohue; Michael | Method and system for delivering documents customized for a particular user over the internet using imbedded dynamic content |
US20010045963A1 (en) * | 1997-04-14 | 2001-11-29 | Apple Computer, Inc. | Method and apparatus for binding user interface objects to application objects |
US7213202B1 (en) * | 1998-12-11 | 2007-05-01 | Microsoft Corporation | Simplified design for HTML |
US6789252B1 (en) * | 1999-04-15 | 2004-09-07 | Miles D. Burke | Building business objects and business software applications using dynamic object definitions of ingrediential objects |
US20010052910A1 (en) * | 1999-11-29 | 2001-12-20 | Parekh Dilip J. | Method and system for generating display screen templates |
US20010049681A1 (en) * | 2000-02-09 | 2001-12-06 | Bova G. Steven | Integrated multidimensional database |
US20010047297A1 (en) * | 2000-02-16 | 2001-11-29 | Albert Wen | Advertisement brokering with remote ad generation system and method in a distributed computer network |
US20030221162A1 (en) * | 2000-03-20 | 2003-11-27 | Sridhar Mandayam Andampillai | Meta-templates in website development and methods therefor |
US20010050681A1 (en) * | 2000-03-31 | 2001-12-13 | I-Media World.Com | Method and system for creating and delivering electronic, multi-media presentations |
US20020001307A1 (en) * | 2000-05-20 | 2002-01-03 | Equipe Communications Corporation | VPI/VCI availability index |
US20020059327A1 (en) * | 2000-07-31 | 2002-05-16 | Starkey James A. | Method and apparatus for generating web pages from templates |
US20020095654A1 (en) * | 2000-09-06 | 2002-07-18 | Ns Solutions Corporation | Program generating support system, program generating method, storage medium and program |
US8321457B2 (en) * | 2000-09-08 | 2012-11-27 | Oracle International Corporation | Techniques for automatically developing a web site |
US20020161602A1 (en) * | 2001-01-27 | 2002-10-31 | Dougherty Karen Ann | Methods and systems for identifying prospective customers and managing deals |
US20030014442A1 (en) * | 2001-07-16 | 2003-01-16 | Shiigi Clyde K. | Web site application development method using object model for managing web-based content |
US7136916B2 (en) * | 2002-03-08 | 2006-11-14 | Siemens Aktiengesellschaft | Method for event management |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20170171102A1 (en) * | 2015-12-10 | 2017-06-15 | Affirmed Networks, Inc. | Data driven automated provisioning of telecommunication applications |
US11005773B2 (en) * | 2015-12-10 | 2021-05-11 | Microsoft Technology Licensing, Llc | Data driven automated provisioning of telecommunication applications |
Also Published As
Publication number | Publication date |
---|---|
AU2003257076A8 (en) | 2004-02-16 |
AU2003257076A1 (en) | 2004-02-16 |
US8554650B1 (en) | 2013-10-08 |
WO2004012081A2 (en) | 2004-02-05 |
WO2004012081A3 (en) | 2004-05-13 |
WO2004012081A9 (en) | 2004-07-08 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US10382420B1 (en) | Website owner verification system, method, and device | |
US7401094B1 (en) | Automated generation of dynamic data entry user interface for relational database management systems | |
US6418400B1 (en) | Representation and processing of EDI mapping templates | |
US10296543B2 (en) | Automated creation and delivery of database content | |
US7254581B2 (en) | System and method for creation and maintenance of a rich content or content-centric electronic catalog | |
US7013289B2 (en) | Global electronic commerce system | |
US9430470B2 (en) | Automated report service tracking system and method | |
US7185317B2 (en) | Logical data modeling and integrated application framework | |
US8543604B2 (en) | System and method for drafting documents using an outline table | |
CN100468396C (en) | Mapping architecture for arbitrary data models | |
US6671697B1 (en) | Rental property caching and searching system and process | |
US20080027830A1 (en) | System and method for creation and maintenance of a rich content or content-centric electronic catalog | |
US20030158897A1 (en) | Networked platform for creating and supporting communities | |
US20020059204A1 (en) | Distributed search system and method | |
US20140164163A1 (en) | Importable template | |
DE112004001031T5 (en) | Ordering procedure and system | |
WO2002057882A2 (en) | System and method for conducting electronic commerce | |
US20080228671A1 (en) | Facilitating Development of Documentation for Products Related to an Enterprise | |
US20060271523A1 (en) | Method for generating documents using layer-specific inheritance rules | |
US20080016048A1 (en) | Intelligent condition pruning for size minimization of dynamic, just in time tables | |
US7512690B2 (en) | System and method for transferring data between databases | |
CN101427273A (en) | System and method for e-catalog supplier portal | |
US20140007261A1 (en) | Business application search | |
US20080016047A1 (en) | System and method for creating and populating dynamic, just in time, database tables | |
CN111488164A (en) | Intelligent form system and code and interface generation method thereof |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
STCB | Information on status: application discontinuation |
Free format text: ABANDONED -- FAILURE TO RESPOND TO AN OFFICE ACTION |