NoiseMap Forums

NoiseMap Software => Hints and Tips => Topic started by: roger on December 01, 2014, 06:52:45 PM

Title: Importing traffic flows from spreadsheet, can NoiseMap put in the flow IDs?
Post by: roger on December 01, 2014, 06:52:45 PM

Yes, the rules for importing traffic flows from a spreadsheet are:

• If the flow ID number matches a flow ID already in the database, the flow values in the spreadsheet replace the flow values in the database;
• If the flow ID number does not match a flow ID already in the database, the flow value in the spreadsheet is added to the database;
• If the flow ID number in the spreadsheet is zero, then NoiseMap creates a new flow ID and adds the value in the spreadsheet to the database.

Option 3 avoids you inadvertently replacing a value already in the database. NoiseMap does report the number of flows added and changed - it is a good idea to check this to ensure that the update option has worked as you expected.