Home → EstiMate Version 2 → Printer Friendly Version
Q: I just updated EstiMate to the latest 2.2.1.19 build, and I'm getting an error after clicking on the "Open" list. The error says: "NexusDB: <unnamed TnxQuery instance>: Query execution failed:" "NexusDB: The operation could not be completed in the allotted time: How can I resolve this? A: Starting with the 2.2.1.19 build of EstiMate a user defined option was included in the System Settings to allow the user to manually adjust the time in seconds for a database operation to complete before the error message appears. There are a couple of reasons a user might encounter this error. 1. The database is very large, and the time required to join the database tables, and display the results exceeds the currently allotted time. 2. Network issues are delaying the retrieval of the data. To correct this issue the user can adjust the "Query Timeout" setting in the System Setting to a higher value (in seconds). 1. Click "Configure and Manage" > "System Settings" (If you're connected to the Multi-User Server you'll first need to have everyone close out of their copy of EstiMate, and then switch to "Single User Mode" by clicking the "blue" EstiMate icon in the upper left and selecting "Switch To Single User Mode"). 2. In the System Settings click the "Advanced" button. 3. Under "Query Timeout (seconds)" use the up/down buttons to adjust the number of seconds, or just type in the number. 4. Start with "30" seconds, and click the "OK" button If you still get the error move it to "60", "90", and so fourth until the operation completes w/o error. You only need to update this setting from one of your copies of EstiMate, and it will apply to all of them on your network. Once you're able to get the Open list or the Archives to open you shouldn't have any further issues opening either until you restart EstiMate because once it's open EstiMate caches most of that data to allow for quicker retrieval the next time (it should open in half the time or quicker).
Q: I'm running the latest build of EstiMate, and the Multi-User Server (build 2.2.1.4). Periodically throughout the day they will both lock up. In order to use EstiMate again I must first crash, and then restart both applications. Is there a fix for this issue?
A: We are aware of, and looking for a solution to this issue. This issue seems to have originated from the 2.2.1.3 update for EstiMate, and the Multi-User Server. In that particular build there was an issue where EstiMate would not connect to the Multi-User Server from any computer on the network other then the one running the Multi-User Server. We corrected that issue with the 2.2.1.4 update shortly after we realized it. We were then made aware that some users with 4 or more copies of EstiMate connecting to the Multi-User Server were encountering issue with EstiMate locking up.
We released a test build (2.2.1.6) to try and fix the latest issue. We believed at the time that it was a client side (i.e. EstiMate) issue, and tried to handle it as such. Unfortunately this did not fix the issue. We are currently unsure of the exact cause of the issue, other then we now believe it to be the Multi-User Server which is locking up causing EstiMate to become non responsive.
Again we are working toward a solution to this issue, and we apologize for any inconvenience it has caused. The only workaround to this issue currently is to "downgrade" the Multi-User Server, and all of your copies of EstiMate to an earlier version (before 2.2.1.3).
At the bottom of this article you will find both the Multi-User Server, and EstiMate 2.2.0.10 for download.
Before you download and install anything please be sure to backup your EstiMate Data.
How to backup your EstiMate Data: http://www.estimatesoftware.com/support/index.php?pg=kb.page&id=617
To begin:
1. Close all copies of EstiMate, and exit out of the Multi-User Server.
2. From the computer/server running the Multi-User Server download and install the 2.2.0.10 build from this page.
3. When it's finished installing let it launch, or start it manually from the Desktop icon or Start Menu icon.
4. Next move to one of your EstiMate computers and download and install the 2.2.0.10 build of EstiMate from this page.
5. When it's finished you can let it launch or just leave it closed.
6. Repeat the above 2 steps until all of your copies of EstiMate have been "downgraded" (NOTE: Do not run mixed versions/builds of EstiMate as this can cause further issues).
You should now have everything back up and running, and the issue should be resolved. Please check back to this page (or bookmark it) periodically for updated workarounds, or to make sure the next build of EstiMate fixes the issue (before you update), or for intermediate build releases that correct this issue.
EstiMate Multi-User Server (build 2.2.0.10): ftp://ftp.estimatesoftware.com/eServerSetup.exe
EstiMate 2 (build 2.2.0.10): ftp://ftp.estimatesoftware.com/eSetup.exe
Username: xestimatesoftware1-public
Password: public123
Sorry for the inconvenience. We are now aware of the networking issue in the latest update of EstiMate 2 (2.2.1.3), and are working to fix this.
Here is the workaround for the latest build of EstiMate (2.2.1.3) not connecting to the Multi-User Server. We can see from our end that there is some sort of issue preventing customers from connecting to the EstiMate Multi-User Server after they update all of their EstiMate software components to the latest build. We apologize for the inconvenience, and we will try to get this issue resolved as quickly as possible.
To bypass this issue: (Make sure the EstiMate Multi-User Server is running before you begin).
1. Open EstiMate, and click "OK" when you receive the message "Could not connect to network server..."
2. Next click the "Connect To Local Folder" button on the connection toolbar
3. A "Select Folder For Database" window will pop up, and the folder called "Data" should already be highlighted - Just click the "OK" button at the bottom of that window.
4. You will get a message stating "You are attempting to connect to a local folder, but you were previously connected to an EstiMateMulti-User Server". Just click "OK" on this message.
5. It could take up to 20 seconds for EstiMate to connect to this local folder.
6. Once EstiMate opens up into this local database it might also appear to be "hung up", but just give it a few second after you click on any of the buttons, and it will respond.
7. Click on the "blue" EstiMate icon in the upper left, and select "Close Database". This will close the local database, and put you back on the connection toolbar.
8. Now click the "Connect To Selected Server" button, and you should get a login prompt (almost immediately). Once you've logged in,EstiMate should open into Multi-User Mode, and everything should work as expected.
If you close out of EstiMate you will (most likely) have to repeat these steps to get reconnected (at least until we are able to resolve the issue, and upload a new build/patch).
Repeat the above steps for any other copies of EstiMate you need to use. If you have a copy of EstiMate on the same computer as the Multi-User Server you shouldn't need to do anything with that copy - it should just open up since the server is "local" to that copy of EstiMate. If you are still having issues after following the steps above please let us know (reply to this email).
Again we apologize for the inconvenience, and will work to resolve this issue as quickly as possible.
In the interest of customer service we wish to provide customers access to incremental builds of the software.
Q: I just did an update of the software and now the Vehicle Wrap items (vehicles, prep solution, adhesive) are not showing up in the list.
A: We are aware of this issue, and are working to fix it for the next build of the software. In the meantime we do have a solution to fix the issue immediately. Attached to this article is the database file for all of the Vehicle Wraps items. If you have a single EstiMate station you will want to save this file to that computer. If you have more then one EstiMate station and use the Multi-User Server you will want to save this file to the computer that the Multi-User Server is installed on.
1. Save the file attached to this article to the desktop of the computer that is running EstiMate (if you only have the one station), or the computer running the Multi-User Server (if you have 2 or more copies of EstiMate networked together by the Multi-User Server).
2. Close any open copies of EstiMate, and stop the Multi-User Server.
3. Right click on the zip file (Custom.zip), and select "Extract All".
4. When the "Extraction Wizard" comes up click the "Next" button.
5. On the next screen it asks where you would like to extract the file. There is a hidden folder in the path to the EstiMate Data folder so you will not be able to browse there (unless you have "Show hidden files" turned on).
Instead you can copy this path C:\Documents and Settings\All Users\Application Data\EstiMate\Data and past it into that field. (This is if you only have one copy of EstiMate).
If you are using the Multi-User Server then you will want to copy this path and paste it into the field in the Extraction Wizard:
C:\Documents and Settings\All Users\Application Data\EstiMate\Multi-User Data
If your data folder is located somewhere other then one of these default locations you will need to know where that is and either browse to that location or enter the path to it into the filed in the Extraction Wizard.
6. Click the "Next" button.
7. You will get two prompts - 1 telling you the file already exists - just click "Yes" to replace it, and second telling you it's a Read Only file - just click "Yes" there too.
8. Back on the Extraction Wizard window uncheck the "Show extracted files" check-box, and click the "Finish" button.
9. Start the Multi-User Server again, and then open EstiMate. All of the vehicles, prep solutions, and adhesives should now be in their respective lists, and available for you to select from in the Vehicle Wraps plugin.
Q: When I try to open a few select jobs and estimates I get and error message that reads: "Invalid object class TchpboSalesTax in attribute TInstantPart('HardNumbers'). Required class TEMboHardNumbers". How can I fix this issue?
A: This issue has been fixed in the current version of EstiMate. Please download the latest version of EstiMate (and the Multi-User Server if applicable) from here:
To fix the "TEMboHardNumbers Error":
After you've updated the Multi-User Server (if you use this part of the software), and all of your EstiMate stations you can go ahead and open EstiMate on one of your computers.
The first thing you will want to do in EstiMate is to make a backup. To do this click on the "Configure And Manage" tab, followed by the "Backup/Restore Data Files" button. On the next window click the "Backup" button. In the "Save As" dialog window choose somewhere to save the backup, and at the bottom be sure and give it a filename (e.g. EstiMateBackup12-10-08), and click "Save". (NOTE: Please do not proceed until you've made a backup).
Once you've made a backup you can begin repairing the issue with the EstiMate Health Check utility.
The issue should now be resolved. You can connect the rest of your EstiMate stations, and continue working.
Q: After I selected a customer for a job I noticed that the contact person was missing from the "Bill To" filed. On another job the address was missing from that same field. How do I get that information to show up?
A: This seems to only affect jobs and estimates that were imported from EstiMate version 1. For some reason EstiMate is not pulling all of the information available in that customers record into the "Bill To" field. We do intend to fix this, but in the meantime here is the workaround.
When you open a job or estimate that was created in EstiMate version 1, and you notice that the contact person or address is missing from the "Bill To" field:
Q: When I select the Screen Printed Garments plugin from Quick Quote or from Add Item on the job or estimate screen I get an Access Violation. Is there any way to fix this.
A: We noticed this issue after our last build/update. We are not sure what caused this to happen, and Screen Printed Garments is the only plugin that is affected.
This issue has been resolved. Visit our updates page to download the latest version of EstiMate.
Q: I usually enter my own descriptions into the "Description" field of a plugin, but lately when I go back in to edit that line item the description has changed back to the original/default, and the "Auto" box is again checked. How do I keep it from changing?
A: We recently made some changes to that area of EstiMate because it was causing some confusion the way it was. It's less confusing now, but unfortunately now it's not working correctly. We are aware of this issue and we hope to have this fixed just as soon as possible.
You can still un-check the "Auto" box, and add your own description, but if you then have to go back into that line item/plugin from the job or estimate screen it will change your description back to the default and the "Auto" box will again be checked.
Another thing you can do is to enter the description directly into the "Description" filed of a line item on the job or estimate screen. Doing this will automatically un-check the "Auto" box in the plugin and fill in with your description. You will then be able to go into that line itme/plugin and the description will stay the same, BUT ONLY THAT ONE TIME. If you click OK, but then have to go back in to that line item again the description will default back to "Auto".
We apologize for any inconvenience this may cause, and we hope to have this issue corrected very soon.
Q: I've typed the information for my job into the "Copy and Colors" section of the plugin, but it keeps disappearing every time I move one of the sliders on the right. How can I keep it from doing that?
A: This unfortunately is just a "bug" in the software. We are aware of this issue and hope to have it corrected soon.
The work around for the time being is simply to make any adjustments needed to the "Subjective Sliders" (i.e. Artwork Complexity, General Difficulty Level, Market Level, etc.) before you type in your "Copy and Colors".
We apologize for the inconvenience.
Q: I've just done a quote using a Line Item Group, and the tax is not showing correctly on the print out of the estimate. The correct tax amount is shown on the estimate screen, and the correct total amount shows on the print out, but the tax on the print out is not correct.
A: We are aware of this issue and we are working to fix it. The issue is that when the print out is generated it's only calculating tax for a quantity of 1 for that Line Item Group. If your quantity is more then 1 it still calculates/shows the correct total on the print out, but the tax amount only reflects a quantity of 1.
The only work around for this right now is to:
Q: When I created my new EstiMate database the files went all over my desktop. Why did this happen and how do I get them into the correct folder?
A: By default EstiMate should create your default database in C:\Documents and Settings\All Users\Application Data\EstiMate\Data. There are two possibilities why this might have happened. The first is that EstiMate might not have been able to access the correct folder due to your Windows settings. The second reason is if you clicked the "Create New Database" button in EstiMate, but didn't select a folder for the database to go in to (it defaults to the desktop).
To fix this issue:
If you have been working with it like that (with the database files on the desktop) then you will want to group those files up so that you can put them in the correct location, and so you don't lose any of your work.
NOTE: If you've not done any work in EstiMate yet, you can just get connected to the correct folder, and then delete the "*.nx1" files from your desktop. Read #1, and # 3 - 5 at the bottom of this article to lean how to open the "Data" folder at the correct/default location.
C:\Documents and Settings\All Users\Application Data\EstiMate
To open the database folder in EstiMate:
Q: What is the ID column in the Open list for, and how do I get rid of it?
A: This is how EstiMate tracks your jobs and estimates. It was accidental left on in the last build of the software, and will be removed from the "Open" list in the next build of the software (2.1).
You can't remove it from the "Open" list yourself, but to avoid confusion you can move it out of your way.
Q: When trying to print a quote, invoice, report, or anything to my Brother HL 2140 Laser printer all I get is blank pages. Is there something I need to set up in EstiMate to get it printed?
A: We are aware of this issue, but unsure of what's causing this to happen. EstiMate uses the default Windows printer, so there are no additional setting to correct this issue. We can't guarantee when or if a fix will be available for this issue. If you currently own this printer then you will need to either use the Print to File option in EstiMate, or print to a different printer (possibly a network printer).
To print to a file:
Q: I'm trying to e-mail a quote out of EstiMate 2, but when I click the Email button nothing happens. I'm using Microsoft Office Outlook 2007. How do I get it to e-mail my quote?
A: We are aware of this, and EstiMate 2 seems to work with all other version of Outlook, but for some reason EstiMate can't launch a new mail message in Office Outlook 2007. We are looking for a solution to this issue, but in the meantime you can use the "Print to File" option in EstiMate to create a PDF of your quote which you can manually attach to your e-mail message. Also make sure your Outlook and EstiMate software are up to date, and also refer to this Knowledge Base article to make sure everything else is set up correctly ("I Can't e-mail a quote out of EstiMate"): http://www.pricingmadeeasy.com/estimate/support/helpspot/index.php?pg=kb.page&id=59
To print to a file:
If we are able to find a solution to this issue we will post it here. We apologize for the inconvenience.
UPDATE: It's possible that EstiMate isn't recognizing MS Office Outlook 2007 if it was installed before EstiMate. If this is the case (you installed MS Office Outlook 2007 before you installed your copies of EstiMate 2) then reinstalling Outlook 2007 should correct the issue.
If you have the MS Office 2007 CD you can reinstall just that portion (Outlook) of the software. Once you've done that restart EstiMate, and try to e-mail a quote. You should now get a new Outlook email message with your quote attached as a PDF.
Q: I am using Windows Vista, and whenever I open Adobe Illustrator it switches Vista's screen mode from Aero to Windows Basic. If I have EstiMate open when it changes screen modes it causes it to crash.
A: We are aware of this issue, and we will try to find a solution. What actually happens is that when the screen mode changes it causes EstiMate to "redraw" the Connect toolbar over top of the main EstiMate toolbars. You then think you've been logged out, but when you try to connect to your database again it tells you you're already connected.
If you happen to have anything open in EstiMate when the "switch" takes place try to save your work immediately if you can, and close EstiMate. If you try to access anything (else) you will get an error message; "Invalid connector for object".
This issue will only occur if you have EstiMate open when switching screen modes in Vista. The solution is to try and save your work if possible, and restart EstiMate. That will correct the issue unless you switch screen modes again while EstiMate is still open. If you close Adobe Illustrator it will switch back to Aero automatically if that's what you originally had set.
UPDATE: The best way to resolve this issue is to just set your Vista Desktop to "Windows Vista Basic", and leave it at that. Adobe Illustrator is one application that can't run with the "Aero" screen mode enabled, LogMeIn (remote desktop software) is another. Setting you desktop to "Windows Vista Basic" will prevent these applications from changing the screen mode for you and causing issues with EstiMate 2.
To change your screen mode in Vista from "Aero" to "Windows Vista Basic":
The main thing you will notice with this change is that you windows are no longer transparent, and the task bar preview of windows no longer show. Other then that there is not much noticeable change, your Windows Side Bar will still work, and everything else will work as expected.
Q: I'm getting an error message when I try to export my jobs and estimates to QuickBooks. The error message appears right at the point EstiMate starts to export the transactions. The error message reads "QuickBooks cannot be accessed at this time. Another application is interacting with QuickBooks and both cannot run simultaneously".
A: We are aware of the issue, and we apologize for the inconvenience. This issue was just recently brought to our attention, and only seems affects QuickBooks 2006 - if you are using a version other then 2006 you should not encounter this issue. This issue occurred after customer using QuickBooks 2006 updated there copies of EstiMate to build # 2.2. There was one change made to the EstiMate QuickBooks Link in this latest update, and that was to fix it's digital certificate to correctly identify itself to QuickBooks as "EstiMate Software" instead of "Unknown Application". We are looking into this matter, and will update this page as soon as we have a fix available.
If you are experiencing this issue as of 10/15/08 you do not need to report it to us just check back on this page shortly (you're still always welcome to call or e-mail us though if you have questions or issues). We will post the fix and directions here as soon as they're available. Thank you for your patience.
Update:
Here is the fix for the QuickBooks Link:
Q: When I open a plugin like Vinyl or Wide Format the plugin screen is so large that the OK, Cancel, Configure, and Templates buttons don't show up on the screen. I tried adjusting my resolution, but that didn't help. How can I fix this issue?
A: This is usually an issue when using EstiMate on Windows Vista. The problem is not with the screen resolution, but with the font size. Vista has to default font sizes - 96 DPI (Normal), and 120 DPI (Large), and when it's set to the larger 120 DPI it causes the buttons in the plugins to be pushed out of alignment to the far right. They are still there, but due to the increased font size the are pushed off the screen. You can "grab" the title bar with your cursor and move it to the left a bit to see the buttons until you can change your font size.
To change your DPI Scaling in Vista:
Q: When I try to preview anything in EstiMate before I print it I get an error that says "Cannot create file "C:\WINDOWS\system32\RBuilder.ini". Access is denied". I can however print the reports, invoice, work orders, etc., I just can't preview them. How can I fix this?
A: This is a permission issue in Windows. This error will sometimes occure if the current user of the system is not logged into Windows as the Admin. You can however just give full permission to this one file, and they will then be able to preview the reports in EstiMate.
To give full permissions to the "RBuilder.ini" file:
Note: If you don't see the "Security" Tab on the properties window for the "RBuilder" file then you probably have "Simple File Sharing" turned on. To turn off Simple File Sharing click on "Tools" > "Folder Options" from the text menu at the top of Windows Explorer or the Systems32 window/folder. On the "Folder Options" window click on the "View" tab. Under the "Advanced Settings" section scroll all the way to the bottom and uncheck the box that says "Use simple file sharing (Recommended)". Now right click on the "RBuilder" file again, select "Properties", and you will see the "Security" tab.
Q: What are the system requirements for running EstiMate 2?
A: EstiMate is a PC based software, and therefore needs to be run under the Windows operating system. Any version of Windows, XP or better is what is required. If you are using a Mac you will need to install a virtualization software like Parallels, VMWare, or Virtual PC, and then a copy of Windows XP, or better on top of that. You will then be able to install EstiMate onto the virtual Windows machine.
Here are the recommend hardware requirements for running EstiMate:
EstiMate is not very resource intensive, and any modern computer should run it without a problem. However for optimal performance we recommend:
If you are also going to run the EstiMate Multi-User Server then in addition to the above you should have:
If the computer you will be running the Multi-User Server on is a "server computer" then it should be able to handle the network load effectively. However if it's one of your workstations then you may want to consider doubling the recommended system requirements from above (i.e 2 GHz processor, 1 GB of system memory).
Q: Will EstiMate 2 run on Windows 7?
A: EstiMate 2 will run on Windows 7 using the new "Compatibility Agent".
To install EstiMate 2 on Windows 7:
1. Download the setup files for EstiMate 2, and the EstiMate Multi-User Server (if you are licensed for multiple copies of EstiMate).
2. Once the download is complete right click on the "eSetup.exe" icon and select "Troubleshoot Compatibility".
3. Windows will detect, and correct any issues needed to complete the installation of EstiMate 2.
4. The EstiMate 2 Installation Wizard will appear. Follow the steps to finish installing EstiMate 2.
Thanks to Tim B. for providing us with this information regarding Windows 7, and EstiMate 2 compatibility.
We put 4 there because proper rounding is critical in accounting. We found in the past that sometimes with only 2 places after the decimal, prices weren't properly rounded and therefore might not match figures brought into QuickBooks or over to other accounting programs. Those fractions of a penny could cause audit issues, etc. With EstiMate 2.0, we have eliminated that concern, by fine tuning the rate price to 4 places after the decimal. It has been done intentionally.
A. In version 1, there was no way to generate .pdf files "on the fly" and it was actually a workaround (and a real hard drive clutter issue) to store them in your estimate folder. In version 2, they are generated on the fly, and therefore are not actually stored on your hard drive but simply attached to the email as it is generated.
The reason the Custom Message appears twice on your printed jobs and estimates is because the "Name" of that message also prints out.
If you type "Thank You", as the "Name/Title" of your message, and then "Thank You" again in the body of the message you will get "Thank You" twice on your print outs.
If you simply want only one line of text to appear you can just type your message into the Name field, click the Add button and leave the message field blank.
Otherwise you could do something like:
Name: Thank you so much for your business.
Message: If you have any questions about your order please don't hesitate to call us @ 1-888-304-3300.
Q: What versions of Windows is EstiMate compatible with, and what are the minimum system requirements?
A: EstiMate is only certified for use on Windows XP and Windows Vista.
It should also work on Windows Server 2003, and 2008, but normally only the Multi-User Server portion of EstiMate 2 is what gets installed on to the server computer.
EstiMate will not run on Windows 9x, NT, ME, or 2000.
EstiMate is not very resource intensive, and any modern computer should run it without a problem. However for optimal performance we recommend:
If you are also going to run the EstiMate Multi-User Server then in addition to the above you should have:
Q: I'm trying to connect EstiMate to the Multi-User Server, but every time I click the "Connect To Selected Server" button it says "Admin is already logged in from another machine". I am licensed for more then one station, and I already have it running on another computer. How can I get EstiMate to connect to the Multi-User Server from the other computers?
A: The issue is that "Admin" is currently the only user in the database. In order to log in from the other machines you must first create some additional users for the system.
To create additional users:
Q: I selected "Non Taxable" for a Labor item on my quote, but when I print it there is still a check mark under "Taxable" for that item. How do I get the check mark to not show up?
A: The reason for this is because EstiMate sees "Non Taxable" as a tax item. EstiMate will calculate the tax correctly, adding nothing for that Labor item because its rate is 0.0%, but because there is a selection in that field it sees it as being taxable regardless of the %.
The way to properly make an item "Non Taxable" is to "blank" the tax field out in the plugin, or in the settings of that plugin. If you never charge tax for Labor items then it would be best to do this in the plugin settings for Labor Items.
To charge no tax for an item:
To do the above in the settings of a plugin so that tax is never charged by default:
If the customer is tax exempt and therefore not charged tax on any items then the way to apply that is to check the "No Tax" box on the Job or EstiMate screen. This will make the tax for the entire job $0.00, and the tax line will be removed completely from the Totals section of the print out.
Q: I am trying to configure my Screen Printed Garments plugin, but every time I move the Market Level sliders the program freezes and then crashes. How can I fix this so I can adjust the Market Level sliders for this plugin? This is the only plugin that has this issue.
A: The problem is there is no Default Press selected in the configuration screen of Screen Printed Garments. EstiMate is trying to pull information from that field for the Market Level sliders to use, and when it doesn't find anything in the Default Press section it causes the program to crash.
To fix this:
Now that you have the new press created with the correct specifications:
Q: Why is the text of some of my line items "blue"?
A: Color was recently added to the text of some items like "System Items" or "Overridden" items to differentiate them from the other "regular" items in EstiMate.
There are currently only two set colors in EstiMate - Here is the key:
Maroon = Basic parts of EstiMate which cannot be deleted. Some examples are "Completed" and "In Process" in the Job Status Flags list. These two items cannot be deleted, but their "names" can be changed. The Maroon color is intended to help you easily identify these items if you ever need to change them back.
Blue = Overridden. When you see a line item on a job or estimate that is blue it means that the price for that item has been "Overridden", and will not change unless *you* change it. For example if you imported you data from EstiMate version 1 all of the line items came into EstiMate 2 "Overridden". This was done so that the new plugin settings in EstiMate 2 would not alter your original price. If you were to uncheck the "Overridden/Override" box in that plugin the price would immediately change to reflect the current system settings.
We hoped that by makeing these items different colors they would stand out, and that customers would exersise a bit of caution before making changes to these items.
Q: I just created a new job for a customer, and printed out the invoice. I then opened that job again from the "Open" list, but it's a completely different job with the same job number as mine. What happened to my job?
A: It's important to watch this especially in a networked environment. EstiMate will allow duplicate numbers to be created by the user, but it will not create duplicate numbers on it's own under normal circumstances.
One thing to be aware of is that when a new job or estimate is created EstiMate will assign it the next highest job/estimate number based on whatever the current highest number in the System Settings. If two or more people click "New Job" or "New Estimate" right around the same time they will all have the same number. It's not until one of those people click on the "Save" button or prints that job/estimate that that job/estimate number actually becomes theirs.
Recommended best practice.
What is recommended to avoid confusion is to click the "Save" button immediately after selecting the customer. This will prevent the job or estimate number from changing during the job if someone else saves that number first. If the number does change after you click the "Save" button it just means that someone else already saved that number, but at least you'll know that the number currently showing is for your job/estimate and will remain so.
Changing job and estimate numbers manually from the job or estimate screens.
Even though you do have the ability to change job and estimate number manually it is not recommended unless you are sure that number hasn't already been used, and also that it won't be used in the future. EstiMate will allow you to do this simply to give you more control over the system. The numbers will continue to go in sequential order despite the fact that you might have already used a number.
For example if you current job number is 500, and you change it to 550 and save it the next job you open will be 500 because 500 was never saved. If you continue to do jobs in order when you get to 550 EstiMate will NOT skip that number it will duplicate it. One thing EstiMate will allow you to do though is to use other characters other then just numbers. So.. you could create job number 550A, and that would help set it apart from number 550 when it comes up.
Changing job and estimate number for the entire system through System Settings.
If you ever need to change the current starting number(s) in EstiMate you can do so by clicking on "Configure And Manage > System Settings > Advanced Settings". If you are in Multi-User Mode you will first need to switch into Single User Mode by clicking the EstiMate icon in the upper left and selecting "Switch To Single User Mode".
Q: I'm getting a message when I open EstiMate that says "The license file on the server is newer than the one on your local machine. Would you like to update your local license file?" I always just say "No" to this message, but it keeps coming up. Should I be saying "Yes"?
A: This is not an error message, but you may see this from time to time. This message could have a few meaning, but normally it appears if someone in the shop downloaded a new license file from their copy of EstiMate.
Normally downloading a new license file is not necessary unless you have purchased new plugins, or if you were instructed to do so by EstiMate Technical Support. In a multi-user environment the updated license file gets sent to the server, and then when the other copies of EstiMate connect to the EstiMate Multi-User Server they are informed by this message that there is a newer license file available.
In any of these cases it is fine to just click "Yes" to update your license file. You will especially want to say "Yes" to this message if you know you have just recently purchased new plugins, so that the new options are available in your copy of EstiMate.
Q: I'm trying to get into the System Settings, but EstiMate keeps telling me I need to be in Single User Mode to access that section. How do I switch to Single User Mode?
A: You must be in Single User Mode to perform certain operations in EstiMate. A few of these things include restoring a backup, deleting materials, deleting users, deleting customers, accessing the System Settings, and Importing you EstiMate 1.98 data.
Q: I've forgotten my password. How can I find out what it is?
A: There are a couple of places in EstiMate that a password is required. The first place is during the registration process when you first install EstiMate 2 on your computer/s. The very first time you register your software you will be asked to create a password (you will only be asked to create the
password once and that 1 password is what you will use for all of your
installs of EstiMate). This password can be any combination of numbers and letters, and must be at least 1 character long (NO Blank Passwords), and not longer then 32 characters. This password will be used to register any subsequent installs of EstiMate . If you have forgotten you registration password blow are the steps to take to try and recover it.
To Recover your registration password.
The second type of password in EstiMate 2 is the Login password. You may not have a login password if you are only running EstiMate on one computer in Single User Mode. The default account in EstiMate 2 is the "Admin". If you don't set a password for the Admin then you should not get the login screen. If you have set a password for the Admin then you will either log in with those credentials (i.e. Username: Admin + Password: *******), or if you've created any additional users (which you can only do after setting the Admin password) then you can log into one of those accounts with one of those usernames and password.
To recover your login password (Admin).
Q: I want to purchase EstiMate 2, but I'm wondering if I need EstiMate Pro or Enterprise. What are the key differences between the two?
A: EstiMate Pro is great for the smaller shops as well as new shops, or shops that may already have scheduling/job management software, and accounting/invoicing software such as QuickBooks.
With EstiMate Pro you have the ability to:
With EstiMate Enterprise you have the ability to do everything above as well as:
Q: In the settings for the Multi-User Server I have the option to start automatically when Windows starts, but it's not working. How can I fix this?
A: The reason the Multi-User Server is not starting is because the registry entry that tells Windows were the executable file is doesn't' have quotes around it, and so Windows stops at the first "space" it sees and opens the EstiMate folder instead.
To fix this.
Q: What plugins come with EstiMate by default?
A: When you first order EstiMate you will have a 60 day trial period to try all of the plugins that we offer. Once the trial period has ended you will have four plugins: Labor Items, Free Form, Line Item Group, and then one other plugin of your choice.
Here is the complete list of plugins:
Q: I've just purchased EstiMate 2. Do I need to uninstall my EstiMate 1 software before installing EstiMate 2?
A: The answer is No. EstiMate 2 is a completely new application, and will not interfere with EstiMate 1 at all (or vise versa). You will also need EstiMate 1 installed if you wish to import all of your data from EstiMate 1 into EstiMate 2. Once you've imported your data you may still want to keep EstiMate 1 installed as you may need to refer back to it while setting up your new software (NOTE: be aware though that you cannot have EstiMate 1 and 2 open at the same time).
After you have EstiMate 2 up and running, you may then want to consider uninstalling EstiMate 1 so that you or an employee don't inadvertently use it to quote a job (as that could get a bit confusing, and will most like cause you to have to retype the quote into EstiMate 2). You may also just remove it to save space on your hard drive, but in either case we recommend that you make a backup from within EstiMate 1 before you remove it and/or any of it's folders.
Q: What is QuickQuote used for?
A: Under QuickQuote you will see list of the pricing plugins you currently own, or if you are in your trial period then you will see the list of all the plugins that we currently offer. During your trial period QuickQuote will allow you to try out each of the plugins without the need to create a new job or estimate just to do so.
The main purpose of QuickQuote (as the name and the icon indicate) is to give your customer or perspective customer a "Quick Quote" over the phone. To begin you simply open the respective plugin based on what the customer has asked for, select the materials for the job, and then give them the quote/price without needing to get all of their personal information. When you are finished just click the "Cancel" button at the bottom of the plugin screen, and nothing will be saved (Clicking OK will open a new estimate with that quote as your first line item).
Another good use of QuickQuote is to configure each of your plugins without needing to open a new job or estimate. Just select the plugin you want to configure, and when it opens click the Configure button at the top right.
Some limitations of QuickQuote are that you can only give a quote using one of the pricing plugins at a time. If the customer needs a quote for several items then it would be easier to open a new estimate and select <One Time Cash Customer>, so you can quote the entire job. You also cannot save your QuickQuotes unless you turn them into an estimate.
Q: I'm trying to add a new salesperson, but every time I click OK I get a "blank" error message, and then a second error message that says "Access violation at address 20006E04 in module 'rtl100.bpl'. Read of address 00000000", and then the salesperson's name disappears from the "Name" filed. What am I doing wrong?
A: The issue here is that EstiMate is expecting you to type something into at least the "First Name" field. EstiMate will actually fill in the "Name" field for you if you type the persons name into the "First Name" filed and click OK (if you also type in their "Last Name" it will add that to the "Name" field as well. The rest of the information (category, address, etc. is optional).
Q: I just opened a Work In Progress report, and it's showing "Completed" jobs. How do I get the Completed ones to not show up on the report?
A: There are two default statuses in EstiMate: "Completed", and "In Process". These statuses are hard coded into the system, and can be distinguished in the "Job Status Flags" list by their maroon color . Fixing this issue can be a bit tricky because you can change the names from "Completed" and "In Process" to something else (this is what actually causes the problem in the first place), but you can't delete either of them (and this is what can make fixing this issue kind of tricky/complicated). The difficulty of fixing this issue also depends on how many statuses you have in your list.
To begin:
It is highly recommended you make a backup of your data in EstiMate before you begin this procedure, and that way if your statuses get messed up you can just restore the backup and start again.
If you only have the two default statuses then this won't be too hard because they are just backward.
Now comes the last step:
If you have more statuses then just the two default ones then this procedure can be a bit more tricky and you'll definitely want to make that backup now!
You should be aware of a few things before you begin:
To fix this issue when you have more then the two default statuses:
Does EstiMate connect to the internet without me knowing?
Yes. Each time you launch EstiMate it connects to our website to check if there is an updated version of the software available for download. It transmits no personally identifiable information (no information at all, actually) to the website, and only downloads a single text file (an example is attached to this article).
If you are not connected to the internet, this fails silently. If you are, and an update is found, you will see a message offering you the opportunity to download the update if you choose to.
Q: Do I need to complete the Hourly Rate Wizard, or can I just enter my own rates somewhere?
A: If you are a new EstiMate user, or especially if you've just started business the it will definitely behoove you to fill out the Hourly Rate Wizard, and let EstiMate suggest an hourly rate for you. It will then apply this rate to both your hourly design and production rates.
If you already use EstiMate then when you import your data into EstiMate 2 all of your hourly rates will automatically come over into the new software (NOTE: If you filled in the Hourly Rate Wizard / Overhead Worksheet in EstiMate 1 that information (your expenses) will not come over, just the hourly rates you have set up). If you've moved locations, hired more employees, bought new equipment, etc. it might be in your best interest to run the Hourly Rate Wizard again too at least to see what EstiMate 2 now thinks you should be charging per hour based on that new information.
To run the Hourly Rate Wizard:
Overhead Worksheet.
Work, Profit, and Taxes.
Summary.
If you just want to enter your rates without using the Hourly Rate Wizard:
Q: What parts of a job or estimate will the Spell Checker check?
A: The Spell Checker is there to help you avoid embarrassing spelling mistakes on your quotes and invoices, but it's limited to the Description of your jobs and estimates, and the Line Item Descriptions. It will not check your customer's name, billing or shipping address, or the terms.
To start the spell checker:
Q: How can I see a break down of my expenses and profits for a job?
A: You would do this by looking at the Hard Numbers for either the entire Job/Estimate, or for each individual line item. You can even print them out. The Hard Numbers provide you with a breakdown of where the quoted price was derived from.
To see the Hard Numbers for the individual items or the whole job/estimate:
Here are the names, and definitions of each of the Expense and Profit categories you will see in the Hard Numbers window. The breakdown is much like any traditional P&L (Profit and Loss) Analysis. Expenses on the left Profits on the right.
- Overhead Labor + Profit Labor = the total amount you are billing this customer for labor
- EstiMate breaks it out so you see what percentage is there to cover your bills and what percentage is there for pure profit!
- Overhead Labor + Profit Labor = the total amount you are billing this customer for labor.
- EstiMate breaks it out so you can see what percentage is there to cover your bills and what percentage is there for pure profit!
Q: I know you can make a copies of your line items on your job, but can you copy line items from one job or estimate to another, and if so how?
A: Yes you can copy line items from one job/estimate to another. In order to do this you will need to have both jobs/estimates open at the same time.
Q: I just imported all of my EstiMate 1 data in to EstiMate 2. When I try to open any of my pricing plugins it tells me they have not yet been configured, and asks me if I want to do that now, or just run with the defaults. I've configured all of my plugins once in the first version of the software, do I need to do it again?
A: We have made some changes to the pricing plugins as well as their configuration settings - they've been made better. It is highly recommended that you take the time and configure each of your plugins again. Weather you're just starting out with EstiMate or a seasoned vet you'll want to make sure you're pricing accurately, and consistently, and that means having your plugins set up correctly. It's also a good idea as circumstances change to make sure your pricing software reflects those changes (this means not only updating your material prices, but also possibly your Market Level, Production Speed, etc.)
Some changes that have been made to the configurations screen of some of the plugins are:
For more information on configuring each of your plugins please see your EstiMate help files: "Quote And Produce" > "Help" > "Help Contents". (Contents: Using EstiMate > Quoting With Plugins Overview).
You should only need to configure each plugin once. If you are in a Multi-User environment you should still only need to configure them once from any one copy of EstiMate as long as you are connected to the Multi-User Server. If you configure your plugins, and then notice that your other copies of EstiMate are telling you that your plugins have not yet been configured then most likely the copy of EstiMate that you configured them from was not connected to the Multi-User Server, or those other copies of EstiMate are not currently connected to the Multi-User Server. For more information/help on getting all of your copies of EstiMate 2 connected to the Multi-User Server please see this article from our online Knowledge Base:
http://estimatesoftware.com/support/index.php?pg=kb.page&id=594
Q: What is the recommended size for the logo in EstiMate 2?
A: Importing you logo into EstiMate is easy. EstiMate supports .BMP, .JPEG, .PNG, .GIF, .WMF, .EMF, and .ICO files. When exporting your logo from your graphics program, make it 300 pixels for every inch you want it to print. You'll then be able to adjust the height and width or your logo in EstiMate for the best look on your estimates and invoices.
Bitmap, and JPEG files are usually the best choice for your logo, but no matter what file type you use it's recommended that you keep the file size fairly small. Your logo is one of the first things that Windows loads into memory when EstiMate starts, and it could slow the program down considerably if your logo file is too large.
Q: What is meant by "Market Level slider should use version 1 range" in the Advanced System Settings?
A: This is generally an option more for customers who have used, or have been using EstiMate 1. EstiMate 1 had a shorter range for which to adjust the Market Level sliders (it's still 0-100%, but the dollar amounts in EstiMate 2 will go much higher). You can use this option even if you didn't use EstiMate 1 if you just feel that the range of the EstiMate 2 Market Level sliders is too wide/high (e.g. if at 50% the Market Level is already showing a higher price then you would charge for the example given).
If you want to use the EstiMate 1 Market Level range click the Configure And Manage tab, and then the System Settings button.
When the System Settings window opens up, click the Advanced Settings button, and then check the box next to "Market Level slider should use version 1 range", and click the OK button.
Q: Is it possible to select multiple items to be archived or deleted? If so how do you do it?
A: Yes. After build number 2.2.0.0 you are now able to select multiple items, and either archive, copy, or delete them.
Q: I've just updated my copies of EstiMate to the 2.2.0.0 build, and now I have these "Book" icons next to some of the fields. What are the used for?
A: The open "Book"icons were originally in EstiMate 1, and they allowed you to go directly into the list that corresponded with the field directly to the left of it. Since you could only have one window open at a time in EstiMate 1 this option allowed you to still be able to go into a particular list and edit, or add a new item if need be without closing out of your job just to do that.
This option is now available again in EstiMate 2 starting with build number 2.2.0.0. Even though you can have multiple windows open in EstiMate 2 there are still places in the software where you cannot open a new window until you close the current one (the plugin screens are one such area). Now with the "Book" icon you can easily open a list to check the cost of a material, change the settings on your printer, add a new material, etc., all on the fly. Once you make a change to an item in a list, or to the list itself the changes become effective in the plugin immediately.
To use this feature just click on the "Book" icon next to the field for the material you want to see the list for. The "Book" icons are also next to any other item that has a list like customers, sales taxes, printers, etc.
Q: I want to limit access to certain features in EstiMate by my employees, but I still need them to be able to add new customers to the database. Is there a way to do this without having to increase their permission level, or me needing to add the new customer from my account?
A: Yes. Users set up as "General User" can still add new customers, they are only prevented from deleting, or making them inactive. For them to add a new customer they can simply open a New Job or Estimate, and in the "Job/EstiMate For" field type the new customer's name and press the Tab or Enter key. A message will appear telling them that the "new customer" is not in the list, and they can choose to set them up, or cancel. If they choose "Set up" a New Entry window will appear for them to fill in the rest of the customers information, and save.
A "General User" will always need to add new customers this way as they will not have access to the "People" button on the toolbar. "General Users" can also add other list items such as materials, taxes, upcharges, etc. using the same method as described above, but likewise they are prevented from deleting or deactivating items already in the list.
Q: I would like to be able to export my EstiMate Customer List, so that I can import that list into my PDA. Is there a way to do this, and if so what formats can the list be exported as?
A: Yes. Just about anything you can print in EstiMate can be exported out of EstiMate using the "Print to File" option. If the file coming out of EstiMate is not in the exact layout/format required by your other applications you can always edit it using another program like MS Excel or Open Office Calc.
To export your EstiMate Customer List (or any other list from EstiMate):
Before you begin check with your other applications documentation to see what types of files can be imported. Most applications that allow you to import data will accept text files, so if you are unsure choose Text as the export type.
Now check with your other applications documentation to see if any formatting needs to be done to the file before you can import it. If so Excel, Open Office Calc, or even a simple text editor should allow you to get it in the format it needs to be in to import it.
Q: When I print out my jobs and estimates part of the text is cut off. It looks fine in the preview. How can I fix this?
A: EstiMate reports are static - that is the're are no controls in EstiMate to control margins, fonts, colors, etc., all of that is based on your printer settings.
You can either go directly into your printer settings, or the next time you go to print a job/estimate click the "Properties" button (on the last print screen) before you click the "OK" button to start printing. When the Properties window for you printer comes up you can set the margins correctly, and any other setting your printer allows for, and then click "OK". Click "OK" on the print screen to print the report and see if your adjustments corrected the issue.
Q: When I try to import my EstiMate 1 data into EstiMate 2 I keep getting error messages and the import never finishes. What can I do to fix this, and get all of my EstiMate 1 data imported into EstiMate 2.
A: There can be several reasons why your EstiMate 1 data didn't fully import into EstiMate 2, and there can be just as many error messages indicating why. Basically if your EstiMate 1 software isn't working correctly the import will most likely fail, and so any issues with EstiMate 1 will need to be addressed before you try the import process again. There may also be cases when your EstiMate 1 software seems to be fine, but the import process still does not complete properly. In most all cases EstiMate 2 will report an error which will usually tell you exactly what the issue or offending file in EstiMate 1 is.
To begin troubleshooting these issues:
1. Write down, copy, or take a screenshot of the error message your received in EstiMate 2 during the import process.
2. Close out of the import screen, and exit out of EstiMate 2.
3. Open EstiMate 1 on this same machine, and make sure EstiMate 1 isn't open on any other machines.
4. When EstiMate 1 opens make sure that it's version number 1.98 or greater.
5. Click on "Management" > "Repair/Maintain Data Files", and then click the "Verify and Rebuild Your Data Files" button, and close when it's finished.
6. Close EstiMate 1 and make sure it doesn't crash, or give you any error messages.
7. If you didn't encounter any issue when closing EstiMate 1, open EstiMate 2 and try the import again.
The main issue you might encounter while importing you data is and error that says "Directory is controlled by other .net files". The procedure above should correct this issue. If it doesn't then this is what you will need to do.
1. Again verify that no copies of EstiMate 1 are running anywhere on your network.
2. Click "Start" > "Search", and select "All files and folders". Make sure that the search is looking in your "Local Hard Drives" (usually C:), and type "dox" (w/o the quotes) into the search field, and click the search button.
3. The 3 files we are looking for are "Paradox.lck", "Pdoxusrs.lck", and "Pdoxusrs.net". If any of these files come up, delete them (and only them)
4. Make sure the search has completed before you exit out of it, and make sure you've deleted any and all of the "Paradox", and "Pdoxusrs" files.
5. Open EstiMate 2 and try the import again, and it should work.
The other issue you might encounter if you've had EstiMate 1 for many years is that there may be missing files in EstiMate 1. During the import into EstiMate to you may receive a message that says "File Does Not Exist". It might be for example that you never purchased the Wide Format plugin for EstiMate 1, and so you are missing some of those database files, but now EstiMate 2 is looking for those files. In the error message on the import screen it will tell you exactly what files are missing (e.g. C:\Program Files\EstiMate\Data\threads.db). You will need to call or email us with this information (the missing file names), and we will send those to you with instruction on how to get them in place. Once you've added all of the missing files to your EstiMate 1 data folder you should be able to import all of your data into EstiMate 2.
Q: Sometimes after creating a new line item or switching toolbars I notice that some of the buttons are missing. Why is this, and is there anything I can do to fix this?
A: This is usually just a "screen refresh" issue, and seems to happen (more) when the system (the computer EstiMate is on) is running low on resources. Basically when you switch windows in EstiMate the new window or the window behind the one you were just working on doesn't redraw itself completely (you might be missing a button or two). This isn't really an issue that affects the way the software works, it's just kind of confusing sometimes when you notice certain buttons are missing.
The way to correct this issue is to simply hover/roll over the area where the buttons should be. The "missing" button should then immediately appear on the screen. If the missing elements don't appear try moving the cursor around the whole area next to the missing element just to be sure you've "touched" it.
If the element still does not appear on the screen, save your work, and restart EstiMate. This will server two purposes, 1. it should correct anything causing this issue, and, 2. If you use the Multi-User Server, or single user system with more then one user account then it's possible that the button were "missing" because you were logged in as a "General User", or "Manager", and do not have access to those parts of the software. You can correct this issue when you restart EstiMate and are presented with the Log In prompt. This time be sure to log in as the "Admin" or a user with admin privileges. If this was the case then another thing you will notice when the buttons are missing is that some of the categories/sections they would normally appear in are also not present.
A third possibility for missing elements could be that you were recently in "trial mode", and once you received your permanent license for EstiMate some features were disabled due to the options/packages you chose.
Yet another possibility is that your screen resolution is set really low, and/or your Font DPI is too large, and it's causing some of the buttons or portions of the window to be pushed off screen (which means the buttons are there they are just not visible on the screen). For now you can grab, and drag the window to one side of the screen or the other to see the buttons, but you will want to eventually refer to this EstiMate Knowledge Base article for instructions on how to fix this issue:
http://estimatesoftware.com/support/index.php?pg=kb.page&id=670
Q: I would like to see my full company name on my invoices, and I also have a new address. How do I change my Company Name and Address in EstiMate 2?
A: Your EstiMate 2 license file uses your Company Name, Contact Person, and Address of validate your copies of EstiMate. In order to change that information you will need to call or Email us, and we'll be happy to make the change for you. You are still able to make changes to your main Email address, any of your phone numbers, and shipping address from the System Settings. From there you can also see your Company Name and Address as they appear throughout EstiMate.
Phone: 1-888-304-3300
Email: customerservice@estimatesoftware.org
To open the Systems Settings window:
Q: My Wide Format Printer is not in the list of printers. How do I add my printer?
A: EstiMate has a pretty long list of Wide Format printers. We've included some of the most commonly used printers, as well as their settings (Resolution, print speeds, etc) for your convenience. If your printer is in the list then all you'll need to do is select it as the default printer in the Wide Format plugin. If it's not then you will need to set it up yourself. It's easy to set up your printer if you have all of your setting available. Your printer settings can usually be found in your owners manual, or on the manufacturers website. (NOTE: We do not have settings information for printers other then the ones already in EstiMate).
To add your Wide Format Inkjet printer:
Q: Sometimes jobs I've created don't show up in the Open list. I have a couple of databases and I'm never sure which one I'm connected to. I'm wondering if maybe I'm just in the wrong database. How can I tell which database I'm in?
A: This can happen sometimes if you use the Multi-User Server, or if you just have more then one EstiMate database on your computer. In EstiMate you can see if you are connect to a local folder, or to the Multi-User Server. If you're connected to the Multi-User Server then you'll need to go to the computer which has it installed and check there for the location of the database folder.
To check from EstiMate:
To check the path fom the Multi-User Server:
Q: How can I move my database from one computer to another?
A: The easiest and safest way to move your database would be to make a backup of it in EstiMate, and then restore that backup into a new install of EstiMate. That assumes though that you are just switching EstiMate from one computer to another. If you actually need to move the database to new location on your computer or network you can do that as well.
By default the EstiMate database is located at C:\Documents and Settings\All Users\Application Data\EstiMate\Data on the computer EstiMate is installed on.
If you use the EstiMate Multi-User Server then the database will be located a C:\Documents and Settings\All Users\Application Data\EstiMate\Multi-User Data on the computer that the Multi-User Server is installed on.
If you are using Windows Vista then your EstiMate and Multi-User database will be located at C:\ProgramData\EstiMate\Data, and C:\ProgramData\EstiMate\Multi-User Data respectively.
If you need to move your database you should make a copy of the whole folder (right click on the "Data" folder and select copy). Next navigate to the new location where you would like the database stored and paste the folder there. If you need to move it to a new computer and don't have a network then you will want to copy and paste it onto some sort of removable media like a flash drive. You can then carry the flash drive to the new computer
Q: I would like to create a second database to keep the two parts of my business, and clients separate. How can I create a database in addition to the one I already have.
A: The database is basically just a group of files in a folder, so you can create a New (empty) Folder just about anywhere on your computer or network, and EstiMate will create a database there for you the first time you connect to that folder.
To create a new database.
Windows.
EstiMate.
NOTE: If you use the "New Database" button be sure not to click the "Create Database" button before you've selected a folder for that database otherwise it will put all of the database files on your desktop (and not in a folder, but all over the place).
Q: What is the "Upcharges" section used for, and how do I use it?
A: Upcharges are a way for you to add additional charges to a quote without the need to add them as a separate line item.
Upcharges can be added as either additional time in "Minutes", or as a "Percent" of the total labor time.
You then need to specify weather this is a "Design Task", or a "Production Task". The additional time will then be added to the selected category (i.e. Design Time, or Production Time).
Some examples of Upcharges include:
You can add a new Upcharge from either the Upcharge tab in the plugin, or by going to Items > Upcharges.
To add a new Upcharge to the Upcharges list from the plugin window (on the fly):
To add a new Upcharge from the Items menu (to add multiple Upcharges to the list of Upcharges all at once):
Set up the properties for you new Upcharge:
Then, to add the upcharge into your estimate:
Q: I have a line item that I would like to be at the to of my quote instead of where it currently is. Is there a way to move it from its current position without having to delete all of the items above it?
A: Yes you are able to move your line items up or down in the list one space at a time. The order there are in in the list is how they will appear on the printed quote/invoice.
To move your line items up and down through the list.
Q: How do I print my customer list, and mailing labels?
A: In EstiMate 2 you can pint Mailing Labels (Avery style) to affix to mailings to your customer. You can also print a Customer Phone List (Company, contact, phone, and Email), and a Customer List Complete which also includes physical addresses.
To print any of these lists:
If you need to print out a list of Vendors you have all of the same options. All you need to do is click People > Vendors, and the directions above are the same for the Vendors list.
NOTE: If you don't see the list of customers to select from, or if the report shows up blank restart EstiMate, and that should resolve the issue.
Q: How do I import my contacts from Outlook and other programs?
A: To import your contact from a program other then QuickBooks you'll need to be able to export your contacts as a delimited text file or a .csv (comma separated values) file. If your program will do that then follow the directions below to bring them into EstiMate 2.
Delimited text files are just text files containing database information such as contact information, separated ("delimited") by a character uncommon in the text file, such as a tab or a comma. These fields are often also further demarked by a "separator" such as a quote (") character.
To begin importing your contacts from a text "delimited" or comma separated value file:
Q: I've just purchased some new plugins for my EstiMate software, but they are not showing up in the list when I click "Add Item". How can I get these new items to show up?
A: After you purchase new plugins, addons, or additional licenses you still need to download a new license file to unlock those changes in your software.
To download a new license file:
Purchasing new components for your EstiMate software is one reason you will need to download a new license file, but you will also need to download a new license file if you've changed your company name, or address with us over the phone. You may also need to do this if your temporary license file has expired or become invalidated because the time and date on your computer clock has changed.
Q: When I open EstiMate it tells me "There is a new version of EstiMate available to download". When I click "OK" it brings up a web page. What am I supposed to download?
A: EstiMate does not update itself *automatically* like some other softwares do. However we recently added the ability for EstiMate to check and see if any updates are available to help ensure that you are always running the most current version.
If your computer(s) is connected to the internet and you are running a version of EstiMate greater then 2.0.0.385 then when a new "build" becomes available EstiMate will notify you of this the next time you open it.
To download and install the update:
If EstiMate doesn't prompt you to update because that computer is not connected to the internet or because it's a really early version then you will need to open the updates webpage manually. Here is the link to the EstiMate Updates Page: http://wwww.estimatesoftware.com/2.0/updates.php
If your copies of EstiMate are networked together it is also important to make sure that the EstiMate Multi-User Server is up to date. On the updates page you will also find the link to the Multi-User Server. There will be a message in "red" on the updates page informing you of the latest version of the Multi-User Server. If you are running a version earlier then the one stated you will need to update it as well.
To Update the Multi-User Server:
NOTE: The updates webpage is not only for updating your existing EstiMate 2 software, but also for brand new installations. The two files (eSetup. amd eServerSetup) are the complete program installers, and not just partial updates.
Q: How do I sort the entries in my Open list?
A: The easiest way to sort the entries in your Open list is to click on the "header" you want the list sorted by (e.g. Date, Number, Customer). EstiMate will immediately sort all of your entries by that column. EstiMate will retain the last sort order each time you open the "Open" list however it will not retain more then one sort order, or order of one particular column (for example you can't have it sort by both Customer and Number at the same time - at least not for the entire list).
EstiMate also has some advanced sort options you can use to find the jobs and estimates you're looking for.
EstiMate has 7 headers you can sort the "Open" list by: Customer | Num | Date | Salesperson | Due Date | Archived | Status. You cannot delete any of the headers or add your own.
To show only a single Customer or a group of Customers (Date or bunch of Dates, Salesperson or group of Salespeople, etc):
There are also some "really" advanced sort options for those who know a bit of SQL.
Q: How do I restore a backup EstiMate 2?
A: Restoring a backup is as easy as making a backup. There are a few thing to be aware however before you restore a backup, and overwrite all of your current data.
The first thing to know is that this process is not reversible, unless, you've just made a backup of your current data (which is what we advise if possible, and generally a good idea before you ever do anything *drastic* to the system.)
The second thing is to make sure you are restoring your most current backup. This process will restore everything in EstiMate back to what it was the moment you made that backup. Anything you've done since that point (e.g. created new jobs/estimates, added/edited/deleted materials, customers, changed settings, etc) will be overwritten. It's a good idea to include the date in the filename when making a backup, so you can easily locate the most current backup.
In a Multi-User environment all copies of EstiMate (except the one restoring the backup) must be closed, and it must be in Single User Mode (Blue EstiMate icon - upper left > Switch to Single User Mode).
To restore a backup:
Note: If you receive an error message during the restore process which says "Object TEMboUserSession('long number') was updated by another session", just click the "OK" button to finish the restore. This error will not affect the restore process.
Another thing to be aware of is that you cannot restore a backup directly from a USB Flash Drive (we are not sure why this is currently). To restore your backup you must first move it to a location on your computer, and then it will restore with no problems.
Q: How do I make a backup in EstiMate 2?
A: It's very easy to make a backup of your data in EstiMate 2. It's also very important that you remember to do this on a regular basis as EstiMate does not do this for you "automatically", nor does it remind you to do it.
To make a backup in EstiMate:
If you are using the EstiMate Multi-User Server to connect your copies of EstiMate to the same database then you only need to do the backup from one of the EstiMate stations. This will backup all of the data that is on the Multi-User Server. You don't always have to make the backup from the same machine but it is recommended that you save the backups to a central location so that when you need one you don't have to search multiple computers looking for the most recent backup file.
If you are using more then one copy of EstiMate, but maintaining separate databases then you will need to make a backup from each copy of EstiMate that uses it's own separate database. EstiMate only backs up the database it is currently connected to.
Q: How do I change my job and estimate numbers?
A: In EstiMate 2 there are a couple of ways to change your job and estimate numbers. There are also a couple of ways to "track" your numbers - You can track your job and estimate numbers as one, or you can track them separately.
To change your starting numbers system wide:
To change an individual job or estimate number.
You can change the number of a single job or estimate, but only if you are tracking job, and estimate numbers SEPARATELY. If you change the number of a job or estimate while tracking them as one it will also make the change in the System Settings, and will go forward from the number you just typed in.
EXAMPLE: If the number of the job or estimate you just opened was 1000, and you typed in 1050 when you save that job/estimate it will be 1050. When you open a new job or estimate after that it will be 1000 because 1000 is still the next number in line in the System Settings. However EstiMate will not prevent you from creating duplicate numbers, so when you reach job/estimate number 1050 EstiMate will not warn you that you are about to create a duplicate number.
NOTE: For the reason above it is not usually recommended that you change your job and estimate numbers directly from the job/estimate screen. One thing EstiMate 2 will allow you to do though is to use letters as well as numbers, so if you need to change the number for some reason you could just add a letter to the number (e.g. 1000a) to help differentiate it from the rest.
Q: How do I use the Check In/Out feature so I can take my information on the road with me.
A: You can check your data out and take it on the road with you. This checked out version will basically only allow you to create new jobs or estimates. Once you have finished working with that copy you can create the merge file needed to merge your changes with the main database at the shop.
To check your data out:
Now that you've checked your data out you will need to restore that checked out copy to a location on your laptop. This checked out copy is essentially a backup that you will need to restore once you are connected to a local folder on your laptop.
After you've finished working in the checked out database you will need to create a merge file that will be "Checked In" once you've connected back to the shop's main database.
To create the merge file:
Once you're back at the shop you can connect your laptop back to the network. When you open EstiMate it will automatically open up into the Checked Out database.
To connect back to the network:
Now that you are connected back to the shop's database you can merge your changes back into this database.
Now that you work has been merged with the shop's data everyone will be able to see and access the jobs/estimates you created while out on the road. Be aware that any jobs/estimates created in the shop take precedence over what you had created on the road. If you created estimate number 524 in the checked out copy and someone at the shop created estimate 524 as well the one you created will become estimate number 525.
NOTE: Before you begin you must first make sure that your original version of EstiMate is updated to 1.98 or greater. If it is not you can download the latest version here: Update your copy of EstiMate now!
To begin importing your EstiMate 1.98+ data click the Configure And Manage tab one the Ribbon (toolbar), and then click the Import EstiMate 1.98+ Data button.
NOTE: EstiMate 1.98 must be shut down, and must also reside on the same computer EstiMate 2.0 is installed on.
In the next step EstiMate 2.0 will try and locate the data that EstiMate 1.98 has been using. Click the Connect to EstiMate 1.98+ Data button to begin the search.
If EstiMate 2.0 was successful in locating your EstiMate 1.98 data then you may begin importing that data. To begin the import process click the Import Data Now button.
NOTE: This will completely overwrite any work you have done in EstiMate 2.0.
Depending on the amount of data you have in EstiMate 1.98 this process could take several minutes. Once the process is complete you may close the data importer and begin working with your data!
Q: My hard drive failing, and I can't open EstiMate, and I don't have any backups. How can I backup my data/save my data?
A: If the drive is still accessible to grab files off of you should be able to get your data off of there, and onto another media like a USB Flash Drive, or CD-R.
The default location of the EstiMate database is:
C:\Documents And Settings\All Users\Application Data\EstiMate\Data
Under Vista it's:
C:\Program Data\EstiMate\Data
If you use the EstiMate Multi-User Server then your data should already be safely on another computer unless the computer with the failing drive is the one that the Multi-User Server is installed on. If the latter is the case then the data will be located by default at:
C:\Documents And Setting\All Users\Application Data\EstiMate\Multi-User Data
You simply need to navigate to the appropriate location, and make a copy of that entire folder ("Data", or "Multi-User Data" - it will have 47 files in it; all *.nx1 files, and 1 *.cfg file).
NOTE: Since you can pretty much create an EstiMate database/folder anywhere on your computer or network if you ever selected another location for your data you will need to go to that location. If you need to you can search for "*.nx1" w/o the quotes, and it will show you all of the locations on your computer that those files exist. Just make sure the the folder you copy is more then 2.0MB (this is the default size of an EstiMate Data folder). If you do have any backups made from EstiMate they would be "zip" files.
Q: I just recently downloaded and installed the Quick Quoter version of EstiMate 2. Now when I go to launch the program I get an error: "Error: Exception exe violation in module", and EstiMate never opens. How can I fix this?
A: This is a Windows error reporting that it was unable to open the specified application or module for some reason (possibly due to a missing or corrupted program file). This error may also be followed by an Access Violation error which may provide further information about the issue, or offending files.
To fix this issue will depend on what's causing the issue, but generally it's that a file that the program needs is corrupted, been replaced with a different version, is being used by another program, or is just MIA.
If you've just installed the program, or even if you've been using EstiMate the first thing to do is restart the computer it's on. When the computer is back up try starting EstiMate again. In most cases this will have resolved the issue. If you've just installed EstiMate the restart should have allowed all of the newly installed components to be recognized by the OS (which also brings up the point that you should make sure you're using a compatible Operating System - Windows XP or better is what is required.
If you're still encountering the issue the next step will be to reinstall EstiMate.
If you've just installed EstiMate you can go ahead and run the installer (eSetup.exe) again. If you chose to "Run" it the last time from our website you'll need to go back to our website and download it again.
If you've been using EstiMate you'll want make sure you have a recent backup of your data before you reinstall. If you don't have a recent backup you can manually backup your data by making a copy of your EstiMate 2 "Data" folder which by is located at "C:\Documents And Settings\All Users\Application Data\EstiMate\Data", or "C:\Program Data\EstiMate\Data" under Vista.
If after reinstalling EstiMate you're still having issues please contact EstiMate for further assistance.
Q: I've just updated my copies of EstiMate to the latest 2.2.0.0 build. Now when I try to open some of my jobs and estimates including my most recent ones I get an error message that says: " Invalid object class TchpboQuantity Discount in attribute TInstantPart (‘HardNumbers’). Required class TEMboHardNumbers.". I can't open any of those jobs/estimates now, how can I fix this?
A: There was also an update to the Multi-User Server part of the software in the 2.2.0.0 build (NOTE: The Multi-User Server doesn't prompt you to update it like EstiMate does). If you only updated your copies of EstiMate (the clients) then this is most likely the reason you are getting these errors. This issue doesn't seem to permanently affect your data, but you will need update the Multi-User Server in order to stop the error messages and access your jobs and estimates again.
Here are a couple of other error messages you might encounter with this issue:
"Invalid object class TchpboSalesTax in attribute TInstantPart('HardNumbers"). Required Class TEMboHardNumbers."
or this if you try to print:
Invalid Pointer Operation or Error reading value from field ‘HardNumber.DesignLabor’: Access violation at address 2006958 in module ‘rtl100bpl.’ Read of address FFFFFFDC.
Here is a link to the EstiMate update page where you can download the latest builds of EstiMate and the Multi-User Server:
http://www.estimatesoftware.com/2.0/updates.php
Q: I am trying to restore an EstiMate backup I made on my desktop computer to my laptop. When I click the restore button I get an error message that says: "Cannot open file "G:\EstiMateBackup10-15-08.zip". The process cannot access the file because it is being used by another process". How can I fix this?
A: This is usually the result of trying to restore a backup into a copy of EstiMate that is running on a Windows Vista machine, and when the backup is stored on a USB Flash drive, or USB backup drive. The solution is simply to move the "Backup.zip" file off of the USB drive, and on to the computer's hard drive (like the desktop, or My Documents, etc), and then restore it from that location instead. The USB drive is fine for storing the backup and moving it over to the other computer, but it just cannot be restore directly from the drive itself (this is only if the copy of EstiMate you're restoring the backup to is on a Vista machine - if it's on WinXP you should be able to restore directly from the USB drive).
Q: I just updated my EstiMate software to the newest build, and when I try to open my jobs and estimates or access the new Vehicle Wraps plugin I get a Floating Point error. The error says: "Error retrieving object TEMboJob('E6A9AA8BE0F4C1469A92D12B539F9EDA'): "'34.5' is not a valid floating point value".
A: This error can occur if you have your Windows default language (Regional Options) set to something other then English (US) during the installation of the software or an update. The differences in currency symbols, accent marks, date separators, used in other countries can sometimes throw EstiMate after an update, and cause a Floating Point error to occur.
To resolve this issue:
If you've encountered this error then you've most likely already installed the update, and now you need to:
You should now be able to move freely through EstiMate without encountering this error. If for some reason you do still get the error try restarting EstiMate once so that it's able to pick up on the changes you just made.
Q: When I go to make a backup in EstiMate 2 I get an error that says: "NexusDB: CloneDatabase: INTERNAL: File could not be opened [C:\Documents and Settings\All Users\Application Data\EstiMate\Database Backup\nxTrans.cfg, error 32, The process cannot access the file because it is being used by another process] [$2405/9221]."
A: The reason for this error can be seen in the last part of the file path shown in the error message. Somehow EstiMate was connected to the folder called "Database Backup" instead of just the "Data" folder. Basically EstiMate can't make a backup of this folder because it's *already* a "backup" of your database files. The folder you want to be connected to is called "Data" by default. Depending on how long you've been connected to this "Database Backup" folder you may just be able to just switch back to the "Data" folder and continue working, but if you've been connected and working in it for awhile you'll need to follow the procedures below to see how to copy that data and move it to another folder.
To fix this issue (Switching back to the "Data" folder):
EstiMate will open up into the database you just selected. If all of your data is there (i.e. just as it was when you were connected to the "Database Backup" folder) then you should be good to go, and you should now be able to make a backup of your data. If your current jobs and estimates, or none of your data is there (in the "Data" folder) then you will need to copy the files from the "Database Backup" folder and paste them into this folder or you can make a new folder and paste them into that one.
To fix this issue (Copying the files from the "Database Backup" folder, and putting them into a "usable" folder):
Q: When I open EstiMate I get a message that says "It appears the clock has been rolled back on your PC, invalidating your temporary license. Please contact EstiMate technical support for further assistance." What can I do to fix this?
A: The first thing to do is make sure your computer clock is now set to the correct date and time. After checking the date and time (and adjusting it to the correct date and time if need be) try running EstiMate again, and the issue should be resolved.
If you continue to see this error message after you have set the date and time correctly you can download a new license file to fix this issue. To download a new license file from the EstiMate connection screen first click OK on the error message. Next click the "blue" EstiMate icon in the upper left, and select "Download New License File" (you must be connected to the internet). After a few seconds you should receive a message saying that "The new license file has been downloaded. Restart EstiMate to activate any new features." Restart EstiMate and the issue should be resolved.
If the solutions above do not resolve the issue you will need to contact EstiMate Technical Support for further assistance.
If you are beyond your initial 60 days of free support you will need to purchase a "Support Incident" for assistance with this issue.
Q: I get an Access Violation error when trying to use EstiMate 2. What can I do to resolve this issue?
A: Access Violations are a common Windows error which can have a variety of meanings. Below are some possible solutions.
Q: I'm am trying to register my copy of EstiMate, but when I click the next button after entering my serial number it says "Failed to connect to licensing server". How can I complete the registration of my software?
A: Registration is one of the few times that EstiMate needs to have access to the internet. It is important that the computer you are registering from is connected to the internet during that time.
Here are some steps to try and troubleshoot the issue:
If you are still unable to proceed with the Registration after verifying that your internet connection is working on that computer then please contact EstiMate Software by e-mail to: customerservice@estimatesoftware.com or by phone: 1-888-304-3300.
We will then e-mail you a copy of your EstiMate 2 license file. To enable your license file you simply need to save the license file to the Desktop of the computer you are trying to register EstiMate 2 on, and then restart EstiMate. When EstiMate reopens it will *absorb* your license file and place it in the correct folder. This will allow you to bypass the registration process and you will then be able to connect to your database or Multi-User Server.
Q: I just updated to the latest build and now when I click on New EstiMate I get an error message that says "Duplicate Index Value". How can I fix this?
A: This error means that somewhere in your database you have a duplicate entry. It might be a material, tax, or a customer. EstiMate 2 should not allow you to create duplicate entries, but it's possible that it happened in an earlier build of the software or possibly in your EstiMate 1 software. EstiMate 2 now has a feature called the EstiMate Health Check which will allow you to make a backup of your data and then find and rename the duplicate entry.
Here are the instructions for using the EstiMate Health Check utility:
Q: I'm trying to import my data from 1.98 into the new version, but I keep getting an error message that says "Table does not exist". The import then stops and EstiMate says it needs to be restarted. What "Table" is missing, and how do I fix it so I can import my data?
A: Depending on which version of EstiMate 1 you started with and/or which plugins you have enabled you may be missing some database tables from you EstiMate 1 Data folder. During the import process EstiMate 2 looks for these known tables, but if it doesn't find them it aborts the import. The error message you see in EstiMate 2 will also indicate wich tables are missing. It will look something like this:
"Table does not exist: C:\Program Files\EstiMate\Data\Threads.db".
The solution is fairly straight forward, you simply need to add the missing files to your current EstiMate 1 Data folder. The most common missing files are the "Threads" database tables if you started with a very early version of EstiMate or you never had the Embroidery plugin enabled.
We have made these files available on this page for you to download and place in your EstiMate 1 Data folder.
To download the files:
(By default your EstiMate 1 data folder is located at "C:\Program Files\EstiMate\Data", but if you moved it so it could be shared on your network, or just because you wanted it in a different location then you will need to locate the folder and save the files there. If you are unsure where you data folder is located you can open EstiMate 1 and click File > Network Setup and you will see the path to your current data folder).
After you have inserted the missing files you can open EstiMate 2 and try the import again.
Q: I'm getting an error message when trying to load the EstiMate Multi-User Server that says: "Windows cannot access the specified device, path, or file. You may not have the appropriate permissions to access the item".
A: This can be an issue if your database/folder is stored on a computer/drive other then the one the Multi-User Server is loaded on, and that computer/drive is not turned on, or otherwise not accessible. You might also encounter this issue if you are not running the same version of EstiMate and the Multi-User Server.
To fix this issue:
1. First make sure that you are running the same version of both EstiMate and the Multi-User Server (and that they are both updated to the latest version). Here is the link to the updates page:
2. Start the Multi-User Server, or double click on it's icon in the Systems Tray (by the computer clock) to launch it. Click the "Stop Server" button, and then the "Settings" button. Check the path to your Data, and if it's on another computer or drive make sure that computer/drive is on and accessible.
3. Make sure the attributes on your "Data" folder are not set to "Read Only". Also make sure you are logged on as the "Admin" on the computer running the Multi-User Server.
After you have checked the items above click "OK" on the "Settings" screen (if you're still on that screen), and then click the "Start Server" button on the main Multi-User Server window. If it starts up, and says "EstiMate Server Running" then go ahead and try to log in from one of your EstiMate stations, and the issues should be resolved.
If you still encounter this error message after checking the items above, reboot the computer/server running the EstiMate Multi-User Server, and then try starting it again. If you continue to have issues please contact EstiMate Technical Support for further assistance.
Q: When I try to start the Multi-User Server I get an error that says: "An attempt was made to access a socket in a way forbidden by its access permissions. I can't start the Multi-User Server, how can I fix this?
A: This is the result of too many incomplete outbound TCP connection attempts. If a program tries to connect too many times to an IP address which is not valid then Windows will start to impose limits on the number of these connection attempts. Here is an article from the Microsoft Knowledge Base which explains the issue in greater detail, and also provides a solution.
An easier solution is to reboot the EstiMate Multi-User Server computer/server. Once the computer/server is back up launch the Multi-User Server, and it should start right up, and you should be able to connect to it from EstiMate.
Q: I'm trying to add a proof image to my estimate, but I keep getting an error "Unsupported Graphic Stream Format", and the image is not added. How can I get my graphic added to the quote?
A: The Unsupported Graphic Stream Format error means that you might trying to add an image to your quote or as your logo in EstiMate, and it's not one of the supported types. If it is on of the supported types then there might be something preventing EstiMate from reading it (e.g. It's corrupted, has an unrecognized file extension, is being used, etc.).
The supported file/image types that EstiMate can handle are:
For Proof Images:
JPEG
BMP (Bitmaps)
WMF (Meta files)
For your Logo:
GIF
PNG (Portable Network Graphics)
JPEG
BMP (Bitmaps)
ICO (Icon files)
EMF (Enhanced Meta files)
WMF (Windows Meta files)
If you try to use a unsupported format you may encounter the "Unsupported Graphic Stream Format" error, but you may also end up with the image stuck in the program, and require technical support.
If you're adding a supported graphic and encounter this issue, try saving the file out of your graphics program again, or a different graphics program (e.g. if you saved it out of Photo Shop try saving it out of another program, even Windows Paint), and/or as a different file type. Any of the supported types should work, but JPEGs are usually the best choice, and WMF, and EMF sometimes don't work so well.
Q: I'm getting an error message when using the Vehicle Wraps plugin that says "Incompatible Units". How can I fix this?
A: This may be more of a glitch then an issue, but may be the result of some input or selection you made just before the error occurred.
Look at the selection you just made, and any other changes (to dimensions, units of measure, etc.). If you had just selected an item make sure that the properties for that item are correct. You can click on the "book" icon next to the selected item, and it will take you into the list for that "type" of item/material. Double click on the item you had selected, and make sure that all of the properties (dimensions, units, etc.) are correct.
If you still encounter the error try selecting a different item to see if that was it, and then try re-selecting your original item.
If the error persists save what you're working on and then restart EstiMate (or the computer if you been having any computer related issues outside of EstiMate).
If this error occurs the very first time you run the Vehicle Wraps plugin it may also be that the plugin items weren't automatically created like they are supposed to be, and so your Vehicle list, and other associated lists are empty. If this is the case please contact EstiMate support for further help.
The ODBC connector can be found on your EstiMate 2.0 CD. Due to licensing restrictions we are not allowed by the vendor to post this connector here for download, however, if you are using 2.0 please email us at CustomerService@PricingMadeEasy.com and we can send you a link to download it after verifying that you are licensed for EstiMate 2.0.
NOTE: You must be using the EstiMate Multi-User Server in order to use the ODBC connector. It does not work with direct connections to EstiMate data folders.
Some background information:
Disclaimer: we do not directly support the use of the ODBC connector **at all** beyond this document and you must use it at your own risk. We strongly recommend that you back up your EstiMate 2 data files before using the ODBC connector, at least until you are comfortable with its operation and "know what you are doing."™
On your EstiMate 2.0 CD you will see an executable file called "NexusDB_V2_ODBC_buildXX.exe" (the build number will change, this does not matter). See the initial paragraph in this article if you do not have an EstiMate 2.0 CD for how to get the installer from us.
Double click this installer, and click "next through the wizard to install the software. Installing the ODBC connector is just like installing any other software.
In the Server Settings screen, do the following:
On the next page of the wizard, do the following:
Now you will be back at the ODBC Data Source Administrator screen, and you should have a new connection called "NexusDB" (or whatever you chose to call it).
Now that you have the connector installed and configured, you can use it to extract data from the EstiMate 2 data files. You can use Excel, Access, or any ODBC-enabled application to do this. The example provided here uses the OpenOffice 'Base" database program which is an open source (read: free) alternative to Microsoft Access.
First, run OpenOffice Base and you will see the New Database wizard.
On the second page of the wizard:
Now you have direct access to the EstiMate 2 database from within the OpenOffice "Base" database. The same basic principles will apply in Microsoft Access, Microsoft Excel, or any other application that makes use of ODBC database connections within Windows.
We STRONGLY recommend that you do not make ANY changes to the EstiMate 2 data files via the ODBC connector. PLEASE NOTE that we do NOT support repairing your data files if they are damaged as a result of using the connector, and therefore you really ought to back up your data files before doing anything. ;-)
The thermal and wide format printing plugins charge for trimming and cutting as follows:
Then they calculate the time by multiplying the number of square inches in the job by the time per square inch based on the above list.
For example, if you have a 24"x48" print and set the trimming to "Moderate":
In EstiMate 1.x the substrate list was shared between the vinyl plugins and the digital printing plugins. In 2.0, they are separate. The confusion arises when you import your 1.x data, because the substrate list is imported into both places and they appear to be the same. However, they are two separate lists.
For vinyl plugins, to edit substrates, click:
Items > Plugin Items > Substrates
For the digital printing plugins, to edit substrates, click:
Items > Plugin Items > Mounting Substrates
One very helpful feature in version 2 is the ability to drag and drop between lists, and this can be very helpful in setting up new substrates that you wish to appear in both lists. For example, you can create a new vinyl sign substrate and then drag/drop it into the mounting substrates list, as long as both are open on your screen.
Q: I'm getting an error when exporting some of my jobs to QuickBooks. The error says "Internal Error: Failed to parse float. What does this mean and how can I fix it?
A: The reason for this error is that you have selected a "Tax" item from your list for one or more of your line items which has a rate of 0.0%. It happens sometimes that customers create a tax item called "Non Tax", or "No Tax", or similar to show that the item is not taxed, and they give it a rate of 0.0% so that no tax is applied. This is not the correct way to specify a non taxed item in EstiMate 2. The correct way to have no tax applied to a line item is to "blank" out the tax field for that item (put your cursor in the "Sales Tax" filed, and delete anything that is there).
To fix this issue so that your jobs/estimates will export to QuickBooks without issue you will need to go back through the jobs/estimates that failed to go to QuickBooks due to this error, and remove from the Sales Tax field any "Non Tax" or Tax that has a 0.0% rate (just blank out the Sales Tax field.
If the whole job is to be "Non Tax" then you can simply check the "No Tax" box on the main job or estimate screen.
After you have corrected this issue in your jobs and estimate you can transfer them again, and they should export to QuickBooks without issue.
Is The QuickBooks Link Compatible With Non-US Versions Of QuickBooks?
Unfortunately not. We have worked very hard to make the QuickBooks link compatible with the Canadian and UK versions of QuickBooks, but unfortunately there are several technical hurdles preventing that and we apologize to our international customers who have been waiting for this product.
Essentially, Intuit's SDK (Software Development Kit) - for the US - offers access to all versions of QuickBooks 2004 and later, with one easy integration method. On the other hand, the international versions are very scattered and we have had limited success connecting with them. It was our assumption that it would be as straightforward as integrating with the US edition that led us to announce compatibility with these editions in the future.
As a result, we are focusing on the US version of QuickBooks as we do not have the resources to maintain several different versions of the QuickBooks link for different international editions.
If the integration issues improve we will wholeheartedly embrace development for international platforms.
Q: I've just installed QuickBooks and EstiMate on my computer, how do I set them up so I can send my jobs over to QuickBooks?
A: Before you setup the QuickBooks link in EstiMate you should first have QuickBooks set up for the way you plan to work. What is meant by this is that you first need to have some accounts and items set up in QuickBooks, so that you can associate that with what's in EstiMate.
The QuickBooks side:
The EstiMate Side:
Now that you've set everything up in QuickBooks it's time to associate these items with the items in EstiMate.
To Begin:
Q: I am trying to set up the QuickBooks Link, but when EstiMate tries to connect to it I get an error message that says "Failed to connect to running instance of QuickBooks. Check to see that no dialog boxes are open in QuickBooks and try again". There are no open dialog boxes, and QuickBooks and my company file are open. How can I get this to work?
A: There are only a few basic requirements that need to be met in order to use the QuickBooks Link, but it is important that you have these things set correctly otherwise the link will fail.
Here is a list of the basic requirements needed to connect to QuickBooks:
As long as you have met all of these requirements you shouldn't have any problems connecting to QuickBooks from EstiMate. If you have made sure all of these settings are correct, but you are still having issues please contact us for further assistance.
Q: I'm considering buying the QuickBooks Link, but I'm wondering what information is transfered from EstiMate to QuickBooks?
A: The main function of the QuickBooks link is to allow you to export your jobs and estimates to QuickBooks as invoices that you can bill the customer with and then receive payment for. You can also export your Customer List from EstiMate to QuickBooks and vice versa.
Some things that do not get sent to QuikBooks on the invoice are the Terms, Salesperson/Rep, and the main Description from the job or estimate.
You can also send you jobs/estimates to QuickBooks as Estimates or Sales Receipts.
When you export you Customer list from EstiMate to QuickBooks the fields that get exported are:
This is due to the time required to pull over the QuickBooks customer list from QuickBooks into EstiMate. Unfortunately our hands are tied at the moment to speed this up; however, be patient and the list will come over. On our development system (P4 3 GHz with 2 GB RAM) 4,500 customers takes about 4 minutes total. This should scale to your customer list so you can approximate the time that will be required.
We are definitely looking into ways to speed this up but haven't found a good way yet. This article will be updated when we do.
Q: I'm getting an error message when I try to export my transactions to QuickBooks. The error message says:
"Failed to add customer Customer Name to QuickBooks: 511: The QBRequestId has been used previously for another request. Please use a different Id."
Followed by:
"Failed to add invoice 731 to QuickBooks: 808: There is an invalid reference to QuickBooks Customer "Customer Name" in the Invoice. QuickBooks error message: The specified name is either invalid or of the wrong type."
What can I do to get my transactions to export correctly?
A: When you get an error message that has the numbers 511 and 808 and/or that says "The QBRequestId has been used previously for another request" then the problem is that QuickBooks is trying to use the same "Token" it used for your last/previous export. The solution can be 1 of 2 things - 1. You can restart both QuickBooks and EstiMate and then try the export again, or 2. If that doesn't fix it then reboot your computer and that will correct the problem.
Q: I am getting an error message while trying to export my transactions to QuickBooks that says "You cannot use the same tax item in both the line items and the txn tax". This is causing most of my transactions to fail, and not show up in QuickBooks. What can I do to fix this?
A: This seems to be an issue with QuickBooks rather then EstiMate. This issue is similar to the one caused by exporting transactions from QuickBooks POS to QuickBooks. It seems to currently only affect our customers who are running QuickBooks 2008 R5 (Release 5). Here is the link to the QuickBooks support page for this issue. The article outlines a couple of fixes that should help you correct the issue.
http://support.quickbooks.intuit.com/support/Pages/KnowledgeBaseArticle/9ce87907
Q: I have sales taxes applied to my jobs in EstiMate, but when I export them to QuickBooks they don't have any sales tax applied to the invoice. How can I get the sales taxes to show up in QuickBooks on jobs sent from EstiMate?
A: The answer is usually a simple one. The items you have in your QuickBooks "Items List" which are associated with EstiMate Items are most likely set to "Non" (Non-Taxable that is). The QuickBooks setting will override the tax information being sent with the job(s) from EstiMate. You would also encounter this issue (in the reverse) if you send a job from EstiMate that is not taxable, or has non taxable line items, but the associated item(s) in QuickBooks are set to Taxable.
To correct this issue:
1. You may need to open the "Configure QuickBooks Link" window ("Configure And Manage" > "QuickBooks Link" > "Configure QuickBooks Link"), if you don't remember which EstiMate Items, are associated with which QuickBooks Items.
2. Once you determined the associations go into QuickBooks, and open the Items List ("Lists" > "Items List").
3. In the Items List find the associated item(s), and double click on them to view their properties sheet.
4. At the bottom right of the properties sheet you will see a section called "Tax Code".
5. If it's set to "Non" that is why your jobs didn't show any tax once they had been exported to QuickBooks.
6. Set the Tax Code field to the appropriate setting (i.e. Tax, or Non), and click the "OK" button.
7. Repeat the above steps for any other associated items which may be set to the wrong Tax Code.
You will need to go back through your QuickBooks Invoices that came from EstiMate, manually add the tax, and record the changes if you haven't already done so.
Q: I'm trying to e-mail a quote out of EstiMate, but when I click the Email button in EstiMate nothing happens. What do I need to do to get EstiMate to e-mail my quote?
A: The first thing to be aware of is that EstiMate will only work with "stand-alone" e-mail clients like Microsoft Outlook, Outlook Express, Mozilla Thunderbird, Eudora, Sea Monkey, etc.. It will not work with web mail like Yahoo, Hotmail, or Gmail (unless you have configured one of the above "stand-alone" clients to retrieve e-mail from one of these services using POP or IMAP).
There are a few possible reasons why EstiMate might not launch your e-mail client. These reasons, and the solutions can vary slightly depending on which e-mail client you are using.
The first thing to do is check and see if the e-mail client you want to use is set as the default e-mail client under Windows.
To check/change the default e-mail client:
This will normally solve the problem if you needed to switch the default from something like AOL, Hotmail, or MSN to Office Outlook, or Outlook Express. If your e-mail client is Thunderbird or Sea Monkey then it is usually more effective if you make the change directly from the e-mail client.
To set Mozilla Thunderbird as the default e-mail client:
These directions should also work for Sea Monkey.
If you are still unable to e-mail a quote then it is possible you may be missing a key value in the Windows Registry. This key is for a protocol called MAPI. MAPI stands for Messaging Application Programming Interface, and is what allows EstiMate to "talk" to your e-mail client.
To check this follow the procedure below. (NOTE: There is one additional step for Windows 7 users).
**The following instructions may require you to make changes to the Windows registry. You should always use caution when editing the registry and never make changes other then those outlined in the instructions. User assumes all risk**
This procedure is to check and see if you have the use of MAPI (Messaging Application Programming Interface) enabled, and if not, how to enable it.
Additional: Windows 7 users may also need to add a second String Value called "InstallCmd".
If you don't see InstallCmd then again click Edit > New > String Value. When the new string appears on the right side of the screen type in the name InstallCmd. Next double click on this string and type in (or copy it from here) the value "rundll32 setupapi,InstallHinfSection MSMAIL 132 msmail.inf" (w/o the quotes), and click OK.
That's it. With this necessary string now in place you should be able to e-mail out of EstiMate. If you are still unable to e-mail a quote then it's possible the e-mail client you are using does not support MAPI, and you may have to choose a different e-mail client.
Q: I'm getting an error message every time I try to start EstiMate that says "Could not connect to network server. Check if it is online and try again. It is also possible that the server is built for an earlier version of EstiMate and needs to be updated, or you may need to open TCP port 16000 on the machine running the server.
A: Normally this is just because the EstiMate Multi-User server is not running.
To launch the EstiMate Multi-User Server:
Connecting to the Multi-User Server from EstiMate:
Note: Even after you start the Multi-User Server EstiMate might start up in "Single User Mode" if the last database you opened was opened "locally". and not through the Multi-User Server. If this happens simply click the EstiMate icon in the upper left, and select "Close Database". Now you will be back at the "Connect" screen, and you can click "Connect to selected server" to get connected to the Multi-User Server.
Q: I'm trying to connect a copy of EstiMate 2 to the EstiMate Multi-User Server, but I'm getting an error message "Could not connect to network server.... You may need to open TCP Port 16000". How do I open TCP port 16000?
A: Here are the instructions for opening TCP port 16000 on the computer running the EstiMate Multi-User Server (this is the only machine you need to open this port on).
You can now try connecting to the EstiMate Multi-User Server again from one of your copies of EstiMate 2 (just make sure the Multi-User Server is up and running (and only on one computer) before you do, as this is most commonly the issue when you encounter connection issue in EstiMate - the Multi-User Server just isn't running).
Q: EstiMate says I'm in Single User Mode, but I'm running the Multi-User Server. How do I get back into Multi-User Mode?
A: The first thing to do in this situation is make sure that the Multi-User Server has been started and is running in the systems tray (by the computer clock).
To launch the EstiMate Multi-User Server: *If the Multi-User Server is already running skip this step.
Now open EstiMate or bring it back to the front if it was already running. To get EstiMate out of Single Use Mode and back in to Multi-User Mode:
You should now be in Multi-User Mode.
NOTE: EstiMate will always default to the last database it was connected to. Once you've connected to the Multi-User Server database from a copy of EstiMate *that* copy of EstiMate will continue to connect back to the Multi-User Server each time EstiMate is started. If the Multi-User Server is not running you will get an error message in EstiMae telling you that it can't connect to the Multi-User Server. If you get this message make sure the Multi-User Server is running. DO NOT click "Connect to Local Folder" in an attempt to connect to the Multi-User Server or it's data otherwise you will be making changes in a local database and not in the main shared database. Changes made locally cannot be merged with any other data.
Q: EstiMate seems to run very slowly when it's connected to the Multi-User Server. Do I have too much data or do I have something set up wrong? What can I do to fix this issue?
A: The EstiMate Multi-User Server is used to allow simultaneous connections to your EstiMate data. It is capable of handling many connections at once as well as large amounts of data, so slowness issues are not normal. If you experience log waits while trying to connect to the Multi-User Server, and/or long delays while trying to open windows within the program it's possible that you are not running the most current versions of each component, or that something is interfering with the transfer of your data.
The first thing to do is to make sure you have the most updated version of the client and server.
The next thing to do is to make sure another software application is not interfering with the connection between EstiMate and the Multi-User Server.
Q: Where should the Multi-User Server be installed?
A: You can install the Multi-User Server on any server, workstation, or desktop computer that is connected to the rest of the network. Which ever computer you decide to install the Multi-User Server on you'll wan't to keep in mind that it will need to be on, and logged into an account with the Multi-User Server running anytime someone needs to use EstiMate. You may also want to install the Multi-User Server onto a computer that others have access to in case it needs to be started or restarted when you're not around.
You data will reside on the computer that the Multi-User Server is installed on by default. You can if you need/want install the Multi-User Server on one computer, but have it connect to a database stored on another computer (e.g. server, external drive, NAS, etc). To do that you would first install the Multi-User Server onto 1 of your computer. Next you would open the Multi-User Server, stop it by clicking the "Stop Server" button, and then click the "Configure" button to change the path to your data. Under "Data" you can now either type the new path to your data or click the browse folder to the right and navigate to your data (or to an empty folder if you just want to create a new database).
Q: I've just installed EstiMate and it created a default database. I would like for the database to be stored on my server computer where it will be backed up. Can I put the database there or does my database have to be on the same computer as EstiMate?
A: Your EstiMate database can be located anywhere on your local network. It does not have to be on the same machine as EstiMate or the Multi-User Server, and can even be located on an external drive, or NAS. The only thing you need to do to start a new database on a separate computer or drive is to create a new folder there, and then connect to it.
To begin: