Fog Creek Software
Discussion Board

Knowledge Base
Terry's Tips
Darren's Tips

Template Distribution in LAN ?

What would be the most efficient way to handle the distribution of corporate template updates among, say 30 CD users on a LAN (more precise: among say 6x different CTY files on different LAN paths) ? Not manual by the user of course but transparent and automatic.


Patrick Thomas
Tuesday, April 30, 2002

The best way would probably be to write VB code that sync'd the database tables.  Its fairly straightforward database access code since the .cty files are really just MSAccess database files...

Customer Service
Tuesday, April 30, 2002

Does anybody care to develop ?

update.exe <sources_and_targets_descriptorfile>

And share or license ?


Patrick Thomas
Tuesday, April 30, 2002

Here's something you might want to experiment with; requires some Access knowledge and I don't guarantee that it will work :)

1. Create a new Microsoft Access database, call it TemplateRepository.MDB.

2. Copy two tables from a .CTY file into that database: the Template table and the TemplateStructure table.

3. Now go into the .CTY file and delete those tables. Replace them with link tables that point to the tables in TemplateRepository.MDB.

4. Repeat step 3 for all the .CTY files

5. Now all your .CTY files will share the same templates. Editing templates in one will affect all the others.

Joel Spolsky
Thursday, May 2, 2002

Good idea, thanks.


Patrick Thomas
Saturday, May 4, 2002

*  Recent Topics

*  Fog Creek Home