Pemrograman Database Jobs

looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site Tools -> MySQL...

I'm seeking a skilled developer to create a script that can download the complete list of sanctions data from OpenSanctions database. Once the data is obtained, the script needs to perform a comprehensive database search, identify any country-specific sanctions, and provide a detailed report of these connections as well as a option to show a visual mapping. Key Requirements: - Download the complete list of sanctions data from Open Sanctions database - Conduct a thorough database search to identify country-specific sanctions - Create a report summarizing the identified connections The final report should be in an interactive web page format. The visualization should be clear and easy to comprehend, allowing for an intuitive exploration of the connections found. Ideal Skills & E...

I require an expert in MS Access and Visual Basic programming to design a user-friendly form input interface for my project. - This interface should be intuitive and be capable of capturing and effectively managing predominantly text data. - Familiarity with database systems and strong understanding of user interface design principles will be extremely advantageous. - I'm looking for someone who can deliver quality work promptly. Demonstrative past experience in similar tasks will be highly advantageous.

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I need a proficient database developer (PHP Developer) to create a specialized system for my dental equipment repair company. The database will cater to a sizeable clientele of 5000 customers. The details to be incorporated include: * Equipment type (X-ray machines, Dental chairs, Autoclaves) * Maintenance history * Customer details (Clinic name, number, email address etc.) In order to succeed in this project, you should have: * Strong database creation skills with the ability to account for our unique needs * Experience in the healthcare sector, specifically knowledge of dental equipment * Excellent problem solving and critical thinking skills for effective database design * Understanding of confidentiality requirements given the sensitive nature of the customer data This system wi...

I need a desktop application that can carefully monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigat...

I'm seeking a proficient Access Database designer to build an advanced and fully functional task management system. Key Features: - Data Entry Forms: These should be user-friendly and designed for efficiency. - Reporting and Analysis Tools: I need to be able to easily track productivity and analyze task-related metrics. - Data Validation Rules: The system needs to ensure the accuracy of inputted data with stringent validation rules. Structure: The database should consist of 5-10 interlinked tables for comprehensive task tracking and management. Ideal skills and experience for this job would include: - Extensive experience with Access database design, specifically around task management systems. - Strong ability to translate user needs into functional system features. - An understa...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consoli...

I am seeking a developer experienced in Apache NiFi to create a workflow pipeline. This will involve converting and integrating data into MySQL. Key Requirements: - Proficiency in Apache NiFi: You must have a solid understanding of the platform to develop efficient and reliable data conversion workflows. - MySQL Integration: Experience in integrating data with MySQL is essential. - Data Conversion: You will be responsible for converting the data - previous experience in this area is highly desirable. Please note the following: - The type and source of data to be converted is not yet defined. - The triggering mechanism and frequency of workflow runs are also pending. Ideal Skills: - Proficient in Apache NiFi - Strong MySQL Integration skills - Previous experience in data conversion Your...

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Proven track record in ...

I need a Student Information Management System developed with SharePoint and PowerApps. This will be a comprehensive tool for tracking attendance, storing documents, and managing information from contact details to medical records. Key components should include: **Attendance Tracking** - The system should enable manual entry by teachers. **Student Profiles** - Each student should have an individual profile displaying personal details, contact information and medical details. - Student details and parent details will be collected using Office 365 Forms and the replies should write directly into the student management system. **Document Storage** - A document storage section is required for maintaining relevant records and resources. Including student documents like passports, reports, ...

I have an existing design of a hospital with roles etc. i want some improvem ents and an interface with and write a report I will sned you analytical details in chat deadline 21/5 budget $60 USD

I'm looking for a Power BI expert to create a dashboard primarily for our executive team. - The main goal of this project is to create a visually appealing and easy-to-understand dashboard. - The dashboard should be tailored to the needs of executives, providing them with the key information they require at a glance. - Database of 2,000 cases and 11,090 variables Ideal skills and experience for this job: - Proficiency in Power BI - Previous experience in creating dashboards for executives - Great data visualization skills - Ability to integrate data from databases The successful freelancer will have a good understanding of what makes a dashboard not only visually appealing but also functional for high-level decision-makers. Your experience in data integration and visualization...

I need an expert to pull data from my MySQL database, specifically from the Customers and Orders tables, and send it to a Slack channel in a unified message. The data includes text, numeric, and date entries. Key Requirements: - Integrate MySQL data with Slack: I need the freelancer to help me integrate the data entries from the specified tables with a Slack channel. - Collide Entries: The entries from the Customers and Orders tables need to be combined into a single, coherent message. - Include Specific Fields: The message should include specific fields from the MySQL tables. These fields include Customer Name, Order ID, Order Date, Customer Phone Number, Customer User ID, Product Details, and Product Quantity. Ideal Skills and Experience: - Proficient in MySQL: The ideal candidate shou...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing integration and consoli...

I have a high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintain the same output as the present T-S...

Our existing CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need this prob...

 We are seeking a highly skilled and experienced individual to fill the role of Database Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  O...

I'm searching for a developer who can build an automated document verification system to simplify the document management procedure in educational institutions. The system must include the following features: - Database Integration: Integrate with MySQL, our preferred database management system, to make document retrieval and management easier. - User Authentication: I want the system to authenticate users via Single Sign-On (SSO) using existing authentication platforms like Google and Facebook. This is to ensure a secure, seamless and user-friendly sign-in process. Proficiency in MySQL, SSO Integration, and system development is required. Prior experience in document management system creation will be preferable. The ideal candidate should understand the intricacies of data secur...

BANGALORE BASED I am looking for a skilled developer to create a data management software system tailored for managing customer data and pricing. The completed software should have capabilities that allow for: * Storing and organizing formation data, pricing and customer information: It's crucial that this software can neatly organize customer profiles and information. * Custom Pricing: The system should allow for the customization of prices for each unique customer, based on specific formulation per product per customer. * Auto-Pricing: Additionally, it should have the functionality to automatically calculate prices based on predefined rules. The ideal freelancer for this project should have prior experience in developing similar software, an understanding of pricing mechanism...

I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. We will looking for a ready application something more or less similar to our requirement. A existing pre developed application. Wherein customization can be done. Key Modules Required: - Quotation - Purchase - Project Management - Materials Management - Stock/Inventory - Billing - Accounts - Reports - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system sh...

I'm seeking a FileMaker Pro expert to modify the existing project database for our small architecture firm. Your main tasks include: - Rectifying existing bugs - Enhancing reporting capacity - Introducing new mapping features, if possible. Some issues have been detected in the current system with features not working properly, particularly in the reporting capacity. A new mapping feature is optional and can be discussed further. There isn't a strict time frame for project completion, but I'm hoping to get it done as soon as possible. Ideally, the applicant should have a strong background in FileMaker, bug fixing and data mapping.

I'm in need of an entry-level freelancer to handle a variety of back-office tasks, including data entry and management, as well as customer service and support. Requirements: - The ideal candidate should have a basic understanding of data entry and management, as well as customer service principles. - Proficiency in using custom database software is a must. Responsibilities: - Accurate and timely data entry to maintain database integrity. - Providing necessary customer support and service responses. I'm looking for someone who is organized, detail-oriented, and can work efficiently. While experience in back-office work is preferred, I'm open to new freelancers who are eager to learn and grow in this role.

VeriCO2 is looking for a talented developer to assist in populating our global scope 1, 2, and 3 emissions database through web scraping and data moderation. The selected developer will be responsible for scraping emissions data from global listed companies, implementing a moderation system, and enhancing our current offering by providing a database of published emissions data for ASX companies. Responsibilities: 1. Web Scraping - Web scrape scope 1, 2, and 3 data points from global listed companies to populate the VeriCO2 emissions database initially. - Develop scripts or tools to automate the web scraping process and ensure efficient data collection. 2. Data Moderation - Implement a moderation check to review and update data points based on user feedback and VeriCO2's own data col...

VeriCO2 is seeking an experienced developer to create a global scope 1, 2, and 3 emissions database as part of our automated quantification of scope 3 emissions project. The selected developer will be responsible for setting up the database, developing a user contribution system, and implementing security measures to ensure data integrity. Responsibilities: 1. Database Setup - Set up a database to store scope 1, 2, and 3 emissions data for global listed companies. 2. User Contribution System - Develop a system for users to contribute data via LinkedIn by signing up and providing their company's scope 1, 2, and/or 3 emissions. - Implement a security check to ensure the user's email domain matches the company name and send a verification email. - Allow users to download ...

I need a proficient developer to design a control panel that will be used for monitoring, reporting and controlling a variety of devices. Key Features: - User management: The panel should be capable of handling multiple users with differing levels of access. - Data visualization: The user interface design should prioritize clarity and accessibility, allowing users to easily interpret and interact with device data. - Control device settings: The panel should provide control over the settings of various devices. Specific Device: - The control panel will specifically be used to control and oversee settings for a ride. Ideal Skills: - Proficiency in creating interactive interfaces. - Experience in developing user management systems. - Prior experience working with control panels and device...

I'm looking for a skilled freelancer to help me in creating a database of entry-level IT working professionals. The database is intended for recruitment purposes and should focus on professionals within our country. Key responsibilities will include: - Identifying and collecting database of entry-level IT professionals. - Categorizing the database based on different IT fields like software development, cyber security, network engineering, etc. Ideal candidates for this project should have experience in: - Database creation and management - IT recruitment - Strong knowledge of the local IT job market Your work will be critical to our hiring processes and future IT recruitment strategies.

I'm seeking assistance in incorporating 2D Data Matrix barcodes within both BI Publisher and Oracle EBS. The primary goal of this integration is to enhance our current inventory tracking systems by printing the Labels with 2D barcode and business users can scan the barcode by using the RF scanner in the inventory. This project should be relatively straightforward for someone who is proficient with BI Publisher, Oracle EBS, and barcode implementation technologies. Key requirements and considerations include: - Proficiency in both BI Publisher and Oracle EBS - Strong understanding of 2D Data Matrix barcodes - Proven experience in integrating barcodes into inventory management systems The successful candidate will be able to not only implement the barcode system but also provide us wit...

I'm looking for a skilled individual who can help me scrape data from a dead mobile app (has both ios and android versions). The database of the app is of particular interest, however, I am not sure of the specifics such as the Database Management System (DBMS) it uses. Key Points: - Extracting data from the database of a defunct mobile app - Unspecified Database Management System (DBMS) - will require exploration and identification Ideal Skills and Experience: - Proficiency in data scraping and extraction - Strong background in database management and familiar with multiple DBMS - Resourcefulness and ability to work with minimal information Please get in touch if you're confident in your abilities to handle this task.

I'm in need of a database designed to organaize companies for Italian regions the data are not well organized, there are 927 companies with different address and region and they need to be divided by north west, north , north east etc - - Customer Information Management: The database should be structured in such a way that it allows categorizing companies according to their respective regions. Ideal freelancers for this job should possess robust skills in database design and management. A keen understanding of categorizing/mapping data based on geographical regions will be considered a huge advantage. Efficient, accurate, and secure data manipulation and storage is essential for this project.

I am seeking a developer to create an online database/sales tracking/CRM system from an existing Access database Key Features: - online access. - mirror the look and ease of use of existing access database. - import existing data in new database

I'm in search of a PHP Developer with a proven track record of developing comprehensive ERP Solutions for the construction industry. Key Modules Required: - Project Management - Cost Estimation - Procurement Specific Features for Project Management: - Task Management: The system should allow for easy task assignment and monitoring. - Resource Allocation: It should have a robust system for allocating and tracking resources. Specific Requirements for Cost Estimation: - Integrated Cost Database: The system should have a vast and well-organized cost database. - Calculation Formulas: It should accommodate complex estimation formulas. - Reporting and Analytics: The ability to generate detailed reports and analytics is crucial. Ideal Candidate: - Should have a strong background in PHP ...

I'm looking for a skilled Python backend developer to enhance an existing backend system for my project. Key Responsibilities: - Enhancing the existing backend system: Your primary responsibility is to enhance the functionality of the current system and optimize its performance. - Integrating SQL/NoSQL Databases: Your expertise in SQL/NoSQL databases is crucial to ensure smooth integration and efficient data handling. - Experience with Python and Minio: If you're familiar with Minio that's a big plus, but Python is the key language you'll be working with on this project. Ideal Candidate: - Proven experience in enhancing existing backend systems. - Proficient in working with SQL/NoSQL Databases and designing queries. - Strong Python skills are a must. - Experience wit...

I'm in need of a system that efficiently and accurately captures and records detailed customer policy information. Key information to gather includes: - Policy Information - Policy Type - Effective Date - Expiration Date - Premium - Carrier Company This information will help us keep accurate records, keep track of expiration dates, and better understand the coverage our clients have. The ideal person for this job would have experience in CRM development, database management, and a strong understanding of data privacy and security matters. Your task will be to set up a data capture followed by populating those information into our database. Understanding of insurance company's workflow will be an added advantage.

Busco un desarrollador que pueda crear un sitio web cuya principal característica es que cuenta con un funnel page en el que (de acuerdo al target de cliente) al finalizar el registro , el usuario podrá ver una serie de ofertas personalizadas para el. Este funnel page, además de contar con distintos pasos, estará conectado con CRM de cliente via API. Por lo que ideal si sabes de implementación via API. Debido a que capto usuarios, necesito recomendaciones de buenos sistemas para la base de datos que construiré, acepto recomendaciones.

I'm in need of an experienced Talend Studio developer to assist with a database migration project. Key Project Details: - **Data Sources**: The project entails integrating data from various databases. - **Primary Goal**: The primary focus of the project is to migrate the data accurately and efficiently. - **Data Processing**: The data migration will primarily be through batch processing, therefore real-time processing is not required. Desired Skills: - **Talend Studio Proficiency**: A strong understanding of Talend Studio and its capabilities is essential for successful project completion. - **Database Integration Skills**: Experience working with database integration is a must. - **Data Migration Experience**: Previous experience with data migration projects will be highly valued....

My bakery is now in it's fourth generation of ownership. My Dad started using a database program called Formula Coster on his Apple IIc to figure out how to correctly price our baked goods based on ingredient costs, labor costs, overhead, etc. The program also allows us to store the formulas and makeup instructions for all our products based on the dough batch and individual pieces from the dough. It's a simple program that we still use today, but are afraid it may not continue to work very long. Other programs exist, but are all cloud based and require subscriptions with features we do not need. I am seeking an adept database developer to either continue work on an in-progress database or commence anew based on existing requirements. This database is intended for exclusive us...

Ordering and invoicing system We would like to have an ordering and invoicing program programmed. This is intended to be used online by various users on a web basis. To do this, roles must be created. One or more admin roles that are allowed to do everything. There is also the User role. This role should only be allowed to print and send orders. There should also be the role of field sales representative. This role can deliver products directly to the customer site. There is also the role of the inside sales representative. More on this later. The software should be hosted by a web host. Our customers send orders electronically in EDIFACT format. These orders contain an order number, different delivery points, each of which has its own GLN (customer number), different items and the q...

Dovrei creare un programma che possa automatizzare delle operazioni da impostare su dei lettori multimediali che vengono riprodotti su un browser. Italian speak only please.

I require a proficient data entry specialist to efficiently input data into my SQLite database from a set of online forms. TASKS TO BE ACCOMPLISHED: - Accurate data entry from 11-20 online forms - Seamless SQLite database integration and management NECESSARY SKILLS: - Extensive experience with SQLite - Excellent data entry skills - Prior experience with online forms - Detail-oriented and precision in data handling. Your ability to complete this task accurately and timely will be crucial to the successful execution of this project.

I'm in need of a professional and corporate designed IT recruitment website that's fully functional and user-friendly. Key Functionalities: - Job postings and applications - Resume database search - Candidate matching algorithm - Candidate registration - Candidate applying for Jobs - Employers registration and Posting Jobs - Integration with email client I aim to get this project completed within a month. The ideal freelancer for this job should have experience in: - Web development - UI/UX design - Database management - Email integration - Preferably prior experience in recruitment websites Please provide a ballpark estimate and a brief outline of how you'd approach this project in your bid. Looking forward to working with you.

I'm looking to develop a Microsoft Access database to manage and print cage cards for laboratory mice from an existing Excel file. The Excel includes columns like Cage ID, Strain, Sex, Age, Mouse ID, and Notes, among others. Each card should group mice by their Cage ID and include relevant details such as Strain, Mouse ID, Sex, and Requirements:Database Development: Create a database from the Excel Card Design: Design printable cards with the listed Functionality: Enable direct printing from Interface: Simple UI for selecting and printing cage provide a quote and timeline for this project, along with any similar work you've done.

I'm in need of an expert in Machine Learning who can successfully build a Language Model for me. Train this LLM on data that I'll provide. The key specifics about the project involve: - Data Handling: My data currently lies in PDF format. Therefore, you need to be proficient in working with PDF data and possibly transforming it for the training process. - Database Knowledge: The data is stored in a MySQL database. You must have experience working with MySQL databases and effectively extracting data from them. - Document Types: This project solely revolves around PDF documents. I require somebody with a proven track record of handling and working with PDF data. Skills required: Machine Learning, MySQL, knowledge of handling PDF data and documents.

Quiero una aplicación para celular que pueda dar el resultado de cuanto cuesta y cuantos paneles necesita el cliente basado en información que el mismo cliente ingrese a través de un PDF de su recibo de luz, la aplicación tendrá que buscar valores en el pdf y despues esos datos ponerlos en formulas específicas. The input will be the PDF format of a bill utility, and the output will be the cost in mexican pesos and the amount of solar panels.

I'm looking for skillful developers to create a currency exchange system, specifically for the United States Dollar (USD). The system must: - Display Live currency rates - Facilitate Secure transactions - Enable creation of User accounts Experience in financial software development and an understanding of online banking services would be beneficial for this project. Knowledge of secure payment gateways is crucial to ensure secure transactions within the system. Proficiency in developing dynamic and user-friendly interfaces is essential for the user accounts' feature. Your expertise will help us deliver a reliable and secure platform for currency exchange. Se requiere un sistema de escritorio que realice la funcion de cambio de dolares en JAVA con conexion a base de datos mysql...