Simple query jobs
...integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of relational databases and experience in query optimization. Previous experience working with MLM databases and familiarity with their structures and terminology. Experience with Dolibarr ERP systems or similar ERP solutions. Ability to work independently and effectively solve problems. Excellent communication skills and ability to work in a team...
We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.
I need a Telegram Web App Simple menu with 4 buttons: Connect TON wallet, Info, Mint NFT, Refer a friend Design is ready Here’s example
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
we are in the need of a simple multi image ( 28 square images on one 16/9 fullscreen ) slideshow, should be windows based, can also be mac based. The app will be used once to playout multiple pictures ( 800 ) taken at an event. App setup settings should be : select folder ( will be dropbox folder which has to be researched for new photos while running ) select image presentation time ( images show for 5-15 sec and then should fade to next image ). after setting up the app should be executed in full screen, exit via 'escape`. as soon as there are more than the 28 images in the folder it should be avoided to have double images shown.
I'm seeking a knowledgeable specialist to perform benchmarks on my Pgvector Chroma Faiss database. The key objectives for this project are: - Analyzing speed and query performance. The ideal freelancer should have: - Proficiency with Pgvector, Chroma, and Faiss. - Experience in database benchmarking, with a focus on query performance metrics. - Ability to provide detailed reports on performance metrics. - Ability to offer performance tuning recommendations based on benchmark results. As this is for personal use, the project requires a specialist who can deliver thorough insights without the need for a business-oriented approach. Your technical database expertise will be crucial for this project.
Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” ...
...activate the account. - **1.2 Login** - Users must log in using their registered school email address. - The system should provide password recovery options. #### 2. User Dashboard - **2.1 Access** - Upon successful login, users are directed to their dashboard. - **2.2 Features** - A search box to look up universities by name. - A list of universities should appear based on the search query. - Users can select a university to view more details. #### 3. University and Course Interaction - **3.1 University Selection** - After selecting a university, a list of available courses is displayed. - **3.2 Course Selection** - Users can select a course to view detailed information, including existing reviews. #### 4. Review Management - **4.1 Review Actions** - User...
...Microsoft Access to assist me with database creation and query design and optimization. The ideal candidate should be able to help me understand: - How to create a well-structured database in Microsoft Access - The best practices for query design and optimization to enhance the efficiency and speed of the database operations You should also be able to provide guidance on: - How to maintain a clean and minimalist design that is easy to navigate - The creation of a user-friendly interface that is intuitive and easy to interact with - The customization of templates to suit specific requirements The completion timeframe is flexible, so I am looking for someone who is patient and good at explaining complex concepts in a simple and understandable manner...
I am in search of a logo for my physical therapy clinic, "Renewed Strength Physical Therapy, LLC." This logo should reflect a unique, feminine, vintage yet minimalist design. KEY REQUIREMENTS: - Color Palette: Mauve, Eucalyptus, and Sky or Opal room blue should be prominent. - Incorporation of Symbols: The logo should incorporate a Christian cross or a Christian fish. - Unique yet Vintage-Style: Although I'm aiming for a vintage minimalist style, the design should also be unique and not too simplistic. IDEAL SKILLS: - Logo design experience - Knowledge in vintage minimalist style - Past experience with healthcare or wellness industry is a plus - Understanding of Christian symbols in design Deliver a design that aligns with my brand's message and positioning: stre...
Looking to have my existing logo, which is currently in PNG format, converted to a vector image in Adobe Illustrator. Here's what I need from this project: - You will be working with a simple logo, predominantly composed of shapes and lines - Original color scheme must to be kept exactly as is. Consists of one color shape on transparent background - I need the final product in Illustrator format (.ai) and png format Ideal freelancer for this job is someone who is skilled and experienced in Adobe Illustrator, especially in recreating logos. It's important that you have a keen eye for detail to replicate the original logo accurately while maintaining its simplicity. The successful freelancer will be expected to deliver high quality work that reflects the professional ident...
I need a power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: -Retrieve product ID, Quantity and Location -Gather specific production data including the production number. Ideal skills: -Proficient in DAX query language -Comprehensive experience with Power Bi -Excellent attention to detail -Previous experience in inventory data management will be a plus. What to do: I need to get a query in DAX (Power Bi) that gives me the same result as what I show in the excel file ( table ( column in yellow)). The excel file was obtained from the attached SQL query () The two screenshots show the power bi tables. I need to get a new column in power bi that shows me the results like in the yellow co...
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the y...
Design: Need a simple clean website, with a few tabs, About Us, What we do, Contact us etc. Colours: Primarily White and blue with a black footer. Can give more details once we agree a price and timelines
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
Need developer who has knowledge of android apps to help me in a small android app related task
We're looking for someone to quickly test our simple software product.
I am ...view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this query does not return any records. I think addCustomView makes rest call and pass all filters in URL. and this URL is too big. Are you able to investigate / fix thi...
I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.
I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.
I'm looking for a skilled AutoCAD designer for a mechanical design project. You'll be responsible for creating a simple drawing with few parts. Key considerations for this project include: - Emphasising dimensions within the design - Including detailed material specifications - Clearly indicating connection details Ideal skills for this project: - Proficiency with AutoCAD, with a focus on mechanical design. - Strong attention to detail to clearly display all required elements. - Experience interpreting and applying design specifications. Please add samples of relevant work to your bid.
The icon should look exactly like this, but should say "Most Savings"
I'm seeking a talented web designer who can create a simple website for me. Key Requirements: - A clean, simple and professional design - Incorporation of text and images The site will be minimal, with only a few pages, so the project shouldn't be too complex. Ideal Skills: - Web Design - Graphic Design Please include a portfolio of your previous work in your proposal. I'm looking forward to reviewing it.
I'm seeking a reliable and competent coder, open to any programming language, be it JavaScript, Python or Java, etc. The complexity of the task is simple, shouldn't pose a challenge for an experienced developer. - Ideal Skills: Proficiency in any high-level programming language, with a track record of successfully completed projects. - Application Requirement: Your application should showcase your past works, preferably related to the project at hand. This will allow me to gauge your skill level and suitability for this project. Looking forward to your bid.
I am looking for a professional with proficiency in Power Query and PowerBI. The key objectives are: - Data Transformation: The expert is expected to possess the skills to thoroughly transform operational data since this is primarily what's going to be handled. - Excel Proficiency: Once transformed, the data should be presented in an Excel file. A good command of Excel functionality is important. - PowerBI Reporting: The transformed data needs to be applied in creating interactive reports. Mastery of PowerBI tools is a prerequisite. - Visual Dashboard Creation: A visually engaging dashboard should be created in PowerBI. Practical knowledge of industry practices in dashboard creation is a plus. Prior experience in handling and transforming operational data and carrying out dat...
We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.
...as well as vector databases to store the index. All ingested documentation is cleaned up and divided into smaller chunks and labeled by source. We then use the GPT embedding API to generate a vector representation of each chunk and store it in the vector db index. When a user asks a question, we convert it to an embedding, and perform an advanced semantic search for closest matches to the user's query. Then we take the most relevant chunks, included them as context along with the original question, and use the ChatGPT API to generate a response in markdown format that we then convert to HTML and display to the user. This is from website. They provide a similarity percentage from the sources they use for the generated answer, we can use that similarity percentage for the r...
I'm in need of a React application that will serve as a simple login system. The app will be using MongoDB to store user login information. Process will be: User logs in. Their login information persists in their state and they can create a user profile and access their user profile Log out and log back in
Homepage: Hero Section: Headline: "Delivering Peace of Mind: Reliable & Secure Courier Solutions" Subheading: "Specialized Same-Day Courier Services for Healthcare and Businesses" Call to Action: "Get a Quote" or "Contact Us Today" Background Image: [Image of a Quiet Craft Solutions INC delivery vehicle parked in front of a hospital or medical facility, showcasing professionalism and healthcare focus] About Us Section: Company Overview: "At Quiet Craft Solutions INC, our mission is to deliver peace of mind through dependable, secure, and timely courier services. We are committed to exceeding customer expectations by leveraging our expertise, technology, and dedication to excellence. As a Service-Disabled Veteran-Owned Small Business (SDVOSB)...
I'm seeking a skilled freelancer who has experience with creating Airtable Dashboards. I posted this previously but I wasn't very clear on specifically what I needed. Please do not respond with an auto-reply as those bids will be ignored. Here is specifically what I need help with: I currently have a database setup in Airtable. It has all the data that I need for my dashboard inside. But special formulas will be needed to calculate certain aspects of the dashboard. Example: I receive a total of 4 individual payments from a vendor. I initially receive 3 of the 4 payments a week after the sale, but I don't receive the 4th payment until ~a month later. Each payment is a separate row in Airtable, but the grouped payments all use the same SAN#. Therefore, I need Airtabl...
I am seeking a WordPress developer who can make specific modifications to a custom query that uses Advanced Custom Fields (ACF). The project involves: - Changing the query parameters - Adding additional query conditions - Sorting the query results The purpose of these modifications is to: - Display specific custom fields - Customize the order of displayed posts In particular, the modified query should display the 'Subfield Date' (from a repeater field) in the query results. Ideal candidates for this project should have: - Proficiency in WordPress development - Extensive experience with Advanced Custom Fields (ACF) - Expertise in modifying and customizing WordPress queries - Thorough understanding of PHP and MySQL Please provide ex...
I'm in need of a publishing expert in book publishing services, specifically for non-fiction genres. I have a fully-completed manuscript and I'm looking for someone to critically fine-tune my query letter and book proposal. Your role would involve: - Review and edit query letter and book proposal for UK and US agents - Offer constructive feedback and direction on improving the overall readability and marketability of the book proposal and letter Ideal candidates should have: - Proven experience in non-fiction book publishing with traditional publishers - Significant experience in the book proposal process - Solid understanding of what works in non-fiction book proposals to secure a literary agent Overall, your expertise will play a pivotal role in the overall su...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
I'm in need of an experienced Vue.js developer to assist with front-end development and implementing dynamic components. The project specifically involves working with Vue 2 and does not require integration with external APIs. Key Responsibilities: - Front-end Development: You'll be tasked with designing and developing the user-facing aspects of the application. - Dynamic Components: Implementing dynamic components to enhance user experience and application functionality. Ideal Skills and Experience: - Proficient in Vue.js: Extensive experience with Vue 2 is a must. - Front-end Expertise: Strong background in front-end development, with a focus on user interface design and development. - Dynamic Component Implementation: Proven experience in implementing dynamic components in V...
Hello See this short video of what I need done = !AnaknzarFP1X1kt2ispbIwh-z-Q2?e=2eBDNY Can you do it right now?
I have a very small dataset and need to do some statistical analysis using SPSS. Need the results in 2 days due to small dataset. Key Responsibilities: - Conducting hypothesis testing using SPSS - Descriptive statistical analysis - Interpretation of the analysis - etc. See the attached files. Ideal Skills and Experience: - Proficiency in SPSS - Strong background in hypothesis testing The answers should be clearly written in a word document. Should you choose to take on this project, please be prepared to start immediately.
...that the specific table causing the error was not identified. Your expertise in this area will be crucial. I am using Magento 2.4.6-p4 CE and I get the following error after every order. The job indexer_update_all_views scheduled at 2024-04-15 10:31:03 failed with the following error message: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in where clause is ambiguous, query was: SELECT `o`.`entity_id`, `o`.`increment_id`, `o`.`customer_id`, `o`.`billing_address_id`, `o`.`customer_email`, `o`.`customer_firstname`, `o`.`customer_lastname`, `o`.`status`, `o`.`created_at`, GROUP_CONCAT(oi.product_id) AS `products`, `billing_address`.`city` AS `billing_city`, `billing_address`.`company` AS `billing_company`, `billing_address`.`postcode` AS `billin...
i need to get build a simple android mobile app. This is based on games. The app must have links open in its own platform. It must operate like a browser.
... Ideal skills and experience for this assignment include: - Expertise in Laravel & MySQL - Experience with high load applications - In-depth understanding of database performance optimization - Experience with online poll/voting systems The specific tasks I need assistance with are: 1. Addressing a database connection error which has arisen due to intense continuous voting. 2. Tackling the query performance problems coming up in our online polling setup. 3. Addressing the data inconsistency issues that have cropped up due to dynamic vote tallying. The votes are expected to be collected as per IP, hence, experience with IP-specific data handling is highly desirable. In summary, I need a Laravel and MySQL expert to revamp our online voting architecture for seamless perfo...
...A data archive is expected to allow users to have a space where they can share data privately to facilitate collaboration prior to publication. Such private enclaves must only last for a defined period of time before that data set is shared with the rest of the data archive will provide an interface that is accessible to anyone with a web browser. A data archive will make appropriate query tools and summary data easily will want to analyze and/or use visualization tools to interact with the data without downloading any data.A data archive is strongly encouraged to use cloud storage and computing possible, a data archive is expected to use existing infrastructures and standards. These could include persistent identifiers such as Digital Object Identifiers
...set of Prev_page/Next_page buttons we should be able to scroll the currently selected file one page at a time. I hope you understood the functionality I want. Also, the app should be able to detect the aspect ratio of each page in the pdf file so that it displays it in 100% view without distorting the text or the images in the pdf file. Please kindly let me know if you can develop this very simple app. Also, the app should be a single standalone exe file. That is, it should not require any sort of installation process to install it. It should just run as soon as we double click it. I believe you can use the pyinstaller app to develop such a single standalone exe file. By the way, I need the file to be developed in python, and all source files should be provided together with ...
I'm in need of an experienced developer to create my Shopify store from scratch. This is a single product online business selling sunglasses and I have both high-quality images and descriptions ready to use. Your task will involve: - Developing a clean, user-friendly e-commerce website. - Setting up a product catalog and managing inventory for one product. - Ensuring secure payment processing pathways are integrated. This must include the popular credit and debit cards, along with other online payment systems. - Integrating the site with social media platforms for increased visibility and customer interaction. Key skills include Shopify development, e-commerce, inventory management, payment gateway integration, and social media integration. Previous experience in developing singl...
I am in need of an individual with proficient skills in data entry for a simple text word document project. Requirements: - Ideal candidates will have a strong background in data entry with a high accuracy rate. - A keen eye for detail is necessary to ensure the entered data is correct and coherent. - Experience with word processing software is crucial, specifically within Microsoft Word. - This project involves purely simple text data, so no complex calculations or figures will be worked with. Objective: - Transform supplied plain text data into neatly structured, accessible Word documents following guidance I will provide. If you feel that this fits your experience and skillset, please provide evidence of any previous data entry projects you've completed.
(VIDEO LINKS FIXED!) I have three performances of the same song: vocal, guitar, and the same guitar from a different angle. I need to edit these into a single video, switching between the shots dynamically and sometimes combining 2 or 3 at the same time. Here are a few references: Below is the folder with the music and the videos, all in sync. I provide three links, if Google Drive says "Download Quota Exceeded" just use a different link: (mirror 1) (mirror 2) Requirements: - Choose the best shot(s) for every moment of the song. - All videos have been glued from smaller clips, and there are obvious abrupt snaps between those clips. Please hide them by jumping to another angle or musician. - When you combine 2 or 3 vids please use thick white borders (collage style) l...
I am looking for a UK based professional with experience in patenting design rights to aid in the protection of my unique household item. Key Responsibilities: - Navigating the process of design patent registration - Preparing necessary legal documents - Providing advice on design protection strategy Skills and Experience: - Expertise in Design Patent Law - Previous work in patenting simple, non-interactive design - Our product we make is an outdoor imitation rock , designed to store either a pet or humans cremation ashes safley inside.
...as peer the dashboard screen provided in figma file. The dashboard and others menus must be created in dynamic way as its menus items and widget in dashboards are different according with the user profile. - Menus and Submenus: The SaaS web app has about 18 screens that allow user to interact with some operations like add a new financial product, query data in tables or grids, update and delete data. All this screen must have filters for query and pagination capabilities. - Data Analytics and Reporting: It's essential that the platform has the capability to collect and analyze data, and present these insights in a user-friendly manner. Further details: - The design of the application should be sleek, intuitive, and responsive and must follow the figma design that...
I'm in need of a talented PCB designer who can assist in creating a simple but effective PCB for a power supply. Key Responsibilities: Need a Small PCB which will contain NodeMCU, 4 Relay, AC to DC 5v. This board is for home automation project which will connect through WIFI, RF and control all home appliances. Ideal Skills: - Proven experience in PCB design. - Understanding of basic power supply principles. - Proficiency in PCB layout softwares, like Altium or Eagle. This is a straightforward project suitable for a skilled PCB designer looking to take on a quick gig.
We need an online Virtual assistant to help us with our company tasks such as social media posts, research data entry etc... The tasks are very simple, however, this will be ongoing, daily work for the foreseeable future. Must be reliable and consistent in order to be successful in this role.
I'm looking for a skilled graphic designer to create a simple yet vibrant abstract design for a women's tee. The design should be: - Abstract: the theme should be abstract in nature, avoiding any literal or representational elements. - Bright and Vibrant: I prefer a color scheme that's lively and eye-catching. - Simple and Minimalistic: The design should be straightforward and not overly busy. A clean, clear composition is key. Ideal candidates for this project will have a strong background in graphic design, particularly in creating abstract works. Experience in designing for apparel, particularly t-shirts, will be a big plus. Proficiency in color theory and an eye for creating harmonious yet striking color palettes is also important. A portfolio demon...
I am looking for a skilled developer to help me craft an app that embodies Airbnb's fundamental aspects, with Android as the platform of my choice. Here are the essential details for the project: Key Features: - Customer Support: Integrated space for users to raise tickets, get their issues addressed, and receive support. - Special Offers: Capability to feature special, limited-time deals or discounts within the app. - Real-time data: updated content, availability, and pricing. Target audience: - Solo travelers: The user interface and experience should cater to solo travelers' needs. - Families: The app should address the specifics required by families, such as large accommodation options, family-friendly activities, etc. - Business travelers: Our app should factor in the essen...