Information

Home & General Information

MRPRO(TM) for Slavery and Trafficking Risk Templates Evaluation

Data stevedoring site

Installation instructions

Troubleshooting help

Online Help Desk

Other info

Product Purchase Links:Read terms of purchase and use

Purchase basic commercial license for login

MRPRO basic module for intelligent resources use

MRPRO- Basic non-subscription model expirable license

Social media broadcast, monitor, sync and download

MRPRO Save Money- module for energy analysis

Purchase a license for EMSPRO E3 Platform -Professional Specialized Version

Purchase a license for EMSPRO E3 Platform - Professional Full Version

Online Help Desk

Training/Tutorial Links:

Training videos

Papros Inc.

IN THIS PAGE - - Frequently Encountered Users' Calculation Enquiries for Conflict Minerals(FEUCE_cm) | Link to Frequently Encountered User Committed Errors

Status Updates in Using MRPRO-EICC-GeSi-RMI Conflict Minerals Dashboard

Recommended stable version-(this page last reviewed and contents current as of 28 Novm 2022 GMT 00:00 hrs); License also renewed here. Always clear browser history when viewing this page to get the latest page (not one stored in your cache)

The install program was updated for extended support, and ZIP filename (and link) has changed. The new link is given below and this link will be maintained till further change is posted in order to maintain continuity, so THE ZIP FILENAME ITSELF WILL GENERALLY BE SAME, the program files within will always have been updated and will have later dates

Simple version, simple installation- No need for registration of dll (dynamic link library). Click this link for Site for Zip file location for download

Alternate link

The password for extracting files from the zip is 1234eicc. If you downloaded before last site review and update date posted above you should update. The rollup strictly enforces the relationship between smelter ids and names by checking the dropdown values, and so if those are not properly picked but randomly entered, there will be a program crash. Fix this thus, use smelter id and by choosing the dropdown correctly, before calling for help

For rollups of previous/pre-Dated version of templates use the landing page got by clicking on this link on this line

Read the readme text (link given below) for system requirements for proper functionality of all features.

The big news that makes life easy for all users of the CMRT and EMRT is that the XML used in the internal MRPRO(tm) computational engine (if using xml) is now the same as IPC 1755 as both have changed and converged to a new standard. This means users can just exchange the XML output of a CMRT and thus increase efficiency in exchanging quality data that can be easily rolled up or searched. ALWAYS issue guidelines for submitters to VIEW the XML to ascertain it is correct before sending.

Link to Videos available for training and to to demonstrate usage of important functions:

http://www.papros.com/training_cm3.htm
If the cell links in the excel file each time a file is opened are slowing your excel rollup, convert files to the built-in XML and do rollups using XML-its much faster. The conversion to XML can take some time, as every character is checked, but this process runs in the background, and error files are dumped into a bin. THE XML is an IPC standard now, so you can even request those files directly from your suppliers. They can just fill the CMRT and convert at their end as all users are allowed XML conversion. This will make the process much easier-take note.

Ensure Excel Trust center settings allow the C:\mrp51 folder and subfolders before asking for help

Logs of recent updates and features/fixes

28 Novm 2022- Minor update for PRT related features

25 Novm 2022- Updated for Pilot Reporting Template (PRT 1.0- only XML conversion and rollups enabled for pilot reporting template testing)

4 Novm 2022- Updated for EMRT 1.11

17 Oct 2022- Updated for EMRT 1.1 and new Conformant Smelter list

12 May 2022- Updated for CMRT 6.22 and new Conformant Smelter list (the previous zip is also available, for link, scroll down below on this page)

25 March 2022- Minor run-time optimization, lesser pop-ups when doing XML conversion

5 Feb 2021- Update to do Excel rollups even when a CMRT smelter ID input is wrong (previously this stopped/prevented the rest of the rollup-now a fix has been added, this slows the rollup a bit). http://www.papros.com/Choose_CMRT_CRT_mode.pdf

Remember to set Trust Center in Excel for c:\mrp51 and all its subfolders as trusted folders, after creating the folder c:\mrp51
Simplified Method 1 Installation/Updating instructions-

Click here/link for new installation or updating existing installation, good for this version also

Alternate Method 2 Simplified Installation/Updating instructions

Click here/link for "alternate installation method" for new installation or updating existing installation, good for this version also

Click here/link for readme text-operating instructions

Follow the instructions bringing in summaries of the Declarations sheet answers to masterlist, and you can obtain pie charts as shown in the training videos. If the questions are those to which the summary has answers to all questions in one cell, copy that entire column alone to Notepad, save as something.csv and close. Then open something.csv using Excel, with commas as dlimiters, and you will have individual columns you can apply the floating pie chart to and get all statistics.

Notes

Old version support and old zip file is available to support users who still need that: (To switch between versions, there is no need to re-install. Just exit the program and Excel, then extract the contents of the zipfile you need to c:\mrp51 ensuring overwite of old files, then launch). Hint: If you are doing rollups with old versions of CMRTs, do the rollups using the old zip as appropriate, then convert the old CMRT to a new one, then load the files from the new zip folder to migrate forward. This helps in checking against compliant smelters and the new zip contains more optimized algorithms in checking versus the latest RMI smelter lists.

Click here for Link to the old zip folder archives

For speed, performance and near-guarantee of completion in supplier templates' rollups and smelter searches among supplier files, best to use XML rollup feature.
Click here/link for Pros and Cons of each approach .
Click here for Link to easy step by step instructions for XML creation, rollups and searches
Click here to see User feedback on XML approach-See User feedback regarding speed and use of the XML approach..


Convert all supplier templates to XML using the output multiple xml files feature after loading you supplier file paths in Sheet AF and then run the Addin. (The program will run to fruition, but conversions may take long as each character is examined for the file to be standards compliant- but the program can run in the background-bad filenames are dumped into an error bin, and only good files are converted. Because the XML is standards based, you can request the supplier to send a standard XML file using this program also, OR instead convert yourself.) Correct all error supply files or get them out of the list to be redone and added later. Do the rollup after all supplier files have been corrected and added to the list. (Note-the xml rollup is keyed of the smelterIDInput field, so ensure your templates have an entry for this field-if its blank copy the smelterID here to that field)

While doing the XML search or rollup, the filenames and paths should be in Sheet AF. If the files are on the desktop, the files must be in a folder within the C:\mrp51 folder. If on the web, the complete path including http:// must be entered.

For files on the desktop, the program automatically sanitizes the path from the current directory (C:\mrp51), by removing the the C:\mrp51 and converting all \ to /, appropraite for web web computation. If your xml search or rollup does not work, check if your path starting C:\mrp51\ is removed by the program. In some cases if your administrator has a used a non-ASCII ":" in the C:\mrp51 it may not remove this string, then you will need to manually set the path. To do this, copy all the filenames and paths to a blank sheet, then do a find and replace of all "C:\mrp51\", then paste in Sheet AF. There all \ will be converted to / automatically. Thus, finally, if your full filename and path is C:\mrp51\folder1\example1.xml the path that the program needs to see to run properly is folder1/example1.xml
In certain laptop installations of Firefox browser, users may have to type in "about:config" in the browser window, and disable the "security.file.origin_strict_policy" for the XML files to be opened in desktop/laptop.

Rollup of Excel based files (only .xlsx type files allowed for CMRT now, if you have .xlsm or .xlsb- open them and save them as .xlsx files Always check your all templates for these basics and for also being the proper version before using including them in a rollup, this will save you time in the overall process) and check smelter names in outbound templates- The latest conflict minerals template allows a little more than about 2000 rows. So if you have more, you will get an error. The key is to get the Smelter names correct, then you will never run over the limit. The best thing is to run the "Check Smelter names" in the Addins (after first selecting the current template first to make it active workbook). Always select the current workbook by clicking once before clicking an Addin button. This check smelter names feature works only with version 3.00 and higher templates. Read the readme7.txt for more on this feature.

Duplicate smelter name removal
During the rollup program removes duplicate smelter names if they are for the same metal by comparing against smelter names in first file, subsequent same smelter names for same metal in subsequent supplier files are not duplicated. In the latest version, to conform to writeout requirements, all smelter fields of two rows must be equal to be considered a duplicate.

Recommended smelter fields error correction procedure
After the rollup process, if smelter names are found mismatching, the best method is trace the suppliers with bad names or fields in their smelter list using the search procedures, and have them correct them. For users' own smelter lists, the recommended correction from an partially incorrect CMRT, is as follows, open a second new CMRT, do a manual pick of the new corrected smelters after checking, ensuring the smelter fields, then take that CMRT and roll it up with the earlier CMRT, and remove the incorrect duplicates in the resulting rollup. If proper smelters are picked from the bottom supplier on, there will be no such errors.

Web/XML database search
For best results, if you cannot configure your browser, for local XML files on desktop use Mozilla Firefox as your default browser, and for web file locations use Internet Explorer as your default browser(when IE asks for permission to allow blocked content, give permission)

Advise on Error 13, type mismatch, due to Language and Regional setting in Excel other than English:

If you get the above error due to your setting in Excel, it has something to do with the following type of issue (although the exact issue is different).

Possible reason(click this)

If you can find the setting that causes this, set it in your default setting to prevent this error. An alternate recommended solution is to run on a machine with Language setting English. This has to do with version defaults in Excel and nothing to do with preference of one international language over another.

Advise on Rollup process stop or Conversion to XML stop:

"Method-Activate_Object of Notebook Failed" (Runtime error-2147221080) OR Error 91--The likely source of your error is that there is a problem with one of the files you are trying to rollup. Look at all the files that are open when the program stops. If a supplier file is open, it is the likely cause and is an incorrect file. The other possibility is that one of your supplier files is not even opening properly. A good visual clue has been added to identify faulty supplier files by stopping during each step (this minor feature added 3/14/2013) of the process to show the file being used in Sheet AF. In general, make sure all your supplier files are openable by Excel. If the program stop is on the first line of Sheet AF and there is no problem with file 1, the only other possibility is that in some Microsoft Windows systems, the EICC-GeSi template can be opened only with a pop-up happening. In those cases, when doing a rollup/multifile conversion, the same error message may show up. In these cases, try and open the file eicckp3A3A.xlsx (for CMRT 5.10 and higher) manually. If a pop-up happens, just save the file by using the same name. If the pop-up is the cause, after this, the pop-up will not happen when opening the file, and so the error will not happen again. If there is no pop-up, dont save the file.
Also if you start getting more than 2500 smelters, better convert your files to the built-iin EICC-GeSi xml format and do the rollups, as even CMRT has limitations over 3000 smelters and rollup templates could hang up on that.
In addition, always ensure your suppliers do not start a cell entry with "#" or a link, as these could jeopardize reading files.
XML Rollup- If all your XML files are ok and you are using Firefox as the browser and not getting a rollup even if the data is ok, then open Firefox, type in about:config in the window and scroll to security.fileuri.strict_origin_policy and ensure it is set to false.
Lastly, but importantly, check that all CMRTs are saved as .xlsx (not .xls -remember only .xlsx is allowed from 5.10 and higher, or in some cases, due to user errors as ".xlsx.xlsx" twice-this can be seen in Sheet AF when the files names are loaded. If such is the case correct both the actual filename and also the corresponding entry in Sheet AF. For further troubleshooting see also Frequently Encountered User Committed Errors

NEXT Short messaging for Supply Chain Information Tracking

IN THIS PAGE- - Frequently Encountered Users Calculation Enquiries for Conflict Minerals(FEUCE_cm) | Link to Frequently Encountered User Committed Errors

To send feedback or to contact, please contact us

Copyright 1994-2018 Papros Inc. All rights reserved.