--- title: "EPC Using NBSG (Natbuild) Format" canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31100168/EPC%20Using%20NBSG%20(Natbuild)%20Format" format: markdown --- This page steps through the required format that Electronic Price Catalogues (EPC) from Suppliers needs to be put in for import into ProStix. Template When importing the EPC into Prostix the data needs to be in the correct position. To determine where the correct position for the data is a template file called NBSG_nett.xls has been created. This template file identifies what information is required in each column of the EPC. One method of creating the EPC file would be to copy data from the supplier price list and paste into this template. When finished copying and pasting the relevant data the file then needs to be saved as a .csv rather than a .xls (as .xls files has special characters associated with formatting that cause imports to fall over). Fields The template mentioned above has a total of 20 fields that can be populated and imported into Prostix. Not all of these fields are mandatory. The table below highlights which fields are mandatory and which are not. The table also indicates what position / column on the .csv import file that data needs to appear under. Also listed in the table are maximum number of characters allowed for each field. It is important to ensure that data entered does not exceed the maximum number of characters allowed otherwise the updating of stock file will fail. File Import Once the EPC file has been modified / manipulated so that data is in correct position the saved csv file needs to be moved from the Windows PC to the Unix server that hosts Prostix (either using batch process supplied by the Sterland Product Manager or a GUI FTP Program like ws_ftp). The file needs to be saved to the /Prostix/dmp directory. 1. From the ProStix Main Menu select ' Electronic Trade Module ' then ' Supplier Interface ' then ' EPC File Import' . A screen as per capture below appears: 2. Once these filters have been filled in press to start the import. When the import has finished a message appears: Your Import has completed . 3. Once the file import has successfully finished the result can be spot checked by the ProStix Main Menu select ' Electronic Trade Module ' then ' Supplier Interface ' then 'EPC Enquiry' .