Invalid SQL: REPLACE INTO `swsessions` (`sessionid`, `ipaddress`, `lastactivity`, `useragent`, `isloggedin`, `sessiontype`, `typeid`, `dateline`, `status`) VALUES('t25jjigoqg4zwij97raahilollod1ink', '34.204.176.71', '1731215827', 'CCBot/2.0 (https://commoncrawl.org/faq/)', '0', '40', '0', '1731215827', '0'); (The table 'swsessions' is full) Importing members from a CRM into a Nanacast membership via Memberlock - Powered By Kayako eSupport
09 Nov 2024 
Support Center » Knowledgebase » Technical FAQs » CRM & Email List Management Integration » Importing members from a CRM into a Nanacast membership via Memberlock
 Importing members from a CRM into a Nanacast membership via Memberlock
Solution

Save it in tab-delimited format, that would probably work best for the import. 

In order to make the import as smooth as possible I would do this: 

1. Add all the Nanacast field names to the top row of your spreadsheet (see screenshot). Then make the spreadsheet data reflect what those fields are. Then when you import it will be easy to match up the fields.

2. When you finish, copy the spreadsheet to a new file and remove all but 1 or 2 rows, or just have yourself in one of the rows and then test the import.

3. Check that you got the email and make sure you get into your memberlock blog. Check the client record in Nanacast to make sure the billing info is correct. 


Keywords: Import members



Article Details
Article ID: 170
Created On: 06 Apr 2010 11:34 AM

 This answer was helpful  This answer was not helpful

 Back
 Login [Lost Password] 
Email:
Password:
Remember Me:
 
 Search
 Article Options
Home | Register | Submit a Ticket | Knowledgebase | News
Language:

Help Desk Software By Kayako eSupport v3.60.04