Завершено

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

Квалификация: HTML, MySQL, PHP, SQL, Дизайн сайтов

Показать больше 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

О работодателе:
( 115 отзыв(-а, -ов) ) London, United Kingdom

ID проекта: #18754400

Поручен:

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 Больше

£70 GBP за 3 дней(-я)
(644 отзывов(-а))
8.8

30 фрилансеров(-а) в среднем готовы выполнить эту работу за £157

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 Больше

£150 GBP за 3 дней(-я)
(102 отзывов(-а))
7.3
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 дней(-я)
(56 отзывов(-а))
7.4
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 Больше

£150 GBP за 3 дней(-я)
(51 отзывов(-а))
7.0
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 Больше

£150 GBP за 3 дней(-я)
(39 отзывов(-а))
6.8
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 дней(-я)
(185 отзывов(-а))
6.9
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 Больше

£150 GBP за 5 дней(-я)
(63 отзывов(-а))
6.4
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 дней(-я)
(36 отзывов(-а))
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 Больше

£150 GBP за 3 дней(-я)
(52 отзывов(-а))
6.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 Больше

£100 GBP за 3 дней(-я)
(48 отзывов(-а))
6.3
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 Больше

£150 GBP за 3 дней(-я)
(83 отзывов(-а))
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 Больше

£144 GBP за 3 дней(-я)
(38 отзывов(-а))
6.9
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 Больше

£150 GBP за 3 дней(-я)
(14 отзывов(-а))
5.8
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 Больше

£200 GBP за 3 дней(-я)
(67 отзывов(-а))
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 Больше

£300 GBP за 3 дней(-я)
(46 отзывов(-а))
5.4
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, Больше

£150 GBP за 1 день
(16 отзывов(-а))
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. Больше

£150 GBP за 3 дней(-я)
(18 отзывов(-а))
5.6
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 Больше

£200 GBP за 3 дней(-я)
(22 отзывов(-а))
5.7
MikeJones915

Hi I read your requirements carefully. I have experience in php and mysql. If you give me the assignment, I will satisfy u with good result. I will always dedicate ourselves for your success. Thank you.

£150 GBP за 3 дней(-я)
(34 отзывов(-а))
5.1
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 дней(-я)
(40 отзывов(-а))
5.2
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 Больше

£120 GBP за 2 дней(-я)
(34 отзывов(-а))
4.6