Classifications

• • G—PHYSICS
  • G06—COMPUTING OR CALCULATING; 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/02—Marketing; Price estimation or determination; Fundraising
• • H—ELECTRICITY
  • H04—ELECTRIC COMMUNICATION TECHNIQUE
  • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
  • H04L51/00—User-to-user messaging in packet-switching networks, transmitted according to store-and-forward or real-time protocols, e.g. e-mail

Definitions

• the present invention relates to the field of online survey solutions.
• the present invention relates more particularly to a technical process comprising different technical steps consisting in generating an electronic form, distributing and informing said form, transmitting data from said informed form and then automatically consolidating the data collected.
• the invention lies in the field of data transfers and is specifically intended to facilitate the establishment of computerized data cycles.
• a data cycle being defined by the request for information from a requesting user to recipient users, the supply of the information requested by said recipients, the return of the information provided to the requesting user, the consolidation and the provision of consolidated information to the requesting user.
• the data cycle is considered to have been successfully completed when the following conditions are met: All of the recipient users have provided the required information
• the consolidated data are consistent with the information system of the requesting user and can be entered there as is
• the entire cycle must be capable of being implemented by a business user, whose IT skills do not exceed knowledge of a basic office environment.
• none of the operations necessary for the implementation of the cycle should require the writing of any line of code.
• the requested information must be able to be supplied by the users requested without this requiring training on their part.
• the information provided by the users requested must be verified in real time.
• the implementation of the cycle must be non-intrusive. In particular, the cycle must not mobilize a server or any other device dedicated exclusively to the execution of one or more tasks necessary for its implementation.
• the implementation of the cycle as well as its update must be able to be carried out in extremely short time ( ⁇ 1 day / man for a user whose computer skills do not exceed the knowledge of a basic office environment) in order that the information collected reflects as closely as possible the situation whose analysis is the subject of the cycle.
• the present invention relates to a method allowing the implementation of data cycles in accordance with the prerequisites given above.
• the problem set out above is today mainly dealt with by one or other of the 3 means set out below:
• Web form The Web is a good way to provide requested users with input forms.
• the HTML language natively assigns a certain number of instructions for this use and the major advantage of this solution is a deployment as a real thin client: no application is installed on the workstation of the users requested.
• HTML forms as a data cycle support reveals several drawbacks.
• HTML language content language
• a programming language is then required (Javascript is frequently used) for this task, but the programming of information transmission directives is not within the reach of an office user.
• HTML technology does not easily make it possible to carry out validity and consistency checks in real time on the data entered by the users requested.
• Such controls can possibly be introduced by programming in an appropriate language but in this case, a verification of exhaustive consistency across all input sessions requires a great deal of information exchange with the data server, resulting in disabling bandwidth consumption
• Distributed architecture By “Distributed architecture”, we mean any database supplied in particular by input interfaces distributed to the users requested. (It also appears, according to this acceptance, that Web forms are a special case of distributed architecture.)
• the advantage of this configuration lies in the fact that the database whose accesses are distributed can be an integral part of the company's information system (IS) and that the data thus collected can be immediately made available to classical information processing processes (decision-making tools in particular)
• IS company's information system
• the distribution of access requires the installation of an input software component at each of the users requested, this installation requiring a dedicated skill and specific training so that the requested user can perform their input task.
• Shared files are also a frequently used means of creating data cycles.
• the requesting user creates a document with fields to fill in and then distributes this document to the users requested. It is their responsibility to complete the document they have received and then return it to the requesting user, who then gathers the information thus collected.
• the requesting user most often creates a document in a standard office format, thus guaranteeing that the users requested can use it without installing any additional component and a priori without prior training.
• the prior art also knows, from PCT patent application WO 02/25486 (Interquest), a method for collecting and processing information.
• the invention presented in this PCT application relates to a method of collecting information from users of terminals connected to a data network, which consists in using the terminals via the network, and in submitting to the users of the terminals one or more questions from the list of questions.
• the degree of disturbance affecting users can be kept as low as possible by defining a maximum number of questions to be answered by a single user.
• For each question at least one statistical characteristic is determined on the basis of the responses received, when one or more responses to a given question are obtained.
• the selection of questions may be based at least in part on said characteristic.
• the present invention provides a software solution that meets the requirements of the context of using data cycles. It consists of four software modules, each serving one of the stages of a cycle: • Creation of the interrogation document; • Determination of the sub-populations of recipients, personalization of the interrogation document according to the recipients in transmission of this document to the recipients concerned; • creation of the desired data using said document; • consolidation and provision of the data collected.
• the present invention relates, in its most general sense, to an electronic survey method comprising • a first step of generating an electronic form; • a step of distributing said electronic form on a plurality of recipient devices; • a step of informing said form, on each of said destination equipment; • a step of transmitting data from said form filled in from said recipient equipment to a mail server in the form of an electronic message according to the SMTP protocol; and • a step of automatic consolidation of said data collected on said messaging server by collection equipment.
• the method further includes a step of producing a file in .csv format.
• the method further comprises a step of sending an acknowledgment of receipt to said recipient equipment.
• the method further comprises a step of statistical processing.
• the method comprises an additional step of sending data from said statistical processing to said recipient equipment.
• the method comprises an additional campaign management step consisting in monitoring the progress of the survey and possibly in issue reminders to said recipients.
• the method further includes a compression step.
• said compression applies to said form.
• said compression applies to the data collected.
• the method further includes a step of encrypting the collected data.
• the step of generating an electronic form includes the use of filters allowing personalization according to characteristic data of the recipient.
• the present invention also relates to an online survey system for implementing the method comprising at least means for generating electronic forms and means for transmitting data.
• the electronic survey essentially consists of: • developing a questionnaire; • informing said questionnaire by a plurality of people; • automatic processing of responses.
• the first phase of the process according to the invention consists in creating a questionnaire.
• the questionnaire being in an electronic format, it is easy to add to it, by means of an adapted interface, hypertext links, buttons and additional fields ... It is essential, during this phase to provide an email address electronic system that will collect the responses.
• the questionnaire is then completed by the respondents.
• the filling of said questionnaire is carried out using downloaded client software.
• a click sends the formatted responses in the form of a digital file to the predetermined email address.
• This file can advantageously be compressed and / or encrypted before sending.
• an additional module installed on a server, examines the emails intended for said email address responsible for collecting the responses.
• the responses are processed, consolidated and results files are produced.
• Personalized emails can be sent to people who answered.
• statistical or reporting tools can be used in combination before the data is consolidated.
• the interrogation document is a file intended to be read by an appropriate executable on the station of the recipient to whom it is transmitted and on which it organizes the collection of the data that the sender wishes to obtain.
• This data can be of any type and must be able to be collected by any means that the recipient's workstation can understand. In a nonlimiting manner, it may in particular be data entered on the part of the user, data present on the user's workstation or in the environment accessible to him or data describing the workstation of the user or the environment accessible to him.
• the implementation of the module for creating the interrogation document will call on the one hand for an object structuring defining the attributes of the document and the structure of the data storage before referral for consolidation and on the other hand has object classes defining the interaction components with the recipient's station.
• object classes are mainly divided into 2 categories: o
• objects whose role is to collect data In order to facilitate the implementation of cycles, MCDI will make extensive use of the usual widgets defined by the operating system of the workstation on which it is installed, as well as advanced support for the most frequent file formats, optionally.
• the MCDI directly calls on the database drivers present on the computer on which it is installed, via high-level interfaces, ADO type.
• the MCDI also integrates a certain number of application control interfaces so as to allow the integration into the document of files intended to be used dynamically, in particular for interacting with the tools associated with the data intended to be collected. on the recipient's workstation.
• These interfaces which can in particular be of the COM or OLE type, provide intuitive access for the recipient to the local applications managing said files, said applications appearing to the user as integrated into the document, with all or part of their properties. and available functions.
• MCDI allows the user to manage the granularity of the data collected by the various components used in the document.
• each unitary data of each of the components is extracted by disregarding its collection context.
• a given response from a given user is always represented by a line in the final CSV file, regardless of the structure of the document.
• plans for consolidation by sets, in which data from objects with identical granularity are grouped together.
• the MCDI allows the designer user to create a fully personalized consolidation model ex nihilo.
• the query document is then created.
• This document is mainly intended to be transmitted by email, two imperatives must be reconciled: o
• the document must not be able to be altered by the mail servers.
• the messaging servers can, depending on the case, receive a specific configuration affecting the messages they convey.
• the interrogation document is in the form of a binary file itself composed of 2 stream files containing the two object classes described above: document structure and dependencies on the one hand, data objects on the other.
• the document must be as light as possible so as not to be pushed back by the mail servers, which are often limited in volume. For this purpose, the final document is compressed, which also has the effect of encrypting the resulting file.
• segmentation In order to send each recipient a document related to the information they have, it is necessary to personalize the query document according to one (or more) segmentation (s) that we will call “sub-populations" ". Said segmentations are frequently contained in the company's information system, as are the coordinates of the recipients of the document, frequently found in an LDAP-type directory.
• the first task therefore consists in bringing these two pieces of information together. To do this, a certain number of requests are placed on the aforementioned systems. So that the demand on the servers hosting these systems is minimal, the information thus collected is gathered in a specific directory which can be refreshed field by field at the request of the user.
• An interrogation cycle combines three elements: o An interrogation document created by the MCDI o A parameter file specifying on the one hand, the personalizations assigned to the interrogation document according to the sub-populations and on the other hand, information inherent to the course of the cycle such as its expected duration, the organization of recovery phases, the visualization of the degree of progress, etc. This file behaves like a script, allowing the re-execution of an entire cycle on refreshed parameters. o A set of sub-populations defined in the directory. The selection criteria are specified either absolutely (query on fixed parameters) or relative so as to envisage the automation of the selection process and these criteria are saved in the parameter file.
• the user can browse it and perform the requested data supply operations. Some of these operations are manual (entry, selection %) others are automatic, either in that they arise from the entry operations, or in that they are carried out without the knowledge of the user ( system information requests, data embedded in the document, etc.)
• the user can, at any time, save the state of his entry.
• a file is then produced containing the structure of the responses: the data supplied are virtually attached to the class identifiers of the objects of the interrogation document which contained them.
• the responses provided by the user can be stored on his workstation as a base. In this case, an additional interface is available, allowing you to browse this database, recall or delete all or part of the responses stored there and export this database to an ASCII data file.
• the data creation module performs all the validation checks specified by the MCDI.
• the execution of the control procedures can take place at three times: o When entering (by analyzing the data entered, selections made ...) o When the entry in a given object can only be checked once that - done, the control takes place when the object loses focus o During the request for data transmission (overall consistency, completeness)
• the email is sent transparently and the destination address is never exposed to the user.
• a configuration is made during installation, indicating the protocol to be used.
• Operating system environment variables provide default messaging settings that can be changed by the user. Three levels of interaction with messaging are possible: o The very high level protocols provided by the OS, MAPI type. In this case, it is verified that the messaging support software is activated, on the one hand so that the sending is transparent to the user and on the other hand hides the destination address. o Intermediate level protocols provided by messaging, VIM type o Direct addressing of an SMTP server
• the user is also asked for an identifier. This, compared to one or more environment variables, will allow the responses to be discriminated during consolidation.
• a procedure for sending data by file is also available if the connection to the mail service fails.
• the purpose of this operation is to supply data files containing the responses provided by the users. These files are created in .CSV format in order to be completely standard and usable in any context
• This module performs the following tasks: 1) Searching in the environment variables for information relating to the cycles in progress 2) For each of the cycles, retrieving the information then connecting to the specified mail server. The connection is always made via the POP protocol 3) For each of the mails present on the mail server, verification of the fact that this mail does indeed contain an authentic data file as an attachment 4) Possibly, deletion of unauthenticated mails 5) For each authenticated email, download of the attached data file, decompression, structural and logical verification, possibly request for arbitration by the user of the consolidation module, addition to the data of information relating to the progress of the cycle then addition of the data to the appropriate data file. If the file does not exist, it is created at this time. 6) Possibly, deletion of the processed mails.

Landscapes

• Business, Economics & Management (AREA)
• Strategic Management (AREA)
• Engineering & Computer Science (AREA)
• Accounting & Taxation (AREA)
• Development Economics (AREA)
• Finance (AREA)
• Economics (AREA)
• Game Theory and Decision Science (AREA)
• Entrepreneurship & Innovation (AREA)
• Marketing (AREA)
• Physics & Mathematics (AREA)
• General Business, Economics & Management (AREA)
• General Physics & Mathematics (AREA)
• Theoretical Computer Science (AREA)
• Information Transfer Between Computers (AREA)
• Data Exchanges In Wide-Area Networks (AREA)

Applications Claiming Priority (2)

Publications (1)

Family

ID=34307164

Family Applications (1)

Country Status (3)

Families Citing this family (2)

Family Cites Families (3)

• 2003
  • 2003-09-25 FR FR0311255A patent/FR2860318A1/fr not_active Withdrawn
• 2004
  • 2004-09-24 EP EP04816236A patent/EP1676233A2/de not_active Ceased
  • 2004-09-24 WO PCT/FR2004/050461 patent/WO2005031620A2/fr not_active Ceased

Non-Patent Citations (1)

Also Published As

Similar Documents

Legal Events