Find Jobs
Hire Freelancers

Auto Create Web Forms

$500-5000 USD

クローズ
投稿日: 16年以上前

$500-5000 USD

完了時にお支払い
Phase I Create web form to collect information from possible candidates to be on a TV show. Data submitted through this form would need to be stored in a database, csv or tab file. An employee would need to be able to download this data in csv or tab format to be imported into a proprietary FileMaker Pro database. The employee would probably download data 1 ??" 2 times per day to be imported. It is important that duplicates are not imported into the FMPro database. Each time an employee downloads the form data, only data added since the last download should be available for export. Each entry should have an ID number used to track and keep reference incase of an error. If necessary the employee should be able to also download the entire dataset or to specify a date range. Web form needs to use the same design and style of current website. Currently we are running PHP and MySQL. Current sample document with questions is about 17 pages long. A copy will be provided to bidders that are under consideration. Phase II Going forward we will need to create new web forms for new shows. Each form will have different questions. We need the ability to create new web forms dynamically for each show as there will be different questions. It would be convenient for us to upload a CSV or XLS file with all of the questions in “COLUMN1?? and use “COLUMN2?? ... (continued) ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). * * *This broadcast message was sent to all bidders on Thursday Dec 13, 2007 1:31:23 AM: (continued...) as a descriptor for the different types of questions. For example (singe line, multi line, multiple choice (1 answer), multiple choice (multi answer), question required/optional, yes/no, true/false, etc… There are many companies that do a similar service. Most of the current services either require questions to be manually created (too long if form has 50+ questions) or some companies have tools to convert XLS to a web from. However the conversion tool usually requires Windows operation system and we only use Mac’s so we need a server based solution. * * *This broadcast message was sent to all bidders on Friday Dec 14, 2007 2:57:31 AM: ***Project Update*** Thank you for your repsonces. Please note that I am only interested in coders who have actually posted a responce directly related to this project. To those of you who have taken the little bit of time to actually write a message to me I thank you again! All other coders who just blasted me with your accomplishments are not likely to be chosen. I need to see the actual interest you have in my project and not a copy of every website you ever designed. I am compiling a list of all of the questions I have received. I will answer each question and broadcast this list to all coders that under consideration. * * *This broadcast message was sent to all bidders on Friday Dec 14, 2007 2:58:30 AM: ***Project Update*** Thank you for your repsonces. Please note that I am only interested in coders who have actually posted a responce directly related to this project. To those of you who have taken the little bit of time to actually write a message to me I thank you again! All other coders who just blasted me with your accomplishments are not likely to be chosen. I need to see the actual interest you have in my project and not a copy of every website you ever designed. I am compiling a list of all of the questions I have received. I will answer each question and broadcast this list to all coders that under consideration. * * *This broadcast message was sent to all bidders on Friday Dec 14, 2007 4:05:28 AM: Q&A ROUND 1! Forgot the attachemnt! [login to view URL] * * *This broadcast message was sent to all bidders on Friday Dec 14, 2007 4:05:58 AM: Q&A ROUND 1! Forgot the attachemnt! [login to view URL] * * *This broadcast message was sent to all bidders on Friday Dec 14, 2007 11:51:29 AM: Q&A ROUND ONE! Q>> I need to understand what you are trying to do, not necessarily from a technical perspective, but from a simple, business or common-sense perspective? A>> This form will be used to collect data from possible candidates for a TV show. We do casting for many shows and need an easy/dynamic way to create these web forms. I know there are thousands of companies that already do this however this requires that every question be manually typed and formatted on a page. These forms could contain 25 ??" 100 questions easily so I need the ability to import the questions. There are also companies out there that offer an Excel Add-In to auto convert a spreadsheet to HTML form however we use Apple computers and 99.9% of these are designed for PC’s ??" plus I prefer a server based solution. Throughout the day someone will want to download the answers from the form in CSV format to import into out File Maker Pro database. It is important that once a completed form has been downloaded that the same data is now downloaded again (or we will have duplicates in FMPro). However we will need the ability to override that normal rule sometimes and either download all forms submitted or all forms within a date range. Q>> Please provide sample questions. A>> Please see attached sample questionnaire. This one is done in word format. You will notice that there are lots of disclaimers, guides and instructions. We will need to be able to upload this information as well. Also the form should probably be broken up into multiple pages and or sections. This will allow each group of questions to be partially saved in the database. Q>> I will also need to understand the range of the number of questions you intend to compose. For example, can we go up to 500 questions? A>> 25 ??" 100 on average. Q>> Let me also know if you would like to be able add, modify and delete questions via a web interface (although I am almost sure that this is what you want). A>> This would be a great feature however usually these forms will have been pre-approved before being placed online. We should probably save this for a future Phase III option as this will increase project cost and time. Q>> As for storing answers, kindly also explain what you would like to do with stored answers if you delete or modify, for example, the corresponding question. (example: You create a question 'What is the color of your eyes'. So this is a stored question in the database. So you have a person answer the question via the web, say Joe, and he enters 'blue' for the above question. Then, the following day, you decide to change the question to 'What is the color of your shoes'. After you've modified the question, the corresponding answer that Joe provided is now incongruent with the modified question. So how do you envision that this exception be handled?) A>> This would be best handled (if implemented) by not actually deleting or modifying the original question but by hiding it and creating a new question with a new collection of answers. Q>> It would help a lot if you can provide more information on what it is that you're trying to achieve. Give me a more complete picture of your situation and your goals, so to speak. A>> See first question. Basically non-web programmers should be able to create a form in Excel and then upload to auto create the web form without the need for a programmer every time. Q>> What kind of questions are these, are these school exam questions, company interview questions for potential employees, survey questions for marketing purposes, and so on. A>> The are questions for possible candidates to be on a TV show. Q>> How many kinds of employees are you expecting to be able to create, modify, delete questions, what kind of format are you expecting the stored answers to be in (with or without the created questions and so on). A>> Again create/mod/del shouldn’t be needed for this project right now. Storing the answers is up to you. Just make sure it works! We currently have a Linux server running Apache and MySQL. We expect to download files to import into FMPro in CSV or TAB formats. Q>> Are you particular in the interface of the questions and/or answers, i.e., do you want to see 'pretty' web pages designed for you? Will this be a part of a bigger existing website? If so, where is the website located? A>> Not so much pretty.. overall page interface should mimic our corporate website (sample provided). We will link to these pages from our main website. Q>> The people who will answer the questions you create, will you require them to log in with a username and password? A>> Yes, we will want to create a profile for each person filling out a form. I would prefer to use their email address as the username and they can create a password. This is so they can start filling out a form save it and come back later to finish it up. It is possible that some of the same people will fill out a form for one show then fill out another form for another show later on. In the future it might be nice to have a master database that holds all of this data. That way the (basic) questions could be pre-filled in and only need to be updated or verified. Q>> You have not even specified that should both the phases quoted in this bid or not? A>> Yes, this project is for both phases. Although Phase 1&2 are really together. Phase 2 is designed to accomplish Phase 1. My though process was backwards during the initial typing of this project. I started out needing a form then realized that I need a way to automatically create that form instead. Q>> Will you use the dynamic form generation in phase 1 or forms of phase 1 will be coded statically by us? A>> The dynamic generator should be used to create the initial form. It is possible that I may need a working form before the generator is completed and working. In that case I will need the form manually created the first time. I will have a better idea about this tomorrow. Q>> In phase 2 I guess you want to use XLS files to generate forms from them. may I see sample XLS file? Will XLS file format be Excel format or some other Mac format? A>> I have created a dummy XLS file as an example. This is not set in stone on how it will work but it is a starting point. Please note that in the questionnaire we request that all field be filled in. If they are not applicable then the applicant should enter “N/A??. This needs to be incorporated into the web from some how. Maybe when they click to the next page we pop-up a dialogue that says all blank fields will be filled in with “N/A?? and then they can go on to the next page. * * *This broadcast message was sent to all bidders on Wednesday Dec 19, 2007 12:57:29 AM: Please let me know if anyone has anymore questions. I will choose a coder tomorrow. I will not consider coders without a bid. ## Platform Server: Linux / PHP / MySQL Client: Windows, Linux, OS X Browsers: IE, Firefox, Safari
プロジェクト ID: 3556135

プロジェクトについて

12個の提案
リモートプロジェクト
アクティブ 16年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
12 freelancers are bidding on average $1,086 USD for this job
ユーザーアバター
See private message.
$1,657.50 USD 10日以内
5.0 (124 レビュー)
8.7
8.7
ユーザーアバター
See private message.
$425 USD 10日以内
4.9 (176 レビュー)
6.9
6.9
ユーザーアバター
See private message.
$2,720 USD 10日以内
4.8 (116 レビュー)
6.6
6.6
ユーザーアバター
See private message.
$1,094.80 USD 10日以内
4.9 (80 レビュー)
5.9
5.9
ユーザーアバター
See private message.
$425 USD 10日以内
5.0 (12 レビュー)
3.6
3.6
ユーザーアバター
See private message.
$425 USD 10日以内
4.8 (14 レビュー)
3.5
3.5
ユーザーアバター
See private message.
$425 USD 10日以内
4.7 (21 レビュー)
3.3
3.3
ユーザーアバター
See private message.
$425 USD 10日以内
5.0 (6 レビュー)
1.9
1.9
ユーザーアバター
See private message.
$510 USD 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
See private message.
$3,825 USD 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
See private message.
$425 USD 10日以内
0.0 (0 レビュー)
0.0
0.0
ユーザーアバター
See private message.
$680 USD 10日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

UNITED STATESのフラグ
United States
5.0
3
メンバー登録日:5月 22, 2007

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。