Suoritettu

Import TXT/CSV into MSSQL Table with mapping of fields (PHP Portal)

Hello all, I have an existing PHP portal. I am looking for a developer to code up my file import page. I have attached some reference files.

On import, it will get the mapping/rules from a table for that import scheme selected. You will see the rules for each field in MappingRules.txt.

This is specific to LoaderID=3. The "LoaderField" tells you which column in the TXT to use.

As an example take "+447542702658"

You will see 3 rules.

1. Remove "

2. Replace +44 or 44 with 0 at start of field

3. Replace all instances of Rule value 1 with value 2

This will convert the field to... 07542702658

After applying all the rules, it will then insert all rows into a MSSQL table. The table is already created. I can give you more details in PM.

Thanks

Taidot: HTML, MySQL, PHP, SQL, verkkosivujen suunnittelu

Näytä lisää: php import export csv, php convertire txt csv, mssql free import tools csv, import data from excel to sql server using query, sql server import and export wizard data type mapping, import data from excel to sql server automatically, excel to sql insert, how to import data from excel to sql server, sql server import csv into existing table, inserting data from excel to sql table, import csv file into sql server management studio, php mysql html table empty fields, import csv sql table vbnet, asp import csv mssql, convert txt csv php, convertir txt csv con php, script import map csv database php, ajax table add fields php, import csv file table sql server 2005 express, php import txt

Tietoa työnantajasta:
( 114 arvostelua ) London, United Kingdom

Projektin tunnus: #18754400

Myönnetty käyttäjälle:

RockStone435

Hello, Nice to see your project posted here. I have read details. As far as I am getting you, you want to create an import process which can be used to import the CSV/TXT file into your database. I understand that t Lisää

£70 GBP 3 päivässä
(619 Arvostelua)
8.8

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

claudiu07

Hi, I have extensive experience working on custom CMS/web applications in PHP/MySQL. I'll be happy to help you out. Cheers.

£144 GBP 3 päivässä
(50 arvostelua)
7.3
widadsaghir1993

Hi there. As php and mssql expert, I am very glad to see your project. Just read your job description and attached files with care. and I think it's very suitable project for me. If you give me your project, I can Lisää

£150 GBP 3 päivässä
(94 arvostelua)
7.0
virals2583

Hi there, I will write such script that read the rules, logic, update the record and insert into your mssql database. I have done many custom web solution having Mysql to CSV, SML/CSV/JSON to mysql and more complex Lisää

£150 GBP 3 päivässä
(51 arvostelua)
7.0
topithub

hello, We can create this import functionality for your website. We can create detail import feature so you can map csv fields with db fields and will also add other features that can ease your work.

£150 GBP 3 päivässä
(33 arvostelua)
6.4
shaktistanwar

Hi I am a technical evangelist, developer and can do this task for you. I have more than 12 years of experience in software development and am a microsoft certified professional.I have strong work experience in Reac Lisää

£150 GBP 3 päivässä
(32 arvostelua)
6.4
michealperfect

Hi Sir, I hope you are well. I have gone through your requirement we can do that for you. Please message me so we can discuss more. I am waiting for your reply. Thank you. Michael

£250 GBP 5 päivässä
(160 arvostelua)
6.7
asadrana91

Hi there, this is Asad. I have a vast experience in web development tasks. I have understood your requirements and I believe the task can be achieved with javascript/jquery. We can add a validation before the data is b Lisää

£150 GBP 5 päivässä
(62 arvostelua)
6.4
pbelhe9

Hello. How are you? Thanks for your good description of project and I understood what you need. As an web expert. i have strong skills and experiences in web development for 7 years. I hope work for you because my Lisää

£150 GBP 3 päivässä
(42 arvostelua)
6.5
Lavlu

Hi, I'm a Professional Web & Software Developer, having 13+ experienced in PHP Portals and able to do your all specified requirements. I've see your attached files and I can Import TXT/CSV into MySQL Table with mappi Lisää

£144 GBP 3 päivässä
(36 arvostelua)
6.9
lovethomas1026

Hello! Thanks for your post. I read your requirement carefully. I have rich experienced in txt and csv importing. If you give me a chance, I will satisfy you with good result. Please check my profile. I will wait Lisää

£150 GBP 3 päivässä
(70 arvostelua)
6.3
pakistansolution

Hello.! I'm a full stack web developer. I'm a great command on PHP. I have so many years of experience in core PHP. Please check my recently done project for PHP https://surmawala.pk. I'll do fast work and quality work Lisää

£200 GBP 3 päivässä
(63 arvostelua)
5.7
brightstar928

⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ Hi I read your job description carefully and I can do your job perfectly. I have developed many websites So I can know what you mean and I am ready for you now. If you hire me, I will finish your job A Lisää

£100 GBP 3 päivässä
(36 arvostelua)
5.7
shuochenyu

Hi, I feel comfortable to work on this project as I have extensive experience with such job. Recently I finished very similar job on freelancder. https://www.freelancer.com/projects/php/Script-for-Sort-phone-numb Lisää

£150 GBP 3 päivässä
(13 arvostelua)
5.7
ravi663

Hello Dear, Hope you are doing good! I have gone through your description I must say I can help you to import the table and mapping with fields.. I can definitely give you the best solution as I believe in Standard Lisää

£300 GBP 3 päivässä
(45 arvostelua)
5.4
ludiac

Hi there, We have reviewed the details of your project. Really easy to understand, thanks for the technical description. It can be code within a couple of days. Please ping us anytime to get started with discussion. Lisää

£150 GBP 3 päivässä
(18 arvostelua)
5.6
rabhardwaj

I mainly work with API Integration project.I have passion about API. I have been in this field for more than 7 years. i have experience in C#,php,Perl,wordpress,Html,postgress ,Ubuntu,Crontab,Web Services, Rest Api, Lisää

£150 GBP 1 päivässä
(13 arvostelua)
5.3
soshiv

Hi, I can help you to create a script according to this rule. please come over chat and discuss in details. Thanks. ....

£122 GBP 3 päivässä
(30 arvostelua)
5.0
Dmitry610

Hello Employer, Greetings for the day! ⭐⭐⭐⭐⭐ I CAN START IMMEDIATELY ⭐⭐⭐⭐⭐ My name is Dmitry Kraitor and I am individual full-stack&full-time web developer. I have gone through the project description and I Lisää

£200 GBP 3 päivässä
(19 arvostelua)
4.4
UnityGame

Hello How are you? I read your proposal carefully and get clear understanding. I can do it in a day. Let's discuss via chat. Thank you.

£111 GBP 3 päivässä
(27 arvostelua)
4.5
aswebsmart

Hi, I have read through your job descriptions, and I understand all of the requirements. I am applying because I believe that I have the required skill set to complete your project. I have been working as a PHP deve Lisää

£120 GBP 2 päivässä
(20 arvostelua)
4.1