Nutrikids to IC

[Jenn Berry]

Goodmorning,

For Districts that have Nutrikids what process do you use for imports and exports in and out of IC?

Thanks

--

Jenn Berry

Database Specialist

Ellsworth School Department

(207) 669-9999

---

The information transmitted herein is intended only for the person or entity to which it is addressed and may contain confidential material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited.  If you received this in error, please contact the sender and delete the e-mail and any attachments from any computer.

[William Backman]

We have a query that runs on the hosted IC systems to generate the list of students.  A batch script reaches out and pulls the file down, and then we import it into Nutrikids.

The occasional new staff person gets entered by hand.

--
You received this message because you are subscribed to the Google Groups "MaineICUsersGroup" group.
To unsubscribe from this group and stop receiving emails from it, send an email to MaineICUsersGroup+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Will Backman
Director of Technology
Kennebec Valley Consolidated Schools - AOS92.org
Vassalboro - Waterville - Winslow

"The future is already here – it's just not evenly distributed.." –William Gibson

[Jenn Berry]

Thanks, we are doing that currently.  Our nutrition services Director wants to use NK as the main source of FRAM and wants the export out of NK into IC.  Do you do any exports out of NK and back into IC? 

[William Backman]

Yes, but not as often as we do from IC to NK.

[Sam Iggulden]

We have a daily process that creates a CSV export file (from IC), and that file is manually uploaded into NK every morning.  We know the upload could be automated, but our food service people like to be able to see what gets changed each day.

We use the FRAM module in IC for processing forms, so IC is the data "hub" for eligibility determinations.  

Many years ago we processed forms in NK and sent the eligibility status back to IC and found that caused more trouble than it was worth when it was time for state reporting.  But we've gotten better at automating exports now - plus we're not syncing directly with the State database anymore - so I guess using NK as the hub would be less of an issue, as long as the data flowed back to IC in an automated daily process (i.e. so that IC would be almost always accurate for the purpose of the Economic Disadvantage uploads to Synergy).

So the key here would be having a good process for achieving that sync.  One issue to be wary of, is to avoid changing eligibility start dates, because that might get IC out of sync with Synergy... I think Synergy identifies unique records using a composite of student stateID and start date, so if the start date changes, Synergy see it as a new record with a date overlap as opposed to an updated start date... which would more than likely cause a range overlap error on the Synergy upload.