Importing csv file sql server 2005 express jobs

Looking for a SQL Expert who is good with Transact SQL, stored procedure and expert with MS SQL server. Task is related to trigger and XML and should hardly take one day to complete

I have a webform developed in HTML5, PHP, SQL, and JavaScript. I'm looking for a developer to make a few key improvements. PRE-BUILT I have currently built a where the user selects a customer from a dropdown and selects the number of products to add to this order. Each customer from an SQL table called 'customers' has its own price class 'customerPriceClass' When the user selects the number of products, the page updates and adds rows for each product with a dropdown menu where the choices are fetched from another table called 'products'. The user selects the product and enters the number of units. NEEDED: STEP1 For each row of products the corresponding price from the table 'prices' should be fetched that is associated with t...

...calculate the hourly rate and the time needed to complete different task documents, on an agreed fixed price. The best offers with the right experience will have the opportunity to work with us on a long-term basis. Also, Good prospects for the right developers, based on the performances evaluated over a period of time, once you established your skills. Need to provide the changed code details and sql queries if any at the end of each sub-task, with the changed code line numbers. Unlimited Revisions are needed. Any bugs created due to your own developments are to be fixed on free of Charge. Recruitment is for a long-term big project as such, all the developers are subject to practical skill test for which not paid. Please send your details for the below-mentioned questions....

...servers on Linux systems. The primary goal is to streamline the game server setup process, reducing manual setup and configuration time. The script should handle the entire setup process, from initial server preparation to the final game server launch. Script Requirements: — Automated Deployment: Automatically download, install, and configure game server software. — Configuration Management: Scripts should read from config file — Compatibility: Must run on Ubuntu — Security: Incorporate basic security settings to protect the server. — Efficiency: Minimize resource usage during setup to not impact server performance. Skills Required: — Proficiency in Python or Bash scripting under Linux environments. &m...

I need an experienced C# developer to create an advanced contact form for my existing website and execute its storage function by integrating it with MS SQL Server. Key Requirements: - Development of a contact form with fields for Name, Email, Phone number, and Address. - Form validation should be included to ensure data input integrity. Specifically: * Email format should adhere to standard email format * Phone number input should match a predefined format. Preferred Skills: - Proficiency in C# and MS SQL Server - Experience in form creation and data validation - Attention to detail for error-free functionality.

I am looking for an expert who can aid with the design and development of an SQL database and a coherent PHP framework. The ideal candidate should have extensive experience with: - Designing efficient SQL database structures for small-scale databases (less than 1000 records). - Writing comprehensive SQL queries. - Effectively integrating PHP with SQL databases. The purpose of this project is to utilize SQL and PHP to innovatively design and construct a web application. The applicant should have a strong track record of building successful, high-performing web applications. Emphasis will be placed on the ability to manage and manipulate small-sized databases. Given the nature of this project, a meticulous approach to data management and a keen eye for de...

Hi we need a professional linux server administrator I need a series of tasks regarding setting up a linux server and configuring it's security. Analytical details will be given in a doc in chat. Every step needs to be reported in a doc according to the requirements, including the screenshots of the system and the commands used. Deadline is in 12 hours from now, we need to do as much as possible Budget: $70 USD (fixed)

I need help to compile my War file and run it on my Apache Tomcat 7.061 Server. Tomcat server needs setup. War file is dashboard to an app. It used to run fine before I migrated to a new server. The machine is Windows 2019. I have the old Tomcat. Backup.

Hi we need a professional linux server administrator I need a series of tasks regarding setting up a linux server and configuring it's security. Analytical details will be given in a doc in chat. Every step needs to be reported in a doc according to the requirements, including the screenshots of the system and the commands used. Deadline is in 12 hours from now, we need to do as much as possible Budget: $70 USD (fixed)

...screen sharing) Resource must have Knowledgeable of the ASP.NET framework, Microsoft SQL Server and design/architectural patterns (e.g., Model View-Controller (MVC)). Knowledge of web development languages, such as HTML, XML, CSS, JavaScript and AJAX. Experience with database servers, particularly Microsoft SQL Server 2016 or newer/ In-depth knowledge of the .NET infrastructure Experience with architecture styles/APIs (REST, RPC). Understanding of the Agile methodology. Knowledge of REST and RPC APIs. Strong communication and interpersonal skills with an ability to work well in a team setting. Advanced proficiency in C#, F#, or VB.NET; preferably all three. Highly experienced using Microsoft SQL. Outstanding analytical, problem-so...

...for standard file management operations. Key Features: - Crafting a treeview interface for file navigation. - Context-specific (right-click) options for creating, deleting, and renaming folders and files. - The application will run on Windows. The candidate would ideally have a strong background in WPF and C#, with substantial experience in creating file manager applications. A firm understanding of directory structures and file manipulation is necessary. Despite the fact that specific functionalities for file manipulation haven't been explicitly mentioned, familiarity with copy, move, determination of file type, and editing file properties is considered an asset. I am in the need of quick turnarounds, therefore prompt and effec...

...hospital usage, I need a proficient developer to create a secure server that is cloud based. The server should be crafted in a way that integrates HL7, placing a strong focus on data security, as we will be storing confidential patient information. Key tasks to undertake include: - Implementing encrypted data storage and retrieval, ensuring integrity and confidentiality of patient data. - Setting up HL7 message parsing and processing, enhancing data interoperability. - Facilitating user authentication and access control via role-based access control, limiting system access to authorized personnel only. To meet these tasks, you should bring a proven familiarity with encryption methods and SSL/TLS certificates to secure server connections. It's critical to o...

This project requires building a robust flight booking system that will function as the primary focus of the software. Ideal freelancers should have a strong background in this area. Key Details: - Essential components of the system will include flight booking capabilities along with...book or cancel reservations. - Ability to review and rate hotels is a mandatory feature to incorporate. Payment Details: - The software system should integrate a secure payment gateway for the booking procedure. - I prefer to accept payments using Credit/Debit cards and Bank Transfers. Previous experience in developing booking systems and payment gateways will be a plus. Skills: - Python, C#, SQL or other relevant languages - Payment gateway integration - UX/UI - Database Management - Project M...

I'm seeking a seasoned logo designer to create an engaging, vintage style logo for a bakery. Here are the project specifics: * The color scheme should majorly include pink. Creativity in blending it with other suitable colors is welcome. * The logo design should be vintage themed, giving it an aged, classic look to express longevity, trust, and warmth. * A cupcake should be an integral part of the logo design, helping potential customers quickly recognize our specialty. Ideal candidate should have: * A strong portfolio of vintage style logo designs. * Excellent skills in color matching and blending. * Creativity and an eye for detail.

I am currently seeking a freelancer experienced in Excel forecasting to provide expertise in both Simple and Winter's Exponential Smoothing. The project entails: - two exercises that involve working with a particular set of data in a file format (either CSV, XLSX, etc.) and applying both variants of Exponential Smoothing to predict future values. - Optimizing the forecasting process to procure the most accurate results. discuss your forecasting method, your forecasts, and the business insights from these in a 750 word report. - Please note that the provided data set won't be updated, so the focus should be on competing the steps of the task assigned. The perfect candidate would have: - Strong experience in Excel and data analysis. - A profound understanding of ...

Project Overview: I have an Angular component TypeScript file () which has grown to approximately 6,000 lines over time. This file has been modified and expanded by multiple freelancers and currently contains a mix of utilized and unused code. The file is part of a larger project that interacts with Google Firestore for database operations. While the code is currently functional, its extensive size and lack of organization present significant challenges for further development and maintenance. Primary Objective: The main goal is to clean up and refactor this TypeScript file to improve readability, maintainability, and scalability. Specific Requirements: Code Cleanup: Identify and remove any unused or redundant code segments. Ensure all deprecated methods or p...

...creation of a dummy server for a hospital with HL7 integration. A pay portal is already in place and will be connected to the server. The server must include the following functionalities: - Patient Registration - Displaying Laboratory Results - Storing and Accessing Medical Records The ideal freelancer would have experience in server development and healthcare-specific technology integration. Please include detailed project proposals in your application. This should illustrate your understanding of the project, your approach to fulfilling the requirements, and outline any relevant past work or experiences that would make you an excellent fit for this project. As for programming languages, while I didn't specify a preference, knowledge in languages ...

The local MySQL server engine suddenly shut down due to a power failure. This caused an error in storage or a memory error that led to corruption when the storage engine is writing data to the table. Attempting to fix it, I manipulated the LOGS files (transaction logs, etc.) and managed to connect to the database, query data, and export some of it, and the data was exported perfectly. That's why I know the data is intact. Unfortunately, I didn't think to export all the data because I thought the error had been fixed. However, the next day, the error returned, and I couldn't fix it. Here is a link that explains that it is a common problem in my situation: We are using, XAMPP, MYSQL and Maria

Hello I just purchased new Rapid SSL certificate but I didn't generated it so I don't mess anything up I will need someone to generate my newcert. and install it on Ubuntu server - So NO CPANNEL And I need this 5-10min job to be done today please

...part of an ongoing project, I am looking for a highly skilled freelancer who can assist me in automating a process on an FTP site. The bulk of the task involves: - Creating a Zap in Zapier that can manage and manipulate .CSV files on the FTP site. - The Zap should be programmed to effectively delete redundant files. - It should also be capable of renaming files to ensure consistent importation. Ideal Skills and Experience: - Proven experience in using and manipulating Zapier. - Familiarity and experience with File Transfer Protocol (FTP). - Confidence in handling .CSV files. - Demonstrable problem-solving skills and attention to detail. In your application, provide a detailed project proposal on how you intend to meet my requirements. Your proposal should demo...

I'm in immediate need of assistance to build a Python function that converts a nested JSON file to a CSV formatted file, in line with my given specifications. The subsequent CSV should match an example I will provide. The function should be compatible to work with any JSON file of the same data structure. Skills and Experience Required: - Proficiency in Python - Experience in handling JSON and CSV files - Ability to understand and follow provided specifications Deliverables: - A Python function that successfully converts nested JSON to specified CSV format - Documentation explaining how to use the function Timeline: - The project needs to be completed ASAP. Prompt delivery is greatly appreciated.

I require a skilled graphic designer to transcribe my rough sketch into a digital design. The design is inspired by the "Taylor Swift Eras" shirt and should emulate a similar style. This project involves creating visuals that portray the life-journey of a speech and debate competitor. The specific eras will be represented through s...trophy. The design may have a maximum of two colors used. The design will be printed on a navy shirt. The organization's colors are attached. Applicants should have experience in Adobe Illustrator and be adept at translating rough drafts into polished designs. Familiarity with the speech and debate competition scene will be a plus. Your task is to deliver a final design in both the vector .ai, .csv, and .png formats that are ready t...

I am in search of an experienced writer who can authoritatively handle writing a piece that covers multiple domains: technology, health & wellness, and fashion & beauty tips. Your writing approach should be informative and well-researched. Key Responsibilities: - Create a comprehensi...technology, health & wellness, and fashion & beauty tips. Your writing approach should be informative and well-researched. Key Responsibilities: - Create a comprehensive article that combines diverse topics - Deliver an informative and engaging tone - Excellent research skills Ideal Candidate: - Broad experience writing articles on the specified topics - Ability to concisely yet informatively express key points - Excellent English writing skills. To apply, please share...

...development and potential future scaling. End Goal To create a functional MVP that effectively demonstrates the capability of the platform to support businesses in developing and analyzing their visions, leveraging the robust foundation of the Full Stack FastAPI template. ⚡ FastAPI for the Python backend API. ? SQLModel for the Python SQL database interactions (ORM). ? Pydantic, used by FastAPI, for the data validation and settings management. ? PostgreSQL as the SQL database. ? React for the frontend. ? Using TypeScript, hooks, Vite, and other parts of a modern frontend stack. ? Chakra UI for the frontend components. ? An automatically generated frontend client. ? Dark mode support. ? Docker Compose for development and production. ? Secure password hashing by default. ? ...

I'm looking for an expert with strong experience in web-based admin systems to develop a reliable stock tracking admin system specifically for NASDAQ st...seamless process where stock reports can be downloaded as and when needed 1) A very simple admin under Laravel 2) A menu: Home / Upload Nasdaq / Download stocks 3) An Upload part in order to put the recovered file here: 4) The Download stocks part will retrieve the Yahoo Daily prices of all Nasdaq stocks. Warning: OLHC or OHLC depending on the sources...! Normalize all data in OLHC A python script can do this and save the data to a DATA directory. D1_AAPL, etc... in CSV A python expert can do this very quickly. Python is installed on the server and scripts can be called via shell_exec.

...with experience in XML parsing and handling database operations. I require a Python utility program to parse Talend jobs and determine source and target column details. Key Requirements: * Parse XML files - The Talend mapping file will be supplied in XML format. We're in need of someone fluent with Python's XML parsing libraries. * Extract information - The utility must be able to extract critical information including source and target table columns, as well as source and target databases. * Dynamic Output format - The extracted information must be formatted in CSV or potentially other formats. It should be flexibly designed as we will use this data to load into a database. * Database expertise - An understanding of database interactions and structure are vita...

I am seeking a professional to develop a Lead-Generation form submission web page, which includes end-to-end API integration, csv download & reporting capabilities. Key Project Details: - The required API is HTTP-based (HTTPS POST) - The form should collect multiple information, including name, email, phone number, addresses, and option for additional custom questions - In addition to API integration, the solution should include download capabilities in csv and comprehensive reporting functions Ideal Candidate: - Proficient in API integration, preferably with HTTPS POST - Experienced in CSV handling and reporting features development - Strong understanding of user experience to design an efficient and user-friendly form

I'm looking for a detail-oriented professional to help enter a mixture of text, numbers, and images into a Microsoft SQL Server database. This should be completed in an organized and efficient manner. Key skills and Experience: - Proficient in Data Entry - Familiar with Microsoft SQL Server - Ability to accurately enter a mix of text, numbers, and images - Good organizational skills and attention to detail - Understanding of database organization and management This project requires someone with data entry experience and a solid understanding of how to utilize Microsoft SQL Server. Efficient and meticulous data organization is crucial to this project's success.

...inventory management, and order uploading capabilities. The application should be able to import orders from a CSV file, xlsx file , track the status of each order, and update it when necessary. In addition, it should provide me with insightful inventory and order history reports, enabling us to monitor our stock levels and analyze our order trends effectively. Ideally, freelancers would have prior experience in web application development, with a particular emphasis on order and inventory management solutions. Some knowledge of CSV file manipulation and report generation would be a definite plus. Major Task which we need to accomplish with this system. 1- Upload daily order files - EXCEL/CSV. 2. Update daily orders , quanity, status (avaiable/...

...process data from a CSV file, apply exact match criteria, then enter these matched results into another CSV file. It's vital for this task that duplicate entries from the CSV files are kept intact - they must not be removed or merged. Prior experience in data matching and a strong understanding of CSV files is highly desirable. Please ensure you can: - Handle large CSV files - Apply exact match criteria - Combine values of a column to replicate a formula - 16 columns of data combining to output a pre determined formula - match the formula across entries on another spreadsheet - 800 rows Let's maximize data accuracy and efficiency together. output formula should be as so - a:[‘number of options’]:{option values s...

【 overview 】 This time, we would like to ask you to develop a tool that automatically searches for landline phone numbers on Google and checks business hours. [Request details] ・Development details: Please develop a business hours search automation tool system on Google. - Desired function: System image ①Import an Excel file or CSV file containing only phone numbers to the system ② The system automatically searches Google and searches for the information you want, such as business hours search * Desired information → "Business hours", "Closed days", "Reviews" *There are some patterns that Google doesn't have, so I'd like you to add a flag for those cases as well. ③ After the search is complete, the information will be liste...

I'm in need of a skilful database expert to restore a MySQL database. The database size is less than 1GB, hence would not pose a heavy workload. Our backup file is conveniently located on the server at hand. Key Skills Required: - MySQL Database Management. - Proficiency in SQL commands. - Experience in restoring databases, preferably MySQL. Your expertise should assure a minor downtime and safe recovery without data loss. Looking forward to connect with the right professional.

I'm currently running a Python script on a server on Digital Ocean and I need a highly experienced individual with solid knowledge of to set up my panel on the platform. Specifically: - The main task involves configuring server access, ensuring the transition is smooth and does not interfere with my running Python script. Ideal Skills & Experience: - Proficient in server access configuration - Strong experience with - Solid Python knowledge - Significant experience working with Digital Ocean. By applying for this project, you are affirming your competence in the stated areas, and your ability to setup the panel carefully while retaining the functionality of my Python script.

I am looking for an expert with extensive experience in Linux (Ubuntu) server set up, to undertake a project in installing the Metabase software on a newly set up server. This task will require: - An in-depth understanding of Linux (Ubuntu) server configuration - Knowledge in standard Metabase software installation on Linux servers Please note, I am only interested in the initial server set up and Metabase installation and do not require ongoing maintenance and updates for the server or the Metabase software. The ability to deliver a functional and optimally configured system up to date with the latest security patches is the paramount expectation from this job engagement. I encourage you to bid if your skill set matches these requirements.

Seeking an experienced IT professional adept at executing tasks within a Windows framework. The primary project goals are: 1. Assisting in crafting a Virtual Machine (VM) on a Windows platform,...project goals are: 1. Assisting in crafting a Virtual Machine (VM) on a Windows platform, and configuring it so that I can access it virtually. 2. Assisting with the creation of API processes in Python, particularly focusing on data extraction and insertion. Required skills include a robust understanding of Windows platforms, VM creation and management, Python programming, API integration and SQL database manipulation. Your comprehensive knowledge and practical experience in these fields will be key in successfully completing this project. More information on the API integration will be...

I'm cons...database engineer proficient in Google Big Query. The project involves: 1. ETL Development: Your main task is to develop an ETL process. You should have experience managing CSV files and integrating APIs. 2. Data Management: The data to handle includes property addresses, sale price history, property characteristics, and people details related to properties. The expert should know how to organize and manage this huge amount of data effectively. 3. Real-Time Updates: Due to the volatile nature of the real estate market, the ability to integrate real-time updates is an asset. An expert in Google Big Query, effective in handling CSV files, and capable of seamless API integration would make the best fit. A good understanding of real estate data could be an advan...

I'm seeking a skilled data miner to gather an email list of over 5,000 chiropractors located in the United States. The source of this information can be any credible public directories, LinkedIn profiles, or industry associations. The following are my project requirements: - Gather email addresses of over 5,000 chiropractors located in the United States, - The list must be provided in a CSV file. I am in need of a ready data list comprising over 5,000 chiropractors in the United States, meticulously compiled with the following details for each entry: Email Address Contact Name Clinic Name Phone Number To be considered for this role, please provide proof of your past work and experience related to this type of project. Detailed project proposals will be highly apprec...

I am seeking an advanced-level SQL Query and Reports developer with a strong background in Microsoft SQL. Your expertise will be leveraged to create detailed operational reports. Key Responsibilities: - Design, develop, and maintain SQL queries for data analysis and extraction. - Create and maintain complex reports in Microsoft SQL. - Interpret data and analyze results using statistical techniques. Ideal Skills and Experience: - Proven experience as an advanced-level SQL Developer. - Ability to write complex SQL queries is a requirement. - High proficiency in Microsoft SQL. - Experience in creating operational reports. - Strong statistical analysis skills.

I am seeking an advanced-level SQL Query and Reports developer with a strong background in Microsoft SQL. Your expertise will be leveraged to create detailed operational reports. Key Responsibilities: - Design, develop, and maintain SQL queries for data analysis and extraction. - Create and maintain complex reports in Microsoft SQL. - Interpret data and analyze results using statistical techniques. Ideal Skills and Experience: - Proven experience as an advanced-level SQL Developer. - Ability to write complex SQL queries is a requirement. - High proficiency in Microsoft SQL. - Experience in creating operational reports. - Strong statistical analysis skills.

I'm in search of a Azure Data Factory expert who is well-versed in Delta tables, Parquet, and Dedicated SQL pool. As per the requirement, I have all the data and specifications ready. The successful freelancer will need to be familiar with advanced transformations as the ETL complexity level is high. It's a plus if you have prior and proven experience in handling such projects. Key Skills Required: - Expertise in Azure Data Factory - Deep knowledge of Delta tables, Parquet and Dedicated SQL pool - Familiarity with advanced ETL procedures

...use-cases. We are looking for an experienced consultant to refactor our algorithm to fix some longstanding issues. *What you will be given:* A document containing several queries that fail at finding the accurate results, along with the suspected reasons for failure Access to a github repo containing a small sample project with our search algorithm. It takes an file, reads it line by line, and then outputs csv files for each line in the input containing the search results for that line. It can be used to understand / work on the algorithm, as well as check the results of the modifications. If needed, several other documents containing additional failed queries, which might help understand the issues we face Access to the MongoDB database containing the products *Wha...

...advancements. You will work with companies in the US looking to develop cutting-edge commercial and research AI solutions. Job Responsibilities: Write effective Python code to tackle complex issues, but also use your business sense and analytical abilities to glean valuable insights from public databases Communicate clearly with researchers and help the organization in realizing its objectives Clearly express the reasoning and logic when writing code in Jupyter notebooks, or other suitable mediums Fix bugs in the code and create thorough documentation Utilize extensive data analysis skills to develop and respond to important business queries using available datasets (such as those from Kaggle, the UN, the US government, etc.) Effectively communicate with the researchers to comp...

...increments or less) pertaining to age retirement, withdrawal, and death from pension datasets. The data should be provided in raw form or as percentages, focusing solely on these three variables. The dataset must be cohesive and not sourced from disparate studies Please check file before post Requirements: Data on retirement, withdrawal, and death categorized by age groups. Data provided in raw form or as percentages. Limited exclusively to the requested variables. Additional Information: Desired format: Excel, CSV, or equivalent. Timeframe: 2 weeks Budget: 30 usd Previous experience or samples of similar work are preferred. Data must be sourced from credible and reputable sources presented by the freelancer (e.g., Eurostat). Only data from European, American, Australia...

I need to import data from multiple files that have roughly the same products in them, but it needs to show me in alphabetical order the product name in the first column and the best prices from each client in the next columns (from largest to smallest). Probably i need macros and i can`t figure them out

We will create an assistant based on OpenAI (like ChatGPT) with a graphical interface similar to ChatGPT. The goal is to develop an assistant that can query information from databases and provide summaries and marketing recommendations. Here is the list of databases: - SQL (Oracle, PostgreSQL, SAP HANA) - Using Airbyte (with LlamaIndex or LogChain): - SAP CRM - Pipedrive (using Airbyte) - HubSpot - Salesforce - JIRA ( ) Additionally, the assistant should be able to process documents (PDF, DOC, TXT) and summarize a document

I'm currently seeking a keen React developer with intermediate experience in Virtual DOM manipulation. This project will primarily focus on: - Building a user registration system - Implementing robust Virtual DOM manipulation using React - SQL Expertise required The potential candidate is expected to have a decent understanding and hands-on experience in working with component-based architecture and also state management. Solid experience with MySql backend will be considered a plus for this task. It is expected that you deliver a clean coded, well-structured and performance optimized registration system while adhering to best development practices. Looking forward to choosing a capable React developer for this challenging opportunity.

Please find database which need to recover, I want it into SQL file I am in immediate need of a skilled MySQL specialist to recover a database from a database folder. This is an urgent task and requires successful completion as soon as possible. The operating system used is Linux. - The chosen freelancer should have proven experience with database recovery tasks and a sound knowledge of Linux operating systems. - Due to missing information, flexibility with handling different versions of MySQL is also necessary. The project will be deemed successful once the database is fully recovered and available for use. Preference will be given to freelancers that offer swift project execution and those who have extensive experience in MySQL recovery tasks.

For my personal use, I need an expert WordPress developer who can work on my project immediately. You'll need to tweak my existing Ultimate Member plugin to extract longitude and latitude location fields from the UK postcode data provided by users. This information needs to be in .csv format. Skills required for this project include: - Proficient knowledge of WordPress and its plugins - Experience working with .csv files - Familiarity with geolocation functionalities - Understanding of UK postal code system Please note that the plugin should automatically generate Location_lat, Location_lng, and Location_url from the user-inputted postcodes. This project should be done as soon as possible.

To change our allocation access / SQL system as per the discussed changes.

As a web owner, I'm looking for an accomplished WordPress developer to spearhead a comprehensive transformation of my website. Key Aspects: - Custom Theme Design: I will provide specific guidelines for the ae...scheme, layout, and fonts. Expertise in tailoring WordPress themes as per client specifications is paramount. - Plugin Customization: Existing plugins demand customization for enhanced user-experience. Your experience in plugin tailoring will be instrumental. - Database Integration: The project encompasses database creation and ensuring seamless synchronization with other links. Skilled handling of SQL and database management is preferred. In essence, the incumbent freelancer should be a versatile WordPress wizard with a knack for aesthetic design and technical databa...