Supplier data record in adequate media type

radame

Starting to get Involved
#1
Hello

One of our suppliers generate electronic data (txt files) from their CMM.

Those measurements are related CC (Critical Characteristics) in a daily basis.

This is an automotive supplier (TS based) however my company evaluate them also with VDA

They are storing all the data in the stand alone PC connected to the CMM, we recently had an issue with the supplier as we require to them all the data to evaluate if all measurements are OK or not, due a claim from our customer.

Now the supplier states they need 3 weeks to process all the TXT files to their statistic software to provide the analysis.

We are not agree on this data management as:

- This will take too much time to process the data, we need to provide also to our customer

- To keep all data in a stand alone PC without any electronic backup or being connected to a server is not reliable as this PC can be damaged.

This information must be keep all part life and 15 years after part end of life.

We know electronic media is allowed by TS16949, but there is no details on how or in which conditions this must be defined, handled, etc.

Is there any standard or norm that indicate some specific conditions to be in place for the storage of data in electronic media??

Such as mandatory back up of information or anything else.....

Any feedback will be welcome and appreciated.
Thanks
 
Elsmar Forum Sponsor

Project Man

Involved In Discussions
#2
The primary requirements come from the customer and secondarily any standards. Do you currently document supplier requirements? This should be the foundation and sounds like it either needs to be revised and/or adhered to. If there are customer requirements above and beyond that, you need to flow that down to your suppliers.
You need to be clear about what you require from your suppliers.
 

Coury Ferguson

Moderator here to help
Trusted Information Resource
#3
I agree with Project Man. You need to flow down your requirements to your supplier, just as your customer flows downs their's to you.

What your organization needs, may exceed your customer's requirements or visa versa. This will need to be clearly stated in any Purchase Orders (Legal/Binding Document) you place with the Supplier and others.

You may want your purchasing group if you have one, or yourself if you don't, to contact the supplier and see if they can reduce the lead time on the data. If they agree, then modify the Purchase Order with an amendment to specify the time agree upon.

Just my opinion.
 

Miner

Forum Moderator
Staff member
Admin
#4
I've been out of automotive for some time, but the base ISO requirement states: "Records shall remain legible, readily identifiable and retrievable."
Since there is no comma after identifiable, the word readily applies equally to retrievable (i.e., Records shall remain ... readily... retrievable.).

Webster defines readily as quickly and easily, or without much difficulty.

Given that, a few days would be reasonable, but not 3 weeks. Your comments about data backup are also completely correct.
 

radame

Starting to get Involved
#5
Thank you so much for your feedback, my question is more related to the media supplier is using to store all the information.

We would prefer supplier uses a server or other media where there is a back up to assure they will not loose any data.

If I understood well your comments, this must be agreed or defined in a document (contract, etc.), otherwise they are not obligated to implement something else, am I right?

Automotive norms (and other customer specific requests) state that some specific information must be available and stored due legal or liability topics in case a problem occur to assign the responsibility to the right entity.

Then I would like to know if there is something (norm, etc) which indicate such electronic media must fulfill some conditions to assure data integrity.

Something like a contingency plan or something else.


Thanks
 

Miner

Forum Moderator
Staff member
Admin
#6
This gets back to the requirement that records must remain legible. This applies to electronic media. Given that hard drives can fail with distressing regularity, it is common practice in all sectors to routinely back up electronic media on a daily basis. Even servers are backed up at regular intervals.

This supplier cannot justify the failure to back this computer up.
 

radame

Starting to get Involved
#7
Given that, a few days would be reasonable, but not 3 weeks. Your comments about data backup are also completely correct.
This is exactly my concern, they are using an stand alone PC (not connected to any network) to store all the historical information.

They will loose all data if this computer breaks down and this information is very important.

I remember, for example, IT guys in the company must have a back up for all company data to avoid data loose and there are some rules based on international standards indicating how the data management must be to avoid this.

Indeed TS indicate what you mention but there is certain ambiguity on how data must be managed, either hard copy or electronically

And such detail for sure is not indicated in a contract or PPAP.
 
#8
It is really a simple matter to back up the data on a flashdrive, although in this case it would have to be done manually, ideally by rotating a few different flashdrives. If it is bluetooth or wifi capable it could also sync its files automatically with another computer (even yours). There is no economic excuse not to be able to maintain a backup. As for retrieving information in a text file format, this should not be that difficult either, as the text output could be run through filters to make searches.
 

howste

Thaumaturge
Trusted Information Resource
#9
The supplier is only required to do what they have agreed to in your purchase order or other legal agreement. If you never specified requirements for how to back up data or when to provide statistics, then you need to negotiate it and add it to your agreement.

If they are unwilling or unable to provide the data you want in the time you want, you may ask them to send you the raw data and you can do the statistical analysis yourself.
 

radame

Starting to get Involved
#10
If they are unwilling or unable to provide the data you want in the time you want, you may ask them to send you the raw data and you can do the statistical analysis yourself.
:applause:

YES, this is the problem we have!!

This is a know bad supplier which give us many headaches and this is precisely what we request, to provide all row data.

Nevertheless they refuse this under the excuse they need to review the info before, now my organization is not trusting on them and we think they are hiding something.

We are going to supplier facility to review this on site.

This is why we wanted to find some regulation about this to know if somehow we can force supplier to improve how they are storing the data in a better way so this can be easily retrievable without any risk to manipulate the data.
 
Thread starter Similar threads Forum Replies Date
R DCMA QAR Request Supplier Data AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 14
S Use of Published IMDS Data from our Raw Material Supplier RoHS, REACH, ELV, IMDS and Restricted Substances 6
A Supplier Rating from SAP QM Module Data Supplier Quality Assurance and other Supplier Issues 2
K Has anyone had experience dealing with SEDEX (Supplier Ethical Data Exchange)? Customer and Company Specific Requirements 4
B Automotive Supplier Benchmarking - Supplier PPM Data Benchmarking 5
I Service Supplier Rating where Objective Pass/Fail Data is not Available Service Industry Specific Topics 7
L Injection moulding supplier control and data - Plastic head band Nonconformance and Corrective Action 2
D High order value suppliers - Analysis of Supplier Data 8.4d ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
I WHO is managing your supplier rating data? Supplier Quality Assurance and other Supplier Issues 4
D Supplier OTD Slip Due to Shipping Delays or Natural Disaster AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
D Re-labeler - audit the supplier EU Medical Device Regulations 2
Evelyn7E The fastest way to get supplier to ship good parts to you Supplier Quality Assurance and other Supplier Issues 10
J Verification of purchased product / supplier questionnaires ISO 13485:2016 - Medical Device Quality Management Systems 2
D Question on Supplier Quality (SCAR) ISO 13485:2016 - Medical Device Quality Management Systems 6
Z REACH: contradictory statement from supplier? REACH and RoHS Conversations 4
G How to implement H&S and Quality Control Requirements in Contract for Potential Supplier? Contract Review Process 6
R Select the 1 Supplier based on the Parts Durability from 6 Supplier Samples using Minitab Using Minitab Software 11
K Why does load cell supplier requires force verification General Measurement Device and Calibration Topics 3
D Question and advice for a supplier self audit questionnaire ISO 13485:2016 - Medical Device Quality Management Systems 6
D Special IATF audit of sub-supplier IATF 16949 - Automotive Quality Systems Standard 18
S IATF 16949 Supplier selection criteria 8.4.1.2 IATF 16949 - Automotive Quality Systems Standard 2
M Supplier approved list - Notified body, regulatory body Supply Chain Security Management Systems 4
N Making improvements in supplier relationship last? Supplier Quality Assurance and other Supplier Issues 6
K Supplier Qualification for Engineering Consultant? Supplier Quality Assurance and other Supplier Issues 3
M Supplier evaluation Supplier Quality Assurance and other Supplier Issues 5
briteme4 ASL - AS9100 / Supplier Survey Supplier Quality Assurance and other Supplier Issues 3
A System for Supplier Documents Quality Assurance and Compliance Software Tools and Solutions 7
T IMDS submission without supplier's input? RoHS, REACH, ELV, IMDS and Restricted Substances 4
J Supplier not responding to PPAP request APQP and PPAP 5
D Supplier audit Medical Device and FDA Regulations and Standards News 2
lanley liao Does all of the suppliers need to integrated into the supplier list qualified of the company? Oil and Gas Industry Standards and Regulations 2
S Distinction between a critical supplier and a Virtual manufacturer EU Medical Device Regulations 2
R AS9102 FAI Change in Material / Process Supplier AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 4
John Broomfield Five ways to botch your supplier management program Misc. Quality Assurance and Business Systems Related Topics 7
C Supplier survey - 200 to 250 duppliers Supplier Quality Assurance and other Supplier Issues 3
J Where is the definition of a critical supplier? ISO 13485:2016 - Medical Device Quality Management Systems 5
U Approved Vendor (supplier) List Supplier Quality Assurance and other Supplier Issues 8
M Supplier requirements - Major supplier is a Non-Profit registered with ICCBBA (FDA UDI) Supply Chain Security Management Systems 12
P Training department ideas and development for automotive supplier Training - Internal, External, Online and Distance Learning 6
B Software service provider as critical supplier ISO 13485:2016 - Medical Device Quality Management Systems 5
T AS9100D Clause 10.2.1g Supplier Corrective Action for each and every nonconformity? AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
S Supplier protocol for the Quality Supplier Quality Assurance and other Supplier Issues 6
A API Spec Q1 Purchasing Process - Supplier Reevaluation based on Supplier Risks 5.6.1.4 Oil and Gas Industry Standards and Regulations 19
D Approved supplier list - Distributors question ISO 13485:2016 - Medical Device Quality Management Systems 6
G Supplier delivered recent PPAP, should he deliver yearly layout inspection? IATF 16949 - Automotive Quality Systems Standard 4
E ISO 13485 QMS certification as a Supplier ISO 13485:2016 - Medical Device Quality Management Systems 8
G Supplier doesn't share drawings IATF 16949 - Automotive Quality Systems Standard 15
S Use of raw materials by two supplier CE Marking (Conformité Européene) / CB Scheme 2
D Are Supplier Quality Agreements Quality Records ? Other Medical Device Regulations World-Wide 9
G Dealing with non conformity caused by Supplier Components detected in the production line IATF 16949 - Automotive Quality Systems Standard 14

Similar threads

Top Bottom