using pc login with customer service software

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Hi.  :]  We use some customer service software called SmarterTrack.  It allows you to use external provider for things like logging in.  It asks for web service URL, web service password and forgot password URL - is there a way to integrate the PC login into this other software, so that they use the same customer database login?!

Here's their support page about this:

http://help.smartertools.com/SmarterTrack/v3/Default.aspx?p=SA&v=3.6.3229&lang=en-US&page=settings/frmproviders

Thanks.

Edited by JWL - 29-May-2009 at 2:48pm

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
JWL Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 15-August-2008 Status: Offline Points: 0	Post Options Post Reply Quote JWL Report Post Thanks(0) Quote Reply Topic: using pc login with customer service software Posted: 29-May-2009 at 2:44pm
	Hi. :] We use some customer service software called SmarterTrack. It allows you to use external provider for things like logging in. It asks for web service URL, web service password and forgot password URL - is there a way to integrate the PC login into this other software, so that they use the same customer database login?! Here's their support page about this: http://help.smartertools.com/SmarterTrack/v3/Default.aspx?p=SA&v=3.6.3229&lang=en-US&page=settings/frmproviders Thanks. Edited by JWL - 29-May-2009 at 2:48pm

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 29-May-2009 at 3:23pm
	Big challenge, and I guess the answer depends upon your budget. I have ST on my server as well, so I'm able to confirm that SmarterTrack uses a MSSQL database, so that may be on the same SQL server as your store database. There's likely no way you will get your hands on the source for SmarterTrack itself, so any integration you create is going to be a matter of examining their database structure and building a tool to exchange customer data between the store and ST. I see there is a st_Users table, and perhaps you can write something that sends data from the store over to that table, but there are several other tables that are prefixed "st_Usersxxx" and I'm not sure what those may be used for, or the extent that those tables need to be included within this integration. To be certain you will need a skilled coder who will be able to evaluate both the ST User and PC Customer table structures, and build a tool that exchanges new and edited data between them.

JWL Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 15-August-2008 Status: Offline Points: 0	Post Options Post Reply Quote JWL Report Post Thanks(0) Quote Reply Posted: 29-May-2009 at 4:39pm
	Do you have any idea what the external login provider feature is about?! I thought it allowed customers to login to the ST portal, by using their login info they registered through say PC registration form... is that not what this feature is for?!

Greg Dinger Members Profile Send Private Message Find Members Posts Add to Buddy List Certified ProductCart Developers Joined: 23-September-2006 Location: United States Status: Offline Points: 238	Post Options Post Reply Quote Greg Dinger Report Post Thanks(0) Quote Reply Posted: 29-May-2009 at 4:47pm
	I'm not sure JWL. It would take some study of their documetation to see what they offer.

Guests Members Profile Send Private Message Find Members Posts Add to Buddy List Guest	Post Options Post Reply Quote Guests Thanks(0) Quote Reply Posted: 29-May-2009 at 7:38pm
	JWL, You're not going to be able to use a web service for this as ProductCart is classic ASP. However, Greg's definitely suggesting the right direction if what you are looking for is to have the login info be the same in both ProductCart and SmartTrack (assuming that your customers would understand that they'd use their email address as the UID for SmarterTrack). The tricky thing, though, would be how to handle the encrypted PWD in SmarterTrack.