...exist in Excel, create it 2. When a record exist in Excel and Access (based on field: EL_NO, UPDATED ALL FIELDS FROM EXCEL AND OVERWRITE ACCESS FIELDS except THOSE FIELDS IN Access starting with FINAL_ and user data entries. 3. In excel files there it is possible to exist duplicate entries (based on field EL_NO). In that case remove duplicated and leave the record which has a value (<>NULL) in column TEL1. If none has, then leave any of those. In Microsoft Access will exist the following tables: 1. Voters (the subscribers – this will be the main database) (ID is autonumber, EL_NO is unique – no duplicates. See access file attached). 2. User (usernames and passwords, for the users to be able to login locally) 3. User_data (the data that each user will enter for ...
I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're
...to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking
...(Solidity/ERC721) to specifics cryptocurrency markets; I think of a good system and its subsequent easy management; a lot of material needs to be reorganized, offered in English, with a sober and professional style, similar on every website, with the option of being available in every language (Wordpress); the basic contents and plan in matrix at the bottom in (first column general info, each others column basic contents on specific websites/patent); ...not need easy migration (traslation) !!! Please: present clearly your offer better; ...how many days do you need ? ...what kind of trace/flow do you think ? *all my easy action, now start from === old asset - new asset; Aruba / Italia ...next to Hostinger / Lituania .
I'm facing issues with my Laravel Livewire Single Page Application after converting it using Livewire Navigate. The job involves fixing CSS styling issues, restoring missing functionality and ensuring that JavaScript executes properly after the first load. Key Details: - CSS Styling: The breadcrumb styling works perfectly on the first load, but breaks once the Single Page Application (SPA) is loaded. - Missing Functionality: Some features that were present before the conversion are working on Fresh Load but currently missing after SPA Load and need to be restored. - JS Execution: JavaScript isn't working as expected after the first load, this needs to be fixed. Skills and Experience: - Strong knowledge of Laravel Livewire Single Page Applications. - Proficiency in CSS, p...
Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1 Background】 This technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB communication uses high-frequency bands, co...
Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1 Background】 This technology pertains to a vehicle control system designed to enable specific operations on a vehicle. Traditionally, there has been a smart system utilizing electronically authenticated keys through wireless communication with the vehicle. However, a new method using sound authentication with a device worn on the user's ear has been proposed. While this device offers a novel way to authenticate with the vehicle, using standard communication protocols allows authen...
I'm looking for an intermediate Online Reputation Management Assistant to help with a variety of tasks. Key Responsibilities: - Removal of negative content: The ideal candidate should be able to successfully remo...Video Calls: Communication will be done primarily through video calls. Expectations: - Improve overall online reputation: The primary goal of the project is to enhance our overall online reputation. - Work on Client Projects: You'll be expected to handle online reputation management for our various projects. - Agree to Confidentiality: As part of the job, you'll need to agree to a confidentiality clause. I'm seeking someone with intermediate experience in online reputation management. Please apply if you're well-versed in these areas and can ...
Hello, I need mapping a CSV that contains many information and put all words in each column
...Surgery (IBMS) is a prerequisite to applying and acquiring an IBMS International Medical License (IBMS IML) • PDF Filler was connected to upload data required for IBMS International Medical License instantcard ; this was done before and may be the best solution going forward. • QR- lists credentials loaded in the healthcare provider profile • IDEALLY … info should go in automatically…see below fields • QR code ideally could be made by the applicant with the documents loaded appropriately in the designated order …otherwise it must be exported from. physician profile (as noted below) to a new QR code created by this process • Instantcard will send out cards to USA healthcare registrants. • Healthcare providers’ card...
...for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mode of delivery, Drop sequence, PP number, Delivery date, Weight, Volume, Addressee, Name of addressee, Deliver address addressee, ZIP/postal Code, Delivery info, Number of cartons/units, Total ADR. The data is sorted using the “Mode of delivery” information, which allows deliveries to be grouped by truck. During the day&#...
I'm currently using a Python scraping bot for my project, but I need to make some adjustments. Key Requirements: - The primary modification involves segmenting the scraped data by day. To achieve this, I would like to have a timestamp column added that differentiates data on a daily basis. This will allow me to have a better understanding of the data collected each day. Your Proposal: In your application, please provide a detailed project proposal. I'm interested in freelancers who can clearly articulate how they will approach this task and ensure its successful implementation. Ideal Skills and Experience: - Proven experience in Python scraping bot modification - Familiarity with data segmentation and timestamping
...time the back button is clicked from the browser, but when the back button is clicked to return to the homepage, part of the function does not run, causing the animation to break and posts not to load. I'm in need of a freelance web developer with considerable JavaScript experience and in-depth knowledge. The key task will just be to improve this function so it runs each time the homepage is loaded or returned to. Key Requirements include: - Vast experience in JavaScript - Proficient in browser compatibility issues - Keen attention to functionality and performance detail Your role will be to diagnose the issue, remedy it, confirm the functionality by adequately testing in Chrome, Safari and Firefox. I can help explain the function and clearly show where the issue is, ...
Need to convert text file to a clean page and remove the colums showing passwords.
I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that co...
I need a simple, single-column WordPress site set up with the following requirements: - The site will need to be built from a provided WP demo content folder, including plugins and theme. - The main content will be of a standard, text and image-based nature. - The site design should be a straightforward single column layout. For this project, you would need: - Proficient skills in WordPress - Experience with SCSS - The ability to set up a local site - Familiarity with migrating WordPress sites Please ensure you can work with the provided WP demo content folder as the basis for the site.
...focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data in the Expenses column wasn't provided. If interested, please provide a portfolio showcasing your past work relating to Excel and financial data management. Your ability to deliver quality and accurate work will b...
Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.
I've been facing an issue with the images on my WordPress website that only load after I scroll down on mobile devices. Ideally, I need them to load as soon as the page is loaded without any delay. Key Requirements: - Immediate image loading on mobile devices - No specific plugins for image optimization or lazy loading Ideal Skills and Experience: - Proficiency in WordPress development - Experience in optimizing websites for mobile devices - Understanding of image optimization techniques If you're confident in resolving this specific issue and improving mobile user experience, I'd be glad to hear from you.
I need a competent translator who can translate text from Polish to English. The content of the text is non-technical and non-legal in nature, falling under the general category. - Unknown Word Count: The exact word count isn't clear, so please be prepared for flexibility in this regard. - Page Range: The text that needs translating is estimated to be between 1-5 pages in length. The ideal candidate will be a native English speaker who is also proficient in Polish, with experience in translation work. Reliability and commitment to deliver quality work are also important.
...-if you mess up, that is OK, but then you must edit the video. (there is no negative to a video with many edits/cuts) If you rehearse it 2X and then record, it takes about 11 minutes. Total time to perform is approximately 35 minutes... So less than 1 hour Here is the google sheet that is a "conceptual guide". For each row, it tells you how many signs are needed for that row (See” count" column).... (many are done with LEFT and RIGHT hand). In some cases signs are moving vs static and it shows you the "States" of the specific sign. Again, this is a conceptual guide but the example video is what you want to use as a reference. https://docs.google.com/spreadsheets/d/14PJe9FmxsQXvaq-Rm7r1MjD0AjMEfFHocKeVYDtQTDg/edit#gid=10251319 More import...
I'm looking for a CSS expert who can help me identify why CSS is failing to load on all pag...is working fine. - Code: The website is written with custom code. It is not WordPress, TYPO 3 or whatever CMS system. - Attached Images: The first image is the outcome without any characters before the HTML. The second image is with some characters (xxxxx) inserted before the HTML. I need someone who can identify the root cause of this issue and implement a solution to ensure that the CSS is loaded and the pages are displayed correctly. The goal is to have the CSS loading correctly on all pages in this section. Ideal Skills and Experience: - Proven experience in CSS troubleshooting and debugging - Familiarity with website development - Excellent problem-solving skills - Strong atte...
Heading into a sponsorship agreement, I'm in need of a knowledgeable attorney. Your role is to draft a robust corporate sponsorship contract that addresses my major concerns: - Exclusivity Clause: The agreement must ensure that the sponsor will not sponsor similar ventures during our partnership period. - Termination Clause: A straightforward exit strategy if either party needs to back out. - Payment Terms Clause: Clear, concise provisions detailing all aspects of financial compensations. The contract needs to delineate a 6-month term. Lastly, it should expound on the sponsors' obligations, mainly focusing on financial support and promotional services. Suitable candidates have a deep knowledge of corporate law and experience in contract negotiation and dra...
...have a hybrid design, but I'm not sure yet if it will be a hybrid app or separate apps for iOS and Android. Your insights and expertise in this regard will be greatly appreciated. - The primary function of the app is to load a specific website URL. In addition to this, the app should have a menu at the bottom of the screen with 5 specific links that will be provided. - The website URL should be loaded within the webapp itself, rather than opening in a separate browser. - The app should be user-friendly, responsive, and optimized for both iOS and Android platforms. Ideal Skills and Experience: - Proficiency in app development for both iOS and Android - Previous experience with webapp development - Understanding of hybrid app development - Knowledge of user-friendly design an...
...and converting it into JSON format. The PDFs, such as the example provided here, vary in format and column structure based on their categories. The solution should not require downloading the PDFs manually. Sample URLs Requirements: - Develop a tool or API endpoint for extracting data from PDF files located at given extracted PDF table data into JSON format. - Handle various PDF formats with different column structures. - Preferred tech stack: PHP (Laravel), Node.js, or Python. - Ensure robust error handling
Fix related issue in the module. Authentication, column view issue. Able to follow to fix one by one and with ftp
I nee...gifs in the background for animation. Ideal skills for this project include: - Proficiency in WordPress - Strong design sensibilities - Experience with UI and UX design - Ability to implement changes to a live site with minimal downtime UI design should be responsive for all device sizes. All assets should be copyright free and light weighted Animate our logo as a welcome loader until assets are loaded first time. All subsequences website load should be faster. Websites should not have any UI/Performance issues. Initially only work on home page, all other pages will be blank as of now Need to deploy of WP hosting Please write Great in start of your proposal, so that I can filter random bids. I'm eager to hear your ideas on how to improve the landing page and drive mo...
I'm looking for a HubSpot consultant to help me with migtation and mapping from pipe drive, i could use the inetgration to map but emal not showing up and i also need them to map/migrate the special column/field from pipedrive to hubspot, IF YOUR NOT A PRO DONT CONTACT ME . I NEED DONE TONIGHT
...url list of about 300 products, all from the same website b) We should be able to run a macro etc, which we need to do multiple times daily c) When we run the script, it should check if for all those 300 products, there is a MSRP pricing appearing on the website d) The products have many variations, so it should check for all the varitions e) It should create each variation entry into a seperate column and highlight that product as a variation f) If any variation does not have MSRP price appear, then it should highlight that G) If the MSRP is appearing for variation, then it should fetch and enter that number. It is very easy and simple work. Bid only if you can do within next 24 hours. See the attached excel file for the sample of what I need For end solution, i should be abl...
I have a large file from my old website, saved in an unknown format (likely HTML, CSV, or XML). Key Points: - The file is from my old website, saved in an unknown format. - I have access to the old website's database or server files. - The main goal is to retrieve the articles and media from the old website to publish them on a new website. - The exact format of the file is unknown. It will be a TAR file and it is rather large file (5.9 gb) Ideal Skills and Experience: - Proficient in web development and file parsing. - Experienced in handling legacy website data. - Strong problem-solving skills for dealing with unknown file formats. - Ability to extract, organize, and migrate content effectively. This project requires someone who can navigate legacy sy...
Hi, I am new to react. If I click open panel a panel opens. if I drag the item from the panel to column2 it should add to the table and simulataneously it should add to column 1. same way if I add to column 1 it should add to column 2 table two. I am able to achieve for column 1 but not inside column 2 table. can you lee me know how to fix it. Providing my code and fiddle link below. ,src%,src%2FApp.jsx&terminal=dev import { useState } from 'react'; import reactLogo from './assets/'; import viteLogo from '/'; import './'; import { DragDropContext, Droppable, Draggable } from 'react-beautiful-dnd'; function App() { const [panelOpen, setPanelOpen] = useState(false); const [columns, setColumns]
I stumbled upon an instrumental track in an online video but I can't seem to pinpoint its origin. Requirements: - Identify the unknown song and artist from an online video - No lyrics in the instrumental track - You will be provided with a link to the video Ideal Skills: - Experience in music identification - Proficient in instrumental music recognition - Attention to detail and patience Let me know if you think you can help and I'll send you the link. If you're able to identify the song and the artist, Thank you!
...freelancer must figure out which one) main WordPress theme. The ideal freelancer has to have experience dealing with WordPress themes and should be capable of figuring out the main theme on their own. Key Tasks: - Install Photograph Child Theme on main WordPress theme - Ensure compatibility of the child theme with the main theme The entire child theme design (pictures, logos, texts, etc.) must be loaded correctly so that the freelancer can immediately begin editing the site blocks according to my task given to the freelancer. The freelancer will need to be proficient in WordPress, theme installation, and troubleshooting. The ability to determine the parent WordPress theme through analysis of the website is necessary. Knowledge on customizing WordPress themes is also a ...
The specific goals and scope of this project are currently unknown as the initial questions have been skipped. The target audience is also undecided. We are open to professionals with a wide range of skills willing to collaborate on this venture. In proceeding, please be aware that further information on the project will only be provided during the interview stage.
...formwork plan over the ground floor • Plate reinforcement plan over the ground floor • Formwork plan and beam reinforcement over the ground floor • Formwork plan and ground floor pillar reinforcement • Formwork plan and ladder reinforcement • Plate formwork plan over the floor • Plate reinforcement plan over the floor • Formwork plan and beam reinforcement above the floor • Formwork plan and floor column reinforcement • wood Frame/ roof plan • wood Frame / roof details - **Sanitary and Thermal Installations Design**: In addition, I require a dedicated engineer with expertise in sanitary and thermal installations. This professional will be responsible for creating the necessary technical designs and providing detailed installatio...
I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.
As the owner of a coupon codes website, I am in desperate need of improved search engine rankings. Our current SEO state is quite poor and needs significant enhancement to better cater to our audience who are avid discount seekers. - Our website is unknown for its ranking and thus our main goal is to enhance visibility in search engine results. This will in turn increase traffic, conversions and ultimately, revenue. - Unfortunately, the primary audience for our website was not specified. Despite this, we trust that you as the SEO expert will leverage suitable strategies to pull in diverse audiences, until a main demographic is determined. - Ideal Skills and Experience: - Proven SEO experience - Understanding of performance marketing, conversion and online customer acqu...
I am new to Power Automate. I have already built several relatively complex Flows, but I am facing a few issues related to dynamic UI elements and how to stop a loop. I am looking for someone with a strong grasp of Power Automate to help me solve these issues. 1. How to stop a loop based on a Python GUI counter. 2. How to pick a link in a table based on the right column (in Salesforce). 3. How to click a download link that always has a different CSS identifier. 4. ...might be an additional question that arises. Note that autodesk is not allowed on my work computer but I can provide very detailed information with screenshot from Power Automate to help you understand the issues.
I need a simple code that can send a purchase transaction for tokens in python or rust The code should have two statements: #3 - Associated Token Account Program: Create #4 - : Unknown for - 6EF8rrecthR5Dkzon8Nwu78hRvfCKubJ14M5uBEwF6P CLI program input: privateKey, mint, amount_in output (print): tx sig, status
As part of our Digital Agency marketing strategy, we've got AI-generated content ready. We're looking for a skilled and reliable freelancer to quickly modify and load this content onto more than five websites using our content tool. This content be loaded via simple API interface through Wordpress Key Responsibilities: - Modify the existing AI content to ensure it's optimized for selling our client products or services. As sometimes AI tool mentions other brands too much or puts information not correct in the blog that needs to be removed or edited. - Load the content onto multiple websites using our content management system. The content is tagged so it's easy to know which client we working on each time. Ideal Skills and Experience: - Proficient in English, a...
I need help creating a custom loan agreement. This agreement must be primarily in English but suitable for use in Thailand. While the document does not need to be translated into Thai, it should be compliant with local Thai law. Key components of the agreement: - Interest rate clause - Annual repayment of loan at 10% of each year's capital and at end of year 5 repayment of capital Plus the removal of management fees on both Ardan and RL360 accounts also While drafting experience would be beneficial, a deep understanding of lending law, particularly as it applies in Thailand, is necessary for this project. I'm expecting the work to be thorough, professional and legally sound. Clear communication skills in English are a must too, as we will be discussing complex, te...
...excel file Pictures must be saved with their code. f.e. (code is in column A). If in Column F there are more than 1 pictures, then save 2nd, 3rd etc. pictures like: , adiddv0318_4.jpg... Always in Column F (URL's for download), pictures without _a, _b... are the main picture (therefore must be saved like ). Pictures with _a, b.. etc. must be save as 2nd, 3rd ... (, ). If in Column F there is no picture without _a, then use the picture with _a as main picture and save it as ; If in Column A there are not valid characters (like / ), replace them with _ Tackle4Allitems excel
I am new to react I need to move the item from the column 3 to column 1. Initially I developed static code. then I used react-beautiful-dnd and splice logic to move item from source to destination I even debugged by putting console.log. console not printing, Providing my code below. Can you let me know how to fix it, even needed to be added to table rows when added and integrate in my codebase later can you fix the code in my stackblitz ,src%,src%2FApp.jsx&terminal=dev
I need assistance transferring data between Excel sheets Key requirements: - Data transfer: I'm unsure if this needs to be a manual or automatic process. I'm open to suggestions that will make the process efficient and error-free. - Randomising 'Task Types': This column needs to be randomized each time data is transferred. The 'Task Types' should be selected from a specific range of values. Ideal skills for this job: - Proficiency in Excel )
I'm working with an existing Excel spreadsheet that contains date data. I need help with sorting and filtering these dates. PROBLEM: I have different data set (mm/dd/yyyy and dd/mm/yyyy) in the same column exchanging every 100rows or so...data set is about 70000rows I dont want a solution I want you to teach me how to resolve this because this is something ill do for some time now and i need to know how i can do it by myself. Key Requirements: - Sorting and filtering the dates in the spreadsheet effectively. - Ensuring the sorted and filtered data can be used for additional calculations within the same spreadsheet. Ideal Skills and Experience: - Advanced proficiency in Excel, with a strong understanding of date functions. - Previous experience working with large data sets a...
I'm in need of a skilled legal professional who can create a comprehensive Pandadoc contract template for my marketing agency. Key Requirements: - The template should specifically cater to digital marketing, branding, and design services. - It must include clear and fair payment terms to protect both parties. - A confidentiality clause that safeguards sensitive business information. - The scope of work should be well-defined to avoid any misunderstandings during the project. You'll be expected to: - Understand the nuances of my business and what's essential for a legal document of this nature. - Have experience working on similar contracts, ideally within the digital marketing or creative industry. - Be able to deliver the completed template within a specific deadl...
I'm needing assistance with an error I'm experiencing when trying to open a Jasper report. The error is highlighting missing depende...() at () at () at (Native Method) at (Unknown Source) at (Unknown Source) at (Unknown Source) at () at () at ()
We are in search of a meticulous researcher adept at data compilation within Excel sheets. Your primary task will involve sourcing, researching, and organizing data for a designated list of company names provided. The role entails gathering contact details and accurately inputting them into the provided spreadsheet under relevant column headings such as email, phone number, address, country, buyer name, buyer Linkedin profile link and buyer contact number. The scope of the project requires data collection for a minimum of 1000 companies, predominantly from the United States, along with other specified countries. Upon data entry, you will be responsible for sorting and categorizing companies based on size (large, medium, small), while ensuring the removal of duplicate entries for cl...
I have ongoing work related to our previous project 'FullCalendar Column Customization Needed'
I require an experienced drafter for creating shop drawings for structural reinforcement. This commercial-scale project encompasses beams and columns, slabs and footings, as well as walls and ...Proficiency in drafting software, such as AutoCAD - Solid background in structural engineering - Extensive experience with commercial construction projects - Understanding of building codes and safety regulations - High attention to detail for producing accurate shop drawings Responsibilities: - Developing comprehensive shop drawings for structural reinforcement including, but not limited to, beam/column, slab/footings and wall/partition details. - Ensuring all drawings comply with local building codes and safety regulations - Review and revise drawings, if necessary, to reflect changes or ...
