한국어 단어를 태국어, 네덜란드어, 유대어, 영어, 포르투갈어 등 다양한 언어로 변환할 수 있는 창의적인 마인드를 찾고 있습니다.
The mssql database you are currently using is slow to search You want to improve the speed of this slow search speed.
... 주문상세내용이 보였으면 합니다. 그리고, 원격 Database 접속정보와 관련된 쿼리는 아래와 같습니다. OS는 windows 2012 , 데이터베이스는 MS-sql이고, 원격주소, 계정, 암호는 실제 내용을 알려드릴 수 없는 점 양해바랍니다. 현재 디비접속은 이런 형식으로 하고 있습니다. -> ,1000 (사이트주소,포트번호) , 계정 : Testaccount , 암호 : Test 입니다. 금액 쿼리 : Select replace(convert(varchar, cast(Isnull(Sum(Ori_price*qty),0) as money),1),'.00','') as Orderamt from Orderdetail where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 금액은 붉은 색 글씨로 표시되었으면 합니다. 주문 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='N' 미배송 건수 : Select count(Order_id) from Orders where Convert(Varchar(8), Order_date,112) = '달력 일자' and DelYN='...
scrape data from darty site and export it into excel file.
I'm seeking an experienced data scientist to work on a project to integrate datasets from CSV files with different features, and feed them into various ML algorithms. The primary objective of this analysis will be to classify the data into different categories. The end goal is to determine the efficiency of the different ML algorithms used, which are decision tree, random forest, extra trees, and XGBoost. The perfect candidate for this project would be someone with a solid background in data science, particularly with experience in working with datasets from CSV files and implementing machine learning algorithms. The candidate should also be able to interpret and present results through visualizations such as charts and graphs.
I'm looking for an Android developer to enhance my app to support zip and rar files. The functionality should include: - Support for both zip and rar files - Support for both password-protected and standard files - Ability for users to extract files - Ability for users to view file contents The ideal candidate should have experience in Android app development, specifically dealing with file handling and storage. Knowledge of third-party libraries for handling zip and rar files is a plus. The developer should also be comfortable with implementing password protection mechanisms. Please note that the app is already built, so the task would primarily involve adding the requested functionality.
There is a website that I do not have access to the hosting and I just need an embedded video extracted from it and saved as an MP4 file. Let me know if this is something you can do, looking to get it done now within the hour.
I'm seeking a highly skilled Power BI professional to assist with creating interactive dashboards and generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experien...
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 u...
...strong attention to detail to perform data entry into my database. The data to be entered is text-based and extracted from various sources which may have distinct formats. Below are specifics about the job: - Handling Text Data: The job will entail entering a variety of text data into the designated database. - Format Diversity: The data comes from diverse sources, so it does not adhere to a specific format. The ideal candidate must be adaptable in handling different data formats. - Correcting Discrepancies: The freelancer will need to spot and correct discrepancies or inconsistencies within the data sources. Accuracy and keenness to details will be crucial. Ideal Skills: - Proficient in data entry - Strong att...
I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.
I need financial data from bloomberg or any other database for research.
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...
...user-friendly shopping cart integration is crucial for this project. The cart should allow for addition of items, editing of quantities, and a smooth checkout experience. - User Registration and Login: The website should have a user registration and login system. This will help in personalizing user experiences, managing orders, and providing security to customers. - Product Search and Filter: A crucial feature for an e-commerce site. It should enable customers to easily find products they are interested in, through categories, filters, and search functionality. Payment Gateway Integration: I have the following specific payment gateways in mind for this project: - PayPal: A widely used payment gateway that provides flexibility in payment options and offers a trusted payme...
...this is all to be done on a new Linux STAGING ONLY server. 1) Linux staging server setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need par...
...PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and work PROFICIENTLY with gi...
I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry
I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.
...for a skilled developer to help integrate the DropzoneJS library into my project in full. I have integrated demo vesrion only. The primary goal is to improve the user experience by allowing for drag and drop functionality for file uploads. Key Requirements: - Implementation of drag and drop functionality using DropzoneJS - Ensuring DropzoneJS supports multiple file uploads at once - Do not need integration within the existing project structure. PHP Upload script working just fine. - Adherence to best practices for user interface design and user experience Ideal Skills and Experience: - Proficiency in JavaScript and relevant libraries, particularly DropzoneJS - Proven experience with front-end development and UI/UX design - Ability to integrat...
I have a collection of 51-100 photographs that have significant damage due to aging, water, mold, cracks and tears. I am seeking a professional with advanced photo restoration skills to not only restore these images but also add color to the black and white photos in the collection. Apart from color addition, expertise in cropping and resizing is also needed. - Restoring damaged photos - Colorizing black and white photos - Cropping and resizing as necessary Experience in handling damaged photos and proficiency in using advanced photo editing tools will be ideal for this project.
Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Deliver...
Se requiere un profesional que pueda diseñar un reporte en "SQL Server Report Builder". Este reporte, será modelo factura o pedido. Ya se cuenta con la consulta, y los parámetros de consulta (Fecha, desde - hasta), y también por número de documento (Desde - hasta).
I want to design a car wash, and I want to import the goods from China, but I do not know what is the method, the best quality, and the method of communication. I want boxes for electric tanks that are made of carbon fiber, I want washing materials, I want water pumps, vacuum cleaners, all cleaning tools, and some other things. Ideal Skills: - Proficiency in Chinese - Experience with online dispute resolution - Strong communication skills - Understanding of international commerce and refund procedures
Necesito generar deshboard y gráficos en Power bi desde 4 bases de datos • 1 base de dato en postgresql corporativa en aws • 1 base de datos en sqlserver en un servidor local • Google Analytics • Zendesk Son aproximadamente 50 gráficos personalizados con los que necesitamos hacer algunos dashboard de gestión. Es importante dejar documentado el trabajo y respaldadas las consultas en sql. Indispensable: • Dominio de Power BI • Experiencia previa en la creación de paneles para ejecutivos • Capacidad para integrar datos de bases de datos Indicar los accesos requeridos y los requerimientos tecnológicos para desarrollar el proyecto
I'm looking to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descriptions, and Ch...
PDF File converted to MS WORD File more than 300 pages Need ASAP
As the project owner, I'm looking to transform an image file of a 2D floor plan into a to-scale outline floor plan. For this project, the digitized floor plan should include room measurements. While I didn't specify a preferred software, utilizing a program adept at architectural design, such as AutoCAD or SketchUp, would be beneficial. The ideal freelancer would possess: - Proficiency in architectural drafting software - Experience transforming image files into digital floor plans - Attention to detail, specifically regarding accurate room measurements.
...searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solu...
I am experiencing slow query processing and management issues with large ...experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhanc...
Hi Roman, If you remember, last year you did a project for me to show the list of participants of an event to me. I want to improve on that code and add some functionality and features to it. Would you be available? We can chat about the details, but basically, this is what I want: I have an Excel file with different sheets. For example, Founders, Advisors, Announcements, and Media. I want a code similar to the previous code (of course, more complicated) to read this Excel file and show the content of each sheet in a different format (as the amount of type of information is different). I will share an example of the Excel file with you. Are you available?
I'm looking for someone experienced in running projects from GitHub repositories "" to assist me in setting up and running the demo-k6-operator project on my Mac machine. Your guidance should help me to understand how this project works, which is my primary goal. Key requirements: - Expertise in running and configuring projects from GitHub repositories on Mac machines - Solid understanding of the demo-k6-operator project - Ability to provide clear, detailed instructions and guidance for running the project on my machine - Patience and willingness to explain concepts to help me understand the project better The specific challenge we may face is that I'm using a Mac CPU that is NOT Intel, so experience with this ki...
Need to copy a powerpoint presentation from a video all the slides theres about 30-40 slides some just images and some some text
...need a skilled Wordpress expert to address a migration issue I'm facing with my website. Here's what I need: - **Migration Issue:** The problem I'm experiencing is related to theme and plugin compatibility following the migration from a server running PHP 7.2.4 where the site worked to a server running PHP 8.2. The front end of the site works but now access to the back end gives the error "There has been a critical error on this website. Learn more about troubleshooting WordPress." I need someone to correct the code so that it works correctly. I believe that the issue may be connected to WPBakery To excel in this project, you should be highly experienced in Wordpress, with a deep understanding of PHP...
I'm looking for a skilled professional to create a Web Assembly prototype, , using a small Delphi application that primarily showcases an interactive user interface. The aim is to target the prototype for web browsers. Key Requirements: - Creation of a Web Assembly prototype utilizing a Delphi application. - Focus on showcasing a simple interactive user interface The Prototype: - The user interface for the prototype is envisioned to be simple, consisting of basic elements. - The primary focus should be on the seamless integration of the Delphi application's functionality into a web browser environment.
The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL tab...
...currently in need of a professional who can assist in completing a database for over +14000 companies. The goal of this project is to generate high-quality sales leads. Key Project Details: - You will be required to include accurate and up-to-date contact information including phone numbers and email addresses. - In addition to the contact details, each company's key contact person's name must also be included in the database. The ideal freelancer for this project will have: - Prior experience with database generation and management. - Proficiency in data mining and web scraping techniques. - Exceptional attention to detail to ensure accuracy of information. - Proven track record in generating sales leads through...
I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency i...
I'm looking for an expert to take the text from my Word document and incorporate it into my Canva slides. The slides are for a presentation, so it's crucial that the information is presented clearly and with a professional touch. Key Tasks: - Transferring text from a Word document to Canva slides - Ensuring all text is appropriately sized, formatted and positioned within each slide - Adapting the text to fit the existing layout and design of the slides - Keeping the information clear and engaging for a presentation audience Ideal Skills and Experience: - Proficiency with Canva - Excellent attention to detail - Prior experience with creating or modifying presentations - Ability to adapt existing layouts to fit new content ...
...Specialist: The Data Specialist is responsible for providing information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, wome...
...professional to assist me in setting up a Local Area Network (LAN) with the primary purpose of facilitating easy file sharing among a small number of devices, specifically less than 10. Key requirements: - Establish a Local Area Network: The main goal of the project is to set up a local network that ensures a seamless connection among the devices for file sharing purpose. - Secure File Sharing: The network should be configured in a way that file sharing is secure and only accessible to the authorized devices. - Minimal Device Connectivity: As the network is intended for a small group of less than 10 devices, the setup should be simple and efficient without compromising security. Ideal Skills: - Networking Expertise: A deep understanding...
Hello, I need a quick fix for my DNS server running on a 2012 R2 system. The major problem encountered is that I'm unable to access my shared files. However, I can ping the IP addresses of the devices hosting these shared files. An RPC Error is shown and some Group Policy issues occur when trying to access these files. • I need someone who understands DNS thoroughly. • Experience with Server 2012 R2 is necessary. • Knowledge of RPC errors and Group Policy is required. Would appreciate quick and effective troubleshooting. Thank you!
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 - Pr...
I need a Python developer to create a tool for me that can convert different file formats. Although I did not specify the particular formats, I am looking to convert at least two different formats. The tool should have a user-friendly interface and be able to handle these conversions seamlessly. Ideal skills and experience for this job include: - Proficiency in Python - Experience in creating file conversion tools - Knowledge of different file formats - Strong problem-solving skills - Ability to create a user-friendly interface - Understanding of data handling and manipulation Complete details will be provided to shortlisted candidates.
I'm ...and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-based independent developers. If you meet the requirements and are able to take active part in client...
- Size: 36" high by 48" wide - Plotting and vector cut line - 2 files one with dimensions displayed other with artwork and cut contour lines. - Should be able to change color of each element in file with just click and fill. - Text if there should be editable (words, font and color)
I need someone who knows about monorepo and angular , the application was in angular 10 and I transferred it to angular 17 (dependencies, code, etc.) now it seems to compile but it throws an error NG0908 .I just need them to make me work (run well in ngserve). Please write ragnar to see you read the post.
have anyone can help me to install the Laravel system which buy from themeforest, thanks i will provide the domain and also the login of the hosting, thanks
I'm seeking a data operator skilled in the analysis and visualization of numerical data. The primary task is to handle the numerical data in my CSV file. Key responsibilities include: - Data Analysis: You'll be responsible for performing thorough data analysis on the numerical figures in the file. - Data Visualization: In addition to the analysis, I need engaging visualizations of the data to be created. This will help to communicate the insights effectively. Specific tasks I need help with include: - Descriptive Statistics: You should be able to calculate and present descriptive statistics for the data. - Trend Analysis: You'll also need to identify and represent any trends present in the numerical values. Ideal ...
...belong to, and the training they have attended. 1. "Employee": They are characterized by: name: The employee's last name. first_name: The employee's first name. date_of_birth: The employee's date of birth. position: The position held by the employee. establishment: The establishment where the employee works. hire_date: The date the employee was hired. contract_type: The type of contract. seniority: The seniority. 2. "Group": They are characterized by: group_name: The name of the group. group_selection_criteria: The selection criteria of the group. 3. "Training": Each training is characterized by: name: The name of the training. description: A description of the training. start_date: The start date of the training. end_date: The end d...
