Hi,
I need the IANA port list in a new format:
Original:
[login to view URL]
Structure:
snagas 108/udp SNA Gateway Access Server
# Kevin Murphy <murphy&sevens.lkg.dec.com>
pop2 109/tcp Post Office Protocol - Version 2
pop2 109/udp Post Office Protocol - Version 2
# Joyce K. Reynolds <jkrey&isi.edu>
pop3 110/tcp Post Office Protocol - Version 3
pop3 110/udp Post Office Protocol - Version 3
# Marshall Rose <mrose&dbc.mtview.ca.us>
Protocolname Port/Type Comment
Desired new format: Two CSV files
First CSV file: [login to view URL]
Columns:
- ProtocolId (1,2,3,4,... starting at 5)
- ProfileId (always 'NULL')
- Protocolname (from list above)
- ProtocolTypeId (always 2)
Second CSV file: [login to view URL]
Columns:
- PortRangeId (1,2,3,4... starting at 10)
- ProtocolId (from other file)
- NetworkProtocol (either tcp or udp)
- PortRangeStart (number)
- PortRangeEnd (always 'NULL')
Example above:
1st file / [login to view URL]
...
5,'NULL','snagas',2
6,'NULL','pop2',2
7,'NULL','pop3',2
...
2nd file / [login to view URL]
...
10,5,'udp',108,'NULL'
11,6,'tcp',109,'NULL'
12,6,'udp',109,'NULL'
13,7,'tcp',110,'NULL'
15,7,'udp',110,'NULL'
Important for this job:
- Service provider can start immediately
- Service provider can provide valid invoice (with local tax number or vat code)
Payment through getAFreelancer escrow account.
Kind regards,
Sebastian