[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: Antw: how to use tsvn with excel & vba

From: Friedrich Brunzema <brunzefb_at_yahoo.com>
Date: Wed, 12 Jun 2013 05:48:01 -0700 (PDT)


Nice thought experiment, but I don't think it is going to work.  Subversion is based on the idea of storing and versioning files - you put something in and if you ask for it later you get the file back which is byte for byte the same.  Unzipping and storing the bits and re-assembling very likely means you can't get a byte-for-byte comparison match.

Also think about what happens when someone browses the file through http.  Instead of seeing the file, they see a directory, which contains the streams inside the zip.  Because you can have "directories" inside a zip file, what do you do - create an entire directory tree in svn?

If all you wanted was keyword expansion for Word/Excel/Powerpoint, I think it should be implemented differently (using the OpenXml API), and not in TSVN - either in subversion itself, or in an external program like SubWcRev. But is the feature really that useful for office docs?  Other rev. control systems like Git don't even have keyword expansion.



 From: Gunter Koenigsmann <Gunter.Koenigsmann_at_semikron.com>
To: dev_at_tortoisesvn.tigris.org
Sent: Tuesday, June 11, 2013 3:10:54 AM
Subject: Antw: how to use tsvn with excel & vba

Instead of saving things outside of excel to get them saved in a text
format I always dreamed of a pre-commit-hook that works on the fact that
technically a docx file from word or a xlsx file from excel-file is an
ordinary zip archive. to get things like svn:keywords working it would
suffice to
- unpack the zip-archive before committing
- and zip it again using zero compression ( for the command line zip
utility the command- line flags that do this would read "-Z store" or
shorter "-0".
Additionaly setting the compression to zero would mean huge space
savings on the server:
- Subversion internally uses compression for storing files so the
files won't be saved in an uncompressed state on the server
- and subversion only stores the differences between the old and the
new version. If you change just a single word in an uncompressed file
chances are high that the change affects only a single line that
therefore has to be stored on the server.
  If the file is compressed, file chances are high instead that
changing a single word in the uncompressed will affect the whole
structure of the result of the compression so subversion will have to
store big portions of a file regardless how efficient it normally is in
handling binary files.


Gunter Königsmann

Tel:    +49 911-6559-6025
Fax:    +49 911-6559-776747
SEMIKRON Elektronik GmbH & Co. KG     
Sigmundstrasse 200, 90431 Nürnberg, Germany           
Amtsgericht Nürnberg HRA 13650
SEMIKRON Elektronik Verwaltungs GmbH
Amtsgericht Nürnberg HRB 21338
Thomas Dippold
Peter Frey
Harald Jäger

IMPORTANT NOTICE - The contents of this email and attachments are
confidential. If you are not the intended recipient you must not use,
copy, distribute or rely on this email and should please return it
immediately or notify us by telephone. While we take every reasonable
precaution to screen out computer viruses from emails, attachments to
this email may contain such viruses. We cannot accept liability for loss
or damage resulting from such viruses.  The integrity of email across
the Internet cannot be guaranteed and SEMIKRON will not accept liability
for any claims arising as a result of the use of this medium for
transmissions by or to SEMIKRON.

This email has been scanned by the Symantec Email Security.cloud service.


To unsubscribe from this discussion, e-mail: [dev-unsubscribe_at_tortoisesvn.tigris.org].


To unsubscribe from this discussion, e-mail: [dev-unsubscribe_at_tortoisesvn.tigris.org].
Received on 2013-06-12 16:06:54 CEST

This is an archived mail posted to the TortoiseSVN Dev mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.