GEET Installation

GEET Demo Site Startup

GEET Your First Export to Excel

GEET Basics

GEET 1.3.2 Reference

GEET FAQ

The setup of the "Gridview to Excel Export Tool" Demo Site.

Following steps are required to run the "Gridview To Excel Export Tool" Demo Site on your machine. The Demo Site is installed in the GEETDemoSite subfolder of the "C:\program files\Cefalà Ing. Ettore\[Version]\" folder (Program files may become Program Files(x86) on 64 bit computers)

During this walkthrough you will:

1. create a Virtual Directory in the Default Web Site of you machine to host the Gridview to Excel Export Tool Demo Site.
2. give permissions to the User ASPNET (or NETWORK SERVICE) which, by default, runs the Web Site, to properly access some application and system folders
3. give permissions to the User ASPNET (or NETWORK SERVICE), to read data from the AdventureWorks Sql Server database
4. run the GEET Demo Site

GEET Virtual Directory Creation

To create the GEET Virtual Directory you should

1. Run IIS on your machine (to run IIS open your computer Administrative Tools and doubleclick Internet Information Services icon;
2. Expand "Your Machine Name" Node;
3. Expand the "Web Sites" Node;
4. Select your Default Web Site;
5. Click the right mouse button and select "New" and then "Virtual Directory";
6. Next "Virtual Directory Creation Wizard" will popup;
   
7. after pressing Next, next screen will ask you to assign an Alias to the new Virtual Directory.
   
8. Assign an Alias to the new Virtual Directory (e.g. GEET)...
   
9. and press Next. Next screen will ask you to enter the path of the folder that contains the site.
   
10. Press the Browse button and navigate to the folder C:\Program Files\Cefalà Ing. Ettore\GridviewExcelExportTool\1.3.2\GEETDemoSite. N.B.: On 64bit machine "Program Files" could become "Program Files(x86)".
    
11. Select the GEETDemoSite folder and press OK. Next window will show up.
    
12. Press Next.
    
13. In the previous screen, please check "Read" and "Run scripts" checkboxs and press next.
    
14. Open Windows Explorer and navigate to the Program Files Folder

GEET Folders Permissions

With next steps you should give some permissions to the ASPNET or NETWORK SERVICES user under which, by default, runs the Virtual Directory you just created.

N.B. You should repeat this procedure three times. Folders on which you should give "Modify" permission to ASPNET or NETWORK SERVICE user are:

1. C:\Program Files\Cefalà Ing. Ettore\GridviewExcelExportTool\1.3.2\GEETLogs
2. C:\Program Files\Cefalà Ing. Ettore\GridviewExcelExportTool\1.3.2\GEETTemplates
3. C:\WINDOWS\TEMP folder

Please notice that "Program Files" may be "Program Files(x86)" on 64 bit machines.

Following are the steps to give permissions on first of the three above listed folders:

1. Open Windows Explorer and navigate to folder: C:\Program Files\Cefalà Ing. Ettore\GridviewExcelExportTool\1.3.2 where "Program Files" may be "Program Files(x86)" on 64bit machines.
   
   
2. In this screen please select the GEETLogs folder, click the right button of the mouse and select "Security".
   
   
3. Next window will show up.
   
   
4. Press Add to add a new user.
   
   
5. Press Advanced and proceed to next window.
   
   
6. Press Find now and next window will show up.
   
   
7. In this screen scroll down to find ASPNET or NETWORK SERVICE User.
   
   
8. Select ASPNET (or NETWORK SERVICE) Used and press Ok. Next window will show up.
   
   
9. Press Ok on previous screen. Next window will whow up.
   
   
10. Give ASPNET (or NETWORK SERVICE) "Modify" permission and press Apply. Next window will show up.
    

GEET - Giving Permissions on the AdventureWorks Sql Server Database

In this section you will give the user ASPNET or NETWORK SERVICE, permissions to work on the Microsoft AdventureWorks Sql Server database. If you neew to install this database you may download it from Microsoft Download Center.

Open Sql Server Management Studio (or Sql Server Enterprise Manager), navigate to the AdventureWorks database and

1. Expand adventureWorks node
2. Expand Security node
3. Right-click Users node and select "New User". Following window will show up:
   
4. Click the Browse (...) button. Next window will show up:
   
5. Click "Browse":
   
6. Next window showing a list of user will show up:
   
7. Look for Your computer name\ASPNET (or NTAUTHORITY\NETWORK SERVICE) User; Check it and press Ok. Next window will show up:
   
8. Give db_datareader permission to the User by checking the db_datareader checkbox inside the Database Role membership box.
   
9. The Press Ok and you're finished with giving proper rights to the user running your Gridview to Excel Export Tool Demo Site.
   

Running the Gridview to Excel Export Tool Demo Site

To run the "Gridview to Excel Export Tool" Demo Site on your computer, open Internet Explorer and give it next URL http://localhost/GEET

Next screen should show up:

For any issue please click here to send a support request.