Instructions for Importing Chilson’s Feed Deliveries into AIM
SETUP INSTRUCTIONS
- In AIM, Navigate to System è Data Imports è Data Import Schedules
- Click Add New.
3. Select Feed Delivery Import from CMC
4. Key a code and description
5. Folders
- On your computer, create 2 folders, one for AIM to pick up files, and one to place processed files. Here is an example of how I do this on my computer (I am putting it on the desktop, but you can do this in “My Documents” or anywhere you wish:
- i. Right Click and click new, folder.
- I named my folder CMCFEED
- i. Right Click and click new, folder.
- 2. Then I open that folder, and create another one named “PROCESSED” within that CMCFEED folder (you can put it wherever you want, this is just what I do.)
b. Navigate Back to AIM and we will select these folders
- For the first “Source Folder”, click Find, Click Desktop, Click CMC Feed, Click OK
d. For the next, folder “Processed Files”, click Find, Click Desktop, Click CMCFEED, Click PROCESSED, Click OK
e. There is a checkbox “Overwrite duplicate records when a batch is run”. If you click this checkbox, you can reimport records over and over to collect updates and overwrite existing records.
- i. If you do not click this checkbox, then if you import records with duplicate values, you will have duplicate records in your feed delivery form.
f. Click the checkbox
g. Click Save
h. The data map tab tells you the records being imported
i. The import history will tell you details of imports and from here you can delete batches if they need to be reran.
PROCESSING INSTRUCTIONS
- Export data from Chilsons
- Place the export file into the “Source Folder” you created
- Open Data Imports
- Navigate to the CMCFEED import you created
- Click the gear on the top right hand corner of the screen (with a green arrow)
- Watch it process
- AIM will move the file from CMCFEED to the PROCESSED folder, and rename it by appending a date time stamp to the beginning of the file name.
- View your feed deliveries by selecting flocks and verifying the feed delivery is correct.
RECONCILING DATA
1. Go to the Import History Tab within your Feed Data Import after it has processed.
2. Here you can find if your data import has run successfully. It serves as a record of the batch showing errors or warnings associated with the import.
3. If you double click on a row, you will be able to view what type of errors you are receiving for your import.
4. You can then navigate the system to fix the errors you are getting.
5. The buttons on the side of this form:
View This Batch. View further information about a selected batch, such as imported records, updated records and errors.
Process This Batch. Roll-back and re-process the selected batch. If the file remains in the import directory.
Delete Selected Batch. Delete the selected batch and any imported records.
Remove Batch. Once you have confirmed a batch, you can remove it from the list to prevent it from ever being deleted or reprocessed.