{"id":48965,"date":"2023-03-16T10:29:53","date_gmt":"2023-03-16T10:29:53","guid":{"rendered":"https:\/\/vger.datos.co.uk\/ClientKnowledgebase\/?p=48965"},"modified":"2025-02-25T15:46:45","modified_gmt":"2025-02-25T15:46:45","slug":"how-to-export-data-from-season-sql-database","status":"publish","type":"post","link":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/?p=48965","title":{"rendered":"How to Export Data from Season (SQL Database)"},"content":{"rendered":"<p>A follow on from how to create a season query, another way that you can export data from season it to use a SQL query or create a connection on excel that will export out key tables. This will only be compatible with your system if your database is running in SQL.<\/p>\n<p><span style=\"text-decoration: underline;\">Connection on Excel:<\/span><\/p>\n<p>From Excel you got to Data &gt; Get Data &gt; From Database&gt; From SQL Server Database<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48972 \" src=\"https:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2023\/03\/1-1.png\" alt=\"\" width=\"957\" height=\"553\" \/><\/p>\n<p>It will then prompt you to enter the server name you can get this from your IT team or someone from DATOS<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-48973  alignnone\" src=\"https:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2023\/03\/2-1.png\" alt=\"\" width=\"379\" height=\"247\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-48974 alignnone\" src=\"https:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2023\/03\/3-1.png\" alt=\"\" width=\"506\" height=\"187\" \/><\/p>\n<p>The next page will be the navigator, this will allow you to select the tables that you are looking to read data from, there is a list of the table names and what data they store from in the link below:<\/p>\n<ul>\n<li><strong>Custmast(300)\u00a0<\/strong>\u2013 Main Customer information table<\/li>\n<li><strong>Ordrhead(45)<\/strong>\u00a0\u2013 Sales Orders Header table<\/li>\n<li><strong>Ordrtrxs(46)<\/strong>\u00a0\u2013 Sales Orders detail table<\/li>\n<li><strong>Salefile(310)<\/strong>\u00a0\u2013 Posted Sales invoices header table<\/li>\n<li><strong>Saletrxs(315)<\/strong>\u00a0\u2013 Posted Sales invoices detail table<\/li>\n<li><strong>Cashhead(355)<\/strong>\u00a0\u2013 Receipts header table (Customer and nominal receipts)<\/li>\n<li><strong>Cashtrxs(360)<\/strong>\u00a0\u2013 Receipts detail table (Customer and nominal receipts)<\/li>\n<li><strong>Pricbook(90)<\/strong>\u00a0\u2013 Pricebook table<\/li>\n<li><strong>Creditor (400)<\/strong>\u00a0\u2013 Main Supplier information table<\/li>\n<li><strong>Stocporh(145)<\/strong>\u00a0\u2013 Purchase order header table<\/li>\n<li><strong>Stocpord(27)<\/strong>\u00a0\u2013 Purchase order detail table<\/li>\n<li><strong>Purchead(410)<\/strong>\u00a0\u2013 Purchase invoice header table<\/li>\n<li><strong>Purctrxs(415)<\/strong>\u00a0\u2013 Purchase invoice detail table<\/li>\n<li><strong>Paymhead(455)<\/strong>\u00a0\u2013 Payments header table (supplier and nominal payments)<\/li>\n<li><strong>Paymtrxs(460)<\/strong>\u00a0\u2013 Payments detail table (Supplier and nominal payments)<\/li>\n<li><strong>Custpart(205)<\/strong>\u00a0\u2013 Main Product information table<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-48975 \" src=\"https:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2023\/03\/4-1.png\" alt=\"\" width=\"788\" height=\"488\" \/><\/p>\n<p>Now that all your data is exported onto the spreadsheet it will be everything in that table so you can either filter your data down or add an SQL statement to limit what you want to see i.e., orders put on between a certain date range, how many orders are coming from what route etc. one setting that is important to set up is the refresh properties you will want to enable background refresh, fresh every 1 minute and also refresh upon opening the spread sheet if you are saving reports for future use. screenshots below show how this can be done<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-48976 alignleft\" src=\"https:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2023\/03\/5-1.png\" alt=\"\" width=\"460\" height=\"332\" \/><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-48977 alignnone\" src=\"https:\/\/vger.datos.co.uk\/ClientKnowledgebase\/wp-content\/uploads\/2023\/03\/6-1.png\" alt=\"\" width=\"328\" height=\"354\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A follow on from how to create a season query, another way that you can export data from season it to use a SQL query or create a connection on excel that will export out key tables. This will only be compatible with your system if your database is running in SQL. Connection on Excel: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5,14],"tags":[],"class_list":["post-48965","post","type-post","status-publish","format-standard","hentry","category-howtoguides","category-howtoexternalsoftware"],"_links":{"self":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/48965","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=48965"}],"version-history":[{"count":1,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/48965\/revisions"}],"predecessor-version":[{"id":49234,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=\/wp\/v2\/posts\/48965\/revisions\/49234"}],"wp:attachment":[{"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=48965"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=48965"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vger.datos.co.uk\/Clientknowledgebase\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=48965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}