infobright ICE User Guide

前言资料简介本产品是一款低压高性能工程型变频器（690V），采用高性能的矢量控制技术，低速高转矩输出，具有良好的动态特性和超强的过载能力，支持永磁同步电机和交流异步电机控制，支持用户编程功能及后台监控，支持多种类型的编码器和通信总线，组合功能丰富，性能稳定。

MD580系列低压高性能工程性变频器（690V）是针对重工EU行业和传统OEM行业市场单点传动应用场合退出的全新一代单机传动产品，广泛应用于石油化工、冶金造纸、印刷包装、木工机床、食品饮料、物流仓储、纺织印染、风机水泵等行业。

本手册介绍产品的维护与维修说明、日常保养与维护、部件更换等。

更多资料版本变更记录关于手册获取本手册不随产品发货，如需获取电子版PDF文件，可以通过以下方式获取：●登录汇川技术官方网站（ ），“服务与支持‑资料下载”，搜索关键字并下载。

●使用手机扫产品机身二维码，获取产品配套手册。

保修声明正常使用情况下，产品发生故障或损坏，汇川技术提供保修期内的保修服务（产品保修期请详见订货单）。

超过保修期，将收取维修费用。

前言前言保修期内，以下情况造成的产品损坏，将收取维修费用。

●不按手册中的规定操作本产品，造成的产品损坏。

●火灾、水灾、电压异常，造成的产品损坏。

●将本产品用于非正常功能，造成的产品损坏。

●超出产品规定的使用范围，造成的产品损坏。

●不可抗力（自然灾害、地震、雷击）因素引起的产品二次损坏。

●超过一般工艺规范外力损伤产品，长期在腐蚀性气体下造成产品零部件腐蚀等（如硫化气体、酸性气体、导电类粉尘等；湿度较高，长期不适用，使用前需做除湿动作。

）有关服务费用按照厂家统一标准计算，如有契约，以契约优先的原则处理。

目录目录前言 (1)安全注意事项 (4)1维护与维修的安全说明 (9)2维护周期 (11)3日常保养与维护 (12)3.1日常保养项目 (12)3.1.1日常检查项目 (12)3.1.2日常清洁项目 (12)3.2定期检查项目 (13)3.3常见维护操作 (13)3.3.1主回路绝缘测试 (13)3.3.2设备通风与清洁粉尘 (14)4部件更换 (16)4.1可维护的部件清单 (16)4.2维修工具 (16)4.3更换风扇 (16)4.4更换通信扩展卡 (17)4.5更换EMC板 (18)4.6更换功率板 (24)4.7更换驱动板 (30)5存储与保修 (35)6废弃与回收 (36)安全注意事项安全注意事项安全声明●本章对正确使用本产品所需关注的安全注意事项进行说明。

Operation Manual and Parts DirectoryGlastender, Inc. · 5400 North Michigan Road · Saginaw, MI · 48604-9780800.748.0423 · 989.752.4275 · Fax 800.838.0888 / 989.752.4444 · © 2010 Glastender, Inc.Rev. 04-26-11MF24-SMF48-B2MF24, MF36, MF48M ug F rosters and P late C hillersGlastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • iiP riCes:All prices are LIST. Applicable taxes will be added.Q uotations:Unless otherwise stated, quotations are effective for 30 days only.a CCePtanCe:All orders are subject to acceptance by Glastender, Inc.’s headquarters in Saginaw, Michigan. Possession of the Product Directory and Price List is not an offer to sell.s hiPMents:F.O.B. factory in Saginaw, Michigan. Freight terms are Third Party or Collect if shipped directly to you. Prepay and Add to Invoice freight terms are available upon request. The approximate shipping weights of all products are listed with the prices. Partial shipments will be made unless otherwise specified by the customer. Surface freight classifica-tions are:Glasswashers, Line Chillers - Class 92.5Cocktail Stations, Underbar Equipment - Class 85Bar Die/Underbar Equipment – Class 125Refrigeration Equipment, 48” long or smaller - Class 100Refrigeration Equipment, greater than 48” long - Class 110All small items are evaluated to see the most cost effective means for shipment. Many small items ship via UPS or FedEx; however, when dimensional weight is excessive DB Schenker, UPS Supply Chain, or even common LTL carriers are the most cost effective choice. Spare parts orders received before 1:00 PM EST can usually be shipped the same day.The order department is happy to assist with routing or shipping ques-tions.P ayMent t erMs:Cash should be included with all orders unless credit terms have been arranged. To establish credit, banking and trade references are required.A convenient credit application is available upon request. Payment via credit card is not our normal means of receiving payment. Visa and MasterCard will be accepted, but must be charged at the time of ship-ment. In addition, a payment via credit card for orders totaling more than $500 will incur a 3% convenience fee on the total transaction amount.d elivery:The majority of equipment is manufactured to order and typically ships within three to six weeks after complete order information is received by the factory. In-stock equipment typically ships within two to three days of the factory receiving complete order information.r eturns:Items specified as “Manufactured to Order” are NOT returnable.A Return Material Authorization (RMA) number must be issued by the factory in advance for any items that are returnable. The RMA number MUST be noted on the outside of the returned package. Returns must be received within 90 days of the RMA issue date. Shipping charges must be prepaid. A minimum 20% restocking charge will be applied to all authorized returns if received in new, unused condition in the original packaging.The above conditions apply to spare part returns, except spare part returns must be received within 30 days of original shipment for elec-tronic or electrical parts or within 90 days for all other parts.l oss or d aMage:For customer routed shipments, Glastender, Inc. is not responsible for any loss, damage, or delay of merchandise during shipment. Such transit claims must be filed with the carrier. Merchandise must be examined on arrival. If shortages occur, Glastender, Inc. must be notified in writing within five (5) days of delivery to honor any shortage claim. Glastender will assume responsibility for freight claims on Prepay and Add ship-ments but the customer must inspect freight and note any damage upon receipt. Failure to do so may result in losses at the customer’s expense.C ustoM o rders:Custom orders must be paid in advance and are not subject to cancel-lation.l aMinates:Some products include common, readily available plastic laminates of the customer’s selection. There may be an additional charge if uncom-mon varieties are ordered.05/18/10Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 1Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 2APPLICABLE TO ALL PRODUCTS SOLD WITHIN THE UNITED STATES AND CANADAGlastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 3i ntroduCtionThis manual describes the operational features of Mug Froster/Plate Chiller models MF24, MF36, and MF48. Please review this information before attempting installation and operation.Long term, trouble-free service will follow if good housekeeping and maintenance procedures are followed. Thank you for selecting Glastender, Inc. products.u tility r eQuireMents and C onneCtions• Electrical: 115 V olt AC, 1 Phase, 60 Hz, 6.7 Full Load Amps. A separate 15 Amp circuit is recommended. A 6-footgrounded cord is included.• Plumbing: None required. Automatic condensate evaporator is included.u nCrating and s tart -u P i nstruCtionsAll Mug Frosters and Plate Chiller models are shipped in one carton. These steps should be followed:1. If legs or casters are included, bolt them to the base with the bolts provided.2. Unwrap power cord from base.3. Position Mug Froster/Plate Chiller and level and/or seal as required (see page 2).4. Install shelves.5. Plug into 115 volt AC outlet.6. Load with mugs, glasses, plates, etc.7.Your Glastender Mug Froster/Plate Chiller is now ready for use.s ealing M ug F roster and P late C hiller B ase to F loorTo comply with NSF & health codes. The Mug Froster base must be sealed to the floor using NSF listed sealant.Place a bead of sealant along outer edges of the base and remove excess with disposable towel.Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 4o PerationThe Mug Froster/Plate Chiller is designed to chill mugs, glasses, plates, etc. that will appear “frosted” when removed. The operating temperature range of 0°F (-18°C) to 35°F (2°C).The Mug Froster/Plate Chiller should be filled with dry, room-temperature mugs, glasses, plates, etc. to allow maximum chilling. During business hours, the Mug Froster/Plate Chiller can be loaded with additional dry, room-temperature mugs, glasses, plates, etc. Allow 30 minutes for chilling.The Mug Froster/Plate Chiller includes an automatic defrost system. Defrosting will occur every six hours for approxi-mately 20 minutes. During the defrost cycle, the fan inside the Mug Froster/Plate Chiller will turn off and a small amount of mist may appear if the top is opened.There is also a manual defrost system controlled by a switch located on the front left bottom of the Mug Froster/Plate Chiller. This is used when there is ice or snow accumulation inside. An end-of-the-day or weekly schedule can be estab-lished for the activation of this manual defrost cycle.When the manual defrost switch is pushed, a light will turn on and the Mug Froster/Plate Chiller will go into a six-hour defrost. After six hours, the Mug Froster/Plate Chiller will resume normal operation.If the manual defrost switch is accidentally pushed, the defrost cycle can be terminated by unplugging the power cord for three seconds.C leaning i nstruCtionsCleaning is essential to sustaining the integrity of your equipment and preventing corrosion.ESTIMATED CLEANING TIME: 5 to 10 minutes per unit daily, 30 minutes quarterlyFREQUENCY: Daily cleaning of exterior & door gaskets. Quarterly cleaning of interior, including shelves.PROCEDURE:1. A non-chlorine based cleaner or mild detergent and warm water applied with a soft cloth or sponge to all contact sur-faces.2. Immediately rinse off cleaning agent(s), using clean warm water, clean soft cloth or sponge.3. Dry with a soft clean cloth, removing standing water as soon as possible.NOTES:1. Never use hydrochloric acid, wire brushes, steel wool, scrapers, or chlorine based cleaners on stainless steel surfaces,since they will break down the passivity layer and allow corrosion to occur.2. On stainless steel surfaces, you may use a soft bristle brush or Scotch-Brite ® pad for more stubborn stains. Alwaysscrub with the direction of the grain. Follow with a thorough cleaning as described above.3. Deposits from food preparation must be properly removed. Even hard water deposits will rust stainless steel, if notremoved.4. Repeated cleaning may dry up black-vinyl-clad steel (exterior) surfaces of the cooler. Armor All ® or similar productcan bring back the shine. Apply the product to a cloth and then rub into the surface, rather than spraying it directly onto the black-vinyl-clad surface.5. The cooler door gaskets are most often overlooked when cleaning. Failure to clean them regularly will lead to prema-ture failure, since alcohol and moisture build-up breaks down the gasket material.6. Mug frosters have a manual defrost timer switch on the front near the bottom, which will activate a 6-hour defrost cycle.Depressing the switch before you close for the evening will remove excess frost build-up on the interior liner. This pro-cedure should be done as often as is necessary. It should also be done the night before the quarterly interior cleaning.e leCtriCal and r eFrigeration s PeCiFiCationsd esignM odel r eFrigerant P ressure(L-to-R length) e leCtriCal t yPe C harge h igh l oW 24”, 36”, 48” 115V, 1Ph., 60 Hz., 6.7 Amp R404A 8.5oz. 350 175800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 5Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 6Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 7P art n o .o ld P art n o .d esCriPtionP riCe3. 07000127Overload protector for R404 Aspera compressor 15.00 4. 07000175 GT-035026 1/3 HP Tecumseh compressor, R404A (after 1/00) 375.000700023719. 07000235 GT-038203 Wicking material, consists to 11 4” pieces, MF24 14.0007000724Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 8Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 9P art n o .o ld P art n o .d esCriPtionP riCe12. 07000227 GT-037419 Control module, complete400.00Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 10P art n o .o ld P art n o .d esCriPtionP riCe07000159 9. 07000162 GT-033108 Shelf, 12” x 19-5/8” [MF36 = 3 (bottom, middle, top),40.0007000224 Complete shelf kit for MF36 (includes: 1- 07000159, MF24 = 1MF36 = 1MF48 = 2MF24 = 0MF36 = 0MF48 = 119-5/8″19-5/8″19-5/8″19-5/8″0700015907000158Glastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 11P artn o .o ldP art n o .d esCriPtionP riCeGlastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 1207000193 GT-036112 Back, stainless steel, MF24 80.00 07000194 GT-036113 Back, black vinyl-clad, MF36 50.00 07000195 GT-036114 Back, stainless steel, MF36 100.00 2. 07000196 GT-036115 Back, black vinyl-clad, MF48 55.00 07000197 GT-036116 Back, stainless steel, MF4896.00 3. 07000198 GT-036117 Side, left, black vinyl-clad, all models 40.00Model MF48Front viewRear viewFront viewGlastender, Inc. • 5400 North Michigan Road • Saginaw, MI • 48604-9780800.748.0423 • 989.752.4275 • Fax 800.838.0888 / 989.752.4444 • 13Installation Notes____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________Original System InstallerCompany: _____________________________________________Address: __________________________________________________________________________________________City, State, Zip: _____________________________________________Phone Number: _____________________________________________Fax Number: _____________________________________________Contact:_____________________________________________P artno .desCriPtionPriCeExpect moremore flexibilitymore featuresGlastender has the most complete line of bar equipment andthe ability to manufacture custom units, giving you virtuallyunlimited design flexibility. Each piece of equipment isengineered with features that enhance your efficiency, easeyour maintenance, and prolong the life of your investment.The flexibility you want. The features you need. GLASSWASHERS • COCKTAIL STAT。

ICE Quick Start GuideThis guide offers the quickest way to install and begin using the Infobright Community Edition (ICE) data warehouse. This guide assumes users have a basic knowledge of SQL and database technologies. However, for assistance on these subjects, some useful resources are suggested at the end of this document.This document includes some high-level information about using ICE, the Install Guide, and links to other useful resources, including:•Release Notes•Tips & Tricks•ICE Optimized Queries•Suggested ResourcesAbout ICEICE is a specialized Open Source load and read-only data warehouse, as opposed to a general-purpose database. ICE is designed to be easy to implement and maintain, eliminating most of the confguration, tuning and ongoing maintenance activities of other data warehouse products. ICE is optimized for use under the following conditions:•Up to 50TB of data•Data loading and storage, no DML support required•64-bit & 32-bit Linux environments and 32-bit WindowsFor more information on using ICE under the best conditions, and properly setting user expectations, please click on the following link to download the ICE Architecture white paper:/wiki/File:IB_Arch_ICE_white_paper_Final_4.pdf/Release NotesClick on the following link to get an overview of new features available with this release: /Resources/release_notes/Click on the following link to login or register to view the roadmap of upcoming features: /Forums/member/registerInstall GuideThe Install Guide describes how to invoke the automated Installer and describes the default parameter settings. One of the main features of ICE is its simplicity; it does not have many parameters that are necessary to be tuned.You can view the latest version of the Install Guide at:/wiki/Windows Installation Instructions1.Download the package infobright-3.3-win32.exe to the Windows XP machine on which you areinstalling Infobright, and double click on the infobright-3.3-win32.exe fle to launch the Install Wizard.Click Next to continue.2.Click I Agree to accept the GPL license agreement.3.By default ICE is installed in C:\Program Files\Infobright. To change the default location, either enterthe folder name in the feld or click Browse… to select desired install location on your computer. Click Install to accept the install location.4.Please wait while the Install Wizard completes the installation.5.Choose if you want Infobright to start on completion of the installation. Click Finish to complete theinstallation.6.The Install Wizard automatically creates ICE as a Windows Service, which allows the Infobright serverto be started and stopped automatically when you boot or shutdown Windows. If you do not want ICE to start on boot, open the Services window from the Control Panel and change the Startup Type for Infobright from “Automatic” to “Manual”.7.The Install Wizard automatically determines the optimum memory settings based on the physicalmemory of the system. You may change these settings by editing the fle brighthouse.ini within the data directory.Important:The memory settings assume that there are no other services on the machine consuming signifcant memory. If this is not the case, please lower the memory settings for Infobright.Windows Upgrade InstructionsTo upgrade ICE on Windows, please follow the Windows Installation Instructions. The Install Wizard automatically detects a previous version of ICE and upgrades your ICE installation while preserving your data and confguration settings.After installation, run the MySQL Upgrade utility from the Windows command line:cd "C:\Program Files\Infobright".\bin\mysql_upgrade.exe --defaults-file="c:\Program Files\my-ib.ini" -uroot--tmpdir=c:\tmpImportant:The MySQL Upgrade utility may display several errors regarding the use of locks with log tables and errors requiring table upgrades. The errors are all handled automatically byInfobright and/or the upgrade utility and can be ignored.Stop and start the Infobright server from the Start Menu items.Linux Installation InstructionsRPM and DPKG InstallTo install Infobright on Linux using the rpm or dpkg package:1.Download the installation package from/Download/ICE/2.Obtain root user access, and run:rpm -i infobright_version_name.rpm [--prefix=path]ordpkg -i infobright_version_name.debImportant:Do not install in the root or home directories due to possible MySQL permission checking issues during install, start up, and/or load.If you use the rpm --prefx option, you should manually create a softlink to the Infobrightinstall directory from /usr/local/infobright .3.To change the default install options, after installation run:/usr/local/infobright/postconfig.shYou can run this script at any time after installation to change the datadir, CacheFolder, socket, or port. The script must be run as root, and Infobright must not be running.I NFOBRIGHT I NSTALL O PTIONSParameter DescriptionDatadir Path to the directory where tables will be created and stored. Use a high-performance storage such as a RAID.Cachedir Path to the directory where temporary fles will be created and stored.Should be located on a fast drive, possibly not the same as the data. Allowat least 100 GB of free space (depending on database size).Port Listening port for the Infobright server instance.Socket Socket connection point for client connections. (The socket connectionpoint will be created during the Infobright installation.)4.The installation determines the optimum memory settings based on the physical memory of thesystem. You may change these settings by editing the fle brighthouse.ini within the datadirectory.Important:The memory settings assume that there are no other services on the machine consuming signifcant memory. If this is not the case, please lower the memory settings for Infobright.1.To start or stop ICE, run:/etc/init.d/mysqld-ib start/etc/init.d/mysqld-ib stop2.To connect to ICE, use the script mysql-ib:/usr/bin/mysql-ib [optional:db_name]Linux Upgrade InstructionsRPM or DPKG UpgradeTo upgrade using the rpm or deb package, simply run the installation command and the package will automatically identify that Infobright is already installed and switch to upgrade mode. Your confguration settings and data will not be changed during the upgrade.Important:If the previous installation was done using the tarball package, you must upgrade using the tarball package (see instructions below). Upgrading from a tar package to an RPM or DEBpackage will be supported in the upcoming 3.2 GA release..To upgrade Infobright on Linux using the rpm or deb package:1.Obtain root user access2.Run either:rpm -U infobright-version-platform.rpmdpkg -i infobright-version-platform.deb3.Start the Infobright server:/etc/init.d/mysqld-ib start4.Run mysql upgrade tool to upgrade data folder:cd /usr/local/inforbright./bin/mysql_upgrade --defaults-file=/etc/f --user=root –tmpdir=/tmp Important:The MySQL Upgrade utility may display several errors regarding the use of locks with log tables and errors requiring table upgrades. The errors are all handled automatically byInfobright and/or the upgrade utility and can be ignored.5.Re-start the Infobright server:/etc/init.d/mysqld-ib restartIB_3.3.0_r6457_6503 (64-bit or 32-bit):/usr/local/infobright/bin/mysqld --versionTAR UpgradeTo upgrade Infobright on Linux using the tarball package:1.Unpack the tarball into a temporary folder. Use the gunzip utility for unpacking:cd /path/to/temp/gunzip < /path/to/infobright-3.3-x86_64.tar.gz | tar xvf -2.Stop the Infobright server:/etc/init.d/mysqld-ib stop3.Run the install script with the "--upgrade” and “--confg” fags and pass in the confguration fles ofthe previously installed version:./install-infobright.sh --upgrade --config=/etc/my-ib,cnf4.Start the Infobright server and run the mysql_upgrade utility:/etc/init.d/mysqld-ib startcd /usr/local/infobright./bin/mysql_upgrade --defaults-file=/etc/f --user=root --tmpdir=/tmpImportant:The MySQL Upgrade utility may display several errors regarding the use of locks with log tables and errors requiring table upgrades. The errors are all handled automatically byInfobright and/or the upgrade utility and can be ignored.5.Re-start the Infobright server:/etc/init.d/mysqld-ib restart6.Confrm the build version as IB_3.3.0_r6457_6503:/usr/local/infobright/bin/mysqld –-versionCreating the Database from an existing schemaICE is a unique database system that automatically builds Knowledge Grid structures instead of requiring or using indices. Indices should be removed from your data model and data defnition fle (DDL). For more information on the ICE architecture and supported data types, see:/wiki/Creating_the_Database_from_an_Existing_Schema/ICE supports standard MySQL DDL, but if your schema was for Oracle or SQL Server, there are possibly syntax or data types which are not supported. For more information, see:/doc/refman/5.0/en/data-types.htmlICE does not implement any referential integrity checks nor does it support DEFAULT values. The Infobright optimizer will accept these clauses, however, these clauses on the table defnitions are ignored. Data loadingICE includes a dedicated high-performance loader, that differs from the standard MySQL Loader. The Infobright Loader is designed for speed, but supports less load syntax than the MySQL Loader, and only supports variable length text formatted load fles.Import your data into an Infobright table by using the following load syntax (all other MySQL Loader syntax is not supported):LOAD DATA INFILE '/full_path/file_name'INTO TABLE tbl_name[FIELDS[TERMINATED BY 'char'][ENCLOSED BY 'char'][ESCAPED BY 'char']];The data is committed when the load completes if AUTOCOMMIT is set to on. This is default setting, but you can make it explicit by setting:Set AUTOCOMMIT=1;If you want to check the data via select before committing, then set AUTOCOMMIT to off: Set AUTOCOMMIT=0;New data can be seen by the loading session even though its not committed. Complete the load using an explicit COMMIT:COMMIT;For more information on using the ICE Loader and details on the supported syntax, please click on the following link to download the Loading Data in ICE document:/wiki/Data_Loading/Tips & Tricks for Performance T uningWhile the standard parameter settings are documented in the Install Guide, performance can be tuned based on:♦Hardware resources (available RAM, number of cores, etc.)♦Operating system (Red Hat Enterprise Linux, Ubuntu, CentOS, etc.)Based on the user’s environment, the Tip & Tricks document discusses which parameters can be tweaked and provides guidelines for appropriate parameters values.Click on the following link to view the latest Tips & Tricks:/wiki/Tips_&_Tricks/ICE Optimized QueriesThis document is a more technical companion reference to the Positioning Infobright document. It is written for a technical audience and covers in detail what types of database queries are optimized for ICE. ICE is a data storage engine with proprietary compression, storage, and retrieval methods. It leverages many features of MySQL including a support for variety widely-used APIs (e.g. SQL, ODBC, JDBC). Best performance can be achieved when Infobright executes SQL statements by using its query optimizer. When a query cannot exploit Infobright’s proprietary retrieval methods, the query will invoke the MySQL database optimizer. In these cases, users should expect the query to perform as it would using the MySQL database engine itself.For more information see Optimizing Queries at:/wiki/Optimizing_Queries/Suggested ResourcesThe following resources at , related web sites, and publications are suggested for learning more about data warehousing, SQL query language, and related topics:♦TDWI (The Data Warehousing Institute) ♦B-Eye Business Intelligence Network ♦MySQL in Data Warehousing and Business Intelligence /why-mysql/application-scenarios/data-warehouse.html。

INSTALLATION & MAINTENANCE MANUAL EcO3IceANTIMICROBIAL PROTECTION FOR COMMERCIAL ICE MACHINES MODEL:X1X4X8X16Model X4 ShownIMPORTANT SAFETY INFORMATIONEXPLANATION OF SAFETY AND NOTICE SYMBOLSDANGER indicates a hazardous situation which, ifnot avoided, WILLresult in death or serious injury.WARNING indicates a hazardous situation which, ifnot avoided, COULDresult in death or serious injury.CAUTION indicates a hazardous situation which, ifnot avoided, COULDresult in minor or moderate injury.NOTICE is used to address practices not related tophysical injury.READ AND SAVE THESE INSTRUCTIONSEnergized electrical circuits presenta life-threatening hazard of electricshock, explosion, or arc flash.-NEVER hose down or clean with water jet.-ALWAYS disconnect device from powerIMMEDIATELY if bare wires or otherelectrical conductors are exposed.-ALWAYS ensure all electrical circuits aredisconnected and discharged, with anappropriately rated voltage detecting device,before performing service, maintenance, orinstallation work.-ALWAYS follow all national and localstandards, laws, and codes, as well as allapplicable safe electrical work practices.Failure to follow these safety instructionsWILL result in death or serious injury.Unauthorized modifications, repairs,or use poses a hazard in the form ofan improperly functioning device.-ONLY for commercial use.-NEVER make ANY modifications thatare not authorized in writing by Franke.-NEVER remove any labels from the device.-ALWAYS replace ANY labels that havebeen removed or damaged IMMEDIATELY.-ONLY use original equipment manufacturer(OEM) parts when performing service,maintenance, or installation work.-NEVER operate with factory installedparts or components removed.-NEVER use for other than intended use.Failure to follow these safety instructionsCOULD result in death or serious injury, aswell as property damage or void of warranty.These instructions are intended forqualified persons ONLY. Use by otherscreates an unsafe condition.-ONLY persons who are certified techniciansor trades persons with the requisiteknowledge, skills, ability, and training,MUST perform service or installation work.-ALWAYS keep out of the reach of children.-ONLY allow access to device by trainedpersonnel who have read this manual.Failure to follow these safety instructionsCOULD result in death or serious injury, aswell as property damage or void of warranty./162This device generates ozone (O3) in the form of gas, which poses a hazard in excess quantities. O3 gas is toxic and corrosive. It accelerates burning, is heavier than air and oxygen, has an acrid odor, and is unstable.-ONLY operate in well ventilated areas. -ALWAYS disconnect device from power IMMEDIATELY if an unusually strong acrid odor is detected.-ALWAYS seek fresh air IMMEDIATELY if respiratory irritation is experienced. Seek medical attention if necessary. Disconnect device from power IMMEDIATELY.-ALWAYS ensure all electrical circuits are disconnected before performing service, maintenance, or installation work, to avoid accidental generation of ozone gas.-ALWAYS follow all national and local standards, laws, and codes, as well as all applicable, safe O3 work practices.-ALWAYS ensure all factory installed parts and components are re-installed properly and are in good condition after performing service, maintenance, or installation work. Failure to follow these safety instructions COULD result in death or serious injury.NEVER use inappropriate tools, processes, or procedures. Damage to components of device can occur.-Follow these instructions EXACTLY to avoid property damage or void of warranty.NEVER discard any loose parts received with device. They may be required for proper and safe installation and operation.EcO3Ice SPECIFIC SAFETY INFORMATIONInstallation of the device on unapproved ice machines could result in damage to the machine, creating a hazard of small parts entering the ice during or after formation. -NEVER install device on, or in line with, unapproved ice machines or equipment. -ALWAYS ensure model compatibility of device and ice machine before installing. -ALWAYS contact Franke to verify approved usage and model compatibility, if unsure (refer to Contact Information, Page 16). Failure to follow these safety instructions COULD result in death or serious injury, as well as property damage or void of warranty.Improper installation presents a risk of respiratory and/or digestive irritation from ozone (O3) gas.-NEVER install device on an ice machine without a dedicated water supply line. -ALWAYS ensure device does NOT feed drinking water dispensers. Some are built into, or are attached to, some ice machines. -ALWAYS ensure the flow rate of the model of the device is appropriate for the ice machine to which it is being installed. Failure to follow these safety instructions COULD result in mild or moderate injury, as well as property damage or void of warranty.IMPORTANT SAFETY INFORMATION/163EcO3Ice SPECIFIC SAFETY INFORMATIONDissolved ozone (O3) is generated by the device from water. Under normal conditions, insufficient quantities of ozone gas are generated to create a hazardous condition.-O3 gas can be detected by humans (by smell) at a level as low as 0.003 parts-per-million (ppm), the odor threshold. -It is normal and expected to be able to detect a very mild acrid odor emanating from the areas around the connected ice machine’s distribution tubes, reservoir, evaporator plates, and ice bin.-Occupational Safety and Health Administration (OSHA) exposure limits for O3 are as follows: * Long term = 0.10 ppm for 8 hours* Mid term = 0.20 ppm for 2 hours* Short term = 0.30 ppm for 15 minutes The device is designed to generate O3 gas below the listed limits when installed, used, and maintained properly.O3 could diminish the effectiveness of some chemical products used during cleaning, sanitizing, or descaling cycles. -ALWAYS unplug device before performing maintenance work.Iron and manganese in the water supply may cause harmless discoloration of internal plastic parts in ice machines under certain conditions when ozone (O3) is introduced.-If this condition arises, additional water filtration may be required.NEVER expose device to extreme heat or open flame.NEVER immerse device in water.Clean exterior of device with soft cloth. Do not use harsh or abrasive cleaners./164CONTENTS Important Safety Information ............................................... 2 EcO3Ice Specific Safety Information ..................................... 3Key Components ..................................................................... 6 Head - All Models ............................................................... 6X1/ X4 ............................................................................... 6X16 .................................................................................... 7X8 ...................................................................................... 7 Specifications .......................................................................... 8 Certifications ........................................................................... 9 Installation ............................................................................... 9 Before Installing ................................................................. 9Installing the Device ........................................................... 10 Maintenance ............................................................................ 12 Expected Cartridge Life ..................................................... 12Replacing the Cartridge ..................................................... 12 Troubleshooting ...................................................................... 14 Disposal ................................................................................... 15 Warranty Information ............................................................. 15 Contact Information ............................................................... 165/16/166213Head - All ModelsITEM #PART NAME 1Green LED - Power 2Yellow LED - Replace Soon 3Red LED - Replace Now 4Serial Number Label 5Model Number (Prefix)Table 1Fig. 1X1/ X4ITEM #PART NAME 13/8" Water Line Inlet *23/8" Water Line Outlet *3Replaceable CartridgeTable 2* Some models include optional fittingsFig. 2/16734121KEY COMPONENTSX16ITEM #PART NAME 11/2” Water Line Inlet *21/2” Water Line Outlet *3Replaceable Cartridge 41/2" Water BypassTable 3* Some models include optional fittingsFig. 3X8ITEM #PART NAME 11/2" Water Line Inlet *21/2" Water Line Outlet *3Replaceable CartridgeTable 4* Some models include optional fittingsFig. 4SPECIFICATIONSSpecification Model X1Model X4Model X8Model X16Application Most flakerice machinesMost cubeice machinesMost highvolume cubeice machinesMost highflow cubeice machinesWater Flow 0.03 gpm to0.34 gpm0.34 gpm to1.30 gpm0.34 gpm to1.30 gpm1.30 gpm to4.20 gpm0.10 Lpm to1.30 Lpm1.30 Lpm to4.90 Lpm1.30 Lpm to4.90 Lpm4.90 Lpm to16.00 LpmWater SupplyClean, potable water ONLY Recommended hardness ≤300 ppm CaCO3Minimum 20 psi / Maximum 125 psi Minimum 1.37 bar / Maximum 8.62 barMinimum 40°F / Maximum 86°FMinimum 4°C / Maximum 30°CElectrical100-240 Volts, 50/60 Hertz, 1 Phase24 Volts, 1.25 Amps integrated transformer & power cord included1.25 Amps 1.67 Amps(Maximum by Phase)30 Watts30 Watts30 Watts40 Watts(Maximum by Phase)Ambient Air Minimum 40°F / Maximum 100°FMinimum 4°C / Maximum 38°CTable 5/168/169enCERTIFICATIONSSanitation (to NSF 2 & 61 & 372), CE, TUV, ETL, RoHS, WEEE WRAS approved for cold water use only in UK. (4°C - 23°C)US EPA EST. NO. 089373-MA-001Table 6INSTALLATIONBefore Installingice machines could result in damage to the machine, creating a hazard of small parts entering the ice during or after formation. -NEVER install device on, or in line with, unapproved ice machines or equipment. -ALWAYS ensure model compatibility of -ALWAYS contact Franke to verify approved usage and model compatibility, if unsure (refer to Contact Information , Page 16).Failure to follow these safety instructions COULD result in death or serious injury, as well as property damage or void of warranty.Observe these guidelines to ensure the device functions and performs optimally.1. Select a location for device so:-It will be in an upright position. -It will be within 3 ft (1 m) of the ice machine water inlet. -LED lights and cartridge are visible and accessible. -Equipment or objects will not press against the device.2. ONLY use one (1) EcO 3Ice device per ice machine.3. DO NOT connect to water lines which feed more than one ice machine.4. DO NOT connect to water lines which feed beverage or water dispensers.5. DO NOT connect to water lines which feed condenser cooling systems of water-cooled ice machines./161016. Ensure adequate back-flowprotection is provided (by others) to comply with all national and local standards, laws, and codes.7. Ensure EcO 3Ice will be the last water treatment device installed on the water line before the ice machine water inlet.8. It is highly recommended that a water shut-off valve be installed before and near the device.9. For best results, clean ice machine, ice bins, and ice dispensers thoroughly before installing.Installing the DeviceThe step numbers below correspond to the image step numbers on the next page.1. Mount device on wall, or other suitable surface, within 3 ft (1 m) of ice machine water inlet. Use appropriate hardware (not provided).2. Insert appropriate size of beverage-grade tubing into the fittings on the ‘IN’ and ‘OUT’ sides of device. Do NOT use more than 3 ft (1 m) of tubing on the 'OUT' side. Some models include optional fittings.3. Attach the ‘IMPORTANT’ label inside ice machine, near the power switch, so it can be seen when cleaning, sanitizing, or descaling is initiated.4. Install cartridge (refer to Replacing the Cartridge , Pages 12 −13).5. Ensure all plumbing connections are secure and leak-free, from shut-off valve to ice machine water inlet.INSTALLATIONBefore Installing (continued)3 ft (1 m) maximum distance and length of tubing/161152INSTALLATIONIMPORTANT!device before ice machine cleaning, sanitizing, or descaling. Plug in the device when the cycle is complete./1612MAINTENANCEExpected Cartridge LifeThe EcO 3Ice replaceable cartridge is designed to typically last:- 2 years 100 to 300 lb - 1 year301 to 1000lb- 9 months 1001 to 1500lb - 6 months 1501 lb and larger Hard water, or other factors, may shorten cartridge life. Two (2) ‘Replace Cartridge’ LED indicators are present on the head of the device to warn when the cartridge is nearing the end of its effective life cycle.Yellow LEDProtection DIMINISHED Replace SOON Red LED Protection EXPIRED Replace NOWReplace cartridge at the expected life cycle intervals shown, or when the Yellow or Red LED indicators warn to do so, whichever comes first.Replacing the CartridgeThe step numbers below correspond to image step numbers below and on the next page.1. IMPORTANT! Unplug the device, and close the water shut-off valve.2. Hold head of device steady, untwist the used cartridge, pull to remove, and dispose of appropriately.3. Record date of installation on the label provided on new cartridge.4. Remove and discard protective cap. Hold head of device steady, push cartridge into head, and twist. Line up notches on cartridge and head.5. Plug device into outlet, open the water shut-off valve, and ensure the green LED on the head of the device is illuminated. If not, refer to Troubleshooting , Page 14./1613❆TROUBLESHOOTINGLED INDICATORS STATUS REMEDYGreen (solid)Power ONDevice operating properly Green (flashing)*Ozone being generatedYellow (flashing)Protection diminished Replace cartridge soon Red (solid)Protection expired Replace cartridge nowYellow (solid)andRed (flashing)No ozone being generated Replace cartridge nowYellow (flashing)andRed (solid)No ozone being generated Replace cartridge nowCartridge installation issue If recently replaced,remove and reinstallYellow (flashing)andRed (flashing)No ozone being generated Replace cartridge nowCartridge installation issue If recently replaced,remove and reinstallLeak in water supply line Repair leak, unplug device,and plug in device againIf these steps do not resolve the issue, contact Franke for support.(Refer to Contact Information, Page 16)Please have the model number of the device available when calling.(Refer to Key Components, Head - All Models, Page 6)*NOTE: Green flashing LED indicator is included only on devices manufactured after April 1, 2017. Previous versions do not include this feature./1614/1615DISPOSALSpecial regulations apply when disposing of electrical appliances.The customer is responsible for proper disposal of the delivered product after the end of its service life at the customer’s own expense, in accordance with all legal regulations for the given region, state, or country.This does not apply to the replacement cartridges for the device.WARRANTY INFORMATIONFranke Foodservice Solutions (“Franke ”) warrants new equipment manufactured in Franke designated facilities to be free of defects due to poor materials or workmanship for the period of time listed below (following the date of purchase):-EcO 3Ice head - One (1) year parts only. -EcO 3Ice cartridge - Thirty (30) days parts only.Exclusions: Certain Franke parts that are expendable by nature and that need to be replaced frequently may not be covered. Franke is not liable under these warranties for repairs or damages due to improper operation, attempted repairs or installation by unauthorized persons, alterations, abuse, fire, flood, or acts of nature. Additionally, this warranty may be voided in the case of:-Failure to follow Franke instructions for use, care, or maintenance. -Removal, alteration, or defacing of Franke -affixed serial number and other labels. -Mechanical damage.-Use of fluids other than clean, potable water. -Use with unapproved ice machines or equipment.This warranty is conditional upon Franke receiving notice of any defect subject to this warranty within thirty (30) days of its original discovery by the Buyer.CONTACT INFORMATIONAsiaFranke Foodservice Systems Asia Co., Ltd.Phone +852 3184 1955EuropeFranke Foodservice Systems EMEAPhone +49 7761 5533 5780The AmericasFranke Foodservice Solutions Inc.Phone +1 615 462 4000Document Part # 19009595, Rev. B, July 24, 2017© 2017 Franke Foodservice Solutions, Inc. This media is the confidential and proprietaryproperty of Franke Foodservice Solutions, Inc. and shall not be reproduced in any formof media without the express written permission of Franke. Trademarks used are theproperty of their respective owners. Due to continuous product development, Frankereserves the right to make changes in design and specifications without prior notice.Printed in the USA under license by Franke Technology and Trademark Ltd., Switzerland.。

VI C O M P LService Price PromiseReal-Time Service UpdateFORDReceive regular real time updates foryour car servicePick Up Ford Fast Ford Protect Ford commits to deliver the guest Just dial 1800-209-7400 or Opt for pick-up and1.5l TDCi Diesel Engine1.2l Ti-VCT Petrol Engine 96PS(70.79kW)100PS(73.80kW)The Ford Figo’s latest 1.2l Ti-VCT engine gives you the confidence to add more power to the journey called life.POWERThe Ford Figo’s energetic design complements your personality and the hint of blue adds life to your world. Making it a smart match for you!STYLER15 (195/55 R15) Alloy WheelsStand apart from the crowd as you zip through roads with these stylish R15 alloy wheels.Sporty Cellular GrilleThe sporty cellular grille gives a smart, bold look to the Ford Figo.Dual Tone RoofContrasting colours on the roof make the Ford Figo a sight to behold.The Ford Figo is designed to perfectly fit in your smart world. Its energetic design and powerful engine are always ready to fuel your fast-paced lifestyle. Its smart technology and safety features add fun and ease to every journey. Giving you the confidence to take on life and manoeuvre through twists and turns in a smart way! PLAY SMART. WHY FOLLOW.6 AirbagsRear -View CameraThe Ford Figo comes with front, side and curtain airbags to keep you and your loved ones protected.When you reverse, the rear-view camera automatically turns on, giving you a clear view of what’s behind.Touchscreen with NavigationRain-Sensing Wipers Automatic HeadlampsThe Ford Figo comes with a 17.78 cm (7.0) infotainment touchscreen that has in-built navigation. So, go ahead and find smart routes while listening to your favourite tunes.Nothing should distract as you drive. Whether it’s a drizzle or a hailstorm, these wipers automatically turn on.When it gets dark, these powerful headlamps automatically illuminate the road ahead, giving you a clear view.The Ford Figo comes with the latest innovations in technology that keep you informed and entertained.SMARTThe Ford Figo has leading safety and security features that give you and your loved ones total peace of mind.SAFETYFord Service Price PromiseThe Ford Figo now comes with 3 year factory warranty.3-Year Factory WarrantyFACTORY WARRANTY~All Prices in INR. Windshield wash fluid is optional.Model VariantEngine 1 year / 2 year / 3 year / 4 year / 5 year / 6 year / 7 year / 8 year / 9 year / 10 year / 10,000 kms 20,000 kms 30,000 kms 40,000 kms 50,000 kms 60,000 kms 70,000 kms 80,000 kms 90,000 kms 100,000 kms Ford Petrol 1.2L 1,811 4,751 4,230 4,751 4,230 6,420 4,230 4,751 4,230 4,751 FigoDiesel1.5L2,8416,1957,2346,1955,6728,4565,6726,1957,2346,195Periodic maintenance service prices~The price you see is the price you pay.When it comes to Ford service, believe in facts and not impressions. Here is the Ford Figo periodic maintenance table for you to see and judge for yourself.COLOURSFigo Titanium - Ruby RedWhite GoldDiamond WhiteSmoke GreyMoondust SilverMoondust Silver Smoke GreyFigo Titanium - Diamond WhitePresenting FordPass TMExperience connectivity with your Ford wherever you are.SMART VEHICLES FOR A SMART WORLDExperience the next-gen connectivity with your Ford vehicle and access features like remote start/stop,remote lock/unlock, vehicle locator, vehicle health alerts and more on your phone through the FordPass app.Get your Ford ready for the road aheadStay abreast of the regular updates about your FordNow get the odometer reading on your phoneStart/stop your car’s enginewith one tapNow lock/unlock your carwith a simple tapStay informed in advance about your Ford’s fuel needsGet timely alerts on the vehicle’s low tyre pressureKnow the right time to change the engine oilSo you never forget where you parked your FordOver The Air UpdatesVehicle AuthorizationFuel Level & Distance to EmptyRemote Start/StopRemote Lock/UnlockVehicle Health AlertsVehicle LocatorTyre PressureOil LifeOdometer1. Anti-Lock Braking System2. Electronic Brakeforce DistributionConditions and exclusions apply. Images and illustrations are for information purposes and are indicative only. Because of changes in conditions and circumstances, Ford India Private Limited (“Ford”) reserves the right, subject to all applicable laws, at any time, at its discretion, and without notice, to discontinue or change the features, designs, materials, colours and other specifications and the prices of its products, and to either permanently or temporarily withdraw any such products from the market without incurring any liability to any prospective purchaser or purchasers. Always consult an authorised Ford Dealer for the latest information with respect to features, specifications, prices, optional equipment and availability before deciding to place an order. Some driver assistance and safety features described above are designed to function using sensors, whose performance may be a ected under certain weather or environmental conditions. Features may vary from model to model. ˆˆThe speed alert system gives audible warning for alert of over speed to driver. When vehicle speed exceeds about 80 KMPH, primary level warning with one beep will sound every 2 minutes. When the vehicle speed exceeds about 120 KMPH, Secondary level warning with continuous beeps will sound. This buzzer does not indicate any malfunction in vehicle. Bluetooth is a registered trademark of ^Bluetooth SIG Inc., and is used under license. Do not change system settings or enter data non-verbally (using your hands) while driving. Fuel economy for diesel is 24.4 km/l & petrol is 18.5 km/l as per ARAI. ~Prices in INR, are indicative as on February 2020 and are subject to change without prior notice. It includes parts, labour, consumables & taxes. For models not mentioned above and for actual price based on your location contact Ford Authorised Dealer. Additional Parts/Services may require inspection/replacement based on vehicle age and driving conditions, refer owner’s manual or visit Ford Authorised Dealer for details. Kerb weight with 90% fuel. Stop the vehicle in a safe and legal manner before attempting these operations. Ford does not recommend using mobile phone while driving. Accessories shown may not be part of standard equipment. Colours are indicative only and may vary due to printing constraints. Specifications and features are subject to change without notice. Registered O ce: at SP Koil Post, Chengalpattu-603204, District Kancheepuram, Tamil Nadu, I ndia. Ford Figo Brochure, printed in June, 2020. Corporate Identification Number: U34103TN2000PTC045537.BUILT QUALITY , GREEN, SAFE AND SMARTCompare ModelLocate a DealerBook a Test Drive18.5 km/l**PETROL 24.4 km/l**DIESEL FORD SERVICESavings on Service:The Ford Figo comes with a 3-year factory warranty.• Scheduled Service Plan:• Total Maintenance Plan: Covers complete maintenance of your car for guaranteed peace-of-mind ownership• Roadside Assistance: 24x7 helpline with Pan India coverage to connect you to the nearest Ford Service Centre。

Accessories: To purchase Bosch accessories, cleaners & parts please visit /us/store or call 1-800-944-2904 (Mon to Fri 5 am to 6 pm PST, Sat 6 am to 3 pm PST).SHXM78Z54N Black Stainless Steel Also available in:Stainless Steel SHXM78Z55N White SHXM78Z52N BlackSHXM78Z56NPatented CrystalDry™ technology transforms moisture into heat to get dishes, including plastics, 60% drier.142 dBA: dishwasher runs quietly so your kitchen conversations aren’t interrupted.The Flexible 3rd Rack with fold down sides adds 30% more 2 loading area, perfect for utensils and ramekins.The AquaStop® leakprotection system contains leaks through a precisely engineered system. If a leak occurs, the system contains it by shutting down operation andpumping out water. So you have the ultimate peace of mind whether you are away or at home.1Based on aggregate average drying performance of Bosch Dishwashers with CrystalDry on combined household load including plastics, glass, steel, and porcelain as compared to Bosch Dishwashers with PureDry. Drying performance may vary by dish type.2Compared to a Bosch dishwasher with 2 racks.3Certification to NSF/ANSI Standard 184 for residential dishwashers. 4September 2020 running production change to remove adhesive routing clips for power cord. These clips and the edge protector are now included in the dishwasher accessory kit # SMZEPCC1UC.Accessories: To purchase Bosch accessories, cleaners & parts please visit /us/store or call 1-800-944-2904 (Mon to Fri 5 am to 6 pm PST, Sat 6 am to 3 pm PST).Installation DetailsJunction box accessoryInstallation DetailsAccessories: To purchase Bosch accessories, cleaners & parts please visit /us/store or call 1-800-944-2904 (Mon to Fri 5 am to 6 pm PST, Sat 6 am to 3 pm PST).。

AN120102Use of ISP091201-DK1IntroductionScopeThis document gives details on hardware and software for using and testing Insight SiP Bluetooth Low Energy module ISP091201. The next paragraphs describe hardware and software of three different kits, two from Nordic Semiconductor and one from Insight SiP. The last paragraph presents a simple link test set-up.Contents1. Recommended Documentation ...................................................................................................Page 12. nRFGo Starter Kit (nRF6700) ......................................................................................................Page 23. nRF8001 Development Kit (nRF8001-DK) ...................................................................................Page 34. ISP091201 Development Kit (ISP091201-DK1) ...........................................................................Page 45. Simple Link Test Set-Up ..............................................................................................................Page 61. Recommended DocumentationThe following documents are recommended reading:2. nRFGo Starter Kit (nRF6700)The nRGo Starter Kit consists of hardware and software components. For more details, see Nordic Semiconductor user guide (document R1- see §1).nRFGo Starter Hardware ComponentsSoftware and Documentation ComponentsAccess to software and documentation at . Then, download and install latest version of nRFGo Studio.3. nRF8001 Development Kit (nRF8001-DK)The nRF8001 Development Kit consists of hardware and software components. For more details, see Nordic Semiconductor user guide (document R2 – see §1).nRF8001-DK Hardware ComponentsSoftware and Documentation ComponentsThe SDK (Software Development Kit) can be downloaded from a Nordic MyPage account at . In order to access the download page, the requested Product Key is written on the nRF8001-DK package. Then, download and install latest version of nRF8001 SDK Installer. Installation will set up the software and will give access to Nordic Semiconductor user guide (document R2 – see §1).4. ISP091201 Development Kit (ISP091201-DK1)Hardware ComponentsThe Insight SiP ISP091201 Development Kit consists of the following hardware components.ISP091201 is the Bluetooth Low Energy module with integrated antenna. This module is based on Nordic Semiconductor nRF8001 uBlue Bluetooth Low Energy Platform. The nRF8001 is a single chip transceiver with an embedded baseband protocol engine. The ISP091201 module size measures 8 x 12 x 1.5 mm. The module integrates all the decoupling capacitors, the 16 MHz crystal and load capacitors plus the RF matching circuit and antenna in addition to the transceiver. For more details, see Insight SiP module data sheet (document R3 – see §1).ISP110701 is the application type test board. It encloses ISP091201 Bluetooth Low Energy module and has size of 18 x 35 mm. ISP110701 has the same function as Nordic Semiconductor nRF2740board.ISP110701 Test board5 sample unitsISP091201 BLE ModuleCD-Rom with Data Sheet and Application NoteISP110701 Electrical Schematic5. Simple Link Test Set-UpAll tests performed in Nordic Semiconductor user guide (document R2) with nRF2740 board can be carried out with ISP110701 instead. Two set-up examples are shown in the following paragraphs.ISP110701 Test Board Set-Up for Testing with Direct Test ModeBLE Master Emulator Set-UpISP110701Carrier boardnRF2735nRFGo Motherboard nRF6310Patch cable RS232 serial cableUSB cableUSB cablenRF2739 BLE Master Emulator。

User Guide for Fisqal™Localization for Luxembourg Fisqal™ is a localization solution for Microsoft Dynamics 365 Business Central in Luxembourg enabling organizations to manageeCDF and FAIA reporting.General Information (2)Introduction (2)Icons (3)Installation (3)a)Import Configuration (4)b)Manual Setup (5)Finalize the wizard (6)Functional documentation (7)Electronic platform to collect financial data (eCDF) (7)Annual Accounts (7)Value Added Tax (VAT) (7)Declaration Appendices (7)How to extract an eCDF declaration (8)Manual Setup (10)Audit File FAIA (11)Setup (11)Exporting FAIA Files (12)To create an export of FAIA files (12)FAIA files and Data Quality (12)Performance optimizations (13)Intrastat Reporting (14)Introduction (14)Setup (14)Generate Intrastat reports (14)Account Schedules (17)Generating account schedules (17)Future release (18)More Information (19)Legal (19)IntroductionFisqal® is a localization solution for Microsoft Dynamics 365 Business Central enabling organizations to manage eCDF and FAIA reporting for Luxembourg. By default. Fisqal®:•Is shipped with pre-defined eCDF model types for Luxembourg. Currently, most model types commonly used in commercial companies are available.•allows you to create your own model types, whether it be for VAT or others. The framework is modular and relies on setups.•enables to generate the audit file “FAIA” which is mandatory for many organizations in Luxembourg.The file is based on the international SAF-T file but contains specific adjustments for Luxembourg.Fisqal® only ships with the complete version of FAIA files.•Is shipped with standard setup packages for Luxembourg for new deployments (paying option). We can also help you customize your existing VAT setup to match other reporting requirements (paying option).•Includes Intrastat report layouts.This document describes the modules and features of Fisqal® and how to use them in your organization / deployment. If you require assistance, please contact our customer service team for personalized guidance.•Tools to setup & export FAIA•Tools to setup & export eCDF declarations•Standardized setup for FAIA1•Standardized setup for eCDF2Each related to the Fisqal® product line.For further information on the application, please refer to the landing page or contact us.1 Subject to compatibility with the Business Central deployment on which it is installed2 Subject to compatibility with the Business Central deployment on which it is installedIconsℹInformation – Indicates sections which include important information to be considered by the user.Reminder – Reminds the user of already mentioned information or processes which enable the user to achieve optimized results.Tip - Indicates sections which support the user to use the functionality correctly.⚠Warning - Signifies information of high importance to be considered to avoid errors.InstallationThese instructions describe how to onboard and setup Fisqal® and register it for a 30-day trial.1.In Business Central, choose the icon, enter Assisted Setup, and then choose Assisted Setup.2.Choose Setup eCDF3.The first page in the setup guide explains what you are about to set up. Choose Next.1.Select one of the “Actions” from the following options.a)Import ConfigurationIn most cases, you can install Fisqal® by using the wizard to import and/or:1)the standardized eCDF package which contains the typical model types including theirdefinition and generic eCDF VAT Product Posting Groups that you can map to your existing VAT Product Posting Groups.2)the Rapid Start Package for Luxembourg. This package contains basic setup data forBusiness Central that is generally useful for a Luxembourgish company. Use this package for a new company only, ideally before you import master data or make other configurations.b)Manual SetupBy selecting this option, you are free to create your own configuration and use Fisqal® in non-standard or existing deployments. You should/must use this option if:1)You don’t want to use the eCDF VAT Prod. Posting Groups provided by Fisqal®2)You are not able to map your VAT Prod. Posting Groups with the eCDF VAT Prod. Posting Groupsprovided by Fisqal®3)You don’t use the PCN2020 as chart of accountsFinalize the wizardAfter you have selected the preferred option and/or uploaded the Files, click Next to automatically upload the Data to your System. After The Import is finished the following Step should be shown where you can fill the mandatory fields with your Company Information.⚠This step could take a few minutes, please do not cancel.Electronic platform to collect financial data (eCDF)In Luxembourg, many organizations must present and file accounts under a specific format referred to as electronic Centrale des Données Financières also known as "eCDF". Fisqal® allows you to export this kind of statements from Microsoft Dynamics 365 Business Central.eCDF is composed of three types of statements:1)Annual Accounts2)Value Added Tax3)AppendicesThe following heading lists currently available statements of the application.Annual Accounts•Annual accounts – Balance Sheet•Annual accounts – Abridged Balance Sheet•Annual accounts - Balance Sheet (S.P.F. - art. 31 L. 19/12/2002)•Annual accounts – Profit and Loss Account•Annual accounts – Abridged Profit and Loss Account•Annual accounts – Profit and Loss Account (S.P.F. - art. 31 L. 19/12/2002)•Annual accounts – Chart of AccountsValue Added Tax (VAT)•Value Added Tax (VAT) – Annual Declaration•Value Added Tax (VAT) – Simplified Annual Declaration•Value Added Tax (VAT) – Monthly Declaration•Value Added Tax (VAT) – Quarterly Declaration•Value Added Tax (VAT) – Monthly recapitulative statement of intracommunity of goods•Value Added Tax (VAT) - Quarterly recapitulative statement of intracommunity of goods•Value Added Tax (VAT) - Monthly recapitulative statement of intracommunity of services•Value Added Tax (VAT) - Quarterly recapitulative statement of intracommunity of services Declaration Appendices•Declaration Appendices – Tables of acquisitions / amortizable expendituresHow to extract an eCDF declarationOpen the eCDF declarations and select the preview button for the Model you want to extract.The following page will open where you must fill up the “Starting Date” and the “Ending Date”.Select the function “Export PDF” to fill up the “eCDF” form.Manual SetupFor the above-described functionality to work, you must map your custom VAT Prod. Posting Groups with standardized, generic eCDF VAT Prod. Posting Groups or create your own codes.Moreover, the eCDF declarations must be correctly defined. By default, Fisqal® ships the below listed model types. If you require help to create custom layouts, please contact us. Each eCDF declaration must be assigned to the correct PDF template.Audit File FAIAIn principle, any company subject to VAT in Luxembourg must be able to report financial data and provide a set of standard tax audit files called “FAIA” to the Luxembourgish authorities upon request. Fisqal® enables you to setup, generate, and export FAIA from within Business Central. The exported FAIA files will automatically be compressed as a .zip archive ready to be uploaded by the user on the website of the Luxembourgish tax authorities.Therefore, Fisqal® provides the following capabilities:•Setup and mapping of chart of accounts to FAIA standard accounts•Mapping VAT setup to FAIA VAT codes•Control to which extent dimensions are exported in FAIA files•Export FAIA files, either directly or by using the Job Queue. Using Job Queue lets you schedule the export to occur during quiet hours, which is useful for potentially large datasets.SetupSet up FAIA through the Assisted Setup. If needed, you can run this wizard several times until you finish the setup.4.In Business Central, choose the icon, enter Assisted Setup, and then choose Assisted Setup.5.Choose Set up FAIA6.The first page in the setup guide explains what you are about to set up. Choose Next.7.In the Mapping Type field, choose the type of Chart of Accounts you want to have based on theLuxembourgish accounts, and then choose Next.To define the period for the first FAIA reporting, choose Accounting Period, confirm the data range, and then choose Next. Typically, this is done for a specific accounting period, but you can also definea date range without specifying an accounting period.1.To map your chart of accounts to the Luxembourgish accounts, choose Open setup to define G/Laccount mappings. Lines where the G/L Account No. is marked with green indicates that here are transactions on the account within the date range specified in the previous step, in which case itmust be mapped. Other G/L accounts can be skipped. When finished, close the FAIA MappingSetup Card, and then choose Next in the setup guide.2.To map the VAT Posting Setup to standard sales and purchase FAIA tax codes, choose Opensetup to define VAT Posting Setup Mapping. When finished close the FAIA VAT Posting Setupcard, and then choose Next in the setup guide.3.Some authorities recommend that you export dimensions for financial transactions. However, insome situations you may not want to export dimensions. This step lets you open the Dimensions list and choose which dimensions to export. Please note that dimension codes cannot exceed 9characters in FAIA. Choose the value in the Export to FAIA field, and then choose Close.4.To specify the employee who is the FAIA contact in your company, choose the employee inthe Employee No. field. This is useful when Luxembourgish authorities have questions about theFAIA files. When finished, choose Next.5.To specify currencies, please make sure you follow ISO 3166-1 alpha 2 naming conventions.6.The setup of FAIA is now finished. Choose Finish.Exporting FAIA FilesTo export FAIA files from Business Central, you must first create and set up a FAIA Export to define the mapping range. For example, you can define a mapping and export the entire year of 2021, and another mapping for just the month of April 2021 if the authorities ask you to provide this data specifically.To create an export of FAIA files1.In Business Central, choose the "Tell me what you want to do") icon, enter FAIA Exports, andthen choose FAIA Exports.2.On the FAIA Exports page, choose Create.3.On the FAIA Export page, in the Mapping Range Code field, choose the mapping range for whichto define an export.4.To start the FAIA export, do one of the following:5.To export immediately, choose Start.6.To schedule the export to be handled by the jobs in the Job Queue, choose Parallel Processing.Exporting G/L entries can take time. To speed up the process, consider specifying how many jobs to run in parallel.7.To check the status of the FAIA file generation, look at the Lines section in the lower part of thispage.8.When all files are generated, choose Download file to download a .zip file that contains the FAIAfiles. This file is ready to be provided to the Luxembourgish tax authorities.FAIA files and Data QualityFAIA files can only be validated when certain information exists on relevant records in Business Central. To help ensure data quality for FAIA you can enable more proactive controls on the Data Quality FastTab on the FAIA Setup page. Additionally, on the FAIA Export card page, use the Data check action to check the data quality before you export the file.Performance optimizationsThere are a couple of things you can do to improve performance:•Split by Date option.•Create Multiple Zip Files optionFor very large exports with many transactions, you can also use the option to create multiple .ZIP files. This is useful if individual files per month are very large, or the count of files per date is too big. Use this option when the single large ZIP file will not validate on the authorities' web site due to its size, for example. Using this feature will split up the export into multiple ZIP files, up to 10 in alignment with the requirements that are stated in the general FAIA documentation. The FAIA Export File page is always opened when using the Download File action. Here you can see how many files where generated and download them one byone.Intrastat ReportingIntroductionThe principle of the free circulation of Union goods among the Member States of the European Union led to the disappearance of all customs barriers and eliminated the need to make customs declarations. Companies must however declare their intra-Community movements of goods in a monthly Intrastat declaration. The Intrastat declaration is used to collect statistical data on international commerce.In Luxembourg, Intrastat declarations are filed with the National Institute of Statistics and Economic Studies of the Luxembourg (STATEC), that next sends the monthly statistics to the Statistical Office of the European Union (Eurostat).Source: https://logistics.public.lu/en/formalities-procedures/general-formalities/intrastat.htmlSetupIn order to setup Intrastat for Fisqal® please refer to the Business Central documentation for Intrastat available here: Set Up and Report Intrastat - Business Central | Microsoft Docs.Generate Intrastat reportsThe following reports are made available by Fisqal®:1)Arrivalsa.Simplified Declarationb.Detailed Declarationc.Extended Declaration2)Dispatchesa.Simplified Declarationb.Detailed Declarationc.Extended DeclarationArrivalsSimplified DeclarationMicrosoft Word - Intrastatform Arrival simplified.docx (public.lu)Detailed DeclarationMicrosoft Word - Intrastatform Arrival detailed.docx (public.lu)Extended DeclarationMicrosoft Word - Intrastatform Arrival extended.docx (public.lu)DispatchesSimplified DeclarationMicrosoft Word - Intrastatform Dispatch simplified.docx (public.lu)Detailed DeclarationMicrosoft Word - Intrastatform Dispatch detailed.docx (public.lu)Extended DeclarationMicrosoft Word - Intrastatform Dispatch extended.docx (public.lu)Account SchedulesGenerating account schedulesBy default, Fisqal™ is shipped with the possibility to generate account schedules (financial statements) based on any eCDF declaration card. To generate an account schedule, make sure the eCDF declaration card is filled:Then, navigate to the Account Schedule Names page in Business Central and use the action “Generate account schedules based on eCDF”:Future releaseFeatures not mentioned in this document are not available in this version of Fisqal®such as the following:-Setup Improvementso Updated PCN 2020 with account categories and subcategories-Intrastat Improvementso Intrastat Controlso Export the electronic format of the Intrastat declaration-VAT Improvementso Export eCDF as an .xml file ready for import by the eCDF platform of the GovernmentIT Centre of LuxembourgThese features are planned to be shipped in a future release.For more information about the product, please refer to: SK Consulting S.A.49, rue de Cessange2441 LuxembourgLuxembourgTelephone: +352 2625 9117-1Email: ***********************Legal•Privacy Policy•Terms and Conditions•EULA。