Where to find staging tables and your data

Missing records?

I explained a while back about how information collected on the ABCgrower mobile App is passed through staging tables when it is uploaded to the website.  The records are checked for errors before they are passed to the relevant data tables.  If any records are in error the uploaded batch is held in the staging table.  Examples include double scanning of a unique bin number and scanning a worker who has been marked inactive. 

What’s new?


We’ve moved the staging tables out of the various menus into their own Mobile App menu.  The staging tables you can see depends on the modules your organisation uses and your user permissions.

The red notification icon shows when there are records being held in error, with the number on the notification telling you how many records there are.

What do I do with them?

Records are automatically processed every few minutes.  It’s possible for records to be in the staging tables but not in error if they’ve just been uploaded but not yet processed.  In this case you can click [Re-process] to push them through if you like.

If there are records in error there will be a message to tell you what’s wrong.  You can delete a record by clicking the adjacent rubbish bin icon.  Then you can click [Re-process] to push any remaining records through (or wait for them to auto-process).  Remember to re-enter the corrected record via the the appropriate page (e.g. Activity > Worker Activity) if necessary.

How to control the default ‘work date from’ date – updated!

Dating Tips – Part 2

Work Date From’ is a common filter in ABCgrower, like in Worker Activity Search for example.  It’s set to 3 months by default, but you have control over this.

Sound familiar? I talked about this a while back. Well, now it’s a whole lot better.  Not only can you set a default for your organisation, you can set different defaults for individual users.  For example, a manager who frequently runs daily reports may set the number of months to zero, and a spray operator who looks at the seasons data may set the number of months to three.

Set user default

Go to Settings > Users > click the User name link and select a value from the dropdown list in Work Date Default.  To set the default to the current date choose zero.  To keep using the default value set for the organisation leave the field blank.

Set organisation default

Go to Settings > Control and change the setting in Work Date Default.  To set the default to the current date select zero.  This will apply to any users without a value set on their user profile.