UK - Manuale LITESTAR 4D Lisdat
Contents
1. CEI 34 21 EN60598 1 93 A1 CEI 34 22 B KW e Clg ID HAL CEI 34 23 H S CEI 34 23 EN60598 2 2 96 Pe N CEI 34 30 ENEC USIBILE 03 Marks F EN 60598 1 CE IMO Delete Delete Marks CE ML Delete Page 19 23 OxyTech Creating the catalog Media TAB linked products In the Media section it is possible to select external files to link to the product such as images texts and accessory documents The possible choices are gt Type indicates the type of association of the file Here you can choose from Technical Sheet all the files linked to the product in this way will be visualized directly in the product Technical Data sheet in Liswin according to the various page displays available e Linked Documents all the files linked to the product in this way will be viewable in Liswin as external documents and will be printed independently This option allows different types of file to be linked to the product so as to make the information regarding it more complete gt File Type indicates the types extensions of file that can be linked to the product The types of files that can be linked differ according to whether Technical Sheet or Linked Documents have previously been selected By selecting Data Sheet for a more detailed explanation on the data sheet see chapter Creating and Managing a data sheet in the Liswin manual in the File Type2. General Data Electrical Parameters Norms and Marks Energy Parameters media Notes Energy Classification UE 874 2012 EEI E Energy Class A D KwWh 1000h Page 18 23 OxyTech The energy evaluation represents a class of the luminaire efficiency evaluation nowadays applied to road lighting luminaires according to specific parameters defined in accordance with indications supplied by Hera Luce Creating the catalog Norms and Marks TAB In the Norms and Marks section it is possible to select the reference norms and marks of the product The screen shows the following elements gt gt marks selection menu the list of the marks linked with the product situated immediately below norms selection menu the list of the norms linked with the product situated immediately below Each of the two sections shows the Delete key in the lower area with which previously linked marks and norms can be deleted On the operative level to link a mark or norm click with the left mouse button on one of the available options At this point the mark or norm will be added to the list of marks and norms linked with the product To delete a previously linked mark or norm from the list just select a mark or norm and press the Delete key Only one mark norm can be deleted at a time General Data Electrical Parameters Mechanical Parameters Photometric Parameters Worms and arks Media Notes
3. lt lt Notes MeasReplacement IL sl CutoftAnde It Dee Beam opening Lamp Type Power Lamps Number Alternative Lamp Add Lamp New Lamp Change Lamp Ballast factor fo Delete Ballast loss IW m Linked Lamps the table shows the references Product Code Lamp Type Power Lamps Number Alternative Lamp of the lamps linked with the measurements or the product There are another two fields available i e e Ballast Factor to indicate the BF value e Power Loss to show the loss of power supply To manage and link the lamps it is necessary to use the five keys in the right hand part of the section These have the following functions e Add Lamp to link a lamp to the product using the Liswin lamps archive by clicking inside the number of lamps field the lamps number can be changed by typing in the new number e New Lamp to add a new lamp in the Liswin database e Change lamp to change the selected lamp e Delete Lamp this allows you to delete the selected lamp Page 17 23 OxyTech It is possible to directly link a photometry to the product in a different format from OXL such as for example Eulumdat or IESNA In this case by selecting the file in the folder where it is situated the program will automatically proceed to convert the format into OXL and to copy the new file in the Litepack folder of the manufacturer if the archive has bee
4. Italian language will be viewable select the File Type from the relative fu Apri Nome Data e dropdown menu Our FRA 26 04 2012 16 28 Cartella di file To activate the menu it IS necessary Organizza v Nuova cartella me men e Gees z eg artella di file to click twice with the left mouse Nome Ultima modifica litepack 26 04 2012 16 28 Cartella di file button on the field and then scroll the Seel fi 01 08 2012 11 26 E catalog coverjpg 02 03 2012 12 03 Immagine JPEG available formats with the pointer ia Ji Agabekov 21 06 2012 16 10 beppe_dimensionij 31 03 2008 14 54 Immagine JPEG oe A mmagini EE clicking on the required one ryt Ji Astro 26 04 2012 16 28 ees SEN i D ccce 31 07 2012 14 43 uE gino_dimensionijpg 15 07 2010 09 27 Immagine JPEG E Video A DISANO 19 06 2012 17 02 i gino_opal jpg 15 07 2010 09 27 Immagine JPEG A Fael 21 06 2012 16 14 E logo jpg 15 07 2010 09 27 Immagine JPEG Gruppo home Ba Computer di Feam 26 04 2012 16 28 A Fumagalli A Gewiss 26 04 2012 16 28 21 06 2012 16 11 mmm E Acer C ca Microsoft Office A i om KR S d Goccia 21 06 2012 16 12 b Nome file v JPG Files jpg Max 25 Chr 3 ees Page 21 23 Creating the catalog Notes TAB In the Notes section it is possible to insert any notes required relating to the product according to the relative reference language The sheet is divided into four sections
5. by means of the correspondence tables which can be selected in the lower part of the window Enter the code id corresponding to the comma for decimals nn 8 M4 SpreadSheet Product Type Colors Applications desired value color type etc Page 23 23 Each field column of the Bridge Excel file shows both the description of the field and the comment of the field itself where the following are defined gt description of field gt type gt Tomat number characters gt an example gt the field name variable as defined in the OxyData MDB database Multiple Entries There may be cases in which the product has a number of different values for the same field in this case just insert as many columns as values to be inserted Example if the product has two colors it will be necessary to have two color columns and on the same line as the product to enter the two color references Texts in Various Languages The system allows management of files in different languages To link these just enter the name of the file the same in all languages in the Excel Bridge file and save the file in the language in a folder with the language name for example ITA for Italian ENG for English etc Accessory Files and Images Save the file in a folder with the same name as the archive to be inserted and type the full name in the Excel file Conversion Excel gt gt Oxydata M
6. individual products gt links to external documents photometries images texts It is possible to choose an alternative path in which to insert the manufacturers folders using the Configuration window by selecting a new address at Database and Media for a more detailed explanation see the Configure Liswin chapter The technical data catalog and photometries of the individual manufacturers present as Plug ins are updated using the various search options found in the Liswin module for a more detailed explanation see the chapters concerning data updating and search Lisdat Catalog data management The OxyData MDB The catalog products are entered in a relational database in the Access format MDB of Microsoft which allows greater flexibility in data management and integration In addition this system allows the modifications made by the user to be activated immediately visualizing them and making them utilizable in the other modules without having to go through OxyTech It should be underlined that the plug ins supplied by the companies can never be modified or updated unless by the company itself so as to maintain the accuracy of the data Updating by means of plug ins however does not prevent individual users from inserting and then modifying the products not found in the database thus creating their own archives to be added to those of the manufacturing companies The catalog name by def
7. linked to the individual products Le gt Images of products applications or drawings up to a maximum of 10 per product gt Photometric files in OXL format the OxyTech format for measurement data exchange gt External documents instruction leaflets assembly diagrams certificates in various formats PDF XLS DOC DXF DWG Product manual management amatic Import Management Manual insertion or automatic import selection keys OxyTech It is possible to access Lisdat from the Liswin module by means of the Lisdat icon situated e on the left of the screen above the list o in the Links menu Alternatively you can select the Lisdat program from the window Start All programs Oxytech When the module opens one of the following functions can be selected gt Manual product insertion updating gt Automatic Import management LITESTAR Liscat Catalog Data Manager amp Oxy Tech Exit from module Page 5 23 Manufacturer Window OxyTech The Manufacturer window allows you to visualize the manufacturer s reference data Whether products are added automatically or manually to add a new manufacturer the Add manufacturer key must be pressed A new manufacturer must be added when the user wants to insert new products that are not available in the manufacturers plug ins This is because the catalogs created using plug ins and subdivided in the Liswin module in ma
8. loaded and linked to the product can be searched and selected The previously set parameters can be modified by clicking on them twice Page 20 23 OxyTech The keys situated on the bottom left allow you to gt Add to add a new file to the list gt Remove to remove the selected file from the list files on the list By selecting an element and clicking on the arrows the product line will be moved respectively upwards or downwards through the list This operation allows you to put in order the visualization of the elements in the Liswin window If a photo and a drawing are linked to the product it is advisable to always place the image in the first position so that it will be the first element to be visualized in the Liswin window Media TAB how to link a file The steps for adding a file to the list are as follows Add D Technical Data Sheet press the Add key In this way a line highlighted in blue will appear in the window select the Type of association from the dropdown menu that appears automatically by clicking on the arrow and scrolling the available elements with the pointer To select the item just click with the left mouse button on the line highlighted in blue Finally to select the file to be linked click twice with the left mouse button in the File Name field At this point the dialog window opens where you can search and select the file in the computer folders the predef
9. 23 OxyTech Creating the catalog Photometric Parameters TAB In the Links section it is possible to link the photometric files to the luminaire The window consists of two sections Linked Measurements and Linked Lamps gt Linked Measurements the table shows the references Product Code and Product Description of the linked measurements On selection of the linked measurement with the left mouse button the program shows the photometric curve of the measurement in the lower left hand area Another two fields are also available i e e Optics to indicate the type of optics of the luminaire Optics Name to give a specific name on the part of the manufacturer to the optical system of the luminaire e Cut off Angle to indicate the value of the cut off angle e Beam opening to indicate the beam opening angle To manage and link the measurements it is necessary to use the five keys in the right hand part of the section These have the following functions e Add Measurement when selected this opens the window in which to select the file you wish to link with the product e Substitute Measurement this allows you to substitute a previously selected measurement e Delete Measurement this allows you to delete the selected measurement e Other Data this allows access to the Photoview module visualizing the data of the selected measurement ue N E Luminaires x Martinelli Luce SpA 2875 3 1 D Find
10. 5 E zero_parairdsg ipa 29 ER Immagine JPEG 13 11 2008 16 45 e Drawings in DWG or DXF format e catalog cover JPG i e the file for the cover Window which is visualized by selecting the manufacturer from the list in Liswin gt A number of files equal to the number of available languages will have to be created for the connected documents named with the abbreviation of the language FRA for French ING for English ITA for Italian inside which all language sensitive files are saved e Catalog parts certificates etc in PDF format e Product texts etc in RTF or DOC format The files of the texts translated into the various languages relative to the same document will have to have the same name so they can be visualized correctly when the product is selected in Liswin in the different languages gt A Litepack folder must be created in which to save the OXL files Page 3 23 OxyTech The OXL file is an XML type file files used in many applications for data exchange inside which the following information is found gt me general lighting device data gt the lamps data including color gt the dimensions and if available 3D file of the luminaire Each code inserted in the general database must correspond to only one OXL file Oxydata mdb is found in the program data folder Docs DB It is a relational Access database which contains gt data technical and commercial related to the
11. 70 BI_Q8_1X70W G12 MH LDT 7 1296 F 70 B1_Q8 DIR IND_1X70W G12 7 1296 J 70 BI_Q8 JUNIOR 1X70W G12 7 1296 J F 70 B1_Q8 DIR IND JUNIOR 1 10 04 2012 12 21 10 04 2012 12 26 10 04 2012 12 29 10 04 2012 12 31 File LDT 2KB File LDT 2 KB File LDT 2 KB File LDT 2KB Litepack 0 Importazior LDTAES LDT IES gt Litepack DB Ime Verity Nome file 1296 70 BI_Q8_1X70W G12 MH L IES Files JES LDT Modify Litepack 02 Verify links This allows you to verify if the OXL files are correctly linked to the products in the Liswin database In other words it allows you to check that the OXL files in the folder relating to the manufacturer correspond in number and name with those linked to each individual code in the database lists To carry out the check just gt select a manufacturer that has products linked with OXL files select the Verify links key the product codes and relative OXL linked files will appear on the right of the screen should there be linked files that are not however inserted in the manufacturers folder NOT FOUND will appear alongside the code Page 9 23 OxyTech The convertible formats are gt Eulumdat LLDT European standard gt IESNA IES American standard including IES2002 The program automatically proceeds to copy the files created into the manufacturer s tree in the Litepack folder and to insert the data relating to the selected manufactu
12. 8 0xl 04 06 2012 23 37 File OXL 12 KB 7 612 FLCL24 oxl 04 06 2012 23 37 File OXL 12 KB Litepack O L i nt 5 d i 2 613 FLCLd8 oxl 04 06 2012 23 37 File OXL 12 KB Importazione OX LZ 613 FLCL24 0xl 04 06 2012 23 38 File OXL 12 KB LDTAES import LDTAIES gt Litepack OXL Nome file 610 FLCId8 oxl 610 FLC1x24 0x OXL Files oxl hd DB Import Fa Ze fe Annulla Verify links Ae the program will automatically insert the codes in the database and link them to the photometries The new products can be visualized in Liswin or manually edited to add missing data in Lisdat Manual management Page 8 23 OxyTech Any manufacturer can be deleted but only the names of manufacturers added by the user and not those downloaded as plug ins can be changed In order to be able to import the new products a new manufacturer must first be created for a more detailed explanation see the chapter Manufacturer window The OXL files must contain the codes related to the manufacturer otherwise the program will not allow import For this reason they will have to come from the conversion of the data from the other photometric formats after selecting the manufacturer or from the FOTOM FDB If the files have not previously been inserted in the selected manufacturer s tree in the Litepack folder the program will automatically proceed to copy them there Automatic product management LDT IES import This allows you
13. B folder defined during installation see paragraph Program installation and startup in the Litecalc manual contains the data relating to each individual manufacturer subdivided into subfolders for a more detailed explanation on creating a manufacturer please see the chapter Manufacturers window lf a new manufacturer not a manufacturer plug in is created in the folders of each manufacturer the following procedure must be followed gt Non language sensitive data must be entered manufacturer folder e Product images in JPG format e Company logo in JPG format in the Mome amp Dimensione Tipo Data ultima modifica IFRA Cartella di file 22 06 2010 11 21 ING Cartella di File 22 06 2010 11 21 ita Cartella di File 22 06 2010 11 21 LitePack Cartella di File 22 06 2010 11 21 SPA Cartella di File 22 06 2010 11 21 TED Cartella di File 22 06 2010 11 21 E KARMAHTERRA JPG ZO KB Immagine JPEG 15 11 2008 16 31 E KARMAHTERRADSG jpg 45 KB Immagine JPEG 13 11 2008 16 31 E karmalMterra jpg 21 ER Immagine JPEG 15 11 2008 16 31 EJ KARMAIMTERRADSG JPG DA KE Immagine DEG 13 11 2008 16 31 logo pg SKB Immagine JPEG 25 06 2009 13 48 EJ OLLATAWOLO JPG 34KE Immagine JPEG 13 11 2008 16 34 Zero IM_dsg jpg 27 KB Immagine JPEG Al Users Documenti OxyTechiLITESTAR 40 1 0 verifica DBYLUCITALIG d 13 11 2008 16 45 E ZERO IM jpg 49KB Immagine JPEG 13 11 2008 16 45 Gi Zero_pargir jpg Zd ER Immagine JPEG 13 11 2008 16 4
14. DB The conversion of the Bridge Excel file into OxyData MDB is the responsibility of OxyTech and is included in the license conditions of the program Maintenance Contract if in force
15. Lisdat _ Catalog Data Manager LITESTAR 4D v 3 00 User s Manual Lisdat Catalog Data Management June 2015 S OxyTech Index BE GE e tee EE I nie TEE 3 Ae 3 Be ERR RE 4 ligarse 16 pie lata EE 5 Vier E ele e ere 6 Ate e es ele riers ars te rt EE T interlace le e 7 Rename added manufacturer ocean ccc he seactnacrvenncocc sacep seq unevocesa ceed aateecnn estes cciedessestssaesiactiaciecticngae pin os sseanmnnseconad eseansueyenas oodaa soeeasuieiniociautiedeet read ecutsa cua dunwtetwe ne taueeaeetuoad panied ouadnauesasocaienenseenneaceasersaeds 8 Biga 8 Litepack OXL EE gE 8 METEN ee EEn 9 LOTIE a Ltepaek OXL COnVETS Nn 9 bede LE 9 Modify Litepack OXL ade doreen 10 Modify Litepack OXL with lamp data EE 10 Convert FDB gt Litepack OXL EE 10 BSR EE EE 10 ET UR a cere aane ae EE 11 lte ae e ME 12 Se biet 12 General Dala Tee 14 Electrical Parameters TAB E 15 Mechanical Parameters KEE 16 Photometric Parameters TAB sscsscicacacicaecsonstasnsepsanancedasasecsanahaacanadaansinscsnnasanaasncanneh tata audisndepsdanaadoatahecen iad aaaaeaddantaaacanqaaasda aaxaaheh cacbandisedeoasaaasdgadadecenbahaeaaesdannceaacanqaabatisacasieaeaseandizeaenas 17 Energy Parameters TAB EH 18 Norms and Marks TAB ieee ancneaaantsanennencataasdinntenansaaad gana ar iiaa ai ariaa aaaea iaa aai Eaa nii ae Ainii a AEEA a ia EA gab aad n aAA eii RARA Ai nanai 19 Media TAB Inked eidele E 20 Media TAB how to link A NIE neenstemmen nnn eene
16. abilty Class pb E parametric searches in Liswin se aa D se sabia Gegend i Should however there be specific requirements the manufacturers price list can be inserted This field is eee w eenen Sech B pn mn you may contact OxyTech directly so they can an q En 150 2500 E effect the insertion of the new items if this is Lt Fon ER ublic Areas 3 Se i gt Product type Type B field this allows selection among the Ge Ke compatible with the stability requirements of the ross Wei p otels various types of product e g Exteriors Interiors Wall re Model Fl 4 system Interiors Ceiling etc This field is unequivocal gt HOLE LIGHT E After receiving the update the new description will Jahil Ger Eeer dee Geer N be viewable in the list by activating the file using gt Availability Class Type A field Alphabetical Max 1 Sen HOLE LIGHT 1x55W 26X13 FL Engish d R i E SC T 2875 J B HOLE LIGHT 1x55W 2GX13 FL talian y the File menu Enable Filter key in Liswin OxyTech Ge We bie to Ss supply availability of the product Ge HOLE La vee aon Spanish n EDE will however send the relative instructions according to The Tolowing classes hon nen na Sg White kheden en 2875 J BI HOLE LIGHT 1x55W 2GX13 FL Flemish a 29 03 2012 e B within 7 days 2875 J BI HOLE LIGHT 1x55W 2GX13 FL Hungarian New Vv e C within 15 days e D within 30 days Pieces per Pack Type A field Numerical Max 3 Mod
17. ault is OxyData MDB and is found in the folder Docs DB see the paragraph Program installation and startup in the Litecalc manual It is advisable to maintain this configuration although there is no reason why the name or position of the database cannot be changed as deemed necessary In this case it will be necessary to configure the new path in the Liswin module selecting the File Configuration menu When the configuration window opens just click on the original description in the Products Database section to open the selection window in which to choose the new MDB file In the Documents section on the other hand it will be possible to define the new path for the linked documents for a more detailed description see the chapter Configuring Liswin in the Liswin manual If a new database has to be created the empty MDB database can be downloaded from the Software Update Accessory Files section of the www oxytech it site selecting LITESTAR 4D Empty OxyData The file can then be saved in the file the user prefers and connected to the program as described above There are two different ways of creating a new catalog or of inserting new data in an existing catalog OxyData MDB file gt use the Excel Bridge File LITESTAR 4D Database Bridge Excel File Luminaires complete it and import it into OxyData In this case it will then be necessary to send the Excel file together with the accessory files OXL files PDF do
18. column selection can be made among e JPG and BMP Files to link images in JPG or BMP format to the product The advantage of JPG format is that of reducing the file dimensions whereas the advantage of BMP format is that of improving the resolution of the image e Product Sheet to link texts in RTF format to the product The text will be visualized in the Texts TAB of Liswin and will have as a title the selected description e Characteristics Description Assembly Instructions to link texts to the product as external documents General Data Electrical Parameters Mechanical Parameters Photometric Parameters Norms and Marks Media Notes Files List Type File Type File Name elight jpg 2875 rtf Linked Documents Assembly Instructions PD ght J Plafone_ita_eng pdf Technical Data Sheet JPG files 2875_hole light_2amb1 jpg Linked Documents Product Certification PDF 219 HOLE LIGHT 2875 _J pdf Linked Documents Product Certification PDF 09_2875_holelight_IMQ pdf Technical Data Sheet JPG files Technical Data Sheet Product Data Sheet By selecting Documents for a more detailed explanation on the visualization of linked documents see the chapter con Bars in the Liswin manual in the File Type column selection can be made among e WAV TXT DOC XLS RTF PDF DES DWG File e Product Certification PDF e Assembly Instructions PDF e Catalog Page PDF gt File Name with this field the file to be
19. cuments images to OxyTech for import of the data in the OxyData MDB file gt use the Lisdat module and enter the data one by one without going through Oxytech The choice of one system rather than the other depends essentially on gt the availability of data that is already organized in another system database in this case it will be possible to export the data neatly from the original system to the Excel file gt the prowess with Excel the copy and paste function is very fast for entering the data but at the same time must be handled with extreme care since it is easy to make mistakes gt the preference for an entry instrument that guides data definition step by step In this case the use of Lisdat is convenient because it also offers the enormous advantage of keeping active the data for subsequent entries for example if a family of products characterized by identical data apart from the code and color has to be inserted it will just be necessary to modify the code and color to create a new product without having to re insert every single item of data OxyTech To download the Bridge Excel file access the main page of the www oxytech it site then select the Software by clicking on it either using the list shown on the top left or the relevant central image L I Gi E OxyTech Manufacturers amp Wgs P WebCatalog List gt Presentation P Tutorial LITESTAR Project At this point select Access
20. ect the Find key Availability Class rf l EA T gt Click on the rt If arrows to scroll through the Volume m3 codes one by one Dimensions mm LIT Application Insertable data TAB Net wou The keys in the lower part of the window allow you Gross Weight kg es Product Description Moel 7 p Backwards to return to the entry window El a gt Delete to delete the product shown on the Function keys for Gg screen product and database Spanish Color p gt New Product to clear the fields and enter an management pean Dropdown editing new product Sc HEIs SERON 10 DE Save Product to save the inserted product Date a completed Cancel to exit the module Delete New Product Save Product Cancel Page 11 23 Creating the catalog Field types With Lisdat it is possible to insert your own archives alongside those created by the companies in a single Oxydata MDB The data can be inserted and modified in several different ways i e gt _Alphanumerical entry fields Type A these are editable alphanumerical numbers and letters fields that allow entry of a certain number of letters and or numbers the fields with asterisks are required fields Product Code AR gt Predefined Multiple Selection Dropdown Menu Type B these are dropdown menus in which it is possible to choose from various available items which cannot be modified To select a field just click on the de
21. el Type C field Alphanumerical Max 20 characters characters this allows selection among the various items inserted Volume m Type A field Numerical previously by the user or insertion of a new item Dimensions mm Type A field Numerical gt Color Type B field this allows the choice among the possible colors of the product gt Date this is a non editable field in which the program enters the date the modification is carried out gt New Type D field this is the flag with which to indicate if the product is new Net Weight kg Type A field Numerical Gross Weight kg Type A field Numerical EAN Code Type A field Numerical Max 25 characters this is the reference bar code of the product gt Product type Type C field here it is possible to insert the product type defined by the manufacturer on the basis of the company catalogs gt Application Type B field this allows selection between the possible fields of product utilization e g medical environments public areas commercial areas etc v v v v VW Page 14 23 Creating the catalog Electrical Parameters TAB In the Electrical Parameters section the following product characteristics can be inserted gt Insulation Class Type B field this allows you to choose among no class Il and Ill Insulation Class Ballast Type Ballast type Type B field this allows the luminaire feed
22. gt Note gt Note 2 gt Note gt Note 4 It is possible to enter a maximum of 4 lines of notes that can be managed via the technical sheet of the product and in the Texts TAB of Liswin To insert a note just click on the language reference line and type the description The procedure has to be performed for each language if you choose to translate the description into all the available languages If instead a single language is selected just type the description in a line select it with the right mouse button and select Copy Values Below lt will however always be possible to modify the string of an single line by clicking on it Notes 1 Notes 2 Notes 3 Notes 4 Page 22 23 OxyTech The Bridge Excel file OxyTech There are two types of Excel Bridge file one for inserting lamp gt archives and one for luminaire archives In both cases the file is organized in the same way as the gt OxyData MDB database and in particular as regards the sections for Excel luminaires gt Commercial Parameters in which to enter the commercial gt data of the product such as code description price list reference etc gt Mechanical Parameters in which to enter the mechanical gt parameters such as weight insulation class IP etc gt Electrical Parameters in which to enter the electrical parameters such as lamp code by inserting the lamp code shown in the Liswin lamps catalog the p
23. hould it not be necessary to perform translation for each language it is possible to click on the description with the right mouse button and confirm to obtain the automatic insertion of the description in the other languages N Copy inal SES Engh Delete all italian Spanish German Czech Portuguese Slovenian Flemish Hungarian Polish Russian Portuguese Brazil Greek Catalan Chinese Simplified Finnish Croatian Cancel Save Product OxyTech Creating the catalog gt Flag Activation Fields Type D these are fields that allow gt Fixed Multiple Selection Fields Type E these are fields in definition of whether the option is active or not To activate or which predefined items can be selected by clicking on them deactivate the flag just click on the relative box with the left mouse button The selection is highlighted in the window below and more than one of the available options may be selected New Iw CEI 34 31 IENBUDOG ZA Page 13 23 OxyTech Creating the catalog General Data TAB ponannnnansensenensenvonenvenensenen In the General Data section the following product characteristics EE Some fields such as the Product type field allow can be inserted en ER EAN de ae selection only from an unmodifiable list i _ d Product Type interiors Ceiling DI Product Type x This is necessary to allow users to perform d dere een e GEN Geer oc SC So Avail
24. ined search folder is that of the program DataBase Should the file be in a different folder from the destination folder the program will automatically copy it there unless the MakeCopy field in the Liswin settings is deactivated Should it be necessary to link the same image or text to a number of codes it is advisable to insert the file directly into the destination folders If not the program will duplicate the file adding a number at each association The default folder is defined in the Liswin configurations for a more detailed description see the chapter Configure Liswin in the Liswin manual Generally this folder is contained in the DB name archive for images and the DB name archive language name for texts OxyTech All the files linked with a product inserted using the modules of LITESTAR 4D are automatically copied in the default folders of the program DB The DB folder is found in the LITESTAR 4D Docs folder and is in turn divided into subfolders one for each manufacturer Inside the manufacturers folders the files are divided as follows gt Files independent of the language the photometries are saved in the sub folder Litepack e the images are saved in the main folder of the manufacturer gt Files dependent on the language the text files are saved in the sub folders divided according to the language this means that for example opening the ITA folder all the files referring to the
25. n created by the user the name of the folder will be that defined by the user Creating the catalog Energy Parameters TAB In the Energy Parameters sheet the energy evaluation and energy class can be assigned to the luminaire The window is made up of two fields gt IPEA Value enter here in numerical terms the energy efficiency value calculated by opening the photometry in Photoview and visualizing the values in the IPEA Energy efficiency evaluation TAB IPEA Energy Class this represents the reference energy class to be applied to the luminaire on the basis of the calculated IPEA values The classes available in the drop down menu go from A to G and represent the range of values according to the table shown alongside the field When inserting a lamp it is possible instead to enter the energy class in accordance with the UE 874 2012 norm Also in this case the window is made up of two fields p EEI where the value relative to the kWh 1000h of the individual lamp is entered Energy Class this represents the reference energy class to be applied to the lamp The classes available in the dropdown menu range from A to E and represent the range of values as seen in the table shown alongside the field IPEA Assessment IPEA Value KT E e IPEA Energy Class l A DI Backwards Delete New Product Save Product Cancel Lamps D osram x 41830SsP Find lt lt
26. n module The fields with a red asterisk are compulsory and must have the same description When inserting the new manufacturer the user must choose the type of inserted products between Lamps and Luminaires According to the product type chosen the manual data insertion window will show different entry fields For example by entering lamp data it will be possible to type in the lamp flux which is not present in the luminaire fields since it relates to the photometry If a file called catalog cover JPG containing a cover image of the manufacturer is inserted in the manufacturer folder when the manufacturer is selected in Liswin this image will be visualized for a few seconds Automatic product management Interface window Click on the Automatic import management key in the module entry window to access automatic data import management for both catalog and photometries The window allows new products to be added to the database converting and importing the photometries from other formats or importing an external MDB database The window also allows you to check the accuracy of the links between OXL files and the products in the database to which they are connected and to carry out certain operations on the OXL files The available functions are gt Add manufacturer to allow the user to add a new manufacturer for a more detailed explanation see the chapter Manufacturer Window Rename added man
27. n tente edet otten tere eeen gaminoectinndc vient einde 21 Kiew 22 BLR ele E a EEn 23 Page 2 23 Lisdat Catalog data management Data structure LITESTAR 4D is equipped with a single database Oxydata MDB evolution of the LITESTAR 10 catalog database in which the functions for managing the photometric files in the new OxyTech OXL format have been integrated The OXL files are obtained by converting the photometric files into international formats e g EUL or IES by means of the Photoview module in which the graphs can be visualized individually or automatically using the Lisdat module for a more detailed explanation please refer to the chapter Automatic product management The MDB database is created by downloading the manufacturers Plug ins unmodifiable data by means of the Liswin module or by directly inserting the luminaire technical data using Lisdat Lisdat by converting the photometric files also allows the catalog to be created automatically and the photometries to be attached extracting the basic information from the available photometric data for a more detailed explanation please refer to the chapter Automatic product management The database also allows management of the relative documentation useful for completing the data sheets such as images and texts These files will first have to be inserted in special folders to allow them to be linked to the product as explained below The D
28. nufacturers archives cannot be modified by the users and therefore a new archive has to be created to be able to add new products to the database The window relative to the new manufacturer will be editable in all fields figure below Company Manufacturer Address City ZIP Code Country Tel DI Tel 2 Tel 3 Tel 4 Fax E mail Website lt will thus be possible to modify the data typing in the new values in the individual boxes or to add a presentation or certification of the company in PDF format using the Open key to link a new file or Change to change a previously linked file By clicking on the Logo key it will also be possible to add the image of the company logo logo JPG which will then be visualized in the box on the top right and then must be positioned in the folder relative to the manufacturer for a more detailed explanation see chapter Data structure Finally click on the Add key to make the updates effective LUCITALIA Information Discount Product Type w C Lamps C Ballast Company presentation Open Change Open Change Company certification Page 6 23 The company presentation certificate and logo will be inserted in the manufacturer s folder inside the program data folders For a more detailed explanation see the Data structure chapter Once the new manufacturer has been saved to modify the data just click on the logo in the top right in the Liswi
29. odify Litepack OXL with lamp data to substitute the OXL file lamps with those in the database to which they are linked Convert FDB gt Litepack OXL to convert links from the old Litestar 10 format into the new OXL format OxyTech The keys in the lower part of the window allow gt Backwards to return to the entry window gt Close to exit the module Data import conversion movements will be visualized on the right of the window The converted data will be saved in the folder of the selected manufacturer as explained in the paragraph Data structure The OXL files are unique for each luminaire and are contained in the folder DB manufacturer s name Litepack In order to be able to visualize them with the product to which they refer they must be linked to the code relating to the product in the database Should a catalog not be available but photometries in standard or OXL formats are the catalog can be created by importing the codes of the photometric files directly into the database In this way the photometric files will automatically be linked to the new products created in the database Page 7 23 Automatic product management Rename added manufacturer To rename a manufacturer added by the user just gt gt select the manufacturer to be renamed from the dropdown list on the top right select the Rename added manufacturer key type the new name in the window that opens press Ok
30. operation to be successful the name shown in the link in the old version must correspond with that of the OXL file If not it will be impossible to find the correspondences Flux L po bi Jon DULUX D E 26 W 8 DULUX D E 26 W 830 G24q 3 1800 00 26 00 1 Rilievo Rendimento 23 85 Lampade Apparecchio Lin VW Max Inten 71 21 cd kim Pos Max C 0 00 G 60 Flusso rilievo 1800 00 Im Area Frontale 0 010880 m2 Area Laterale 0 029484m2 Simmetria Asymmetrical Maximum Gamma 180 Codice CL322 04 041 HF74492 Nome HF74492 G24D 3 FSQ 1X26 TION GARDEN H 300 1x26W FSQ G24q 3 230V TION GARDEN H 300 DB Import This allows two operations gt to import an external database into the general database gt to export a manufacturer from the general database to an external database In the first case you must gt select the manufacturer where the database products are to be inserted and select the DB Import key gt select the file path to be inserted and press the Import key the products will thus be imported into that archive In the second case you must gt select the manufacturer to be exported and select the DB Import key gt select the path of the file in which the products are to be imported and press the Export key the products will thus be exported into the new database Page 10 23 Date ansgerent ccce E SLITESTAR 4D LITESTAR 4D Docs DB OxpData mdb El Im
31. ory Files in the Download menu shown in the index on the left from which it will be possible to download the LITESTAR 4D Database Bridge Excel File Luminaires file OxyTech _ veveoe Accessory File Download Bridge Excel Files and Empty OxyData for LITESTAR 4D Tutorial The LITESTAR 4D database creation is possible in 2 different ways LITESTAR Project LITESTAR Litecaic gt Liswin using LITESTAR 4D Lisdat the data ma evelopped b Ti at gt Photoview Lisdat P WebCatalog SE Note the LITESTAR 4D database is the same used for the WebCatalogs Gallery the Internet system of catalog product browsing We ask you to contact our customer service for any information on how to activate your WebCatalog LITESTAR Open Pro Freeware Software Access Files gt LITESTAR Updates gt LITESTAR 4D Bridge Excel File Luminaires Rv01 010811 News You may find below also the Empty OxyData file the empty program database to be used for new data inputs or imports with LITESTAR 4D The OxyData mdb db must be copied at the program DB folder Page 4 23 Lisdat Catalog data management Introduction and access LITESTAR 4D Lisdat is the program module for the maintenance entry and modification of the catalog data luminaires and lamps used in the Litecalc and Liswin modules Lisdat in addition to managing the technical catalog data also allows management of the documents
32. port Export Close i d OxyTech Clicking on the Manual product management key in the entry window accesses the function of Company plug ins can never be modified except manual data management by the companies themselves so as to preserve l l l data accuracy At this point from the first dropdown menu choose between d gt Luminaires if luminaires are to be inserted Select Manufacturer gt Lamps if lamps are to be inserted Once the type has been selected in the second dropdown menu select the manufacturer whose Add manufacturer data is to be updated By selecting the Add manufacturer key the user can add a new manufacturer whose data will always be modifiable for a more detailed explanation see the chapter Manufacturer window When both fields have been set the product data insertion TABS will open automatically To find a previously inserted code you can Luminaires aaa all Find gt gt Manufacturer and code gt Click on the vertical arrow positioned alongside the code list on the top right and scroll through the codes General Daf Electrical Parameters Mechanical Parameters Phptametric Parameters Norms and Marks Media Notes selection menu bar j odat a Lode j j i Product type selection Product Code af Cod gt Type the code in the field on the top right and dropdown menu bar Product Type Product Type DI sel
33. rer in the OXL files The manufacturing companies will be the owners and will be able to insert data to create plug ins only in the manufacturer name assigned to them The final users however will have to create new manufacturers in which to insert the data since the plug in folders are modifiable only by the manufacturers Automatic product management OxyTech Modify Litepack OXL with product data This allows the code and the description of the linked product to be written in the OXL file so that the data coincides both in product visualization in Litecalc and in Liswin To activate the command just select the manufacturer from the list and click on the Modify Litepack OXL with product data key The operations will be shown on the right of the window Modify Litepack OXL with lamp data This allows the lamp directly linked with the product in Liswin to be written in the OXL file To activate the command just select the manufacturer from the list and click on the Modify Litepack OXL with lamp data key The operations will be shown on the right of the window Convert FDB gt Litepack OXL This allows you to convert the product photometries links from the LITESTAR 10 version to the new LITESTAR 4D version To perform the operation just select the manufacturer from the list and click on the Convert FDB gt Litepack OXL key The operations will be shown on the right of the window In order for the
34. rogram automatically links all the electrical parameters to the product etc Norms and Marks in which to enter the Norms the product complies with and the Marks of conformity Images JPG or BMP and Texts RTF in which to enter the name and extension of the image or text file to link to the product Photometric Data with which to define the name and extension of the file or photometric files to link with the product Accessory Files with which to define the name and extension of the accessory files or file instruction leaflets assembly diagrams to link to the product The files may be in different formats OxyTech alol 0 SON TESTAR 4D Bridge Excel File Luminaires Rv00 240410 Example of comment in the field 15 Commercial Parameters Product Code 16 HA 18 L0301RC BRO711i 19 L0301RC LB0301 BR0711i 20 L0503RC GX01071 21 LO109PD W1215 Type PL 1 2009 number Format max 20 characters Use PL 1 2009 PL 1 2009 PL 1 2009 22 i It s the product price as per the Price List It s not obligatory to input the price as it can be managed separately Example of field The comment is available if a red triangle appears in the upper right of the field itself Just place the mouse pointer on the triangle to make the comment appear Certain fields present in Lisdat as dropdown fields have reference numbers and are definable
35. scription with the left mouse button In some those without the and keys only one selection can be made Product Type Emergency a Exterorlnterior Emergent E steriors EI Exteriors Ceiling Luminaires Availability Class Pieces per Pack Extenors Emergency Light Externors Emergency Light Exteriors Explosion Proof L SHEE Floodlights Volume m3 Dimensions mm Net Weight kg Gross Weight kg gt Editable Multiple Selection Dropdown Menu Type C these are dropdown menus in which it is possible to choose among the various items previously defined by the user To enter a new item you must click on New and complete the window that opens To add one of the items present to the list select it from the dropdown menu and press the key On the contrary to remove an item that has already been entered select it from the list and press the key prod 2 DH EN T prad Product Type UD Page 12 23 OxyTech New definitions may be implemented in these menus by communicating the new fields to OxyTech OxyTech will perform insertion and activation in the DBFilter To make the new fields operative it will be necessary to copy the update file in the folder indicated by Oxytech and enable the items in Liswin file menu Enable Filter To enter a new item you must press the NEW key and this opens a window in which to type the new descriptions in the various languages S
36. tical Box and Auxiliary Box as for example may happen with road lights or floodlights By typing for instance 64 the IP64 in Liswin will be visualized Optical Box IP Grade Type A field Numerical Max 4 characters Auxiliary Box IP Grade Type A field Numerical Max 4 characters Shock Resistance IK Type A field Numerical Max 3 characters here the shock resistance index can be entered By typing for instance 10 the IK10 in Liswin will be visualized Fire Resistance T C Type A field Numerical Max 5 characters this represents the fire resistance of the luminaire Superficial T C Type A field Numerical Max 5 characters this represents the maximum surface temperature of the glass of the luminaire Wind Exposed Surfaces Type A field Numerical Max 5 characters this represents the luminaire surfaces exposed to the wind useful for calculating mast dimensions generally for sports or roads installations Materials Type B field here it is possible to select one or more materials characterizing the product pesseneseessseessnsssenssessssensssssnsssssssensssnssensenses General Data Electrical Parameters lechanical Parameters photometric Parameters Norms and Marks Media Notes Luminaire IP Grade Fire Holding T Optical bos IP Grade Surface T Gear bos IP Grade Wind exposed surface jo IK Shock Resistant o Materials IT sl Dd Page 16
37. to confirm or Cancel to cancel Delete manufacturer To delete a manufacturer just gt select the manufacturer to be deleted from the dropdown list on the top right select the Delete manufacturer key confirm deletion Litepack OXL import OXC Import This function allows new products to be created in the database importing the data contained in the photometries in OXL format or just the luminaire technical data in the case of OXC and the photometries to then be linked to the new codes created To import the data just gt select the manufacturer where you want the data to go from the dropdown list on the top left select the Litepack OXL import key select the files to be imported to import more than one product press the SHIFT key plus the left mouse button on the first and last product and click on the Open key Rename added manufacturer Jr i Delete manufacturer NN aj wer d M f t ba 7 A ct Add manufacturer Confirm deletion Rename added manufacturer Delete manufacturer ccce Organizza Nuova cartella Asin Add manufactur Nome e Ultima modifica Tipo Dimensione Rename added manu aj 610 FLC1d8 oxl 04 06 2012 23 37 File OXL 12 KB 2 610 FLC1x24 ox 04 06 2012 23 37 File OXL 12 KB Delete manutact gt z 7 611 FLC148 oxl 04 06 2012 23 37 File OXL 12 KB 2 611 FLC1x24 oxl 04 06 2012 23 37 File OXL 12 KB 7 612 FLC1x1
38. to convert LDT IES files into OXL format to create new products automatically in the database by importing the data contained in the photometries and to link the photometries to the new codes To import data just p select the manufacturer where the data is to be inserted from the dropdown list on the top right select the LDT IES import key select the files to be imported to import more than one product press the SHIFT key plus the left mouse button on the first and last product and click on the Open key the program will automatically insert the codes in the database and link them to the photometries The new products can be visualized in Liswin or edited manually to add missing data manualmente in Lisdat Manual management LDT IES gt Litepack OXL conversion This allows you to convert the LDT IES data into OXL format To convert the data just gt select the manufacturer you want to appear in the OXL file data from the dropdown list on the top right select the LDT IES gt Litepack OXL conversion key select the files to be imported to import more than one product press the SHIFT key plus the left mouse button on the first and last product and click on the Open key The files will automatically be created in the Litepack folder relating to the select manufacturer Modify Litepack OXL D Dimensione Nuova cartella G ss LS se A Nome Ultima modifica Tipo 7 1296
39. type to be selected e g dimmerable electronic etc LED luminaire Type D field this indicates if the luminaire is classified as LED Source voltage Type A field Numerical this allows the luminaire source voltage to be inserted e g 230 Source current Type A field Numerical in the case of LED luminaires it allows the source current to be entered if the luminaire is not equipped with ballast Emergency Flag Type D field this indicates whether or not the luminaire is classified as an emergency device Battery Type A field Alohanumerical Max 20 characters this allows insertion of battery description Battery Life h Type A field Numerical Max 5 characters here it is possible to enter the life of the battery General Data Electrical Parameters Mechanical Parameters Photometric Parameters Norms and Marks Insulation Class WW e Balast Type LED luminaire IT Source voltage fo MI Source current ja mA Emergency Flag E Battery Vv Battery Life ja h Page 15 23 OxyTech To insert a new ballast just select the source from the dropdown menu and click on the button Creating the catalog Mechanical Parameters TAB In the Mechanical Parameters section it is possible to insert the following product characteristics gt Luminaire IP Grade Type A field Numerical Max 4 characters this indicates the general IP Grade when this is not divided into Op
40. ufacturer to rename a previously inserted manufacturer Delete manufacturer manufacturer Litepack OXL import to insert the data in the OXL files in the database and link them to the photometries OXC import to insert the OXC data in the database catalog data without photometries LDT IES import to convert the standard photometric formats into OXL insert in the database and link to the photometries LDT IES gt Litepack OXL conversion to convert standard photometric formats into OXL files DB Import to import export an external MDB database advised only for expert users Verify links to verify that links between the codes inserted in the database and the OXL files correspond Modify Litepack OXL with product data to substitute the OXL file codes with those in the database to which they are linked to delete a previously inserted MartineliLuceSp vl r Process ended Martine Luce Sp I D products succesfully converted C Clienti Oxytech Catalogo Martinelli Fotometrie1 907_FLIK_1X15W E27 R95 FL LDT converted Add manufacturer uccesfully C Clienti Oxytech Catalogo Martinelli Fotometrie 1 342_SET_1X24 W 2G11 FL LDT converted succesfully Rename added manufacturer Delete manufacturer Litepack 0XL import Importazione DC LDTAIES import DB Import Verify links Modify Litepack OL with product data Modify Litepack OL with lamp data Convert FDB gt Litepack Cl Backwards M
Download Pdf Manuals
Related Search