Perl script connect sql server database jobs
...more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Excel spreadsheet. • Update a different table using simple IF conditions based on the calculated values. • Ensure the solution is optimized for minimal database overhead and runs as efficiently as possible. ...
I'm looking for an experienced Pine Script programmer to create a version 6 code for TradingView. This code will implement the following: - Draw a Simple Moving Average (SMA) with a period of 20 on the main chart (overlay = true). - Draw two Exponential Moving Averages (EMA), one with a period of 5 and another with a period of 25, below the main chart (overlay = false). - Draw an upward arrow if one the the two conditions was fulfilled: a. If the last closed candle's EMA(5) has crossed above EMA(25) while the closing price of that candle is already above the SMA(20), or b. If the closing price of the last closed candle is above the SMA(20) while the EMA(5) of that closed candle is above EMA(25). The default colors for the indicators are: - EMA(5): Blue - EMA(25): Ora...
I'm in need of a detail-oriented freelancer for a data entry project. The task involves manually entering data from PDF files into a database. Ideal Skills and Experience: - Proficiency in manual data entry - Experience working with PDF files - Familiarity with database systems - High attention to detail - Ability to maintain confidentiality and handle sensitive data with care.
I'm looking for a skilled database programmer to create a stored procedure for data retrieval across five tables. This procedure should handle complex joins and maintain foreign key relationships. Key Requirements: - Design a stored procedure primarily for data retrieval. - Proficient in managing joins across multiple tables. - Understands and can maintain foreign key relationships. Ideal Skills: - Proficiency in SQL and experience with stored procedures. - Strong understanding of database management and relational databases. - Excellent problem-solving skills to handle complex data retrieval tasks.
...Ultimately, I want to be able to make simple changes myself. I have minimally started my site but it is not yet published. I would need you to review what I have done and move forward from there. Here are some things I have in mind: (1) I have created a chatbot on that I want to connect to the website (2) I want two levels of membership-paid and free so when a member signs in, they will go to the "free member page or the paid member page" (3) there will be "chat lounges" available for players to connect (4) there will be a book I wrote to promote (5) there will be online courses to promote.. What this means is that the "projects" would be done by you, the ongoing maintenance and simple changes would be done by me. 10:08 PM Key Responsi...
I'm in need of a proficient freelancer or a professional agency capable of curating and delivering a detailed database of 7,000 US companies. Each company profile must encompass key details like the company name, and its associated emails (e.g CEO email, Owner email, Founder email etc.) along with the website. Key Requirements: 1. All data must be current and verified for precision. 2. Data must be sourced from credible platforms to ensure uniqueness, eliminating any duplication. 3. Final data should be presented in an orderly Excel or Google Sheets format. 4. Timely delivery within 7 days from the project start date. 5. Proficient use of data scraping and verification tools and platforms. Please ensure to read the project description carefully before bidding. If you're ...
...processing. Ensure data validity and store parsed data in S3. Data Transformation Enrich and reshape parsed data for analysis or database upload. Store intermediate results in S3 for staging. Data Upload to SQL Database Save transformed data into Amazon RDS (PostgreSQL/MySQL) with optimized database inserts. Ensure data integrity and performance. Data Analysis and SQL Transformations Execute SQL procedures and queries in RDS for additional analysis and derived insights. Store final results in the database for website access. RESTful API Development Build a secure RESTful API using AWS API Gateway and Lambda to provide real-time data to the website. Optimize database queries to minimize latency and maximize efficiency. Non-Funct...
I'm looking for a Pine Script expert to enhance my TradingView setup. Currently, I have a Heikin Ashi-based strategy with defined buy and sell conditions. My objective is to automate this process across approximately 40 stocks. Key Requirements: - The script should scan the 40 stocks and place Limit Orders via my trading account for those that meet the buy/sell conditions. - For stocks that partially meet the criteria, the script should execute a partial order instead of ignoring the stock or sending an alert. - The script needs to be user-friendly and efficient, eliminating the need to attach my strategy to every single chart. Ideal Skills: - Proficient in Pine Script with extensive experience in TradingView. - Understanding of Heikin Ashi and sto...
...Ultimately, I want to be able to make simple changes myself. I have minimally started my site but it is not yet published. I would need you to review what I have done and move forward from there. Here are some things I have in mind: (1) I have created a chatbot on that I want to connect to the website (2) I want two levels of membership-paid and free so when a member signs in, they will go to the "free member page or the paid member page" (3) there will be "chat lounges" available for players to connect (4) there will be a book I wrote to promote (5) there will be online courses to promote.. What this means is that the "projects" would be done by you, the ongoing maintenance and simple changes would be done by me. 10:08 PM Key Responsi...
I'm in search of someone with strong personal connections in Canberra. The goal is to assist with business networking across multiple sectors. Key Responsibilities: - Connect me with potential clients and local businesses. - Help me attend relevant networking events. Industry Focus: - Primarily in Technology and Retail. - Also interested in connections within the New Restaurant sector and with Delivery Gig Drivers. Ideal Skills: - Excellent communication and interpersonal skills. - Strong understanding of the mentioned industries. - Ability to leverage personal connections for business opportunities.
I'm in need of a talented copywriter with a knack for persuasive, engaging content to help me promote my service. Key Requirements: - Exceptional writing skills with a focus on compelling copy for marketing and sales - Previous experience in service promotion preferred - Ability to understand and connect with a broad audience - Creativity and ability to think outside the box Please provide samples of your previous work, particularly any that relates to service promotion.
I need a seasoned Windows Server Administrator with robust Active Directory management experience. This ongoing project involves configuring group policy for security settings, software installation, and user configurations. Ideal candidates should: - Have in-depth knowledge of Windows Server and Active Directory - Windows OS Hardening - Demonstrable experience in Group Policy configuration - Ability to ensure compliance with security protocols - Proficient in managing software installation through group policies - Skilled in user configuration settings Your role will be pivotal in enhancing our server environment's operational efficiency and security.
I'm looking for someone who can help me connect my CRM with WhatsApp through Twilio and Zapier. Every new lead that enters my CRM should automatically receive a WhatsApp welcome message. I've already done most of the setup, including registering a number on Twilio. I just need help with the configuration. The WhatsApp message will include the client's name and should be sent to all new leads without any conditions. Ideal skills for this project include: - Experience with CRM - Proficiency in using Twilio and Zapier - Ability to configure automated messaging systems
I'm in need of a modern sticker design featuring a coat of arms with a caduceus. The design should include our comp...and the English underneath. Key design specifications: - The sticker is a circle with a diameter of 2.5". - The primary color scheme is red, white, and black. - The overall feel of the sticker should be fun and bright. -Our company logo should be incorporated (see attached file) Preferred design elements: - The coat of arms should be in a modern style. - The font for the slogans should be in a script style. Ideal candidates should be proficient in graphic design, have experience with sticker design, and be able to incorporate our company logo into the design seamlessly. A good understanding of modern design aesthetics and a knack for creating fun, brigh...
I need help with explore an Oracle database on my Windows 11 machine, this project will be conducted remotely for security purposes. Please note, this project will be conducted remotely for security purposes, so a reliable and secure remote connection is essential. Your understanding and expertise in these areas will ensure the successful completion of this project.
Job Advert: Script Editor for Children's Television Series Are you an experienced script editor with a passion for crafting stories that captivate kids? I’m looking for someone to help refine the script for my 2D animated series aimed at children aged 4-8. What I’m Looking For: A script editor with experience working in children’s television. Someone who understands how to craft stories that resonate with 4-8-year-olds. A collaborator who can elevate the script while staying true to its vision and themes. Responsibilities: Provide thoughtful feedback and detailed notes on the script. Ensure the dialogue, pacing, and structure are engaging for the target audience. Polish the script to meet industry standards and mai...
I'm looking for a short, engaging ad designed to generate leads for final expense life insurance 30-45 seconds. Script is already complete with details. Open to suggestions. This video will feature an old couple in financial and emotional distress over how to pay for their funeral as described in the following scenes: First scene: This scene shows the elderly couple sitting in the living room in distress searching thru mail and searching online. "Stop worrying about the future! Second scene: This scene shows 3 middle aged sibling positively honoring their parents at their grave stone "You may qualify for up to $40,000 in Final Expense Benefits for your burial." Third scene: This scene shows the elderly couple from the first scene picking up the phone and ta...
I'm looking for a quick Python script that can help me automate the reading and databasing of LAS file format headers using the LASIO library. The product tables should be exported in csv format. - Read a library of LAS files - Ingest and export CSV files The task is straightforward: there's no need for specific processing or data transformations on the files before exporting to CSV. The ideal freelancer for this job should have: - Proficiency in Python, particularly in file handling and CSV manipulation - Experience with automating tasks using Python scripts - Ability to deliver a simple and effective script in a short timeframe.
I am looking to create a vibrant and colorful website dedicated to showcasing pets for adoption. The main objective of this site is to connect loving homes with adorable pets in need. Key Features: - An interactive and engaging user interface that reflects a playful and colorful design style - Integration of an adoption application form for prospective pet parents. Ideal Skills: - Proficiency in web design and development, particularly for e-commerce and non-profit sites. - Experience in creating playful, colorful websites. - Understanding of user-friendly interface design. Please provide examples of similar projects you have worked on in your proposal. Thank you!
I'm looking for an experienced developer to create a simple grid trading bot for me. The bot will need to operate on the Bitget platform, and I require the strategy to be built in Pine Script. Key Requirements: - The bot should implement a price movement trading strategy. - It should have adjustable settings for different trading conditions. Ideal Skills: - Proficiency in Pine Script. - Previous experience with trading bots, particularly on Bitget. - Understanding of price movement trading strategies. Please provide examples of your previous work related to this project when you bid.
I need a Python script that can help me extrapolate and adjust historical stock data based on a constant ratio. Here's what the project entails: - **Data Extrapolation:** The script should be able to download a stock symbol's data from Yahoo Finance across all available time-frames (daily, hourly etc.) and fill the gaps using a pre-determined ratio. - **Data Adjustment:** The adjusted data should be calculated using the formula: Adjusted Data = downloaded data * Ratio. - **Flexibility:** The script should be adaptable to any stock symbol available on Yahoo Finance, not just the one I'll be providing. The ideal freelancer for this project should have: - Proficiency in Python, with a strong understanding of data manipulation libraries. - Experience wo...
...processes as we expand. --- Key Responsibilities HubSpot Administration: - Design, optimize, and troubleshoot workflows for marketing, sales, and automation. - Manage HubSpot CRM setup, administration, and customization. - Create and maintain custom reports and dashboards. - Implement lead scoring, sales automation, and marketing workflows. - Leverage HubSpot API integrations to connect tools and streamline processes. - Work with HubSpot custom objects and sandbox environments. - Collaborate on HubSpot strategies and execution to meet client and team needs. Development Work: - Full-stack development to support both internal and client-facing needs. - Leverage coding skills for custom HubSpot integrations and other tasks. - Help grow and refine our te...
...joining relevant Facebook Groups to connect with members and entice them to join our community or follow our professional pages. You’ll also find ways to creatively encourage personal connections, such as adding people as friends and interacting with their posts to inspire them to follow or engage with us. The ideal candidate is flexible, adaptable, and deeply passionate about creating compelling content that resonates with a variety of audiences. You should have experience managing social media accounts, creating high-quality content, and developing innovative strategies to grow audiences and drive engagement. You must also be self-motivated, detail-oriented, and comfortable working in a fast-paced environment where your creativity and ability to connect with other...
I need somebody who can connect my merchant center to shopify. It was connected the whole time and suddenly it disconnected. I know its a small job but those things needs to be done as well
I have an ATV electronic drum kit with an aD5 sound module, a Focusrite Scarlett 2i2 Audio Interface, a Behringer XenyX Q1202USB mixer, and Reaper 7.3 DAW on a Dell Inspiron Computer. I need assistance connecting these components so I can record playing the drums along with MP3 music files using Reaper. - My main difficulty lies in connecting the hardware components - I want to monitor audio during recording sessions using both headphones and studio monitors - I have all the necessary cables for connecting these components Ideal candidates for this project should have experience with electronic drum kits, Focusrite audio interfaces, Behringer mixers, and Reaper DAW. They should also have a good understanding of audio setup for recording. Please reach out if you can help me get this setu...
I'm embarking on a personal writing project with a friend (roleplay) that weaves in references to North American Indigenous cultures. While I did a lot of research to be respectful to the cultures it references, I have come empty-handed when it comes to finding a name/nickname for a specific character. I am looking for a word, a name, in any North American Indigenous language, that means something akin to "reflection of stars on water". Anything close to this works, perhaps using "sky" instead of stars, "ocean" instead of water, etc. As long as it fits, I'll take it. I also am unfortunately on a tight budget, hopefully this won't be too big of a problem and we can find even grounds.
Custom PHP Script for Batch Code Update in MySQL Database I am looking for an experienced PHP developer to create a simple and effective script that interacts with a MySQL database for bulk code updates. Requirements: Input Handling: The script should accept a list of codes through a text box, where each code will be pasted on a new line. Database Interaction: For each code input, the script must locate the corresponding record in the MySQL database, where the codes are stored in individual rows. Value Update: Upon finding a match, the script should update the value of that code with a number specified in a second text box. Error Handling: If the script cannot find a code in the database, it should skip that code...
Convert Excel data to Access for monthly data storage and invoice calculation and creation for small water utility company.
I'm looking for a freelancer to convert a Python trading indicator into TradingView PineScript. The ideal candidate must have proven expertise in both Python and PineScript, along with prior experience converting or building indicators. Please include a brief personal message with your bid to confirm authenticity and highlight rele...freelancer to convert a Python trading indicator into TradingView PineScript. The ideal candidate must have proven expertise in both Python and PineScript, along with prior experience converting or building indicators. Please include a brief personal message with your bid to confirm authenticity and highlight relevant experience. Automated bids will not be considered. I have attached the python script and associated CSV files needed for datafram...
I'm looking for an AWS expert who can configure an IP camera to connect to an AWS S3 server. The project will also involve setting up a system for batch processing of the video files. Key Requirements: - Extensive experience with AWS and its services, particularly AWS S3. - Previous work with IP cameras is a plus. - Competence in setting up video batch processing. - Ability to deliver clear, thorough documentation of the setup process. The ideal freelancer would be able to streamline the process and ensure seamless integration between the camera and the AWS server.
I'm seeking a freelancer to run a Python script that scrapes the entire DataAxle database of 18 million companies. The end goal is a comprehensive spreadsheet that includes all available fields. Example fields include: - Company name and address - Industry and revenue - Number of employees and contact details - SIC Code - SIC Code Description The primary purpose of this data collection is for sales leads generation. Ideal Skills: - Proficiency in Python - Experience with web scraping - Familiarity with DataAxle or similar databases - Ability to generate clean and comprehensive spreadsheets - Understanding of sales lead criteria
I'm facing script errors in my Browser Automation Studio (BAS) bot, specifically within the login process. The bot is meant to log in using a standard username and password mechanism. Ideal Skills and Experience: - Extensive experience with Browser Automation Studio (BAS) - Strong debugging skills - Knowledge of API integration - Experience with login automation - Familiarity with script error diagnosis and rectification
I'm looking for a LinkedIn expert who can help me to enhance my presence on the platform. The primary goal of this project is to comment, network, and connect with people across the platform. Key Activities: - Commenting on posts: I want you to actively engage with relevant content on LinkedIn. - Networking with professionals: I need you to identify and connect with key players in my industry. - Connecting with new people: Expanding my LinkedIn connections is a key part of this project. The ideal freelancer for this project should have: - A knack for networking - Excellent communication skills - Proven experience with LinkedIn engagement - Ability to comment on posts in a way that adds value and showcases expertise Daily Requirements - 50-60 comments Connection...
...an efficient and robust workflow. The script has separate files for administrator, teacher and student, so the changes to be implemented should be replicated based on this structure. 1. Fix CKEditor problem with modal windows Problem: When trying to insert images using CKEditor, the field crashes and cannot continue. Requirements: Identify and resolve the problem that prevents the correct use of CKEditor in modal windows. Ensure that CKEditor functions (e.g., insertion of images, HTML code, and other elements) are working correctly. Test compatibility on multiple browsers and devices. Complete deletion of tasks, users and other items 2. Requirements: Ensure that deleting tasks, users or other records from the system also removes them from the database. For related att...
Proposed Milestones Milestone 1 ($25): - Fix Bug 1: Resolve the redundant intensity level input at the "stuck" point. - Update the display of `problem name` and `SUDS` to occur before process blocks. Milestone 2 ($25): - Fix Bug 2: Standardize recursion behavior for all levels, ensuring consistent handling of underlying issues. Milestone 3 ($25): - Fix Bug 3: Correct report generation to include: - Level six problem name and statistics. - Proper handling of "Ghostbusters" transitions, recursion, and checks for underlying issues. Milestone 4 ($25): - Final optimization: - Consolidate as much code as possible into the main procedure. - Ensure alignment with the flowchart. - Conduct thorough flow testing to verify functionality.
I require a seasoned Network Administrator to assist with managing my Linux server. The primary task involves configuring the server to block and allow specific API calls. Ideal Skills: - Extensive experience with Linux servers - Proficient in network administration - Familiar with various API types (REST, SOAP, GraphQL) - Knowledge of server firewall tools (iptables, UFW, Firewalld) - Strong problem-solving skills
I'm in need for a skilled and compassionate professional to help my GoFundMe campaign reach its target. The campaign is dedicated to supporting a charitable cause: aiding a Palestinian family in need. It's crucial to emphasize in the campaign their personal story. This family has faced unimaginable hardships, and sharing their journey can help us connect with potential donors on a deeper level. A compelling narrative can greatly increase our chances of hitting the target. The ideal candidate for this project would be someone with experience in fundraising, particularly through GoFundMe, and excellent storytelling skills. Your understanding of, and sympathy towards, the Palestinian plight will be an added advantage. This project is not just about raising funds, but also ...
I'm in need of a PHP script that will restrict all search engine crawlers from accessing any page on my entire website. The script needs to be robust and capable of preventing page access for these bots. Ideal Skills and Experience: - Proficient in PHP - Experience in web security - Knowledge of bot detection and blocking techniques
Website Revamp with New UI/UX Design I need a complete redesign of my current website with a new UI/UX but keeping all functionalities and links to the same database. The new design should align with the provided Figma prototype (but with old website data and sections and with new design) in terms of colors and modern aesthetics, with an emphasis on ease of navigation and responsiveness. old web site: figma design: Key Requirements: - All components from the old site must be retained
...programmer for native Android development. The task at hand is to create a client-server application for managing mobile clients. It's crucial that you have substantial experience working on such applications. Key Requirements: - Expertise in Java or Kotlin for Android development - Proven track record of developing client-server applications - Immediate availability for urgent project commencement In this long-term project, there's potential for permanent hiring. I will consider professionals who demonstrate commitment, deliver quality work, and have sufficient availability to dedicate to this project. Please note, the specifics of the application functionalities, the type of database to be used, and the method of server interaction have yet to...
I'm looking for a proficient Terraform developer to create a script for Google Cloud. We need the script to create these items 1. networking 2. GKE cluster with one node 3. permanent volume and claim for GKE 4. Postgres SQL service - needs to be accessible from GKE 5. API Gateway - if API URL is /example1 > run a lambda function - otherwise forward API request to /endpoint/{incoming URL) (a service running in GKE) 6. IAM Role Binding for Cluster Access
I have several Excel/CSV files containing sales records that need to be transferred into our current digital system, which is a txt format. Key Responsibilities: - Accurately input sales data from Excel/CSV files to the txt system. - Ensure data integrity and correctness during the transfer. Ideal Skills: - Proficiency in handling Excel/CSV files. - Attention to detail for data ...containing sales records that need to be transferred into our current digital system, which is a txt format. Key Responsibilities: - Accurately input sales data from Excel/CSV files to the txt system. - Ensure data integrity and correctness during the transfer. Ideal Skills: - Proficiency in handling Excel/CSV files. - Attention to detail for data accuracy. - Experience with data entry and database m...
I'm seeking a professional to assist with migrating my Laravel website to a dedicated server. The job includes transferring the database and pointing my existing domain to this new hosting server. Key Responsibilities: - Migrate Laravel website to a dedicated server - Transfer the database - Point existing domain to the new server - Update the Laravel framework during the migration - Implement specific server configurations as required Ideal Candidates Should Have: - Extensive experience with Laravel and server migrations - Proficiency in configuring dedicated servers - Capability to update the Laravel framework - Knowledge of required specific configurations - Excellent problem-solving skills to ensure a smooth transition
...for a codecanyon script website, which is already live in The script: Changes I want… 1. I want a unique custom homepage and gamepage design like these website: 2. A all games selector to select all games and delete them together with a delete button. 3. My selected game should show on home page as feature games. 4. I want a separate option to bulk import games from and by just paste and submit their game feed: 5. I want to make this overall theme more lightweight, now the site is taking too long to load a game although I'm using cloud server, I wanted to make
I am in need of a skilled System Admin for my Linux and Ubuntu servers. Key Responsibilities: - Regular updates and patching: Ensuring the servers are up-to-date and secur...skilled System Admin for my Linux and Ubuntu servers. Key Responsibilities: - Regular updates and patching: Ensuring the servers are up-to-date and secure. - Performance monitoring: Keeping an eye on server performance and addressing any issues that arise. Ideal Skills and Experience: - Extensive experience with Linux and Ubuntu server maintenance. - Proficiency in performing regular updates and patching. - Strong skills in monitoring server performance. I'm looking for someone who can keep my servers running smoothly and securely. Your expertise will be crucial in maintaining the health...
I'm in urgent need of a cyber security specialist who can perform thorough penetration testing on my React web application. The primary goal is to identify any potential security vulnerabilities, particularly: - Cross-Site Scripting (XSS) - SQL Injection - Cross-Site Request Forgery (CSRF) Your expertise in assessing these specific types of vulnerabilities will be crucial. The ideal candidate would also have experience in Quality Assurance, particularly with automated testing tools such as Selenium and Cypress. Your role will not only involve identifying security vulnerabilities, but also ensuring the overall code quality through automated testing. Please include in your proposal your relevant experience and any examples of previous work that may be applicable. Thank you.
We need another sequence for the wedding opener. This time, it's about a chat history on WhatsApp and Instagram. The messages should appear in the respective platform designs of Whatsapp and Instagram. I am happy to provide you with: A script with the messages (5 chat sequences) A template from Envato Market (if needed) Would you like to take on this project? Looking forward to hearing from you. Best regards, Tom
I need a freelancer to set up a daily backup of my Microsoft SQL Server database from a dedicated Windows server to S3 AWS Storage. The backup files need to be compressed. Ideal Skills and Experience: - Proficiency in Microsoft SQL Server - Experience with AWS S3 - Knowledge of Windows Server - SQL database management - Data compression techniques