{"id":10087,"date":"2023-12-04T06:16:38","date_gmt":"2023-12-04T06:16:38","guid":{"rendered":"https:\/\/support.divominer.com\/en\/?post_type=ht_kb&#038;p=10087"},"modified":"2023-12-04T08:05:26","modified_gmt":"2023-12-04T08:05:26","slug":"how-to-select-field-type-how-to-upload-documents-with-date-format","status":"publish","type":"ht_kb","link":"https:\/\/support.divominer.com\/en\/knowledge-base\/how-to-select-field-type-how-to-upload-documents-with-date-format\/","title":{"rendered":"How to select field type? How to upload documents with date format?"},"content":{"rendered":"\n<p>Users can confirm and modify the field types during the data uploading process. There are four types of fields:<\/p>\n\n\n\n<ul><li>Text: Text format as the content form<\/li><li>Numerical value: Content presented in numerical format, allowing for statistical analysis such as calculating averages, totals, and other numerical computations.<\/li><li>Boolean value: Content represented as true\/false.<\/li><li>Date: Content formatted as &#8220;date&#8221; in an Excel spreadsheet, which can be used for creating time-series charts and can be aggregated for statistical purposes, such as by year, month, or day.<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"265\" height=\"360\" src=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/12\/image-2.png\" alt=\"\" class=\"wp-image-10088\" srcset=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/12\/image-2.png 265w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/12\/image-2-221x300.png 221w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/12\/image-2-37x50.png 37w\" sizes=\"(max-width: 265px) 100vw, 265px\" \/><\/figure>\n\n\n\n<p>The DiVoMiner platform will automatically recognize the type of field in the uploaded document. For example, if a column of data in an Excel spreadsheet is formatted as &#8220;date&#8221;, after uploading to the platform, this column of data will be recognized as &#8220;date&#8221;, which can be used for timeline analysis.<\/p>\n\n\n\n<p><span class=\"has-inline-color has-vivid-cyan-blue-color\">TIPS: What if the field configuration is incorrect after uploading?<\/span><\/p>\n\n\n\n<p><span class=\"has-inline-color has-vivid-cyan-blue-color\">The field types of uploaded data cannot directly be modified. Since the database remembers the field types of previously uploaded data, they can be modified by re-uploading. If there are numerous field types that need to be modified, it is advisable to delete the database and set up a new one, then upload the data again.<\/span><\/p>\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":[9],"ht_kb_tag":[26],"_links":{"self":[{"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/ht_kb\/10087"}],"collection":[{"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/ht_kb"}],"about":[{"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/comments?post=10087"}],"version-history":[{"count":1,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/ht_kb\/10087\/revisions"}],"predecessor-version":[{"id":10089,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/ht_kb\/10087\/revisions\/10089"}],"wp:attachment":[{"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/media?parent=10087"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/ht_kb_category?post=10087"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/ht_kb_tag?post=10087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}