Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import csv
- ipAddressSpreadsheet = open('G:\\Downloads\\list_of_sites.csv')
- spreadsheetReader = csv.reader(ipAddressSpreadsheet)
- spreadsheetData = list(spreadsheetReader)
- with open('G:\\Downloads\\results.txt','w') as file1:
- restaurant_dict = {}
- for item in range(len(spreadsheetData)):
- add = spreadsheetData[item][0]
- name = spreadsheetData[item][1].replace(" ","")
- if name in restaurant_dict.keys():
- restaurant_dict[name].append(add)
- else:
- restaurant_dict[name] = [add]
- for name,add_list in restaurant_dict.items():
- for x in range(len(add_list)):
- file1.write('set security address-book global address RESTAURANTS_{name}_{iteration} {add}\n'.format(name=name, iteration=x, add=add_list[x]))
- file1.write('set security address-book global address-set Customer_{name} address RESTAURANTS_{name}_{iteration}\n'.format(name=name, iteration=x))
- print('All done!')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement