Sql 2005 import csv table dtsงาน

We last worked together 3 yrs ago. I have a PHP script that I use to import data into my web application. However, I'm encountering issues with single quotes (') in the data fields, which are causing problems during the import process. I need a skilled PHP developer to modify this script to effectively remove any single quotes from the data fields array prior to the import. Single quotes are my immediate need, however I would like to include some other non-standard non-english characters that are used in names, like ( á, é, í, ó, ú, ü, ñ, ¿ and ¡ <-(upside down exclamation mark)

...both cash and credit/debit card payments for customer convenience. **Additional Features:** - **Convert Traditional Menu to Digital:** QR code enables easy access to the digital menu. - **Complete POS System:** Order creation from the counter. - **Order Management and WhatsApp Updates:** Updates for customers and restaurant staff. - **Flexible Ordering:** Options to place orders from the phone, table, or home. - **Auto Invoice Generation:** Invoices sent via WhatsApp. - **Customer/Order Excel Export:** For easy management and analysis. - **Reporting:** Monthly and daily order reports. - **Menu Updates:** Upload menu via Excel, update prices and pictures anytime. - **Unique QR and Link Generation:** For pamphlets and Google business. **Ideal Candidate:** The ideal freelancer sho...

I require an expert in SAP Integration Suite for a project focused on integrating Salesforce, Slack, and SQL. With proficient experience in Cloud Integration, Open Connectors, and API, you'll be able to skillfully execute my requirements. Your main tasks will be: - Implementing SAP Integration Suite with Salesforce, Slack and SQL. - Ensuring real-time data synchronization between the systems. - Establishing automated data transfer protocols. - Enhancing the overall efficiency of business processes through these integrations. Your expertise in SAP Integration Suite, Cloud Integration, Open Connectors, and API, along with the ability to ensure real-time data sync, automate data transfers, and streamline business processes, will be crucial for this project.

I am in need of a freelancer who can create paginated Access reports. The job involves: - Using data from MS-Access to use in the report. - Converting the extracted data into paginated reports. - Very good knowledge of SQL. The perfect candidate will be proficient in manipulating SQL language and creating Access reports, with a keen eye for detail and a some understanding of sales data. Background in SQL language and Microsoft Access report is advantageous. Attached is a sample of the report I need the candidate to perform, but in much better format and with the correct information extracted for each column.

I need a professional who'll efficiently compile my crafted 60 articles into an engaging, well-formatted e-book. Key tasks involve: - Collating and structuring the content while creating a flow, considering I need an inclusion of a table of contents. - Complete editing to ensure clarity, coherence, and strong articulation. - Proofread to spot and eliminate all potential errors. - Format the whole e-book to an appealing and readable state. The ideal freelancer should have proven experience in editing, proofreading, e-book formatting, and a knack for meticulousness. Your attention to detail, creativity, and commitment to deadlines are key to making a perfect fit for this project.

I'm looking for a resourceful individual to perform an in-depth market research and produce a detailed report on maker and taker fees based on crypto exchange websites. Ideal skills and experience for the job: - Strong analytical abilities - Proficient in web research - Experience with ...detailed report on maker and taker fees based on crypto exchange websites. Ideal skills and experience for the job: - Strong analytical abilities - Proficient in web research - Experience with cryptocurrency and blockchain - Excellent report writing skills. Key requirements include but are not limited to: - Gather and analyze fees information from multiple crypto exchange websites. - Summarise it in table covering each exchange (there are 600+ exchanges as per coingeckgo) and each VIP tier ...

I need to convert a small 25mb .bak file to csv/xml. This is a backup of MSSQLSERVER2016 (MS SQL Server)

...should include essential features such as online appointment scheduling, patient registration, and detailed information on the hospital and doctors available. The primary users will be patients and hospital staff, so the user interface must be intuitive and user-friendly. Ideal skills: * Proficient in WordPress development * Experience in healthcare sector websites beneficial * Knowledgeable in SQL or other database management systems * Familiarity with responsive and mobile-friendly designs Key Customization Features: * Patient profile creation: Users should be able to create and manage their profiles effortlessly. * Personalized appointment reminders: The platform should send customized reminders to patients about their upcoming appointments to reduce no-shows. Your port...

I need an experienced .NET C# developer to urgently create an ArcGIS plugin for...should include: there is already ArcGis plugin that already works on AutoCAD , but i want one that can be created that can run on GstarCAD - Data Sharing - 3D Modeling - Import/Export Features - Other major functionalities related to CAD and GIS integration that is already in ArcGis that works on AutoCAD The timeline is crucial, I require this as soon as possible. Ideal Candidate: - Proficiency in .NET and C# programming languages - Demonstrable experience in ArcGIS platform, specifically plugin creation - Familiarity with CAD softwares, especially GstarCAD and AuTOCAD - Strong understanding of data sharing, 3D modeling, import/export functionalities in GIS environment - Able to work under...

I'm in need of a developer to help me transform the tables on my web platform into a downloadable Excel sheet. This needs to be done in a way that the Excel sheet maintains the same order and all data fields as seen on our website. Job requirements: - Extract all data fields from our websites data tables - Develop a downloadable Excel sheet functionality for each table - Ensure the data maintains the same order as on the website - Use PHP and Javascript languages Key details: - Users are expected to download updates on-demand - The Excel sheet should be styled to match the website's design I'm looking for a developer who is proficient in both PHP and Javascript and has prior experience working with similar data transformation projects. Attention to detail and abi...

I am looking for a skilled web developer to perform a major update on my existing website. This projec...implementing a responsive design onto my website. Creating a site that is user-friendly across all devices is crucial to me. 2. Content Updates: I am aiming to liven up the website with fresh and quality textual content as well as relevant images. This demands proficient writing and relevant, high-quality image sourcing or creation skills. A successful freelancer for this project should bring to the table strong web development and design skills, a keen eye for aesthetics, and attention to detail. Competence in creating mobile-friendly, responsive designs is a must-have. Experience in sourcing or creating quality content, specifically text and images, for websites is highly ...

I'm currently in need of an expert in Google Sheets proficient in utilizing the Vlookup formula to match and compare data between two columns in a simple table with rows and columns. Key Tasks: • Apply Vlookup to compare and match data • Simplify and present result in an understandable format • Assure accuracy of matched results Ideal skills and experience: • Proven experience with Google Sheets • Strong understanding of the Vlookup formula • Exceptional attention to detail • Ability to deliver accurate results promptly. Please present examples of similar work in Google Sheets applying the Vlookup formula.

...Development Script 1: [Opening Scene: A colorful and inviting setting with a therapist and a child sitting at a table filled with various toys and objects.] Narrator: "Welcome to our Fine Motor Skills Development session! Today, we'll be exploring fun and engaging exercises to help your child enhance their handeye coordination and dexterity." [Cut to the therapist smiling warmly at the camera.] Therapist: "Hi there! I'm [Therapist's Name], and I'm excited to guide you through these activities that will not only be enjoyable for your child but also beneficial for their fine motor skills development." [Cut to the child, who eagerly looks at the therapist and toys on the table.] Narrator: "Let's get started with our fi...

Need to fix wordpress exisiting filter, some drop downs are missing there and after selecting drop down from every category and click on find button filter should work rather than automatically work

I'm looking f...looking for a skilled developer to integrate a form from GHL Connect with our current CRM. The core task will involve: - Data Synchronization: The main requirement is to synchronize data in real-time between the GHL form and the CRM. - Import/Export Workflow: You should create an automated workflow to import or export data from the form to the CRM. - Data Type: The primary type of data to be synced is contact information. Ideal Skills and Experience: - Expertise in CRM integrations and data synchronization. - Proficiency in creating automated workflows for data import/export. - Specific knowledge or experience with GHL Connect would be advantageous. Your role will be to ensure accurate and efficient data flow between the form and the CRM to im...

Amend table column. (Add/remove) And some issue example: Delete data immediately remove (need to refresh)

Main objectives include: 1. table of content 2. Introduction 3. literature review 4. methodology 5. problem definition 6. the goal of the research aim of the research 7. outline 8. project plan. 9. appendices 10. reference ... in total 12 pages. important (non-AI and non-plagiarism) This project must be completed within a month. Ideal freelancers will be people who have a strong grip on tourism studies and have excellent academic research and writing skills. Previous work experience writing research papers or having a degree in a related field is an advantage.

I'm in need of a highly skilled .NET developer for my project. It involves .NET framework (specifically web forms) and a complex SQL database. Ideal Skills and Experience: - Strong expertise in .NET framework, particularly with web forms. - Comprehensive knowledge of SQL, able to navigate and manipulate complex databases. - Previous experience with large-scale projects requiring intricate database structures. Your application should focus on your experience in these areas and similar projects you've completed. Please, make sure to emphasize your accomplishments and results in your past work.

I have a customer base of Wellness users some of which use Strava on their phone. With their consent I want to be able to access the Strava API to download their activity to my Zoho CRM instance and record all the activity in fields created in Zoho for this purpose. Freelancer requires knowledge of API data requests (Strava experience a plus but this is clearly documented) and know...of Wellness users some of which use Strava on their phone. With their consent I want to be able to access the Strava API to download their activity to my Zoho CRM instance and record all the activity in fields created in Zoho for this purpose. Freelancer requires knowledge of API data requests (Strava experience a plus but this is clearly documented) and knowledge of Zoho CRM for the setup and import of...

Hi, Please apply only individual. Agency can apply but budget should not be more than mentioned. Role : GCP Engineer (OTP) Exp : 7 + yrs SHIFT: IST Cloud Storage Buckets, BigQuery (SQL, Data Transformations and movement) Airflow (python, DAGs), DBT IAM Policies PyCharm Databricks (pySpark), Azure DevOps Clear and confident communication

I am in need of a sound designer to work on a corporate explainer animation. The explainer is an animated table of contents that is intended to guide the user through a large set of documents they will recieve further into the year. Key Job Requirements: * Craft an ambient soundscape that enhances the learning experience * Provide a serious and professional tone to the sound design * Some desired SFX includes movement of paper, notification feedback noises, whooshes, etc * Experience in sound mixing and design for educational or corporate content is preferred Ideally, the sound design would not distract, but rather encourage focus and enhance engagement on the content. It should foster a professional atmosphere to facilitate learning and comprehension. Showing experience with simi...

...looking for a data expert to help transform my Pdfs question catalog into a specific CSV format. The targeted CSV format is as follows: number;Filename;question;answer1;answer1correct;answer2;answer2correct;answer3;answer3correct;answer4;answer4correct. - Purpose: The purpose of this project, namely, is to make the data compatible with a specific system. - Assistance Required: Depending on the case, some data entries may need reformatting prior to transformation, ensuring they are structured correctly. - Data Type: The 'question' and 'answer' columns contain mixed data, both textual and numerical. Ideal Candidate Skills & Experience: - Experience in data manipulation and transformation using Excel and CSV formats. - Proficiency in d...

In this project, I'm seeking a Power BI expert's assistance to accomplish the following: - Development of data visualization using Power BI - Creation of intuitive dashboards and comprehensive reports I will provide data from classified sources, particularly Excel spreadsheets and SQL databases. Your task will be to integrate these platforms and generate compelling, easy to understand visualizations. The primary KPIs needed in the dashboard and reports will focus on: - Sales revenue: I'm interested in monthly, quarterly, and annual trends - Customer satisfaction: We'll track this through a set of predefined parameters. Your ability to illustrate complex data in a user-friendly manner will be paramount. Prior experience with interpreting sales data and custo...

I'm keen to find a well-versed ASP.NET MVC core developer to work on building a project from scratch. This task includes: - 4 Web Forms using Razor View and 4 Listing page with Filtering and Search feature. - Code first approach - Wire frames will be shared with shortlisted developer. - Entire code project need to share. - SQL Server DB. Key skills required: - Mastery in ASP.NET MVC core - Proficiency in Entity Framework and Identity Framework - Profound understanding of user authentication protocols - Demonstrable experience with responsive design - Ability in creating professional, corporate designs.

As a beginner in Power BI, I need a proficient tutor to help me master all aspects of the tool including Data modeling, Creating visualizations and DAX formulas. I have various data sources such as Excel files, SQL databases and Web APIs which I'd like to connect with Power BI seamlessly. For this job, a deep understanding of Power BI and experience in teaching or tutoring are desired. Patience and ability to explain technical concepts to a newbie could be a good fit for the role. - Power BI mastery - Tutoring experience - Familiarity with Excel files, SQL databases and Web APIs - Patient and clear communication skills

...interaction can handle conversational queries using the LlamaIndex's `ContextChatEngine` class. 3. Document Loader with SimpleDirectoryReader: - Set up the document loading mechanism using LlamaIndex's `SimpleDirectoryReader` as described - The connector should be able to load documents from a specified directory, supporting various file types (.csv, .docx, .html, .md, .pdf). 4. Configuration & Settings: - The configuration must allow users to specify the path to the directory of documents and their OpenAI API key. 5. Implementation Language & Tools: - The entire connector should be coded in TypeScript to ensure compatibility and performance. - Necessary dependencies should be managed via npm or yarn as suitable for the project.

When importing customers via CSV file in ASTPP version 6.0, both postpaid and prepaid customers balance always uploads 0. The task is to find the corresponding php file/path on the server and correct it, so that the balance uploads correctly when uploading the customers on the ASTPP both for prepaid and postpaid customers. Positive balance must upload as positive balance. Negative balance must upload correspondingly. 0 uploads 0. You need to make a detailed document how to do that on any ASTPP server, so that someone without technical knowledge takes the document, follows it and gets the same working on the other ASTPP server. Example of the document: Someone from our side will try to upload customers on the provided server to make

Project Deadline: 2-3 Days Project Budget...Search Console input box 3. Wait for page to load 4. Press the "Request indexing" button 5. Wait for successful submission Then we repeat the process with the next url, a maximum of 12 a day as per Google limits. We want to completely automate this process with some simple automation app, where we: 1. Login in to authorise the app to access our Google Search Console 2. Upload a list of URLs via CSV 3. The app completes the task daily and restarts next day We also want to be able to view the performance of the script including: - Successful urls - Failed urls - Submission time So we can always track progress. There need to be a wait period of 24 hours + 5 minutes for each daily run, so the Google quota resets. 5* FEEDBACK ...

I am searching for an extraordinary fiction writer with considerable experience in penning mystery short stories to work on this assignment. The brief: a 1000-7500 word mystery tale revolving around a core theme of crime investigation. The successful candidate will be adept at creating suspenseful, intriguing narratives with a strong focus on the ...particularly in maintaining intrigue, pace and narrative arc within a restricted word count - Demonstrated ability to effectively incorporate given themes within a story (crime investigation, in this case) I anticipate an engaging, suspenseful plotline delivered in a thoughtfully-structured short story format. Bring your creativity and in-depth understanding of mystery genre conventions to the table, and let's craft a captivating...

I'm in need of an MS SQL expert who can write complex stored procedures for my project. Key Responsibilities: - Develop and write complex stored procedures tailored to my specific needs Ideal Skills and Experience: - Proficient in MS SQL - Experience in writing complex stored procedures - Strong understanding of database design - Ability to understand and adapt to project requirements This project is vital to my current development, and I'm looking for someone who can deliver quality results. Please share your experience and approach to this task in your bid.

Competitive Analysis and Research, presented in table and essay format. Comprehensive Business Market and Product Analysis

Tengo un archivo CSV de mi tienda web que voy a cambiar a Shopfy Necesito que alguien suba los productos de mi tienda online en archivo CSV a la nueva tienda shopify

I have around 1.5 million records in CSV format that need to be imported into my database. These records are stored on FIDE website. The file needed is Combined list STD, BLZ, RPD in .zip format on the following website The project doesn't require a user interface as one is already set up. Key Requirements: - Develop a custom PHP function that can efficiently and effectively upload these records from the FIDE rating list in TXT format. - Ensure the function can handle the large volume of records without performance issues. I would like the upload to be completed in minutes, not hours! - The function needs to be integrated into an existing system, and the ability to work in tandem with the existing interface is crucial.

I have been trying to install PHP Composer on AlmaLinux 8 but I've run into a roadblock. The issue revolves around the pecl/grpc package, I can't seem to download it. Despite several attempts at different solutions, this particular problem persists. Ideal Skills and Experience: - Proven Experience with Linux Systems, specifically AlmaLinux 8 - Deep understanding of PHP Composer and its insta...its installation process - Familiarity with handling pecl/grpc package errors - Strong problem-solving and troubleshooting abilities The goal here is to resolve this issue, allowing for the successful download of the pecl/grpc package and subsequently the installation and use of PHP Composer on AlmaLinux 8. I am open to any viable solutions or recommendations you, as an expert, can bring ...

...from 2003-01-31 to 2023-12-31. Refinitiv returns rating changes, so where a rating is unchanged (i.e., not reported in a particular month) forward-filled from the most recent rating change event. - Formatted with the following columns: TICKER, COMMON NAME, CUSIP, MOODY's RATING, FITCH RATING, DATE (YYYY-MM-DD). Returning N/A if the firm is not rated by a particular rating agency. - Exported to CSV. - Provided as a code block that I can paste in Jupyter Notebook and run using my local Refinitiv access and API key. I'm available over email for any clarifications or testing. Ideally, following retrieval of the ratings data, the time-series data retrieval will be expanded to include: - A range of market and financial data as each monthly date. - The rating agency ann...

I am seeking a skilled 3D designer to develop a downscaled game of tennis for two players that can be played on a table. The game should be realistic, engaging and suitable for being played on a tabetop. - You'll be tasked to create a detailed 3D environment model that represents a miniature tennis court setup, suitable for two tabletop players. - The game design should focus on the sport of tennis. Therefore, skills and experience in sports game design and particularly tennis will be beneficial. This is a unique project and I need a creative, detail-oriented designer who can bring this idea to life. Prior experience designing 3D models is a must.

I am seeking a freelancer with deep experience in .NET MVC project code and Azure databases who can assist me in deploying my project on Azure. The task specifically involves: • Investigating issues with my database connectivity on Azure. • I...MVC project code and Azure databases who can assist me in deploying my project on Azure. The task specifically involves: • Investigating issues with my database connectivity on Azure. • Identifying and resolving authentication-related errors I am currently encountering while using SQL Server authentication. The freelancer ideally could view these issues on my laptop setup and advise solutions accordingly. Knowledge of error diagnosis is critical. Understanding of Azure databases, .NET MVC projects and SQL...

...looking for an Independent contributor, who can support us for 8 hours a day, 5 days a week, with the following requirements. Role- Low code Developer Exp Required - 5+ Yrs Timings : 10:00 am to 07:00 PM IST Location : Remote (India) 3+ years of .NET or JAVA development experience  Exposure to Outsystems and/or Appian for Low-Code preferable  3+ years with relational databases  3+ years of MS SQL or MYSQL  1+ years designing and developing REST APIs  Proficiency in C#, .NET, HTML, and/or Javascript  Exposure to JIRA and BitBucket/Git for source control a plus  Practical understanding of data structures, algorithms, and design patterns in a web environment  Cloud first architectures (AWS, Azure, Cloudera, etc.) a plus  Log aggregators (SumoLogic, Splunk) a plus ...

...a modern aesthetic to conceive a wooden dining table for 4 people. The unique twist: the top should be fully removable for easy storage and the design should include multiple boards for different games that fit perfectly onto the table top. The ideal freelancer for this job will have: - Proven experience in furniture design, particularly tables. - Strong understanding of modern aesthetic principles. - Proficient with wood materials and manufacturing processes. - Knowledge of creating game board designs is a plus. The final design should deliver: - A modern, small-sized, wooden dining table that can comfortably accommodate 4 people. - Fully removable and easy-to-store table top. - Multiple game board designs that fit seamlessly on the table top. Th...

I own tons of digital documents composed of text data that need to be carefully and accurately entered into a SQL database. Seeking an experienced Data Entry Specialist who: - Has proficient knowledge in working with digital documents for data entry. - Demonstrates excellent typing skills for handling text data. - Has a strong understanding of SQL databases and is comfortable entering data into this platform. - Has meticulous attention to detail to ensure the integrity and accuracy of my data. - Possesses a track record of data entry efficiency and speed, without compromising quality.

As a developer seeking to collaborate on a significant project, I'm looking for an Android Expert to aid in building an encompassing app solution. BEES (Beneficial Experience and Entrepreneurial Skills) The freelancer should display a range of prior successful app creations. Bring your experience and detailed project proposals to the table. FUNCTIONALITIES We have a broad market in mind, and want our app to provide a range of relevant functionalities. This might include user login, push notifications, and payment integration. I fully believe, together, we can conceive an Android application masterpiece. Your experiential knowledge coupled with specific expertise in user-centric design and functionality will turn our vision to reality.

I'm in need of an expert to efficiently import my existing contacts into a mailing list that will capture detailed contact information from each recipient. This system should pave the way for sending weekly emails to my entire list effortlessly. Key tasks: - Importing my contacts into a mailing list - Ensuring that detailed contact information can be captured - Setting up an automation process to dispatch emails weekly Ideal Candidate: - Proficient in mail list automation and management - Proven experience in handling high volume contact information - Excellence in maintaining email scheduling and delivery efficiency

I need a versatile email data extraction expert who can efficiently pull email data from various sources such as websites, databases, and text files for South Asia region. The task involves: 1. Extracting emails from any source 2. Delivering the result in a CSV file Daily Target: 20k Emails Payout: INR 100 per 10k Emails (Unique)

I'm seeking a seasoned social media manager who can effectively handle the social media platforms of my engineering company based in California. Specifically, I require expertise spanning across Facebook, Instagram, and LinkedIn. It is preferred that the person brings to the table professional experience in construction/civil engineering, which aligns with my company's field of operations. A couple of key goals for this project include: 1. Increase Brand Awareness: Amplify our online presence through creating engaging content and well-targeted campaigns. 2. Generate Leads: Craft strategies tailored towards attracting and converting potential clients in California, notably engineering professionals and construction companies. 3. Community Engagement: Foster a free-flowing ...

I need a versatile email data extraction expert who can efficiently pull email data from various sources such as websites, databases, and text files for South Asia region. The task involves: 1. Extracting emails from any source 2. Delivering the result in a CSV file Daily Target: 20k Emails Payout: INR 100 per 10k Emails (Unique)

I need of code in Python (Selenium) to get information of product page of a marketplace. The method/function need receive the link of page, and the code must create a directory and save inside this directory, the video and images of product. Must create file (ex xml, csv) and save the title of product, description of product, price and discounted price when offered, basic information.

We need a data extractor, who would be helping us in extracting data (Emails) of South Asian countries. There are no strict restriction for use of sources, it could be set as per the convenience. Daily Target: 20k Payout: INR 100 per 10k emails (Unique) There is no maximum limit for daily email count. File would be shared in CSV format.

I am looking for a proficient developer who can integrate my WooCommerce e-commerce platform with AliExpress using JSON. The goal of this integration project is to effectively handle and manage pr...knowledge and experience in WooCommerce and AliExpress - Excellent JSON data handling capability - Proven track record in conducting successful one-time integrations Key requirements: - Establish a seamless one-time integration between WooCommerce and AliExpress - Enable efficient pulling and handling of product information, order statuses, and customer details - Ensure complete and error-free data import from AliExpress into my WooCommerce platform - Deliver a robust and secure integration solution Only bid if you possess the skill set required and can confidently deliver what I...

...custom report that merges both my sales and customer data. The report will include the following data fields: - Date - Customer name - Product name - Sales quantity - Sales amount - Other additional fields depending on the specific requirements at a given time. Notably, this report needs to be sent to a FTP server daily in CSV format. Ideal Skills: - Expertise in data analysis and report creation, specifically targeting sales and customer data. - Strong knowledge of CSV formatting and transferring files to a FTP server. - Ability to accurately arrange data fields in the specified format. - Proficient in creating actionable and easy-to-understand reports from complex data. Experience: Prior experience in similar projects is a significant advantage. Demonstrated abili...

I'm seeking a proficient Excel expert to develop an interactive dashboard and implement pivot tables within my project. Key responsibilities will include: - Setting up formulas and functions to aid in data analysis. - Creating a visually appealing, interactive dashboard. - Incorporating ability to filter and analyze data via pivot tables. - Customizing calculations and...data analysis. - Creating a visually appealing, interactive dashboard. - Incorporating ability to filter and analyze data via pivot tables. - Customizing calculations and generating summary reports in pivot tables. The ideal candidate should have a strong understanding of Excel's logical formulas and a knack for complex data interpretation. Extensive experience with dashboard design and pivot table utili...