Ok, so the documentation on automatically importing updated suppliers price lists into QuoteWerks is a little hard to understand. I needed a way to get Ingram Micro (Australian), Dicker Data and Leader computers automatically importing. The process took a little fine tuning, but i now have it.

The 1st step is to save the import templates for each supplier. Once they are working as they should be, I.E. press on it, click next lots, then you are ready to move on…

i have these 3 scripts

net use q: servershare

wget.exe

–no-check-certificate https://www.dickerdata.com.au/STK/stkfiles/datafeeds.mc “-OservershareQuoteWerksImport folderdatafeeds.csv”

 

Q:QuoteWerksqw4.exe /u:administrator /p:Password /i:”q:QuoteWerksDickerDate import.pit” /notify:”user“,1 /exit

——-

net use q: servershare

wget.exe

http://www.ingrammicro.com.au/pricelists/tld/pgstd.zip “-O172.27.72.105CommonQuoteWerksImport folderpgstd.zip”

net use q: servershare

q:
cd “Q:QuoteWerksImport folder”
WinRAR e pgstd.zip *.tld -o

Q:QuoteWerksqw4.exe /u:administrator /p:Password /i:”q:QuoteWerksingram micro.pit” /notify:”User“,1 /exit

 

——-

net use q: servershare

wget.exe

–no-check-certificate http://www4.leadersystems.com.au/Download/Download.aspx?ID=10001 “-OservershareQuoteWerksImport folderleader.xls“

del “Q:QuoteWerksImport folderleadercsv.csv“

convert-xls-csv.vbs “Q:QuoteWerksImport folderleader.xls” “Q:QuoteWerksImport folderleadercsv.csv“

Q:QuoteWerksqw4.exe /u:administrator /p:Password /i:q:QuoteWerksLeader.pit /notify:”User“,1 /exit

 

——–

There is also the convert XLS to CSV script

if WScript.Arguments.Count < 2 Then
    WScript.Echo “Error! Please specify the source path and the destination. Usage: XlsToCsv SourcePath.xls Destination.csv”
    Wscript.Quit
End If
Dim oExcel
Set oExcel = CreateObject(“Excel.Application”)
Dim oBook
Set oBook = oExcel.Workbooks.Open(Wscript.Arguments.Item(0))
oBook.SaveAs WScript.Arguments.Item(1), 6
oBook.Close False
oExcel.Quit

This script is needed by the Leader script as it downloads in an XLS format.

You also need to find a copy of WGET, i cant remember where i found it, but it wasnt too hard.

You also need WinRAR installed and working for the Ingram Micro script. This allows you to export the file from the ZIP

 

Save the each of the 3 into their own bat files, then make a task calling each of the three.

This will ONLY work when there is a user logged on and unlocked, so i have it running on the console of our terminal server, set that to Autologon, then run the importers 15 min after the weekly reboot. It works a treat

 

« »