Clean Up Photos and Documents Referenced by SQL Server DB Tables

Fermé Publié le il y a 2 ans Paiement à la livraison
Fermé Paiement à la livraison

See Excel file for details.

1st

For each record in a GREEN tab, determine if the URL targets a file that exists. If it does mark "File Exists" column with a Y. If the target file does not exist mark it with a N.

For each tab's corresponding ORANGE folder, crawl the full folder structure and identify orphan files that do not have a link in the corresponding excel tab

2nd

Once the above two items are complete, CLIENT will update the BLUE tab in the excel for the developer. CLIENT will list files and a target folder organization. Grab all files, organize them according to CLIENT spec and upload them to target server. Confirm they are viewable.

Deliverables

1st : an updated Excel file with:

Y or N for each record on a GREEN based on if the file exists

List of files that aren't referenced by a record (Orphans) on each ORANGE tab

2nd : organized folder of document and photo files that are accessible via server according to BLUE tab. BLUE tab will be completed based on the 1st .

Python Script Shell Développement de bases de données

Nº du projet : #32068351

À propos du projet

5 propositions Projet à distance Actif il y a 2 ans

5 freelances font une offre moyenne de 168 € pour ce travail

freelancerIrvan

Hi there, I am a talented python dev, and I suppose I can handle this task successfully. Please let me know more details, and Please give me your chance. I look forward to hearing from you. Plus

€139 EUR en 7 jours
(11 Commentaires)
5.2
umairkaramat24

Hello sir how are you doing? I have read the project detail and really interested in your project, I am full stack developer with multiple frameworks, I have great experience doing similar jobs regarding to these skill Plus

€250 EUR en 12 jours
(15 Commentaires)
4.6
SamRamadan

Hello, I believe I can help you with this project. I have been working as a python developer for more than 3 years and I'm certified as a professional data analyst, therefore, processing the data and automating the w Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% EUR en 1 jour
(17 Commentaires)
4.4
rudieri3127

Trabalho com docker e linux e python sou programador a 2 anos , entre em contato comigo se gostar do meu perfil

€140 EUR en 7 jours
(0 Commentaires)
0.0