DEVELOP MULTI - SOURCE DATASTORE

CLOSED
Bids
9
Avg Bid (GBP)
£686
Project Budget (GBP)
£250 - £750

Project Description:
Accounting system called Pastel, this will not be changed and the solution has to be built around this.
Currently Reports are generated as follows.
1. Sales data is exported out of pastel to an excel sheet. Referred to as: Sales Data. ( see sales data 1 – 30 nov.xlsx) – This is the raw Data exactly how it appears when exported out of pastel.

However Sales Data must be exported out of pastel - the accounting system _ at least daily or twice daily - this can be done by making use of a Pastel data connector, - This data connector s for pastel is available, depending on which version of Pastel is being used. (Google - pastel data connection)

SEE A STEP BY STEP DETAILED EXPLAINTION can be seen by clicking on:

[url removed, login to view]

But for purposes of our “DATA HUB “ - The pastel data connector must be ignored.

THE SALES DATA FILLE WILL BE MANUALLY EXPORTED – DAILY. Example

1 – 1 nov.xlsx
1 – 2 nov.xlsx
1 – 3 nov.xlsx
1 – 4 nov.xlsx

A SOLUTION WILL NEED TO BE FOUND WHERBY THESE SHEETS IS EXPORTING INTO THE SAME FILE THE FOLLWING DAY OR SOMETHING BUT TO DO IT SEPARETLY DAY FOR DAY AS THE ABOVE EXAMPLE WON’T WORK!! Previously the sales data file where only done at least only monthly which enabled manual merging.

THE DATAHUB
THIS WILL CONSISTS OF VARIOUS DATA SOURCES based on data from multiple applications and platforms. THESE various different data sources need to be automatically integrated into one single automated Data store.
NB – In order to Generate a proper single sales data set: the following, DATA SOURCES need to be added, WHICH IS NOT PART OF the additional “Sales data x-y Nov.xlsx)
SEE THESE : CURRENTLY EXCEL SHEETS :

1. FACTORS – THIS IS THE AMOUNT OF KG PER UNIT – ( The Sales Data file straight from Pastel only consist of the units and seeing that all pricing etc. is done per/kg one will need to change this , see following explanation:

{ This is how the transaction looks in the sales data file


After it is converted, it looks as follows in the reporting tool

The Qty field is calculated by taking the units above – which is 60 and multiply it by the Factor which is 15 for this specific item. ( 60 units x 15kg per unit) = 900 kg as ]

2. LINK SALES PERSON TO CUSTOMER – EVERY CUSTOMER PASTEL CODE/CUSTOMER NAME RECORD MUST BE LINKED TO A PERSON RESPONISBLE
EXAMPLE:
Sales Person CUSTOMER PASTEL CODE CUSTOMER NAME
Jacques ALB001 Alberton frozen Foods


ADMINISTARTROTOR MUST HAVE THE OPTION TO ADD, EDIT, DELETE SALES PERSONS
With the following fields

NAME AFDELING CONTACT DETAILS
Jacques
Danie B
Dorne
Sales General



1. TO BE ADVISED: MY PROBLEM WITH THIS IS THE FOLLOWING:
All the sales data.xlsx is merged into another single.xlsx file,
Then your Factors is also added as a lets say Factor sheet, and every Customer linked to a person responsible sheet also , and and and …….

Now Let say you combine all this by means of a macro : into one nice EXCELL MACRO FILE:

This NICE MACRO ENABLED EXCELL SHEET -

1 – MUST BE IN CSV IF YOU WANT TO ADD DATA TO ANY SOURCE, WHICH MEANS THE HEADINGS MUST BE DELETED ETC ETC ETC.
2 – THIS MACRO ENABLED SOLUTION MUST “ RUN” MANUALLY BEFORE THE LATEST VERSION IS AVAILABLE
3 – THERE MUST BE SECURTY MEASURES – FOR EXAMPLE ONLY A ADMIINISTRATER CAN CHANGE THE SALES PERSON LINKED TO A CERTAIN CUSTOMER. AND SO I CAN GO ON AND ON AND ON AND ON.

In order for me to really get value out of this data to for example link it to a webbased realtime reporting tool –“ BI Platform”
Create and Maintain a stocksheet app zand and and and

The only way IS XLSX - MYSQL OR ..............

REFERENCES TO A SIMILIAR PROJECT SUCESSFULLY COMPLETED WILL BE REQUIRED.

REGards

Skills required:
Excel, Javascript, MySQL, Oracle, PHP
Qualifications required:
us_eng_1 US English - Level 1
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


£ 773
in 10 days
£ 789
in 0 days
Hire nirandas
£ 1000
in 25 days
£ 1029
in 10 days
£ 333
in 20 days
£ 777
in 10 days
£ 763
in 10 days
£ 555
in 10 days
£ 250
in 10 days
Hire croca
£ 666
in 20 days