Convertir csv sqlεργασίες

θέλω να εξάγω δεδομένα από sql σε excel, , δηλαδή να έχω κάποια σταθερά κελιά που θα πρέπει να ενημερώνονται κάθε φορά μετά την καταxώρηση νέων στοιχείων στο erp.

Θα ήθελα να ενημερώνω ένα φύλλο ms excel από μια βάση δεδομένων MS SQL την οποία χρησιμοποιεί το ERP (SoftOne) ως χώρο αποθήκευσης δεδομένων.

Θέλω να δημιουργήσω οικονομικές αναφορές στο excel που να αντλούν πληροφορίες απο την sql που χρησιμοποιεί το erp μου.

SQL Tuning, PL/SQL, ΟΒΙΕΕ, Discoverer, APEX, Forms, Reports

...Κεντρικά Γραφεία της Εταιρείας, στη Θεσσαλονίκη. Τα επιθυμητά προσόντα της θέσης είναι: Πτυχίο σχολής ΑΕΙ ή ΤΕΙ Πληροφορικής Πολύ καλή γνώση προγραμματισμού ...

Θέλω την δημιουργία ενός eshop που να μπορώ να συγχρονίζω τις κατηγορίες και τα προϊόντα των προμηθευτών στο site είτε μέσα από excel, csv, xml. Και αναλυτική αναζήτηση προϊόντων με βάσ&e...

ΔΕΔΟΜΕΝΑ πολύφυλλα έγγραφα ΚΑΤΑΧΩΡΗΣΗ σε sql server2005 ημερομηνία έκδοσης εκδότη θέμα 3level κατηγορία το έγγραφο σαν εικόνα στο sql server και όχι το path του αρχείου ΑΝΑΖΗΤΗ&...

ΔΕΔΟΜΕΝΑ πολύφυλλα έγγραφα ΚΑΤΑΧΩΡΗΣΗ σε sql server2005 ημερομηνία έκδοσης εκδότη θέμα 3level κατηγορία το έγγραφο σαν εικόνα στο sql server και όχι το path του αρχείου ΑΝΑΖΗΤΗ&...

MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of loading from JSON file. (1 API) require updating treeview to load on demand 4- Packages Load from APIs instead of loading from DB (2 APIs) 5- Subscri...

I'm seeking a proficient PHP Developer, capable of performing specific tasks like PHP scripting without CMS/Framework. The core responsibility will be to parse strings and files, specifically CSV files. The ideal candidate is someone with strong PHP scripting skills, problem-solving attitude, and expertise in CSV file parsing. Your primary goal will be to customize the functionality of my website by automating some repetitive tasks and creating dynamic content. Experience with unstructured data formats like CSV will be critical to your success in this position.

I need a proficient freelancer to assist in the conversion of a PDF and an Excel file into a CSV format, specifically tailored for WIX integration. Key Requirements: - Conversion of a PDF file into a CSV format. The PDF contains crucial information that needs to be extracted and transformed into an easily readable and usable format for WIX. - The Excel file contains customer data, specifically including names, email addresses, and phone numbers. This information should also be integrated into the CSV file. Ideal Skills and Experience: - Strong expertise in data conversion, particularly from PDF and Excel to CSV. - Familiarity with WIX Integration - including the ability to format the CSV file in a way that is ready for immediate use in WIX. - Experienc...

I am seeking a proficient R programmer to assist with the evaluation of statistical significance in a large dataset. This project will involve data cleaning processes to address missing data, outliers, and unbalanced classes from CSV files. An in-depth understanding of advanced analytics and R programming is needed. • Proficiency in R language • Experience handling CSV files • Strong ability with data cleaning methods (dealing with missing data, accurately identifying outliers, working with unbalanced classes) • Expertise in evaluating statistical significance The selected candidate should not only have technical expertise but also the ability to interpret data and present findings in a clear, concise manner. This project shall pave the way for consequen...

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-dri...

...months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vita...

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

I require an expert in Python and Excel to assist with data analysis ...result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in reshaping data into different formats, preferably from *.xls to timeseries *.csv. the created python scripts must be proven to work both on raspberry pi and windows environment. Existing code will be provided, must be reworked for robustness and execution speed. Your keen eye for detail and high level of accuracy will be critical in ensuring our data is of the highest quality and suitable...

...homes listed and compile them into a CSV file. The program should include the duration each house has been listed on the site, and have it run every hour to capture new listings. Additionally, I would like duplicates to be automatically eliminated. Key Responsibilities: - Scrape for home addresses - Compile addresses in CSV format - Include the duration each house has been listed - Run the program every hour to capture new listings - Automatically eliminate any duplicate entrie - Run CSV file against another data base that has age and name of owner and contact info. Ideal Skills and Experience: - Experience in web scraping and data extraction - Proficiency in programming languages suitable for web scraping (e.g. Python, Scrapy) - Knowledge of CSV file cre...

...few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...

I am in need of an application that will download realtime 1 minute stock market data from the New York Stock Exchange (NYSE) and save it to a csv file. The application must be compatible with Windows. Key Features: - **Data Downloading**: The primary function of the application is to download 1 minute stock market data from the any chosen stock exchange in real time. - **Data Saving**: The downloaded data needs to be saved to a csv file. - **Data Filtering Options**: The application should allow for various data filtering options to facilitate data analysis. - **Real-time Alerts**: It should provide real-time alerts triggered by certain market conditions as well as calculated alerts based on oscilator calculation - **Historical Data Access**: The application should also fac...

...this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....

Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.

...Python programmer to design a program that analyzes the data from 7-8 spreadsheets and generates a discrepancy report. The project will require: - Strong proficiency in Python - Expertise in data visualization - Ability to compare categories within a large dataset - Comprehension of CSV format Specifically, the core functions of this Python program should include: - Analyzing spreadsheet data - Comparing various categories - Visualizing these comparisons to spot discrepancies - Exporting the results in CSV file format Ideal candidates should have extensive programming experience, particularly in the field of data analysis, and be able to demonstrate a solid understanding of data visualization techniques. They should also be familiar with handling large datasets a...

I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.

I'm in need of a web scraping wizard who can help me extract text data and profiles from Twitter website. Key Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in ...Requirements: - The ability to scrape text data and profile information efficiently and accurately. - Experience in web scraping, with a strong portfolio showcasing past work in similar projects. - The time for scraping a post and profile must be less 3 seconds without using Twitter API. The final deliverable should be in a format that's easy for me to analyze, but I'm flexible on whether it's a CSV file, Excel spreadsheet or a database format. Please describe your past work examples with your application. Write "Blue" on th...

I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.

I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience with Angular/react/Node would be plus

I need an expert to conduct a local PrivateGP...expert to conduct a local PrivateGPT installation on my Linux server with a pgvector database configuration. This setup aims to ingest various document and data file formats to enable a local Retrieval-Augmented Generation (RAG) Question-Answering system. Here are some details: - **Objective**: Incorporating GPT technology to generate a question-answering system. - **Document/Data Types**: JSON, CSV, PDF, XLSX, DOCX, TXT files - **Skills Required**: - Proficiency in GPT - Experience with Linux server configuration - Familiarity with document and data ingestion into pgvector database. You should be able to ensure full functionality and provide guidance or documentation on how to use and maintain the system upon project c...

I need a proficient software developer to create a Windows software that can scan COM port on a local machine, read and analyse various data formats including CSV, JSON, and XML. This software should have key features such as: 1. Data Reading & Analysis - Extract data from COM port in CSV, JSON, and XML formats. 2. Custom Filtering - Provide an option to select specific data to be posted to RSS feed. Two main custom filtering options should be considered: - Filtering by data type - Filtering by keyword Ideally, the freelancer should have strong skills and experience in software development for Windows, with a keen understanding of data formats and RSS feeds. Deep knowledge of COM port operations will be a significant plus.

As the point person for this project, I require a professional with proficiency in both LLMs (Larhe language Models) and Langchain, with a particular emphasis on the Llama 2 model. The objective here is to incorporate LLMs and Langchain to create a tool that can do data analysis from CSV as well as creating a chatbot for a restaurant Here's what in focus: - Implementation of LLMs and Langchain in data analysis and user interface - Specifically, developing a chatbot for a restaurant system that utilizes Llama and Langchain To be the ideal candidate, you need to: - Be an expert in LLMs, Langchain, and the Llama 2 model - Exhibit proficiency in working with data analysis tools - Possess UI design knowledge and experience - Have prior experience in chatbot development for the ...

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

I'm in need of a seasoned Apache Solr professional to help me implement search functionality for my project. The ideal candidate has excellent expertise in Apache Solr and can effectively optimize search functionality for text documents. Key responsibilities: - Upgrade from Apache Solr 3.6 to a version supporting wildcard search, Windows server - Multi cores with replication - bulk import via CSV - core creation/deletion across master and slaves Ideal skills and experience: - Prior experience implementing Apache Solr for search functionality - Proficiency in data indexing and faceted navigation with Apache Solr - Strong understanding of optimization techniques for search functionality - Excellent problem-solving and analytical skills - Good communication and collaboration ab...

...completion) Whereby; candidates can create a profile upload their CV, images or link to images and videos recruiters can search CVs with a Boolean type search functionality & save searches. Candidates and recruiters can message each other. Admin can manage the back end. Suggested technical skill set but not a complete one… • Cloud-based server solution • Azure or Single server solution • MS SQL Database (NoSQL document database might be more appropriate?) • OAuth • Payment gateway • .net We suggest design led development process where we sign off the look and feel of the web pages… the back end is for the supplier to advise the best scalable solution for the application. Please send your credentials/ skill sets and cost struct...

...managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and delivery addresses. 7. Manage user records and orders in the backend. 8. Prompt new users to provide necessary details. 9. Facilitate dish selection based on user preferences. 10. Display sorted dish options in sets of four ...

Description: I am looking for an expert in SQL and R programming for a detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with experience in ...

I'm on the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your proposals. Please include samples of your previous...

I am seeking a highly skilled freelancer to undertake a multifaceted project involving the detailed completion and enhancement of a CSV file for upload to Square. This extensive project requires three core competencies: meticulous data extraction from our website, proficient data entry into an Excel form, and the creation of engaging service descriptions using AI tools. The ultimate goal is to craft a CSV file that not only meets but exceeds the requirements for Square's platform, ensuring a seamless upload process. Key Responsibilities: Data Extraction and Accuracy: Initiate the project by extracting data from specific sections of our website. This data must be accurately transcribed into an Excel form, adhering closely to the required fields. Attention to detail is p...

Our company develops both desktop and web applications tailored for analysing insurance premiums. These have been developed in Delphi over the past 25 years. We are seeking to establish a long term relationship with an experienced Delphi programmer with exposure to Microsoft SQL databases. ASP.net application experience is also desirable. Our software packages require continued upgrading and enhancement and given the specialist nature of our software we are seeking to establish a long term relationship. The primary requirements include understanding our business process and system design, determining and articulating technical solutions, and implementing the design into build and install stages. Australian based is preferred, our principal office is based in Sydney NSW. If you...

I'm looking to build a custom scraper fo...scraper for DeFi exchanges. The main features I'm interested in are: - Historical data analysis: This is crucial for me to make well-informed decisions about the market trends. - Real-time data updates: Although not explicitly stated in the questions, the bot will need to be able to update data in real-time. This will help me stay ahead of the market. I currently prefer the output in CSV format, as it is easy and widely used. Given the nature of the DeFi space, experience in cryptocurrency scraping bots is a must. It would be ideal to have experience with DeFi exchanges particularly. This project will require strong skills in programming languages such as Python, R, or JavaScript, as well as experience in data sc...

I am in search of a proficient data entry specialist based in LATAM who can help me with various data management tasks. Key Responsibilities... - Data Cleaning: Your role will also involve cleaning data sets to ensure they are free from errors and inconsistencies. - Data Verification: You will need to cross-verify data to guarantee accuracy and reliability. Preferred Tools: - Proficiency in Microsoft Excel, Google Sheets, and CSV file format is preferred. Ideal Candidate: - Prior experience in data entry, processing, and cleaning. - Familiarity with data verification methods and tools. - Proficiency in Microsoft Excel, Google Sheets and CSV file format. - Attention to detail and accuracy in data management. Please note that the estimated amount of data to be processed...

I'm looking for an experienced .NET developer to assist with a project. This project requires someone who has a strong background in .NET technology, particularly in C# programming, ASP.NET development, and SQL database management. Ideal candidates should have experience in developing web applications, creating software solutions, and improving existing systems. The key functionalities to be implemented by the .NET developer in this project include user authentication, data encryption, and payment integration. If you're a .NET developer with a solid understanding of the above technologies and functionalities, please reach out to discuss the project further.

...in need of an hacker to perform a thorough black-box penetration testing on my WordPress website. Key Responsibilities Include: - Testing the security from an outsider's perspective. - Identifying and using hacking techniques including SQL injections, cross-site scripting attacks, and brute force attacks to hack website as outsider so that we can plug the vulnerability. Ideal candidates should have: - Proven experience in website vulnerability testing. - A strong understanding of WordPress. - Exceptional problem-solving skills. - In-depth knowledge of SQL injections, cross-site scripting attacks, and brute force attacks. My objective is to ensure my website's robust security, and your expertise can help me to achieve this. Your keen eye and tech skills are ...

I'm seeking a skilled Drupal expert to help me to export form submissions from the Drupal website to csv More details will share I can able to download as json file. I can able to download as yml file. But only CSV is blocking. So iwant CSV export web form Ideal Skills and Experience: - Proficient in Drupal CMS - Prior experience setting up content management systems - Ability to tailor CMS systems to specific business needs - Good communication skills to ensure our team can effectively use the CMS.

...of the website's database. Key Requirements: - Daily database updates: The website should automatically update its database every day. - Products and prices: The database should include technology products, such as electronics and computer hardware. - Design and layout: The website should be visually appealing and user-friendly. - Database type: The database can be either SQL or MySQL. Ideal Skills: - Proficiency in SQL or MySQL - Experience in e-commerce website development - Strong understanding of front-end design - Ability to automate database updates - Expertise in handling technology products Your proposal should include: - Your experience in similar projects - Your approach to automating daily database updates - Your estimated timeline for completing the pro...

I am in need of an individual with skills to assist with the migration of data from FS5 and .IDX files. My project involves: - files in FS5 or .IDXfiles that need to be migrated into a usable, readable CSV format that can be edited a - Handling text data specifically, and ensuring its integrity is maintained throughout the conversion. Potential freelancers need to have: - Knowledge of FS5 /.idx files. - Strong knowledge and understanding of text data management. - Excellent problem-solving aptitude, as the difficulty level can vary across files. I look forward to a thorough demonstration of your ability.

I have a CSV file that I need to be analyzed through visual data analysis in Python. The CSV file has a wide range of data, but the specifics of what data I'm interested in have been left open-ended. I need you to help me identify trends and patterns from this data and provide me with clear, insightful, and informative visualizations. Ideal skills: - Strong background in data analysis. - Proficiency in Python and data visualization libraries. - Experience with analyzing CSV files. - Ability to generate insights from data.

Looking for a skilled developer to fill in for a team member on vacation. The ideal candidate should have: - Strong experience in C# and ASP.net - Good knowledge of SQL Server The role involves: - Troubleshooting and fixing bugs in our existing applications - Enhancing and adding new features to our applications The projected timeframe for this position is less than a month, but the role could potentially be extended. You're being hired for not only your skills but also your problem-solving abilities - an essential trait when dealing with application bugs/issues. The key objectives for this role are: - Improving the performance and stability of our applications - Enhancing the user experience and application functionality Note: We skipped the outcome due to the job's shor...

I'm requiring aid in managing and optimizing my SQL database. This database is currently handling a range of information including product details, customer details, and order details. Key Tasks: - Improve the existing SQL database - Ensure efficient handling of product, customer, and order data Ideal experience and skills: - Proficiency in SQL queries - Experience in database management - Familiarity with inventory management processes, specifically handling a limited range of 20 different products. This project will require a keen attention to detail and a comprehensive understanding of SQL database manipulation.

I'm currently facing potential malware attacks causing unexpected slowdowns, particularly affecting my website load times. Hence, I'm i...security professional who can identify and rectify issues within my server files. Key Responsibilities: - Investigate the root cause for the slowdown of the website load times - Pinpoint potential malware in server files - Advance and fortify the security system to prevent future occurrences Ideal Skills: - Proficiency in cybersecurity - Solid understanding of server operations, particularly SQL - Experience in malware detection and prevention Your task: Use your expertise to bring back operational efficiency and bolster my domains server's security. If you can catch the malware predator and restore the peace of my server wor...

...equipo colaborativo, español nativo. b - JAVA2EE con experiencia superior a 2 años c- Conocimientos en programación Java Swing d- Experiencia en programación previa demostrable de al menos 1 año en programas de gestión tipo ERP, SGA, POS, CRM, facturación, contabilidad, etc. e- Entorno de trabajo sobre GITHUB, JIRA, ECLIPSE f- Conocimientos de programación SQL sólidos 2.- CERTIFICACIÓN PREVIA DE LOS PERFILES. a. Es para colaborar en un producto ya en explotación y distribuido en miles de instalaciones, por lo que la calidad y certificación previa son totalmente obligatorios. b. Por ese mismo motivo buscamos colaboradores permanentes y a mu...

I'm seeking a SQL and snowflake expert. I have a small table in snowflake, for which I need a view to be created. The view will have some failed from the table and then some calculated fields based on the original table.  Needs to be done asap. Will share the table data and columns of the table in and excel sheet and the desired results as well for your reference.