We currently using SAP.To generate a working list this is transferred by LiGS to our old Chemstation devives.
I want to develope the same for Open Lab.
I Technical Datasheet of the direct transfer via Lan would be greatly appreciated.
I added tags to this post to increase visibility.
Unfortunately, there is no technical datasheet outlining the layout of a csv or tsv file to import as a sequence worklist. You can refer to the OpenLAB Help & Learning to determine what column headers to use for the import file. I have also attached an example of a .csv file for a sequence import.
As for exporting files from OpenLAB, I will need more information. What type of data do you wish to export (results, raw data, etc...)? The easiest way you can export information from the software is by printing your injection reports to a file. There is no fixed layout for the injection reports and you can edit them in the 'Reporting' view of the Data Analysis software.
Sequence.csv.zip 526 bytes
thank you for your information.
I found a document concerning the XML Files. We would like to export either the raw data, then send it to our Software Ligs. It converts into a reading format to SAP. We also got a GC with the Old Chemstation up and running.
The Step is to create a working list in SAP. Then we pull it with Ligs and directly send the ord File to the Chemstation.
There we import the Sequence and get all the Data to the Sequence Table.
After the run we send it to our Software Port to send it back to SAP.
I know that the easiest way is to do it over a external file. But then we need to check the Checksum and since its manually transferred by the user it can cause errors.
Thank you for your help
We also need to know if the Import is like in the "Open Labs Chemstation Edition"
Can the program only read csv Files. I saw that you provide a tool called XML2CSV.
But I would prefer to read it directly as XML File.
If the Intergity of the data isn't changed during the prozess it would also be an option.
We got a second way too.
The Idea is
LIMS (XML) ==> Agilent tool ( XML2CVS ) ==> Open Lab ==> Result as CSV ==> Agilent tool CSV 2 XML ==> LIMS
I saw that there is a way with the " Sample Sheduler ".
Its an optional Software from Agilent. We don't own it yet.
But if we can solve all our Problems with that we will get it for sure.
Or is it possible to read xml files directly in OpenLabs Chemstation 2.1 and send the results as a xml file too ?
In the current releases of OpenLAB CDS 2.x, there is no way to directly export results or raw data as a .xml file. You are able to print injection reports to the following data file formats in the latest releases (2.3): *.pdf, *.docx, *.csv, *.xlsx, and *.txt.
There is also a data export add on available that allows you to export raw data in the *.D format used by OpenLAB ChemStation or in AIA format.
It is possible that the solution that you are looking for is found in the Sample Scheduler software. If you are interested in learning more about Sample Scheduler's capabilities, then I recommend you contact your local Agilent sales representative (Contact Us | Agilent ) and they can provide you with more information.
Thank you for your Time.
I requested more information from the details you provided.