Database for Sim City 4

[AKPSV]

Hello,

My English is not so good. For this reason, I have translated the Readme with Bing.
That hope is understandable.

Since I have long got to thinking how I organize my Pluginordner best I came me the idea to create a database for it. In this, I entered the data of the bats and lots and fitted with an image. Over time more and more was added so that you organize them for the can use the reactivate. At the time, 418 records contained in the database. By far not all are, I could use help to populate the database.

Sim City 4 Database   with Access 2007

Data from Bats and Lots manage

The data can be managed with this database for SimCity 4.
Because it is not always easy for the one or the other player where the data of lots and bats come here because I've bothered me to create a database. I tried to keep the database as easy as possible.
The database to all players  help to organize their Pluginfolder and give an overview of the values of  the bats and lots.

The Main Screen



The forms are called from here. With click on the yellow font. For readability, it is blue background
Click to help for the Readme file
Click to Data input for about the Data in the register
Click to Datasets for information the Data from hard disk
Click to Search for the searching the Lots and Bats

Datainput



Here, the bats and lots all relevant data are entered.
I have the values of lots and bats from the Readme files.
To display the image, the image path is opened and taken over by clicking on the image file. Only image files can be displayed. The same works with the file path. Here, the location of the zip file is displayed.
The dependencies are partly traced back to SC4 tool and from the Readme files.
The database file path is "D:\SC4-DB\".
To keep the database as small as possible, only the values in the DB are stored.
The image files and I are stored on the hard disk in the file structure of the DB. I have the following bulk created:

D:\SC4-DB\ = main path of the database
D:\SC4-DB\SFBT\ = drop of the Readme files from the SFBT-Team
D:\SC4-DB\SFBT\Images\ = drop of image files that belong to the Readme
D:\SC4-DB\SFBT\Dateien\ = drop of the Zip file

The paths of the files of that are set in the VBA code. Be changed but without problems. To open the form in Design view. Open with a right-click on the respective buttons for image path, file path and Readme or Readme, then click event, now opens the respective code of buttons.

Now the line search in the stands:

With fd
   .InitialFileName = "D:\SC4-DB\"
   D = drive; SC4-DB = folder;

The path is modified between the quotation marks.
The same applies to the two other buttons "File path and Readme".
Whom this too cumbersome is simply the line (.)(Initial Filename) delete. Now opens at the click on the button "default open dialog" Windows.
Data entry is simplified with combo boxes. Where the values are predefined and can be selected by clicking on the small arrow.
PluginPackID

I have found the plugin Pack ID using the ILiveReader. To do this I have installed an Excel table me in which the conversion takes place. Access offer unfortunately no solution. Therefore I have installed an Excel table me in which I enter the hex value and leave the convert. The ID appears usually when loading a city when a lot or bat is missing. The error message shows the ID in decimal to.

It can also occur, lacking the a lot but no ID is displayed.
for example: SFBT_Rehhofstr. 16, is missing in the game, is not displayed when loading.

The PluginPackID shall automatically be converted. Just enter the hex number and press tab.

There is in addition to creating a form to a creator or a category just for creator and category. Simply click the button new to.

Readme: Here you can enter the description in the Readme.

Comment: Here can additional information entered or copied from the Readme.


Downloads

In the form, the most links to SimCity downloads are listed. The call is made in the form of data entry button downloadside.

Records



It displays only information.
Show files can open you a folder to view the contents. Capacity of the disk and the disk space available is rendered, so that you have the current state. SimCity Plugin folder shows the size of Pluginfolder under documents. Including the total size of the database is displayed.
Number displays the number of records of the individual creator or team.
Under size in Megabyte, the size of the folder of files is displayed.

If you are looking for a dependency, which appears with the SC4 tool or is listed in a Readme file, you can look. Just type the file name in the combo box, or open the list by clicking on the arrow. Because the list is very large, I recommend the name typing.

The form is called dependencies in the data entry form with the button.
This list is of me completely with dependencies that I for example: SC4Devotion and Simtropolis have filled. This, I create a list which I then insert into an Excel file with a program. It is then imported into access.
I created the same form also for the plugins. The operation is the same.
The form is called with the plugins button in the data entry form.

Number:  Number of Records from the Creator

Search of bats and lots

In the search form, you can by 7 different criteria view the lots and bats. It is entered in the search criteria. There are the following available:



Building: Name of the the building

Lot size: Input - 1x1, 2x1, 3x1, 5x2, 3x3, etc.

Constuction style: Input - all, EUR or Hou is Europe, Houston, etc.
We must not all write out

Density: Input - 0, 1, 2, 3

Creator: here the name of the creator can be entered to see the lot.

PluginPackID:

Here the error number is in decimal displayed when loading the city is entered.
Now it is possible, if a plugin is missing when loading a city and displayed the number they will enter in the search box, and if the plugin exists, it is displayed.
The plugin numbers are unique and can be entered not double.

If you enter anything in the search fields, all records are listed. It is also possible in only a portion of the value of the search admitted. Then, the records appear where the part is present. Example: If you are entering in PluginPackID a4, all records where a4 is present are displayed. The input of the density is subdivided into  0, 1, 2 and 3. Thus, a unique assignment of the corresponding lot can be and reach bats.

Dependencies




If you are looking for a dependency, which appears with the SC4 tool or is listed in a Readmefile, you can look. Just type the file name in the combo box, or open the list by clicking on the arrow. Because the list is very large, I recommend the name typing.
The form is called dependencies in the data entry form with the button.
This list is of me completely with dependencies that I for example: SC4Devotion and Simtropolis have filled. This, I create a list which I then insert into an Excel file with a program. It is then imported into access.

Suggestions and criticisms are welcome
If you are interested send a message to me.

greeting Andy

[catty]

Hi AKPSV

  for your efforts and also happy birthday   

At the time, 418 records contained in the database. By far not all are, I could use help to populate the database.

I am setting up something very similiar over here

http://citybuilders.co.nz/index.php/database

its currently read only, at some point in the future it should be something that people can add to themselves, you are more than welcome to export the data for your own database   

I'm also cataloguing the SC4 Plugins and the sites they are on

http://citybuilders.co.nz/index.php/all-items

I think it would be possible to export this data out for you (a bit more difficult as the data is in a number of different databases), but do-able if you wanted any of it.



-catty

[AKPSV]

Thanks für all,

Because I've now completed my database I just can it now here. I hope that you one or the other is helpful in mapping the plugins and the build of the Pluginfolder.

Here the Link to the Database

http://www.file-upload.net/download-7608242/DB_englisch.zip.html

Greeting Andy

[catty]

Its taking a while to download due to its size, but I'll take a look when it finishes downloading and let you know.

EDIT: Can't open the access database unfortunately

[AKPSV]

Have you Microsoft Office 2007?
When Not - Download the Microsoft Runtime For Access 2007.

Greeting Andy

[catty]

Have you Microsoft Office 2007?
When Not - Download the Microsoft Runtime For Access 2007.

Greeting Andy

I use Microsoft Office 2000 which I'm quite happy with, I use OpenOffice for anything that can't be opened by MS2000.

I'll take another look at my OpenOffice set-up, but I do have a lot on so not sure when that will be

-catty

[Magneto]

Had no trouble opening the files with open office 3. Thanks for the database Andy! 

[AKPSV]

Hello,
I'm looking for a programmer for my database. Even against payment!
Programming languages:
Visual Basic or VB.Net or others that I can call a button.
I've created my database with Access 2007.
He should write me a code with which I can read the information from the SC4 plugins so how it works in the reader.
The code is for my database and should include the following:
Open file dialog - to the open the folder and select the file
Read the info - line
Save the Information in the database or in an Excel table

I'd like help

Greeting Andy

Sorry for my english - translate with Bing

[catty]

Hi AKPSV

First of all sorry I never did get any time to look at your database, secondly the links I originally provided are now out-of-date

I am setting up something very similiar over here

http://citybuilders.co.nz/index.php/database

its currently read only, at some point in the future it should be something that people can add to themselves, you are more than welcome to export the data for your own database   

I'm also cataloguing the SC4 Plugins and the sites they are on

http://citybuilders.co.nz/index.php/all-items

You can now find it here

http://city-builders.info/catalog

It got about sixteen thousand plugins listed in it now ... still growing when I have the time to add to it

thirdly if I read your post correctly I'm not sure that's do-able, but its been quite some time since I did anything in Visual Basic and that was using an older version of MS ACCESS, so hopefully someone who has more up-to-date knowledge will give you an answer.

-catty