How To Prepare and Import the CSV File created by the Mobile App To Today’s Rancher Desktop
After you have created and saved the spreadsheet on your mobile device and transferred it to your desktop computer
1. Start Excel
2. Open a ‘New’ Blank Worksheet – Click inside Row 1 Column A
3. Go To Data
4. Click on ‘From Text’
5. A window ‘Import Text File’ will show
6. Select the file (see list below for possible names) you might have to browse to find it
7. Click ‘import’
8. Make sure the ‘Delimited’ button is selected
9. Make sure ‘start import at row:’ is changed to 2
10. Click Next
11. Under ‘Delimiters’ the “Tab” box should be checked
12. Text qualifier should by ”
13. Click Next
14. The ‘General’ button is highlighted and the first column should be highlighted, click on the ‘text’ button
15. You’ll see the column header change to ‘Text’ from ‘General’
16. Do this for each of the columns
17. Once all the columns are labeled ‘text’ click ‘finish’
18. Make sure ‘existing worksheet is selected on the popup that will appear
19. Click ‘OK’
20. After clicking OK you should have a new Worksheet fill in with values only – no header record
21. Click the File tab
22. Click “Save As”
23. Select the folder where you want to save the data
24. Select ‘Save As Type” “Microsoft Excel 5.0/95 Workbook”
25. Use The filename (see list below for possible names)
CSV Filenames From Mobile
Cattle
Master Animal List (output file name = cattle.csv)
Medical (output file name = cattle_medical.csv)
Notes (output file name = cattle_notes.csv)
Weight Changes (output file name = cattle_weights.csv)
Births (output file name = cattle_births.csv)
Location Changes (output file name = cattle_movement.csv)
Sales (output file name = cattle_sales.csv)
Feedings (output file name = cattle_feedings.csv)
Goats
Master Animal List (output file name = goats.csv)
Medical (output file name = goat_medical.csv)
Notes (output file name = goat_notes.csv)
Weight Changes (output file name = goat_weights.csv)
Births (output file name = goats_birth.csv)
Location Changes (output file name = goat_movement.csv)
Sales (output file name = goat_sales.csv)
Feedings (output file name = goat_feedings.csv)
Sheep
Master Animal List (output file name = sheep.csv)
Medical (output file name = sheep_medical.csv)
Notes (output file name = sheep_notes.csv)
Weight Changes (output file name = sheep_weights.csv)
Births (output file name = sheep_births.csv)
Location Changes (output file name = sheep_movement.csv)
Sales (output file name = sheep_sales.csv)
Feedings (output file name = sheep_feedings.csv)
XLS Filenames To Create for Import
Cattle
Master Animal List (output file name = cattle.xls)
Medical (output file name = cattle_medical.xls)
Notes (output file name = cattle_notes.xls)
Weight Changes (output file name = cattle_weights.xls)
Births (output file name = cattle_births.xls)
Location Changes (output file name = cattle_movement.xls)
Sales (output file name = cattle_sales.xls)
Feedings (output file name = cattle_feedings.xls)
Goats
Master Animal List (output file name = goats.xls)
Medical (output file name = goat_medical.xls)
Notes (output file name = goat_notes.xls)
Weight Changes (output file name = goat_weights.xls)
Births (output file name = goats_birth.xls)
Location Changes (output file name = goat_movement.xls)
Sales (output file name = goat_sales.xls)
Feedings (output file name = goat_feedings.xls)
Sheep
Master Animal List (output file name = sheep.xls)
Medical (output file name = sheep_medical.xls)
Notes (output file name = sheep_notes.xls)
Weight Changes (output file name = sheep_weights.xls)
Births (output file name = sheep_births.xls)
Location Changes (output file name = sheep_movement.xls)
Sales (output file name = sheep_sales.xls)
Feedings (output file name = sheep_feedings.xls)
XLS Spreadsheet Structure
Master Record
Animal Id (Name)
Animal EarTag
Animal Type
Animal Status (Single Character “A”=Active, “S”=Sold, “F”=For Sale, “I”=Inactive
location
Current Weight
Dam
sire
Date Of Birth,
Sex
Medical
Animal Id (Name)
Date Treated
Treatment
Weights
Animal Id (Name)
Date Recorded
Old Weight
New Weight
Births
Animal Id (Name)
EarTag
Dam
Sire
Date of Birth
Birth Weight
Animal Type
Ease Of Birth
Assisted By
Notes
Animal Id (Name)
Date of Note
Note Text
Movement
Animal Id (Name)
Date Recorded
Old Location
New Location
Sales
Animal Id (Name)
Date Sold
Total Sales Price
Sold To
Sold Where
Feedings
Animal Id (Name)
When Fed
Where Fed
What Fed
How Much Fed
Feed Cost
Quantity Type
To Import The Newly Created XLS File into the Desktop1. On the main menu
2.
3.
4. Select the appropriate Animal Group (Cattle, Goats, Sheep)
5. Select the appropriate File Type (Animals – this is the master listing, Medical, Weight, Births, Notes, Movement, Sales, Feeding)
6.
7. Locate the Excel file you created (see above instructions – pay special attention to the FILENAME)
8.
XLS Spreadsheet Structures
Master Record
Animal Id (Name)
Animal EarTag
Animal Type
Animal Status (Single Character “A”=Active, “S”=Sold, “F”=For Sale, “I”=Inactive
location
Current Weight
Dam
sire
Date Of Birth,
Sex
Medical
Animal Id (Name)
Date Treated
Treatment
Weights
Animal Id (Name)
Date Recorded
Old Weight
New Weight
Births
Animal Id (Name)
EarTag
Dam
Sire
Date of Birth
Birth Weight
Animal Type
Ease Of Birth
Assisted By
Notes
Animal Id (Name)
Date of Note
Note Text
Movement
Animal Id (Name)
Date Recorded
Old Location
New Location
Sales
Animal Id (Name)
Date Sold
Total Sales Price
Sold To
Sold Where
Feedings
Animal Id (Name)
When Fed
Where Fed
What Fed
How Much Fed
Feed Cost
Quantity Type
Troubleshooting
The most frequent issue is ‘file not found’ 1. Make sure your filenames are exactly as above the system is case sensitive and also that your device is disconnected from the desktop