Introduction

What to do when Top20 Report in Propmansheet does not work

Details

1.Click on link http://webapp.redcross.org.uk:3000/property/bids and login page doesn't appear

Contact helpdesk as this is an infrastructure issue.

2. Forgot your password - so need to set-up new password

login is as admin: user: admin password: (see my email)

Delete old user here: http://webapp.redcross.org.uk:3000/property/login/list_users (click on the (x) )

Add new user and password here: http://webapp.redcross.org.uk:3000/property/login/add_user

3.Links to report don't work as reports have been moved

Need to edit this file on the Top20 report property server (linux): /home/property/propmansheet/Propmansheet_current/app/views/layouts/bids.rhtml

Change the following lines to reflect where the spread sheets are stored:

<%= link_to("1. Open Crystal Reports - Total Top 20 Report (Formatted for Printing)", "file://S:/FinRes/Property portfolio mgt/Data mgt/Data Manager/PropMan/Reports/Top20/Top20_RoR.rpt") %>
<Br>
<%= link_to("2. Open Excel Top 20 Spreadsheet for Territory 1 (excluding Retail)", "file://S:/FinRes/Property portfolio mgt/Roadmaps etc/a 2007/07 Top 20s/T1/Propmansheet_Top20_T1.xls") %>
<Br>
<%= link_to("3. Open Excel Top 20 Spreadsheet for Territory 2 (excluding Retail)", "file://S:/FinRes/Property portfolio mgt/Roadmaps etc/a 2007/07 Top 20s/T2/Propmansheet_Top20_T2.xls") %>
<Br>
<%= link_to("4. Open Excel Top 20 Spreadsheet for Territory 3 (excluding Retail)", "file://S:/FinRes/Property portfolio mgt/Roadmaps etc/a 2007/07 Top 20s/T3/Propmansheet_Top20_T3.xls") %>
<Br>
<%= link_to("5. Open Excel Top 20 Spreadsheet for Territory 4 (excluding Retail)", "file://S:/FinRes/Property portfolio mgt/Roadmaps etc/a 2007/07 Top 20s/T4/Propmansheet_Top20_T4.xls") %>
<Br>

Then get IT to restart server.

4. Propmansheet EXCEL Top20 reports don't work on your PC

You probably have not got the ODBC drivers installed on your PC.

Ask IT to install then for you.

The ODBC driver can be found at http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32

After installing it IT then needs to set up a link to the Propmansheet database source:

Goto: Control panel Adninistrative tools ODBC System DNS Add Data source name: Top20_Bids Server: 192.168.16.113 User: report Password: (see email) Database: property

The Excel spreadsheet should then automatically update.

5. Need to make changes to Propmansheet web spreadsheet

Contact me on ezzy.elliott@gmail.com and I will talk IT through making changes.