Using Export to Disc

There are times when a report can only be generated on the screen or sent as an email but you might like to have the information in an excel format.  Using Export to Disk will export the data in a raw format to then be dealt with.

Step 1: Choose Output to Screen and generate the report.

Step 2: Select Export Disk to make text file.  

When the report has been generated, click on the Export to Disk icon.

Step 3:  Save the file.

Step 4.  Open the Text File you have just saved.

i.  Select All the data by holding down Ctrl+A.

ii.  Copy all the data  Ctrl+C.

Step 5.  Open a blank worksheet in excel.

i.  With a blank worksheet open, use the down arrow to paste the text file using the Text Import Wizard.

ii.  Select Fixed Width.

iii. Tick My data has headers if you have headings you want to keep.

iv.  Check the data is segregated correctly in the columns.

v.  Insert the columns right before the letter of each heading if any are missing.  You can slide them around to fit as close as possible to the text.

vi.  Click on Next, check the data again, and then Finish.

You might need to fix things up a little bit in the worksheet but in general the data should be pasted into the excel sheet to reorder or use as needed.

• Related Articles

• Overview of Livestock Reports

  Stages in Livestock Reporting Overview of Livestock Reports Preparing Emails for Distribution Generating Livestock Reports (View/Send/Print) Introduction This guide equips you with the knowledge to navigate Stockyard's livestock reporting system ...

• Adding Reports for Ways

  Go into the Purchaser record in the Address Book Click on the email address under Reports to open the Scheduled Reports window. Right click on the specific report you want to send for that way and Add a Way eg Purchaser Way It will duplicate the ...

• Using Scheduled Reports

  One of the quickest ways to send off reports once a sale is complete is to use the Scheduled Reports option for Vendors, Purchasers and Agents. With the click on just a couple of parameters all like reports will be sent to their various destinations ...

• Using a Stockyard Remote System

  It is possible to attend sales off-site/out of internet coverage using Stockyard to record the sale and print out reports. This requires a special setup and separate installation. Once the Remote System is installed on the laptop, printers and other ...

• Weighing Using the Lot Interface

  CALIBRATION OF SCALES Before a sale starts, ensure you have calibrated the scales so you can verify that the weights taken are accurate (from the Scale Indicator to the PC) : Roll on your approved weight (e.g. 50kgs of weights) Ensure all gates to ...