How to auto extract monochrome and color meter readings from a Xerox WorkCentre 7855 MultiFunctional Device via a batch job and dump into Excel 2010 Spreadsheet

I have to do meter reding each month and I would like to find a way to auto extract monochrome and color meter readings from a Xerox WorkCentre 7855 MultiFunctional Device via a batch job and dump into Excel 2010 Spreadsheet.

Does anyone know if this can be done?

Thank you,
CPChem1Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
hdhondtConnect With a Mentor Commented:
@DansDadUK
Of course, CentreWareWeb uses SNMP to get the info from the printers.
0
 
DansDadUKConnect With a Mentor Commented:
If there is a method, I'd imagine that it would involve using Simple Network Management Protocol (SNMP) requests.

Try to obtain a  Management Information Base (MIB) file pertinent to your device.
0
 
hdhondtConnect With a Mentor Commented:
DansDadUK's method will work, but it's not easy. I suppose you could also use something like AutoHotkey to create a macro that will get the information via your browser and the printer's web page.

A better way would be to use software like Xerox' CentreWareWeb to get the info for you. It will email you a CSV file at preset times - and can do lots of other things besides. It's a free download.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
DansDadUKConnect With a Mentor Commented:
I'd hazard a guess that the CentreWareWeb application uses SNMP to obtain information from each printer.

If it does the job, then there is no point in trying to do the lower-level work yourself.
0
 
CPChem1Connect With a Mentor Author Commented:
These are both great Ideas!!!!!!  Our machines are locked down, but I'll try to get CentreWareWeb.
In addtion, I'd like to know more about the Management Information Base (MIB) file. Is this easy to obtain and how would I do that?
0
 
DansDadUKConnect With a Mentor Commented:
Not sure whether or not Xerox publish any model-specific MIB files.

For general printer MIB data, read the RFCs: RFC 2790 and RFC 1759 v.2 would appear to be the relevant ones.

You could try to use snmpwalk to return all of the OIDs supported by the device, but without reference to a relevant MIB file, the output may be rather difficult to interpret.
0
 
hdhondtConnect With a Mentor Commented:
The "WorkCentre 7830/7835/7845/7855 Information Assurance Disclosure Paper" lists the supported MIBs in Appendix B.
0
 
CPChem1Author Commented:
Thank you both so much for the information! I should be able to investigate the information provided to come up with a solution. :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.