| |
|
|
Job Summary:
|
| |
| Job Type: |
Project |
| Budget: |
$ 100-250 |
| Required
Skills: |
,
|
| Attached
Files: |
Convert_spec.xls
|
| |
|
| Status: |
Work Performed (selected user Sandev)
|
| |
|
|
|
Buyer Summary:
|
| |
| Username: |
|
| Feedback Score: |
        
3
reviews
|
| Award Reliability: |
3 posted 3 paid |
| |
|
| Location: |
London, United Kingdom
|
| Member Since: |
March 7, 2010 |
| |
|
|
|
| Invited Users: |
There are no invited users
|
Description
Transfer Excel rows to multiple Tables in SQL2005 using asp.net (vb)
To be able to take an excel sheet and for each row INSERT or UPDATE multple tables depending upon the column.
There are only about 2200 rows of 200 columms and 5 tables updated but I'd like the automation to assure accuracy. Only about 65 of the columns will be used to update any of the tables.
There are three data transformations used in a number of fields. The first uses a Regular expression to replace all non standard alpahnumeric with "-", i.e. "/[^a-zA-Z0-9]/", "-" The second one requires 0 tranforming to 1 and 1 transforming to 0 The third uses a fixed text string as a part of the Select of "TableF"
Processing will be to Read each row and : For Columns relating to "TableS" Check if the record exists, Update or insert the data For Columns Relating to "TableR" Check if the record exists, Update or insert the data The ID generated by an insert or select will be used a a foreign key in "TableD" updates For Columns Relating to "TableD" Check if the record exists, Update or insert the data The "TableR" ID created or found will be inserted into the "TableD" record The ID generated by an select will be used a a foreign key in "TableL" updates
For Columns Relating to "TableL" Check if the record exists, Update or insert the data The "TableD" ID created or found will be inserted into the "TableL" record The ID generated by an insert or select will be used a a foreign key in "TableA" updates
For Columns Relating to "TableA" Check if the record exists, Update or insert the data The "TableL" ID created or found will be inserted into the "TableA" record The ID generated by an insert or select will be used a a foreign key in "TableF" updates
For Columns Relating to "TableF" Check if the record exists, based on a combination of "TableA" ID and column name Update or insert the data The "TableA" ID created or found will be inserted into the "TableF" record
If this is to be automated I will need a quick response and quick turnaround.
The attached sheet demonstrates the contents to be imported. It extends to Column:EL Row 3 indicates the type of data which may be encountered. Columns without headings will not be processed.
I have available the database schema and sample XLS to interested parties.
Additional information:
Submitted on 03/07/2010 at 9:13 EST
Attachement Added
Reminder
You may not start working in this and any request before
your bid is accepted. Users who violate this policy
may have their accounts permanently suspended.
|
| Un-Decline Bid |
|
|
Ahmedabad,
IN
location |
US$190
bid amount
|

         
(72
reviews)
feedback |
19 day(s)
delivery time |

|
| |
| Decline Reason: Did not address my project requirements |
We are specialized for web-design and development using HTML, XML, JavaScript, CSS, AJAX, ASP, PHP, ASP.Net C#.Net or VB.Net , with Ms-Access / MySQL / Ms-SQL -2007 / Oracle.
Our design and multimedia expertise including Photoshop / Fireworks / CorelDrow / Dreamweaver and Flash 8.0
We are selective about the jobs we approach, taking into careful consideration the talent and expertise we have on hand to fulfill your goals.
Bid Time: 03-08-2010 09:36
|
|
|
|
| Un-Decline Bid |
|
|
kolkata,
IN
location |
US$150
bid amount
|

         
(54
reviews)
feedback |
12 day(s)
delivery time |

|
| |
| Decline Reason: Did not address my project requirements |
Hello,
I have done this type of work previously and can do it. I do not find any attached sheet.
Please open chat session so that we can discuss and start the work.
Thanks
SM
Bid Time: 03-07-2010 08:57
|
|
|
|
| Un-Decline Bid |
|
|
Indore,
IN
location |
US$250
bid amount
|

         
(21
reviews)
feedback |
6 day(s)
delivery time |

|
| |
| Decline Reason: Bid is too high |
Please open chat for further discussion...
Bid Time: 03-07-2010 12:58
|
|
|
|
| Un-Decline Bid |
|
|
kolkata,
IN
location |
US$230
bid amount
|

         
(15
reviews)
feedback |
25 day(s)
delivery time |

|
| |
| Decline Reason: Did not address my project requirements |
“SEARCHING FOR THE RIGHT MATCH†we’ve been working in web development industry since last 4 years. We are committed to deliver the highest level consulting and development services.
Read your requirement and everything has been understood. We have already delivered a couple of similar projects and given our strong capabilities. I am confident we can deliver a powerful end-result to you as well.
Our prime objective is client satisfaction and fulfills their needs with unlimited efforts.
WE DO : * work personally with you ; during business hours through the communication means by your choice ; in simple English, to ensure a concise implementation of your satisfaction ; into 100 % W3C compliant and validate ( optional ) clean ; efficient web coding and design.
WE DON’T : * talk sweetly and give assurance and give wrong commitments.
Bid Time: 03-07-2010 11:11
|
|
|
|
| Un-Decline Bid |
|
|
Abbottabad,
PK
location |
US$100
bid amount
|

         
(42
reviews)
feedback |
3 day(s)
delivery time |

|
| |
| Decline Reason: Did not address my project requirements |
Sir:Can do it upto your utmost satisfaction.Waited to be interviewed by you via chat. thanx, Kind Regards.
Bid Time: 03-07-2010 13:49
|
|
|
|
| Un-Decline Bid |
|
|
kolkata,
IN
location |
US$200
bid amount
|

         
(34
reviews)
feedback |
10 day(s)
delivery time |

|
| |
| Decline Reason: Reason not provided |
yes i can do this.Please open the pm for details.
Bid Time: 03-08-2010 00:59
|
|
|
|
| Un-Decline Bid |
|
|
Dhaka,
BD
location |
US$250
bid amount
|

         
(24
reviews)
feedback |
5 day(s)
delivery time |

|
| |
| Decline Reason: Bid is too high |
we are able to do this, pls open chat option for more details ....
Bid Time: 03-07-2010 13:32
|
|
|
|
| Un-Decline Bid |
|
|
Dhaka,
BD
location |
US$130
bid amount
|

(No Feedback
Yet)
feedback |
7 day(s)
delivery time |

|
| |
| Decline Reason: Did not address my project requirements |
I have an IT firm. My team can handle any kind of job. We are very expert about free lancing job. Now in my team has near about 220 employees
Bid Time: 03-07-2010 13:17
|
|
|
|
| Un-Decline Bid |
|
|
India,
IN
location |
US$200
bid amount
|

(No Feedback
Yet)
feedback |
25 day(s)
delivery time |

|
| |
| Decline Reason: Service provider did not have necessary expertise |
I have 7 Working Experince in DEsktop as well as Web Applications and WebServices.
please give me Work Oppertunity.
Thanks.
Bid Time: 03-07-2010 14:55
|
|
|
|
| Un-Decline Bid |
|
|
Ahmedabad,
IN
location |
US$200
bid amount
|

(No Feedback
Yet)
feedback |
5 day(s)
delivery time |

|
| |
| Decline Reason: Did not address my project requirements |
Dear Buyer,
We are the team of 15-20 People including developers and designers.
Our team includes experienced persons in field of different
technologies. Our Customer set belongs to Europe, USA , Australia and
many other countries around the Glob. We are providing our services to
many different and advanced technologies. Our work field includes CMS
(Content Management System), Web Technologies, Application Software
Development and Real-time Software development. We have more than 7
years of experience to work with Joomla, Drupal, Wordpress, Magento,
VB.net, C#.net, ASP.net,JAVA, J2ME, JSP, VB, PHP, MySQL, MSSQL, C,
C++. Visit our portfolios to know about my work and We are not a
premium member of GetaCoder so can't add more then 5 portfolios.
Please connect via chat for further discussion.
Thanks
Regards
Softcoder05
Bid Time: 03-07-2010 22:01
|
|
|
|
| Un-Decline Bid |
|
|
CENTREVILLE,
US
location |
US$100
bid amount
|

(No Feedback
Yet)
feedback |
5 day(s)
delivery time |

|
| |
| Decline Reason: Did not address my project requirements |
We are .net certified professional. We are 5 years DBA exp at SQL Server 2005/2008. Please accept our bid or chat with us. We will provide 100% solution. you can pay us once we complete our work.
Bid Time: 03-08-2010 07:00
|
|
|
|
| Un-Decline Bid |
|
|
Singapore,
SG
location |
US$200
bid amount
|

(No Feedback
Yet)
feedback |
4 day(s)
delivery time |

|
| |
| Decline Reason: Bid is too high |
Hi There,
I have reviewed the requirements.
Confidently offer willingness to finish this easily.
Thank You
Bid Time: 03-08-2010 10:01
|
|
|
|
| Un-Decline Bid |
|
|
jaipur,
IN
location |
US$140
bid amount
|

(No Feedback
Yet)
feedback |
8 day(s)
delivery time |

|
| |
| Decline Reason: Did not address my project requirements |
i can help u to complete it
Bid Time: 03-08-2010 10:14
|
|
|
|
|
|
|
|
| |
| Get the Free
Step-by-Step Guide on How to Use GetACoder |
The act of
outsourcing jobs has become easy in the past few years
thanks to GetACoder. However, our team aims at making the
whole process even easier. So, it has now come the time to
provide you with a step-by-step guidance on how to use this
service and succeed in the outsourcing world totally for
FREE.
It doesn't matter if you are a more experienced user or a
novice; using GetACoder will become even simpler with the
help of this E-book. There are two major sections: a Buyers
section and a Coders section.
Buyers will learn:
- How to outsource safely
- How to pick the best freelancers
- How to manage time and money
Coders will learn:
- How to get the best jobs
- How to secure their payments
- How to build a long-lasting relationship with buyers
...and MUCH MORE
Clear examples and pictures illustrating key situations,
great tips and real testimonies of some of our best users...
all in this Outsourcing Guide. So don't loose the
outstanding opportunity to download GetACoder FREE E-book.
|

 |
|
GetACoder is a leading Global Services Marketplace doing business in more than 200 countries. Our unique system accelerates your time to market and provides your business with key competitive advantages. When you use GetACoder you are stretching your budget and saving as much as 60% over traditional outsourcing. GetACoder is changing business, now it's no longer about what you own or build but which resources and talent you can access. With GetACoder you reduce expenses, increase efficiencies, aggressively grow your business, and create a sustainable competitive advantage. GetACoder makes outsourcing to any part of the world an easy task! With GetACoder it's simple to outsource any business request, gain access to global talent and manage jobs online. One of the main advantages of GetACoder is the low labor cost. The typically rates are about seven times lower than the ones in the US or Europe. Posting a request at GetACoder allows the right professional or company to find you and to bid for your work. We are building a reputation for exceeding our customers' expectations and for becoming an extremely cost effective way to outsource work. Use GetACoder when you want to save money, increase efficiency or accelerate the development of your request. With GetACoder you focus on growing your business and let others do the tedious work. Post your request on GetACoder for free. Find out why people outsource jobs with us day after day. Thousands of Satisfied Customers - Submit/View Quotes
| - | No matter what the project, GetACoder has always pulled through. There really are some great designers providing quality work at competitive prices here. This truly is my one stop shop - | | - | I love to bid on GetACoder, its a good site for posting projects as well as getting income for me. Thanks GAC - | | - | I greet GetACoder because it's a great website. - |
|
|
| |
© 2004-2012 GetACoder. All rights reserved. |
|