Sql 2005 import csv dts jobs

As a web developer, I need assistance in building a PHP script to connect an HTML form to a database. I require a seamless integration wher... Duplicate, and Download PDF for data manipulation. - These functions provide a robust database management system ensuring efficient editing, deletion, duplication and downloading of entries. - Integrating text fields, radio buttons, dropdown menus and file upload fields in the HTML form with the database for seamless user input. Skills Needed: - Proven experience in PHP, HTML, JavaScript, and SQL. - Understanding of Database schema and associated concepts. - Attention to detail and good problem-solving skills. - Ability to work under tight deadlines. Please apply if you believe you're the right fit for this project. This needs to be ...

I'm looking for a skilled SQL coder to help with a project management initiative. This includes: - Developing a project-focused database management system - Implementing data extraction, transformation and loading processes The ideal candidate will show proven experience in SQL, especially with data coding. Proficiency in project-oriented tasks will be beneficial. Sound understanding of data analysis and reporting is anticipated.

## Automated / copy - paste bids wil...based job ## ## 8 hours job, Monday - Friday ## ## Experience : 4+ years ## ## Package: INR 65K per month ## ## Selection: Technical interviews (2 rounds) ## ## Open for freelancers from INDIA only ## JD for the Power BI/ Analyst resource MS Dynamics 365 + Power BI + SQL experience is mandatory. Only Power BI + SQL will not work. Experience in (at least 4 years) •     Building Power BI reports •     Dynamics 365 Business Central (BC) •     Working with different connectors via API for the Data warehouse •     SQL Server/SQL Queries •     Data tools and technologies to proce...

Complete a csv file containing 16306 rows/contacts (firstname, lastname, company, title) with linkedin url profile and languages (+tag the native one).

As a client, I'm seeking an expert developer to build a sophisticated web-based ap...integrating drawing tools such as lines, shapes, and text. - Means to measure drawings with tools like a ruler and protractor are to be included. - The interface should be interactive and accommodating with an Undo/Redo functionality for the user. - There should be a feature to adjust line size with a slider. Extra Functionality: Your ability to install a feature that allows users to easily import and export their drawings is an additional requirement for this project. The ideal freelancer for this task should have similar previous experience in developing intricate drawing apps and a deep understanding of user interface design. The functionality and users' ease of use are top prioriti...

...expertise in Oracle technologies. You will be responsible for designing, developing, implementing, and maintaining Oracle databases to support our organization's applications and business processes. This role requires proficiency in SQL, PL/SQL, database functions, triggers, ETL processes, and database performance tuning. Key Responsibilities: • Design, develop, and implement Oracle databases to meet business requirements. • Perform database administration tasks, including installation, configuration, backup and recovery, and monitoring. • Write efficient SQL and PL/SQL code to support application development, including the creation of functions, stored procedures, triggers, and packages. • Develop and maintain ETL processes to ext...

My application requires a skilled coder fluent in google scripting. The main task will involve automating data entry from Google Sheets into a task management system. Specific requirements for these scripts include: - Import data from Google Sheets - Create a task management system - Implement a task assigning feature - Include progress tracking This project is best suited for someone with a deep understanding of Google Sheets, Google Scripting, and building task management systems. Previous experience in automating data entry is a plus.

Hi, I need someone very experienced with importing variable products from Excel. Attached is a sample file. I'm having issues Doc on importing variable products using this plugin - :~:text=To%20import%20variable%20products%2C%20go,data%2C%20then%20run%20the%20import.

1. We have 32 backups from the same database as .sql-files. From one table of this database we need all instances in one csv-file (with the same codepage as stated in the sql-file ). So basicly you must: - import 1st backup on your sql-server - export the table "contracts" to "csv for Excel" - repeat for all 31 other backups - put everything together in one big csv-file that is readable in Excel (pls maintain german umlaute) 2. There should be a menu-item (i.e. "Report"); clicking this asks for the date "Welches Datum?"; the current date is proposed but can be changed by choosing a date in a calendar. The report should consist of: 1. All customers that have been added at the given date. 2. All...

I'm seeking a skilled Python developer to scrape data from Google Maps, specifically in the restaurant and café category. The area of interest is strictly on the local level, focusing on specific cities or states. The expected data: * Business Name * Phone Number * Address * Website * Email (if available) After scraping, the collected data needs to be properly formatted and delivered in CSV file format. Proficiency in web scraping, Python, and data handling is critical for this job. Experience in deciphering Google Maps data would also be beneficial.

I am searching for a Python developer proficient in Scrapy to forge web security testing tools. As a key deliverable, these tools must have the features below: - Subdomain Enumeration: Subdomains to be listed and categorized. - Directory Enumeration - Sensitive Parameter Detection - XSS Testing - SQL Testing Proven experience in creating security software is ideal. The developer should be adept at creating intermediate-level subdomain enumeration features. The project completion requires an understanding and implementation of Scrapy. I expect a functional, well-tested software package at the end of the project.

Please see attached CSV file we are looking for people to fill this out and then we will pick a freelancer with the best backlinks.

I'm searching for a skilled developer to create a React application from scratch with integration to a .NET API. This application will need to make use of an existing SQL database. Key Tasks: - Design and develop a new React application. - Implement integration to a .NET API. - Utilize an existing SQL database. Candidates must have expertise in: - Development of React applications. - Integration of .NET API. - Working with SQL databases. - **Core Functionalities:** - **User Authentication:** Secure login system using email and password. This system should ensure that user data is protected and only authorized users can access the application. - **CRUD Operations:** The ability for users to create, read, update, and delete data within the database seamlessly. ...

For my project, I require an expert well versed in Database Normalisation, specifically forms 1,2,3. The main goals of this normalisation process are to elimina...performance for better usability in my document database. Identification of primary key(s),foreign key(s),partial dependencies,transitive dependencies Ideal candidate skills: - In-depth knowledge of data normalisation - Experience with document databases Responsibilities: - Ensuring data integrity and performance - Applying normalized data to a documented environment Take note that we're not using SQL, NoSQL or Cloud-based systems. Instead, a document database system will be utilised. Your previous experience in such an environment would be a big plus. Your role will be pivotal in assisting this project to reach ...

For my project, I require an expert well versed in Database Normalisation, specifically forms 1,2,3. The main goals of this normalisation process are to elimina...performance for better usability in my document database. Identification of primary key(s),foreign key(s),partial dependencies,transitive dependencies Ideal candidate skills: - In-depth knowledge of data normalisation - Experience with document databases Responsibilities: - Ensuring data integrity and performance - Applying normalized data to a documented environment Take note that we're not using SQL, NoSQL or Cloud-based systems. Instead, a document database system will be utilised. Your previous experience in such an environment would be a big plus. Your role will be pivotal in assisting this project to reach ...

I'm on the lookout for an experienced Shopify app developer for my e-commerce business. I need an application that can be seamlessly integrated with customizable templates, products import/export features, and a payment gateway. The task specifically involves code in the file to reappear on reinstalling it. So, I am looking for a candidate who possesses the following: - Exceptional expertise in Shopify app development - Ability to handle complex app coding tasks Please include your previous Shopify app development experiences in your application. This is not just about app development – It's about developing an app that will stick and add business value to my Shopify store. Looking forward to your applications!

...Task: Imagine you are a data scientist recently hired by the government to demonstrate the new SQL database you have created. Imagine the government is also planning on storing the names of people involved in accidents. You produced a relational database in SQL. In your presentation, you should introduce the potential technical, ethical, and legal issues of storing the data. How might an SQL relational database address some of these? Present and describe an entity-relationship diagram (ER diagram) for the database. There are a lot of columns in each table, so do not show them all. Just show primary keys, any foreign keys, and a representative sample of 2 or 3 of the other columns. Present SQL commands for the following, using the full data set from all yea...

...Back up the Excel Spreadsheet by making a copy, keeping the last 10 copies 2. Automatically append the contents of 1-2 CSV files found in a folder to an excel spreadsheet 3. Move processed files into a COMPLETE folder 4. Log the results in a local text file. Full story: My software exports 2 CSV files daily to a local computer. These CSVs show the products that have been sold and the quantities of each product sold for that day. We need to add these rows of data to a master Excel sheet, and it should be done automatically when a new file is detected, OR at a specific time each day. The fields would be Date Sold, Erply ID, UPC, Internal ID, Description, Qty Sold The CSV files would be The Excel Spreadsheet would be called Pioneer_Supp_Sales

I need assistance involving incorrect output being produced by my PHP/SQL code. I require an expert who's proficient in: - Debugging PHP/SQL, primarily focusing on calculation issues. - Understanding how aggregated functions operate. My problem involves miscalculations within the aggregated functions. An expert in SQL that can accurately rectify this issue is necessary. The successful freelancer should having strong experience in PHP/SQL and great debugging skills.

I'm looking for a highly skilled PHP and SQL professional to assist me in managing my database. Specifically, I need help with: - Database Management: I require someone well-versed with handling databases, ensuring that their structure and performance are optimal. - Data Structuring: My project predominantly deals with tables and requires someone with an in-depth understanding of them to ensure efficient data structuring. Ideal skills and experience for this job would include a strong command of PHP and SQL, a deep understanding of database structures, and substantial experience in database management and structuring, especially tables.

As a research tool, I am looking for a capable freelancer to produce a simulation. The simulation will involve the creation of 'couples UE' and nodes to set a s...able to: - Collect specific signals namely: Received Signal Received Power (RSRP), Channel Quality Indicator (CQI) and Signal-to-Noise Ratio (SNR). - Allow variation of certain parameters like 'Transmit Power', 'Distance between the UE and node' and 'Environment type'. - Output the collected data in CSV format. Ideally, I need a freelancer with strong skills in simulation design, data analysis, and a solid understanding of signal transmission aspects such as RSRP, CQI, and SNR. Experience with CSV data output is advantageous. Your task will play a fundamental part in my res...

I'm looking for an experienced PHP developer to configure and run my application, integrating it with a SQL Server for data storage. Key requirements for the project: - Expertise in PHP development - Proficient in SQL Server database management - Ensure data security and integrity during migration Considering the urgency of the project, ideally looking for candidates who can start working immediately. Respond with your available start date and a detailed outline of how you intend to approach this project.

I am currently in need of a meticulous data entry specialist with a good sense and understanding of SQL Server. Your primary responsibilities would involve: - Organizing and processing data on our SQL Server - Keeping the database updated - Ensuring data integrity and security - Regular reporting and documentation This project requires a detail-oriented professional with excellent keyboard typing skills and profound knowledge of spreadsheets and online databases. An ideal candidate would have experience in managing SQL Server databases. Impressive organizational skills and a keen eye for detail are both a must to do well in this role. I await your proposals.

As part of my undertaking to analyze data, I require a program that is proficient in fulfilling the following tasks: - Open zip files containing PDFs. - Identify the number of pages within each PDF. - Output this data into a .xlsx or .csv file, containing both the file name and number of pages. Operating System: The program will be run on MacOS. It should be optimized for this system and function smoothly, without causing any crashes or system lags. PDF Structure: The PDFs within the zip files will all have the same structure, a factor that can be taken into account while creating the program. Ideal Skills and Experience: Applicants should have experience developing similar programs or handling similar projects. Familiarity with MacOS will be important, as well as a mastery of d...

Hello, I have a list of 700k emails. I need to opt them into my Aweber form one at a time, rotating USA proxies each time & changing the browser fingerprint. Here is the process: 1. Iterate through a CSV list of emails 2. Use Smartproxy with a new IP address per request 3. Ensure that the cookies are cleared, and the fingerprints are changed. 4. Visit the website, type in the email address, and then submit 5. Wait until submission completes 6. Wait a random amount of time (between 1-3 seconds), and move onto next email. 7. We can multi-thread this in order to run a few instances at the same time. Can you get it done? Thanks!

I have a stored procedure on a MS SQL Server that is running a SQLCMD statement to output a CSV file in the following format where #sqlStatementHere# is the SQL string. I won't give specifics to the database structure as that part is irrelevant. sqlcmd -s, -W -Q "set nocount on; #sqlStatementHere#'" | findstr /v /c:"-" /b > '+@OutputFilePath; My problem is that some varchar fields contain special characters such as quotes and double quotes and commas. This is causing some rows of the CSV file to be invalid. I am assuming we can pass in some parameter to this SQLCMD to escape special characters or perhaps wrap the entire varchar data in double quotes. You will not be given access to the database for this project. You can...

I have a stored procedure on a MS SQL Server that is running a SQLCMD statement to output a CSV file in the following format where #sqlStatementHere# is the SQL string. I won't give specifics to the database structure as that part is irrelevant. sqlcmd -s, -W -Q "set nocount on; #sqlStatementHere#'" | findstr /v /c:"-" /b > '+@OutputFilePath; My problem is that some varchar fields contain special characters such as quotes and double quotes and commas. This is causing some rows of the CSV file to be invalid. I am assuming we can pass in some parameter to this SQLCMD to escape special characters or perhaps wrap the entire varchar data in double quotes. You will not be given access to the database for this project. You...

I'm in need of a proficient backend developer to implement key functionalities related to User Authentication, Database Management, and API Integration. The ideal candidate should have: - Proficiency in Java, PHP, JavaScript, SQL, MongoDB, and AWS. - Solid experience with backend frameworks - Spring Boot, Laravel, and Django. Your job will be working on an Examination Portal for a university. It can be desktop application as well as Website.

Hi Kazi Md Nurul I., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

...tool that has the functionality to accept input of geocoordination data from a polygon on a map and provide the addresses encompassed by that polygon. The primary aim of this tool is the extraction of address data for later analysis. - The tool must be versatile, capable of handling polygons of absolutely any size and shape. - The extracted data output must be formatted in Comma Separated Value (CSV), which is ideal for my analysis needs. This project would be perfect for someone who has a strong background in geographic information system (GIS) technology and experience in data extraction and manipulation. Understanding of various geocoordinate systems would also be advantageous. Dedication to accuracy is paramount, as these data extracts will be used in high level analysis. O...

I'm seeking a developer skilled in SSIS, C# and SQL for this project. The task involves fetching JSON data from an API using oauth with a username and password. This data will then need to be written to a SQL table. The main specifications are: - API provides JSON data - Only specific fields are required from the JSON data for the SQL table write operation - These fields are constant and will not change in the future Confident understanding and experience with JSON, C#, API fetch, SSIS, and SQL are paramount. The ideal candidate will be adept at creating smooth integrations, dealing with API provided data and handling SQL scripts.

I am in need of a freelancer who knows how to easily import a shapefile into the ArcGIS Pro 3.2 system. While I am attempting to import the file, I am not receiving a specific error message, but the file still fails to import successfully. Ideally, the candidate for this project would be someone who: - Has extensive experience with ArcGIS Pro, particularly version 3.2 - Can troubleshoot issues with file imports - Has worked with shapefiles before and understands common problems and solutions with file importation in this format. Ultimately, the goal of this task is to have the shapefile successfully imported into my ArcGIS system without issue. Fluency in English is also desirable for any potential troubleshooting communication.

I require a proficient team or individual to import property listing from Airbnb to or agoda. You wil be given a list of profile url from Airbnb to import into Agoda or Each published listing will be paid USD5 * Need not concern about property's setting , policies etc . Just get it published.

I'm in need of a service that uses Excel to send scheduled emails to an assorted list, ideally with a frequency of every 5 minutes. Details: - The operating system I'm using is Windows. - The email service that t...list, ideally with a frequency of every 5 minutes. Details: - The operating system I'm using is Windows. - The email service that the application would need to interface with is Outlook. - The application should ideally be able to handle the CSV Excel file format for the email list. Ideal Skills and Experience: The ideal candidate for this project would have experience with Excel, as well as know how to create an application that interfaces with Outlook's email system. Familiarity with Windows is also crucial. Experience with email schedules, and ...

...method like JWT (JSON Web Tokens). This includes login, registration, and role-based access control. 2. **RESTful API**: Develop a set of RESTful APIs using .NET Core to handle data exchange between the Angular frontend and the backend server. This includes endpoints for CRUD operations (Create, Read, Update, Delete) for various resources. 3. **Database Integration**: Integrate a database (e.g., SQL Server, MySQL, PostgreSQL) with .NET Core using Entity Framework Core or another ORM (Object-Relational Mapping) tool. Ensure proper data modeling and management. 4. **Frontend Development with Angular**: Build the frontend user interface using Angular. Design and implement components, services, and modules to create a responsive and intuitive user experience. Utilize Angular featu...

I'm currently struggling with an encoding issue in my Salesforce reports. These reports are in CSV format and some characters are appearing as symbols. This is making the data difficult to understand and use. I need someone who can efficiently resolve this issue. Ideal Skills: - In-depth understanding of Salesforce and CSV format - Proficient in Python - Strong familiarity with encoding issues - Demonstrated problem-solving capabilities I am seeking an expert who can quickly and accurately diagnose and address this unique problem. Please share any previous experience fixing similar encoding issues.

...startup that is innovating at the leading edge of Artificial Intelligence movie and game production. Our competitors are the likes of Sora, DALL.E and Runway.ml. This remote work job is for initially 10 hours per week at NZD $31 per hour with the opportunity for promotion in the future. Technologies that you must be able to use competently. C# and LINQ Visual Studio 2022 MS Web API Javascript SQL We are looking for someone who: * Is fundamentally enthusiastic and passionate about learning AI technologies. * Can learn quickly. * Can speak English well enough to communicate appropriately in a joint Zoom session with our English speaking developers. * Be available to RDP into our data center resources from 3pm and 5pm Monday to Friday New Zealand time while performing Zoom m...

I am looking for a skilled freelancer with profound expertise in Excel and SQL, particularly on the Mac platform. Key tasks include: - Importation of numeric data from an Excel workbook into Microsoft Azure Data Studio using Python - The data is arranged over multiple worksheets, all of which are interrelated. - Apart from the primary data importation job, the freelancer will be tasked with devising an efficient method of performing this task on a daily basis. Ideal Skills: - Strong Excel and SQL skills with experience in data migration. - Proven ability to handle related datasets spread over multiple worksheets. - Experience with automation, to maintain daily import tasks. - Familiarity with Mac operating systems. Your bid should demonstrate a clear understan...

Please completely read this project description, and check attached requirements file before bidding. TECHNICAL REQUIREMENTS Solution Solution must be delivered in Visual Studio 2022 Community Edition Awarded freelancer must provide SQL scripts to create database and tables. Prefered solution projects structure in VS Solution: API DTO Models Repository Services WebAssembly Backend Asp.net Core 8 SQL Server 2019 or later Frontend Blazor Web Assembly The budget placed on this project is already final and negotiations for it will not be entertained. Tip is only provided to those freelancers who accomplish the job before the estimated days by the freelancer when bidding. I only pay additional money for new additional requirements, not included in original s...

I'm seeking an experienced Laravel developer with knowledge in SQL Database Management, MQTT, and IoT integrations. Essential skills and experience involve: 1. **IoT Devices Integration**: The professional should have previous experience integrating Laravel with various IoT devices. In this case, the object of integration includes smart home devices, industrial sensors, and wearable devices. 2. **SQL Database Management**: I need assistance in managing my SQL database for various functionalities. Specifically, the task requires skills in data retrieval, data storage, and data synchronization. 3. **Template Customization**: I have my own pre-designed templates which need adjustments. The main element to be modified is the layout and structure. Experience in cust...

Skills required: Good English, HTML, CSS, JS, JSON, API. 1) Change theme to match from - Thread icon - Link icon - Age / Date Posted - Total comments - Color/font theme - User comments when posted/ed...gallery 6) When a thread isn't loaded widen thread list so it takes up 100% width - When a thread is loaded slide it in from the right to the left - Above Tweet button place X button to close thread 7) Add new property 'Regex' for each subreddit added - For example, filter out threads that have a specific word in their title All values including 'Regex' need to be able to be imported/exported via "Import Data" and "Export Data" button on left bottom navbar Project must remain as a portable html that does not require building or specia...

I am in need of a seasoned PHP/SQL programmer to create a robust Admin Panel for my website. The panel should focus mainly on two key functionalities: User management and Content management. For User management, the software should allow me to function as a Super Admin with the rights to full access of all components and operations within the panel. Content management is another critical feature. It should specifically cater to handling products, allowing me to conveniently add, update and remove product listings. Ideal skills for this project includes: - Proficient in PHP/SQL - Experience in building admin panels - Sound understanding of user and content management - Familiarity with product-based platforms is a plus. Your proposal should include your previous work s...

...robust functionality and user experience. • Provide documentation for the plugin, including installation, configuration, and user guides. • Offer technical support and updates as needed to address any issues, improvements, or Moodle updates. Requirements: • Proven experience in Moodle plugin development, with a portfolio of previous projects. • Strong proficiency in PHP, HTML, CSS, JavaScript, and SQL. • Familiarity with Moodle's architecture, coding standards, and best practices. • Excellent understanding of UX/UI design principles, especially in the context of educational platforms. • Ability to work independently and collaboratively in a remote environment. • Strong communication skills, with fluency in English. • A passion for...

I am looking for someone who can help me export Instagram followers from a ...usernames of each follower, no additional information required. The ideal candidate for this job is tech-savvy, detail-oriented, and comfortable with data extraction and Excel. Experience with social media APIs, especially Instagram, and Excel data handling will be crucial for successfully completing this project. Key Responsibilities: - Extract usernames from a public Instagram account - Import the data to an Excel file - Ensure accurate capture of information No particular organization or formatting in the Excel file is needed. Let's keep this straightforward and simple. Your primary goal is efficiency and accuracy in data extraction. Please share any similar projects you've worked on, a...

I need a proficient programmer capable of creating an invoicing progr...are some specific requirements you need to be aware of: - The program must be able to convert CSV files into both Word and PDF formatted invoices. - It should include sections relating to personal, product, and payment details directly from the CSV files. - This program should have the functionality to use predefined templates, but also allow for customization as per my needs. In addition, I want the ability to generate clean and minimalistic invoices. Your experience in similar projects, strong programming skills, and understanding of invoice formatting will be valuable for this work. Your attention to detail will also be crucial to ensure all information correctly transfers from the CSV...

I have a php js mysql based software. a part of it already imports csv data and makes records in the system. I want to make some improvements (remove columns, change calculation mode, add a bulk action button) The instructions are in the following videos video 1, purchases: video 2, sales and bulk button: (I am attaching csv files in the project)

...saying “I am AI” so that I can discard it. I'm looking for an expert with a clear understanding and experience in enhancing WooCommerce stores with bulk order functionality. Your Task: - To include a seamless quick 'add to cart' feature for multiple products on our WooCommerce store. - Enable bulk discount pricing to encourage customer-bound loyalty and enhance user experience, - Integrate a CSV file import feature for ordering. Skills and Experience: - Proven experience in creating similar bulk order features. - Extensive knowledge and experience working with WooCommerce. In your bid, please highlight your experience working on similar projects. Advise on how you intend to implement these features based on previous work done. I look forward...

We have a collection of books that we need to enter into a database. We will provide you with the ISBN-13 via a .csv file. Your objective is to lookup the ISBN-13s and provide the following information, within a separate .csv file: - Title - Author(s) - Main Author Bio (Three full paragraphs) - Format - Publisher - Publication Year - Image URL - Short Description (Between 150-160 characters, enticing and informative) - Full Description (One full paragraph) - Average price online (Amazon preferred, but other retailers as well) - Category/ies (Can be multiple, but must only be from this list) Biography Black Authors Business & Professional Growth Children's Comedy Cooking Drama Education Ethnography Family Fantasy Fiction Finance Health & Wellness History Language...

14 
app folder ✔ What is your project named? … profi_file_upload ✔ Would you like to use TypeScript? … No / Yes ✔ Would you like to use ESLint? … No / Yes ✔ Would you like to use Tailwind CSS? … No / Yes ✔ Would you like to use `src/` directory? … No / Yes ✔ Would you like to use App Router? (recommended) … No / Yes ✔ Would you like to customize the default import alias (@/*)? … No / Yes It's a very simple task; in the already created and empty project, only components for uploading photos need to be made. In the project, a backend endpoint is already made that accepts multipart/form-data. The assignment already includes a repository with the application, so it's really not about creating the whole application; I only n...

I'm in need of experienced hands to refine and improve my ongoi...- Adding Search Functionality: There is a requirement for more advanced search functionality to be integrated into the site. - Report Generation: A new feature needs to be added that enables the users to generate reports. - Dealing with CSV Exports: Being a complex site, it makes use of CSV file exports. The professional I choose must be comfortable handling this. Skills needed: - Strong knowledge in handling and optimizing databases. - Proficiency in debugging and problem-solving. - Experience with adding search functionality. - Familiarity with CSV file exports and report generation. Given the complexity and specifics of the website, applicants must have relevant experience and expertise to h...