{"id":675,"date":"2020-09-22T02:30:51","date_gmt":"2020-09-22T02:30:51","guid":{"rendered":"https:\/\/support.divominer.com\/en\/index.php\/docs\/divominer-user-manual-2\/overview\/upload-excel-file\/"},"modified":"2024-08-22T08:13:50","modified_gmt":"2024-08-22T08:13:50","slug":"upload-excel-file","status":"publish","type":"docs","link":"https:\/\/support.divominer.com\/en\/docs\/divominer-user-manual\/overview\/upload-excel-file\/","title":{"rendered":"Upload Excel file"},"content":{"rendered":"\n<p>1.&nbsp; Upload files: upload files from your local drive to the platform.<\/p>\n\n\n\n<p><span lang=\"EN-US\">Note: currently only support Excel files in .xlsx and csv format.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"321\" src=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1-1024x321.png\" alt=\"\" class=\"wp-image-9900\" srcset=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1-1024x321.png 1024w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1-300x94.png 300w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1-768x241.png 768w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1-50x16.png 50w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1-920x289.png 920w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1-600x188.png 600w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1-320x100.png 320w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_17-03-01-1.png 1322w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"406\" src=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52-1024x406.png\" alt=\"\" class=\"wp-image-9893\" srcset=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52-1024x406.png 1024w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52-300x119.png 300w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52-768x305.png 768w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52-50x20.png 50w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52-920x365.png 920w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52-600x238.png 600w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52-320x127.png 320w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2023\/11\/Snipaste_2023-11-02_15-39-52.png 1316w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>2. Preview data: Preview the uploaded data, click the drop-down arrow on the left of the data field name to set the field type of the data. There are four types of data fields: text, numeric, Boolean value, and date. After uploading the data, select the corresponding data field type according to the content. If the field content is text, select text as the field type; if it is a number, select numeric; if the content is true\/false, select Boolean value; if it is a date, select date. After defining each data field type, click \u201cNext\u201d to configure data.<\/p>\n\n\n\n<p><span lang=\"EN-US\">Note: For the data uploaded to the platform for the first time, a small red dot will appear in the upper right corner in each column. At this time, carefully check the field type of the data field. For the previously updated data, the corresponding data field type cannot be modified. To redefine the field type of the previously uploaded data, you need to delete the database and upload the corresponding data again.<\/span><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"403\" src=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-1024x403.png\" alt=\"\" class=\"wp-image-8287\" srcset=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-1024x403.png 1024w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-300x118.png 300w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-768x302.png 768w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-50x20.png 50w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-1536x604.png 1536w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-920x362.png 920w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-600x236.png 600w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1-320x126.png 320w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/4-1.png 1576w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>3. Setting Data: After selecting the data field type, configure the content to be displayed on the Coding page. The left side of the page is the format setting of the Coding page. Select data field for the corresponding content, and preview the content arrangement of the Coding page on the right side.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" width=\"1024\" height=\"207\" src=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-1024x207.png\" alt=\"\" class=\"wp-image-8288\" srcset=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-1024x207.png 1024w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-300x61.png 300w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-768x155.png 768w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-50x10.png 50w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-1536x311.png 1536w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-920x186.png 920w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-600x121.png 600w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1-320x65.png 320w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/5-1.png 1591w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"484\" src=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1-1024x484.png\" alt=\"\" class=\"wp-image-8289\" srcset=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1-1024x484.png 1024w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1-300x142.png 300w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1-768x363.png 768w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1-50x24.png 50w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1-920x435.png 920w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1-600x283.png 600w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1-320x151.png 320w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/6-1.png 1209w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>4. Submit data: After the data configuration, click \u201cSubmit data\u201d to submit the configured data to the platform.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" width=\"1024\" height=\"422\" src=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-1024x422.png\" alt=\"\" class=\"wp-image-8290\" srcset=\"https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-1024x422.png 1024w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-300x124.png 300w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-768x317.png 768w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-50x21.png 50w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-1536x634.png 1536w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-920x379.png 920w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-600x247.png 600w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1-320x132.png 320w, https:\/\/support.divominer.com\/en\/wp-content\/uploads\/2021\/11\/7-1.png 1588w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>5. After the data is submitted successfully, click \u201cReturn\u201d to go back to the Overview Page; or click \u201cView data\u201d to check the uploaded data on the Coding library page.<\/p>\n","protected":false},"featured_media":0,"parent":669,"menu_order":2,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"_links":{"self":[{"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/docs\/675"}],"collection":[{"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/comments?post=675"}],"version-history":[{"count":82,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/docs\/675\/revisions"}],"predecessor-version":[{"id":9901,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/docs\/675\/revisions\/9901"}],"up":[{"embeddable":true,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/docs\/669"}],"next":[{"title":"Upload PDF\/Picture","link":"https:\/\/support.divominer.com\/en\/docs\/divominer-user-manual\/overview\/upload-pdf-picture\/","href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/docs\/677"}],"prev":[{"title":"Upload data","link":"https:\/\/support.divominer.com\/en\/docs\/divominer-user-manual\/overview\/upload-data\/","href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/docs\/673"}],"wp:attachment":[{"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/media?parent=675"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/support.divominer.com\/en\/wp-json\/wp\/v2\/doc_tag?post=675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}