How do I copy only parcels modified since last transfer?

There are two things you need to do:

1) Go into the options and (on the General tab) put a check next to "Only Export Edited Parcels Since Last Transfer". The panel beside the check box will show you the date you last ran the GisWeb.exe. When you check this the program will look for parcels edited after this date. (specifically it will add general.editdate >= :date to the sql statement).

2) If you now run the GisWeb it will only dump recently edited parcels. In version prior to 1.7 the database will be emptied first, in 1.7 and after you have an option to specify. If you are dumping sketchs or photos to disk it will NOT empty the directories first. If you are dumping photos or sketches to disk you will probably want to delete all the files first before you run the GisWeb.exe.

In summary, it will empty the database but not the photo or sketch directories.

How do I setup autorun?

First a warning: when you start the program you can log into working or certified. And to setup autorun, you can choose working or certified. Make sure they are the same. If your going to autorun with certified, log into certified! The reason for this is because the PDF's might be different between working and certified. Working PDF 1 might be residential but Certified PDF 1 might be commercial.

1. decide what database you're going to autorun on. Lets pretend you choose certified.
2. run the giswebx.exe program, choose certified from the dropdown menu, enter your username/password and login
3. Click on the options toolbar button.
4. Setup the options on the general tab (pdf's, save photos and sketches to a file, etc)
5. Click on the "Servers" tab, and in the "AutoRun source database" box select the certified database.
6. Setup the destination database stuff, and "OK" out

These options are saved, and used in autorun. I'd recommend running it once right now just to make sure it all works. Once you have it going like you want, now we can try autorun. Just add a commandline argument "-autorun" to the program, and it will autorun.

One way to do that is to create a shortcut to the executable, then edit the properties of the shortcut, and in the Target, and "-autorun" at the very end. Then when you double click on the shortcut it will autorun.

You probably want to schedule the program to run after hours. In the scheduling software set the program as: "giswebx.exe -autorun"
If you have more questions you can check the help file, and, of course, you can email me, andy@camavision.com.

How can I see the Firebird Data?

www.ibphoenix.com is the place to go. There are a bunch of tools listed that will let you connect to a database and fool around with it.

A google search usually turns up some good stuff too.

IBExpert has a nice "Free" personal edition, if you can find it.
FlameRobin is nice too

Where is the ODBC Driver?

www.ibphoenix.com is the place to go. There are other odbc drivers, some free, some from companies. This is the only driver I have ever tested, and it has worked fine for me.

Go for the version 2 stuff, I know its still in beta, but its stable, and works in more places than the 1.3 stuff.

How do I get the ODBC driver to connect?

First, and very important, you cannot use a share name, or shared drive! When you setup the ODBC driver, it will have a spot for a connection string. The connect string uses the format:

server:c:\path\on\server\file.ib

The username and password are sysdba and masterkey.

For example, in our office we have a server named torgo. It has a D:\dbs folder where we keep all the databases. So from my workstation (in fact, from all workstations), I would use the following:

Connect String: torgo:d:\dbs\gisweb.ib
Username: sysdba
Password: masterkey

Cant GisWeb.exe just convert the data to MS SQL Server?

Why, actually, yes, it can. (Sorry Pete, should'da thought of it sooner)

The first thing you need to do, however, is create a database to use. The gisweb.exe program can create the tables and data, but wont create (or drop) the database. (This is different than firebird because it can drop and re-create the entire database)

So, first, create a gisweb database (for example). Second thing you need to worry about is the username/password. If you are using windows authentication, then leave the gisweb.exe settings blank. If you have created a sql server user, then copy that info into the gisweb.exe settings.

The connect string (in the gisweb.exe) will need to be set to:

server:dbname

Its close to the firebird method, without the path. So if I have created a gisweb database on my ms sql server on torgo, and I'm using windows authentication, I'd use these settings:

Connect String: torgo:gisweb
Username:
Password: