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

เสร็จสมบูรณ์ โพสต์แล้ว 5 ปีที่ผ่านมา ชำระเงินเมื่อจัดส่ง
เสร็จสมบูรณ์

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.

การเขียนโปรแกรมฐานข้อมูล MySQL

หมายเลขโปรเจค: #17597794

เกี่ยวกับโปรเจกต์

9 ข้อเสนอ โปรเจกต์ระยะไกล ใช้งาน %project.latestActivity_relativeTime|แทนที่%

มอบให้กับ:

jmelillo

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 เพิ่มเติม

$19 USD / ชั่วโมง
(7 รีวิว)
4.0

freelancer freelancer 9 คน กำลังเสนอราคาในงานนี้ โดยมีราคาเฉลี่ยอยู่ที่ $17/ชั่วโมง

meet2amitvw

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 เพิ่มเติม

$20 USD / ชั่วโมง
(85 รีวิว)
8.7
langlangFan

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 เพิ่มเติม

$20 USD / ชั่วโมง
(8 รีวิว)
5.1
achrafchiboub

Hello. Ping me for more details....

$15 USD / ชั่วโมง
(3 รีวิว)
3.4
kusaldiss

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 เพิ่มเติม

$16 USD / ชั่วโมง
(0 รีวิว)
0.0
MathieuVDP

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' เพิ่มเติม

$16 USD / ชั่วโมง
(0 รีวิว)
0.0
krushsonar9

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 เพิ่มเติม

$16 USD / ชั่วโมง
(0 รีวิว)
0.0