Käynnissä

MSSQL Data Extraction to PHP site or similar - repost

Hello Freelancers.

We need to build a custom feature for our existing warehousing system InFlow Inventory.

What we need done is a system/script which every day at a certain time calculates how much space our customers use in our warehouse.

How can this be done?

Every product in our warehouse is entered in our warehouse system and stored in a MSSQL 2005 database.

The product is stored with length, height and width and m3 per. product.

Customers should pay per m3 (cubicmeter) they use in our warehouse.

Every customer has their own assigned "Location" in our warehouse system, so what we need is a system/script that every day calculates the total m3 usage of every location.

System/script should "list" all items in a location of the MSSQL database, take the m3 usage of every item in the database and multiply it with the amount of the item in stock.

All stock should then be put together and the total m3 usage of this specific (customer) location should be outputted into a list for every date of the year.

It is very important that the system/script is able to automatically search and check for new locations added to the MSSQL database BEFORE the list for the day is generated.

Please see attached example for an idea of how the output should look like. Output could be a .php page or similar.

We are able to provide a test enviroment with a copy of the actualy database.

Our warehouse software is InFlow Inventory ([url removed, login to view])

Looking forward to hearing from freelancers who can do this project.

Martin Brandt

Brandt Logistics

Taidot: HTML, MySQL, PHP, SQL

Näytä lisää: sql inventory system, site freelancers com, logistics freelancers, how to use freelancers com, how to search for freelancers, height and length, freelancers output, freelancers customer page, example of inventory database, a site for freelancers, how to take a test, freelancers site list, warehouse system, warehouse inventory, sql freelancers, mssql, M3, database extraction, data warehousing, c# MSSQL, mssql stored, similar stock, much similar, inventory mssql, sql stock inventory

Tietoa työnantajasta:
( 0 arvostelua ) Riyadh, Saudi Arabia

Projektin tunnus: #4230704

19 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$399 USD 7 päivässä
(270 arvostelua)
8.0
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our Lisää

$300 USD 20 päivässä
(59 arvostelua)
7.4
phpgenin

i can help you with your script.

$300 USD 7 päivässä
(83 arvostelua)
7.1
abhius

100% PROFESSIONAL AND READY TO START.

$399 USD 3 päivässä
(122 arvostelua)
6.6
biddyweb

I have experience in data warehousing applications. I can implement a solution using c# and run the application as a windows service. Kindly contact me and lets discuss more.

$300 USD 5 päivässä
(17 arvostelua)
6.1
mickeylee112

###Expert is here!### I can do that,sir! I'm ready! I'm a full time developer. check private message! kindly regard my message. I will wait for your reply, sir.

$350 USD 10 päivässä
(93 arvostelua)
6.1
feninsoftech

Hi, I have 8 years experience in SQL Server. This can be achieved by writing a stored procedure and calling this stored procedure from a application( C#/ASP.NET etc.).

$250 USD 5 päivässä
(29 arvostelua)
6.0
alrazon

Read your details and interested to work, thanks.

$250 USD 15 päivässä
(39 arvostelua)
5.4
AmGlobaltechs

were is the attachment?

$450 USD 10 päivässä
(52 arvostelua)
5.3
sthakral

Hi Martin, Assuming you have access to MSSQL server, this is a very simple exercise. Please see PMB.

$250 USD 2 päivässä
(6 arvostelua)
4.5
goelvivek

Best quality work will be provided.

$250 USD 7 päivässä
(4 arvostelua)
3.2
ShadowMaster971

I can do it, just waiting you to start

$400 USD 21 päivässä
(3 arvostelua)
2.2
vanpham

I am interested in this.

$750 USD 90 päivässä
(5 arvostelua)
2.0
sorinpanduru2189

Hello, I have great experience in data manipulation and report generation. Please see PMB.

$325 USD 5 päivässä
(2 arvostelua)
1.2
oneinfosolution

Please see the personal message board

$750 USD 20 päivässä
(0 arvostelua)
0.0
ejivan

I can do this project quite well. Let me know and I will get started.

$250 USD 10 päivässä
(0 arvostelua)
0.0
artsiavi

I am experience programmer in SQL and script

$350 USD 5 päivässä
(0 arvostelua)
0.0
queen1

Ready to start!!

$250 USD 7 päivässä
(0 arvostelua)
0.0
gimli2

I have done similar project based on PHP&MSSQL for automobile industry (intranet application providing periodically stats & reporting of produced elements in stocks).

$250 USD 2 päivässä
(0 arvostelua)
0.0