unfi.py

#!/usr/env python

from subprocess import call
import datetime
import os

import xlrd
import csv

def csv_from_excel():

   wb = xlrd.open_workbook('temp.xls')
   sh = wb.sheet_by_index(0)
   your_csv_file = open('catalog-extra-info.csv', 'wb')
   wr = csv.writer(your_csv_file, quoting=csv.QUOTE_ALL)

   for rownum in xrange(sh.nrows):
       wr.writerow(sh.row_values(rownum))

   your_csv_file.close()


#curl https://legacy.unfi.com/uploadedFiles/UNFI_ER/09_FullListingBYCSeptember.xls -o temp.xls

today = datetime.date.today()
monthnum = today.strftime("%m")
monthwords = today.strftime("%B")
yearnum = today.strftime("%Y")


filename = "https://legacy.unfi.com/uploadedFiles/UNFI_ER/"+monthnum+"_FullListingBYC"+monthwords+yearnum+".xls"

call(["curl", filename,"-o","temp.xls"])

if os.path.getsize("temp.xls") > 10000:
  csv_from_excel()