Import customer from external file

The format for the import of customer data is described in the manual section entitled Consumption data. One very easy way in which you can create a template for import is to create a “sample customer” in NetSim and then export this customer to a text file!

·      Open a model in NetSim. There must be at least one node in the model!

·      Go to the Customer tab.

·      In the right-click menu, select Create new

·      Now enter values in the fields which you can easily recognised in the exported customer data file.

·      In the menu, select File -> Customer data -> Export of customer data. Open the exported file in Notes, select the row and paste the row into Excel.

ANLID¤KUNDID¤KUNDNAMN¤FASTIGHETSBETECKNING¤ADRESS¤N766¤N766¤N766¤1¤16¤1¤31¤2300¤2012¤100¤1¤230¤0¤4497¤0¤45¤50¤0¤0¤¤¤¤¤¤

The file looks like the one above (wrapped). If you want to include notification information, this is added between the last four field separators.

·      Column-separate the file in Excel, the ¤ character is the separator.

·      Now create new rows in the Excel file for your customers. Use your sample customer as a template. When you have finished, delete the sample customer, then set national settings use the ¤ character as a column separator. Note that numerical values must be integers with no decimal places. Save the spreadsheet in CSV format.

·      Import the file by selecting the menu File-> Customer data-> Import all

·      Your customers are loaded!