|I have some sql scripts. need them to be executed from python script and write output to log files.
||I have some sql scripts. need them to be executed from python script and write output to log files.
I can do this for simple query scripts. I want a script for for executing complex sql scripts which contain BEGIN, DECLARE, IF, CREATE etc.
||Python, Destop Windows, Kejuruteraan Perisian
||May 17, 2018
||May 17, 20182h 1j
|Build SSIS Package using VB 2017 SSDT ( VB Script included below)
||I wish to refresh an excel sheet and email it to a user.
The excel file has a connection to a SQL Database so the file must be refreshed and then emailed out to a user
I have previously done this using some Vb script in a BAT file and triggered this using a Windows scheduled task, but this is a bit legacy now and I want to implement a more professional method.
Below the VB script I previously ...
||.NET, Microsoft, Pelayan Microsoft SQL, VB.NET, Powershell
||May 10, 2018
||May 10, 2018Tamat
|Powershell script expert needed - urgent task....
||Need a powershell script to write a script to do the following:
1) go to a c:deployToBeDeployed folder
2) loop through all the .zip files in the folder
2a) extract all the .sql files from the zip file
2b) execute the .sql file one by one using Invoke-cmd on to the local SQL server instance
2c) Continue with next script if any script throws error.
2d) Log the error in a simple text fil...
||Visual Basic, Destop Windows, Kejuruteraan Perisian, Skrip Kekerang, Powershell
||Apr 23, 2018
||Apr 23, 2018Tamat
|Amazon API Seller Central integration - import orders into our SQL Order Entry system
||We are a seller on amazon seller central
We are currently entering our orders into our order management system by hand.
We'd like to write a script or a process that will import the orders into our SQL DB
We will let you suggest the best method - we have shared a screen shot of our customer system
i have attached the table schema abd will provide access to amazon API to selected de...
||PHP, SQL, Perkhidmatan Web Amazon, Pengaturcaraan Pangkalan Data, Scripting
||Apr 12, 2018
||Apr 12, 2018Tamat
|Python script cron job bug on Ubuntu server
||I have a python script that runs perfectly on my ubuntu remote server when run via ssh in the terminal window. The script is set to scrape data from an API and write the data to an sql table.
However, when i try to run this as a cron job on my plesk control panel, the job seems to take forever to run and gets stuck and doesn't finish running.
I need help fixing this bug so the cron job can...
||Python, Plesk, Ubuntu
||Apr 4, 2018
||Apr 4, 2018Tamat
|Scrap Images data from site
||We are looking for python or php based developer to write script and scrape image and image data from a site. Image size varies under 10mb so you must be able to both write script and run it to save images. Data is in unicode - so you must be able to save it in UTF-8 format.
We would need image tar and csv/or sql dump of data.
||PHP, Python, Pengikisan Web, Kejuruteraan Perisian, MySQL
||Mar 29, 2018
||Mar 29, 2018Tamat
||This is a simple project for anyone who is proficient in powershell.
The aim of the project is to write a powershell script that is reads the security event log of a given server and enters those details into a SQL table.
The script is to be parameter based (Server Name, SQL Server, userid, password) and should only read the past hour of events.
As for the SQL table only the table des...
||SQL, Kejuruteraan Perisian, Skrip Kekerang, Pelayan Microsoft SQL, Powershell
||Mar 28, 2018
||Mar 28, 2018Tamat
|Azure Queue and Function Code Development v1
I require a coder to write some code that utilises Azure Queues and Functions, as well as SQL Database and SendGrid.
Function 1 named UpdateReminderQueue
This, which will be a scheduled function (runs every day at 1am). This will query a database for email addresses, where the ReceiveEmails = 1, Unsubscribed = 0, MessageSent = 0 and the SubsExpiry date is within 14 days of the day...
||Pengaturcaraan C#, Azure, Pembangunan Pangkalan Data
||Mar 18, 2018
||Mar 18, 2018Tamat
|PL/SQL coder needed for one time freelance work.
||I am an individual and work as an IT professional myself.
This is a quick one time requirement and a simple and straight forward task.
I need someone to write a script to generate alerts for long running sqls from Oracle database and send it via email with the following information.
- Capture distinct long running sql ids > 30 mins elapsed time
- Provide sql execution history with hash ...
||Oracle, Pentadbiran Pangkalan Data, Pengaturcaraan Pangkalan Data, Pembangunan Pangkalan Data, Pengekodan
||Mar 12, 2018
||Mar 12, 2018Tamat
|Data Analysis Project
||For this project, you will use Python to scrape the web links from the HTML code of the U.S. Census Bureau’s Population Estimates web page, use SQL to spot differences in the population size, and use linear regression in R to predict the size of the population of the State of Nevada in 2020. The link for the web page is [login to view URL]
You will use versions of Python, SQL, and R of yo...
||Python, SQL, Pengikisan Web, Bahasa Pengaturcaraan R, Data Analytics
||Mar 5, 2018
||Mar 5, 2018Tamat
|Implement a download limit using member groups from SQL database
||Re-write my python script so that it has download limits,
I have a forum which runs from an SQL database, i want certain user groups to have unlimited access and others to only be able to download 3 times in a rolling week period.
My program is set up to deny access if the user hasn't registered on my forum, once they login it then gives them access to the downloads area.
If you thi...
||Mar 5, 2018
||Mar 5, 2018Tamat
|Lime Survey Results to a database
Looking for a simple PHP script that will extract results from a Lime Survey and write to a existing table in mySQL.
Survey Question 1: Name of Company?
Survey Question 2: How many people in your company?
Survey Question 3: Favourite Color?
If Bill Smith (who was emailed via lime survey on bill@[login to view URL]) answered:
Q1: Acme Brothers
||PHP, SQL, MySQL, Pengaturcaraan Pangkalan Data, Data Extraction
||Feb 28, 2018
||Feb 28, 2018Tamat
|Need someone who is good at socket programming and json in PHP.
||I have a client program which will send json data to the PHP server.
I need you to write the PHP script for the server.
The server will listen to a specific port and every time the data is received, it will add that data to the SQL database, and will show updated table on the page.
No complex UI is required.
If you are interested, please bid for details.
||Feb 11, 2018
||Feb 11, 2018Tamat
|Project Work on a Legacy VB.net Web Application
||I need some work done on a legacy VB.Net Web Application. The System is build as a Single Page App it is technically a Web Forms system there is nothing on the markup side and does not use any standard .NET controls. Pages get built by back end VB Code. It also connects to an old version of SQL Server (2000). The System is distributed across several servers for various functions though the pri...
||ASP, Visual Basic, ASP.NET, Pelayan Microsoft SQL
||Jan 29, 2018
||Jan 29, 2018Tamat
|Automation script and user db.
||We are looking for someone to write a python automation script that will help us automatically submit credit card data to [login to view URL] from a SQL database. We will need a User Interface so we can enter Credit card info easily into the database which will be hosted on Heroku.
The User interface will need the following fields.
Card number (req)
||PHP, Java, Python, Kejuruteraan Perisian, MySQL
||Jan 15, 2018
||Jan 15, 2018Tamat
|Write a popular blog about websecurity
||Write an article about Web security?
Article should be in English
It should be written with your own words, you should not copy and paste from other resources. I will be controlled by using professional plagiarism tools.
Select any topic from web security domain. Potential topics: Wordpress hardening steps, a recent wordpress vulnerability and ways to fix it, about sql injection and how to fi...
||Article Writing, Blog Writing, Penulisan Kandungan, Sekuriti Web, Wordpress
||Dec 24, 2017
||Dec 24, 2017Tamat
|online programming mentor help wanted
||AD: Please read, understand and respond that as a programming mentor, you'll via "screen share webcam" not develop any software but meet on a need basis few times a month/or week for an hour long online mentoring session 8pm-9pm New York Time USA-EST in order to provide various technologies related webapps programming help to an individual Developer by explaining A thru Z of any sam...
||Dec 12, 2017
||Dec 12, 2017Tamat
|SQL expert to write a script
||Need a SQl script to write table data to a specific format XML file. I have the mapping done from SQL to XML
||Dec 7, 2017
||Dec 7, 2017Tamat
|Connect Program to Database
||I need you to develop some software for me. I would like this software to be developed for Windows using Java and sql. I have the java done i just need you to connect it to the database using sql and write the script in java to put stuff in the database. I will send you the file if you message me so that you can view it. I have the database
||Java, Destop Windows, Kejuruteraan Perisian, MySQL, Pengaturcaraan Pangkalan Data
||Dec 5, 2017
||Dec 5, 2017Tamat
|.NET script to read and display SQL table
||I need a .NET script, located in server 1 ([login to view URL]) to read and display 3 SQL table.
Tables are in SQL server located in Azure (server 2). Tables are reachable using management studio
Please write PM to let you know login credentials to [login to view URL] server and management studio (server 2)
||.NET, SQL, Pengaturcaraan C#, ASP.NET, Pelayan Microsoft SQL
||Nov 29, 2017
||Nov 29, 2017Tamat