Skip to main content

Rebuild Database

There may come many different times where you find that you have some corruption in your database, an error informing you that you will need to rebuild or data is just not looking correct. In these events, we always recommend that you rebuild your database. This tech tip will walk you through the steps of completing just such a process. Please note you will need to shut down the POSIM applications running on the other computers. With that in mind, you will not be able to run POSIM while the rebuild is taking place. Also, you must backup your database before beginning. If you’re not sure about the steps required for that, see the associated tech tip to walk you through those steps.

Rebuilding POSIM Diamond Database (Mac)

  • Quit out of all the POSIM applications
  • Quit out of POSIM Share Server.
  • Open your POSIM Diamond Folder. **Note, by default it is located in the root of your hard drive, but can also be found in your Applications Folder. It greatly depends on where you installed it to.
  • Now, open the application called Supervisor Tools. There will not be any Application Bar, like the other programs have, but you will see in the Top Left corner of the screen the application name has changed to Supervisor Tools.
  • In the Supervisor Tools click on File and choose Rebuild Database.
  • A new window will appear with different table selections you can choose to rebuild. Unless otherwise directed, please press the button for Rebuild All. This will ensure that you are rebuilding all the data to ensure conformity throughout the database.
  • The program will prompt you on where you wish to save your rebuilt database. Please save it to somewhere that you will be able to locate easily again. The rebuild will begin.
  • This will take some time, depending on the size of your database and the speed of your computer. We have no estimate on how long, so it’s suggested that you get yourself a cup of coffee and a snack. If it finishes quickly, you still have your cup of coffee and a snack.
  • Once the rebuild is done the system will inform you. Press Done and the Rebuild Window will disappear. Now you’ll need to quit out of Supervisor Tools by pressing the bold Supervisor Tools wording in the top left and selecting Quit.
  • Now you’ll need to locate the location where you saved your rebuilt database and copy it by highlighting the file and pressing Command and C (⌘+C). This will copy the database.
  • Next, go into your POSIM Diamond Folder, then go into the POSIM Data folder. You’ll need to highlight the current POSIM_DB file and rename it to something different, like POSIM_DBold
  • Now paste your rebuilt database into there by pressing Command and V (⌘+V).
  • You’re done. Start your POSIM Share Server and get your business underway.
[gravityform id="17" title="false" description="false" ajax="true" tabindex="88"]
<div class='gf_browser_unknown gform_wrapper' id='gform_wrapper_17' ><div id='gf_17' class='gform_anchor' tabindex='-1'></div><form method='post' enctype='multipart/form-data' target='gform_ajax_frame_17' id='gform_17' action='/knowledgebase/rebuild-posim-diamond-database/#gf_17'> <div class='gform_body'><ul id='gform_fields_17' class='gform_fields top_label form_sublabel_below description_below'><li id='field_17_6' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_6' id='input_17_6' type='hidden' class='gform_hidden' aria-invalid="false" value='https://app-3QNL6WU154.marketingautomation.services/webforms/receivePostback/MzawMDG3NDO0AAA/' /></li><li id='field_17_7' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_7' id='input_17_7' type='hidden' class='gform_hidden' aria-invalid="false" value='0994ba05-06b3-460d-b11c-4f3b11093ec9' /></li><li id='field_17_8' class='gfield gform_hidden field_sublabel_below field_description_below gfield_visibility_visible' ><input name='input_8' id='input_17_8' type='hidden' class='gform_hidden' aria-invalid="false" value='POSIM' /></li><li id='field_17_11' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_11' >First<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_11' id='input_17_11' type='text' value='' class='large' tabindex='88' placeholder='First Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_10' class='gfield gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_10' >Last<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_text'><input name='input_10' id='input_17_10' type='text' value='' class='large' tabindex='89' placeholder='Last Name' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_2' class='gfield posim-email gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_2' >Email<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_email'> <input name='input_2' id='input_17_2' type='text' value='' class='large' tabindex='90' placeholder='Email' aria-required="true" aria-invalid="false" /> </div></li><li id='field_17_3' class='gfield posim-phone gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_3' >Phone<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_phone'><input name='input_3' id='input_17_3' type='text' value='' class='large' tabindex='91' placeholder='Phone' aria-required="true" aria-invalid="false" /></div></li><li id='field_17_5' class='gfield posim-industry gfield_contains_required field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_5' >Your Industry<span class='gfield_required'>*</span></label><div class='ginput_container ginput_container_select'><select name='input_5' id='input_17_5' class='large gfield_select' tabindex='92' aria-required="true" aria-invalid="false"><option value='' selected='selected' class='gf_placeholder'>Your Industry</option><option value='Apparel' >Apparel</option><option value='Hobby' >Hobby</option><option value='Household' >Household</option><option value='Liquor_Wine_Beer' >Liquor, Wine &amp; Beer</option><option value='Needlearts' >Needlearts</option><option value='Quilt_Fabric_Sewing' >Quilt, Fabric &amp; Sewing</option><option value='Outdoor' >Outdoor</option><option value='Other' >Other</option></select></div></li><li id='field_17_12' class='gfield field_sublabel_below field_description_below hidden_label gfield_visibility_visible' ><label class='gfield_label' for='input_17_12' >CAPTCHA</label><div id='input_17_12' class='ginput_container ginput_recaptcha' data-sitekey='6LcWicwZAAAAAF6_JZFIf_bEpNSyHe5AsCdrkgmD' data-theme='light' data-tabindex='-1' data-size='invisible' data-badge='bottomright'></div></li><li id='field_17_13' class='gfield gform_validation_container field_sublabel_below field_description_below gfield_visibility_visible' ><label class='gfield_label' for='input_17_13' >Phone</label><div class='ginput_container'><input name='input_13' id='input_17_13' type='text' value='' /></div><div class='gfield_description' id='gfield_description_17_13'>This field is for validation purposes and should be left unchanged.</div></li> </ul></div> <div class='gform_footer top_label'> <input type="submit" id="gform_submit_button_17" class="gform_button button om-trigger-conversion" value="Request My Demo" tabindex="93" onclick='if(window["gf_submitting_17"]){return false;} window["gf_submitting_17"]=true; ' onkeypress='if( event.keyCode == 13 ){ if(window["gf_submitting_17"]){return false;} window["gf_submitting_17"]=true; jQuery("#gform_17").trigger("submit",[true]); }'> <input type='hidden' name='gform_ajax' value='form_id=17&amp;title=&amp;description=&amp;tabindex=88' /> <input type='hidden' class='gform_hidden' name='is_submit_17' value='1' /> <input type='hidden' class='gform_hidden' name='gform_submit' value='17' /> <input type='hidden' class='gform_hidden' name='gform_unique_id' value='' /> <input type='hidden' class='gform_hidden' name='state_17' value='WyJbXSIsIjFmYmJkMmM5NDAyMGYzNTJmZGM3MmU0ODNlNDM2YjBmIl0=' /> <input type='hidden' class='gform_hidden' name='gform_target_page_number_17' id='gform_target_page_number_17' value='0' /> <input type='hidden' class='gform_hidden' name='gform_source_page_number_17' id='gform_source_page_number_17' value='1' /> <input type='hidden' name='gform_field_values' value='' /> </div> </form> </div> <iframe style='display:none;width:0px;height:0px;' src='about:blank' name='gform_ajax_frame_17' id='gform_ajax_frame_17' title='This iframe contains the logic required to handle Ajax powered Gravity Forms.'></iframe> <script type='text/javascript'>jQuery(document).ready(function($){gformInitSpinner( 17, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery('#gform_ajax_frame_17').on('load',function(){var contents = jQuery(this).contents().find('*').html();var is_postback = contents.indexOf('GF_AJAX_POSTBACK') >= 0;if(!is_postback){return;}var form_content = jQuery(this).contents().find('#gform_wrapper_17');var is_confirmation = jQuery(this).contents().find('#gform_confirmation_wrapper_17').length > 0;var is_redirect = contents.indexOf('gformRedirect(){') >= 0;var is_form = form_content.length > 0 && ! is_redirect && ! is_confirmation;var mt = parseInt(jQuery('html').css('margin-top'), 10) + parseInt(jQuery('body').css('margin-top'), 10) + 100;if(is_form){jQuery('#gform_wrapper_17').html(form_content.html());if(form_content.hasClass('gform_validation_error')){jQuery('#gform_wrapper_17').addClass('gform_validation_error');} else {jQuery('#gform_wrapper_17').removeClass('gform_validation_error');}setTimeout( function() { /* delay the scroll by 50 milliseconds to fix a bug in chrome */ jQuery(document).scrollTop(jQuery('#gform_wrapper_17').offset().top - mt); }, 50 );if(window['gformInitDatepicker']) {gformInitDatepicker();}if(window['gformInitPriceFields']) {gformInitPriceFields();}var current_page = jQuery('#gform_source_page_number_17').val();gformInitSpinner( 17, 'https://posim.com/wp-content/plugins/gravityforms/images/spinner.gif' );jQuery(document).trigger('gform_page_loaded', [17, current_page]);window['gf_submitting_17'] = false;}else if(!is_redirect){var confirmation_content = jQuery(this).contents().find('.GF_AJAX_POSTBACK').html();if(!confirmation_content){confirmation_content = contents;}setTimeout(function(){jQuery('#gform_wrapper_17').replaceWith(confirmation_content);jQuery(document).scrollTop(jQuery('#gf_17').offset().top - mt);jQuery(document).trigger('gform_confirmation_loaded', [17]);window['gf_submitting_17'] = false;}, 50);}else{jQuery('#gform_17').append(contents);if(window['gformRedirect']) {gformRedirect();}}jQuery(document).trigger('gform_post_render', [17, current_page]);} );} );</script><script type='text/javascript'> jQuery(document).bind('gform_post_render', function(event, formId, currentPage){if(formId == 17) {if(typeof Placeholders != 'undefined'){ Placeholders.enable(); }jQuery('#input_17_3').mask('(999) 999-9999').bind('keypress', function(e){if(e.which == 13){jQuery(this).blur();} } );} } );jQuery(document).bind('gform_post_conditional_logic', function(event, formId, fields, isInit){} );</script><script type='text/javascript'> jQuery(document).ready(function(){jQuery(document).trigger('gform_post_render', [17, 1]) } ); </script>