8/29/2025 1:33:37 PM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Openning a MS Excel in saleslogix
Posted: 21 Aug 09 2:35 AM
|
Hi All,
I need to open a excel sheet by clicking a icon in saleslogix lan client and i need to check the user name ,password ie i need to access the username ,password of the saleslogix in excel sheet or can i pass the username ,password of the saleslogix user to excel as parameter.
Please help me to slove this issue.
Thanks,
Ajoy |
|
|
|
Re: Openning a MS Excel in saleslogix
Posted: 22 Aug 09 12:33 AM
|
Nagaratna,
I've never done anything beyond exporting to Excel, but I imagine the api allows you to do more than just open a spreadsheet and pop values in there.
As for the username and password, I know that they are stored in the UserSecurity table under UserCode and UserPW, but UserPW is encrypted and I don't think there is anyway to unencrypt it. It's meant to stay hidden, even from an admin. |
|
|
|
Re: Openning a MS Excel in saleslogix
Posted: 25 Aug 09 2:49 PM
|
It is unclear what you want to do.
Are you trying to open a password protected excel file in SalesLogix? If so, search msdn.com and I'm guessing you'll find a way to pass a ID & password in VB script when opening an excel file.
Are you assuming that the excel file & SLX user have the same password? Even if it is, it is encrypted in SLX and I know of no way for SLX & Excel to authenticate together. The only solution that comes to mind is to restrict Windows Read permissions on the Excel file. That way, only the users with access to the file will be able to open it. |
|
|
|
Re: Openning a MS Excel in saleslogix
Posted: 26 Aug 09 2:19 PM
|
Are you trying to run a Query within Excel that logs into SLX as each user?
In general, you shouldn't pass around any Password like this, as anything is a security risk, but there are few ways around it:
If you are trying to query slx from excel with a user within context, then you could try the following approaches:
- SQL: Connect to SLX DB via SQL and just add the Security Joins into your query, applying the UserID (or UserCode) as a parameter to the query
- SLX OLEDB Provider: Connect to SLX as Admin and add the Security Joins into your query, applying the UserID (or UserCode) as a parameter to the query
- SLX OLEDB Provider: Connect to SLX with an Admin connection, but using Impersonation and pass the Usercode into the connection string. (This one may be more difficult to achieve). |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|