Contacts are imported to RAYVN from Account settings – Contacts.
Click "import contacts from file".
You will now see a window where you will be able to click, or drag and drop an import file into the dropzone.
The import file has to be formatted in a specific way, and we recommend downloading the template files in either Excel or Google Spreadsheet below. You then only need to copy/paste in your contacts data, before exporting a "tab-delimited" text file.
It is important that you only copy the contact's data into the spreadsheet, not the formatting from your original file. For example phone numbers etc should be formatted without spaces etc. "12345678", not "12 34 56 78". In Excel, you can choose "Paste only values", which will add only the data, without any text formatting.
In Excel save the file as "Text (Tab delimited)".
In Google Spreadsheet, download as "Tab-separated values". You will then get a .tsv file. Rename it after download, and give the extension - .txt before uploading to RAYVN.
Templates Import files
You can download an example file in
- Excel format (.xls format, in this example it has not been converted to a .txt file)
- Text file (.txt format)
- Google Spreadsheet (.tsv, later converted to .txt)
Connecting data fields
When the file has been successfully uploaded, you will see a new dialog where you shall map fields from the import file to fields in RAYVN. Click on the dropdown field at the top over each column. Select which data field this column represents. All columns need to be assigned. The template has a column header. You need to check the "First row contains column headers" checkbox. In this way, the first row won't be imported.
RAYVN provides some error handling in the import engine. If RAYVN discovers data with the wrong format or other kinds of irregularities, those rows will be marked. Import cannot be completed until all rows are correct. Duplicate email addresses are not allowed.
The image below shows an error while trying to import the header row, which does not have the correct data to import. I have tried to import the first row that contains column headers. RAYVN marks the row and displays a warning sign with a tooltip. The content of the tooltip will give guidelines on what is wrong.
After a successful import, you can mark contacts, and add them to a Contact list, move them to a Group, or upgrade them to a Responder.
Removing an import batch
Go to the tab “Imports” in the Account settings.
All active and reverted imports will be visible here. To "Revert an import" means that all the contacts from an import will be deleted in one operation. Click the specific import batch you want to revert/delete, and then click "Revert".