Import and export of data: Difference between revisions

Revision as of 17:22, 8 November 2012

Latest revision as of 09:44, 28 February 2025

(39 intermediate revisions by 34 users not shown)

Line 1:

{{unreferencedrefimprove|date=JanuaryFebruary 20122013}}

The '''import and export of data''' is the automated or semi-automated [[input and output]] of [[data set]]s between different [[Application software|software application]]s. It involves "translating" from the format used in one application into that used by another, where such translation is accomplished automatically via machine processes, such as [[transcoding]], [[data transformation]], and others. True exports of data often contain data in raw formats otherwise unreadable to end-users without the user interface that was designed to render it.<ref>{{cite web|title=Export Salesforce Data|accessdate=November 7th7, 2012|url=http://www.sfdataexport.com/export-salesforce-data/|archive-url=https://web.archive.org/web/20140424095819/http://www.sfdataexport.com/export-salesforce-data/|archive-date=April 24, 2014|url-status=dead}}</ref>

Import and export of data shares semantic analogy with [[Cut, copy, and paste|copying and pasting]], in that sets of data are copied from one application and pasted into another. In fact, the [[software development]] behind operating system [[clipboard (computing)|clipboards]] (and clipboard extender apps) greatly concerns the many details and challenges of data transformation and transcoding, in order to present the end user with the illusion of effortless copy and paste between any two apps, no matter how internally different. The "Save As" command in many applications requires much of the same engineering, when files are saved as another file format.

The ability to import and export data (or lack of such ability) has large economic implications, because it can be resource-intensive to input data in non-automated ways (such as manual rekeying), and because lack of [[interoperability]] and [[data portability]] between systems unable to import or export data between each other causes [[stovepiping]] and, lack of opportunity and efficiencies such as those seen in, for example, [[mashup (web application hybrid)|mash-ups]]., and may not suffice in its ability to search for information as enabled by tools such as <code>[[grep]]</code>.

[[File:Extract, Transform, Load Data Flow Diagram.svg|thumb|[[Extract, transform, load]] (ETL) - the typical import procedure into databases]]

{{computer science stub}}

==See also==

[[Category:Input/output]]

*[[Data dump]] as export from databases

*[[Data portability]]

*[[Solid (web decentralization project)]]: allows users to control and export their own data

==References==

{{Reflist}}

==External links==

*{{Commonscatinline}}

*[https://www.tradeimex.in/search-live-data Importers Data]

[[Category:Input/output]]

{{computer science stub}}

[https://www.tradeimex.in/search-live-data '''Importers Data''']