Sql server 2005 dts csv import jobs

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I have a PDF that is meant for email but I'm looking to convert it into HTML so that I can import it into MailChimp. The original PDF has a mixed layout with text and images. I need the resulting HTML to be mobile-friendly, professional-looking, and containing clickable links. Key requirements: - Convert PDF to HTML: The PDF contains a mix of text and images. I need this content to be faithfully translated into HTML. - MailChimp Compatibility: The HTML should be structured in a way that it can be easily imported into MailChimp. - Mobile-friendly: The HTML should be responsive and mobile-friendly to ensure a consistent experience across devices. - Professional Design: The resulting HTML should look professional and sleek, keeping in line with email marketing best practices. - C...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project...

Setup of accounting software, import and clear data to have it ready to work.

I'm looking for a logistics sales executive who specializes in air and sea freight in the Chennai region. Main Tasks: - Develop and manage relationships in the manufacturing, export, and import sectors. - Target businesses who could utilize our freight services for their operational needs. - Increase brand visibility and leverage existing networks to generate sales. Key Skills and Experience: - Proven sales experience specifically in air and sea freight logistics. - Strong network within manufacturing, export, and import sectors in the Chennai region. - Excellent interpersonal, negotiation and networking skills. - Proactive with solid business acumen to identify new opportunities. The right candidate will have a sound knowledge of the logistics industry and be able ...

...AI-driven funding opportunity matching, interactive user profiling through an intelligent quiz, and efficient application assistance. Scope of Work: The project encompasses the following key tasks: Template Customization: Adapting the AI SaaS Dashboard template to fit the unique branding and functional requirements. Database Integration: Configuring and linking an external Airtable database to import and regularly update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure login/logout capabilities and user profile management. AI Chatbot Development: Integrating OpenAI’s ChatGPT API to create an interactive chatbot that conducts a business background quiz and uses responses to tailor funding recommendations. Opportunity Matchi...

DEFININTIONS local environment: developers laptop client: Wayne contractor: Faisal and his team PROBLEM STATEMENT Due to missing connection to database, the website on clients local machine is generating errors thus preventing development. SOLUTION: Create a replica of RDS production server (to be called "dev") on AWS, that can be used for development on local environment and for staging testing later on. CONTRACTORS ANTICIPATED TASKS (high level) 1. Take backup of production database on AWS 2. Create new RDS instance (server) using the backup and restore the backup. 3. Configure and verify the network settings to make connections over internet. 4. Test connection of new dev database with web application on local environment. DELIVERABLES 1. Demo showing the we...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

Server Admin for and Node.js

I'm looking for an expert to engineer an Asana project with a focus on workflow automation. The project should have robust features such as: - Task management: I need a proper setup to facilitate the creation, allocation, and tracking of tasks. - Collaboration tools: The Asana project ...project creation, especially in the field of workflow automation, will be preferred. Your experience in creating an intuitive, professional, and sleek UI will come handy. A solid understanding of efficient task management, collaboration, and tracking tools is also essential. Finally, your ability to understand and translate requirements into action will set you apart. I have attached the CSV file i'm hoping to import and would like suggestions on including templates to use across ...

I have a specific custom Google map that I need data from. The data I require includes: Business name, Customers name, Address, City, State, Postcode, website, phone. Key points: - You will be scraping a specific custom Google map - The data needed includes Business name, Customers name, Address, City, State, Postcode, website, phon... Key points: - You will be scraping a specific custom Google map - The data needed includes Business name, Customers name, Address, City, State, Postcode, website, phone Ideal Skills: - Proficient in web scraping techniques - Expertise in data extraction from Google Maps - Experience in handling large datasets - Attention to detail for accurate data gathering. Ideally i would like this in a CSV format. There are aprox 720 records in the custom g...

I'm in need of a seasoned IT professional who can set up a Windows-based VPN server for my company. The primary purpose of this server is to allow our employees to access the company's resources securely from remote locations, which is currently a pressing need for us. Key Requirements: - Configuration of a VPN server on Windows OS - Setting up a secure connection for remote employees - Allowing simultaneous connection for a small user base (1-10 users) Ideal Skills and Experience: - Proficiency in Windows OS - Hands-on experience with VPN server configuration - Knowledge of network security best practices - Prior experience with remote access solutions Your expertise will play a crucial role in enhancing the security and efficiency of our remote w...

... - Responsiveness: The design must be fully responsive and work flawlessly on all devices (desktop, tablet, smartphone). - SEO: It must be possible to optimize each individual listing for SEO, as well as the overall website. - Security: Implementation of security measures to protect user data. - Performance: The website must load quickly and be highly performant. - Import Functionality: Ability to import an Excel file so that entries are automatically created in the backend. 2. Design and User Interface: - Pixel-Perfect: The highest priority is given to a pixel-perfect implementation of the provided design. - Favorite Lists: Users should be able to create and rename multiple favorite lists. 3. Project Management: - Timeline: Please provide an estimat...

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...

Our existing CGI ...script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and effici...

I'm looking for a professional who can set up an automatic download of mainly .csv files from FTP, SFTP, https and webscraping-login. The script should be configured to run daily/weekly at pre-defined time - configurable for each file. Requirement: Check after each download that the download has actually been downloaded. Notify user if any errors occur. Key Requirements: - Configure FTP download automation on Windows enviroment or hosted. - Schedule the download to occur at defined day/hour. - Check if download has been succesful. - Clear commented code. I only respond to bids where the bidder clearly has read the description...sorry (not really sorry, lets not waste each others time :) ) I prefer fixed price, but have entered hourly - let me know your suggestion.

...been added to an import file. - Improving the style sheet so as to automatically map the new fields from the import file. The ideal candidate for this job should have experience with layout adjustments in XSL style sheets, automatic mapping of new fields and VB coding. Your skills and experience in rearranging content layout, updating fonts & colors, and altering data display formats will be highly appreciated. Don't hesitate to place your bid if you can deliver this effectively and efficiently. This is fairly simple task each year but neither of us have time to do this today and we are in a time crunch. Are you or someone at BDO available to modify this asap. Right now, a couple of us are working until the middle of the night for the past 2-3 weeks. Th...

I've encountered an internal server error on my website when accessing a specific page. This issue is particularly critical as some of my visitors are unable to access my site due to this error. While some visitors can browse the website, others are completely blocked. Key Project Details: - The error is triggered when accessing a specific page. The rest of the website is accessible. - The issue is causing a split in visitor access, with some able to view the site consistently and others unable to access at all. - The problem is particularly urgent as it is directly impacting my site's usability. Skills and Experience Needed: - Proficient in troubleshooting common internal server error causes. - Experience in addressing website access discrepancies for users based...

I encountered an internal server error while trying to access a specific webpage on my website. The error is isolated as it only occurs on certain pages. Some visitors can access the site and some cannot. For example: I can access with WiFi but not with my mobile connecction. The ideal freelancer for this project should have: - Proficient understanding of server-side technologies and the workings of web servers. - Strong problem-solving skills and the ability to troubleshoot technical issues effectively. (Wordpress) and (godaddy) - Experience in handling internal server errors, ideally on specific pages. - Good communication skills to effectively inform me of the error's cause and resolution. Please contact me if you have experience with this issue and think you...

...with the data visualizations, such as filtering views based on time or sentiment. Tools & Techniques: Web Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. D...

I am in need of a skilled freelancer who can help me extract all products from an online shop and import them into my Shopify store. Key Responsibilities: - Extracting all products from an existing online shop - Importing/copying these products into my Shopify store I expect the freelancer to: - Ensure all product information is correctly ported over like variants, prices, ean/gtin, description, collections,... - Maintain the quality of product listings - Ensure the product images are not lost during the import I'm looking to work with someone who has: - Experience with product extraction and import - Proficiency in Shopify - Attention to detail Please provide a timeline for completion when bidding. Please check the size of the shop and the number of products...

I'm in need of an experienced web developer with strong shell scripting skills. While the main purpose of the website application is not specified, it's targeted at the general public. Ideal Skills and Experience: - Proven expertise in web application development - Experience in creating websites geared towards the general public - Robust skills in shell scripting - Ability to independently make decisions to enhance website functionalities Note: As the tasks for shell scripting are undefined, a flexible way of working is preferred for meeting emergent needs in the project.

...warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills,...

I'm in need of an IT professional to set up an SMTP server on my Debian server. The primary purpose of this setup is to allow the server to send out automated email notifications for a custom-built application. Key requirements and expectations for this project include: - Setting up an SMTP server specifically utilizing Sendmail software on a Debian server - Ensuring that the configuration is optimized for automated email notifications - Providing guidance or documentation on how to integrate the SMTP server with my custom-built application Ideal candidates for this project should possess the following skills and experience: - Proficiency in working with Debian servers and setting up SMTP servers - Prior experience with Sendmail configurat...

...up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications  Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred.  8+ years of total experience.  Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle.  Proficiency in SQL and PL/SQL programming languages.  Strong understanding of database design principles and data modeling techniques.  Experience with database performance tuning and optimization.  Excellent communication and leadership skills.  Ability to work effectively in a fast-paced environment and manage multiple priorities.  Relevant certifications in Netezza and Oracle te...

Resetting our FireLaser DTS with a Siemens Logo device using Modbus

I have a PostgreSQL database hosted on AWS. When trying to connect to my database server from my web application, I'm consistently receiving a TCP/IP error. Key Project Points: - The issue is specifically related to the TCP/IP connection between the web application and the AWS PostgreSQL database server. - The PostgreSQL database is hosted on AWS; it's not a local instance. - The web application is the only service experiencing this issue with the server. Ideal Freelancer: - Proficient in AWS services, particularly Amazon RDS for PostgreSQL. - Strong background in dealing with network errors, particularly TCP/IP. - Experience in troubleshooting web application and database connectivity issues.

...two-week timeline. The Laravel-specific requirements are as follows:- 1. Fix the Home Dashboard to display real data instead of dummy data in Laravel. 2. Implement form data transfer from the website to the CRM Enquiry Menu in Laravel. 3. Ensure that won enquiries are correctly displayed after conversion to contacts in Laravel. 4. Highlight the current menu item on the left in Laravel. 5. Correct CSV download functionality in Contacts, ensuring filters, headers, and special characters are handled properly in Laravel. 6. Enable clicking anywhere on the contact data table to open the view of that particular contact in Laravel. 7. Remove the display of the last date from the top of the contact view in Laravel. 8. Adjust calendar functionality to match design specifications in Larav...

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

Hello After a reboot of a server our cpanel not working anymore, need urgent helpwith IMMEDIATE availability

...CRM: - Create a custom module named "Partners" for financial advisors. - Add financial advisors to the Partners module once they respond to the drip campaign. - Referred leads entered into the Leads module need attributed to the corresponding financial advisor in the Partners module. - Provide a link in the Partners module to a report listing all referrals made by each advisor. Zoho Campaigns: - Import the list of 10,000 financial advisors into Zoho Campaigns. - Ensure campaign emails come from my emails address and not a generic / bulk address. - Basic set up of two email drip campaigns: - A 6-week weekly drip campaign. - A 24-month monthly drip campaign. - Ensure only a select number of advisors are added to the 6-week campaign daily. - Transfer advisors from the 6-w...

I'm in need of a programmer well-versed in TIA (V18) Unified and JavaScript to assist with a specific task. - **Skillset**: Proficiency in TIA (V18) Unified and JavaScript is crucial. Experience in data manipulation and handling would be an added advantage. Your primary responsibility will be to help me export a datalogfile created in TIA (V18) Unified to a CSV file using JavaScript. The purpose of this export is for archiving, as the datalogfile is stored locally. Please reach out if you believe you have the right skills and experience for this task.

I am looking for a proficient C# developer who can build a .Net 8 Console application with in-depth CSV handling capabilities. You will need to be able to: - Import CSV files; - Validate CSV data, specifically focusing on data format and range checks; - Convert validated CSV data to a c# DTO format; - Post the converted data to an API. Responding to errors is a significant part of the project. The application should be able to handle any issues encountered during the import, validation, or conversion processes seamlessly. Proficiency in C# is a core necessity, with previous experience in CSV handling and data validation highly desired.

When designing a logo for the MANZU Company, it's important to capture the essence of the business and its values. Here are some inspiration and ideas for their logo design: 1. Symbolism: Consider incorporating symbols that represent the company's diverse offerings, such as a Chinese symbol or icon for the restaurant aspect, a shipping container or globe for the import trading business, and construction-related symbols for the contracting services. 2. Colors: Utilize colors that evoke a sense of quality, reliability, and professionalism, such as deep reds, golds, or blues. These colors could also represent the company's Chinese roots and the construction industry. 3. Typography: Choose a bold, modern, and easy-to-read typeface that conveys strength and reliability....

I am looking for an experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excelle...

The project consist to convert a json format file to some csv format files

...functionalities include: - Form submission - to post HTML data to the database. - Data visualization - to display posted data on the webpage. Ideally, the freelancer should have: - Proficiency in WordPress plugin development, - Expertise in HTML, and - Familiarity with handling data through form submission and visualization techniques. The data integration will not involve manual input, spreadsheet import, or API connection as the data is already displayed on the page. We just need it saved. This is to complete a mostly complete wordpress plugin which already captures the user ID, Data source ID and captures the html data which needs to be stored. We have a problem getting the plugin to trigger an Ajax response which we need help debugging. Please submit your bid if your ...

I'm seeking a professional to assist with integrating my python scraping script output to my personal WordPress site in real-time. Key Requirements: - The integration should be real-time and without the need for page refresh - The current output of the python script is a CSV file, but can be Json or another Ideal Freelancer: - Proficient in Python and WordPress - Experience with real-time data integration - Familiarity with data formats (CSV, JSON, etc.) - Excellent communication skills to deliver a seamless solution Looking forward to working together.

...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we

I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portf...

I'm seeking a developer who can create a script or plugin that pulls content from Facebook, Twitter, and Instagram on a daily basis and automatically imports them into my WordPress site as separate posts. Key Requirements: - Scheduled Import: The content should be imported into WordPress daily as individual posts. - Post Categorization: Each imported post should be assigned a category based on its source (e.g. Facebook, Twitter, Instagram). - Immediate Publishing: The imported posts should be published immediately upon import. - Instructions on how to setup App/ID/secret for each social channel Ideal Skills: - Strong knowledge of WordPress and its internal mechanisms. - Proficiency in working with the APIs of Facebook, Twitter, and Instagram. - Experience in developin...

...will go to 'BodyParts3D', 'Lluis Vinent' and 'Z-Anatomy'. The tools need to be set up for and be owned by the client. Profile: >3 years of experience in tailored projects in Unity Experience in the set up and use of databases Good organization and communication skills Necessary missions (estimated 100 euros): Share the project on Unity Hub Create a database containing a .csv file (the translations) and a series of texts (the definitions), Link it to the objects (the anatomical structures) through the existing functions already set up, Adapt the app for Windows, Mac and Linux, Set up a functional and reactive web viewer, Explain how to paste it on a website and how to update it, Optional missions (estimate...

...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated expertise in SQL...

I'm looking for a server administrator with intermediate Drupal experience to handle ongoing maintenance. Key responsibilities include: - Monitoring the server's performance and troubleshooting any issues that arise. - Ensuring the server remains secure and up-to-date with the latest patches. - Regularly backing up the server's data to prevent loss in case of failure. - Updating and maintaining the Drupal installation, ensuring compatibility with the server setup. Ideal skills and experience: - Proficiency in Linux server administration and management. - Intermediate level of experience with Drupal, including installation and configuration. - Strong troubleshooting and problem-solving skills. - Understanding of best security practices for server...

...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled f...

Bought a react eCommerce template (front-end & back-end) from theme-forest. Provided documentation is not enough for server side installation. I need professional assist to install the project on server side and install the theme on server side.

I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...

I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

I'm seeking a proficient scriptwriter to design an Airtable...relationships. The main task for this script will be to focus on combining data from the parent-child and combining it onto 1 row each. Specifically, the required updates will involve: - Combining Parent and all children data onto same row - Taking DOB field and splitting into a Month field and a Year field - The end result should be a base where I can upload a new CSV and it outputs the desired result into a new table that I can download a csv from The ideal candidate for this role is someone well-versed with airtable scripting and data management, specifically having a strong knowledge of number fields. Your experience with manipulating parent-child data relationships will be crucial for successful compl...