Import csv file into mysql query jobs
...our website, which is built using Umbraco, C# coding, and MySQL database, to a new hosting environment. **Project Details:** - **Current Setup:** - Website developed in Umbraco (Microsoft open-source CMS). - Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with migrating websi...
I need a python programme to download historical prices on daily basis of a list of stocks from the BSE India (Bombay Stock Exchange) website. Data should be stored in csv or excel file. Retrieve data accurately and efficiently.
I need a fluent, efficient typist to convert an English PDF into an doc -formatted Word document. Requirements: - The primary task is to convert the text from the PDF into a Word document. The original PDF is in English. - The Word document must be formatted in doc style. Familiarity with this style is a must. Pdf file must be typing and i need word .doc file . The PDF does not contain any tables but does include images. These images need to be included appropriately in the Word document. Ideal Skills: - Proficient typist - Strong understanding of APA formatting - Experience with incorporating images in Word documents Please provide a brief description of your relevant experience.
I'm looking for a skilled developer to create a Flask-based website connected with mysql. This website will be primarily for my personal development. Key Features: - Email Verification otp on login A simple website for our team to use with login option and it should have following features A form to manually update my database A search page to search in my database (For example :- for a student databases a page to add all the details of a new student manully and a page to search for students based on same criteria which shows the result in a table form) My budget is around 2000- 2500 rs Ideal Skills: - Strong experience with Flask: You should have a proven track record of developing websites using Flask. - User Authentication Expertise: Understanding and implementing se...
...to extract data from relevant grant databases and websites (if possible, considering anti-scraping measures). Sites to be scraped: 2. Design a database schema to store the extracted data. 3. Write scripts to clean, transform, and load the data into the database. 4. Design a WordPress directory listing interface with search filters to display the grant information. 5. Develop a user interface to query and display the grant information based on customer criteria 6. Create a Python plugin for WordPress to automate the scraping work, using tools like WP-Python or PyWP. This plugin would allow for scheduled scraping, data updates, and integration with WordPress's database and user interface. Please note that this is
...maintaining dependencies and task sequences. Set up triggers to initiate automations based on specific actions (e.g., task creation, completion, or status change). Email Integration: Integrate our email system with ClickUp to enable direct email sending from within ClickUp. Ensure that email addresses prepopulate as contacts' details are typed into the email address field. Create and configure email templates for common communications. Contact Management: Import and manage a large contact list (approx. [specify number]) within ClickUp. Ensure synchronization of the contact list with external sources if needed. Checklists and Task Management: Organize and automate around 20-25 checklists with varying numbers of tasks. Set up dependencies and automate the flow of tasks ...
...of a proficient designer with experience in SVG file creation for both laser cutting and etching purposes. The project entails transforming my hand-drawn sketch design into an SVG file format, showcasing simple yet specific shapes. The following are the project specifications: - The SVG file will be used for a medium-sized (1-3 ft) project, meaning attention to detail in scale factor is essential. - The material targeted for laser cutting and etching is acrylic. Hence, prior experience working with this material will highly be considered. Ease in following instructions, excellent communication skills, and the ability to creatively interpret sketches into clean digital designs will be key in picking the ideal candidate. I’ve attached a file...
I have a lot of data in a spreadheet. Have a look at attached spreadsheet. I need the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in ...the sheet named "auto made" to be automaticly made. (it is now manually filled with data) What triggers data to be in "auto made" sheet is the value 1 in Ordre!B column. If no value in Ordre!B column the "auto made" sheet will only have headers. Description on where the data is from is described in row 10 in "auto made" sheet. ...
...suppliers, products, and purchase orders from various data formats (CSV, XML, JSON) and seamlessly import them into Microsoft Dynamics GP 2016. This will greatly enhance the efficiency of our purchasing workflow and eliminate the need for manual data entry. Ideal Skills and Experience: - **Microsoft Dynamics GP 2016 Proficiency**: A thorough understanding of Microsoft Dynamics GP 2016 is essential for this project. Previous experience working with this ERP system is a must. - **Database Manipulation**: Given the preference for direct database manipulation, the selected freelancer should be proficient in creating secure, efficient, and reliable integrations. - **Data Formats**: The ability to work with multiple data formats, such as CSV, XML, and JSON, is cru...
I'm in need of a freelancer who can help me parse my VCF file and convert it to a different format. The main goal of this task is to extract the genotype information from the file. input will be VCF file (from ONT whole genome run) and csv file with columns containing rsID, chromosome number, position. output will be same as input csv file, with extra column showing genotype from VCF at the given position can run on Mac shell so either perl or python would be fine. Ideal Skills & Experience: - Proficient in parsing VCF files and understanding genotype data - Experience in converting files to various formats like CSV, TXT, and XLS - Attention to detail to ensure accurate extraction of the data - Knowledge of any data validati...
...can create a Windows GUI application. This app should be capable of opening and editing a pre-formatted CSV file. Key Features: - The app should have interfaces for inputting free-form English text in certain fields and selecting options from drop-down menus in others. - It must offer normal file saving and opening functionalities. - The design should incorporate a professional and corporate-looking splash screen graphic and an about page. User Interaction: I aim for a straightforward user experience. The app should be intuitive and easy to navigate without the need for an extensive guided walkthrough. Ideal Skills: - Proficiency in Windows GUI app development - Experience working with CSV files and handling user inputs - Strong understanding of UI/UX desi...
I am in need of a highly skilled developer who can create a chatbot integrated with Zoho Desk for my employees. This ch...answering common FAQs. Given the type and nature of questions expected, an ideal candidate should: - Have experience in creating chatbots - Show familiarity with Zoho Desk API - Demonstrate ability to create bots that can answer technical support-related questions Understanding of the common issues faced in a technical support environment is a big plus, as the chatbot is intended to be primarily query-based. A well-defined and intelligent bot will not only improve our workflow but also help us resolve employee queries faster. That being said, I'm looking for someone who can deliver a chatbot which can accurately answer FAQs and improve overall operatio...
...skilled Shopify developer with solid experience in data import from Excel. Specifically, you'll be dealing with: - Product data import into my Shopify site from a URL download of a CSV - Importing simple data, without dealing with variants or complex attributes. - syncing of the products in the CSV with Shopify products would happen every 24 hours automatically - If an existing product on Shopify is not found on the CSV download, its status on Shopify needs to be changed to "draft" or "inactive". The ideal candidate should have: - Strong Shopify development skills - Familiarity with Excel or similar data management tools - Experience with product data migration or import Success in this project would mean a se...
I'm in need of a professional who can help me edit a PDF document. I would like to make some text edits, add some new text, and also enhance the document with the additio...PDF document. I would like to make some text edits, add some new text, and also enhance the document with the addition of a few images. Ideal Skills: - Proficiency in PDF editing - Skilled in text addition and reformatting - Experienced in image editing and addition I already have the original document that was used to create the PDF, so you can make the required changes directly from the source file. I would prefer someone with a keen eye for detail and design, who can make the document visually appealing as well as functionally accurate. Please reach out if you're confident in your PDF editing and ...
...of the school (e.g., only certain locations or only scheduling). Teacher Management Teacher Data Upload: Module to add and update teacher information, including: First and last name Email Phone number Subjects taught (both theoretical and practical) Hourly and daily availability Locations where the teacher is available to teach Intuitive interface for quick data entry with the ability to import data from CSV or Excel files. Tabular view of teachers with search and filter functionalities. Hourly and Daily Availability: Interactive calendar to set daily and hourly availability of teachers. Drag-and-drop functionality for easy time adjustments. Ability to set recurring availability (e.g., every Monday from 9:00 to 11:00). Option to add notes or comments for each availabilit...
...a WordPress real estate theme for my website. Additionally, I need the developer to transfer all listing information from an existing website to the new one. Project Details: Theme Installation: Install and configure a WordPress real estate theme that I will provide. Hosting: Recommend and choose a suitable hosting package. Data Transfer: Extract all listings from a specified website and import them into the new WordPress site. Focus Area: The new website will only feature the sales section. Requirements: Experience with WordPress theme installation and customization. Familiarity with real estate themes. Ability to transfer data accurately and efficiently. Strong attention to detail to ensure all listings are correctly migrated. Good communication skills to update me on...
Gradeco has an intranet called GRADENET, and its created in php/mysql platform. Please look at uploaded file for the requirements. Feel free to ask questions.
...performance - Troubleshoot and resolve any technical issues that arise - Collaborate with our team to understand project goals and deliver results that exceed expectations - Stay updated with the latest industry trends and technologies to implement best practices Requirements: - Proven experience in WordPress and WooCommerce development - Strong understanding of PHP, HTML, CSS, JavaScript, and MySQL - Experience with theme and plugin customization - Knowledge of SEO best practices - Ability to work effectively in a team environment - Excellent communication skills and attention to detail - Ability to manage multiple projects and meet deadlines Preferred Qualifications: - Experience with RESTful APIs and third-party integrations - Familiarity with version control systems like Gi...
...by visitors. ** Database Management: - Integrate Google Sheets with the MySQL database so that the rates can be updated weekly via Google Sheets instead of directly through the cPanel, simplifying maintenance and updates. - Ensure seamless data synchronization between Google Sheets and the MySQL database to keep the quote system accurate and up-to-date. ** Deliverables: - A fully redesigned WordPress website with a modern look and maintained content. - A fully functional, tested, and bug-free instant quote form. - SEO setup and optimizations, including keyword implementation, meta tags, and link building. - SSL certificate setup and configuration on GoDaddy. - A system for syncing Google Sheets to the MySQL database to streamline updates. ***** Project T...
Wanting a sketchup file with the terrain and image matches and scaled
I am seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in automated data notifications. Familiarity with handling Excel ...
...Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, Purchase Date, Ship Date, Payment Method, Fulfillment Methods, ASIN, Quantities, Item Subtotals, Tax Total, Refu...
... Reward points management (adjust points, manage redemption) specific to each hospital. Product management for point redemption. Transaction management for cash withdrawals. Reporting and analytics dashboard. Technical Specifications: Backend: PHP Laravel framework. Frontend: Hybrid technology (e.g., React Native, Flutter). Database: MySQL or PostgreSQL. Secure payment gateway integration for cash withdrawals. Compliance with data protection regulations. Project Timeline: Detailed project plan and timeline to be provided by the company. Expected project completion within 3months. Payment Terms: No advance payments will be made. Payment will be released only upon successful del...
Seeking someone to fix, or create a file: for new hires to complete onboarding forms. Currently, when new hires join our agency, they receive and fill out mountains of paperwork. My agency will not move away from having hand signed forms and documents. Before someone is hired, we mail a packet containing forms to complete and turn in on their first day along with other agency information. When they arrive on their first day, (aside from the documents they’ve received in the mail), we provide more forms to complete. So they’re stressed by starting a new job, and now they have to shuffle through all these forms and papers, it’s a lot to deal with. I’ve already started the process of changing this. My idea is this: new hires will still receive the pap...
I need an experienced 3D designer to modify an STL file quickly. The specific modifications are unspecified, but I need them done promptly. The final deliverable should be an STL file, though I'm open to other file formats. It is essential that the designer has the ability to make complex modifications and is experienced in the software necessary to perform the task. Please bid only if you're available immediately and can work on the project promptly.
I need someone who is proficient in web development to help with passing query parameter string into the SEO title page in a dynamic manner. For example, this is the URL of the framer pager I would like help with: However, when I pass the URL into to check if the query parameter is being passed in the SEO title, it fails and doesn't update. I would like a Framer expert who is also proficient in coding to help me with this project.
I'm in need of a freelancer with the ability to translate English to Chinese (and vice versa) and experience in selling products on AliExpress in China. AliExpress uses two log...AliExpress communication with the customers so that the customer only received our branded confirmation e-mail? 5. What are the fees for the Intake of Merchandise. Storage, Order Picking, Packing Materials, etc.? 6. What are the international shipping rates for underwear (~80 grams total weight)? 7. How to integrate the AliExpress back-end with the Shopify back-end? 8. How are custom forms for the import of packages created? In the event the initial assessment turns out positive, we would like to hire the candidate for the actual application process with AliExpress and for other ad-hoc tasks on a lon...
I'm in the business of importing and distributing promotional products. The goods are mainly m...I'm keen to ensure that all products being dealt by my business are REACH compliant. Thus, I'm looking for an expert in REACH compliance who has experience with items such as these. Ideal skills would cover: - Expert knowledge in REACH compliance - Experience in the advertising and promotion products industry - Proficient in compliance for plastic and aluminium items - Detailed understanding of import and distribution sectors The role will involve scrutinizing the products I deal with to ascertain REACH compliance and advise or implement necessary actions. Your expertise will greatly contribute to the sustainability of my business, adhering to environmental guidelines a...
I'm in need of an expert server administrator with exte...Your role would be to assess the current setup, make necessary adjustments and ensure that the server is running optimally. - Troubleshooting: The primary issue I'm experiencing is a DB query failed: SQLSTATE[HY000]: General error: 1 Can't create/write to file '/var/tmp/#' (Errcode: 2), query was: DESCRIBE `sessions`. Your expertise in diagnosing and resolving such issues will be crucial. Skills and Experience Required: - Proven experience in Plesk server administration, particularly in configuring and optimizing servers. - Strong troubleshooting abilities, particularly in resolving database query failures. - Ideally, experience in identifying and resolving security vulnerabiliti...
I'm in search of a skilled video editor to work on my projects which are typically 5-10 minutes in length. Requirements: - Experience in Cinematic style video editing is desired. - Proficiency in various editing techniques such as color grading, slow motion, and animated text. - Ability to work on videos of 5-10 minutes. This role would suit someone with an eye for detail, creative flair, and a strong understanding of narrative structure. Please provide examples of your previous work that align with these requirements.
...developer who is adept at developing systems using PowerApps and PowerPages. The task at hand involves creating an appraisal system for an organization, which includes the following elements: - Performance tracking - Goal setting and tracking - Feedback and comments section The system will not integrate with any existing systems, instead, it will be a standalone system with the capability of data import/export. A key prerequisite for this task is understanding and implementing varying access levels based on the role hierarchy of the organization. Each role within the organization will have different user permissions. Restrictions will be employed, allowing certain roles comprehensive access, while limiting access for others. The ideal candidate should be experienced in PowerA...
I have an illustration file that needs some detailed work in Photoshop. I am specifically looking for someone who can enhance details by hand, and not just run the file through a software. The main focus will be on small details, specifically the fine lines on characters. I've noted that the print size is showing poor resolution in the eyes of the animals, and this is particularly what I want fixed. The lion and zebra are eye level for a child ( this is a kids playroom) and they need to be better quality....without changing the color and feel of the mural. We have tried using other people and they run it through a software that is changing the other parts of the mural. Key Skills: - Proficient in Photoshop - Attention to detail - Experience in enhancing fine l...
I am looking for a professional PHP developer who can build a custom website for me, and integrate it with one APIs. - the API is already in use in other websites so you will be able to see what it should d...already developed a basic frontend page with the form (input boxes and selectables) to collect the data that will be submitted to the API (json). Next step is store this data locally and submit it to the API. Final design we will take care later. Ideal skills and experience for this project include: - Proficiency in PHP, with a strong understanding of MySQL. - Experience working with various APIs, as you may need to integrate APIs into the site. - Strong communication and problem-solving skills, as you may need to troubleshoot any issues that arise during the int...
This is a quote for starting the work on this page: We will transform the pages to static HTML with creating a simple CMS to manage the articles.
This is a quote for starting the work on this page: We will transform the pages to static HTML with creating a simple CMS to manage the articles.
I want someone who can convert my pdf file to word file
I'm looking for a proficient image editor who can make specific changes to a number of files. I am attaching two files. Currently, they say: MTNV Administration MTNV Diagnostics They are in two different formats. So, 4 files. I need them to be changed to say: QED Administration QED Diagnostics QED Operation QED Proxy Administration QED Proxy Operation So, I need a total of 10 files. I will pay a max of $25 for this. I will provide the source files to the successful bidder.
I am looking for a skilled C++ developer to create a REST API for my...data retrieval and manipulation. - User authentication and authorization are required for this project, using existing APIs Database: - Although I don't have an existing database, I have specifications for it. - The API should connect to the specified MySQL database based on the provided specifications. Timeline: - The expected timeline for the project is more than 3 weeks. Skills and Experience: - Proficiency in C++ programming language and POCO framework - Strong knowledge and experience in developing REST APIs. - Familiarity with MySQL database connectivity and management. - Ability to understand and implement specifications for the database. Please provide examples of your previous work in dev...
...able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page this way. There are some other pages that I want to structure properly, so your help is appreciat...
...able to help me with a Magento 1 task. I got a template: ‘’Porto theme’’ and I can’t find out how to build / structure pages properly. The manual is not sufficient for me. How can I integrate the page structure of a demo (home)page for example? The automatic function is not working for some reason. I have contacted the developers: ‘’P-themes’’ and they suggested to go into the folder: ‘’app/code/local/Smartwave/Porto/etc/import’’ on the server, but from there I don’t know how to integrate these (short)codes on the page properly. Hope you can help me integrate it and explain how to build a page this way. There are some other pages that I want to structure properly, so your help is appreciat...
...Classification - Object Detection In terms of output, I require the processed videos to generate a Metadata file, which ideally is formatted into an Excel or CSV file. This data should include details such as date, time, classification, and direction. While I do have an Azure account for hosting and I am comfortable with it, I am also open to suggestions on which programming language would be the best fit for this project. The ideal freelancer for this task should possess the following skills and experience: - Proficiency in Python, C++, or Java - Familiarity with Microsoft Azure or similar - Experience in image classification and object detection - Ability to create Metadata files in Excel or CSV format. Remember that while these are the core...
Hey, I’m using a theme that have it’s own sign up form but there is no field for entering username. I want to add the enter username field and make it required. We have to do this from the file manager by editing codes.
I'm looking for a custom add-on for Perfex CRM. The add-on shall generate a graph that can be filtered by personnel and date. Key requirements include: - Display data: The graph should show the number of op...number of opportunities. - Chart style: The preferred style is a line chart. - Filtering: The graph should be filtered based on selected personnel and date ranges. Ideal skills for this project include familiarity with Perfex CRM, strong PHP and MySQL experience, as well as an understanding of charting libraries for graph representation. A professional who can work efficiently and deliver a user-friendly, visually appealing solution will be highly appreciated. There is a ready-made page similar to our needs in Perfex CRM. I just want it to be converted into a plug...
I have a MOV video file that needs to be edited. I would like it to be adjusted to a specific resolution. Key Requirements: - Video editing: Adjusting the resolution of the MOV video file. Accepted Video Specifications: About two small screens Media player: Mirage Screen resolution :2288*1248 Refresh rate:60Hz Video type:.mov About Big screen Media player: Mirage Screen resolution :3536*5616 Refresh rate:60Hz Video type:.mov Ideal Freelancer: - Experience with video editing software - Attention to detail for resolution adjustment - Familiarity with MOV file format.
...with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying the results of the database analysis. The ultimate goal of this project is to use data effectively to inform business decisions regarding our customer base. If you find you have these ...
...does not have a website yet. We therefore need top-quality leads to contact, and they have to meet 2 criteria: 1. The business should NOT have a website (Facebook, free websites etc. are ok) 2. The business MUST HAVE a contact phone AND e-mail. The businesses need to be in the home service business in the UK (Plumbing, Electrician, Roofer, Mason, Painter, Cleaner, Pest control, etc.) We need a CSV file with the following columns): BUSINESS TYPE BUSINESS NAME BUSINESS ADDRESS BUSINESS ZIP BUSINESS CITY BUSINESS LOCALITY (IF APPLICABLE) BUSINESS E-MAIL BUSINESS PHONE BUSINESS SOCIAL LINKS (IF APPLICABLE) SOURCE FOR INFO! (this is the source where you got the info from) I say high-quality leads because when we cold-called samples earlier half of them had websites and som...
### Query: I'm looking to create a WebAR experience without incurring expensive monthly costs. Could you suggest some cost-effective solutions and the necessary requirements for implementation? ### Requirements: 1. **Open-source Libraries**: - ****: - Technology: JavaScript - Compatibility: WebXR, WebRTC - Cost: Free - **MindAR**: - Technology: JavaScript - Functionality: Marker-based AR - Cost: Free 2. **Frameworks**: - **A-Frame**: - Integration: - Cost: Free - Technology: Web-based framework 3. **Combination Solutions**: - ** with WebXR**: - Technology: JavaScript - Functionality: 3D graphics rendering, AR integration - Cost: Free 4. **Commercial Platforms
I'm looking for an experienced Python Developer to assist with web development tasks using Django and Flask frameworks. Key Responsibilities: - Implementing web development tasks using Django and Flask frameworks. - Ensuring the code is of high quality and meets our standards. - Collabora...Flask frameworks. - Ensuring the code is of high quality and meets our standards. - Collaborating with the team to deliver project requirements on time. Ideal Candidate: - Proficiency in Django and Flask is a must, with experience in building scalable web applications. - Previous experience with Python for web development is highly desired. - Knowledge of databases and data storage systems like MySQL, PostgreSQL, and MongoDB is a plus. - Strong communication skills and ability to work well...
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
