摘要:
Systems and methods are described for performing a schema-based data transfer between a database associated with a data-based application and a document associated with a document application. In one implementation, connection information established during an initial schema-based data transfer between the database and the document is maintained in association with the document. This connection information is then used to facilitate subsequent updating of the document based on information currently residing in the database as well as subsequent updating of the database based on information currently residing in the document in a manner that is highly automated and easy to use.
摘要:
A method and system are provided for converting a hierarchical data structure into a flat data structure based on a schema. The format of the hierarchical data structure may be XML. A hierarchical data structure conforming to a schema is loaded into an application program. The data structure includes elements and attributes linked together in a parent-child relationship. The schema defines the hierarchical relationships between the elements and attributes in the hierarchical data structure. After the hierarchical data structure conforming to the schema has been loaded, a plurality of layout rules is applied to the hierarchical data based on the schema to create a flat data structure. The layout rules determine how the hierarchical data will be inserted in the flat data structure. The layout rules may be applied by identifying properties in the schema which identify occurrence requirements for elements defined in the schema. After the layout rules have been applied to the hierarchical data, the hierarchical data is rendered into a spreadsheet by inserting the data in rows and columns.
摘要:
Embodiments are provided to merge, manage, create, and reuse database parts in a computer system. Database parts may include database tables, datatypes, field combinations or entire databases. A selection of a database part is received by a database software application executing on a computer system. The application may be configured to check for metadata associated with the database part to identify an action property. If, after checking for the metadata, a merge action property is identified, then the application may check for a metadata property associated with a database table. If a merge action associated with the database table is identified, then the application may merge the database part with the database table in the database. The application may also be configured to generate a user interface for creating database parts using database tables and for creating a database part by saving a database.
摘要:
Systems and methods are described for using templates associated with a document application to facilitate schema-based data transfers into and out of a database associated with a database application. Such templates may be made available to a user so that the user can easily export various data entities out of the database for display, editing, or report generation as well as to import new or edited data entities into the database. The templates may include fixed or user-customizable reports that are populated with data entities exported from the database and/or that present data and graphics derived from such data entities. The templates may also be created during an initial data transfer between a first document and the database and then saved for use in performing subsequent data transfers between other documents and the database.
摘要:
Extensible markup language data in an extensible markup language (such as XML) is associated with a schema file for defining data types and data type definitions for applying data to the document. A map is prepared that relates that any extensible markup data applied to the document back to corresponding elements or attributes defined in the associated schema file. When the document is imported into a spreadsheet application grid, the data map is parsed to find XPATHs which determine the location, data types and user data for each cell or list object in the document related to the schema file. The cells and lists are populated with the extensible markup data and user data, and rendered according to formatting dictated by the extensible markup data applied to the document. The document may be exported such that the extensible markup data is maintained for subsequent import and use.
摘要:
Embodiments are provided for rendering markup language data representing a macro as macro objects in a graphical user interface on a display device and for converting macro objects to markup language data. In one embodiment, markup language data representing the macro from a data source may be translated into macro objects for display in the graphical user interface in response to receiving a paste command in an application program. The macro objects visually represent the macro. The application program may automatically convert the markup language data into the macro objects. The macro objects are then automatically rendered in the graphical user interface. In another embodiment, a selection of macro objects displayed in the graphical user interface may be received via a copy command in the application program. In response to receiving the copy command, the application program may automatically convert the selected macro objects into markup language data.
摘要:
A user interface is provided that allows users to create queries interactively. The user interface operates by creating a source query (or, for example, SQL commands) for the user while they select fields from a data source. This provides users with an alternative to using conventional designers, wizards, or other tools to manually generate a query.
摘要:
A user interface (UI) includes floating action buttons. Respective hot zones are established for associated respective UI elements. When a focus is targeting (e.g., located at) a given hot zone, one or more floating action buttons that are associated therewith are presented as part of the UI. Activation of a particular action button of the one or more floating action buttons causes an action corresponding to the particular action button to be implemented. In an example implementation, the actions available through the one or more floating action buttons may be context-sensitive such that the actions thereof are tailored to the type of item corresponding to the UI element (e.g., an icon, a graphical element, a text portion, a screen area, etc.).
摘要:
An improved user interface is provided for displaying selectable software functionality controls of a database application. When a task-based functionality tab is selected from the user interface, selectable functionality controls provided by the associated database application for performing aspects of a task related to the selected tab are presented in a ribbon-shaped user interface above a workspace in which a user is entering or editing data. Upon selection of a different task-based functionality tab, the presentation of functionality controls associated with the first task is removed, and selectable functionality controls associated with the second selected task-based functionality tab are presented in the user interface. The selectable functionality controls presented in the user interface are grouped into logical groupings for more efficient utilization. An extensibility model is provided for allowing users to develop and use customized user interfaces and to allow utilization of legacy user interfaces.
摘要:
Where a label for an item to be represented by an icon is customized, the icon is generated to dynamically display all of the label. Thus, at some point, the entire label is displayed, even though only a portion of the label is eventually displayed in the icon.