{"_id":"55496673a5ecbc190032168a","user":"55208129504fd6230022ae20","githubsync":"","project":"55208137623ff50d009b2bec","__v":14,"parentDoc":null,"version":{"_id":"55208137623ff50d009b2bef","__v":14,"project":"55208137623ff50d009b2bec","createdAt":"2015-04-05T00:26:31.564Z","releaseDate":"2015-04-05T00:26:31.563Z","categories":["55208138623ff50d009b2bf0","55494a226a82a10d00817ae5","55494ba7ee219b0d001743c8","55494bc1ee219b0d001743cc","56ead8c1df765617008bccaf","573a2073dd007d1700cf288f","579695b1f64c9f0e007cd76c","57969e3dfa1ff60e006a1274","579a4592fd9f3c0e008e4f4a","57ab9afe54fa780e006c5430","57b784f5b7ebd60e009cb4a6","58f686818193090f008cec76","59e79fbd4cf31900341d50c6","5b2436973fd93f0003dcf99d"],"is_deprecated":false,"is_hidden":false,"is_beta":true,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"category":{"_id":"55494bc1ee219b0d001743cc","pages":["55496509c634cf2d0012507c","5549650ecd09b317005f8f4e","55496535a5ecbc1900321683","5549654dcd09b317005f8f53","55496557c634cf2d0012507e","55496563cd09b317005f8f55","55496673a5ecbc190032168a","55496682cd09b317005f8f5e","5549668da5ecbc190032168c","55497c3ea5ecbc19003216bd","55c1047d81dc010d00d50678","55c3cad1b0778d2100a7ebd8","5638e41e3539050d0008205f","563a2ac1f0c29b1700daaf98","563a2b7ef0c29b1700daafa2","563a2d83d25e8919005f3f05"],"project":"55208137623ff50d009b2bec","version":"55208137623ff50d009b2bef","__v":16,"sync":{"url":"","isSync":false},"reference":true,"createdAt":"2015-05-05T23:01:21.408Z","from_sync":false,"order":3,"slug":"features","title":"Features"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2015-05-06T00:55:15.475Z","link_external":false,"link_url":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":true,"order":9,"body":"There are a few ways to get your customers into Sonar. One of the easiest ways is to import customers using a [CSV file](http://en.wikipedia.org/wiki/Comma-separated_values).\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"How To Use CSV Import\"\n}\n[/block]\nThe first thing you need to do is prepare your CSV file to look like the screenshot below. The first column should be the Phone Number of the customer you're importing. \n[block:image]\n{\n  \"images\": [\n    {\n      \"image\": [\n        \"https://files.readme.io/bIAuqhp2SM6ICr9K4fC9_Screen%20Shot%202015-05-08%20at%2010.47.02%20AM.png\",\n        \"Screen Shot 2015-05-08 at 10.47.02 AM.png\",\n        \"1982\",\n        \"384\",\n        \"#e5e5e5\",\n        \"\"\n      ],\n      \"caption\": \"CSV Example\"\n    }\n  ]\n}\n[/block]\n\n[block:callout]\n{\n  \"type\": \"warning\",\n  \"title\": \"Unique Identifier\",\n  \"body\": \"The first column of the CSV file must be the Phone Number of the customer you're adding to our system.\"\n}\n[/block]\nFirst Name, Last Name, and Email are all reserved columns that you can use. After that, you can add any number of properties you want, with any values. \n\nThere's a special column called Delete that will delete a customer by their Phone Number when our importer sees the value \\*\\*DELETE\\*\\* for the column Delete.\n[block:callout]\n{\n  \"type\": \"info\",\n  \"title\": \"Deleting Properties\",\n  \"body\": \"To delete a property on a customer, put \\\\*\\\\*DELETE\\\\*\\\\* in the cell of the property you want to delete for the relevant customer. **Please note** that \\\\*\\\\*DELETE\\\\*\\\\* only works on non-reserved columns.\"\n}\n[/block]\n\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"After Import\"\n}\n[/block]\nAfter the import is completed, you'll receive an email showing how many customers were successfully imported and how many failed.","excerpt":"","slug":"csv-import","type":"basic","title":"CSV Import"}
There are a few ways to get your customers into Sonar. One of the easiest ways is to import customers using a [CSV file](http://en.wikipedia.org/wiki/Comma-separated_values). [block:api-header] { "type": "basic", "title": "How To Use CSV Import" } [/block] The first thing you need to do is prepare your CSV file to look like the screenshot below. The first column should be the Phone Number of the customer you're importing. [block:image] { "images": [ { "image": [ "https://files.readme.io/bIAuqhp2SM6ICr9K4fC9_Screen%20Shot%202015-05-08%20at%2010.47.02%20AM.png", "Screen Shot 2015-05-08 at 10.47.02 AM.png", "1982", "384", "#e5e5e5", "" ], "caption": "CSV Example" } ] } [/block] [block:callout] { "type": "warning", "title": "Unique Identifier", "body": "The first column of the CSV file must be the Phone Number of the customer you're adding to our system." } [/block] First Name, Last Name, and Email are all reserved columns that you can use. After that, you can add any number of properties you want, with any values. There's a special column called Delete that will delete a customer by their Phone Number when our importer sees the value \*\*DELETE\*\* for the column Delete. [block:callout] { "type": "info", "title": "Deleting Properties", "body": "To delete a property on a customer, put \\*\\*DELETE\\*\\* in the cell of the property you want to delete for the relevant customer. **Please note** that \\*\\*DELETE\\*\\* only works on non-reserved columns." } [/block] [block:api-header] { "type": "basic", "title": "After Import" } [/block] After the import is completed, you'll receive an email showing how many customers were successfully imported and how many failed.