Feedback can be sent to moc.xmg@8491c (only about app latest release) attaching a screenshot of the Help|About menu item.
Please read this first
The following Questions and
Answers are intended for the latest release of the application, which is currently 4.1.0.
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 Mac OS 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 Mac OS 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 virtual
machine working by just installing VirtualBox on your system, which is a free of charge product from Sun Microsystems. Please go to the
VirtualBox site to get more info and download the
software. Designed specifically for Mac OS at the time of writing this, Parallels Desktop and
VMware Fusion 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 main functions should operate properly.
|
|
6. What are the screen resolution requirements to run the application, and how can I change it 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 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 from 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 in MS Access?
| Unfortunately the answer is no. There is no possibility of importing data from other formats, unless you were 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 managing and lack the tools to do it. Developing a standard procedure to perform automatically that kind of operations is quite difficult, highly time consuming, and must be done in an almost case by case basis, given the number of existing formats and, above all, the multiplicity of field structures each one can have. |
|
10. What is the purpose of the Update 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 it for inflation. It only needs to be run once when some change has been made in the inflation database, otherwise it does nothing. |
|
11. What is the Reindex function for?
| As you surely know, the specimens 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 to proceed if I ever need to restore the backup copy?
| Close the program and copy all the files from the folder where the backup is to the folder where the application is installed, allowing to overwrite all (and be very careful not to perform such an operation in the opposite direction). You can learn which the backup folder is by opening the Utilities > Preferences menu item. Your files will be found within a folder with a name equal to the month and the day separated by a hyphen inside another folder named Minerals.bak that must be within it. |
|
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, that 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
in Windows. However, you will need administrator permits 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 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 would it be today. |
|
20. What is the 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 and get some practice. The selected rows will be enhanced with a blue color, and
a dot will be visible in its 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 be necessarily a nation-state, because there are territories that can also be considered a country 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 amount of data multiplied by fifty? This is nowadays an inefficient way of storing information and even may 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 with 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! |
|
25. What are the size (or maximum length) and type of each field?
| The maximum length is shown between parenthesis 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), Source (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 (a 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 him/herself. 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 in 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 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 negociate 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 with 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 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 right border by placing the mouse cursor on the title. Do the opposite to make it visible again. This state is kept in further 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 kind 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 and size, and font alignment for each of the three fields that most people would want on their labels (species/description/locality).
| Please read also question #52 before 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, columns number, columns 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, or 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 with red color font in the grid. |
|
52. How to print simple labels.
| Try this:
1. In the main screen move to the right by dragging the mouse all the grid colums other than Species/Name, Locality and Country, until all of them are placed in 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 columns 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 of your specimen in the right.
- Make some tries by setting different lines separation and grid data fonts, or changing the columns width and position, until getting the best result.
- If you don't like the country printed, just hide also 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 varieties in the species list.
| The species file is intended to keep only approved species names. The variety can be included in the fields Description or Notes. But you can add manually new names to the species file, and even translate them to your language if necessary. |
|
54. Any special advice to install and use MMCC in Windows 7, 8.x, 10, 11, or upper?
| Make sure you are logged in Windows as an administrator. If not, log in again in order to have all the administering 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 (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 in Windows.
Please see more details in question #74 and question #76. |
|
56. What to do if I ever need to convert my data to other formats?
| 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, than 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 in 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 in 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 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 to do 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 is usually because the data is in another folder (not excluding the low probability that the
user inadvertently deleted them beforehand).
Let's see now what to do. 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 install 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 (usually 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 in all 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. (3) If there were 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 to get more details.
Check the Help|About... menu item to know the kind of Windows user your are working with and your actual data folder.
If you need more information about the administrator/limited users, please read also the 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 or 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, or converting them to the JPEG/JPG format, or 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 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 the order 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 the 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 got by googling the key words 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 happen sometimes 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 Minerals folder with the 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 no error messages, you're done.
Otherwise read the following lines to try another solution.
3. In the Minerals program folder carefully delete all files with 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 mistake, restore the deleted files from the Recycle bin.
4. Carefully delete all files with 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. First of all 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 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 with 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 necessarily 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 other than expected. That is admittedly very annoying, but there is no
data loss, only that you have two sets of database files in different places of your computer.
6. To prevent this problem from arising, you should have the previous concepts very clear and then decide: (a) Either to execute always 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 separated 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 are. 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 acomplished. (Think also that there is no such thing as a cloud, it's just someone else's computer.)
8. In the worst 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 the 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 Largest crystal field 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 instead (which is the default for Windows) AND execute it as Limited (also default),
you will find your files at 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 to a specimen?
| First of all, 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.
|
|
81. How can 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 in the View "Notes" form available in the main data grid. |
|
Application latest release: 4.1.0
Copyright © Carles Millan, 2007-2023
