[sims] 'Dietary Needs' attribute ID/Interrogating the SIMS database to find field ID's

[Garacesh]

I have next to no knowledge of SQL and I have no idea how I'd even go about getting this information..

 

So we use Cunninghams iDstore and IMPACT for our cashless. Apparently since Cunninghams came in to do the upgrade, the tills no longer flag up pupil allergies any more.

From what I've gathered, by 'Pupil Allergies' they mean SIMS Dietary Needs section, and my 'flag up' they mean when the kid scans their fingerprint they get a popup that comes up with the information that they have to manually dismiss.

Through some testing, that popup only appears if there is information in the user's iDstore 'Comments' field, and it displays whatever is written there.

 

There's an INI file that appears to just be a list of attributes to copy across, with what I assume is the SIMS attribute on the left and the iDstore attribute on the right.

eg: FREEEXPIRYDATE=FREEMEALSDATE, PICTURE=PHOTO, PERSONID=ADMISSIONNUMBER, PERMANENTMESSAGE=COMMENT etc

Looking at this file INI file, it looks like that carries the COMMENTS attribute.

So what it looks like, is I just need to take out PERMANENTMESSAGE=COMMENT (I have no idea what field PERMANENTMESSAGE relates to, but everyone's Comment field is blank in iDstore so it's clearly not doing anything) and replace it with DIETARYREQUIREMENTS=COMMENT

 

And now we come full circle.

Does anybody know what this attribute is labelled as in the SIMS database, or how I would find out?

[bobsmith]

don't you map all this within their web interface?

[Garacesh]

I have absolutely no idea.

 

There's no web interface that I know of, certainly not one myself or the IT Manager have been shown, and the Kitchen staff don't know anything about iDstore as they only deal with IMPACT.

 

Going to give them a call today, I was just hoping it was an easy fix and someone could go "Oh yeah, easy, it's just $String".

[RobFuller]

Did you find a solution to this, looking to migrate to IDstore to automate this information flow from SIMS into Impact so would love to know it this works. Thanks

[Garacesh]

'fraid not