Import TXT/CSV into MSSQL Table with mapping of fields (PHP Portal)
£20-250 GBP
Paid on delivery
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
Project ID: #18754400
About the project
Awarded to:
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 More
20 freelancers are bidding on average £154 for this job
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 More
Hi, I have extensive experience working on custom CMS/web applications in PHP/MySQL. I'll be happy to help you out. Cheers.
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.
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
⭐⭐⭐⭐⭐⭐⭐⭐⭐⭐ 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 More
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 More
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 More
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, More
Hi, I can help you to create a script according to this rule. please come over chat and discuss in details. Thanks. ....
How are you today? I have seen your proposal carefully, and I am very interested in your project. I am a senior full stack developer. I am confident to complete your project perfectly by your requirements. Please c More
Hello, I'm an expert and efficient PHP developer. I could help you do a file import mapping to your MS SQL database. I could also add functionalities like to display the result of the imported file in table view before More
Hello We are team of smart developers working in IT industry from past 7-years have developed 200+ simple and complex Mobile phone apps for Android & iPhone, Hybrid app and many Websites in RubyOnRails,WordPress More