I gang

PHP to SharePoint Library

INTRODUCTION

The TEALS program ([url removed, login to view]) hosts many of its public facing services such as volunteer and school applications on a WordPress platform. Yet its internal operations are managed through SharePoint lists. This document describes the requirements of a PHP library callable from a WordPress site when faced with a table DELETE, UPDATE or INSERT request that must have an equivalent experience in its SharePoint counterpart.

INTERFACES

The PHP library must support interfaces to accomplish the following:

• Read full or partial record from SharePoint list

• Insert full or partial record to SharePoint list

• Update full or partial record to SharePoint list

Common interface parameters are:

- SharePoint site URL

- SharePoint list name

- SharePoint username

- SharePoint password

To maintain integrity between a table on the WordPress site and its SharePoint list equivalent, every list operation must include a column representing the unique key value. Additionally, the destination list column that hosts the key must be identified in the interface call.

COMMAND

The interface for every operation (read, insert, update, delete) must be represented as a query in a format similar to “select {columns…} from list where ….”

PROTOCOL

The protocol format must be JSON and XML. In phase 1 of the project, JSON will be the standard format. In phase 2, XML will be supported. As a result, the interface must specify which protocol is required for formatting the output (i.e. JSON or XML).

SECURITY

The library must account for security over the wire. SharePoint passwords must not be sent in clear text over the wire.

DEBUG INTERFACE

For testing, a DEBUG USER INTERFACE allows end-user testing of the library. The library presents UI elements for:

- Fixed configurable variables

- Query input

- Response output in JSON (phase 1) or XML (phase 2)

The debug interface serves two purposes

1. Create the protocol specific input which the PHP library needs to submit

2. Create the protocol specific output which the PHP library will receive

USER SCENARIOS

Scenario 1

The volunteer and school application are filled in the WordPress forms on www.tealsk12.org. When the applications are created, a process will call the PHP library to insert the full or partial contents of the newly created application into a SharePoint list.

Scenario 2

Volunteers and schools can return to a partially completed application to update their preferences. When the applications are updated, a process will call the PHP library to update the full or partial contents of the application into a SharePoint list.

Scenario 3

TEALS administrators make updates to volunteers and schools data in their SharePoint lists. Sample changes include removing volunteers or schools from circulation. When this occurs, the website on [url removed, login to view] must be updated to reflect these changes. A process on the public website will do a read query on a SharePoint list via a CRON job at a scheduled interval, looking for an update in a SharePoint list record or set of record(s). If the record has been updated, the WordPress site will query the SharePoint list for the record contents and update itself in WordPress.

RESOURCES

[url removed, login to view]%28v=[url removed, login to view]%[url removed, login to view]

Færdigheder: PHP, Sharepoint, Software Arkitektur

Se mere: website debug software, volunteer experience, sharepoint job, library scenarios, standard library list, common services architecture, common query, list library, library standard, clear wire, call scenarios, sample job applications, microsoft sharepoint support, microsoft office sharepoint, software testing services, php introduction, wordpress website needs updated, sharepoint website, sharepoint site, sharepoint services, sample json data, protocol testing, process wire, cron command, php xml delete

Om arbejdsgiveren:
( 24 bedømmelser ) Redmond, United States

Projekt-ID: #6011344

Tildelt til:

cspeter

A proposal has not yet been provided

$526 USD in 10 dage
(3 bedømmelser)
4.4

8 freelancere byder i gennemsnit $921 for dette job

scriptphp87

Hello, I am a professional programmer for web programming with php language to build the system website, Besides, I also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer https://www.freelan Mere

$515 USD in 10 dage
(122 bedømmelser)
7.1
sveralex

A proposal has not yet been provided

$700 USD in 20 dage
(49 bedømmelser)
5.7
AppXonedotCom

Reviewed your project requirement and all three scenerio. Following projects are done by us: partners.emirates.com www.moe.gov.ae di.mofa.gov.ae www.msa.gov.ae As soon as you reply , we will be able to pro Mere

$1000 USD in 9 dage
(3 bedømmelser)
4.3
phamtech211

My team is really interested in this project as it is exactly within our scope of expertise: We are WEB application design & development experts. Please kindly visit our website phamtech.net to learn more about us and Mere

$2444 USD in 30 dage
(7 bedømmelser)
3.9
BrMiNdia13

Hi, I am Priyanka from Binary Resource Management. I would like to introduce our company that provides services of website design, website development, flash website design, website hosting, software development, g Mere

$526 USD in 10 dage
(1 bedømmelse)
2.3
vijaywebsolution

Hello, Placing a PlaceHolder Bid At Vijay Web Solutions Provide Assortment of Services and Skilled Staff For Your Offshore Project Requirement. We are Based In India. We have Good Expertise in Design a Mere

$670 USD in 10 dage
(4 bedømmelser)
2.0
prologics2

Hi, Greetings of the day and thanks for sharing these details and allowing me to bid on this assignment. yes we have similar experience and can deliver u as u have mentioned in your requirements. we already have Mere

$555 USD in 10 dage
(0 bedømmelser)
0.0
poojarajput09

Hello, Thanks for opportunity , ABOUT US "WEB GLOBAL IT" is a "DELHI" based Private firm that provides Website, WEB & Window System app, and Hosting & Networking services With a venture Of "DELHI" Host Mere

$504 USD in 10 dage
(0 bedømmelser)
0.0
bluerain05

A proposal has not yet been provided

$1000 USD in 14 dage
(0 bedømmelser)
0.0