Balance Point Technologies, Inc.
Quick Data Loader Balance Point Technologies, Inc. www.maxtoolkit.com Quick Data Loader User Guide www.maxtoolkit.com Certified MAX Integrator 1 Page
Quick Data Loader Copyright Manual copyright 2017 Balance Point Technologies, Inc. All Rights reserved. Your right to copy this documentation is limited by copyright law and the terms of the software license agreement. As the software licensee, you may make a reasonable number of copies or printouts for your own use. Making unauthorized copies, adaptations, compilations, or derivative works for commercial distribution is prohibited and constitutes a punishable violation of the law. Trademarks Microsoft, Microsoft Dynamics GP, and SQL Server are registered trademarks of Microsoft Corporation or their affiliates. MAX is a registered trademark of Exact Software or their affiliates. Unless otherwise noted, all names of companies, products, street addresses, and persons contained herein are fictitious and are used solely to document the use of this product. Warranty Balance Point Technologies, Inc. disclaims any warranty regarding the sample code contained in this documentation, including the warranties of merchantability and fitness for a purpose. Limitation of Liability The content of this manual is furnished for informational use only, is subject to change without notice, and should not be construed as a commitment by Balance Point Technologies, Inc. Balance Point Technologies, Inc. assumes no responsibility or liability for any errors or inaccuracies that may appear in this manual. Neither Balance Point Technologies, Inc. nor anyone else who has been involved in the creation, production or delivery of this documentation shall be liable for any indirect, incidental, special, exemplary or consequential damages, including but not limited to any loss of anticipated profit or benefits, resulting from the use of this documentation or sample code. License Agreement Use of this product is covered by a license agreement provided by Balance Point Technologies, Inc. with the software product. If you have any questions, please call Balance Point Technologies, Inc. at (847)265-3797. Publication Date February 2017 www.maxtoolkit.com Certified MAX Integrator 2 Page
Quick Data Loader Table of Contents Purpose . 4 Minimum System Requirements . 4 Installation . 4 Settings Configuration . 6 Main Window. 7 Bill of Material . 8 Supported tables on the Static Data tab . 9 Supported order imports on the Orders tab. 10 Supported transactions on the Transactions tab. 10 Main Window Operation . 10 Defaults Specification . 13 File Templates . 15 Settings. 17 www.maxtoolkit.com Certified MAX Integrator 3 Page
Quick Data Loader Purpose Quick Data Loader provides methods for quickly populating data in an existing MAX database. All data is imported from Excel files. Quick Data Loader supports Excel files with multiple worksheets and also allows the user to verify the data in the worksheet before it is actually imported. Minimum System Requirements .NET Framework 4.5 EXACT MAX Software v5 SQL Server 2008 Microsoft Office 10 or later Installation Quick Data Loader is automatically downloaded and installed by MAX Workbench. After a successful installation, an icon will be added on the main window of MAX Workbench. www.maxtoolkit.com Certified MAX Integrator 4 Page
Quick Data Loader www.maxtoolkit.com Certified MAX Integrator 5 Page
Quick Data Loader Settings Configuration Click the Quick Data Loader icon on the main window of MAX Workbench to launch the application. The Quick Data Loader login window displays. Database connection settings are determined after a company selection has been made on this screen. Select a company from the Companies dropdown and click OK to proceed to the main window of Quick Data Loader. www.maxtoolkit.com Certified MAX Integrator 6 Page
Quick Data Loader Main Window Configure defaults Generate a template Settings Help Excel file location Validate before import Button to read selected Excel file Available worksheets Loaded file contents Import the available data There are four tabs contained on the main window – BOM, Orders, Static Data, and Transactions. Each tab contains its own set of tables that can be updated but the feel and look of the tabs is like each other Below is a list of supported tables for each one of the tabs. www.maxtoolkit.com Certified MAX Integrator 7 Page
Quick Data Loader - Bill of Material Loads single or multilevel BOM Adds new BOM or update existing BOM Replaces an existing BOM Adds a BOM as an alternate BOM Assigns component effectivity date directly from an input file or assign a user defined effectivity date that applies to all components in the BOM Adds new records to Part Master and/or Mfg Part Master at the same time as importing the BOM Specifies the row number in the input file to designate where the data to be imported starts Validates the data before it is imported and provide detailed error checking during validation and import to let the user know what the problem is Automatically exports encountered errors to a .csv file that is ready to be sent to support for evaluation Specifies default values for fields that are not in the input file Updates fields in product structure table www.maxtoolkit.com Certified MAX Integrator 8 Page
Quick Data Loader - Supported tables on the Static Data tab Account Types Address Master BOM Notes Buyers Code Master Class Codes Commodity Codes Customer Master Customer Master Ext Customer Part Data Customer Types Document Link Mst Employee Master Employee Master Ext General Ledger Acct Invoice Detail Invoice Master Job Progress Labor Rates Lot Tracking Header Lot Tracking History Mfg Part Master Mfg Part String Misc Items Part Master Part Master Ext Part Routing Part Routing Ext Part Sales Part Sales Ext Part Stock Part Vendor Planner PO Receipts Price Breaks Product Data Product Structure www.maxtoolkit.com Certified MAX Integrator 9 Page
Quick Data Loader - Purchase Order Code Purchase Order Note RMA Detail Sales Rep Master Stock Master Shipping Master Transaction History Vendor Master Vendor Master Ext Work Centers Work Centers Ext - Supported order imports on the Orders tab Non-Inventory Purchase Orders Purchase Orders Sales Orders Work Orders - Supported transactions on the Transactions tab Unplanned Receipt Unplanned Issue Stock Transfer Main Window Operation To select a file to load, double click on the XLS File to Load text field and select a file. Click OK on the Open File Dialog window All available worksheets contained in the selected file will be loaded in the Work Sheets dropdown. www.maxtoolkit.com Certified MAX Integrator 10 P a g e
Quick Data Loader After selecting the worksheet that will be imported, select a table to import to from the MAX Table dropdown, click Read XLS and the contents of the selected worksheet will be loaded. Column headers in the selected worksheet are required and must match the field names from the database. However, the column headers can be ordered in any sequence. Column headers could be in any If needed, click Validate to validate the data before it is imported. The result of the validation will be recorded in the Status column. In case a record passed the validation, the Status column will be updated with green background and in case of not passing the validation, the Status column will be updated with a red background. Move your mouse over the cell in question in the Status column and a tooltip containing the error message will be displayed. All error messages are also recorded in .csv files located in the Output Files folder which is in the installation folder of the Quick Data Loader. www.maxtoolkit.com Certified MAX Integrator 11 P a g e
Quick Data Loader Click Load to MAX to load the data. www.maxtoolkit.com Certified MAX Integrator 12 P a g e
Quick Data Loader Defaults Specification Quick Data Loader provides the user with the capability to specify default values. Default values are used only if the field is missing from the currently loaded worksheet. To specify a default value for a database field, click on the Default button. www.maxtoolkit.com Certified MAX Integrator 13 P a g e
Quick Data Loader To specify a default value, select a table from the Tables list. The Table Fields section will be populated with the available fields of the selected table. If the list of fields is too long and you cannot find the field you want to specify a default value for, type the name of the field in the Field Name textbox and click Find. After finding the field, click in the Default Value column for that field and type in the default value. No saving is needed. All values on this screen are saved as they are entered. www.maxtoolkit.com Certified MAX Integrator 14 P a g e
Quick Data Loader File Templates Quick Data Loader provides the user with the capability to create a template that can be used in the future to import data. The template is in the form of an Excel file and contains all fields from the selected table. To create a template, click on the Templates button. Select the tables that will be included in the template. Each table will be recorded as a separate spreadsheet in the generated file. A default file name will be generated in the File Name text field. It can be changed by simply entering a new one. The default location where the template will be saved is the installation folder of the Quick Data Loader. Click on the blue File Location button to select another location. Check the Open file after creation check box to open the generated template file. Click Create File to proceed and create the template. www.maxtoolkit.com Certified MAX Integrator 15 P a g e
Quick Data Loader www.maxtoolkit.com Certified MAX Integrator 16 P a g e
Quick Data Loader Settings Click on the Settings button to open the Settings dialog. The Settings dialog allows the user to change the default behavior of Quick Data Loader and makes it more flexible. www.maxtoolkit.com Certified MAX Integrator 17 P a g e
Technologies, Inc. Balance Point Technologies, Inc. assumes no responsibility or liability for any errors or inaccuracies that may appear in this manual. Neither Balance Point Technologies, Inc. nor anyone else who has been involved in the creation, production or delivery of this documentation shall be liable for any indirect, incidental, special,
compared the Biodex balance system with the conventional balance approach for improving balance and motor control in children with SDCP. Therefore, this study was designed to examine the effect of using the Biodex balance system for improving the balance scores and gross mot
NCERT Solution for Class 11 Accountancy Chapter 6 - Trial Balance and Rectification of Errors transferred to balance sheet. Any debit balance will be reflected in assets side whereas a credit balance is shown as liabilities in balance sheet. 7. What kinds of errors would cause difference in the trial balance? Also list examples that would not be
RingCentral Inc 27% 4.4 Pinterest Inc 24% 4.1 Zillow Group Inc 23% 6.5 NVIDIA Corp 23% 9.4 Teladoc Health Inc 22% 8.3 Uber Technologies Inc 21% 5.1 ServiceNow Inc 21% 15.9 Meta Platforms Inc 19% 4.1 Intuitive Surgical Inc 17% 14.2 Illumina Inc 17% 8.6 Alphabet Inc 16% 6.6 Microsoft Corp 16% 11.9 Amazon.com Inc 15% 7.0 Charles Schwab Corp/The 14 .
Print Only Closing Balance in Balance Confirmation Letter Introduction This Module Helps to Print Only Closing Balance in Balance Confirmation Letter. No Need to Print entire Ledger. Prevents wastage of Papers. Important! As a best practice it is advisable to back up your company data Installation 1. Copy the TCP file in Tally.ERP9 Folder. 2.
Account Trial Balance Report Objective This document provides the procedure for completing the Account Trial Balance Report program in its full form to check if a fund is in balance. If the fund is not in balance, the report identifies where and what entries have caused it to go out of balance. This report is an important tool when reconciling .
Trial Balance and Rectification of Errors 181 Trial Balance of .as on March 31, 2014 Account Title L.F. Debit Credit Balance Balance Total Fig. 6.1: Showing format of a trial balance It is normally prepared at the end of an accounting year. However, an organisation may prepare a trial balance
that balance exercises have a positive effect on speed, agility and balance performance. Keywords. Physical Education Lesson, Balance, Speed, Agility . 1. Introduction. Balance is the base of all movements. There is a constant loss and recovery of balance during movement determines[1]. Although
Abrasive Water Jet Processes . Water Jet Machining (invented 1970) A waterjet consists of a pressurized jet of water exiting a small orifice at extreme velocity. Used to cut soft materials such as foam, rubber, cloth, paper, food products, etc . Typically, the inlet water is supplied at ultra-high pressure -- between 20,000 psi and 60,000 psi. The jewel is the orifice in which .
