Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Exporting and Importing Customer Contract Prices




Please ensure that you do not modify contract prices whilst exporting and importing the spreadsheet.






Run these processes on your Server!


Pages
Exporting Customer Contract Prices To An Excel Spreadsheet2-6
Importing Customer Contract Prices From Excel to Readysell7-9

Exporting Customer Contract Prices Into An Excel Spreadsheet
From the Readysell Main Menu

  1. Click on report <Report Wizard>


If you don't get the new report writer screen as pictured below, you would be on the old report window, click on <Report Wizard> (bottom right hand corner of the screen)

  1. New report writer



  1. Search for Type = 'Customer'


  1. Description = 'Contract Prices All Customers'


  1. Click on <Run Highlighted Report>



  1. <Close> query for all contract prices for all customers






  1. Report will display to screen


  1. Click on <Send To>


  1. Select Excel and Save it to folder D:\Rsello\ContractPrices.XLS (If this is the correct path for your Readysell. It may even be D:\READYSELL\RSELLO\Contract Prices.xls This is should be run on your server)



The process generates the report (you do not have to do anything with this screen)

  1. The Excel spreadsheet then opens. Commence EDITING ONLY THE DATA AND SAVE IT WITH THE SAME NAME.  DO NOT ADD, CHANGE OR DELETE ANY POSITIONS OR COLUMNS.  MAKE SURE YOU DO NOT CHANGE COLUMNS AT ALL.  ONLY CHANGE THE DATA


  1. Once you have made your data changes and <Save> the file as noted in point 9.



If you wanted to change start and end dates
Excel stuffs this up as it wants to save dates in its own internal date format.
You need to highlight, then format the start and end date columns as text to make Excel save them back in the correct format.
You could then change the dates and import them back.



Importing The Customer Contract Prices Excel Spreadsheet Back Into Readysell

  1. Go back to the Readysell Main Menu


  1. Select <Import> Module



  1. Highlight name 'Contact Prices All Customers' and  click on <Change>


  1. Check the Input File = 'Contractprices.XLS'


  1. Click on <GO>



  1. This process will read the rows and then update the data file.



  1. Check the import by checking couple of customers.


That is it.
Note :-

  • Some columns can't be changed,
  • Some columns can be changed as you like,
  • The date columns have to be formatted as text if you want to change them.


  • No labels