Send feedback to moc.xmg@8491c. Only about the app's latest release (4.2.1) and attaching a screenshot of the Help|About menu item
Please read this first
The answers below are intended exclusively for the latest release of MMCC, which is currently 4.2.1
Before going on, you may want to check the version you are using. Don't be afraid to update it if necessary
The most frequent questions
Where can I find my data files on the computer? Question #76
What if all my data is missing after installing an update? Question #60
What's this mess about Administrator and Limited users? Question #74
After installing MMCC, I get a number of error messages... Question #71
1. Is MMCC really free of charge?
| Yes, it's free of charge for you to use for an unlimited time, with some restrictions explained in the license agreement that you must accept before installing the application (and can still read from inside it): not for sale, no warranty given, no internal modifications allowed, and so on. |
|
2. How can I run the application on my macOS or on a Linux/Android system?
| There are two essentially different ways:
1. By creating an independent virtual machine that insulates a Windows box on your macOS or any Linux distribution (Android is based on the Linux kernel, after all). Within this box, you will be able to
run any Windows program on your computer the same way you would do it in the native Microsoft operating system. You can easily have such a virtual
machine working by just installing VirtualBox on your system, which is a free product from Sun Microsystems. Please go to the
VirtualBox site to get more info and download the
software. Parallels Desktop and
VMware Fusion, designed specifically for macOS at the time of writing this, also create hardware
virtualization for running Windows software on your computer.
2. With the help of Wine or
CrossOver, which act as an intermediate layer to encapsulate a Windows
environment. Wine is free of charge and works fine but is not perfect yet, so expect to see rather old-fashioned buttons and some odd
color tones, and probably the internet links not working. But the application's main functions should operate properly.
|
|
6. What are the screen resolution requirements to run the application, and how can I change them if necessary?
| The screen must be able to work with a width of at least 1280 pixels and a height of at least 1024. Smaller sizes may truncate some of the MMCC forms. If you need to change it, close all the applications that may be running, place the mouse pointer near the center of the screen, make a click with the right button to open the Properties dialog, select the Configuration or Settings tab, and set the screen resolution to at least 1280 pixels wide and 1024 pixels high. |
|
7. What is the best place I can choose to make the backup copies of my data?
| It's strongly recommended to make them in a drive other than the one where the program is installed. It can be either a second local drive (HDD or SSD), any network drive, a USB flash memory stick,
aka pen drive, or a memory card that is available in most computers to prevent losing your data in case of mechanical or logical failure of the drive where the application and the user files actually are. If you don't mind other people snooping on your data, send your backup copy to the cloud. Read also the question #12. |
|
8. Can I import all my database into MS Access?
| Unfortunately, the answer is no. There is no possibility of importing data from other formats unless you are able to convert it to Paradox with the same field structure that MMCC uses. Not an easy task if you are not an expert in database management and lack the tools to do it. Developing a standard procedure to automatically perform that kind of operation is quite difficult, highly time-consuming, and must be done on an almost case-by-case basis, given the number of existing formats and, above all, the multiplicity of field structures each one can have. |
|
9. The inflation rates or consumer price indexes (CPI) included in the application are very different from the ones registered in my area.
| You can edit any or all of them by opening the inflation database file (menu item Utilities > CPI adjustment) and overwriting the existing values. Then click the Utilities > CPI adjustment menu item for the field Current cost of every specimen to be recalculated. When the rate of a new year has to be added, just open a new record by pressing the down arrow in the last line of the grid, enter the year and the rate, and repeat the recalculation. Go to the website of your local government to get the real inflation data recorded in your area. |
|
10. What is the purpose of the CPI adjustment function?
| As explained in question #9, this function makes a full recalculation of the field Current cost, on a record-by-record basis, to adjust them for inflation. It only needs to be run once when some change has been made in the inflation database; otherwise, the prices will be recalculated but not changed. |
|
11. What is the Reindex function for?
| As you surely know, the specimen database file can be ordered by different criteria, and that order is saved in several auxiliary files technically known as index files. In certain circumstances, they can get corrupted, and then the reindex function comes to the rescue by simply rebuilding them. You don't usually need to perform this operation unless you notice some strange behavior when ordering the records or an error message is shown when opening the database files or changing the order. You can choose between a regular and a clean reindex (this one works by deleting the preexisting index files). Any reindex operation also rebuilds the index files linked to the species, contacts, and inflation database files. Read also question #57 for more details. |
|
12. How do I proceed if I ever need to restore the backup copy?
| Close the program. Then copy all the files from the folder where the backup is to the folder where the application is installed. Allow them to overwrite each other (and be very careful not to perform such an operation in the opposite direction). You can learn which backup folder it is by opening the Help > About... menu item, Backup copies. Your backed-up files will be found within a folder with a name equal to the current year, month, and day separated by a hyphen inside another folder called Minerals.bak. Copies made on the same day will be overwritten. Otherwise, they will be kept indefinitely. |
|
14. How do I move a column or change its width?
| Drag the title with the mouse to move it. To change the width, put the cursor on the title, just over the right border, and drag left or right. The new positions of the columns, if moved, are not persistent when opening the application again, but the new widths are kept for further sessions. |
|
15. Where are the user's settings stored, and how can I reset them?
| All these settings, grid column widths included, are written
in the configuration file minerals.ini, which can be found in the MMCC folder. To reset them, close the
application first and then delete the file. In Windows 7, 8.x, 10 and 11, look for that file in the deep folder
\Users\[UserName]\AppData\Local\VirtualStore\Program Files (x86)\Minerals, where [UserName] is, you guessed it, the name of the user
on Windows. However, you will need administrator permissions to open it. |
|
16. What is the difference between the fields Original cost and Current cost?
| The first cost is the amount you paid for the specimen at the moment of purchase. The latter means this same cost has been adjusted for the inflation that has been registered since then. It can be quite useful, specially with pieces bought many years ago, to get an idea of how much money they would be worth today. |
|
20. What is the best way to have multiple rows selected?
| Hold
down the Control key and click each of the rows you want to select. If the rows are contiguous, hold down
the Shift key with your left hand and press the up or down arrow key. Combinations of both procedures can
also be used. Just try it and get some practice. The selected rows will be enhanced with a blue color, and
a dot will be visible in their left margin. This operation may be useful for having a printed report restricted to
only certain records and for summing up the cost, or the mass, or the appraisal value, of a number of selected
records. |
|
22. Sometimes I find the field Country too short. Could it be widened?
| The actual field in the physical file has room for 12 characters. But it seems they are enough. There is no need to write Lao People's Democratic Republic or People's Republic of China if you can write just Lao or China, or United States of America and United Kingdom instead of the more common USA and UK. You can even enter an acronym or abbreviation that you like or find to be more mnemotechnical, since a country may have other meanings. For many people, it must not necessarily be a nation-state because there are territories that can also be considered countries without having that rank. |
|
23. Would it be possible to add several more fields, like chemical formula and class, Dana and Strunz numbers, crystal system, synonymy, etymology, and the species name in more than one language?
| Given that that information is common to all specimens of a single species, it seems redundant to repeat it in each record. If you owned fifty pyrites, were you going to include in your file such an amount of data multiplied by fifty? This is nowadays an inefficient way of storing information and may even be a waste of time as well. I think that you should never include any detail in your catalog that is already easily found on the net or in any reference book. As you may know, the program puts at your fingertips specific direct links to the major mineral databases on the internet, which can provide you with all of that and much more in a matter of seconds. For free!
- See also next question #24. |
|
25. What are the size (or maximum length) and type of each field?
| The maximum length is shown in parentheses after every field name. The fields whose type is string (aka character or alphanumeric) are Number / ID (8), Main species / Specimen title, Species 2, Species 3, Species 4, Species 5, Species 6, Species 7, and Species 8 (25), Description (200), Location (10), Locality (120), Country (14), Provenance (75), Condition (12), Rating (2), Label price (9), Buy price (9), Size (30), Largest crystal (60), Appraisal by (50), Free field 1 (60), Free field 2 (60), Free field 3 (60), Images and videos (64). Acquired and Appraisal date are of date type. Original cost, Current cost and Appraisal value are currency. Mass is numeric (or float) with two decimal places. Marked is logical or Boolean. And the type of Notes is memo, a field that contains plain text (text without formatting), the field size being very, very large. |
|
26. Could the size of any given field be enlarged?
| No, this is a task that the user cannot do by themselves. Not only would the application have to be internally modified and recompiled, but the structure of the actual file that contains the data (whose name is minerals.db) would have to be changed too on every computer where it resides. |
|
28. What are the meanings of the fields Label price and Buy price as opposed to Original cost?
| There are two major differences between them. Label price can be defined as the labeled price, the price at which the specimen was tagged when it formerly had been for sale, and Buy price, the price really paid after the discount, if any. A switch of currency is now frequent, so you can buy, for instance, in euros but your credit card may be finally charged in dollars, which will be the Original cost. And sometimes you negotiate with (and obtain from) the vendor a discount on the requested price. In both cases it may be interesting for many collectors to keep record of what the Label price and Buy price were at the moment of purchase. |
|
29. What are the user file names? I mean the files where the data I'm entering is actually stored.
| They are named Minerals and Deleted, with the extensions db, mb, px, x??, and y??; Infl, with the extensions db and px; Species, with the extensions db and px; Filter.db; and minerals.ini. But don't be worried about the risk of losing them. All these files are included in the backup utility, so every time you execute it, they are copied to the folder you set in the Utilities > Preferences... menu. |
|
33. Can your program take, in its field Number / ID, dots or periods (.) or hyphens or slashes (-/)? Will it take letters as well as numbers?
| Yes, you can type there any character, number, uppercase letter, dot, hyphen, slash, etc., except lowercase letters. |
|
34. Can fields that are not used be minimized?
| If you mean hidden, the answer is no in the edit form, but yes in the grid or main screen. To hide a field in the grid, drag to the left as much as you can the column's right border by placing the mouse cursor on the title. Do the opposite to make it visible again. This state will be kept for future sessions of the program. |
|
38. I found a minor bug related to the Order by number function, in the sense that if you write 1, 2, ..., 10, ..., 124, etc., the program will misunderstand and order them as follows: 1, 10, 11, 12, ..., 2, 20, 21,... etc.
| That's not a bug. The field Number / ID is not really numeric but alphanumeric. This means you can write in all kinds of characters, digits, uppercase letters, punctuation signs, etc., even spaces, except lowercase letters. Therefore, the digits are considered just as characters, so the number '2' follows the number '11' for the same reason that 'B' follows 'AA'. If you are going to use only digits, you'd better write the Number / ID with leading zeros, for instance, '001', '002', '003' and so on. |
|
39. What about printing labels? Nothing fancy would be needed, maybe the ability to choose a font, size and alignment for each of the three fields that most people would want on their labels (species/description/locality).
| Please also read question #52 before deciding if having simple labels is enough for you. It's not as easy as it seems. Implementing a complete and flexible function to have labels printed is not a matter of a couple of hours because not only the fonts should be controlled. In addition to fonts, there are a lot of other parameters to take into account. Paper size, column number, column width, label height, position of the fields, what fields to include, inserting a graphic logo, drawing frames, and so on. And all of them must be hard-coded. I'm sorry, but currently I don't have enough time to develop such a function. An option might be to export the data in MS Excel format and get the labels from there. |
|
42. What is the Marked field for?
| It has no predefined function. You can mark the records of the specimens you most prefer, the pieces you plan to remove in the future, and so on. It can also be useful to have two parallel collections. The main (not marked) and the duplicates, or specialized (marked). The marked records will be displayed in a red font in the grid. |
|
52. How to print simple labels.
| Try this:
1. On the main screen, move to the right by dragging the mouse all the grid columns other than Species/Name, Locality, and Country until all of them are placed on the right side of the screen. Read also question #14 for details on how to move and widen columns.
2. Make the Country column wider than usual with the mouse in order to push to the right the unwanted columns that still remain visible until all of them are hidden.
3. With a click, select or make active the line of the specimen you want a label from.
4. Make sure the only visible columns are the ones you want printed.
5. When you are done, open the menu option File > Reports & Labels, or press Control+R.
6. Leave Page title and Page numbers unchecked.
7. Set Number of copies to 1 and Lines separation to 10.
8. Check Records in Page layout.
9. Check Current row in Rows.
10. Check Visible columns in Columns.
11. Click the button Grid data in Font and select any font you like.
12. Click the button Print to have the label printed.
13. Finally, you may want to reset the grid column order, width, and position to the factory settings by clicking on the menu item Utilities > Reset Columns.
- You will get a printout with two columns. Discard the left one. There will be a simple label for your specimen on the right.
- Make some tries by setting different line separations and grid data fonts, or changing the columns width and position, until you get the best result.
- If you don't like the country printed, just hide this column the same way you did with the others.
- If you want the number, description, or another field included, leave the corresponding column(s) visible.
- To print more than one label in one single operation, try either to set a filter or to select multiple rows (read also question #20 for details). Or do nothing if you want to print one for every specimen. Then change the setting in step 9 accordingly.
- If you need more sophisticated labels, however, read question #39.
|
|
53. I don't find the name of the varieties on the species list.
| The species file is intended to contain only approved species names. The variety can be included in the fields Description or Notes. But you can manually add new names to the species file and even translate them into your language if necessary. |
|
54. Any special advice on how to install and use MMCC on Windows 7, 8.x, 10, 11, or higher?
| Make sure you are logged into Windows as an administrator. If not, log in again in order to have all the administrative permissions. Then open the executable file Properties window (right-click either Minerals - Application file name, or minerals.exe file name, or the program shortcut on the Desktop). Then go to the Compatibility tab and check Execute (or Run) this application as an administrator (this may vary depending on your version of Windows).
Failing to do so can produce some system errors at startup, or, depending on the Windows version, your data files can be found at the folder \Users\[UserName]\AppData\Local\VirtualStore\Program Files (x86)\Minerals, where [UserName] is the name of the user logged on Windows.
Please see more details in question #74 and question #76. |
|
55. When I try to open MMCC, several errors are shown, my data is not visible, and it hangs. What should I do?
| Try to close the program. If you cannot, terminate it through the Windows Task Administrator. Open it again, go to the Utilities > Reindex menu item, and click the Regular reindex button. If the problem keeps going, go for a Clean reindex, even a second time, until everything works fine. If you were not able to solve it this way, the latest backup copy will have to be restored, following the directions in question #12. |
|
56. What should I do if I ever need to convert my data to another format?
| The user's files are in Paradox 7, not a rare format, but a function is available to easily export all your data to an XLS file, that can be read and processed by other known software like MS Excel, MS Access and the free and excellent suites LibreOffice.org or OpenOffice.org. Important: You must have MS Excel installed on the same computer for the export process to work properly.
But if you ever want to directly open the Paradox tables, install a free piece of software named xDBD that you will find at SourceForge. It's very intuitive and easy to use. |
|
57. What is the difference between a regular reindex and a clean reindex?
| The regular reindex operation just rebuilds the preexisting auxiliary index files. A clean reindex, however, physically deletes all those index files and then builds new ones from scratch. This second operation can be a lifesaver when a regular reindex is not enough to solve the problem because of the poor condition of the index files. Read also question #11 for more details. |
|
58. How can I quickly find the record linked to an image file?
| Look for a button on the top area of the main screen that shows a magnifying glass, and click it. This is the Search button. Then enter the file name or just a portion of it and click the Next button. For higher efficiency, however, it is recommended to give the image files a name in such a way that the specimen number is included in it, for example, 1234-galena.jpg. |
|
59. What is the best way to name the picture files?
| There is no general rule for doing that. But it is a good idea to name them by starting with the specimen's Number/ID, followed by a hyphen, and the species name. If you have several photos of the same specimen, add a sequential number. For example, 1234-galena1.jpg, 1234-galena2.jpg... |
|
60. What if all my data is missing after installing an update?
|
The installation program is carefully instructed to never overwrite existing user data files, and I can't imagine any reason for this failing. Your data is
neither overwritten nor deleted. If somebody can't see them it's usually because the data is in another folder (not excluding the low probability that the
user inadvertently deleted them beforehand).
Let's see what to do now. Just after finishing the installation of My Mineral Collection Catalog, the app will be executed with administrator
rights, since this is required by Windows for the installation program to work. If MMCC had been running until now as a limited user, your data
files were moved by Windows to a different folder (typically C:\Users\...), an operation that is known as virtualization. I suggest you close the
program and open it again as usual, the installer aside.
Your data should be visible now. If not, you can make three operations to go on. (1) Make sure you have installed MMCC in the same folder as before,
not in a new one. (2) By using the Windows File Explorer, perform a search on your computer for a file named minerals.db, and
a list will be shown displaying the folders that contain it, its size, and the last date it was edited. Look for the one that has the most recent data and a larger size. (3) If there is not such file in a folder different
from the one where you installed the program, I fear something very odd has happened. The last resource is restoring the most recent backup copy.
See question #12 for more details.
Check the Help|About... menu item to know the kind of Windows user you are working with and your actual data folder.
If you need more information about the administrator and limited users, please also read question #74.
|
|
64. The specimen photos I added to the Edit form are shown very slowly in the Carousel. Why?
| This most often happens because the image is too large, it is in PNG or BMP format, your computer is short
of memory or CPU speed, or too many programs are open at the same time. You can dramatically increase the opening speed by getting
a copy of your photos with a more manageable size, converting them to the JPEG/JPG format, closing the apps that clutter
the available memory, or, if all of this fails, by upgrading your computer. |
|
66. My new Netbook does not allow me to set a screen resolution over 1280x1024, so I find some of your program screens truncated at the bottom. Any solution?
| There is a solution to that problem in most cases. Try this:
1. Go to the Windows Start menu and type regedit in the Execute box, then hit Enter.
2. Scroll up on the left pane to make sure you are at the very top of the tree.
3. At the top menu, go to Edit, then Find... and search for the word Display1_DownScalingSupported. Be patient, the process can take a while.
4. After right-clicking, change the value of Display1_DownScalingSupported you find from "0" to "1".
5. Then press the F3 key to make sure you change every found instance, because otherwise the hack won't work. There might be more than 10.
So you'll have to repeat steps 4 and 5 a number of times.
6. Once done, restart the system, and open My Mineral Collection Catalog again. It will produce a message and try to change the
resolution to the minimum supported, 1280x1024. If it failed to do so, this may mean your computer does not have that capability. Contact with
the manufacturer.
For advanced users, more details can be gotten by googling the keywords display1_downscalingsupported netbook together and other similar
combinations.
|
|
71.
After installing MMCC, I get a number of error messages like Index file corrupted, Field ... not found, Index is out of date,
Cannot perform this operation on a closed dataset, A component named ... already exists, and what's worse, my data has suddenly
vanished.
This can sometimes happen in certain systems. But don't panic, and try this:
1. Close MMCC. If you can't, then open the Windows Task Manager (Control+Shift+Esc) and kill the program or end the task.
2. Open the app folder with Windows Explorer and sort the files by alphabetical order. Then look for a file with the name Minerals.exe or
Minerals - Application. Right-click that file and choose Run as administrator. If the program is opened as usual with your data and there are no error messages, you're done.
Otherwise, read the following lines to try another solution.
3. In the app program folder, carefully delete all files with the name minerals except those with extensions DB, MB, and EXE (maybe you will need to set your
Windows Explorer to not hide extensions of known file types). In case of a mistake, restore the deleted files from the Recycle bin.
4. Carefully delete all files with the name deleted, except those with extensions DB and MB.
5. Open the file minerals.ini with a pure text editor, like Notepad or WordPad, search for two lines that begin with Order=<here a number> and Invers=<here a number>, and delete both.
6. Save and close.
7. Open My Mineral Collection Catalog. You'll probably still get some message like No index currently active, but your data
should be there now. Dismiss it and jump to the next step.
8. First of all, go to the Utilities > Reindex menu item and click Regular reindex button.
9. Then open the menu File and click Removed.
10. Go to the Utilities > Reindex menu item and click Regular reindex button.
11. It's done. Just close and open MMCC again. No more errors should be displayed.
12. If you keep getting error messages, repeat the two reindex operations with the Clean reindex button instead.
|
|
74. What's this mess about Administrator and Limited users?
|
A primer to the Administrator/Limited rights mess
1. As you may already know, according to Windows requirements, there are two kinds of users: Administrator and Limited, with different rights.
2. If you installed the application in the "\Program Files (x86)" or "\Program Files" folders, which is the default (but can be changed by the user
during the installation process), your database files can be either in the program folder (Administrator user) or in a deeper path (Limited user), as may be
\Users\[UserName]\AppData\Local\VirtualStore\Program Files (x86)\Minerals, where [UserName] is the name of the Windows user.
3. Since the user is free to choose between executing the application as Administrator or as Limited and switch it at any time, there is the possibility of unexpectedly
finding yourself with a database that is not the real one. But don't panic yet!
4. To make things worse, the process of installing must be conducted with Administrator rights for it to be able to write in the \Program Files folder.
No alternative. Windows rules.
5. When opening MMCC again, if it had been executed as Limited before, the data you will see may be different from what you expected. That is admittedly very annoying, but there is no
data loss, only that you have two sets of database files in different places on your computer.
6. To prevent this problem from arising, you should have the previous concepts very clear and then decide: (a) Either to execute the application as Administrator or as
Limited user, or (b) Either to install it in the folder "\Program Files (x86)" or in another. It's up to you.
7. In any case, it's crucial that you obtain a backup copy of your valuable data whenever you make changes. The application can perform it for you every time you close it
and will keep separate copies of every day at least for one year. Just give the order from the menu Utilities|Preferences.... But select (if
possible) a different drive from the one where your working data is. For example, in a pen drive or an external HDD or SSD. Or in the cloud, if you prefer, but this will not
be automatically accomplished. (Think also that there is no such thing as a cloud, it's just someone else's computer.)
8. In the worst-case scenario of accidentally losing all of your data, you will always be able to recover the most recent files in a matter of minutes.
9. By opening the Help|About... menu item in the application, you will know what kind of Windows user you are and where the real data folder is.
If you couldn't see them, you likely have an old version of MMCC, so just update it for free.
Please see more details in question #54 and question #76.
Good luck!
|
|
75. Why is the field Largest crystal so long?
| It's longer than expected to make room for some details about the crystal. For example, 65 wide, 70 long, 35 on edge, and so on. If the specimen contains several species, you may want to add the size of the largest crystal of each as well. |
|
76. Where can I find my data files on the computer?
|
1. If you are executing MMCC as Administrator (recommended), you will always keep your data files in the same folder where the app is installed.
2. If you chose to install the program in the \Program Files (x86)\Minerals folder (which is the default for Windows) AND execute it as Limited (also the default),
you will find your files in the deeper folder \Users\[UserName]\AppData\Local\VirtualStore\Program Files (x86)\Minerals, where [UserName] is the name of the Windows user.
3. You can easily find out where your data actually is and whether you are running the application as an Administrator or Limited user by opening the Help|About... menu item.
4. To switch the execution of the program from Limited to Administrator please go to question #54.
|
|
78. What should I do to associate an image with a specimen?
| First, gather all your mineral pictures in one single computer folder. Then open the menu item Utilities > Preferences..., go to the frame Folders, fill the box Images with the path of the folder where you put your images, and click the OK button.
Then open the Edit form of the specimen, click on any of the boxes named Image, and select the image you want. Read also question #58 for more details.
|
|
79. Is there a way to sort the Species 2, 3, etc.? Sometimes I am looking for all the occurrences of certain rare species, and they may be the second or even third species on a specimen whose primary species is also rare.
|
No, at the moment, there is no way to do it. But you can use two ways to meet your need:
1. On the main form, click the button Search (with a magnifying glass), write the name of the species you want, and then click Next.
2. If you don't like this, click the button Filter (with a funnel) and define a filter with "Species #" - "contains" - the name of the species you want. Then click OK. You can add as many species as you need, then unmark the All values required checkbox and optionally save the filter conditions for future operations.
|
|
81. How can I open a website from the field Notes in the Edit form?
| The field Notes only accepts plain text, a data type that does not support any formatting (bold, underline, italics, link, etc.). But to get around this limitation, I have introduced a trick to facilitate such an operation. Just select the text with the URL (website address) by dragging your mouse. The pop-up menu will appear with an option to open the site. Something similar is available in the View "Notes" form available in the main data grid. |
|
84. What is the Provenance field for?
| A brief history of the specimen can be noted here. If it was purchased, write down from whom. If it was field-collected by you, note this. Or write the names of previous collectors who also owned it, if any. Up to 75 characters. To keep the locality (the geographical point where the specimen was found), use the Locality field instead. |
|
Application latest release: 4.2.1
Copyright © Carles Millan, 2007-2024
