Flatten out svnaccess

Hello SVN users,

We're looking to integrate svn access info into some reporting systems, but its almost impossible to use information from svnaccess to join with other sources.
The reason is that there are no structured relation between groups, users, repositories and permissions.

So I'm looking how to get it flattened, to have something like this:

user1 | group1 | repo | path | permissions
user2 | group1 | repo | path | permissions
and so on...

So far I managed to get first two cols, after massaging svnaccess file with combination of sed, grep and awk.
Then it become obvious that getting last three will be a problem.

Does anybody know if its possible to get this file transformed into something more sql friendly?

Thanks,
--Roman Naumenko
_______________________________________________________________________

This email is intended only for the use of the individual(s) to whom it is addressed and may be privileged and confidential.
Unauthorised use or disclosure is prohibited. If you receive This e-mail in error, please advise immediately and delete the original message.
This message may have been altered without your or our knowledge and the sender does not accept any liability for any errors or omissions in the message.

Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent.
Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite.
Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen.
Received on 2014-04-25 21:53:04 CEST