{"id":681,"date":"2019-01-09T14:28:07","date_gmt":"2019-01-09T14:28:07","guid":{"rendered":"https:\/\/pir2.tk\/?page_id=681"},"modified":"2022-03-26T01:37:18","modified_gmt":"2022-03-26T01:37:18","slug":"3dpdf-data-extract-to-csv","status":"publish","type":"page","link":"http:\/\/demo.max-drake.cc\/index.php\/3dpdf-data-extract-to-csv\/","title":{"rendered":"3DPDF data extract to CSV"},"content":{"rendered":"<p><span style=\"color: #ff0000;\">This is a test page and only upload is <strong>live.<\/strong><br \/>\n<\/span><\/p>\n<p><em>This was a test for an automated Process using UiPath to create a remote scheduled Robot that would open a 3D PDF file, extract parameter data from that file and save it to a CSV file so that it could be used in an Excel Macro sheet. <\/em><\/p>\n<p><em>The second part of the process would have been to import the CSV file and filter the data and export Room information such as Wall, Floor &amp; Ceiling Finishes and substrate details as well as quantities of each.<\/em><\/p>\n<p><em>It was intially based on this <strong>post.<\/strong><\/em><\/p>\n<h5>To extract all parameters in 3D PDF file to a CSV file please click on<em><a href=\"https:\/\/docs.google.com\/forms\/d\/e\/1FAIpQLSefpKYgTObepd2_qRtpwOFHju0M9hDf5a18tpJ3i3X8hZSGhQ\/viewform?usp=sf_link\"><strong> link<\/strong><\/a><\/em>\u00a0 to upload your 3dPDF file.<\/h5>\n<p>Note: File must be a<strong> .PDF<\/strong> type otherwise it will not upload.<\/p>\n<p>You also need to put in your Name &amp; Email address. This is required so that:<\/p>\n<ol>\n<li>You get an email confirming you have uploaded the file<\/li>\n<li><span style=\"color: #ff0000;\"><em>A link is sent where you can access the .CSV file [NOT WORKING]<br \/>\n<\/em><\/span><\/li>\n<\/ol>\n<p><span style=\"color: #ff0000;\"><em><strong>[Not functioning]\u00a0<\/strong> the automated robot only runs every hour, on the hour (Auckland Time), so there may be a delay in the response email.<\/em><\/span><\/p>\n<p>(Note , because this Google Form asks for email address it will not let you embed it into a web page. That is why there is a Link to the form, not an embedded form)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a test page and only upload is live. This was a test for an automated Process using UiPath to create a remote scheduled Robot that would open a 3D PDF file, extract parameter data from that file and save it to a CSV file so that it could be used in an Excel [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"templates\/template-full-width.php","meta":{"footnotes":""},"featured_image_src":null,"featured_image_src_square":null,"_links":{"self":[{"href":"http:\/\/demo.max-drake.cc\/index.php\/wp-json\/wp\/v2\/pages\/681"}],"collection":[{"href":"http:\/\/demo.max-drake.cc\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/demo.max-drake.cc\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/demo.max-drake.cc\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/demo.max-drake.cc\/index.php\/wp-json\/wp\/v2\/comments?post=681"}],"version-history":[{"count":6,"href":"http:\/\/demo.max-drake.cc\/index.php\/wp-json\/wp\/v2\/pages\/681\/revisions"}],"predecessor-version":[{"id":693,"href":"http:\/\/demo.max-drake.cc\/index.php\/wp-json\/wp\/v2\/pages\/681\/revisions\/693"}],"wp:attachment":[{"href":"http:\/\/demo.max-drake.cc\/index.php\/wp-json\/wp\/v2\/media?parent=681"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}