Import txt file database sql jobs
DATA SCRAPPING DATABASE This is an interesting overview of the steps that might be involved in completing this project: 1. Develop a web scraping script using Python (e.g., BeautifulSoup, Scrapy) 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
...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 within these checklists, ensuring that changes in due dates propagat...
...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 with an ex...
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. ...
...this project is to create a direct integration or web service that can extract 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 abilit...
Hi I will work for 6 hours and get website leads as many as possible till Tomorrow. Thanks
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 validation methods wou...
I'm in need of a 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 seamless in...
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 ...
...aspects 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 availabili...
...set up 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...
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 ...
...that I need. The data columns listed above will be need to be automatically pulled into tables and columns and stored in Microsoft Excel. I need to be able to use SQL or a UI and ultimately easily import/embed into Microsoft Excel - the data finally must be pulled into Microsoft Excel. The freelancer must be Proficient in working with Amazon Seller Central and pulling back the relevant info for comprehensive, robust reporting purposes. Understanding of reporting data from Seller Central data and experience in data reporting and data analytics. Also ultimately this data is to be stored into a database and to where I can use SQL to create queries and tables for dashboard reporting purposes. Your work will be crucial in creating and enhancing reporting f...
I'm seeking a Power BI expert to create a Territory Map of both Zip and State. Key Project Requirements: **Mapping:** Your task involves creating the map with both zip and state information. **Data Update:** The map should be updated periodically, not in real-time. I'm using ARCgis in Power BI to create maps. I can create a good map based on zip codes, or based on state, but I can't seem to figure out how to combine the two. Our CA territory is divided by zip code, but some states are considered one territory. So, I need to apply first a filter by zip code, and then a layer based on state on top of that. Attached is the territory map by zip code that I created with Power BI. I need it to look like that but with New Mexico, Arizona, and Nevada fully colored in with...
I'm looking for an expert who can accurately retrieve data from an AWS RDS Database. The task includes: - Extracting text data, specifically all customer data - Precise collection of customers' names, emails, and membership dates - This project involves data extraction of all customers, not just active members Ideal skills and experience would include a comprehensive understanding of AWS, RDS databases specifically, and a stellar ability in data extraction and management. You should be meticulous and maintain the integrity of the data while handling extensive datasets. Familiarity with customer database management would be an added advantage.
I require a meticulous professional, experienced in the workings of Microsoft Access 2007, to resolve manifold errors plaguing my software application. Key Responsibilities: - Fix syntax errors, making sure the coding with...application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version in the earliest possible timeframe. If you're that hands-on problem solver with a keen eye for detail, you could be just what this project needs. *Some of the sub-application the softwar...
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'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 looking for a freelancer to convert a simple text PDF to a Word document. The key purpose of this conversion is to enable editing of the content in the Word document. Key requirements: - The PDF contains only simple text, no complex formatting, tables, or images. - The Word document should be in a standard format, making the content easily editable. The ideal candidate should have: - Proven experience in similar projects - Proficiency in PDF and Microsoft Word - Attention to detail to ensure accuracy in the conversion process Please include any relevant experience and examples of your work when applying.
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...
This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Appl...
Having problems with Docker and need configurations 1 - 3 current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capab...
I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.
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...
- Merging Persons Records on a Single Table - Fixing some bugs - Displaying "merge company" interface instead of the expected "merge person" interface - Merging Persons Records on a Single Table - Displaying the listed fields on merge person CRM section - Add a "Date-Added" field to CRM records for FirstPrint project. - Update image on CRM Instruction page for FirstinPrint project - Update the Input field and other Issues in the FirstinPrint project
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.
Need a college B. Tech student who is studying and want to earn something.
...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 appreciated to create columns and other...
...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 appreciated to create columns and other...
I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of data - Strong knowledge of d...
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.
Need freshers who want his first job with good visibility.
...previous experience in dealing 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 o...
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.
Need freshers who want his first job with good visibility.
I did convert my existing old website (built 2004) to a responsive html5 website. As a first step I did convert the Homepage () and the into a responsive page without changing the design (look and feel). But the Homepage had only two (horizontal) Navigations. Other pages have an additional vertical navigation on the left side of the page - that needs to be integrated into the responsive navigation. Additional Notes: * Please don´t bid if you don´t have (and can show me) experience with this kind of work; I would like to see working examples beforeward; * To show that you've read and understand the project requirements, please include the phrase "hello pk" in your bid. Failure to include this will eliminate you from consideration. * Payment via escr...
...create a form and results page that is compatible with mobile, tablet, and desktop. The form will have less than 5 fields, but will require special features such as validation checks and file upload capabilities. Key Points: - Design a form with less than 5 fields - Ensure the design is responsive and compatible with mobile, tablet, and desktop platforms - Implement validation checks to ensure accurate data submission - Integrate a file upload capability for user convenience Ideal Skills: - Proficiency in UI/UX design - Experience in designing responsive web applications - Knowledge of form validation and file handling - Strong communication and problem-solving skills Please provide examples of previous projects you've worked on that demonstrate your ability...
I need an experienced data entry professional to update contact emails in 3 databases All of them are updated I need someone to crosscheck & update if they are incorrect & highlight if it is incorrect. DB 1 MC- 5972 DB 2 H- 754 DB 3 AC- 1033 Bid with the exact price you can do this for. I will go with the lowest bid as its an easy task.
...experienced application developer who can build a robust database application. The application will need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database application will manage, this r...
We are seeking a talented JavaScript Developer with expertise in El...building cross-platform desktop applications. Familiarity with OpenCV and TensorFlow is essential, as is experience with ExcelJS or similar libraries for handling Excel files. This project aims to develop a desktop application using that allows users to create custom OMR (Optical Mark Recognition) sheets with questions and multiple-choice options. The application will enable the import of student data to generate personalized OMR sheets for each student and include features for managing committees to oversee exam centers. Key functionalities include an intuitive interface for designing OMR sheets, question placement, and data export capabilities. For more details, please refer to the attached PDF document.
...into my Crystal Report PDFs within my web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I'm l...
I need a freelancer to convert a series of simple, text-based PDF documents into Word. Your job is to ensure that the text in the Word documents is fully editable, and that the original formatting is preserved. Key Responsibilities: - Convert multiple text-based PDF documents into fully editable Word documents. - Ensure the text is accurately extracted and maintained, without any errors or omissions. - Preserve the original formatting of the documents in the Word version. Ideal Candidate: - Proven experience in PDF to Word conversion, especially with multiple documents. - Proficient in software for text extraction and formatting preservation. - Attention to detail and ability to meet deadlines. Please note that the documents are text-only, so no experience with image or table conversi...
Currently using .Net Framework 4.5 and looking to upgrade project. The main goal for this upgrade is to ensure compatibility with modern systems. I don't require any specific performance improvements, just upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibility with...
