Sql express 2005 import data csvpráce

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solut...

I'm in need of a proficient data scientist who can assist me in obtaining targeted gene expression data from the web-based database Culling specific gene expression characteristics, such as expression levels in different tissues and co-expression networks are the main focus. I require the downloaded data to be in CSV format. Ideal Skills: - Data extraction capabilities - Familiarity with gene expression databases - Proficient in handling large datasets - Ability to deliver data in CSV format

Ho la necessita di configurare un importazione di prodotti con attributi collegati nella stessa pagina, la piattaforma da utilizzare e woocommerce con wp all import ( il caricamento dei prodotti e relativi attributi è stato gia fatto)

Hello, I need mapping a CSV that contains many information and put all words in each column

...talented artist who has expertise in creating realistic watercolour artworks. This task requires developing a peace-evoking, calm landscape scene. Key Requirements: • Strong experience and understanding of realistic watercolour painting • Proven track record in landscape focused artwork I’m keen to see previous work before selecting the freelancer to ensure your style aligns with my vision. Express your realistic interpretation through calming tones and serene imagery. Your expertise in colour blending, brush practicality and detail orientation are central. Propose how you'd convey tranquillity through a landscape scene. I am looking forward to seeing your unique and auspicious proposals. I’m keen to fill the space below (see picture attached ) wit...

...into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number...

...customizable point-of-sale software tailored for my retail store. The software should offer various features including: - Import/export functionality: The software should support the import and export of products and customer data to enhance efficiency. - Scanning and printing receipts: I need the software to allow for scanning products and printing receipts with thermal printers. - User login for separate staff: It should also have a feature to allow separate logins for different users or staff members. - Inventory management: The software should include inventory management features for tracking stock levels and products. - Customer management: I need a system that can handle customer data and history, to help with marketing and future sales. - Tax calcula...

I need to change the way my web site updates schedules for tv channels. Right now my site scrapes external sites and pickle dumps and returns data to the site. I want a json or csv to upload to updates all channels manually or we can use my admin to update with file.

...need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting ...

Data Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, bl...

...Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifi...

...requirements: - Exceptional ability in logo design, illustration, and typography design - Proficiency in creating a message in style design. - Deep understanding and appreciation of local culture and heritage. - Appreciation of community and the small business role in creating strong communities - Will need files in reproducible format at least 300 DPI The ultimate goal is to produce designs that express our sense of community and our dedication to supporting local small businesses. The right candidate will have a creative mind and a keen eye for details. Work will be used on merchandise including Tote bags, T-shirts, Hats, etc using printful as the supplier. Previous work on similar projects would certainly be a big plus. Some of the requirements, on some products, are attach...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

...issues - Showcasing excellent customer interactions - Demonstrating the resulting satisfaction of customers - I will also need some additional info like phone number put in this video Ideal skills for this project would be: - Proven experience in video production - Knowledge of appliance repair industry (preferred) - Making use of real-life scenarios to explain concepts - Ability to capture and express customer satisfaction effectively in the narrative. Your job is to create a compelling story within a 30-second timeframe that highlights our service's dedication to customer satisfaction. Bring your best storytelling and video editing skills to life in this project....

Villa Silvana Building IFC Model with BlenderBIm Export Ifc and FBX. Ifc File import in UNREAL Engine and setup location map with Cesium plagin.

Riabilia Building IFC Model with BlenderBIm Export Ifc and FBX. Ifc File import in UNREAL Engine and setup location map with Cesium plagin.

I'm looking for a Google Sheets expert to help me automate a process involving day by day data input process I'm seeking a freelancer who can streamline and automate the repetitive task of data import and export in Google Sheets. The ideal candidate should possess the following skills and experience: - Proficient in Google Sheets: You should have in-depth knowledge of Google Sheets and be able to manipulate data effectively. - Automation Skills: Experience in automating processes in Google Sheets is essential. Feel free to ask any questions, and please provide relevant examples of your past work. Thank you.

I'm seeking a data operator skilled in the analysis and visualization of numerical data. The primary task is to handle the numerical data in my CSV file. Key responsibilities include: - Data Analysis: You'll be responsible for performing thorough data analysis on the numerical figures in the file. - Data Visualization: In addition to the analysis, I need engaging visualizations of the data to be created. This will help to communicate the insights effectively. Specific tasks I need help with include: - Descriptive Statistics: You should be able to calculate and present descriptive statistics for the data. - Trend Analysis: You'll also need to identify and represent any trends present in the numerical values. ...

I'm looking to expand the export capabilities of my OsTicket installation. Specifically, I need to add a feature that allows me to export ticket information to a CSV file. Key requirements include: - Implementation of an additional export feature in OsTicket - This feature should specifically allow for exporting ticket information - The exported file format should be CSV The ideal freelancer for this project would have: - Strong experience with OsTicket and its customization - Proficiency in PHP for making changes to the system - Familiarity with CSV file handling Please provide examples of similar work in your proposal.

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward to receiving your proposals!

I'm looking for an experienced Azure Analytics specialist who could coach me in the areas of Data Analysis and Data Visualization. The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming f...

...A user-friendly web interface where users can enter the URL of the job listings page and initiate the scraping process. # Downloadable in .csv Format: The scraped job data should be downloadable in .csv format for easy analysis and storage. # Filtering Options: Ability to filter job listings based on old vs. new jobs for specific job verticals (e.g., technology, finance, healthcare) and support for Middle East/GCC countries. # Scalability: The scraper should be able to handle a large volume of job listings from multiple sources without performance issues. # Scheduled Scraping: Optional feature to schedule regular job scraping tasks to keep the data up-to-date. Ideal candidates for this project should have: - Experience in web scraping - Proficient in va...

...business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a...

I'm in need of a skilled developer who is experienc...reports about warranty returns. - User access control: Improving the control measures for different user permissions within the software. - Ticket creation, Data Import and Export: Aptitude in handling these features are considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit ...

K zobrazení podrobností se zaregistrujte nebo přihlaste.

Setting up the quick book, import sales data, invoices and cleaning up to have ready to use

...compiling it into a CSV. The CSV will need to include specific details about each product, including but not limited to the product name, description, price, manufacturer, Grainger number and SKU number. Key Responsibilities: - Scraping the Grainger website for all product details. - Compiling the scraped data into a CSV file. - Ensuring that the data is organized and categorized correctly. Ideal Skills for this Project: - Proficiency in web scraping tools and techniques. - Experience in organizing and compiling large datasets. - Understanding of CSV file format and its use. - Familiarity with Grainger's website and the ability to navigate it effectively. It's important to note that I'm looking for a freelancer who can deliver...

I have an Oracle database configured with WE8ISO8859P1 character set (call it DB1). The database needs to be updated to character set WE8MSWIN1252. I need to preserve the DB1 database, so I've created a new database with WE8MSWIN1252 (call it DB2). I would like someone to do this for me: 1. Export entire DB1 including data 2. Import the DB1 export into DB2 Communication and control will be done with Zoom

I'm seeking a creative illustrator to design a mental health-themed t-shirt for me. Your design should captivate the viewers by fusing: • Relevant symbols (quotes, brain, heart, butterfly) to effectively signify the cause. • A mood that is hopeful yet educative. • Aesthetic sensibility, to largely resonate with the mental health community. Skills/Exp...illustration • Adept in creating meaningful, symbolic designs • Strong conceptual skills and understanding of the mental health terrain • Capacity to complete this project immediately Those who can infuse creativity with purpose, stretching beyond typical designs to create a powerful advocacy tool, are highly encouraged to bid. Time is of the essence, I need the design ASAP. Let your portfolio ...

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 princi...

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 ...

...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 Matching System: Implementing algorithms to match users with funding opportunities based on quiz results and profile data. Subscription and Payment Processing: Integrating Stripe for handling subscriptions and payments, including setting up di...

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...

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, 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 google map.

...PostgreSQL, or another relational database. - 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...

...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 larg...

Our existing CGI...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...

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...

...users based on their reading habits and preferences. Secondary Goals: Implement data visualization features to display trends and sentiment analysis of news articles. Minimum Requirements: Content Aggregator: Develop a system that pulls news data from various APIs or web scraping. User Profile Management: Create functionality for users to register, login, and specify their interests and preferences. Recommendation Engine: Implement a machine learning model to analyze user behavior and curate news content accordingly. Optional Enhancements: Sentiment Analysis: Integrate a sentiment analysis model to evaluate the tone of news articles, helping users understand the general sentiment of the news they are reading. Data Visualization: Use libraries like Matplotlib and Sea...

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 seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data 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 su...

...performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay 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 d...

I'm in need of an experienced graphic designer to create a captivating, illustrative logo that stands out and reflects the essence of my brand. This design is crucial for my upcoming product launch, and I'm working on a tight deadline. **Ideal Skills and Experience:** - Strong portfolio in illustrative logo design - Ability to translate concepts into visual designs - Proficiency in Adobe Illustrator and Photoshop - Great communication skills and ability to work under tight deadlines **Requirements:** - Design a unique, illustrative logo that embodies my brand's values and essence. - The final logo must be scalable, as its primary use has not been defined yet; it could range from web applications to print materials or product packaging. - Deliverables include the original v...

...undertake crucial tasks within a large-scale project over a 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 v...

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