Upload offers

How to upload daily offers to the IBS Intranet site?

a)First find the name of the company who has sent this offer.

b)Order the columns as :

A B C D E F G Excel spreadsheet column

Part#, Mfg, Price, D/C, Delivery, Qty, Vendor Part# or Comments

c)Save the excel file as .csv [click on file -> save as -> text (csv) ]

d)Important: Replace all comma by empty space (or nothing)

Search through the .cvs file and make sure there is no comma ‘,’ in the file, convert comma to space or dash, or remove comma. If you don’t do this the data uploads wrong. Make sure that there is no comma, in the quantity, vendor part name, or any where in the file.

-Make sure that the number 0,60 is converted to 0.60

-To do this you can select the column (not the whole spreadsheet)  Format  Cells  Number (Decimal Places = 0, and do not use 1000 separator)

e)Important: Open the .csv file in a text editor and make sure that there is no extra lines in the input file. This step is important as if you do not do this, many empty lines might get uploaded to the database.

f)Then search for the company in IBS Intranet site. First login to ( after you have successfully logged in type

g)When uploading the offers of a specific company, we need to know user name

h)Click on “Upload Offers” on the page. Click on the “see the list of users” to find the company name. If it is not listed here, you can add the company by clicking on the “Enter a New User”. Choose the company name or part of it as the user name for the company, and password is ALWAYS “test”. (you can choose another password, but it is easier if you only work with one password.)

i)In the ( URL, when it asks you to enter the user-id and Password, it is the company’s user-id and Password, which you can find from “see the list of users.

Password for all of them is test

j)Click on browse

k)Select the .csv file that you want to upload. If you want to overwrite the previous offers select “Yes” in the related drop down box. Click on “Here” to complete.

  • You have to complete the process. Don’t click “back” or leave the process because it will give you an error in the future if you upload for the same company.

l)You can search for the items that you have just uploaded in the System, by browsing to Login. Click on the “Offers”, on the left side of the page, and look for the item that you have just uploaded.

P:\techteam\network\procedures\Upload offers.docRev. 01/09/02