I have a client that has an existing program for data entry. The program takes the customer data that she enters and compresses the data into 3 .txt files and uploads the 3 files to the root directory of her website. Once those are uploaded, she has a .asp web page that has a script that she executed which takes the data from the .txt files and transfers it to the sql databases. At the present time, the process has stopped functioning as it should and the data is being deleted but not replaced as the code is written to do. I have pasted the info from the .asp web file below. This will be more of a troubleshooting project and maybe some evaluation of the current databases to see why it has stopped functioning.
<%
[login to view URL] = false
[login to view URL] = 1200
Const ForReading = 1
Const ForWriting = 2
Const ForAppending = 8 %>
<% 'Open and read a text file.
On error resume next
Set OBJdbConnectionMem = [login to view URL]("[login to view URL]")
[login to view URL] "DRIVER=MySQL ODBC 3.51 Driver;SERVER=localhost;DATABASE=p26330_PNI;UID=p2633_pni;PASSWORD=“password removed”;OPTION=3"
tmpOut = ""
Filename = "/[login to view URL]"
Dim Filepath
Filepath = [login to view URL](Filename)
set fs = CreateObject("[login to view URL]")
set file = [login to view URL](Filepath, ForReading)
SQLStrMem = "DELETE FROM ntodata1;"
[login to view URL]( SQLStrMem )
do while not [login to view URL]
tmpOut = "("""
tmpOut = tmpOut & Replace(Replace([login to view URL], chr(34), "'"), vbTab, """, """)
tmpOut = tmpOut & """]"
tmpOut = replace(tmpOut, """, "" ""]", """)")
'[login to view URL] tmpOut
SQLStrMem = "INSERT INTO ntodata1 VALUES " & tmpOut & ";"
[login to view URL]( SQLStrMem )
loop
[login to view URL]()
[login to view URL] "1/3 Loaded...
"
Filename = "/[login to view URL]"
Filepath = [login to view URL](Filename)
set fs = CreateObject("[login to view URL]")
set file = [login to view URL](Filepath, ForReading)
SQLStrMem = "DELETE FROM mem;"
[login to view URL]( SQLStrMem )
do while not [login to view URL]
tmpOut = "("""
tmpOut = tmpOut & Replace(Replace([login to view URL], chr(34), "'"), vbTab, """, """)
tmpOut = tmpOut & """]"
tmpOut = replace(tmpOut, """, "" ""]", ""","""","""","""")")
'[login to view URL] tmpOut
SQLStrMem = "INSERT INTO mem VALUES " & tmpOut & ";"
[login to view URL]( SQLStrMem )
loop
[login to view URL]()
[login to view URL] "2/3 Loaded...
"
Filename = "/[login to view URL]"
Filepath = [login to view URL](Filename)
set fs = CreateObject("[login to view URL]")
set file = [login to view URL](Filepath, ForReading)
SQLStrMem = "DELETE FROM reqdata1;"
[login to view URL]( SQLStrMem )
do while not [login to view URL]
tmpOut = "("""
tmpOut = tmpOut & Replace(Replace([login to view URL], chr(34), "'"), vbTab, """, """)
tmpOut = tmpOut & """)"
'tmpOut = replace(tmpOut, """, "" ""]", """)")
'[login to view URL] tmpOut
SQLStrMem = "INSERT INTO reqdata1 VALUES " & tmpOut & ";"
[login to view URL]( SQLStrMem )
loop
[login to view URL]()
[login to view URL] "3/3 Loaded...
"
%>
Done
I have a huge Classic ASP experience and can troubleshoot and fix your issue TODAY for just $250 USD. Could you show your text files that ASP page tries to process?
Roman
$250 USD in 1 Tag
5,0 (511 Bewertungen)
7,8
7,8
40 Freelancer bieten im Durchschnitt $467 USD für diesen Auftrag
Hi there! My name is Raman and I'm part of the Top Rated | 18+ years of experience in Web and APP Development team at Top Rankin. We specialize in PHP, WordPress, WooCommerce, Data Scrapping, React Native and other similar development languages. We've worked on many projects for clients large and small and have achieved success every time.
I understand that your client needs help with data entry on her website and that the process has stopped functioning as it should. With our expertise in PHP, WordPress and related technologies, we are confident we can provide the best solution for this project. We would be more than happy to discuss this project further with you if you'd like.
Experienced coder for troubleshooting and evaluating data entry program
Get your data entry program back on track with an experienced coder!
As an experienced coder with over 10 years of experience, I am confident in my ability to troubleshoot and evaluate your data entry program. With my expertise in SQL databases and web development, I have the skills necessary to identify and fix any issues that may be causing your program to malfunction.
My strong communication skills and attention to detail make me the ideal candidate for this project. I will work closely with you to understand your needs and ensure that the program is functioning as intended. Additionally, my experience in coding and web development gives me the ability to think critically and use good common sense when evaluating and troubleshooting your program.
In summary, if you want to get your data entry program back on track, I am the coder for the job. With my experience, communication skills, and attention to detail, I am confident that I can deliver the results you need. Let's work together to get your program functioning properly once again!
Note: Bid Amount And timeline is just a placeholder actual value would be provided after 1 to 1 discussion over chat
Let’s troubleshoot your website and make the program fully functional on your client’s website!
As per my understanding, you require the removal of error from your client’s program on her website that gets customer data and ultimately upload it to sql database.
We have a team of Script and Web tools/program developers. We have developed, updated, and troubleshoot many programs and Scripts to make them fully functional for the website and perform the desired tasks.
Our Solution: We will first check whether the problem is with program or the script or anywhere lse, then resolve the issue, and after proper testing implement it to your client’s website again to add the data correctly into the sql database.
Please answer the following questions for a better understanding:
1- Which programming language was used to develop this program and Script?
2- Can you also please share the website where this program and Script are implemented?
3- Is there a deadline in your mind?
You can interview us and we will be happy to demonstrate and explain our experience with similar projects in our 15+ years of development experience.
Looking forward to hearing from you,
Fahad Khawaja
I'm devyani, fastest growing freelancer in short time.
I understand your need for a coder and can help you with that. My team specializes in PHP development, specifically with Codeigniter, Laravel and CakePHP frameworks. We have extensive knowledge in the field of website design and development as well as CMS solutions such as Wordpress, Magento, Joomla and Opencart. Additionally we have experience in IOS & Android application development (both native & react native), SEO optimization and backlinks generation.
We are committed to providing quality service at all times through thorough communication between us during the project's development phase so that you don't encounter any issues or delays along the way. This will guarantee completion of the project on time with full quality control along the way to ensure customer satisfaction.
Hello there!
Let's have a quick call!!
My name is Anamika Tiwari, and I am a dedicated freelance developer with over 10 years of experience in the industry. I understand that you are seeking a coder for a project that requires data entry into an existing program and the transfer of data to SQL databases. I believe that I am the perfect fit for this project because of my extensive knowledge in PHP, front-end development (HTML, CSS, JavaScript), back-end development (PHP & NodeJS), database management, as well as UI/UX design.
With my past success in completing over 75+ projects, I am confident that I can deliver high-quality work that meets or exceeds your expectations. Additionally, I strive to provide exceptional customer service so that you are satisfied with the end product. If you would like to discuss further please feel free to reach out to me directly. Thank you for considering my services and we look forward to working together soon!
Hello there! My name is Navjot and I am an experienced PHP specialist. I understand that you need help with your data entry program and I think I am the best fit for this project. With over 7+ years of experience in web design and development, I have the skills necessary to solve your data entry problem quickly and effectively.
Specifically, I have expertise in Magento 2 | WordPress | Shopify | HTML | Bootstrap | PHP which will be invaluable when it comes to troubleshooting the existing program and evaluating the current databases. Additionally, I am a highly motivated individual who is able to work quickly and efficiently to get projects done on time. Additionally, I always ensure that my work is delivered on time with no errors or delays.
Nice to meet you RLB14896,The requirements of your project match my areas of work and skills, to introduce myself.
My name is Anthony Muñoz and i am the lead engineer for DS Pro IT agency. I have worked for
over 10 years as a Full-Stack and software development engineer and have successfully done multiple jobs. It
will be a pleasure to work together to make your project.
Feel free to discuss about the project with me, greetings.
Hi there, My name is Hamza Amjad and I am a Mechanical Engineer with 3 years of experience in MATLAB and Cad Modeling/ Simulation. I understand you need a coder for your existing data entry program that takes customer data and compresses it into 3 .txt files before uploading them to the root directory of your website. Once uploaded, a .asp web page executes a script which takes the data from the .txt files and transfers it to the SQL databases. At present, the process is not working as it should, leaving data un-replaced.
I believe I am the perfect fit for this project as I have the skills necessary to troubleshoot any issues that may arise along the way and make sure that your website stays up-to-date with all of your data needs. Please feel free to contact me if you have any questions or would like me to provide more information about my skillset and services.
hi i know asp, and python programming with database. i can fix your code issue please message me so i can fix the problem thanks. please check my profile for my past project and reviews. i have completed all proejcts 100%
Hi, I have gone through the project description very carefully there are some initial queries that i have we can discuss those over chat. I will do my best for you. Thank you
Hello, my name is Bryan De Vera and I am a creative web developer here to bring you best service as per your requirements. I have been in the industry for past 6 years, which makes me experienced and skilled enough to deliver what you want for your project.
Especially I am very familiar to ASP.Net and php and confident that I can fix your project in short time.
I look forward to meet and discuss about your project via chat.
Thank you for considering my bid. Bryan
Hello.
I am a professional web developer with more than 9 years of experience in web development.
I mainly specialize in website and web app development now.
Given my experience and skills, your project is a great fit for me.
I guarantee that I can complete your project and give you perfect results.
I can start to work right away and you can call me anytime here.
Let's discuss the details of the project via chatting.
Best regards.
Hello RLB14896,
I would like to grab this opportunity and will work till you get 100% satisfied with my wonderful work.
I have worked in many companies and excellent development teams as a senior developer, so I have solved many main problems and completed many web and mobile apps using PHP.
Lets connect in chat so that We discuss further.
Thank You
⚛️ Expert of C# and ASP.NET, MySQL and Web Site HERE ⚛️
Hi!
I am a rich experienced software expert.
I noticed that I am appropriate to this project.
As a skillful software developer, I have rich experience with C# and ASP.NET, MySQL and Web Site and Git and built many projects like this.
I promise I will finish this project with high quality on time.
I hope you to contact me so that we have a full discuss with the project.
Thanks.
Best regard!
Hello RLB14896,
We would like to grab this opportunity and will work till you get 100% satisfied with our work.
I can work full time for you and your project. I can start work immediately.
I am an expert developer who has many years of experience on PHP, ASP, SQL
Lets connect in chat so that We can discuss more details about this project. I can turn your idea into real software very quickly.
Best Regards
Dear Client, my name is Wayne and I am an EXPERT in the following skills:
I understand that you have an existing program for data entry that has stopped functioning as it should. I can help you troubleshoot the issue and evaluate your current databases to see why it has stopped functioning. With my experience in web security, penetration testing and web server operating systems, I am confident that I can provide the best solution for your needs.
My SERVICES include:
I believe that I am the perfect fit for this project because of my vast array of knowledge in web security, web server operating systems and database servers. Additionally, my services are available 24 hours a day so you can count on me for any urgent needs. Additionally, with unlimited revisions and a fast response time you can rest assured that your project will be taken care of quickly. Please feel free to reach out if you have any questions or would like further information about me or my services.
hi , The code you provide appears to performs data loading operations from text files into a MySQL database using ASP. But it seems incomplete. If you can provide complete code i can make it correct to store the data in mysql.. Please message me so i can provide you demo. I won't charge if code doesn't work for you. thanks
Hi there, my name is matrix and I am a full stack developer with 16 years experience in the field of software development. I have worked with many different programming languages such as PHP, JS and frameworks such as Laravel, Symfony and Codegniter before.
I understand that you need someone to help with the data entry process for your client and that the program has stopped working as it should. I believe that I am the best person for this job as I have the necessary skills and experience to tackle this project. With my help the process will start functioning again quickly and efficiently so that you can get back to focusing on other parts of your business.
I would be more than happy to discuss pricing and the exact details of how my services can be used to best advantage during our discussion in person or over the phone. Please feel free let me know if you would like to chat further about this project or any other related matters.
