Database Driven Copy/Replace Folders/Files & Notify Results.

This project requires a MySQL database containing a list of folders be created at a location based on what is contained in a MySQL database table if they do not already exist. It also requires that files be copied from a location on the same HDD to the location (same HDD) specified in the database table. It also requires the text string in the database table column2, i.e. (sample1) be replaced with the text string in another column3 in the database table, i.e. (Dallas).

At a high level, the Classic ASP logic is as follows:

1. Open a database with a SELECT statement

2. Do while not EOF

3. Call objFolder Function ( info from db table )

4. If Folder rs("column1") not exists then create folder using name from db & return T or F

5. If T (folder created successfully) then update db column4 with 1 (true) and db column5 with date/time folder created. Else update db column6 with 0 (false) and column7 with date/time folder operation failed.

6. Call objFilename Function ( info from db table ) i.e. tmp-location, filename, rs("column1"), rs("Column2")

7. If filenamers("column2") not exists, then copy file from temp-location to location specified in variable for the current row in the db table. Search the current file, based on db info, and replace the tmp-text rs("column2") with the replacement text rs("column3"). Return T or F if operation was successful.

8. If T (file copied & updated successfully) then update db column6 with 1 (true) and db column7 with date/time folder created. Else update db column6 with 0 (false) and column7 with date/time file operation failed.

9. Display a progress bar showing progress of these activities. Does not need a separate progress bar for each individual activity, just one for the high level operation of folder/file/rename activity. The label for this progress bar will be "File Operations1". There is a requirement for additional progress bars for certain Folder activities and will be labeled as "File Operations2", "E-Mail Notification", etc.

10. Move to next row in the table and loop through the above operation again

11. Once everything is completed successfully, call another function named objNotify, using info from the db table row to send an e-mail notification based on the e-mail address in the db table. Return T or F if e-mail was successfully sent.

12. If T (successful e-mail sent), then update db column8 with 1 (true) and db column9 with date/time e-mail was sent. Else update db column8 with (false) and column9 with date/time e-mail operation failed.

13. Close db related operations.

NOTE: The db column update activities could be performed within the function to simplify operation.

This is very high level just to give an idea how this will work so some things could change as we move forward with this project. The column1, column2, etc are just examples. We will use actual names for the columns. Basically, I just want to create folders and copy template files into each folder and rename the placeholder text in the newly copied file with text from the database and update the database table with status information. I also need the page to display progress bars so the user knows something is happening in real time as this activity is happening.

Skills: Database Programming, MySQL

See more: freelancer jobs, freelancer uk, freelance jobs online, microsoft flow sharepoint copy file, how to work on freelancer, microsoft flow copy folder, microsoft flow update file properties, freelance jobs from home, database driven flash gallery, database driven flash, view vss project folders files front end, edit msi file replace dll files, database driven java gui application, database driven cms 2008, software database driven web applications, search replace text files, database driven website, database driven form design, vba copy folders files date modifed, copy folders files drive progress bar vbnet

About the Employer:
( 1 review ) The Colony, United States

Project ID: #17597794

Awarded to:


Hello! I've read carefully what you requested. I am strong versed in Classic ASP since it was my very first language learnt when I jumped onto web development, about 20 years ago. I also used MySQL databases in comb More

$19 USD / hour
(1 Review)

12 freelancers are bidding on average $18/hour for this job


ok can we discuss more on freelancer inbox to get detail understanding about project ? I have relevant skills and experience as per your project need...i can share some demo as well once i get proper scope. i am More

$20 USD / hour
(84 Reviews)

Hi, thanks for your job posting. I don't look new client but I read your serious job posting. That's why I write this bid with happy mind. I have developed several websites similar with your requirements. I am good a More

$20 USD / hour
(8 Reviews)

Hello. I read your project description.. I have many experience with Mysql and php. You will satisfy with my work. I am very fast and reliable. Please let us discuss more.. I will do my best to help you.

$15 USD / hour
(9 Reviews)

¬¬¬Hello Sir Greeting of the day! We will give you properly document and wireframe also free of cost before this please come on chat so that I can understand your requirement. About us and relevant work I More

$16 USD / hour
(3 Reviews)

Hello. Ping me for more details....

$15 USD / hour
(1 Review)

Hello. I have carefully read your suggestions. I have a wealth of experience to give you a satisfactory solution to your wishes. I worked for many years as a full-time employee of a large company and participated in More

$22 USD / hour
(0 Reviews)

Hi there, Greetings!! My name is Kusal and I am a software engineer from Sri Lankan tech startup. I have read your project description and have understood your requirements very well. Thank you for the detailed d More

$16 USD / hour
(0 Reviews)

I'm a developer and I worked with mysql several time. Can you describe me what is your architecture? In which language do you want the script to be written with? As I can say from the project description, this shouldn' More

$16 USD / hour
(0 Reviews)

Because I have much experience of Database programming with php and python. I estimate this project will take a few days. Thanks. BILL

$22 USD / hour
(2 Reviews)
$15 USD / hour
(1 Review)

Hi there, Good morning I read your requirement, after getting understand i want to ask few question. Are you ok with any scriptin language to finish your work as intended? like PHP, JAVA or you want to use specific More

$16 USD / hour
(0 Reviews)