Import csv table sybase sql query jobs
I have the SQL file and main images of my current Wordpress site, and am looking for a professional to migrate and set it up on the new hosting account. We have the hosting account set up and will share the files with a dropbox link. Key Requirements: - Migrate current Wordpress site to a new hosting account - Setup and configure Wordpress in the new hosting environment - Ensure all site functionalities are working post migration - Provide login credentials for the access to Wordpress Please note: - There are no custom changes or updates needed during the migration - The new hosting environment is fully compatible with Wordpress Ideal Skills: - Proficient in Wordpress migration and setup - Knowledgeable in SQL databases and file handling - Experience in configuring hostin...
As the developer of an existing project written in Python, SQL Server, and MongoDB, I am currently facing a challenge. A logical error in the code is causing a bug, and I need an expert to fix it. High-level summary of the code- 1. Fetch records from SQL server ( total 680000 records) 2. Apply face recognition on each record 3. Insert the response from step 2 in MongoDB along with other data from the SQL server Issue- The existing code is currently doing steps 1 & 2 and performing step 3 at last when face recognition is applied on all records. Due to this it step 3 is waiting to complete the step 1 & 2. Expectation- After fetching each record from SQL server, the code should apply face recognition and then store the data in MongoDB immediately. I wil...
I'm looking for a skilled WordPress developer to assist me in creating a custom, multipage form using Contact Form 7. This form will have a unique require...address - Stored in a specific page inside WordPress dashboard, already configured Furthermore, I require the setup of an export mechanism for this incomplete data, specifically in a CSV format. This CSV should: - Have separate columns for each field to ensure easy data processing - Include timestamps for each form submission for traceability and analysis. The ideal candidate should be proficient in WordPress development, especially with Contact Form 7 plugin integration. Experience in setting up and managing multipage logic for forms is a plus. Additionally, knowledge of data handling and export in CSV ...
...objectives are: Optimal candidates should possess: - Strong writing and editing skills - A knack for structuring information effectively - The ability to create engaging and clear content however, no Chatgpt , no google Bard/Gemini, or any other AI tool. Cybersecurity CIA Analysis (2019-Present) Need in-depth analysis of CIA triad in recent research? 5 IEEE papers (2019-present) Comparative table with key insights âš¡ Fast, expert research & delivery Order now & unlock cybersecurity knowledge! Tags: cybersecurity, research, CIA, IEEE, analysis, comparison - Identifying potential vulnerabilities in multiple IoT in smart city systems - Analyzing existing cybersecurity measures - Proposing enhanced security solutions The ideal candidate will understand Security Ch...
...documentation. We need a checkout option for Zelle and for Cashapp. These will be seamless just like checking out with credit card. The customer will select one of the two options and then they will be prompted to login to their account to complete the payment then upon successful payment they will be reverted to the payment success screen. Additionally you will add a field into the product category table and to the product add/edit pages in the admin panel for payment options allowed. Certain product categories can be paid with credit card whereas the others cannot. So something like cc_allowed and the answer would be y or n. Upon the options in the checkout if cc not allowed then this option won’t be available to the customer. You will do the above mentioned functional...
As a business user, I need assistance with the configuration of SS...WebPortal using Report Server Configuration manager and I am able to run SSRS reports from the Web UI. The project requires the following: 1. Automatically Scheduling of SSRS reports with default parameters. 2. Exporting the outcome of SSRS reports in a given folder every time a scheduled report runs I am experiencing the following issue while scheduling: Error: The SQL Agent service is not running. This operation requires the SQL Agent Service. You will need to help get rid of this error and set up scheduling and exporting of reports as mentioned. You will be required to get on a video call and help me set up the above over the call since this is a secured environment. Also, this needs to be executed...
...business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to collaborate...
...three different algorithms for matching a resume with jobs on the website. They are coded in python. You have to create the APIs for webapplication. Then you create the Website which has 2 user types. Job Seeker and Employer. Login to use (home page) Job seeker will upload their resume details using a fixed form. Employer can post as many jobs using an upload job form. The data is stored in a table. On clicking the Find Jobs button (after uploading resume) or Find Profiles (for each job posting uploaded) the results page will show the ranked results (either job or resume depending on user). Home Page - Login SignUp buttons only...no design or banner or random stuff. Profile Page - Form Filling page with resume details. Resume Form Page Job Description Page Simple Dashboard...
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product inventory. Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results...
...for the Snipepay Payment Plugin: WooCommerce Integration: Develop a payment plugin to integrate Snipepay into WooCommerce, allowing users to choose Snipepay along with existing options like PayPal and GoUrl for payments. Deliverables: A fully functional WordPress plugin for hosting management. A Snipepay payment gateway plugin for WooCommerce. Skills Required: Proficient in PHP, JavaScript, and SQL. Experience with WordPress and WooCommerce plugin development. Strong understanding of RESTful API integration. Knowledge in payment gateway integration, specifically Snipepay, PayPal, and GoUrl. Excellent problem-solving skills and attention to detail. Project Timeline: Please provide an estimated timeline for completion with your bid. Budget: Your bid should include the total cos...
Hi Yasar W., I noticed you posted a following project ( https://www.freelancer.com/projects/sql/SQL-Expert-Needed-for-Data/details )
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal...Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migratio...
I need an expert API developer to create a functional, reliable API for automating table reservations and event bookings on my website, integrating with Tabology. The task involves: - Understanding the existing booking system on the site - Defining specific automation processes for table reservations and event bookings - Integrating these processes with Tabology to enhance efficiency and usability A successful freelancer for this project should demonstrate significant experience with API development and have a deep understanding of booking system operations. Familiarity with Tabology integration will definitely be an added advantage.
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
...in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an outline of the tasks Script to Parse XML for Nightly Update: This script will run once a night to parse a large XML file provided by the content provider. It will update, add, or remove relevant data in the PrestaShop facet search database tables. The script should be optimized to avoid system slowdowns and long processing...
...Management**: This entails handling all incoming emails from customers. The goal is to ensure timely and accurate responses, maintaining high quality customer service standards. - **Data Entry and Organization**: You would be responsible for entering and organizing data within our Shopify platform. This would include product information, customer details, and other pertinent data. - **Customer Query Resolution**: Addressing customer queries in a professional, friendly and efficient manner is crucial. You would need to have good problem-solving skills. **Daily Volume**: The expected volume of emails and queries to be handled on a daily basis typically falls within the range of 50-100. It's important to maintain a quick turnaround time while ensuring accuracy. The ideal ca...
I am looking for a professional logo designer who has a keen eye for creating engaging and dynamic logos. You need to be a creative thinker who can bring fresh new ideas to the table as I do not have a specific concept in mind. Key Responsibilities: - Creating an innovative and captivating logo design - Being open to feedback and willing to make adjustments as needed Ideal Skills: - Extensive experience in logo design - Creative thinking and open-mindedness - Strong communication skills to understand design requirements and feedback I can't wait to see what unique ideas you bring!
I'm working on a film or TV production and in need of an experienced 3D artist who can help me with 3D modeling, Visual Effects (VFX), and Computer-Generated Imagery (CGI), all with a focus on creating a realistic visual theme. Key Requirements: - Proficient in 3D ...me with 3D modeling, Visual Effects (VFX), and Computer-Generated Imagery (CGI), all with a focus on creating a realistic visual theme. Key Requirements: - Proficient in 3D modeling, VFX, and CGI - Experience working with a realistic visual style - Previous work on film or TV productions is highly preferred Looking for someone who can bring creativity, technical skills, and flexibility to the table, while delivering high-quality and realistic CGI work. If you've got the right skillset and experience, I'...
I need a talented interior designer who has a knack for modern styles to revamp my home. This includes the living room, kitchen and bedroom. Creativity and originality are crucial; I'm looking for someone to bring fresh, innovative ideas to the table. Experience And Skills: - Understanding of modern interior design elements. - Previous work on residential homes. - Ability to turn visions into reality. - A portfolio showcasing previous design work. The aim of this project is to transform these rooms into efficient, aesthetically pleasing spaces. If you understand the subtleties of modern design and can apply them to residential surroundings, then this project is for you.
I will do these screen design in figma they are exactly 8 screens as following: 1- login 2- home with the table of tasks 3- forget password. 4- my profile. 5- search for vehilce 6- vehicle Details. 7- taking images of vehicle (repeatable screen) 8- Milage screen
import all the data from a json to custom compis all json data must be imported
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
I need a tech-savvy freelancer to create a custom thank you p...custom thank you page for my WooCommerce website. The page should have a particular focus on: - Presenting order details effectively. These details must be displayed within a detailed table, allowing for a comprehensive overview of the purchase made. Ideal skills and experience: - Experience in programming and website development. - Familiarity with WooCommerce and creating custom pages. - A knack for clean, efficient code and attention to detail. - Knowledge in creating user-friendly, intuitive layouts and designs. Please note the client has opted not to include any interactive elements within the detailed table on the thank you page. Therefore, ensuring factual accuracy and perfect presentation of order deta...
...a strong understanding of software architecture and design patterns. - CAD Software Development: Prior experience in developing CAD software, particularly with a focus on 3D modeling, will be highly beneficial. - Windows OS: A good understanding of Windows OS and its specific requirements for software development. - File Format Handling: Experience in handling DWG files and developing import/export functionalities for CAD software. If you have relevant experience and skills in C++ development, particularly in CAD software, and can commit to creating a high-quality, Windows-compatible CAD software, I'm keen to hear from you. Extra info: I am looking at a long term contract of 1 year, renewable each year. I will conduct a written test before making offe...
I'm looking for a developer who's proficient in C#, MS SQL Server, Dot Net, and XAMARIN to work on an already existing application. Need to improvise and add amend few things. Pls note we can pay maximum INR 4,000 for the work.
...have got few virtual entity tables link to Azure SQL database. One table has got 1:M relationship with another. In my form, I am trying to populate custom view in lookup field of this virtual entity lookup. I tried it in two different ways but it doesn't work. Method 1: I created fetchXML and link two tables, I get the result but issue is records don't filter in query. I tried this method with advance find as well, and again records don't filter according to criteria for virtual entity. in Advance find, if I try to select the columns from second table then I get error. Methos 2: I tried to create Fetch XML query and use addCustomView method. This method works if filter criteria is small. If I pass filter for say 50 GUIDS then this ...
I'm seeking an interior designer with the skills and experience to create a Bohemian-style design for a /laboratory and living room. The ideal candidate will be able to deliver a design that is both aesthetically pleasing and cost-effective. Key Requirements: - Design for a small space - under 500 sq ft - Bohemian style - Earth tones color scheme Ideal...color scheme Ideal Skills and Experience: - Proven experience in small space design - Creative flair for Bohemian design - Ability to work within a budget - Strong understanding of working with earth tones This project will require close collaboration and communication on design choices and adherence to a strict budget. I'm looking for a designer who can bring fresh, innovative ideas to the table while keeping the...
I'm seeking a skilled Python developer who can handle all aspects of SNMP for my project. Key Responsibilities: - Implementing SNMP query and data retrieval - Efficiently managing SNMP trap handling and notification - Developing a robust SNMP agent Your role will be crucial in ensuring that our system effectively communicates using SNMP across multiple versions. Ideal Skills and Experience: - Proficiency in Python - Extensive experience with SNMP (versions 1, 2c, and 3) - Strong understanding of network communication - Previous work on SNMP trap handling and agent development is a major plus If you have the right skillset and experience, I look forward to seeing your proposal.
I need a 3D modeler to create a straightforward product model based on provided photos. There's no need for intricate details or textures, just a model that captures the basic shapes and proportions of the product accurately. Key points: - The model is based on photographs only; I will not provide sketches or detailed drawings. - The aim is to create an 3D model (STL) - Leg from table. - Experience with product modeling and the ability to work from photos is crucial.
I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the template.
I am looking for someone who has worked with Elementor Queries before to write a query that does the following ... Our posts have an ACF field called prsona, which is shared with the posts. When posts are created they are created with that ACF field of the creator. Now we want to display posts where the posts prsona field matches the users prsona field.
I need an editable Word template created. The document will have permanent styles, but editable sections for my team to fill in. Key Features: - The template should include common formatting options like font styles and sizes, bullet points, numbering, and page borders. - I need the following styles to be fixed in the template: Heading styles, Paragraph styles, Table styles, Font, color, alignment, Indentation. - The main body content should be the only editable section for my team. Ideal Skills: - Proficient in Microsoft Word and its advanced features. - Experience in creating editable templates. - Attention to detail to ensure that the permanent styles are consistent throughout the template.
I'm looking for a professional programmer, proficient in Python to craft a script. This script is for the main p...Python to craft a script. This script is for the main purpose of finding mobile numbers, identifying their carrier, and matching this information with corresponding zip codes. This process is vital for my verification purposes. Not only this, but your script must provide these details in a CSV file output format. Key requirements are: - Extensive knowledge and experience in Python - Experience in number location and carrier identification script writing is a plus - Knowledge of data presentation in CSV format This task requires high attention to detail and a strong understanding of number location matching technology. If you meet this description, I'...
...from backup Activate 2. change the name of to 3. add the alias domain 4. Add the prt for and cname record for @ cloudfare , now i do manually 5. create the ssl for and have to do some sql sql command to change the Admin name , Instance name -- now i do manually 7. env file need to be updated 50% mile stone will be created at the time of awarding the project, All payment will be released as soon as satisfied with your work and fit to my requirements. If you are interested, please send me a message so that we can discuss... Thanks...
We need Oracle resource who are expert in below skills and having 8+ years of exp. Mandatory Skills: *• Need candidates with extensive experience in data migration across CRP, SIT, UAT, and GoLive phases in Oracle Fusion ERP implementation, utilizing ETL tools. * Experience in SQL Server, T-SQL, and SSIS Job Responsibilities: Data Extraction: * Extract data from various source systems, including flat files, spreadsheets, legacy databases, and external APIs. * Develop and optimize SQL queries and scripts for efficient data retrieval. Data Transformation: * Perform data cleansing, validation, and transformation to ensure data quality. * Convert data from source formats to Oracle-compatible formats. * Apply business rules and data mapping for aligning source data ...
...need of a professional with 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 ...
...need of a professional with 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 ...
...rewards and incentives to referrers, and provide benefits to referred customers. The system should also be able to manage and monitor the referral process with ease. There are other smaller improvements required to the website and the database we use to run our suppliers prices. Our stock database was designed by me and built by our then developers. We also link into accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in e-commerce systems - A good understanding of security features to ensure customers' data ...
This is a Python-based project involving LinkedIn connections parsing using a cookie file. The target is to uncover and analyze mutual connections between my personal friend's list and a CRM file. Important Aspects: - The script needs to efficiently ...existing client database is distinctly relevant. - I also need the parser to generate records of connections between my LinkedIn friends and contacts in my CRM. - I would require the output to be well-organized and easy to navigate. It should be exportable and storable both as a CSV file and an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in Python for web scraping and data handling - Experience in working with LinkedIn's data structure and APIs - Demonstrated expertise in managing and exporting data in ...
I'm in need of a skilled CAD designer, experienced in CATIA, to create a custom welding table design according to the following requirements: - Dimensions: (L)4000mm * (W)1800mm * (H)400mm - Material: Steel Features that I'd like to be included are: - Adjustable height - Built-in clamps - Hydraulic clamping The ideal candidate for this project should have: - Proficiency in CATIA - Prior experience designing welding tables - A good understanding of different welding table structures and features - Knowledge of steel as a material and its implications for table design
I urgently need a detail-oriented professional to type out the exact table of contents of the book I'll share with you. The end product, 2-3 pages, must be delivered in a Word Document format. You need to follow the same table of content format for the source book. It can be two or three pages. Skills and experience for the job: - Proficiency in MS Word - Strong attention to detail - Experience in transcribing text - Ability to handle potential diagrams or illustrations.
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be up...skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
...expert to create a flow that will automate the discount application process on my Shopify store from a Google Sheets CSV. Key Requirements: - The ZAP should identify new email addresses added to the CSV, and then add a customer tag "REGATHLETE" to them in Shopify. When the tag is added, they will be eligible to use that discount, as we have already created a customer segment for customers with the tag. - The ZAP must be able to add the tag both to new and existing customers in our Shopify database. Required Skills: - Proficiency in working with Zapier - Experience in creating Zaps with google sheets and matching CSV/data fields - Experience in automating processes and dealing with CSV files. The timeline is asap, and the budget for this is £...
I'm looking to have a tool developed that can analyze biological microscopy images, specifically with features such as color segmentation, edge detection, and cell counting. The tool should also support universal data import and corrections of alignment and image rotation. Ideal candidates for this project should have: - Strong proficiency in Python and Java - Previous experience with image analysis and microscopy imaging - Fiji, Maven, Eclipse preferred - Bio-formats - Would be great if you have experience in setting up a Fiji plugin (post your work)
Need help with a simple task that involves writing simple SQL statements and completion of the relevant ER diagrams. This task is in the context of simple data analysis. To be completed within 2-3 days.
I have a running Python file, who parse data from xml and insert it into sql server. Currently it isnt working. need an expert in python, who can fix it and upgrade few things as well.
I'm in urgent need of skilled professionals with experience in MySQL and Digital Ocean recovery console. My MySQL server is locked and I require assistance in exporting a SQL file. The exact cause of the server lock is not currently known but it might be due to server resource overload or a potential security breach. Required Skills: - MySQL - Knowledge of Digital Ocean's recovery console - Server management The main objective of the task is: - Successfully export the locked SQL file for further analysis and resolution - Provide insights on the potential cause of the server lock for future prevention. Experience in server management, specifically in handling locked servers, will be a great plus. Thanks.
I need a WordPress expert to help me import posts from a JSON file to my website. I need to import posts from a JSON file to my WordPress site, without any media files, just the text content. This is a one-time job and I want the imported content to look exactly like the original. Key requirements: - Expertise in WordPress - Proficiency in handling JSON file imports - Attention to detail to ensure no data loss Please ensure that you have prior experience in handling similar projects.
I am seeking a skilled database developer to convert my .frm and .idb files into a SQL file. The original files are in MySQL format. Key tasks will include: - Conversion of .frm and .idb files to SQL format. - Exporting these converted files to mysql server. I did not specify any special properties or features of the .frm and .idb files that need to be preserved, but will appreciate a careful and diligent conversion to ensure no data loss. The ideal candidate for this job would have: - Extensive experience with MySQL 5.7. - Proficiency in SQL file conversion. - Strong knowledge of database export practices. - Keen attention to detail to ensure data integrity.
