| Both sides previous revision Previous revision | |
| assesor:microsolve [2023/07/18 15:44 UTC] – [Microsolve Manual] eric | assesor:microsolve [2023/07/18 15:58 UTC] (current) – [Step 4 - Using the Program] eric |
|---|
| {{ :assesor:savecama.png?600 |}} | {{ :assesor:savecama.png?600 |}} |
| ---- | ---- |
| <html> | ==== Step 5 - Accessing the Commercial Cost Report ==== |
| <h3 style="font-weight: bold; text-align:left;">Step 5 - Accessing the Commercial Cost Report </h3> | ---- |
| <hr> | |
| <p style="font-weight: bold;">Use the following steps to access the Commercial Cost Report.</p> | |
| |
| <li> Go to the back up to the toolbar and locate the icon that looks like a <span style="font-weight: bold; color:purple;">building with a dollar sign on it</span> tab.</li> | **Use the following steps to access the Commercial Cost Report** |
| <p style="font-weight: bold; color: orange; tex-shadow: 1px 1px #333;">NOTE: Be sure to save your work prior to running the report!</p> | |
| | * Go to the back up to the toolbar and locate the icon that looks like a //building with a dollar sign on it// tab. |
| | **NOTE: Be sure to save your work prior to running the report!** |
| |
| </html> | |
| {{ :assesor:cama11.png?600 |}} | {{ :assesor:cama11.png?600 |}} |
| <html> | |
| <li> Click that button and it will bring up the cost report</li> | * Click that button and it will bring up the cost report |
| </html> | |
| {{ :assesor:cama6.png?600 |}} | {{ :assesor:cama6.png?600 |}} |
| |
| <html> | |
| <p style="font-weight:bold; font-style: italic;">NOTE: The program can be slow, so we recommend you immediately go to the PDF version of the report. This can be done by clicking the <span style="color:red;">printer icon</span> on the report toolbar.</p> | **NOTE: The program can be slow, so we recommend you immediately go to the PDF version of the report. This can be done by clicking the //printer icon// on the report toolbar.** |
| </html> | |
| {{ :assesor:microsolveprintreport.png?600 |}} | {{ :assesor:microsolveprintreport.png?600 |}} |
| <html> | |
| <li>Once you PDF comes up in your PDF viewer, you can print like any other document.</li> | * Once you PDF comes up in your PDF viewer, you can print like any other document. |
| </html> | ---- |
| <html> | |
| <hr> | ===== Export Excel File With ALL DATA ===== |
| <h2 style="font-weight: bold;">Export Excel File With <span style="font-weight:bold; color: red;">ALL DATA</span></h2> | |
| <p>The following instructions will teach you how to make a Microsoft Excel file out of all of the data in the database. IE. If you wanted to run a spreadsheet where all fields for particular parcels, or even filter results based on particular criteria.</p> | The following instructions will teach you how to make a Microsoft Excel file out of all of the data in the database. IE. If you wanted to run a spreadsheet where all fields for particular parcels, or even filter results based on particular criteria. |
| <ul style="text-align:left"> | |
| <li>First, you must be logged into Microsolve. If you are not, follow the steps listed above.</li> | * First, you must be logged into Microsolve. If you are not, follow the steps listed above. |
| <li>If you have a current parcel open, you must also close out of it by hitting the red x in the top right hand corner of the "Parcel Information" window</li> | * If you have a current parcel open, you must also close out of it by hitting the red x in the top right hand corner of the "Parcel Information" window |
| </ul> | |
| </html> | |
| {{ :assesor:toolstab.png?600 |}} | {{ :assesor:toolstab.png?600 |}} |
| <html> | |
| <ul style="text-align: left;"> | |
| <li>Go to the toolbar at the top of the program and select "Export" from the "Tools" dropdown menu.</li> | * Go to the toolbar at the top of the program and select "Export" from the "Tools" dropdown menu. |
| <li>This will bring up the Extraction Menu</li> | * This will bring up the Extraction Menu |
| <li style="font-weight: bold; font-style: italic;">There is a default setting in the export menu. If you are satisfied with the choices selected, you can skip over the selecting fields and filtering sections.</li> | * There is a default setting in the export menu. If you are satisfied with the choices selected, you can skip over the selecting fields and filtering sections. |
| <ul> | ==== Selecting Fields ==== |
| <h3 style="font-weight: bold; text-align: center;">Selecting Fields</h3> | You are able to customize what fields you would like to export to your spreadsheet. This can be done by the following steps: |
| <p>You are able to customize what fields you would like to export to your spreadsheet. This can be done by the following steps:</p> | |
| <ul> | * At the top of the "Extract records from database..." window, you will see there is a tab named "Choose Fields to Process" Click on this tab |
| <li>At the top of the "Extract records from database..." window, you will see there is a tab named "Choose Fields to Process" Click on this tab</li> | |
| </ul> | |
| </html> | |
| {{ :assesor:choosefieldstab.png?600 |}} | {{ :assesor:choosefieldstab.png?600 |}} |
| <html> | * In this window, the list of fields on the left is the fields you can choose from while the list on the right are the fields you would like to include |
| <ul> | * For our demo, let's add the field called //Book// |
| <li>In this window, the list of fields on the left is the fields you can choose from while the list on the right are the fields you would like to include</li> | * Scroll through the menu until you find the field you are looking for (for the demo, it's //Book//) and click so that the field you want is highlighted. |
| <li>For our demo, let's add the field called <span style="font-style: italic;">Book</span></li> | * To add to the list of included fields, click the "carrot" that is pointed to the right. You will now see that the field has been moved to the "Choose Fields to Process" column. |
| <li>Scroll through the menu until you find the field you are looking for (for the demo, it's <span style="font-style: italic;">Book</span>) and click so that the field you want is highlighted.</li> | |
| <li>To add to the list of included fields, click the "carrot" that is pointed to the right. You will now see that the field has been moved to the "Choose Fields to Process" column. | |
| </ul> | |
| </html> | |
| {{ :assesor:movefilesright.png?600 |}} | {{ :assesor:movefilesright.png?600 |}} |
| {{ :assesor:movedfileschoosefields.png?600 |}} | {{ :assesor:movedfileschoosefields.png?600 |}} |
| <html> | |
| <ul> | * To remove a field, highlight the field you would like to remove by clicking on it, then click the "carrot" that is pointed to the left |
| <li>To remove a field, highlight the field you would like to remove by clicking on it, then click the "carrot" that is pointed to the left</li> | * To remove all fields, you can hit the "Double Carrot" icon, pointing to the left. |
| <li>To remove all fields, you can hit the "Double Carrot" icon, pointing to the left.</li> | * When all desired fields have been selected, click on the "Records to be Processed" to continue the process. |
| <li>When all desired fields have been selected, click on the "Records to be Processed" to continue the process.</li> | |
| </ul><br> | |
| </html> | |
| {{ :assesor:carrotleft.png?600 |}} | {{ :assesor:carrotleft.png?600 |}} |
| {{ :assesor:backtorecordstoprocess.png?600 |}} | {{ :assesor:backtorecordstoprocess.png?600 |}} |
| <html> | ==== Filtering Results ==== |
| <h3 style="font-weight: bold; text-align: center;">Filtering Results</h3> | In addition to field customization, you are also able to filter your results by different criteria such as last names that match a certain criteria or values that are less than $500k etc |
| <p>In addition to field customization, you are also able to filter your results by different criteria such as last names that match a certain criteria or values that are less than $500k etc</p> | |
| <ul> | * To start, you now must find the "Filter Button" in the top of the main window. |
| <li>To start, you now must find the "Filter Button" in the top of the main window.</li> | |
| </ul><br> | |
| </html> | |
| {{ :assesor:findfilterbutton2.png?600 |}} | {{ :assesor:findfilterbutton2.png?600 |}} |
| <html> | |
| <ul> | * Clicking the Filter button will open up the Filter window |
| <li>Clicking the Filter button will open up the Filter window</li> | * To add a filter, click the add button |
| <li>To add a filter, click the add button</li> | * Use the dropdown menus to select what field you want to filter, the operator (less than, equal to, does not equal, etc) and then the value. |
| <li>Use the dropdown menus to select what field you want to filter, the operator (less than, equal to, does not equal, etc) and then the value.</li> | * For our demo, we wanted to filter the fields to only show those records where the ParcelID is equal to "TEST" |
| <li>For our demo, we wanted to filter the fields to only show those records where the ParcelID is equal to "TEST"</li> | * When you are satisfied with your choices, click the "OK" button to return to the Filter window and see your filtered results |
| <li>When you are satisfied with your choices, click the "OK" button to return to the Filter window and see your filtered results</li> | |
| </ul><br> | |
| </html> | |
| {{ :assesor:showfilterchoice.png?600 |}} | {{ :assesor:showfilterchoice.png?600 |}} |
| {{ :assesor:filteredresultsmicrosolve.png?600 |}} | {{ :assesor:filteredresultsmicrosolve.png?600 |}} |
| {{ :assesor:filteredresultsmicro.png?600 |}} | {{ :assesor:filteredresultsmicro.png?600 |}} |
| <html> | ==== Extracting Excel File ==== |
| <h3 style="font-weight: bold; text-align: center;">Extracting Excel File</h3> | |
| <p>Now it is time for us to extract the excel file with all of our filtered selections</p> | |
| <ul> | Now it is time for us to extract the excel file with all of our filtered selections |
| <li>You can see the results have been filtered to our specifications if we made any. Hit the extract button to start the extraction process.</li> | |
| <li>There are several file types that you can choose, but for our example we are going to choose the "Excel V5" choice and then click continue</li> | * You can see the results have been filtered to our specifications if we made any. Hit the extract button to start the extraction process. |
| <li>Now it is time to give our file a name. You are only allowed to choose 8 characters, so attempt to make them meaningful.(EX. "R063023" <- Report June 30th, 2023)</li> | * There are several file types that you can choose, but for our example we are going to choose the "Excel V5" choice and then click continue |
| <li>Once your file is named, click on "Save"</li> | * Now it is time to give our file a name. You are only allowed to choose 8 characters, so attempt to make them meaningful.(EX. "R063023" <- Report June 30th, 2023) |
| </ul><br> | * Once your file is named, click on "Save" |
| </html> | |
| {{ :assesor:microextract1.png?600 |}} | {{ :assesor:microextract1.png?600 |}} |
| {{ :assesor:microextract2.png?600 |}} | {{ :assesor:microextract2.png?600 |}} |
| {{ :assesor:microextract3.png?600 |}} | {{ :assesor:microextract3.png?600 |}} |
| |
| <html><br> | |
| <ul> | |
| <li>The program will automatically open a confirmation report of what you exported. You can close this by clicking the "X" in the top right hand corner</li> | * The program will automatically open a confirmation report of what you exported. You can close this by clicking the "X" in the top right hand corner |
| <li>On the main export window, you will now see that your file has been exported by a confirmation note in the bottom left hand corner of the menu. That is the file path of your exported report. <span style="font-weight:bold; font-style: italic;">NOTE: For your computer, disregard the file path before the letter "C".</span></li><br> | * On the main export window, you will now see that your file has been exported by a confirmation note in the bottom left hand corner of the menu. That is the file path of your exported report. **NOTE: For your computer, disregard the file path before the letter "C".** |
| </ul> | |
| </html> | |
| {{ :assesor:microextract4.png?600 |}} | {{ :assesor:microextract4.png?600 |}} |
| {{ :assesor:microextract5.png?600 |}} | {{ :assesor:microextract5.png?600 |}} |
| <html><br> | |
| <ul> | * Now you can open your file explorer and copy that url (C\USERS\....) and paste it in the address bar or navigate to your local "DOCUMENTS" folder. |
| <li>Now you can open your file explorer and copy that url (C\USERS\....) and paste it in the address bar or navigate to your local "DOCUMENTS" folder.</li> | * You will see our file located in the folder. Open it up to display your results. |
| <li>You will see our file located in the folder. Open it up to display your results.</li><br> | |
| </ul> | |
| </html> | |
| {{ :assesor:microextract6.png?600 |}} | {{ :assesor:microextract6.png?600 |}} |
| {{ :assesor:microextract7.png?600 |}} | {{ :assesor:microextract7.png?600 |}} |
| **Note: At this point in time, the column names DO NOT carry over with the file export. Rename the top row with the appropriate column names you chose to include (ie. a1 => ParcelID, a2 => CAMARCNLD, etc) and save.** | **Note: At this point in time, the column names DO NOT carry over with the file export. Rename the top row with the appropriate column names you chose to include (ie. a1 => ParcelID, a2 => CAMARCNLD, etc) and save.** |