Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

...along with some basic metadata like dates and sizes

Should work on windows, otherwise DB and platform/language does not matter much.

Although I can and earlier have scripted stuff like this, I do not have the time now :-)

(What I am trying to accomplish is to analyse many files and folders, find regularities in the folder structure and enumerate every pattern that can be mapped to metadata in a content management system).


For now I did a simple dir /S /N /B into a text file, split it using regular expressions and assembled every line into full path+parent dir+filename separated by tabs. Then I imported it into a database, assigning parent dir as foreign key.

share|improve this question

closed as unclear what you're asking by voretaq7 Aug 27 '13 at 16:25

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.

Are you asking us to do this work for you? Because that's what it sounds like. If you can do this work but are short on time, pay someone to do it for you. – mfinni Aug 27 '13 at 12:43
It seems like it is such a basic task, that I would expect that there were some already existing resources/scripts that could accomplish the task and yes, save me time. – grojo Aug 27 '13 at 12:55
And did you Google for those resources or scripts? – mfinni Aug 27 '13 at 13:11
What specific problem are you trying to solve? A database seems like the wrong tool for this... – voretaq7 Aug 27 '13 at 16:25
I've updated the question, hopefully it is more clear now – grojo Aug 28 '13 at 12:36

This is really a "give me the codez" question, which we hate - but I hope I can help address the actual problem you're trying to solve, which I'm only guessing at.

While this ideally might be simple, I don't think that it's common. I certainly don't have a script like this lying around. If I want to know what's on a drive, I use a dedicated tool like WinDirStat or TreeSize rather than play around writing my own database and analysis tools.

And any implementation would be specific to the DB; at a minimum, you'd need a script to create the tables which is almost always DB specific, and the import script would likely also be DB specific. If I gave you something written in Erlang and it used Progress, would you find that useful at all?

share|improve this answer
Sorry, you may be right that it is too specific. I thought it might be common enough, so there might be some solution hiding somewhere, just "out of sight". BTW I am very familiar with the above-mentioned tools :-) – grojo Aug 27 '13 at 20:43

Not the answer you're looking for? Browse other questions tagged or ask your own question.