<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> <title>Tutorial / Entering data in your model </title> <link rel='stylesheet' href='../styles.css' type='text/css' /> <!--PageHeaderFmt--> </head> <body> <div id="container"> <div id="menubar"> <div id="logo" align="center"> <br/><img src='../frepple.bmp' alt="frepple" /><br/> <a href='http://www.frepple.com/'> <strong>a Free<br/>Production Planning<br/>Library</strong> </a></div> <div id="menu"> <br/> <h3><a href='../Main/HomePage.html'>Main</a></h3> <h3><a href='../UI/Main.html'>User Manual</a></h3> <h3><a href='Main.html'>Tutorial</a></h3> <h3><a href='../Frepple/Main.html'>Reference Manual</a></h3> <h3><a href='../Main/FAQ.html'>FAQ</a></h3> <h3><a href='../reference/index.html'>C++ API</a></h3> <br/><div> </div> </div> </div> <div id="content"> <br/> <!--PageText--> <div id='wikitext'> <p><a class='wikilink' href='../Main/HomePage.html'>Main</a> > <span class='wikitrail'><a class='wikilink' href='Main.html'>frePPLe Tutorial</a> > <a class='selflink' href='Step3.html'>Entering data in your model</a></span> </p> <p class='vspace'>There are multiple ways to enter data in the model.<br />Before entering any data this section describes each method. </p> <div class='vspace'></div><ol><li><strong>Enter the data in the form.</strong><br /> In an entity list you can click on object to edit it, or use the 'add' option to create a new object. The change form also allows to delete an object (and all other objects that reference it), and to review the history of edits. <div style='text-align: center;'> <img src='../uploads/Tutorial/changelist.png' alt='' title='' /></div> <div style='text-align: center;'> <img src='../uploads/Tutorial/changeform.png' alt='' title='' /></div> <div class='vspace'></div></li><li><strong>Upload data from a CSV-formatted file.</strong><br /> The 'export' option exports the report data into a CSV-format.<br /> The 'import' option reads in a file in this format.<br /> It is possible to export data in a spreadsheet, make all changes there, save the results as a CSV-file and finally reimport the data. <div style='text-align: center;'> <img src='../uploads/Tutorial/upload.png' alt='' title='' /></div> <div class='vspace'></div></li><li><strong>Data can also be directed loaded into the database.</strong><br /> For integration with other systems, direct access to the database is also possible. This bypasses the user interface altogether. <div class='vspace'></div></li><li><strong>Fixtures</strong> are a special case.<br /> A fixture is pre-defined, frozen dataset that can be loaded in a single step.<br /> This is very convenient to load test or training datasets in the database. <div style='text-align: center;'> <img src='../uploads/Tutorial/fixture.png' alt='' title='' /></div> When you load a fixture it adds new data or updates existing data in the database, WITHOUT erasing any existing data. Depending on the purpose of the fixture it may be required to erase the existing data before loading the fixture. </li></ol><div class='vspace'></div> </div> <!--PageFooterFmt--> <!--HTMLFooter--> </div></div> </body> </html>
