Closed

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 [url removed, login to view]) – 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 [url removed, login to view]

1 – 2 [url removed, login to view]

1 – 3 [url removed, login to view]

1 – 4 [url removed, login to view]

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 [url removed, login to view])

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 [url removed, login to view] is merged into another [url removed, login to view] 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: Excel, Javascript, MySQL, Oracle, PHP

See more: source for accounting, problem in accounting field, problem in accounting, out source com, need sales persons, how to create accounting, found accounting, excel sheet for customer details maintain, excel sheet for customer details, excel out source, excell app, google excell, need an accounting person, sales order app, pastel, out source my app, google app sheets, excel 50/60, develop google app, develop after, danie, bi reports, develop manual, edit macro, develop tool

About the Employer:
( 0 reviews ) Pretoria, South Africa

Project ID: #5410394

8 freelancers are bidding on average £643 for this job

meet2amitvw

Let's discuss over freelancer Personal Message Box for the proper estimation of cost and time. I am myself doing programming so you will directly work with one person and that's me. No mediators. No managers. No sub More

£773 GBP in 10 days
(68 Reviews)
7.2
Teloquence

Consider it done. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.

£789 GBP in 0 days
(162 Reviews)
6.6
nirandas

Hello, The first thing to do will be create a web app (php5 + MySQL) where you can upload the exported excel file (csv) and the script will parse and update the db. Then All sorts of reports etc can be made from th More

£1000 GBP in 25 days
(81 Reviews)
6.1
wanggil

Hi, I have read your requirement carefully. I am an iPhone | Android software expert with rich experience. I have done many successful iPhone | android apps and games: single, multi-player, cocos2d, unity3d. A More

£1029 GBP in 10 days
(6 Reviews)
5.9
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

£333 GBP in 20 days
(50 Reviews)
5.3
drudev

Hello. I am a web developer with 11+-year experience . I work remotely on DigitalRay company - [url removed, login to view] - LA (USA). Technical knowledges: 1PHP JavaScript Ruby RoR ASP.Net C#, Zend, CakePHP, Symphony frameworks More

£777 GBP in 10 days
(24 Reviews)
4.7
AsifAliSE

-------------I am expert in this field . I will provide you 100% satisfaction .My aim is satisfaction .For previous work sample discuss project with me ....Many Thanks me in advanced for considering my bid --------- More

£763 GBP in 10 days
(20 Reviews)
3.9
ServingInfoSys

I am able to help you and complete this project as soon as possible and I have been working as a programmer for 10 years

£555 GBP in 10 days
(10 Reviews)
3.4
srdas2012

Hi, We are Expert in Word and Excel Macro VBA/VB6/VB.Net can bring almost VB6 in Macro. We have seen your Description understand the process ready to start We have delivered the following Excel Macro project More

£250 GBP in 10 days
(6 Reviews)
3.2
croca

Hello Jacquesdp1, I'm doing something very similar. Instead of converting Datasheets (XSLX, XLS or whatever) i'm extracting/converting data from an old Informix database, and uploading data into Oracle database. I'm an More

£666 GBP in 20 days
(0 Reviews)
0.0