AssetCleaner.zip

B

belgian46

Active member

• Sep 12, 2016

• #1

Hello,

Does anyone still have the Assetcleaner.zip? It used to be available on this website https://passingtrains.wordpress.com/2013/08/20/cleaning-up-assets-sql/ ?

I had it on a Usb-stick but unfortunately this usb-stick is no longer accessible

Thank you.

Best regards.

Kurt :wave:

 

O

oknotsen

Holder of a broom

• Sep 12, 2016

• #2

What would that tool do?
Maybe we can explain you how to achieve that without it.

 

S

shaneturner12

Tutorial Creator

• Sep 12, 2016

• #3

From memory it was for removing duplicate information from the assets.sql database file in TS12. I used to have a copy of it but not sure if I still do.

Shane

 

B

belgian46

Active member

• Sep 12, 2016

• #4

shaneturner12 said:

From memory it was for removing duplicate information from the assets.sql database file in TS12. I used to have a copy of it but not sure if I still do.

Shane

Click to expand...

Hello Shane,

Thank you for explaning to Oknotsen. If you would find it, would you mind sending it to me?

Best regards

Kurt:wave:

 

S

stagecoach

75377

• Sep 12, 2016

• #5

http://www.scriptspot.com/3ds-max/scripts/asset-cleaner This site has the scripts for it.

 

B

belgian46

Active member

• Sep 12, 2016

• #6

oknotsen said:

What would that tool do?
Maybe we can explain you how to achieve that without it.

Click to expand...

Hello Oknotsen,

Thank you for your reply. Shane already explaned the purpose of the tool.
However, If you know another method - I can always try it out.

Best regards

Kurt :wave:

 

B

belgian46

Active member

• Sep 12, 2016

• #7

stagecoach said:

http://www.scriptspot.com/3ds-max/scripts/asset-cleaner This site has the scripts for it.

Click to expand...

Hello Keith,

Thank you for your information. Are you using this asset-cleaner from this site http://www.scriptspot.com/3ds-max/scripts/asset-cleaner?

The assetcleaner.zip package which was available on this website https://passingtrains.wordpress.com/...up-assets-sql/ went into the assets.sql ( DB ) and removed duplicate records and also did a compact of the database

Best regards

Kurt :wave:

 

J

JCitron

Trainzing since 12-2003

• Sep 12, 2016

• #8

I have it Kurt if you need it I can email it to you. PM me your email address.

I recommend following the instructions exactly when setting it up.

 

B

belgian46

Active member

• Sep 12, 2016

• #9

JCitron said:

I have it Kurt if you need it I can email it to you. PM me your email address.

I recommend following the instructions exactly when setting it up.

Click to expand...

Hello John,

Fantastic :clap:. I will send you my email address.

I have used assetcleaner.zip several times - but nevertheless I will recheck the setup instructions.

Best regards

Kurt :wave:

 

J

JCitron

Trainzing since 12-2003

• Sep 12, 2016

• #10

Check your email.

John

 

L

leksie

Active member

• Sep 13, 2016

• #11

Hi John , i've sended you also a PM .

 

J

JCitron

Trainzing since 12-2003

• Sep 13, 2016

• #12

leksie said:

Hi John , i've sended you also a PM .

Click to expand...

Yup... Check your email.

John

 

S

sonofham

Member

• Sep 13, 2016

• #13

Cleaning up Assets.sql(Archived copy of site page). I haven't tried to download the file to see if it was archived though.[edit] Tried dl link and the file doesn't exist anymore...

 

J

JCitron

Trainzing since 12-2003

• Sep 13, 2016

• #14

This will not clean up assets; the name is a misnomer and this is strictly a TS12 assets.tdx database clean up utility. What this means is it re-indexes and removes duplicate pointers, and empty records from the database file.

TRS2004 does not have a database, or one that works in the same fashion as the assets.tdx file was introduced in TRS2006.

 

L

lackoo11111

Member

• Sep 9, 2019

• #15

Tested .

It isn't working on my Win10 x64 system .

 

J

JCitron

Trainzing since 12-2003

• Sep 9, 2019

• #16

lackoo11111 said:

Tested .

It isn't working on my Win10 x64 system .

Click to expand...

I doubt that it will work. It was written some years ago before Win 10 came out, and it definitely doesn't work for T:ANE and up because the database structure has changed.