Automatic Database Imports and Fuctions (Microsoft Access ONLY)
$30-250 USD
Paid on delivery
I need a windows program or the same VBA that will fetch data from a folder (PlayoutLogs) DAILY and AUTOMATICALLY, then modify and store it to Microsoft Access Database.
(So that later anyone on the network can access this data and create special reports)
This folder comes from a playout software, that each day generates a log file:
Example:
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
[login to view URL]
Inside each Logs, it contains (4) rows of data:
Row 1: [dd:mm:yyyy hh:ss:mm:000]
Row 2: E:/PLAYOUT/folder/subfolder/[login to view URL]
Row 3: hh:mm:ss
Row 4: []=TAG
The automation must a preform these (5) functions always:
1. Fetch/Import each Log from folder AUTOMATICALLY (Once Every 24 hours) to Microsoft Access Database.
2. Split Rows 1, into to (2) separate Rows for Date (dd:mm:yyyy) and one for Time (hh:ss:mm:000).
3. Then, change the Date format from “dd:mm:yyyy” to mm/dd/yy
4. Remove this : “E:/Playout”
5. Remove this : “[]=”
The FINAL Rows must look like this in Microsoft Access, 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/[login to view URL]
Row 4 (Duration): hh:mm:ss
Row 5 (Type): []=TAG
IMPORTANT NOTE: I THINK THE DATABASE MUST ONLY FETCH THE DATA FROM THE PREVIOUS DAY, SINCE THE PLAYOUT SOFTWARE GENERATES THIS LOG ON THE FLY AND IF MS-ACCESS/PROGRAM 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)
PS. ATTACH IS THE SAMPLE FOLDER AND LOG FILES
Project ID: #2693022
About the project
Awarded to:
13 freelancers are bidding on average $99 for this job
Hi, I can do the job, MS Access, SQL, PL-SQL, VBA, VB6, VBNET, C#, Oracle, SQL Server, Firebird, MySQL expert
Greetings!!! We are glad to bid on your project and would be more happy if get a chance to work on the same. Please see PMB for details
Greetings!!! I can do this. I am expert in vba. You can see my portfolio for more information. Regards, benefit works