Prepare and Import the CSV file from the Mobile Apps to the Desktop

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 “System Admin’
2. ‘Mobile Data Administration’
3. ‘Import Data From Mobile Device’
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. ‘Get File’
7. Locate the Excel file you created (see above instructions – pay special attention to the FILENAME)
8. ‘Import’ – The box below the ‘import button’ will fill with data. The cursor will be on the LAST record, scroll up and verify your data is correct. If it is, ‘Update Records’, the system will import your records and update your master files.
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