Perl CSV mysql

Web Programming — incorrectly specified categories?

Project translated automatically. Log in or register, to view the original

Simple task on Perl

We have a file BAZY.TXT with a list of databases in the format *BAZA1.csv, BAZA2.csv, BAZA3.csv, ..*

1) check if the file *.csv exists

1a) If there are no files --> We terminate the program

1B) If the file *.csv exists, we check the file name against the list of databases

3) If the file exists, but there are no matches with the list of databases --> then we delete this file --> ) Then we go to point 1)

3A) If there is a match, then the file (for example *BAZA2.csv), we move it to the folder TEMP_CSV

4) Next, if the name matched the list of databases, we clear the table in the Mysql database (for example BAZA2) and write the data from the file BAZA2.csv into the cleared mysql table

5) Next, we add the Date and TIME to the file name (for example *01.01.2025_03_00_BAZA2.csv), we move this file to the OLDCSV folder

6) Next, we go to point 1)

Proposals 2 Discussions 2

Tetyana S.

75 4

Budget: 1200 UAH Deadline: 1 day

Good day! I have some experience, so I can do it!!!! Feel free to contact me!!!!!

Artur Mileyko

105 0

Budget: 4500 UAH Deadline: 1 day

I can do it
by the time - by Monday it will be
Do you need to run it as a console application or web (locally/online)?

Current freelance projects in the category Web Programming

Refinement of 1C

9 proposals 31 July

Not specified
Need a programmer/specialist in Prestashop.

Online Stores & E-commerce 58 proposals 31 July

Not specified
Reddit API

Data Parsing 26 proposals 30 July

Not specified
Development of AI Creative Studio (AI agents)

AI & Machine Learning 51 proposals 30 July

198 USD
Transfer goods mobile phones and Iphone phones

Content Management Systems 54 proposals 30 July

Not specified

Mikola Mihaylenko
Lvov, Ukraine

Projects -
Rating -
Rating 45

Tetyana S.

Artur Mileyko

Proposals are currently absent

Current freelance projects in the category Web Programming

Refinement of 1C

Need a programmer/specialist in Prestashop.

Reddit API

Development of AI Creative Studio (AI agents)

Transfer goods mobile phones and Iphone phones