InfoPath Dev

Dear Friends,

My problems,

I have to create Users in the Active Directory to the particular OU using InfoPath Form.
I done this task with webservice. This WebService Create a User in the mentioned OU.

But I have to create 100 users, So I decide that I enter all the information about the User in the Excel Sheet(xls).

Then, If I upload the Excel Sheet into InfoPath....Then infopath form will create the User in the Active Directory using the Webservice that I already done.

But , before that...I have to show the content of ExcelSheet in the form. Before click the Create Button in the form the user can see Details.

My Question is..
How can I take the User's Information from the Excel Sheet that already uploaded ?
How can I Display content of the Excel Sheet in the Form After upload the File(.xls) ?

Thanks in Advance.
Vasanth.

Hi Vasanth,

Approach #1
Use the XML support in Excel to bind your spreadsheet to an XML file with a schema. Then, add logic in your InfoPath form to import the XML by specifying the XSD in the manifest.xsf (this will require manual editing), but it's possible and provides you with a mechanism.

Approach #2
Add the code to access the Web service to Excel and bypass InfoPath. This is probably less work than #1.

Approach #3
Just add the 100 users by hand in the InfoPath form. This is probably less time than both of the above and is less error prone... :)

Good luck

Patrick Halstead [InfoPath MVP]
InfoPathDev

Approach #4
Get your secretary to do it.

At least I wish :)

---------------
Matt Faus

Thank you very much Patrick Halstead.

I am try to do it.

Vasanth

Hey Matt,
I think I will choose #4! Oh wait, I don't have one! Dang! :)

Patrick Halstead [InfoPath MVP]
InfoPathDev

Hello Mr.Patrick Halstead,

I chose your Apporach #2 to do this stuff.

My logic is....,

When the User mention the file name( with path) in the infopath then...the webservice get the filename and grabs the details...and obvious this gives an XML format with all data in the Excel Sheet... So after that we can play with it.

Is this logic is ok Mr.Patrick Halstead...,

Vasanth.

. . . Always thanks for your Quick Reply . . .