<div dir="ltr">All sounds good to me, before we imported tons of files manually under the account Anonymous when there was this issue so we could keep track. But, as long as these imports are tagged in a special way so librarians could help go through them manually, I think that is the crucial part.<div> </div><div>Cheerz on the housecleaning! </div><div>Jon</div></div><div class="gmail_extra"> <div class="gmail_quote">On Tue, Mar 12, 2013 at 10:23 AM, Wolfgang Spraul <<a href="mailto:wolfgang@fabricatorz.com" target="_blank">wolfgang@fabricatorz.com</a>> wrote: <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">OK I have continued some cleanup, roughly summing up: *) deleted about 500 .svg files that had pd_issue set in the database, but were still present in the filesystem (and publicly accessible). Also deleted about 4200 derivative .pngs of those pd_issue graphics *) imported about 500 old cch graphics into the database, and deleted about 1000 duplicates of those graphics (see earlier mail) *) renamed about 200 files with .SVG (capitalized) extension that didn't show up in the database. The database had a few (13) .SVG graphics which I also renamed to .svg. Going forward, I will try to disable .SVG (capitalized) or auto-lowercase for new uploads. Now I am looking at 6308 .svg files that show up in the filesystem, but not in the database. They belong to the following users: 962 ArtFavor 785 Anonymous 176 inky2010 88 rejon 84 gustavorezende 80 pianoBrad 73 Gerald_G 69 brandynne 68 slanteigne 66 Merlin2525 62 jiangyi_99 57 cibo00 54 gsagri04 52 boobaloo 51 10binary plus another 856 users with less than 50 graphics, for a total of 6308. Any idea what that might be? I think I will roughly do this: 1. make sure that all those users exist in the database, if not create them. 2. check some graphics manually to understand whether they are old 'problem' uploads, spam, non-pd, duplicates, etc. 3. import all those 6308 into the database same as I did for the 'cch' user this morning. The problem with #3 is that unlike the cch import, this one will be harder to reverse once I did it. In the cch case, it's all listed under that specific user. But for these 6308 graphics, they are spread out among hundreds of users. So once I import them, they will be everywhere and if there are problems with those graphics, they would need to be flagged pd_issue etc. and then deleted again. Feedback? _______________________________________________ clipart mailing list <a href="mailto:clipart@lists.freedesktop.org">clipart@lists.freedesktop.org</a> <a href="http://lists.freedesktop.org/mailman/listinfo/clipart" target="_blank">http://lists.freedesktop.org/mailman/listinfo/clipart</a> </blockquote></div> <div> </div>-- Jon Phillips 王✳ <a href="http://fabricatorz.com" target="_blank">http://fabricatorz.com</a> ✳ skype: kidproto ✳ irc: rejon +1.415.830.3884 (global) ✳ +86-187-1003-9974 (beijing) </div>