Excel file upload to database

$30-250 USD

完了済み

投稿日:

約7年前

$30-250 USD

完了時にお支払い

We area real estate office that is looking to bring our agent referral system online. It is very simple system and more like a small database. Here is what we need. 1) The database will be updated once per month (maybe more), We keep track of all the agent referral amounts in Excel spreadsheet format. Offices have anywhere from 1 - 100 agents on average. 2) We have a few offices and agents probably don't want others to know how much they made. Would need a way when an agent signs up, we could add them. Thinking Name, Email, Real Estate License # (BK293811 sample format), List off offices (and way to add more (prefer drop down) Phone #, and password or a way to generate a password for the new user. When save is clicked, it then emails them. 3) When we add the monthly payouts to the database, we would like to separate them into offices So each user is assigned to an office. This is because each office is calculated once a month and put in Excel. This Excel file is then currently being emailed to the office manager or admin and they send it via email to the agents. 4) The back end / control panel. Option to add new or remove office, add / remove an agent from those offices and then a spot under each office that is in the system to upload the excel file. When the excel file is uploaded, it will then pull the data from the spreadsheet and add it to the agents from that office. Obviously mistakes happen etc, so would be nice to have a backend edit button so we can modify the data instead of having to upload a whole new spreadsheet. Not a huge deal though. Also the spreadsheet doesn't contain a date. We can either add a column for it (currently it is ###) or better yet, we can select the Month/Year, click browse and select the file to upload and then click upload. This will then have January 2017, Feb 2017 etc. That's pretty much it. Open to suggestions and features. The basic idea is the controller logs in the backend each month and uploads the new excel file. Then at anytime the agents can login to the system and see there payouts broken down into months and if possible total. I have attached out excel file that we would upload each month. We would have one for each office. Sounds more complicated then it actually is.. Just trying to explain everything> Looking to complete ASAP please. We do have webhosting will cpanel. through [login to view URL] and another account with [login to view URL] Submit all offers!!!

PHP

Software Architecture

プロジェクト ID: 13244024

プロジェクトについて

29個の提案

リモートプロジェクト

アクティブ 7年前

お金を稼ぎたいですか？

メールアドレス

Freelancerで入札する利点

予算と期間を設定してください

仕事で報酬を得る

提案をご説明ください

登録して仕事に入札するのは無料です

アワード者:

@MykolaDudych

Hello, I am interested in your offer and I am ready to cooperate. I have experience in writing scripts in php for Excel. I have experience in writing scripts in Javascript , php, mysql. I have experience in creating web app, websites, amendment to the sites.

$111 USD 5日以内

4.9

(13 レビュー)

4.0

この仕事に29人のフリーランサーが、平均$244 USDで入札しています

@NickolaS

Hello. I can make this simple CMS for you within 3 days. Actually, I would make this in 1-2 days, but tomorrow is my birthday =) So, if interested, just contact me and we will start right now. I'll require escrow payment, then will make the tool on my server, then you will confirm and send money, but I will place everything on yours. Please, reply in any case. Thanks in advance

$238 USD 3日以内

5.0

(396 レビュー)

7.9

@mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$237 USD 10日以内

4.8

(472 レビュー)

8.3

@darkwind

Hello, You have explained each functionality you wanted very well. The database schema will be created accordingly so that the data in excel file that will be uploaded will all be saved. The sample excel file you attached actually have dates. The date displays '###' because the column that contains the data isn't wide enough. ;) Looking forward to getting some feedback from you soon. darkwind

$444 USD 10日以内

4.8

(288 レビュー)

7.7

@Shopify

Hello, I want to show you all relevant Demo and Designs which is similar to your project completed previously. To make sure about the requirement set and customizations, I want to discuss this project with you further on personal chat. Let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, I use to be online 24x7 on Freelancer so probably you will get a quick response from my end. Following are my Expertise Area: 1)PHP with CodeIgniter and Laravel Framework. 2)Node JS 3)Angular JS 4)Mobile App Development Thanks

$257 USD 15日以内

5.0

(27 レビュー)

7.0

@pkjoshi

I have extensive experience in Web Development. Joomla, Magento, PHP Framework(Yii2) etc. I read you project and can tell you that I can deliver what you are looking for.

$1,000 USD 10日以内

5.0

(65 レビュー)

6.8

@shihan033010

Hi i have understood your requirements. I can complete the back end functionality within 8 days. please accept the bid and create the milestone. I am ready to start the project. Regards Shihan

$300 USD 8日以内

4.9

(329 レビュー)

6.9

@BitLabs

Hello, I have gone through your outsourced requirements "Excel file upload to database" and have analyzed that I have right skills (PHP, Software Architecture) to execute your esteemed project. I will complete your project within 3 days, LIFETIME error free guarantee and provide 365 days (ONE YEAR) support... ===== Why choose me? ===== 5.0 / 5.0 rating, 100% completion rate, 100% on-time completion, 100% on-budget :) Kindly, check my profile: http://www.freelancer.com/u/BitLabs.html I work smart, hard, and strictly bid only what we can do! No sub-contracting... ever! You will never go wrong choosing me :)

$232 USD 3日以内

5.0

(131 レビュー)

6.8

@RubyOnRail

$277 USD 10日以内

4.8

(17 レビュー)

5.9

@adeellhr786

i recently worked with some person who has business of estate, he wanted me to make an app , which tracks different location get gives analytics for locations how many people search this location , from google map, app website etcc etc, for this project , this is very simple and clear , i suggest you to try this sofwate of state as well i am a PHP/java se,ee C# developer these days i find extra time so i am here freelancing , i assure you once u work with me and then afterwards you will always look for me WHY u should give me the project ? because i am free right now and i will start working for u right now and deliver the work as soon as i am done

$250 USD 3日以内

4.8

(36 レビュー)

5.5

@Misujon3

Greetings! Hope you will not ignore my resume/cover letter or proposal letter whatever you mean it. Wish you could have spent some time to read this thoroughly. May be this will help you to get an eminent person or may be waste your time. Let me introduce myself first. I am a professional Graphics Designer along with Web design and Data Entry. I have competency on, Graphics Design based on these fields, Clipping path, Background Removing/Changing/etching, Image editing, Image Optimization for web, Image Enhancement, Portrait Retouching, Image Manipulation, Photo Restoration, Photo Retouch, Hair Masking, Color Correction, Creating Vector Image, Flyer /Brochure Design, Business card, Banner Design etc. And Web Design based on these fields, WordPress, HTML & CSS, PSD to responsive HTML to WordPress etc. I even worked with some clients as a Virtual Assistant and I have done well on all of them. So I can tell you confidently that Admin assistant or virtual admin is also one of my strong skill. Looking forward to hearing from you. And thanks a lot for your response. Thanks once again.

$150 USD 4日以内

4.8

(42 レビュー)

5.6

@nileshbakotiya

Hello I have gone through the details of your project and we find it well within our capabilities. I will give you 100% quality work As your need , we will Ready To start work,I can create and deliver the project very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this as per the information.I have skilled, expert programmers I'm position further. Waiting for your message then will start work immediately Thanks

$116 USD 5日以内

4.6

(49 レビュー)

5.3

@tkannanid

Hello Sir, I would like to work on this project and please have a conversation in detail to proceed further on this project. Thanks!!

$80 USD 3日以内

4.1

(4 レビュー)

2.0

@geniusbg

A proposal has not yet been provided

$138 USD 15日以内

0.0

(0 レビュー)

0.0

@ian06rosales

A proposal has not yet been provided

$277 USD 15日以内

0.0

(0 レビュー)

0.0

@lmontazeri

I have more than five years of programming experience.I checked your sample excel file and your application requirements. It is easy for me to implement. So, I will charge you less. I am also familiar with UX design to make your application handier and more user-friendly. You will love your newly designed application. I am looking forward to hearing from you.

$60 USD 3日以内

0.0

(0 レビュー)

0.0

@Rickytp11

I am a new user, so I will do my best to finish the job in the best way. Stay calm, I can do the job.

$188 USD 10日以内

0.0

(0 レビュー)

0.0

@lefty0911

I have a ready to go import feature for php , where you can import your excel sheet and map your fields from excel to php easily . I would just have to design the output . Once the system runs you can use a ready to go export feature already available to export back to excel . This can only run on a server . either localhost or your own or a website domain. 1. Do you have a website that can run php 2. or do you have your own server? 3. The agent can actually track this on website instead of exchanging excel report back and forth. but the option is available to import and export data . 4. I can do this in access database or MYSql. 5. Also security is available to form groups / like admin can see all records where agents can see only their records. easy to setup and there is an admin section to change or add groups. ( offices ) 6. Date can be added to filter out results. 7. I use PHPrunner - one of the fastest RAD tools in the world . 8 . American based freelancer. I would need contact info for questions and conversation about exact output needed.

$222 USD 5日以内

0.0

(0 レビュー)

0.0

@Innovotel

We are PHP and database experts, and have been creating custom PHP based solutions for the last 6 years. Our lead developer has more than 18 years developing in PHP and over 25 years developing databases. We can quickly deliver a solution that has multiple user roles (who can see what data) and multiple login and administration capabilities. While our bid may not be the lowest you will see, we will stand by our commitments and deliver a quality product that is exactly to your specification. Additionally, we have other clients in the real estate industry so we already have a fairly decent understanding of the market and your requirements. Thank you for your consideration.

$600 USD 10日以内