Đang Thực Hiện

Script to create database entries of files received via FTP

We would like to provide videos coming from cameras via FTP on a website. Website and database already exist, so that the job is very simple: whenever a new FTP-Transfer has finished the script shall make a database entry containing filename, date, time, cam-id and transfer that .avi file to a target directory using a new filename which is determined from the db-entry.

db-structure table security:

CREATE TABLE "security" (

camera integer,

filename character(80) NOT NULL,

frame integer,

file_type integer,

time_stamp timestamp(6) without time zone,

text_event character(40),

event_time_stamp character varying(14)

)

Example of db entries

camera | filename | frame | file_type | time_stamp | text_event | event_time_stamp

--------+----------------------------------------------------------------------------------+-------+-----------+---------------------+------------+------------------

3 | /home/sosobserve/htdocs/gallery/img/3/2017/06/23/[url removed, login to view] | 3 | 1 | 2017-06-23 14:00:32 | | 20170623135948

3 | /home/sosobserve/htdocs/gallery/vid/3/2017/06/23/[url removed, login to view] | 2 | 8 | 2017-06-23 14:02:24 | | 20170623140224

3 | /home/sosobserve/htdocs/gallery/img/3/2017/06/23/[url removed, login to view] | 0 | 1 | 2017-06-23 14:03:22 | | 20170623140224

3 | /home/sosobserve/htdocs/gallery/vid/3/2017/06/23/[url removed, login to view] | 2 | 8 | 2017-06-23 14:05:22 | | 20170623140522

3 | /home/sosobserve/htdocs/gallery/img/3/2017/06/23/[url removed, login to view] | 2 | 1 | 2017-06-23 14:07:27 | | 20170623140522

3 | /home/sosobserve/htdocs/gallery/vid/3/2017/06/23/[url removed, login to view] | 3 | 8 | 2017-06-23 14:15:58 | | 20170623141558

origin of data

camera ---> values 1,2,3,4.... determined from the directory name where the respective ftp-files arrive

filename ---> full path of file in target directory - path comes from a config file

frame ---> value 2 should do it for the moment

file_type ---> value 1 for .avi file

time_stamp ----> time when ftp files arrival has completed

text_event ---> empty

event_time_stamp --> same value as time_stamp - different format

Kỹ năng: Linux, PostgreSQL, Python

Xem thêm: data entry create database, create database entry mssql script, remove entry mysql database script, mysql create database script, create movies site database script, create functional database script, oracle10 create database script, php setup script create database, create database install script php, php script will create database tables, create database text files, script ftp files server, sql script automatically create database, create database php script, php script create database, create database script, php create install database script, perl script ftp files

Về Bên Thuê:
( 5 nhận xét ) Salzburg, Austria

Mã Dự Án: #14488545

Đã trao cho:

stoyanovalexandr

Hello, I am a skilled unix and network engineer with 5 years of experience in unix based systems, virtualization like proxmox,esxi,xen,virsh, iptv,zimbra etc. Relevant Skills and Experience Hello, I am a skilled unix Thêm

$250 USD trong 1 ngày
(113 Đánh Giá)
6.2

37 freelancer đang chào giá trung bình $418 cho công việc này

odessky

Hello. I'm an expert in Linux and related technologies. My CV is [url removed, login to view] I'm ready to discuss the details of your project. I'm available during business hours + 2GMT Relevant Skills and Experience I Thêm

$333 USD trong 3 ngày
(199 Đánh Giá)
6.7
gangabass

I can create such Python script in 3-5 days for just $350. I have worked on similar projects (Python + Postgres) many times before that's why I'm sure you'll be impressed with my work. I can start right now and finis Thêm

$349 USD trong 3 ngày
(121 Đánh Giá)
6.3
tlchung

I am a skilled developer, i can do the db insert script for you. let discuss more via private message, thanks. Relevant Skills and Experience I am a skilled developer, i can do the db insert script for you. let discus Thêm

$333 USD trong 10 ngày
(53 Đánh Giá)
5.4
iglobalvn

Hi sir, I have read your requirement carefully. I am interested to work for this project and i will provide within or before 5 days . Relevant Skills and Experience If you wanna confirm me, please check my work histo Thêm

$500 USD trong 5 ngày
(13 Đánh Giá)
5.5
masterlancer999

Hi I am very experienced in Python and MYSQL Database programming I already read through your requirements, and I am sure I can complete this in 5 - 6 days Please message me Thanks Relevant Skills and Experience Pytho Thêm

$388 USD trong 7 ngày
(12 Đánh Giá)
5.3
webbookstudio

Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so Thêm

$400 USD trong 7 ngày
(1 Đánh Giá)
4.8
techashu91

I have reviewed all the requirements and specifications shared by you n the job description. I am confident enough to handle this task. I have all the skills required for this job. Relevant Skills and Experience https Thêm

$700 USD trong 15 ngày
(13 Đánh Giá)
4.9
letshappy

hello, i am red hat certified engineer with python and c and java experience i have done a python task for script for adidas yeezy and i can do your easily lets discuss more Relevant Skills and Experience have a look Thêm

$488 USD trong 4 ngày
(15 Đánh Giá)
5.1
ukgolang

I understand your problem and can write a script to accomplish what you require. Relevant Skills and Experience I have ten years experience supporting Linux servers and writing scripts to perform admin tasks. Propose Thêm

$250 USD trong 2 ngày
(4 Đánh Giá)
4.1
$400 USD trong 4 ngày
(4 Đánh Giá)
4.1
tranngocanh1702

I am able to write a script that can create database entries of files received via FTP containing filename, date, time, cam-id and transfer that .avi file to a target directory. Relevant Skills and Experience I am Ann Thêm

$500 USD trong 10 ngày
(12 Đánh Giá)
4.9
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Thêm

$500 USD trong 8 ngày
(5 Đánh Giá)
4.2
$555 USD trong 10 ngày
(21 Đánh Giá)
4.2
steveo100

Hi there, My name is Steve, and I am a Freelancer from Brisbane, Australia. Myself and my team including a graphic designer and 2 other developers would be keen to assist you with your project. We have worked o Thêm

$555 USD trong 10 ngày
(2 Đánh Giá)
3.5
vlayausa

Hello, I would love to help you with this project. I work as a system administrator in a bank and I was helping to my colleagues who are Database administrators with several projects. Relevant Skills and Experience Thêm

$300 USD trong 5 ngày
(4 Đánh Giá)
2.8
$270 USD trong 10 ngày
(9 Đánh Giá)
2.7
etuannv

Dear Sir, I think I can do this job. Could you discuss on chat? Relevant Skills and Experience python, linux, ftp Proposed Milestones $388 USD - Milestone for project

$388 USD trong 10 ngày
(4 Đánh Giá)
2.5
phpfreelancer86

Hello Sir, I've reviewed your requirement and I'm ready to work with you. I will provide quality work as well full support for any query. I'm giving you trust for good quality work. I have almost 7+ years of expe Thêm

$500 USD trong 4 ngày
(1 Đánh Giá)
2.1
rajibdebslg

Hi, I have gone through your requirements and I am very interested to build this automated script. I have very good experience in Linux system. Please have a look at my profile and let me know Relevant Skills and Expe Thêm

$250 USD trong 10 ngày
(1 Đánh Giá)
1.8
needanazeema

it can be easily done in less time. Postgresql plugin is already available for python. just have to configure the database site and database access credentials. will do in very less time. i have experience with python Thêm

$385 USD trong 3 ngày
(3 Đánh Giá)
1.7