Suljettu

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

Taidot: liiketoimintaprosessien ulkoistaminen, Tietokoneapu, tiedonsyöttö, Desktop Support, Excel

Location: Eluru, India

Näytä lisää: 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

About the Employer:
( 0 reviews ) India

Projektin tunnus: #14723175