Perspective Server Login

[satya.bhamidipati]

Is there any option to connect the a server from perspective, if I provide the server details(server name, user id and password ) in the columns of excel. As shown in the attached screenshot by taking those column values as inputs can we connect to that perticular server?

[lotsaram]

Have you tried the documentation? There is a very simple VBA function provided with Perspectives called N_Connect ...

Very easy, as good as nil coding and nil understanding required. If however you want to use CAM as the security provider then it won't work and you would need to build your own connection module from scratch with API, at your own peril.

Why would you want to do this anyway and expose a password in a cell in an excel worksheet? Is that really a good idea when the application already provides a login dialog?

[satya.bhamidipati]

Hi,
Thanks for your reply
By using N_Connect function I am able to connect to server through excel
One more query, I want to pass the server name from login page to all formulas used remaining pages



For example, if I connected to Go_New_Stores server in login page, all formulas should use Go_New_Stores. At present it is using Planning sample, but preferably when I connect to Go_New_Stores then formulas also take Go_New_Stores instead of Planning sample

[lotsaram]

So ... you're saying you don't know how to write an Excel formula?

[satya.bhamidipati]

I have Given Cell Reference(Login page Server Name Cell ) But It is Not working

[Alan Kirk]

I have Given Cell Reference(Login page Server Name Cell ) But It is Not working

I suggest that you post the EXACT FORMULA that you're using rather than the above abstraction of it. And when it comes to "not working"?

4) Similarly if you're getting unexpected results, specifics of what you're running, how, and what results you're getting will yield a more valuable response than "I'm running a T.I. but my code doesn't work properly". If you're getting an error, please be specific about what the error is (full details, not just "a runtime error" or "process terminated with errors"), and the circumstances under which it's occurring. But remember that even if you do specify the exact error message, it's not likely to be helpful unless you provide the context for it; which part of the software the error is occurring in (point 2 above), and what, specifically, you were doing at the time. For Rules and TurboIntegrator processes, remember that including the actual code in your post will be a thousand times more useful than an attempted description of it. You can upload entire .pro and .cho files as attachments if necessary, or just copy and paste the relevant part into your post using the Code tag at the top of the post editing window.

It also applies to Excel formulas.