Hello,

We imported several hundred contacts into SLX a few years ago. We are finding that many of these contacts are not picked up when using SwiftPage to send emails to them. This occurs whether they are in a group, or selected as a single target with SwiftPage. I have tried everything I know how to do at this point including a SLX profiling on a send to a good contact VS a bad contact. The only thing I found with this exercise was that in the case of the good contact a SQL statement occurs selects several fields from the contact table (i have added the statement below). This statement does not occur with the bad contact and the only thing that the profiler shows is a whole mess of PLUGIN queries that only reference my USERID/ACCESSID.

I have tried using the integrity checker. It found a few problems but unfortunately they didnt resolve this issue. The only hopeful item that I have encountered is that I updated the contactid of one of the bad contacts and Swiftpage was able to successfully identify the contact and email them. However, a few days later it did not work (same test). The idea to update the contactid came from an article I found where someone stated that having contactIDs with lowercases characters in the middle of the ID is not a best practice. Sure enough, the several hundred contacts had IDs such as ESPMey01ychj. I spoke to SwiftPage support and they pointed me right back to SLX.

Any help would be very, very appreciated!

<p>SELECT CONTACT.Lastname,CONTACT.Firstname,CONTACT.Email,CONTACT.DoNotSolicit,CONTACT.DoNotEmail,CONTACT.CONTACTID,CONTACT.SECCODEID SLXSECCODEID7 FROM Contact INNER JOIN SECRIGHTS S_AA ON (S_AA.ACCESSID = 'U6UJ9A0000IT' AND CONTACT.SECCODEID = S_AA.SECCODEID )   WHERE CONTACT.Contactid = 'CYB000009514'

I don't know much about Swiftpage (full disclosure - we sell Exact Target integrated to SalesLogix), but it sounds like something is missing from your imported data.

Have you tried sending while logged in as ADMIN or just  a user?

Does the imported data work everywhere else in the system?

Enter a new record with as little information as it will allow and compare it side by side with one of your imported ones.

Anything that is different between those two is a big red flag.

Get a copy of QueryExpress or something that lets you open the database through the OLEDB provider using a connection string.

Try retrieving your contact record

ex: SELECT LASTNAME, FIRSTNAME, EMAIL, DONOTSOLICIT, DONOTEMAIL, CONTACTID, SECCODEID FROM CONTACT WHERE CONTACTID ='yourid'

Doing a query directly against the provider will give you any error messages that may be getting dropped by the SLX client.

Happy hunting...

Hi Walter

Thank you very much for the reply. You have given me some new things to explore. I'll report back if any are the smoking gun. I might want some info about Exact target as well

Well no luck so far on fixing, but I have discovered something.  If I search for one of these bad contacts using a lookup, and then go to their Contact Details page i get the failure in Swiftpage. However, if I go to their Contact Details page and do a F5 refresh, then do Swiftpage, it works! Only the regular F5 works and not a Ctrl-F5.

I think something is not getting populated when the contact is brought up. I tried Profiler again, but no clues there. I am pretty new at this SalesLogix thing in general so I am probably overlooking some key item.

I am currently running Integrity checker in a Dev environment, and repairing what it finds. I keep checking after each job, but so far no luck.

you do have  valid email for each and every one of these contacts?

AccountManagerID, Seccodeid, AddressID, ShippingId also must be valid....

Hi RJ

Thank you for replying. I cant guarantee that I have a valid address for all of them, but the handful I have been testing with do have a valid address. I checked all of the IDs you mentioned and they are valid or more accurately I should say that they exist and are populated. I messed around with the address and shippingIds and still had no luck. The biggest clue that I have is that if I do an F5 refresh on the contact prior to opening the Swiftpage plugin, it will work.

For giggles I created a new contact and merged one of my 'bad' ones with it (making the new one the primary) and that also fixed the issue permanently for that contact. The bottom line I think is that these contacts somehow got hosed on the import. I am getting to the point where I think I should probably just reimport them and merge them unless you have another idea (I sure hope you do!)

thanks again for the reply and help. I know my way around T-SQL decently well so the powers that be decided I got the priviledge of being the SLX admin/developer (I think I am only maybe 5% qualified, but I seem to be gaining a percent a week or so )

Dan,

Something just occurred to me here - it is HIGHLY LIKELY that Swiftpage is looking at the record id's to figure out whether it is a contact or a lead record that it is dealing with. Typically it would be something where they look at the first letter of the record id. If it is a C, then its a contact, if its a Q, then its a lead. If your imported records start in anything else - it could be that it simply does not know what to do with them.

ws