Automatic Database Imports and Fuctions (Microsoft Access ONLY)

Zamknięty Opublikowano Nov 16, 2012 Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

I need a dynamic Database that will Fetch/Import data DAILY and Automatically from a folder.

The playout software, generates each day a log file:

Example:

playout\_2012\[url removed, login to view]

playout\_2012\[url removed, login to view]

playout\_2012\[url removed, login to view]

playout\_2012\[url removed, login to view]

Inside each file it contains (4) rows of data:

**Row 1:** [dd:mm:yyyy hh:ss:mm:000]

**Row 2:** E:/PLAYOUT/folder/subfolder/[url removed, login to view]

**Row 3:** hh:mm:ss

**Row 4:** []=TAG

I need the Microsoft Access to this (5) functions:

1. Fetch/Import each file from folder _AUTOMATICALLY_ on daily basis (Every 24 hours)

2. On **Row 1**, separate the Date (dd:mm:yyyy) and Time (hh:ss:mm:000) to an individual row.

3. Change the Date format to **mm/dd/yy** (from dd:mm:yyyy)

4. Remove the string: "**E:/****Playout**"

5. Remove the string: "**[]=**"

The final rows must look like this, and I must then be able to create detailed reports for this data:

**Row 1** (Date)**:** mm/dd/yy

**Row 2** (Time)**:** hh:ss:mm:000

**Row 3** (Source): /Folder/Subfolder/[url removed, login to view]

**Row 4** (Duration)**:** hh:mm:ss

**Row 5** (Type)**:** []=TAG

**IMPORTANT NOTE: **FOR THIS TO WORK FINE, THE DATABASE MUST ONLY FETCH THE DATA FROM THE PREVIOUS DAY, SINCE THE SOFTWARE GENERATES THE LOG ON THE FLY AND IF MS-ACCESS TRIES TO IMPORT A FILE FROM THE SAME DATE, IT WILL IMPORT AN 'UNCOMPLETED' LOG FOR THAT DAY.

(IF YOU HAVE A BETTER SYNTAX OR FUNCTION TO THIS, I AM OPEN TO DISCUSS)

Instalowanie skryptów Shell Script Pulpit systemu Windows

Numer ID Projektu: #2675760

O projekcie

20 ofert Zdalny projekt Aktywny Jan 4, 2013