Spectral Data Import and AnalysisHi,
one of my customer from pharmaceutical company is exploring JMP PRO, but they have problem to open the original data that been generated by their equipment
they told me this is spectral data, however in special data type "PKCS #7 Certificates" which i have no idea at all
Guessing the special type of file should able to be read into JMP via JSL or some other addin or ....
trying to attach the dummy file got from customer "Dummy Spectral data 280819.spc" but always with upload error: the contents of the attachement doesn't match its file type 
Kindly seek advice, any suggestion / thought : how to import the data into JMP, what kind of analysis usually perform, any relavent information etc..
thank you and wish you a good day
Re: Spectral Data Import and AnalysisHello All,
Just to update the status and result from my side. No exciting news basically
please feel free to skip the later part.
as suggested, seems there are many possible open and free resource to open .spc file.
I have tried few in the past weeks :
1: United States Environment Protection Agency --> overwhelmed search result that make me totally lost
2: “spc2csv.exe” --> download unsuccessful ( auto deleted once completed downloading), not even mention work or not . I gave up after x3 try
3: "Spectrum viewer" seems the most potential possible converter, managed to install the exe, however error code appeared ( guess this is due to system compatibility as i'm using x64bits system while the exe is for x32bits) sighh ~
emailed to EDAX tech support , but with least hope
4: Python Code --> that's my last try as i'm very new to python, in the end i found this code is for python 2.7 ONLY (while the current python is 3.7 )
Conclusion: leave those professional things to professional, there must be a great value added for those companies design the equipment /software which is not so easy for common person (like me) to achieve in such a short time
This is also what i always used to answer my JMP customer who want to develop PRO feature by themselves
(they want PRO features yet don't want to pay for it)
But will continue explore analysis techniques e.g. PLS ... in this area.
Thanks and Wish everyone a good day 
Pin
Re: Spectral Data Import and AnalysisHi Pin,
Once you get your data into JMP you have a couple of options for analysis. PLS is used often for spectral analysis. Check out Gasoline.jmp in the sample data files. This is NIR data used for predicting the octane rating in gas. You can also leverage FDE with your spectral data. @peterhersh has shown one way to use FDE and I have another way to FDE and PLS or GenReg to build a predictive model from the spectral data.
Hope this helps,
Bill
Re: Spectral Data Import and Analysis@wendytseng , Hi wendy,
I'm still learning, start from download Phthon (will post my result here once i got it)
Pharmaceutical area is quite new for me, really need take some time and effort to understand it.
It would be a good idea some of our SEs who are familar in Pharmaceutical area can share more practice
Re: Spectral Data Import and AnalysisThermoFisher support site has a FAQ about this issue. Here is an excerpt:
"How does someone use an Antaris spectrometer for in-line process analysis?
If the process environment has water hose down, CIP, dust, high temperature, corrosive or explosives chemicals, the analyzer needs to be placed in a safe area or enclosed in an environmentally stabilized enclosure. Fiber optics run from the NIR analyzer to probes or flow cells installed in production process pipes, tanks, hoppers, conveyors, reactors, etc. The fiber optics carry the NIR source light to the probe sampling window and then carry the light after it has interacted with the sample back to the NIR analyzer detector. The end of the probe will have a window or an air gap for reflection or transmission analysis. The product being analyzed must be self-cleaning or the probe engineered to automatically clean itself by high pressure air. The computer that controls the NIR analyzer is also located in the safe area with Thermo Scientific RESULT Software exporting NIR results to text or Microsoft Excel files, LIMS, OPC or by 4-20mA."
You might be able to get the data in an Excel file.
Re: Spectral Data Import and Analysis@PIN Curious if you had any luck with the Python code. I have a customer who just sent me a similar question. But his file is a .spa
"The instrument I’m using (ThermoFisher NIR (near Infrared) Spectral Analyzer) outputs the spectral data file in a .spa file format, which I have not been able to get JMP to read it. I think .spa is TF’s native (and proprietary?) file format, which is unfortunate, if true.
Do you know if any of your clients, especially those in pharmaceuticals is using TF spectral analyzers and whether they have been successful in using JMP to analyze the data from the .spa files?"
Re: Spectral Data Import and AnalysisThank you so much Ian.
Will test the Python code and update later whether it works or notRe: Spectral Data Import and AnalysisRegarding analysis, I feel obliged to mention this book (which could use an update). I'm sure they would be familiar with the methods therein. Of course there are other options too, including perhaps FDE.
Re: Spectral Data Import and AnalysisPin sent me the file directly, and it's this type. As stated there, it's a proprietory binary file, so reading it directly into JMP would be non-trivial. Wikipedia tells me that there is Python code to read the file, so using the JMP-Python interface may provide the path of least resistance. It might be worth the effort since I believe this is something of a standard for spectroscopic data . . .
Re: Spectral Data Import and AnalysisSearching for 'PKCS #7 Certificates' lead me to things like this, which are (probably . . . ) not relevant. To get useful help someone would need to try loading your '.spc' file into JMP. Try changing the file extension to one that will be accepted, perhaps '.jsl'.
