DEVELOP MULTI - SOURCE DATASTORE

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 [login to view URL]) – 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: [login to view URL] 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 [login to view URL] 1 – 2 [login to view URL] 1 – 3 [login to view URL] 1 – 4 [login to view URL] 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 [login to view URL]) 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 [login to view URL] is merged into another [login to view URL] 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