Sql express csvεργασίες

Γειά σου Νίκο, είμαι ο Στέργιος. Στη δουλειά έχουμε κάποια site σε cpanel σε shared hosting στο hostgator και προσφατα μας κλειδωσαν την SQL και με το support τους δεν υπάρχει επικοινωνία γ&i...

θέλω να εξάγω δεδομένα από 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 του αρχείου ΑΝΑΖΗΤΗ&...

I need a bash script that can import and export data from my database to CSV files. Ideal candidate should be able to: - Create a bash script that can effectively import and export data - Have experience working with database management systems such as MySQL, PostgreSQL, or MongoDB - Ensure that the script securely creates user accounts and manages their access to the database. The script will be used for daily database management tasks, so it needs to be reliable, secure, and efficient.

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

I'm looking for a seasoned Python developer who can assist in two main areas: - Creation of PowerPoint presentation using a CSV data file - Automate the process via a public URL to upload the CSM file Creation of Powerpoint Presentation The CSV file will feature data-points in columns. A powerpoint presentation template will be provided for reference. The graphs and tables should be present as per the data-points present in CSV file. Automating the Process This is the secondary part of the job. Once we have are successfully able to convert a CSV data in PPT format, we should create a public secured link to upload the file. It should be auto-converted and file should be ready for download. The ideal candidate should be a proficient Python Developer wit...

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Manag...agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to design an aesthetically pleasing interface. Requirements can be asked if you are interested, you can build with any framework, preferably javascript based frameworks. Minimal SQL is required, a...

I need a tool that extracts specific content (text and images) from PDF files and adds this data into a CSV file under designated headers. Key Requirements: - The tool should be designed specifically for Windows OS. PDF Data Extraction: - Need the tool to extract both text and images from the PDFs. CSV Insertion: - The extracted data should be sorted correctly under their respective column headers in a CSV file. Consistent PDF Structure: - It is important that the tool can handle data extraction from PDFs with a consistent structure. Ideal Skills and Experience: - Proficiency in developing Windows-based tools. - Experience with PDF data extraction. - Familiarity with CSV file manipulation in Python or related languages.

I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance and to...Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import for softw...

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Set...framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability to deliver on...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...

I'm looking for a capable developer to help me reorganize the layout of phpMyAdmin by utilizing CSS. Key responsibilities: - Rearrange the layout of the phpMyAdmin interface to suit my preferences and needs & upload CSV file. Ideal skills and experience: - Proficiency in PHP and CSS - Experience with phpMyAdmin or similar database management systems - An eye for design and user experience - Ability to understand and implement user requirements into the interface

As a business owner, I'm looking for a competent Xero data entry specialist to handle my bank transactions. Key Responsibilities: - Transferring bank transaction data from the exported CSV file into Xero - Correct categorization of all transactions as per Xero's standard chart of accounts Ideal Skills: - Proven experience with Xero and bank transaction data entry - Knowledge of Xero's standard chart of accounts - Attention to detail and accuracy in data entry - Good communication skills to clarify any uncertainties Please provide your relevant experience and availability for this task.

I am looking for an expert in Python programming to assist me in the creation of a multi-timeframe indicator merge. The project entails the merger of the 4hr, 1hr, 15min, and 5 min timeframes while including specific indicators, namely Moving Average, Relative Strength Index (RSI), ADX, and Webslingers. To make info... To make informed bids, it's important to note the following: Ideal Skills & Experience: - Extensive knowledge in Python programming - Proven experience in financial analytics - Expertise in working with listed indicators Project Requirements: - Code the multiple timeframes using Python - Integrate the Moving Average, RSI, ADX, and Webslingers indicators - Generate the deliverable output as a CSV file Please feel free to inquire if you need more clarificat...

I'm in need of a proficient developer to create a comprehensive computer (in a network) probe software compatible with Windows and Linux. The software should have the following key features: 1. find systems in a network and log details to a CSV file/db table. hostname, ip addresses , mac address etc along with hard disks ,os,version etc. 2. find applications installed in the computers Ideal Skills & Experience: - Prior experience in developing network monitoring and security auditing software. - Proficiency in programming languages suitable for cross-platform development. - Strong understanding of network protocols and security standards. - Experience with compliance monitoring tools and techniques would be an added advantage. Please include re...

Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.

I am seeking a full stack PHP developer to assist me with my project. I'm l...you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality applications, this project is for you. Your ability to work both independently and collaboratively will be key to our success. Ideal skills and experiences include: - Proficient in PHP and related frameworks - Strong knowledge of HTML, CSS, and JavaScript - Familiarity with SQL and database management - Experience in user authentication and payment processing - Understanding of project management and problem-solving - Excellent communication and time management skills I am looking to commence this project at the earliest convenience, so please get in touch if you're avail...

I'm in urgent need of a detail-oriented freelancer who can assist me with enriching the data in a CSV file. This file contains information on over 6000 Fast-Moving Consumer Goods (FMCG) products, including product titles and barcodes. Key Tasks: - Go through the CSV file: Identify each product's title and barcode. - Search for the product image online: Using the product title or barcode, find a suitable image of the product. - Download the image: Save the image to your local system. - Organize the images in folders: Each image should be saved in a folder named after the product category. - Rename the image files: Each image should be renamed to match the product’s barcode with a .png/.jpg/.jpeg extension (e.g., ). Ideal Candidate: - Proficient in data analy...

I'm looking for an experienced Python coder to tackle two key aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy & Django**: Proficiency in these fra...

...creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for collection, waiting on parts, not started, complete...

Develop macro-enabled Excel file to handle CSV

Ho bisogno di un programma che mi permetta di aggiornare disponibilità e prezzo di vendita dei prodotti presenti nello store shopify partendo da un file excel/csv che viene generato automaticamente ogni x ore e viene esportato dal getionale su cartella FTP

Specs: Grid Cells select format 1-the color picker: first time open (no previous coclor selected), defaulted luminance to 50%. If previous color selected, default to that color. 2-the selected color needs to be on the button after first selected. 3-a radio button (format button appearance) for each format type: backcolor, forecolor, bold, italic, underline. same like color, needs to select and change the cell. 4-the cell select needs to toggle the format on and off. 5-checkbox to save the format between reload of grid data source. Bid with 1-22-333 in you bid to filter bot

...hence our AI works on it through big data and automation. The project is about algorithmic auto-investing trading on world wide's financial market. Fixed Rate Job Paid based on success delivery per country. $10/country. Make about 5-10 API/country for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Perso...

exactly similar to this f-system

...Technologies: Google Assistant SDK: For setting up and configuring Google Assistant. Dialogflow: For natural language processing and managing conversations. Node.js/Python: For writing the webhook server. OpenAI GPT-3 API: For generating content based on user input. Example Code Snippet: javascript const express = require('express'); const bodyParser = require('body-parser'); const { OpenAIApi, Configuration } = require('openai'); const app = express(); (()); const configuration = new Configuration({ apiKey: 'YOUR_OPENAI_API_KEY', }); const openai = new OpenAIApi(configuration); ('/webhook', async (req, res) => { const userQuery = ; const response = await ({ model: 'text-davi...

I'm looking for a skilled professional who can migrate an existing voicemail manager system from Google Script (Javascript) to Office365. The primary purpose of this migration is to rebuild the system on a completely different platform. Key Requirements: - Proficient in Google Script (Javascript) - Familia...intricacies of voicemail manager systems. The project's success will depend on the freelancer's ability to effectively transfer the existing system's functionalities to the new platform. The system must be rebuilt using Javascript, ensuring compatibility with the desired platform: Office365. I also need help to complete previous project. Help with the following: 1. Batch file to merge Ruckus csv files instead of overwriting. 2. Batch file to find missi...

...---------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game.

...mailing list, Loyalty program, Social media accounts, FB, Whatsapp, Youtube, Instagram, Twitter. Email newletter banners (Relevant occasions, seasons). Digital marketing activities, SEO, Selection of categories and merchandise by Client. Bulk downloading of product files (including pics, videos, descriptions, prices, no sold, and reviews) from Walmart, Home Depot, Wayfair (for US primary market) Ali express for the secondary market. Automatic Ability to sync products, prices, availability, etc. frequently. Ability to post product and merchant reviews. Packing slip & shipping labels. Ability to carry min. 50,000 sku's in online catalog. Discounts: Visitor, first order, seasonal, Occasional (tied to things like mother's father's day, Christmas etc. up to 25 occas...

Hello, I need convert a PDF invoice to Excel to import to our invoices software

I have a Python notebook containing well-structured code that effectively translates a sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the existing Python code in t...sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the existing Python code in the provided notebook to translate the entire dataset from English to Arabic. - Ensure the translated data is saved in two formats: Comma-Separated Values (CSV), and Apache Parquet (.parquet) - Provide the CSV and parquet files aft...

...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...

I desire a professional Macrodroid developer with a strong portfolio to create a macro for any use. The objective of the macro is to read a CSV file and automatically send a specific WhatsApp message to each phone number listed in the file. Key requirements include: - import a CSV file (Name,Given Name,Additional Name,Family Name,Phone 1 - Type,Phone 1 - Value) - Creation of a macro that automatically triggers WhatsApp messages. - The macro should be programmed to initiate the messages when it reaches a phone number listed in the CSV file. - The message is from CSV or default the same for all numbers in the CSV file. Ideal Candidate: - Proficiency and extensive experience working with Macrodroid. - A proven track record with similar projects. - Strong...

We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.

use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

I am looking for a web-scraping expert to retrieve both images and text from a specific website for research purposes. The text data will need to be structured and saved in a CSV file, including paths to saved images. Key details to consider: - Knowledge of web scraping tools and techniques is essential to accomplish this task. - Quality control to ensure accurate data extraction and image quality is critical. - Structure page information and freeform descriptions should be made available in a CSV file. - The images should be saved in their original resolution and quality settings. Please provide any relevant experience you have in web scraping, including free and paid services you have used before to help with your work. I would like the project to be completed in the n...

...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dash...

We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.

Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.