{"id":721,"date":"2020-09-22T02:57:51","date_gmt":"2020-09-22T02:57:51","guid":{"rendered":"https:\/\/support.divominer.cn\/en\/knowledge-base\/how-to-build-a-database-upload-data\/"},"modified":"2021-09-01T06:14:13","modified_gmt":"2021-09-01T06:14:13","slug":"how-to-build-a-database-upload-data","status":"publish","type":"ht_kb","link":"https:\/\/support.divominer.cn\/en\/knowledge-base\/how-to-build-a-database-upload-data\/","title":{"rendered":"How to build a database? \u2013upload data"},"content":{"rendered":"\n

After the Subject is created, you will automatically enter the [Data Management]-[Overview] page. Here you can see the overall data coding in each database, such as the number of samples in the coding pool, recycle bin, number of samples that have been coded, current Subject\u2019s data capacity and usage, file capacity and usage, etc. Multiple databases can be built in one Subject, allowing different types of data to be uploaded. By default, there\u2019s one database for a Subject.<\/span><\/p>\n\n\n\n

The following steps show how to build up two databases with different types of data from different sources:<\/span><\/p>\n\n\n\n

Step 1: create databases. If you want to create two databases, one with \u201cnews\u201d articles, and another one with \u201cWeibo\u201d posts, first change the name of the default database into \u201cNews Database.\u201d<\/span><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Then click [+Add Database] and enter the name \u201cWeibo Database.\u201d<\/span><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 2: After the databases creation, click [Upload Data] in the \u201cNews Database\u201d window and select the data file to be uploaded.<\/span><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Currently, it supports data types such as Excel, PDF\/picture, third-party data sources,video and audio. Select the file format, then click or drag the file from your local drive to the data upload area.<\/span><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Note: EXCEL files need to be in .xlsx format, and the maximum capacity of a single file is 200MB.<\/span><\/p>\n\n\n\n

After selecting the file to be uploaded, you can preview the data and define the field type of each column of data. There are four types of data fields: text, numeric, Boolean value, and date.<\/span><\/p>\n\n\n\n

  • Text: textual data, generally include English characters, Chinese characters, Pinyin symbols, etc. Arabic numerals can also be used as text data;<\/li>
  • Numeric: data measured on a numerical scale;<\/li>
  • Boolean value: also known as logical data type, is composed of binary digits: 0 and 1, namely True\/False;<\/li>
  • Date: data in the format of date and time;<\/li><\/ul>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    TIPS: A red dot marked in the data field means the data is uploaded to the platform for the first time, and the field name can be modified. The data fields with previously uploaded data cannot be modified. If you need to modify the field type of the previously uploaded data, you need to delete the database and upload the data files again. If you are uploading the data for the second time, you can convert the data field into an existing data field on the platform.<\/span><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    In the [Data Configuration] page, you can set up the Coding Page style for data to be displayed, which is the data presentation of manual coding on the [Coding] page and data preview in the [Coding Pool]. The Coding Page format is customizable for the user. Drag the \u201cTitle\u201d variable to the [Title] field, the \u201cDate\u201d variable to the [Information] field, and the \u201cText\u201d (e.g., the body of a news article) variable to the [Text] field, and click [Submit Data] to complete data upload.<\/span><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n
    \"\"<\/figure>\n\n\n\n

    TIPS: The machine coding will only be performed on the data in the [Title] and [Text] fields. User can decide which data variables to be put into different data fields based on their needs.<\/span><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    Step 3: Go to the [Coding Pool] to see the uploaded data and check the number of uploaded data samples. Click on a random data sample to check the data display.<\/span><\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    If you need to clean data, you can [Remove] irrelevant or junk data in the [Coding Pool].<\/span><\/p>\n\n\n\n

    Step 4: If you need to modify the data display style in different pages later (or change the data range for machine coding), go to the [Data Management]-[Overview], and click [More Operations]- [Display Settings] of the corresponding database to perform the modification.<\/span><\/p>\n\n\n\n

    \"\"<\/figure>\n","protected":false},"author":2,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"ht_kb_category":[5],"ht_kb_tag":[24],"_links":{"self":[{"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/ht_kb\/721"}],"collection":[{"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/comments?post=721"}],"version-history":[{"count":144,"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/ht_kb\/721\/revisions"}],"predecessor-version":[{"id":8556,"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/ht_kb\/721\/revisions\/8556"}],"wp:attachment":[{"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/media?parent=721"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/ht_kb_category?post=721"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.divominer.cn\/en\/wp-json\/wp\/v2\/ht_kb_tag?post=721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}