Find Jobs
Hire Freelancers

Securing Excel XMLMap

$100-500 USD

Suljettu
Julkaistu yli 18 vuotta sitten

$100-500 USD

Maksettu toimituksen yhteydessä
Our product uses Windows Excel '03 XMLMaps feature to serve up-to-date data directly to Excel reports. However, our clients need additional security so that the XML source data cannot be accessed, via Excel or directly over the web, without authentication. We are seeking a solution to this problem. The XMLMap source data is already being generated-- all we need is a way to authenticate the user of the spreadsheet that consumes the data. Adding a spreadsheet password is not an acceptable solution because it is easily broken, and the XML feed can be accessed outside of spreadsheets. *** Also, macros and vbscript in the spreadsheets is disallowed by our clients for security reasons.*** One solution we're considering is the creation of a Windows Sharepoint proxy to sit between our product and client spreadsheets. Product platform is Windows Server '03. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition. A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request is required, or at least detailed instructions that would permit us to go from a base Windows Server '03 system with SQL Server '00 and Windows Sharepoint installed on it, to a system that supports a solution to the authentication issue outlined in the description. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Wednesday Nov 16, 2005 12:45:23 PM: Hello, It seems that there has been some confusion about the purpose of this project, so please read the following. The objective is to serve private data (marketing reports) from a marketing system to the users of that system, using Excel as the interface to it. In other words, all a user needs in order to see the latest data is Excel 03 and a copy of the spreadsheet. Once they open the spreadsheet inside Excel, they can simply pull down the Excel Menu Data...XML...Refresh All XML Maps, and the spreadsheet will update itself to include the latest data. The system already does all of the above successfully. However, Excel does not request a username and password before the Data refresh is completed. This means that if the spreadsheet is accidentally sent outside the company or stolen, users other than those authorized to use the data could gain access to the data fo r criminal purposes. We require that users of the spreadsheets enter a username and password in order to refresh the data. The username and password must be validated by the server, not the spreadsheet. No VBA code must be used by the spreadsheet. The username and password are to be chosen by the designer of the spreadsheet before it is distributed to users. We will implement the interface that assigns the username and password to the XMLMap feed that serves the spreadsheet. As I have stated elsewhere, the built-in spreadsheet password locking feature of Excel is insufficient data protection, and is not an acceptable solution. Hope this clarifies things. Thank you for your interest. ## Platform If the authentication solution is to run on the application server side, it needs to run under Windows Server '03 (w SQLServer '00 and Windows Sharepoint 2004). If the authentication solution is to run on the application client (spreadsheet) side, it needs to run on Windows XP Pro (latest service packs/patches), running Office '03. We prefer the authentication solution run on the server side to simplify deployment.
Projektin tunnus (ID): 3093270

Tietoa projektista

Etäprojekti
Aktiivinen 18 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista

Tietoja asiakkaasta

Maan UNITED STATES lippu
United States
0,0
0
Liittynyt marrask. 14, 2005

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.