|
I'm working on a web application that allows you to import an excel spreadsheet with a list of users. When importing this spreadsheet what it does is creates users in active directory and then enables the user mailbox in Exchange.
I'm more a Windows developer but what I'm wanting is to display a progress percentage and text on what user it is on and a list of ones that may have failed.
I've done some googling and found a lot of information on this topic (http://msdn.microsoft.com/en-us/magazine/cc163553.aspx[^] and even Use the Asynchronous Power of ASP.NET to Create a Simple, Reusable Page for Displaying a Processing Message[^]).
What I am wanting to know is which of these would be a better option for what I'm trying to do? Would creating a web service that reports the progress be best?
If I do a web service would it work like this:
1) User submits list of users to Web Service
2) Web service gets list and returns a Guid to page
3) Page redirects to another webpage with the guid session variable or query string
4) Web service starts the task and logs its progress to a SQL database
5) Page constantly refreshes (every 1 or 2 seconds), pulling the latest information regarding that GUID from the database and displaying it.
6) Web service logs the "COMPLETED" task in the database
7) Web page receives the "COMPLETED" information from the database and stops refreshing..
Sorry for the novice questions on this topic.. just wanting to make sure I have the workflow correct
|
|
|
|
|
If your good with javascript and char arrays, then maybe you can parse the excel file using client script, and then the list to a web service 1 user at a time, in a loop, so you can update the progress and results.
|
|
|
|
|
I'm not really that great with javascript but wouldn't that be opening my web service for anyone to use?
If I was callign the web service from code behind I can limit it to that specific IP. If I am callign it with javascript then that is client side code which would mean I would have to open the web service to the world.
Not sure if that would be best for my situation 
|
|
|
|
|
Well of course, but I think there is a rule in javascript, which only the originating website can consume a web service, you can't go cross domain using $ajax, you have to use something else to go cross domain.
I don't what to tell you.
You want to do something really really complex, and your not sure how to plan or engineer the task, plus your not familiar with some of the rules regarding how to secure the application.
Then you need to start simple and upload the excel file first. Then read the file and parse the data you need. Then create your accounts, update your database, and return a result first.
Then take the pieces, optimize them, and you can rearrange the parts, to be more fluid.
In theory, with really well written code, shouldn't take more than a few seconds to complete the task.
|
|
|
|
|
I'll see what I can find out.
I have already wrote all the code that uploads the excel spreadsheet, creates the active directory users, then enables the user's mailbox in Exchange. This is all working just fine.
In theory this type of import will not take a few seconds. You are talking about upload excel spreadsheets that contain numerous amounts of users (One client is 700 users for example).
So that is 700 calls to Active Directory that creates the user object, another 700 calls to add that new users to the correct security groups, then another 700 calls to Exchange using remote powershell to enable the user object for mail. Remote powershell is not that fast anyways.
I was really just looking for a type of tutorial or a working example of what I am looking for, which is just being able to relay information back to the client about which task the server is currently performing.
|
|
|
|
|
I forgot, that’s going to take awhile, maybe an hour or two. Maybe 4 or 5 hours. Writing to active directory isn’t that fast.
Just tell them it will be ready in the morning
Well, if you look at windows update, or Microsoft virtual server, the web interface, that’s the most advance stuff that I have seen. I’m trying to think of more examples.
You can try the google forums, and I think Gmb something.
I don’t know of any turtorial, that’s probably going to be home brewed.
I tried some stuff in the past that worked, but then an update to asp.net came out and it killed my work.
Today I just avoid that stuff.
I would use uploadify to upload the excel file, attach uploadigy to a generic handler, process the excel file, return a json array to javascript with the names via generic handler, then create dynamic javascript and populate a div container using append, with progress updates, feed each user in 1 at a time through a web service to create each user, return json with the status when complete, loop again till done. When done, create a complete button via dynamic javascript.
Since the whole thing is ssl, and session protected, security should be covered. Generic handlers are session capable.
if you call a web service ssl, it will be ssl. You can tweak a web service to be session capable. Add some tokens to the javascript ajax for authentication, tweak the names to make it real confusing to the average joe.
|
|
|
|
|
Hi
I have a web page .On clicking of a button I get a modal popup(Ajax) which shows the the text box which is dynamically filled by the contents and it is inside a panel. This modal popup contains a print button. Once I do print then I take the innerhtml from the panel and open it in a separate window and this goes for printing. But as the text value is dynamic so the height of the text box is not fixed and hence when i do print so the part remaining in the scroll bar doenot print. Could you please let me know how exactly i can remove the scrool bar means I can adjust the height of the text area so that all the contents present in the text area can be printed.
the code is like this as shown below.
var printContent = document.getElementById('<%= pnlProrateSlip.ClientID %>');
var windowUrl = 'about:blank';
var uniqueName = new Date();
uniqueName.getTime();
var printWindow = window.open(windowUrl, windowName, 'left=50000,top=50000,width=0,height=0');
var printWindow = window.open(windowUrl, windowName);
printWindow.document.write(printContent.innerHTML);
printWindow.document.close();
printWindow.focus();
printWindow.print();
printWindow.close();
So what I am doing is , geting the innerhtml value from the panel and putting in a new page and printing it.This panel contains a textbox, whose height and widt I have to manipulate through script, so that I will not get the scroll bar. So from the innerhtml of the panel can I get the textbox by the ID?
Thanks
Prashant
|
|
|
|
|
Well, you need to calculate the height then, and use the result in your JavaScript to re-size the text area. But then you have to pass it to the next page somehow.
The textarea scrollbar is the default for overflow, so you use CSS to either hide or show the overflow.
Maybe you should experiment with CSS first. CSS is pretty good for solving stuff like that. height: auto;
Oh, and that's a JavaScript question, and your post belongs in the java script discussion area. Your post has nothing to do with asp.net.
|
|
|
|
|
Hi,
i have a website and I showing external news on my website (links to news from other websites).
I want to ask... ranking wise, is it better to display the link as its original url on my news page or show as goto.aspx?URL then the goto.aspx will redirect to that page?
what's your advise?
|
|
|
|
|
Original URL.
Bastard Programmer from Hell 
if you can't read my code, try converting it here[^]
|
|
|
|
|
why not use
<a href="http://www.target/com/" target="_blank">link</a> ?
|
|
|
|
|
I am using the Asp.net system.diagnostics.process to command line execution of executable file
To execute the for(eg:eRegistortool.exe ) with arguments for reading the media file information
1. Argument eg(C:\document and settings\0100808\ desktop\sample.jpg)
Problem:
The file cannot open return the error 000005 access denied error
Note:
when the executing the file via visual studio the problem not produce,
Please give me resolution for solve this problem
|
|
|
|
|
RajavelK wrote: Problem:
The file cannot open return the error 000005 access denied error
Using IIS? In that case, your app will not be running under a standard-user account; the ASP.NET account is limited in it's rights.
RajavelK wrote: when the executing the file via visual studio the problem not produce
In which case "you" are the logged in user, and the app will be running with your permissions.
RajavelK wrote: Please give me resolution for solve this problem
Change the permission.
Why are you trying to launch a picture on the server?
Bastard Programmer from Hell
if you can't read my code, try converting it here[^]
|
|
|
|
|
value was either too large or too small for an int32. how can i solve this ,when i converting to int?
|
|
|
|
|
Make sure the value is not too large or too small. Maybe you should think about what you are trying to do here and explain the problem in better detail.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
You cannot convert it into int. The maximum value of an int is 2,147,483,647.
Alternatively, if needed, try using UInt (4,294,967,295) or long (9,223,372,036,854,775,807).
|
|
|
|
|
Hi,
i'm using a AJAX SlideShowExtender. i'm having a multiline textbox for commenting images by clicking stop button(so that it will save for that image). Now i want to get the details of comments to be displayed(if comments already saved) during the slideshow automatically. Anyone have idea plz let me Know.
thanks in advance.....
|
|
|
|
|
hi to all,
any one give the solution to me,normally grid view contents displays and expand in row-wise.i need how to display the grid content and expand in column-wise.
M.Saravanakumar
SunArk-GmbH.
|
|
|
|
|
kumaranvnr wrote: display the grid content and expand in column-wise
That should be simpler than expanding row-wise. All you need to play with column visibility. Pre-populate the column at the time of grid content bind and based on an event just(click of a plus sign or so) set the visibility of the column to true. Try out!
|
|
|
|
|
how to create database with sql connection in vb.net
|
|
|
|
|
Wrong forum. Try the VB forum.
But before you try that, try Googling "VB.NET database connection", that currently has 5,280,000 results.
|
|
|
|
|
In addition to what Keith said, you already asked in QA no need to ask again.
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
We should have proper name for this triumvirate:
- Wrong forum
- Easily Googled
- Cross posted
Only needs to add bumping via repost FTW!
|
|
|
|
|
Keith Barrow wrote: proper name
I think it's called a trifecta
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012
|
|
|
|
|
shouldn't it be a pentavirate(?) with these additions?
- Urgentz
- Gimme codez
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
