31 results about "Comma-Separated Values" patented technology

Flat file formats are used widely in Enterprise Application Integration (EAI) and Business to Business (B2B) solutions. The formats describe the layout of the meaningful information within the data stream in such a way so that the parsing of that stream and extraction of the information can be automated. An example of a flat file format is a Comma Separated Values (CSV) format, where units of data are delimited between each other by using comma character. Another example is a positional format where the units of data occupy certain positions relative to each other within the data stream. The common task that is performed very often is conversion of the documents from various flat file formats into an XML representations and vise versa. The algorithm of iterative definition of the flat file structure from document instance described herein simplifies the process of defining the conversion rules for the flat file formats. These rules are used by components that perform conversion from flat file format to XML and back. The algorithm allows definition of those rules by working with the flat file document instance and iteratively creating an XML schema from that instance.

The invention discloses a packing method based on a line storage database engine, which comprises a line storage database, and following operations are carried out based on the line database: creating a compress table, specifying a corresponding compressing level, and importing data files with CSV (Comma Separated Value) format into the created compress table. The method is characterized in that: the compress table is a common data table showed externally for supporting general DML / DDL (Data Manipulation Language / Data Definition Language) operation; the compress table comprises a master HOT data segment and a slave LOB large object segment realized internally, wherein the master HOT segment is used for storing internally defined attribute lines, and the slave LOB segment is used for storing a compression method control structure and compressed data content; the compress table is used for supporting various query languages, and when in query, even though all fields in the line need to be read into memory, the related line data only needs to be decompressed and queried; the compress table is used for supporting update operation, and only decompressing updated lines when in update; and the compress table is used for supporting speedy deletion, only delete mark is made, and when no record is in a slave line, a master line is automatically deleted; and the compress table is deleted. According to the invention, through a line storage database technology, without changing a storage engine physical result, the technology of compression and storage according to line is realized, and the effect of high compression ratio of the line storage database is achieved.

The invention provides a method for importing a csv (Comma Separated Value) question bank to an interactive teaching platform. The method comprises the following steps of: at first, using a TstringList to open a question bank file with a csv format; scanning a first line of the question bank file; judging whether the first line of the question bank file accords with a format of the interactive teaching platform or not; putting data of the csv file into a configuration window of the csv question bank; adjusting the first line of the question bank file which does not accord with the format of the interactive teaching platform, so that the first line of the question bank file accords with the format of the interactive teaching platform; gradually reading the configuration window of the csv question bank line by line until all lines in the configuration window of the csv question bank are read, and a question type is completed to judge; and importing the entire file of the csv question bank in. With the adoption of the method provided by the invention, a teacher does not need to edit the question bank file with the csv format for the second time when the interactive teaching platform is used, so that the direct importing can be realized.

The invention relates to a logic test method and device suitable for a reactor protection system. The logic test method comprises a construction step, a call step, an operation step and a judgment step, wherein the construction step is as follows: constructing test programs and a truth table based on a comma separated values (CSV) format, wherein the truth table comprises the logic diagram index information of the reactor protection system, an input variable, an output variable, the voluation information of the input variable, the input variable of the output variable, and an execution time; the call step is as follows: reading the logic diagram index information, calling the test programs corresponding to the logic diagram index information; the operation step is as follows: reading the input variable and carrying out voluation on the input variable in accordance with the voluation information of the input variable, and carrying out logic operation in accordance with the called test program and the execution time so as to obtain the output value of the output variable; and the judgment step is as follows: judging whether the output value of the output variable is consistent with the expected value, if yes, outputting correct result information, and if no, outputting wrong result information. In the logic test method, the test is carried out by constructing the truth table based on the CSV format and the test program, thus being convenient for modification and regulation, and avoiding human errors.

The invention discloses an HTTP (Hyper Text Transport Protocol) retrieval method for a CSV (Comma-Separated Values) fragment marked by a URI (Uniform Resource Identifier). The HTTP retrieval method comprises the following steps that: a client resolves a fragment URI and obtains a main resource URI and a CSV fragment identifier; the client sends the selection mode and the selection range of the CSV fragment to a server; the server extracts the CSV fragment according to the selection mode and the selection range of the CSV fragment; the server returns the extracted CSV fragment to the client; and the client obtains the CSV fragment and displays or stores the CSV fragment. The HTTP retrieval method for the CSV fragment marked by the URI disclosed by the invention has the advantages that on one hand, the expansion on a current HTTP / 1.1 protocol is not needed; and on the other hand, the RFC 7111 international standard 'URI Fragment Identifiers for the Text / CSV Media Type' is supported, and compared with a conventional technical scheme of extracting the fragment after the client downloads a complete CSV file, the method provided by the invention has the advantages that the network bandwidth can be greatly reduced, and the communication time delay is reduced.

The invention provides a method for importing a csv (Comma Separated Value) question bank to an interactive teaching platform. The method comprises the following steps of: at first, using a TstringList to open a question bank file with a csv format; scanning a first line of the question bank file; judging whether the first line of the question bank file accords with a format of the interactive teaching platform or not; putting data of the csv file into a configuration window of the csv question bank; adjusting the first line of the question bank file which does not accord with the format of the interactive teaching platform, so that the first line of the question bank file accords with the format of the interactive teaching platform; gradually reading the configuration window of the csv question bank line by line until all lines in the configuration window of the csv question bank are read, and a question type is completed to judge; and importing the entire file of the csv question bank in. With the adoption of the method provided by the invention, a teacher does not need to edit the question bank file with the csv format for the second time when the interactive teaching platform is used, so that the direct importing can be realized.

PURPOSE: A method for managing an address book by using an LMS(Long Message Service) in a mobile communication terminal is provided to use an LMS which employs a CSV(Comma Separated Value) format, and to wirelessly transmit an address book regardless of a place, thereby updating and restoring the address book of a user terminal. CONSTITUTION: A system generates a long message including CSV-type address book information. The system transmits the long message including the address book information to a message center, and stores the long message in an inner backup server. The system requests the long message stored in the backup server to be transmitted, and receives the long message. The system separates the address book information from the received long message, and parses the address book information. The system stores the parsed address book information according to an address book type.

The invention discloses a data acquisition method and device, relates to the technical field of internet, and aims at solving the problem that the process of acquiring data in CSV files is not reusable in the prior art. The method comprises the following steps of: receiving metadata information corresponding to a business requirement, wherein the metadata information comprises an attribute name, a row identifier and a format type corresponding to different pieces of attribute information, and the row identifier is an identifier of a row in a Comma-separated values CSV file; establishing a mapping table according to the metadata information, wherein the mapping table records a corresponding relationship among the attribute name, the row identifier and the format type; extracting data corresponding to the row identifier from the CSV file according to the mapping table; converting the extracted data into a format type corresponding to the row identifier according to the mapping table; and binding the format-converted data with the attribute name corresponding to the row identifier. The data acquisition method and device are suitable for being applied to the process of extracting the data in the CSV file.

The embodiment of the present invention provides a data import method, device and electronic equipment, which are applied in the field of multimedia technology. The method includes: writing the data in each data source in the Hadoop cluster into the Hadoop distributed Each comma-separated value in a CSV file for the file system HDFS. Synchronize HDFS from the Hadoop cluster to the Druid cluster through distcp. For each CSV file, according to the attribute information of the CSV file, generate a JSON configuration file. According to the JSON configuration file, initiate a request to build an index task through the CURL command, so that Druid The cluster imports the written data in the CSV file into the Druid cluster. The invention can improve the efficiency of data import.

The invention provides a character processing method and device. The method comprises the steps of: reading a first character string stored in a data source file in an EXCEL format; substituting the first character string according to a preset character string substituting relation, and storing a second substituted character string in a blank EXCEL file; and converting the EXCEL file for storing the second character string into a comma separated value CSV formatted file. By employing the character processing method and device, the error rate can be lowered, and the utilization efficiency can be increased.

The invention discloses a method for converting CSV (Comma-Separated Values) data labeled by metadata to RDF (Resource Description Framework) data. The method comprises the following steps: reading and analyzing a CSV file, obtaining tabular data, and storing the tabular data into a memory data structure; reading and analyzing a metadata description file, obtaining metadata, and storing the metadata into the memory data structure; combining with the obtained tabular data and metadata, generating an RDF triple set, and storing the RDF triple set into the memory data structure; and outputting the generated RDF triple set as an RDF data file of a Turtle grammatical format. The method for converting the data format converts the CSV data labeled by a metadata model vocabulary defined by a W3C (World Wide Web Consortium) technical specification <Web Tubular Data and Metadata Model> into the semantically equivalent RDF data, so that a traditional software tool can be utilized to conveniently publish the RDF data obtained by conversion onto an associated data network for various semantic web applications to share, reuse and process the tubular data from the CSV file, and therefore, a great quantity of large-coverage CSV data can perform the maximum potential.