Clean Up Photos and Documents Referenced by SQL Server DB Tables.
Budget: $30 – $250 USD
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, identify orphan files that do not have a link in the corresponding excel tab
2st:
- Once the above two items are complete, CLIENT will provide developer with a list of files and a 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.
- 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, identify orphan files that do not have a link in the corresponding excel tab
2st:
- Once the above two items are complete, CLIENT will provide developer with a list of files and a 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.