使用Ansible从csv在Netbox中创建站点

Question

我正在尝试基于CSV文件在Netbox中创建站点。因为我要在站点名中添加一个ID，所以当没有为站点指定ID时，我不希望创建该站点。在这种情况下，CHI和STO将被创建，但BER不会。

我试着把

when: {{ item.ID }} not ''

在循环之前和之后，在第二个任务中，但没有成功。

CSV：

sitename,ID,location
CHI,101,Chicago
BER,,Berlin
STO,103,Stockholm

剧本：

tasks:
  - name: "read sites from csv"
    community.general.read_csv:
      path: sites.csv
      delimiter: ','
    register: sitelist
    delegate_to: localhost

  - name: "create/update sites in netbox"
    netbox.netbox.netbox_site:
      netbox_url: https://url
      netbox_token: token
      data:
        name: "{{ item.sitename }}-{{ item.ID}}"
        physical_address: "{{ item.location }}"
    loop: "{{ sitelist.list }}"

Answer 1

你必须像这样写你的测试：

  tasks:
  - name: "read sites from csv"
    community.general.read_csv:
      path: sites.csv
      delimiter: ','
    register: sitelist
    delegate_to: localhost

  - debug:
      msg: "name: {{ item.sitename }}-{{ item.ID}}, physical_address: {{ item.location }}"
    loop: "{{ sitelist.list }}"
    when: item.ID != ''

结果：

ok: [localhost] => (item={'sitename': 'CHI', 'ID': '101', 'location': 'Chicago'}) => {
    "msg": "name: CHI-101, physical_address: Chicago"
}
skipping: [localhost] => (item={'sitename': 'BER', 'ID': '', 'location': 'Berlin'}) 
ok: [localhost] => (item={'sitename': 'STO', 'ID': '103', 'location': 'Stockholm'}) => {
    "msg": "name: STO-103, physical_address: Stockholm"
}