In order to create and edit XML Documents, you will need a program called Notepad++

I have left an easy-to-install version of this software in the DATARAID shared folder.  To Access this folder, first goto Computer located in the start menu.

Once my computer is opened up, in the address bar, type:    \\ussv054\DATARAID\shared

and press "Enter"

**Note: this may not work when working from home.

Drag the "Notepad++" folder to your deskop, or any other folder if you wish. This will install Notepad++ to your computer, so that you can use it.

Once the folder has finished copying, open the folder.

Click on "Notepad++Portable.exe" inside the Notepadd++ folder  to launch the software.

Notepad++ will look like this. Now you are ready to start creating an XML for Intel. The best way to do this is to take an older XML file of a working Lot for the same product of the product that needed a waiver to be shipped.

Open the Intel XML Product folder.

If you do not have a direct link to this folder, you can goto My Computer, and enter:    \\Ussv075\INTEL_XML_Prod

Click on the Archive folder.

***If you have Notepad++ already installed, you should start from this step.

Search for a previous successful lot number of the product you need to create an XML file for.

In this example, we will use lot# 00781973  from Microfab CU-MSA M

Copy the XML file for the lot number you searched for to your desktop (or any other folder, if you prefer). You can do this by Drag-and-Drop. This ensures that you do not make any changes to the original file.

On Your desktop, find the icon of the XML file you just copied. Right-Click on the icon, and select "Rename".

Rename the file so instead of reading Enthone-00781973.xml, it will read the proper lot number. In this example we will use lot# 00782110.

So I will rename the file to Entone-00782110.xml

Change the name of the file based on the lot number you need to create an XML for.

Now goback to the Notepadd++ Window. If you have closed it, you will need to re-open it now. n Notepad++, click on the Open Icon. Alternatively, you can goto File > Open...

Navigate to the folder you stored the XML file to, and select the file you are going to be editing. In this example, we are going to be editing the file we just created,  Enthone-00782110.xml, which is located on the desktop. Click open to open the file.

Now the file you opened will look like this. This view is not very good for editing, so we will have to change the way the XML code is presented to us.

Hit these keys at the same time to activate the XML view:

Control + Shift + Alt + B

Now your file will look like this. Scroll to the top of the document.

If you look closely at the file you will see the categories of the XML file in the triangle brackets.

ex. <lotNumber>00781973</lotNumber>

***Note: if there is a " / " in the brackets preceding the words, it signifies the end of that section.

In Notepad++, the text you can edit to change the information sent to Intel is shown in Black.  This heading section represents the cover page information, or what is shown at the top of the pdf CoA.

In this example, we are going to update the "thisDocumentGenerationDateTime" , "lotCreatedDate" , and "lotNumber" fields. Sometimes it may be required to edit other fields, but in this case and in most other cases, it will not  be needed.

you should be able to edit these fields exactly like you edit in MS Word or any other word processor.

Update these fields to show the statistics of the new Lot:

"thisDocumentGenerationDateTime"  = the date and time the sample was approved. You can see this in the description section of a sample in LIMS.

"lotCreatedDate" = this is the Manufacturing date. You can see this on the pdf COA or in the top section in LIMS

"lotNumber" = the new lot number

for time, use 24-hour time format, or military time.

for a date or time value, if there is a 1-digit value, always remember to add a zero in front like this:

<thisDocumentGenerationDateTime>2012-01-25T02:32:01</thisDocumentGenerationDateTime>

ie: year-month-date T hour:minute:seconds

After you are done, hit the Save icon, or Control + S to save your changes.

***IMPORTANT: Do not change any blue text in this document. It will mess up the formatting, and you will have to start again.

After your edits are done, it should look like this. (in this example). for your lot#, it will reflect that lot's information.

Take note of how the Data section is formatted. Since we started with an older lot of the exact same product, we do not have to change any of the <shortName> , <unitOfMeasure> or <measurementQualifier> values.

In the XML, the parameters are sorted by the Intel short name of parameters. the short name is displayed by the odd numbers above. (1, 3, 5)

Now, you must update the <measurementValue> sections of each of the parameters with the results from the lot new lot number.  This section is shown by the even numbers, (2, 4, 6). Make sure to keep the same number of decimals when you make the changes.

***NOTE: <measurementType> indicates the type of number the result will be. if it says "Value" - it means that the value in the <measurementValue> is a number. if it says "est_max" it means that the number in the <measurementValue> is a "<" value - such as "<0.250"

After your edits are done, these three values should look like this. (in this example). for your lot#, it will reflect that lot's information.

You must go through the the entire XML document and replace all of the data with the updated values from the new lot. Remember to save periodically.

These are examples of "est_Max" values. these values, in the old Lot were below the lower dedection limits (LDL) and thus were reported as Lead = <0.200 mg/L and Tin = <0.250 mg/L

In this example, in the new Lot , Lead = 0.291 mg/L. It is needed to change the <measurementType> to "Value" from "est_max" and then change the "0.200000000" to "0.291" - In this case, you should change the number of decimals to match what is would be shown on the COA for Lead.

The value of Tin in the new lot is also <0.250 mg/L, so no change needs to be made here.

After your edits are done, these three values should look like this. (in this example). for your lot#, it will reflect that lot's information.

Again, make sure to enter thecorrect  values for this entire document. Intel Will not accept the document unless all the values are accurate to the new Lot#.

Once you have completed your changes,  make SURE to save the document.

Once you have saved, you can close Notepad++

Please send the XML files you need to send out to either Brad Selvarajan, Jon Bimler, or Jiqin Ma.

They will be sent out as soon as possible.