Find Jobs
Hire Freelancers

Import Tab-Delimited Text File to MySQL using PHP 8.3

$20-50 USD

Completed
Posted about 2 months ago

$20-50 USD

Paid on delivery
I'm looking for someone with a deep understanding of PHP and MySQL to develop a system that will import a tab-delimited text file directly from a user's computer to MySQL. Key responsibilities include: - Create an interface for file selection and import to MySQL - Develop the system in PHP 8.3, having it capable of importing a tab-delimited text file - Database tables should be created from the file itself. The format of the file is as follows: The source file type is an Primavera XER file, renamed to txt file. The first row of data in the file is irrelevant, it can be skipped from there on each row starts with two characters. if the row start with %T it is the table name, if row data starts with %F it is the field names within that table, if it starts with %R it is the record data in that table, the table just created. If it starts with %E the end of the file has been reached. All field types can be Text but care needs to be taken in each table that fields contain the correct data in the MYSQL tables. One additional requirement is that if the tables exist in MYSQL the tables should be deleted, then re-created.
Project ID: 37796327

About the project

46 proposals
Remote project
Active 2 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Good day, I specialize in PHP and MySQL development. I can certainly assist you with your project requirements. I understand that you need a system to import tab-delimited text files directly into MySQL, creating tables based on the file's structure. Additionally, existing tables should be deleted and recreated if necessary. Let's discuss this further. We can connect via chat or call to delve into the details. Best regards, Ismail U
$50 USD in 1 day
4.9 (101 reviews)
6.6
6.6
46 freelancers are bidding on average $50 USD for this job
User Avatar
Hi I have read that all, can help you with this task with all if conditions I am great with PHP and MySQL and can perform the task really well I am Confident and Highly Interested as I have 8+ years of expertise My Profile Reviews speak for my Quality Work and I assure you won't regret working with me on this :)
$150 USD in 2 days
5.0 (139 reviews)
7.6
7.6
User Avatar
As an accomplished web programmer with over 14 years of experience, I guarantee a deep understanding and skillset in PHP, SQL, and MySQL. My experience includes managing a vast array of different programming tasks, including extensive work with databases and data import/exports. Specifically, I have successfully created similar systems involving file selection and import to MySQL databases using PHP 8.3, making me an ideal fit for this project. Moreover, my ability to adapt and problem solve while under pressure enables me to handle complex file formats with ease. The Primavera's XER file conversion is a perfect example where I am confident in parsing the data based on the specified row identifiers (%T, %F, %R %E) and rebuilding the tables accordingly. Additionally, my understanding of data management will ensure that the correct data types are assigned as Text within each table. In conclusion, my skills, experience, and commitment to excellence make me the best candidate for your project. Let us combine our expertise to develop an efficient system that not only imports your tab-delimited text files in PHP 8.3 but also dynamically creates/recreates mysql tables as per your requirements. By hiring me, you're ensuring a successful project delivery that is tailored precisely to your needs. Feel free to contact me with any further questions or details you require. Thank you!
$20 USD in 1 day
5.0 (425 reviews)
7.3
7.3
User Avatar
Hello, I have good PHP, Powershell and I can help you to make interface through Powershell form and VB form, once user start the app and upload the file, then backend script will take care all import stuff Kindly ping me and award the project Thanks
$50 USD in 7 days
5.0 (83 reviews)
6.5
6.5
User Avatar
Hello there, I am a senior Designer and Developer who can serve you Quality work with 100% satisfaction. I always try to provide High-Quality Work to work long-term with you. I can assist you in PHP, Laravel, WordPress, Shopify, WIX, JavaScript, jQuery, HTML5, CSS4, Bootstrape4, FIGMA/PSD to HTML/ WP Conversion, UI/UX, FIGMA, PSD, and many more Please allow me an opportunity to work on your Project and I will not disappoint you. Waiting for your Response :) Thanks Vishal
$50 USD in 7 days
4.9 (93 reviews)
5.9
5.9
User Avatar
I'm ready to make that PHP Script for importing the text files into MySQL but I've a small question; since field names are dynamic and really don't give clues which can be used by the script to create table columns with the best data types, would it be OK if the script defaults to the varchar datatype?
$50 USD in 1 day
4.9 (56 reviews)
5.9
5.9
User Avatar
Greetings, I have been using PHP for more than 10 years. I can develop PHP applications from the ground up or take up existing applications and work with them. In addition, to my backend experience, I can also work with frontends, using VueJS. Let's engage over chat to further discuss your needs and the changes that you need done.
$100 USD in 3 days
5.0 (32 reviews)
5.5
5.5
User Avatar
Hey! I hope you are fine! I have read your project description very carefully and sincerely I bring over 10 years of freelancing experience, specializing in, WordPress, PHP, Laravel, HTML, CSS, React js, Note js, databases, Adobe, Figma (UI UX), and more. Let's collaborate to create a bespoke template tailored to your project needs. My skills span graphic design, UI/UX, API integration, and responsive web development. I am excited to discuss your vision and deliver a top-notch solution. Anticipating the chance to collaborate with you. BEST atif: BR
$20 USD in 1 day
4.8 (44 reviews)
4.8
4.8
User Avatar
Hi there. ⭐⭐ I am a full stack Developer ⭐⭐ with experience in HTML, Javascript, PHP, AWS, MY SQL, Bot Developement, Web, Machine Learning (ML), PYTHON, Deep Learning and Communications. I have worked with many similar projects as i have a team of enthusiastic developers. We strive to give our best. Please contact to discuss in detail.
$40 USD in 1 day
5.0 (18 reviews)
4.6
4.6
User Avatar
I can fix this issues I am an individual full stack developer with decent amount of experience well enough to handle this project. I can start the work immediately after a detailed discussion.
$40 USD in 1 day
5.0 (13 reviews)
4.3
4.3
User Avatar
Hi! This seems pretty interesting, as I'm working with various formats, making parsers, and so on. I'm starting with the middle of your per-hour price range, aiming for a moderate/fair cost, and too time estimate is somewhat long-ish, because I guess there might be some details that aren't clearly determined yet, like if you need a setup for the service, user management so the import is per user, I'm wondering how you want to access the imported result (or is your goal to then access just the database, internally?), etc.
$35 USD in 14 days
5.0 (3 reviews)
4.0
4.0
User Avatar
Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun
$35 USD in 1 day
5.0 (6 reviews)
3.6
3.6
User Avatar
Import Tab-Delimited Text File to MySQL using PHP 8.3, message me , i can help you................................................................
$75 USD in 3 days
5.0 (22 reviews)
3.8
3.8
User Avatar
Hello there, I'm well-versed in PHP and MySQL. I can certainly help you develop a system to seamlessly import tab-delimited text files into MySQL, considering the specific format and requirements you've outlined. Let's connect to discuss your project further ensure the right path of your way. Looking forward to assisting you. Best regards, Aliza H
$45 USD in 1 day
5.0 (14 reviews)
3.5
3.5
User Avatar
As a skilled PHP developer with a deep understanding of MySQL and SQL, I am confident in my ability to create the system you need to import tab-delimited text files into MySQL. Understanding the process outlined in your project description, I will ensure the tables are deleted and recreated if they exist already, and take care to maintain correct data for all fields within the MySQL tables. My experience working with file handling and database management ensures I can build an interface that allows users to select their desired file for import with great ease. Moreover, I'm very familiar with PHP 8.3, which enables me to fully utilize its features in creating your import system. On top of this, I've ample experience working with web developments having worked on projects similar to yours such as parsing data from various file formats into MySQL databases. I value constant communication and ensure 100% job satisfaction where my clients' needs are paramount. Given the opportunity, I'll deliver your project effectively based on your unique specifications while staying within the given timeframe. Let's discuss your project in detail!
$50 USD in 7 days
5.0 (5 reviews)
2.9
2.9
User Avatar
Hello there, I am Maksym Morar, a highly experienced web developer with over 8 years of expertise in PHP, Website Design, CSS, HTML, and HTML5. I have carefully reviewed your project requirements and I am confident in delivering a top-notch solution tailored to your needs. To create an engaging and consumer-focused website, I will leverage my extensive knowledge and skills in HTML/CSS to design a functional and dynamic platform. I understand the importance of user-friendly interfaces and will ensure that the website is intuitive and easy to navigate. In addition to my web development expertise, I also offer a range of digital marketing services including social media marketing, graphics designing, UI/UX, and SEO. These services can be customized to align with the goals of your project, ensuring maximum visibility and reach for your website. I propose working on a milestone basis, allowing us to track progress and ensure that each stage of the project is completed to your satisfaction. I believe in open communication and collaboration, and I am eager to discuss your project further. Please initiate the chat so that we can delve into the details and get started on creating an exceptional website that meets your requirements. Sincerely, Maksym M.
$40 USD in 7 days
5.0 (3 reviews)
3.1
3.1
User Avatar
Hello I’ve carefully checked your requirements and really interested in Import Tab-Delimited Text File to MySQL using PHP 8.3. I am confident for your project because I have skills of PHP, SQL and MySQL. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details. Sincerely, Yehor.
$40 USD in 3 days
5.0 (1 review)
2.6
2.6
User Avatar
As an expert in MySQL with a significant experience in custom software development, I can assure you that your project is right up my alley. I have handled numerous projects involving database management and your requirement of creating/recreating tables from file data aligns perfectly with what I've done. With precision and adherence to detail, I will create an intuitive user interface for file selection and import to MySQL, ensuring the data remains accurate and organized. Additionally, my team at NCS can tap into the power of PHP 8.3, skillfully navigating not just its established features but also implementing any newly introduced ones that would make the file import process smoother for your system. We'll effectively utilize the tab-delimited text file structure you provided; identifying the table name, field names, record data, and more. Lastly, a hallmark of our work is efficiency and cost-effectiveness. We understand the need to curtail costs while maximizing value through IT strategies. By entrusting this project to us, you'll be collaborating with a team committed to delivering comprehensive solutions that not only meet your expectations but also align seamlessly with your business goals.
$50 USD in 7 days
4.8 (4 reviews)
2.1
2.1
User Avatar
Hello, thanks for reading. I can start right now and can work very fast. With my substantial experience and extensive skills in MySQL, PHP, and SQL, I am confident in delivering an exceptional solution for your project's needs. Being a senior full-stack developer with proficiency in various backend technologies, I've gained invaluable insights into working with databases, creating sophisticated user interfaces, and developing expansive systems that require careful consideration of data formats. Deep-diving into the specifics of your project and my sound understanding of parsing Primavera XER files (renamed to txt files) and creating database tables dynamically from the file while ensuring correct field data insertion will prove vital. I assure you that all essential functionalities, such as file selection and importing tab-delimited text files to MySQL while deleting and re-creating tables if already present, will be diligently implemented. In addition to the necessary technical skills, my dedication to providing first-rate solutions coupled with my ability to quickly comprehend complex projects gives me an edge in accomplishing this task proficiently and effectively. Let's transform your project from an idea to a fully-functioning reality, together! I look forward to discussing further details with you and contributing my expertise to bring about the best possible outcome for your project.
$35 USD in 1 day
5.0 (3 reviews)
2.0
2.0
User Avatar
Dear Client, Just finished reading the brief details of your job. I am excited to submit my proposal for the development of a robust system capable of importing tab-delimited text files directly into MySQL. With my deep understanding of PHP and MySQL, I am well-equipped to meet your requirements and deliver a solution that streamlines the import process efficiently. Key Responsibilities: Interface Development: I will create a user-friendly interface that allows seamless file selection and direct import into MySQL. PHP 8.3 Implementation: Leveraging PHP 8.3, I will develop the system to handle the import of tab-delimited text files effectively. Dynamic Database Table Creation: The system will dynamically create database tables based on the structure of the imported file, following the guidelines you provided. Data Validation: I will ensure that each field contains the correct data type in the MySQL tables, maintaining data integrity throughout the import process. Table Management: As per your requirement, existing tables will be deleted and re-created if they already exist in the MySQL database. Thank you for considering my proposal. I am eager to discuss the project further and collaborate with you to bring your vision to life. Best regards, Sumit Joshi
$49 USD in 7 days
5.0 (3 reviews)
2.2
2.2
User Avatar
With a wide array of skills and over 5 years of experience in MySQL and PHP development, I am more than capable of crafting the system you need to import tab-delimited text files directly into MySQL. Additionally, my adeptness in AngularJS, ReactJS, VueJS, ASP.NET(C#), Python, Laravel(a PHP framework), and web scraping (using Python) will be immensely useful in creating a fully functional interface to select and import the files. FYI: before we go too far down the rabbit hole, the first row of data in your file seems irrelevant - I will skip it for optimization. Moreover, I come equipped with hands on experience with databases like PostgreSQL and NoSQL that positions me well to understand the data analytics aspects of your project. This comprehension aids me when it comes to testing the compatibility of imported data and ensuring they match their respective fields correctly. Reliability is something I pride myself on. I believe this extends beyond providing quality code to also fostering clear channels of communication. This means open dialogue throughout the project's lifecycle, ensuring your needs are met at each major milestone. Ultimately, what sets me apart is solid problem-solving skills from my extensive DevOps exposure and unwavering commitment to meet project deadlines with optimal efficiency. Let's talk further about your requirements.
$35 USD in 7 days
5.0 (3 reviews)
2.2
2.2

About the client

Flag of SOUTH AFRICA
Pretoria, South Africa
5.0
6
Payment method verified
Member since Mar 24, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.