Sessions from a scanner uploaded as CRV files like this

Put the cursor over the number 1, right click and select delete row

Put the cursor on any of the letters ( A,B,C etc ) at the top of a blank column ( before or between existing data but not after the last data column) right click and delete column

Put the cursor and highlight the column with dates in it and hit the delete button ( not delete column )

Now put the date in only in this order: Day month year Make sure the day and month have two digits ( eg 04 not 4) and the year has four digits  07/06/2022

Now copy and paste the date down the entire column

If the date isn’t showing in right format you need to highlight the cell. Then choose format top right, cell and set to the correct format plus none for time.

Use today’s date

In the next three columns in Capitals put JD, JDV and on

Now copy and paste so the entire columns are filled like this

Now under file select export to and CSV

Select next and then export it to documents or desktop

Database at nlis.com.au Sign in with Tas dairy systems email and Landers15!

Go to nlis

Hit log in

Now log into the database and select device status and go

Select I want to upload a file

Select choose file and then upload the CSV file you’ve just created Now press continue

Now send the file

If you are successful this screen will come up if not there will be red writing on it highlighting your problems