Integrate web products through a WP site, build a database and Admin Panel -- 2

Cerrado Publicado Dec 9, 2015 Pagado a la entrega
Cerrado

We are building a portal to map out a market. We want to use third party products to manage login's, gather and publish data. The primary driver is a cool UX - and self service. 

We will build what we have to, but are pursuing a No Stack approach. Please go through the No Stack slides before replying.

[url removed, login to view]

The build will be 

design back end database to house and manage the data

Create an Admin panel to access, report on and manage the data. This will be simple Approve/Publish capabilities. We will use the client tools below for normal 'CRUD' capabilities

Connect Typeform - all forms to gather/edit data - share with users and capture data on and offline.

MapBox - GIS publish to the web, slice,dice, drill down. filter

AuthRocket - log in's, user community management, social log in

Zoomcharts - cool charts, map overlays and dashboarding and reporting

Love Zapier - not hung up on it though - would prefer it

Connect these tools to the back end through API calls to the database - as well as pass authentication tokens.

Users will be able to Create, Read,Update,Claim records.

The site will be a WP multisite (mostly set up)data will be exposed through the web portal. Users must be able to slice, drill down, select and filter data to a high degree.

Data volumes will be low - launching with 6K records and growing to 16K clean records. 

The database will also be used to house and clean data we are gathering. We have 20K records to clean and will need some basic logic here to help with this - deduping/name look ups and matching users to companies. We add about 1K of records a week to the dirty data. The data structures and processes will be relatively simple, it is not a true transactional system - it is clean/gather and publish process - do the data will look more like an ODS (operational data store) or a 'flat' dataware house than a transactional relational design.

The data will focus on companies primarily, with user records as secondary records and market data as the tertiary layer. 

Phase 1 go live will be Company and Personal profile records - market records to come later. We have fourteen forms used to capture data - these will be in Typeform - building the first Seven is part of the brief. The forms are very similar.

We will deploy through a WP multisite - but light WP skills required - and may get them somewhere else if you don't have them.

We will host on Azure and would prefer an SQL design - but not hung up on this.

If you have a market map already built inside a third party tool, like CRM - very open to hearing about this. Will consider a small number of paid licences or open source. If this is built or bought - we need 'ok' back end admin capabilities.

First principle - don't write code if third party tools exist 

Second principle - UX is key, 'cool' will beat complexity of API call integration

Third principle - self service is the goal for us, we are a small business and want to be able to enhance/customise/extend what we have without using developers. The tools we have selected are cool, have a great UX and offer us a large degree of autonomy. If you have other tools you think look better - tell us.

If you are a dev shop and want to build everything from scratch - please don't reply

We are using this project to validate the No Stack principles - to prove we can do it and it works and looks great - so need people that are thinking about the future of the dev market and not hung up on the old way of doing things

Desired Skills PHP, API Development, SQL Azure

Azure NoSQL Couch y Mongo PHP SugarCRM

Nº del proyecto: #9084968

Sobre el proyecto

2 propuestas Proyecto remoto Activo Jan 15, 2016

2 freelancers están ofertando un promedio de $7 / hora por este trabajo

gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo Más

$7 USD / hora
(379 comentarios)
7.9
itwsdevelopers

Hello Thank you very much for your invitation. We have gone through your requirements and would like to offer my services for the same. We will make perfect design as per your requirement We have following Más

$7 USD / hora
(0 comentarios)
0.0