{"id":155,"date":"2007-09-13T07:07:32","date_gmt":"2007-09-13T12:07:32","guid":{"rendered":"http:\/\/www.teamdesk.net\/blog\/2007\/09\/data-is-a-const\/"},"modified":"2007-09-13T07:07:32","modified_gmt":"2007-09-13T12:07:32","slug":"data-is-a-const","status":"publish","type":"post","link":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/","title":{"rendered":"Using Advantages of TeamDesk Import"},"content":{"rendered":"<p>To save your time and facilitate your effort on data processing, TeamDesk is enhanced with the <a href=\"http:\/\/www.teamdesk.net\/help\/index.htm?tableimport\">import\/export features<\/a>. Pretty standard solution for an application of this type, one may say. Yet, TeamDesk uses these features to solve a variety of tasks and helps to lighten your work appreciably.<\/p>\n<p><!--more--><\/p>\n<p>The most amazing about importing data with <a href=\"http:\/\/www.teamdesk.net\/\">TeamDesk<\/a> is that there\u2019s no need to spend hours and set some specific format for the info you need to import. If you are not sure about the correct data format, it is possible to import information as simple text and change it to the required type later on. Being very flexible, the system also allows you to create new columns during import \u2013 say if your TeamDesk table has just a couple of fields, you can extend the application table by simply importing a file with the necessary columns.<\/p>\n<p>If you already tried to import anything with TeamDesk, you couldn\u2019t but notice that the whole process takes just a couple of mouse clicks: you just need to mark whether the first row in your file contains column names or not. The rest is done by the system: it analyzes data and matches the table columns with imported fields. If you import dates or numerals, even your local regional settings will be applied to the TeamDesk table.<\/p>\n<p>Another great advantage is the ability to update your table contents by importing a file. The solution is based on a key column that is actually a table field used to identify records in the table (a good example of a key column is the ID field). <\/p>\n<p>In brief, it works in the following way:<\/p>\n<ul>\n<li>Firstly, you perform the import of initial data into the TeamDesk application (at this stage you simply fill out your table with data).<\/li>\n<\/ul>\n<ul>\n<li>When there arises a need to change some information in the table, it is not necessary to perform any actions online. Export the table data into a file and modify it on your computer.<\/li>\n<\/ul>\n<ul>\n<li>After this you may import the file once again: the system will compare the file and application data basing on the key column. Records with the same data in the key field will be considered one and the same record, and info in the online table will be overwritten by imported details. In case there is no match in the TeamDesk table, the system will import file records as new ones.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>To save your time and facilitate your effort on data processing, TeamDesk is enhanced with the import\/ export features. Pretty standard solution for an application of this type, one may say. Yet, TeamDesk uses these features to solve a variety of tasks and helps to lighten your work appreciably.<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-155","post","type-post","status-publish","format-standard","hentry","category-tips-tricks"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Using Advantages of TeamDesk Import - TeamDesk Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Using Advantages of TeamDesk Import - TeamDesk Blog\" \/>\n<meta property=\"og:description\" content=\"To save your time and facilitate your effort on data processing, TeamDesk is enhanced with the import\/ export features. Pretty standard solution for an application of this type, one may say. Yet, TeamDesk uses these features to solve a variety of tasks and helps to lighten your work appreciably.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/\" \/>\n<meta property=\"og:site_name\" content=\"TeamDesk Blog\" \/>\n<meta property=\"article:published_time\" content=\"2007-09-13T12:07:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2024\/01\/logo_og.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"315\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Christine Jefferson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christine Jefferson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/\"},\"author\":{\"name\":\"Christine Jefferson\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/049dd02fd19258ded8cfdc419b4462ed\"},\"headline\":\"Using Advantages of TeamDesk Import\",\"datePublished\":\"2007-09-13T12:07:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/\"},\"wordCount\":412,\"commentCount\":0,\"articleSection\":[\"Tips &amp; Tricks\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/\",\"name\":\"Using Advantages of TeamDesk Import - TeamDesk Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\"},\"datePublished\":\"2007-09-13T12:07:32+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/049dd02fd19258ded8cfdc419b4462ed\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/tips-tricks\\\/data-is-a-const\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Using Advantages of TeamDesk Import\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/\",\"name\":\"TeamDesk Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/#\\\/schema\\\/person\\\/049dd02fd19258ded8cfdc419b4462ed\",\"name\":\"Christine Jefferson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/?s=96&d=mm&r=g\",\"caption\":\"Christine Jefferson\"},\"url\":\"https:\\\/\\\/www.teamdesk.net\\\/blog\\\/author\\\/christine-jefferson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Using Advantages of TeamDesk Import - TeamDesk Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/","og_locale":"en_US","og_type":"article","og_title":"Using Advantages of TeamDesk Import - TeamDesk Blog","og_description":"To save your time and facilitate your effort on data processing, TeamDesk is enhanced with the import\/ export features. Pretty standard solution for an application of this type, one may say. Yet, TeamDesk uses these features to solve a variety of tasks and helps to lighten your work appreciably.","og_url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/","og_site_name":"TeamDesk Blog","article_published_time":"2007-09-13T12:07:32+00:00","og_image":[{"width":600,"height":315,"url":"https:\/\/www.teamdesk.net\/blog\/wp-content\/uploads\/2024\/01\/logo_og.png","type":"image\/png"}],"author":"Christine Jefferson","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christine Jefferson","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/#article","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/"},"author":{"name":"Christine Jefferson","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/049dd02fd19258ded8cfdc419b4462ed"},"headline":"Using Advantages of TeamDesk Import","datePublished":"2007-09-13T12:07:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/"},"wordCount":412,"commentCount":0,"articleSection":["Tips &amp; Tricks"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/","url":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/","name":"Using Advantages of TeamDesk Import - TeamDesk Blog","isPartOf":{"@id":"https:\/\/www.teamdesk.net\/blog\/#website"},"datePublished":"2007-09-13T12:07:32+00:00","author":{"@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/049dd02fd19258ded8cfdc419b4462ed"},"breadcrumb":{"@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.teamdesk.net\/blog\/tips-tricks\/data-is-a-const\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.teamdesk.net\/blog\/"},{"@type":"ListItem","position":2,"name":"Using Advantages of TeamDesk Import"}]},{"@type":"WebSite","@id":"https:\/\/www.teamdesk.net\/blog\/#website","url":"https:\/\/www.teamdesk.net\/blog\/","name":"TeamDesk Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.teamdesk.net\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.teamdesk.net\/blog\/#\/schema\/person\/049dd02fd19258ded8cfdc419b4462ed","name":"Christine Jefferson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Christine Jefferson"},"url":"https:\/\/www.teamdesk.net\/blog\/author\/christine-jefferson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/155","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/comments?post=155"}],"version-history":[{"count":0,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/posts\/155\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/media?parent=155"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/categories?post=155"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.teamdesk.net\/blog\/wp-json\/wp\/v2\/tags?post=155"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}