category vs type

[martinvk]

In Content Manager, the one of the columns is TYPE.
In the custom filters, there is no TYPE but there is a value CATEGORY which is similar but not quite.

Is there a way to filter for just a specific TYPE? And why the almost overlap in results?

 

[stagecoach]

CM type = lists the asset type they come under in general.
Category = lists all assets in a more advanced type. It breaks down the CM type into smaller sections. Use this to select the type you are looking for.

 

[Dinorius_Redundicus]

Annoying isn't it? The only way I know of is to sort on the column heading TYPE and scroll to the one you want.

 

[pware]

I have always been puzzled by the distinction between the types "Built-in" (which I understand) and "Base" (which I do not)

 

[martinvk]

Seems par for the course, built-in, base, category, type. Makes one wonder if they really know the consequences when these are introduced and then not used 100%. Like they get a new gang in and they have to justify their work by adding another distinction. Anyone remember region, era, class?

 

[Dinorius_Redundicus]

The addition of a Kind column and/or search filter would be nice too.

 

[stagecoach]

The CM type column for instance shows train as one type. This includes locos, rolling stock, vehicles (driveable), ships and planes. The filter category splits this into two sections: locomotive or rolling stock

I have always been puzzled by the distinction between the types "Built-in" (which I understand) and "Base" (which I do not)

I think Base are the original assets installed when you first install Trainz
Built-in are other assets that have been added since the original install. These coming from updates of the versions. Go back to disk versions, the base would be what came with the disk and built-in newer assets that came with upgrades.

 

[martinvk]

All well and good but my issue is that the filter list doesn't include things like STATUS, TYPE which are column headers.
Speaking of which, Is there was a way to export more than just the name and kuid to be able to do some data analysis?

And then there is KEYWORD. There is a category-keyword in the config file which is sometimes used. But objects without this are also selected with the same keyword. Duh.

Did anyone ever write a front-end for the trainz db so we ca do a proper query?

 

[JCitron]

All well and good but my issue is that the filter list doesn't include things like STATUS, TYPE which are column headers.
Speaking of which, Is there was a way to export more than just the name and kuid to be able to do some data analysis?

And then there is KEYWORD. There is a category-keyword in the config file which is sometimes used. But objects without this are also selected with the same keyword. Duh.

Did anyone ever write a front-end for the trainz db so we ca do a proper query?

I wish we could write our own queries. The database uses MySQL-Lite and that would be easy to write a query using Excel or Open Office by linking tables, but not so fast because the database is encrypted preventing any kind of access to the information. It's not like there is direct access to the data, it's only the database records. Yes, I know the user information, including password is stored in there but there are ways of hiding that information from queries.