Fog Creek Software
Discussion Board




Knowledge Base
Documentation
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

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

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 02, 2002

Good idea, thanks.

Patrick

Patrick Thomas
Saturday, May 04, 2002

*  Recent Topics

*  Fog Creek Home