Database variable column numberεργασίες

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...

...expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Products, and Orders. - Write queries: I need you to write SQL queries that will allow me to seamlessly interact with the database. Specifically, I'm looking for someone who can: - Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Exp...

I'm in need of a proficient database specialist to manually collect email addresses and phone numbers, and compile them into an efficient and reliable database system. The leads to be collected are specifically from the Social Media industry. Ideal Skills and Experience: - Proven experience in data collection and management. - Exceptional research abilities, particular in the social media landscape. - Ability to use manual collection methods efficiently and effectively. - Knowledge and understanding of database management and lead generation. - Accuracy and attention to detail in dealing with phone numbers and email addresses. Roles: - Locating and collecting required data from specific direct websites. - Organizing the data into a systematic database...

I'm seeking an expert in Entity-Relationship Modelling and Rational Database Design. Key Requirements: - I need an expert in this particular area. Please only apply if you have a proven track record in both Entity-Relationship Modelling and Rational Database Design. - I'm looking for a high-level overview of the Entity-Relationship Diagram. This means I don't need every minute detail, but rather a clear and concise depiction of the core entities and relationships. - Experience is key. Please share your past work in this field. Ideal Skills: - Proficient in Entity-Relationship Modelling - Experienced in Rational Database Design - Strong track record in this particular project type - Excellent communication and understanding of client needs. Pleas...

...of any length and return specific data about those products. Here's what I need in detail: • Find top hot selling products at any given time • Crawl eBay and AliExpress for specific product data based on entered keywords. • The data retrieved should include product names, quantities sold and locations of sellers, images, • The crawler should be capable of providing this information for a variable timescale, ranging from 1 to 30 days in the past. • The results should be sortable. Php or python preferably The task would best suit a freelancer with previous experience designing similar crawlers and a deep understanding of web scraping, data mining, eBay and AliExpress's data structures. Proficiency in Python, Java, or another similar lang...

I need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel format:

I need a skilled professional to assist with a data entry task. The project involves the following: - The task is primarily image data entry. - The images will be provided in digital photo format. - The entered data should be compiled into a database. Ideal candidates should have experience with data entry, particularly with image data. Proficiency in database management is also essential. A keen eye for detail to ensure accurate data entry is a plus.

...ages-python Need simple process (like click action button and select file with image urls) to extract numeric digits TEXT_DETECTION on JPG images hosted on cloud server using API. ATTACHED: - Sample of image from url and what is required to be extracted. - Data under green header is to be extracted from jpeg file name in image urls - Digits extracted from google vision api to be put under column with header "Google Extracted Text" REQUIREMENTS: - Your relevant experience with Google Vision API or similar text extraction APIs. - Your proposed approach for implementing the extraction process. - A sample of the API usage and extraction results. - Your estimated timeline and cost for completing the project. ******Please note that applications without a sample of API...

I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Data" Cloumn B into A11 as a QR Code Need Text Data from "Sheet Data" Cloumn C into G1 as QR Code The data will be manually pasted into "Sheet Data" I need this for 50 Sheets Pages to ignore Coverpage, Inside and Page Breaks Key Requirements: - Ability to generate QR codes in Excel: The end product should be an Excel script or add-in that can create QR codes based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - E...

I'm seeking a professional who can make an Excel page from a word document and then make it auto organize for our department. This job requires an ability to create a code to organize and automatically count values in certain columns. The code should be designed to recognize and count based on column values. Unfortunately, I'm uncertain about which specific columns should be counted; clarification will be needed later. Key skills would be proficiency in Excel, programming, and an eye for design. Experience in data organization and tracking is a must.

We are seeking a team of Database Engineers who can combine multiple sources of data into an Azure MySQL database on an automated basis. The operation must comply with HIPAA regulations under an organizational development environment (VDE). All VM's and databases will be deployed through Azure.

I am in need of an investment website that allows users to buy and sell stocks. Key Features: - Database Integration: This website should include a database to facilitate and record stock transactions. - Buying and Selling: The primary function of this site is to allow users to buy and sell stocks. - User-friendly Interface: The site should be intuitive and easy to navigate, ensuring a seamless user experience. Ideal Skills: - Web Development: Experience in developing dynamic websites with database functionality is crucial. - Financial Knowledge: A basic understanding of the stock market and investment is advantageous to ensure the site meets the required standards. - UI/UX Design: A good eye for design and user experience is important to create an engaging and...

Look at the samples attached!!!! If you do not know the content in the file, Do not apply You nee...who is skilled in the application of turbo-machinery including the design and operation of typical wind and hydroelectric plants from first principles to the various types of turbo-machines choices. Fundamental fluid mechanics equations, efficiency coefficients, momentum exchanges, characteristic curves, similarity laws, specific speed, vibration, cavitation of hydraulic turbines, pump/turbines; variable speed machines including transients and hydraulic stability. This would be a tutoring position for solution help. We will discuss more. If you want to be considered, look at the samples attached and be prepared to submit sample solutions to the attached files. This is to test your pr...

I am looking for an expert in website speed optimization to improve the mobile page speed of my website. The main goal is to enhance user engagement. I believe an improved page speed will keep my visitors on the site longer, resulting in more interaction. Additionally, I need my blog pages laid out in a single column format. This should be optimized to ensure a seamless user experience across multiple devices. While there are no specific responsive elements advised on, the developer should ensure general responsiveness throughout the page, including any present text content, images, or embedded videos. Ideal Skills: - Proficiency in website speed optimization - Experience with responsive website design - Expertise in blog layout design Experience in SEO will be an added advanta...

...Economics, 4(3), 241 247, if you wish to learn about the formula’s motivation. The Rogers-Satchell range based volatility formula is given by � �??(?)=(1 ?) 1 2(∑{ln(?? ?? )ln(?? ?? )−ln(?? ?? )ln(?? ?? )} ? ?=1 ) 1 2 2. (30 marks) The p-th percentile of a set of n observations of a given variable is defined as the observation located in the p(n+1)/100-th ordered position (e.g. the 10th percentile of a variable for which we have 50 observations is located in the 10 (50+1)/100 = 5.1 or the 5-th ordered position). Program a function to calculate the percentiles. 3. (25 marks) The ? coefficient of an asset measures the sensitivity of its rate of return to variations in the portfolio market return. It c...

...been experiencing. The error states "SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'entity_id' in". Ideal Skills and Experience: - Proven experience with Magento 2 development - Strong understanding of cron jobs and how they work within Magento 2 - Familiarity with debugging and resolving SQL integrity constraint violations Please note 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,...

...WordPress website's database. The primary reason for this is to lower hosting costs. Key Areas for Optimization: - **Back-end Operations Speed**: The site's backend is significantly slowed down due to the large database. I need a solution that will significantly improve the speed of my back-end operations. Data Types to Address: - **User Data**: The large volume of user data on the site is a significant contributor to the database size. I need to find ways to optimize or archive this data without compromising its integrity. - **Media Files**: The site is media-rich, and the files are taking up a lot of space in the database. I need to find a way to reduce the size of these files without compromising the images or videos' quality. - **Logs an...

• Automate the collation of data from two sheets, "Data" and "Report," into one Excel workbo...data from two sheets, "Data" and "Report," into one Excel workbook. • Transfer data from specified columns in the "Data" sheet to new columns in the "Report" sheet. • Implement exception handling to address missing values during the data transfer process. • Develop an email notification feature to inform managers about the completion of the collation process. • Add "Data" suffix to transferred column names in the "Report" sheet for differentiation. • Provide a solution to automate the process without manual copying and pasting of VBA code. • Name the final file as "Book o...

We need a good database of Qualified and experienced candidates resumes for us to hire in a Megawatt Solar Clean energy project. Database should be live and good up to date database with full Resumes of the interested candidates.

I'm looking for a skilled and experienced professional to create a comprehensive Farsi database for advanced language learning purposes. This database will be used as a refrence for a text generator Ai Key Project Details: - The focus of this database should be on advanced-level language content - Content should include a mix of literary texts, technical documents, everyday conversations, as well as other forms such as books and poems. Ideal Skills and Experience: - Proficiency in Farsi language - Experience in creating educational content, particularly for advanced learners - Ability to source and organize a variety of content types, including literary and technical material - Strong understanding of language learning methodologies and best practices - Familia...

...connection errors that have arisen on my Windows-based Sal server. The server is primarily used for database management. Key Responsibilities: - Investigate and pinpoint the root cause of the connection errors. - Implement necessary fixes to ensure a stable and reliable database management system. Ideal Skills: - Proficiency in Windows server environments. - Extensive experience in database management, particularly in resolving connection errors. - Strong analytical and problem-solving skills. - Excellent communication to ensure the process is transparent and educative for me. Please provide an overview of your relevant experience and your approach to addressing connection errors in database management systems. Looking forward to working with an individu...

I am looking for a knowledgeable freelancer with solid experience in Android development, particularly in the field of business process optimization apps. Primary Requirements: - Implement bug fixes in User Interface and Database Management. - Optimize pages for enhanced performance. Ideal Freelancer: - Should have extensive experience working with Android applications. - Proficiency in UI enhancements and Database Management. - Knowledge of business process optimization apps is beneficial. Please make sure you can commit time to promptly address and resolve these issues. Let's make my app better together.

...Requirements: - Product Page Layout Modification: I need to incorporate 15+ jewellery variables into the product pages. These variables will influence the pricing and display of the products. - Dynamic Pricing: The dynamic pricing should be able to adjust based on the selected variables. This will require a more complex pricing structure than a standard Shopify store. - Image Gallery: Each product variable should have a gallery feature allowing me to showcase multiple images of the item. Ideal Skills and Experience: - Proficient in Shopify: A deep understanding of Shopify's backend and customization capabilities is essential. - Dynamic Pricing Experience: Previous experience implementing dynamic pricing is highly desirable. - UI/UX Design: Experience with product page lay...

I'm looking for an intermediate Excel expert to create a user-friendly database system for managing contacts and tracking outgoing information. Key Requirements: - Develop a simple yet effective database system within Excel. - Design a user interface that is intuitive and user-friendly. - Ensure the system is structured to manage contacts efficiently. - Implement a feature to track when and what information is sent to each contact. What I'm looking for: - A freelancer with a proven experience in working with Excel and developing databases. - An intermediate level of proficiency in Excel. Advanced skills are not necessary, but a basic understanding won't suffice. - Ideally, I'd like the freelancer to have experience in designing user interfaces, or at lea...

...along a 30m length table. - The device should be electric-powered. - The device should have a variable speed control, ideally ranging from 0.2 km/hr or less to 1.0km/hr. - The control method for the device should be via remote control. - The device should have an automatic off switch when the limit of the table is reached. - The device will be manually drawn / rolled back to the beginning position. Ideal Skills and Experience: - Mechanical Engineering: To design and ensure the device is capable of pulling the 100kg trolley. - Electrical Engineering: To design an efficient electric-powered system to drive the device. - Robotics/Control Systems: To incorporate remote control functionality and variable speed control. If you have experience with similar projects or possess t...

Change label name Change the id format of the field( one column only) Link the column with correct table. Only developer who can go one by one (I don't share all)

We already have a database built in Air Table and would like to go back to Access. It would be a fairly straightforward process to see what we have and work to recreate in Access. Prefer English speaking and US resident for ease of communication.

I'm experiencing some issues with my Access database. The data seems to be missing or incorrect. Moreover, I need to add new functionality. The additional function is generating reports. Although I haven't specified the type of reports, I expect freelancers bidding for this project to possess experience in various types of reporting functions. Skills required are: - Proficiency in Microsoft Access - Experience in fixing data errors - Expertise in implementing reporting functions in a database It's crucial that the freelancer grasps the issues and rectifies them, and demonstrates an understanding of database reports functions to add onto the system. Bids from freelancers with relevant experience and skills are welcomed.

Hello, there? I have done the project. We can process as our promise. Is it possible to award? I will wait for you.

Google sheet has 5 columns. From the user interface you have to select 4 choices from left to right via drop-down boxes. Once the choices have been made, which must lead to the selection (if possible) of one or more choices, the final result selected in the fourth column must print in the user interface, the contents of the fourth and fifth columns (the latter is a link) . The interface must have a background color, a text with a provided font, and two small images.

...characters should be dog-themed. The game should have an unlimited number of levels. After the initial 1000 levels, the game should be able to repeat, but with a significantly higher difficulty level. Ideal Skills: - Game Development - Mobile Game Development - Candy Crush Style Game Development - Graphic Design - Experience with Match-3 Puzzle Mechanics - Experience with Dog-Themed Games Please provide examples of similar games you've developed in the past. game requirements include but are not limited to: The game should be based on the idea of Candy Crush, however, using a dogs theme Gameplay: - Match-3 Mechanics: The core gameplay revolves around matching three or more dog treats of the same color and shape in a row or column. Players can swap adjacent trea...

My .csv file needs some serious help. Here’s the deal: - Columns aren't properly aligned - I’m finding incorrect entries in certain columns - There's frustratingly missing data in some cells This mess stands between me and importing the data successfully into my database. If you can efficienty wield the tools of data cleaning and if you excel at attention to detail, this could be the job for you. Skills and Experience: - Proficient in csv files management - Highly skilled in data editing, cleansing and validation Please note, I haven’t determined which software I'll use to import the .csv file. Your input on this area will be valuable! I'm open to MySQL, Oracle or MS SQL Server. Let's make things right!

I'm looking for a seasoned email marketer to help us with a weekly campaign aimed at promoting our services and products to a database we've built over the last six years. Key Points: - We need a strategy that is effective in engaging an audience that we haven't communicated with in a while. - Our emails should primarily focus on presenting our latest products and services. The ideal freelancer for this project should be well-versed in crafting compelling product-focused email content, and should have a strong understanding of re-engagement tactics. A background in both email marketing and e-commerce would be a significant advantage.

I'm seeking an Advanced Data Entry Specialist to support me in inputting data into a database. This is a work-from-home position that will require 10-20 hours per week. Key Responsibilities: - Accurately input data into a database - Verify and cross-reference data to ensure accuracy - Adhere to specified data entry guidelines and procedures The ideal candidate will have: - Advanced data entry skills, with a high level of accuracy and attention to detail - Experience with entering data into databases - Ability to handle a workload of 10-20 hours per week - Strong understanding of data entry guidelines and procedures If you have a proven track record of advanced data entry skills and are looking for a flexible work from home opportunity, I would love to hear from you.

I'm lo...develop a script that can take an image URL as input and return the OCR text response. The purpose is to extract numbers with a minimum of 4 digits from images, using only Free OCR tools. The desired output should be a JSON object. The script must support the JPEG and PNG formats. It's unclear how many digits the numbers in the images could have, so the code should be robust enough to handle variable digit lengths. Experience in optical character recognition (OCR) and handling JSON objects are crucial for this project. Specific requirements: - Python coding experience - Knowledge in OCR - Proficiency in handling JPEG and PNG formats - Experience in managing JSON objects Please see the attached images for a better understanding of the project requirements befo...

For this project, I am looking for someone to help m...store market data from Interactive Brokers API, specifically stock prices, into a MySQL database. Key requirements for the project include: - Api should be in either js or python - Experience with Interactive Brokers API: The freelancer should have a solid understanding of retrieving data from this particular API. - Proficiency in managing MySQL databases: As the goal is to store data in a MySQL database, experience in this area is a must. - Understanding of market data and stock prices would be beneficial to align the project goals and outcome successfully. I look forward to working with a dedicated professional who can seamlessly bridge the gap between the Interactive Brokers API and my MySQL database with ac...

I'm seeking a Google Sheets expert to assist me with creating a dynamic client database with a functional search button and also save and modify button . Key tasks will include data analysis, spreadsheet automation, and formula creation. The database needs to store specific information like client name, accountant name, bank names, and sort, amongst others. Ideal freelancers should have extensive experience in Google Sheets with a knack for complex formula creation and automation. Strong data analysis skills will also be useful for this project. Familiarity with creating searchable databases is highly desired.

I have a project that involves entering textual data from physical documents into a database we are creating. Key details: - The data is textual in nature and will be provided to you in physical document form. You will need to accurately transcribe this information into our database. - The primary goal of this project is to create this database. Ideal skills and experience: - Strong attention to detail is critical for this project as accuracy is a key requirement. - Previous experience with data entry is preferred, especially when working with physical documents. - Familiarity with database software would be a bonus, although not necessary. - Excellent organisational and time management skills to ensure the project is completed efficiently.

Project Overview: We are seeking a skilled website developer to create an intuitive and user-friendly platform designed to serve as a comprehensive database for fresh produce suppliers. This platform will enable customers to efficiently locate and interact with suppliers, focusing on ease of use and accessibility. The map functionality is a core feature, as it will assist users in finding geographically proximate suppliers. Key Functionalities: 1. Keyword Search: - Enable a basic keyword search to help users identify suppliers using specific terms. - Integrate auto-suggestions to enhance the user experience by providing potential matches as the user types. 2. Advanced Search Filters: - Develop advanced filtering options to refine searches based on various parameters lik...

I have a big PDF and website data that I need to consolidate into a single Exce...to make this work. Key Points: - The data is spread across a large PDF and a website, and I need it all extracted and combined into a single Excel spreadsheet. - I need product decision, finish, list price, cast Qty, Master Qty, weight, length, and similar details extracted from both sources. - The extracted data should be organized in the Excel spreadsheet with each data point in a separate column. Ideal Skills and Experience: - Proficiency in data extraction and consolidation from PDFs and websites. - Experience in Excel and its advanced functions to organize data efficiently. - Strong analytical skills to help with product decision-making. - Prior experience in similar projects would be a bonus. ...

**Project Description: Database Creation with GPT Assistance in Excel** **Overview:** The aim of this project is to leverage the capabilities of OpenAI's GPT (Generative Pre-trained Transformer) model to assist in the creation of a comprehensive database using Microsoft Excel. The database will serve as a centralized repository of structured information, facilitating efficient data management and analysis. **Objectives:** 1. Develop a structured database architecture suitable for the organization's requirements. 2. Utilize GPT to automate data entry, validation, and enhancement processes. 3. Ensure data integrity, accuracy, and consistency throughout the database. 4. Enable seamless data retrieval and reporting functionalities. 5. Facilitate c...

...with the process of creating a proper pipeline for machine learning and, for any model deployed, having a reliable estimate of its performance. Although, some effort should go into improving an initial model. How many datasets do you need? - Groups of 2 need **two** datasets - Group of 3 needs **three** datasets **Database** After the data has been collected and processed, it should be stored in a SQLite database. At a minimum, each dataset should have its own table. Database and table creation and data insertion can be done either with the `sqlite3` package or with `Pandas`. Both SQLite and `sqlite3` come with Python. **Machine Learning Models** For each dataset you should train, evaluate, and save a machine learning model: - one model should be for a *cla...

I'm in need of a professional who can scrape specific data from a website onto an Excel spreadsheet. The requirement is to list information in a table format. Key Requirements: - Scraping of content descriptions from the website - Transferring the extracted data into an Excel database The data should be organized in a clear and structured manner, following the format I will provide.

I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.

Hello, I need you to build an app that will show 1 article per day (all users see the same article) to all the users (article: image, title, text content, category, number of likes) + users need to be able to browse the previously shown articles. I need to be able to add new articles without resetting the current order of articles (basically, add to the list). Users can like the article, and the app will show the total number of likes of the article. The app will be localised in 3 languages (I have all 3 language versions of articles; you must set up the database system). I also need you to suggest and implement transitions and animations between screens and when browsing between articles. And since I would like to upload the app to the App Store, I need you to h...

...facing is related to database interactions. I use 2 types of phones: samsung s4 gt-i9505 and samsung s4 gt-i9515. They should be identical, but the application running on gt-i9505 phones frequently gives this error: ": server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request." I need someone to help me debugging this error as the application can't be shared. I appreciate that this isn't a high-urgency task, so you'll have some flexibility with timing. However, it's important to me that the issues are resolved effectively and efficiently. Ideal skills and experience for this project include: - Proficiency in Django development - Strong understanding of database...

I'm looking for a proficient Data Entry Expert for online database management on MySQL. Your tasks will involve entering and managing data in the MySQL database effectively and efficiently. Key Requirements: - Must possess strong online data entry skills. - Should have experience in working with MySQL. - Familiarity with structured form data is essential. - Attention to detail to ensure data accuracy. - Strong organizational skills to manage and track data in a large-scale database. Your responsibility will be to keep the database updated. This project requires an efficient individual who can deliver accurate work within the stipulated timeline. If you think you're suited for this job, let's connect.

...up and configure a MySQL database with Oracle APEX. The main purpose of this setup is to manage and retrieve product inventory and sales transaction data. Key tasks include: - Designing the database to efficiently handle product inventory and sales transactions. This involves creating an Entity-Relationship Diagram (ERD), and writing Database Definition Language (DDL) and Manipulation Language (DML) statements. - Configuring the Oracle APEX environment to interact with the MySQL database and ensure smooth data retrieval and management. - Ensuring the system is secure, ensuring no unauthorized access to the database. - Providing a high-level overview of the system's architecture and functionality. Skills and experience required: - Strong expertis...

I need a Django professional to manage a sensitive task involving the masking of our project's database. Your primary role will entail implementing encryption on our data. Key Responsibilities: - Generate an encryption key. You’ll be responsible for creating a robust and secure encryption key. - Implement Database Encryption. Utilise your Django expertise to seamlessly integrate encryption without compromising the performance or accessibility of our database. - Maintain Data Format. It is critical that the encrypted data retains its original format. Ensure that no distortions occur during this process. Ideal Skills: - Proficient in Django - Knowledgeable in database structures and encryption - Proven ability to generate secure encryption keys - Exp...

Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, ...time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what S...