I'm reading a post about migrating to the new OPNsense rules, and I noticed that the downloaded CSV contains multiple rows but only a single column. I was expecting each rule to occupy a row with multiple columns (one for each field). Is this expected, or is there something wrong with the export? I tried a few times, but the export looks always the same...
Tia.
So you never worked with a csv-file... Open it in Excel, LibreOffice or something similar. It is separated by ;.
Yes, it is a strange thing that opening CSV files without the specific CSV dialogue in Excel shows each row as being one text column only. To fix this, you need to import the file properly. In the English version of Excel, use the following menu path: Data > From Text/CSV (located in the Get & Transform Data group)
Quote from: meyergru on July 19, 2026, 07:11:48 PMYes, it is a strange thing that opening CSV files without the specific CSV dialogue in Excel shows each row as being one text column only. To fix this, you need to import the file properly. In the English version of Excel, use the following menu path: Data > From Text/CSV (located in the Get & Transform Data group)
Yep, it worked, thanks.
Anyway, I don't think I need to modify anything in the file, so I can just export the rules and then import them according to the instructions, right?
Quote from: hushcoden on July 20, 2026, 07:10:29 PMAnyway, I don't think I need to modify anything in the file, so I can just export the rules and then import them according to the instructions, right?
Yup! :)
Decided today to migrate the rules, but if I click on Rules [new] that's already populated with floating rules and interface rules: does it mean OPNsense migrated the rules already?
I also noticed that a bunch of legacy rules were disabled and those were not migrated, but not a big deal.
So, can I simply now remove the legacy rules?
Tia.
Quote from: hushcoden on July 25, 2026, 11:40:18 AMDecided today to migrate the rules, but if I click on Rules [new] that's already populated with floating rules and interface rules: does it mean OPNsense migrated the rules already?
No. Thats just a preview with links to legacy rules. Just follow instructions in migration assistant and keep in mind that transition is not done until you delete your legacy rules. Once the migration assistant is gone from the menu, that means that transition is fully completed. Dont forget to migrate your NAT rules too.
Quote from: Nullman on July 25, 2026, 05:37:58 PMQuote from: hushcoden on July 25, 2026, 11:40:18 AMDecided today to migrate the rules, but if I click on Rules [new] that's already populated with floating rules and interface rules: does it mean OPNsense migrated the rules already?
No. Thats just a preview with links to legacy rules. Just follow instructions in migration assistant and keep in mind that transition is not done until you delete your legacy rules. Once the migration assistant is gone from the menu, that means that transition is fully completed. Dont forget to migrate your NAT rules too.
Good to know, thanks.