Texas Online Metals

Upload Instructions

Printed: 4/18/2024 11:49:30 PM (O:0, U:0)

Please click here for Important Version 2.0 File Format Information

The Metal Recycling Program offers an upload utility by which data can be exported from an external system and uploaded to this website. The Transaction File Upload process described here requires a user to manually upload a file. TxDPS offers additional methods for automating Transaction submissions and manually entering Transactions:

If you are looking to manually enter information, you should use the web interface by clicking the Add Transaction link on the maintenance screen.

How the Upload Process Works

The first step in uploading a file is to create the file. It is not expected that this file will be created by hand; it should be created by an export process for the system that the data originates from. Details on creating a file can be found below.

The file should be validated by an external system using the supplied validation tools. Files containing errors will be rejected in full and will have to be resubmitted.

After uploading the file is validated and checked for duplicate invoice numbers. The user then submits the pending Transactions and they are saved to the system.

Validation rules and restrictions on modifying existing information are consistant accross all methods of Transaction submission.

Version 2.0 File Format

The web site only accepts XML files. Excel, Word and Text files are not accepted.

TOM 2.0 Format Changes.docx - Document explaining importatnt changes to v2.0 File Format.
Transaction Validation Files - These files are used to validate XML that is in the v2.0 File Format. Be sure to replace TypeMakeModelCode.xsd and MetalTypeForm.xsd with updated versions (See below).
TypeMakeModelCode.xsd - Updated XSD for validating vehicle codes.
TypeMakeModelCode.txt - Literals for vehicle codes.
VehicleColorCode.xsd - Updated XSD for validating vehicle color codes.
VehicleColorCode.txt - Updated XSD for validating vehicle color codes.
MetalTypeForm.xsd - Updated XSD for validating Metal Form codes.
MetalTypeForm.txt - Literals for Metal Form codes.

User Tips

Sample Data File

<TransactionBatch>
            <Transactions>
            <Transaction>
            <Details>
            <TransactionDetail>
            <MetalWeight lbs="2" />
            <MetalTypeForm>ALUMINUM-AUTO_TRANSMISSION</MetalTypeForm>
            <HasTradeLicense>true</HasTradeLicense>
            <IsExplosive>true</IsExplosive>
            <MetalDescription>Description 1/2</MetalDescription>
        </TransactionDetail>
            <TransactionDetail>
            <MetalTypeForm>REGULATEDMETALS-CATALYTIC_CONVERTER</MetalTypeForm>
            <Ccid>XXXMMYYYY1234</Ccid>
            <HasTradeLicense>true</HasTradeLicense>
            <IsExplosive>false</IsExplosive>
            <MetalDescription>Description 2/2</MetalDescription>
        </TransactionDetail>
         </Details>
            <Seller>
            <Identification idt="DL" issuer="TX" idn="13245678" />
            <Business>
            <Name>JD Metals</Name>
        </Business>
            <Name l="Doe" f="John" m="" />
            <Address>
            <Street>123 Test Drive</Street>
            <City>Austin</City>
            <State>TX</State>
            <Zip>78731</Zip>
            <County>TRAVIS</County>
        </Address>
            <Vehicle>
            <Plate plateNo="ABC123" issuer="TX" />
            <TypeMakeModel>AUTO-FORD-F15</TypeMakeModel>
            <Color>BGE</Color>
            <IsModelExist>true</IsModelExist>
        </Vehicle>
         </Seller>
            <CertificateId>100000</CertificateId>
            <SaleDate>2009-02-10</SaleDate>
            <DealerInvoice>INV0001</DealerInvoice>     
            <DeliveryMethod>Automobile</DeliveryMethod>
            <Agreement signed="true" legalOwner="true" lawfulSeller="false" />
       </Transaction>
            <Transaction>
            <Details>        
            <TransactionDetail>
            <MetalWeight lbs="1" oz="15" />
            <MetalTypeForm>COPPER-INSULATED_WIRE</MetalTypeForm>
         </TransactionDetail>
         </Details>
            <Seller>
            <Identification idt="DL" issuer="TX" idn="6789065" />
            <Business>
            <Name>ABC Metals</Name>
         </Business>
            <Name l="Garcia" f="Jose" m="" />
            <Address>
            <Street>1220 plains</Street>
            <City>Austin</City>
            <State>TX</State>
            <Zip>78731</Zip>
            <County>TRAVIS</County>
         </Address>
         </Seller>
            <CertificateId>100000</CertificateId>
            <SaleDate>2009-02-10</SaleDate>
            <DealerInvoice>INV0002</DealerInvoice>
            <DeliveryMethod>Bicycle</DeliveryMethod>
            <Agreement signed="true" legalOwner="true" lawfulSeller="false" />
       </Transaction>
            <Transaction>
            <Details>     
            <TransactionDetail>
            <MetalWeight lbs="1" oz="15" />
            <MetalTypeForm>COPPER-INSULATED_WIRE</MetalTypeForm>
         </TransactionDetail>
         </Details>
            <Seller>
            <Identification idt="DL" issuer="TX" idn="6789065" />
            <Business>
            <Name>ABC Metals</Name>
         </Business>
            <Name l="Garcia" f="Jose" m="" />
            <Address>
            <Street>1220 plains</Street>
            <City>Austin</City>
            <State>TX</State>
            <Zip>78731</Zip>
            <County>TRAVIS</County>
         </Address>
         </Seller>
            <CertificateId>100000</CertificateId>
            <SaleDate>2009-02-10</SaleDate>
            <DealerInvoice>INV0003</DealerInvoice>
            <DeliveryMethod>Walk</DeliveryMethod>
            <Agreement signed="true" legalOwner="true" lawfulSeller="false" />
       </Transaction>
            <Transaction>
            <Details>
            <TransactionDetail>
            <MetalWeight lbs="2" />
            <MetalTypeForm>ALUMINUM-AUTO_TRANSMISSION</MetalTypeForm>
            <HasTradeLicense>true</HasTradeLicense>
            <IsExplosive>true</IsExplosive>
            <MetalDescription>Example of IsExplosive</MetalDescription>
         </TransactionDetail>     
         </Details>
            <Seller>
            <Identification idt="DL" issuer="TX" idn="13245678" />
            <Business>
            <Name>JD Metals</Name>
        </Business>
            <Name l="Doe" f="John" m="" />
            <Address>
            <Street>123 Test Drive</Street>
            <City>Austin</City>
            <State>TX</State>
            <Zip>78731</Zip>
            <County>TRAVIS</County>
         </Address>
            <Vehicle>
            <Plate plateNo="ABC123" issuer="TX" />
            <TypeMakeModel>AUTO-FORD-F15</TypeMakeModel>
            <Color>BGE</Color>
            <IsModelExist>true</IsModelExist>
         </Vehicle>
         </Seller>
            <CertificateId>100000</CertificateId>
            <SaleDate>2009-02-10</SaleDate>
            <DealerInvoice>INV0004</DealerInvoice>
            <IsRejected>true</IsRejected>
            <DeliveryMethod>Automobile</DeliveryMethod>
            <Agreement signed="true" legalOwner="true" lawfulSeller="false" />
       </Transaction>
   </Transactions>
</TransactionBatch>

Formatting Dates

Dates should be entered using standard xs:date format. The following chart shows what is and is not accepted by the sytem:

Allowed: 2008-11-06
Invalid: 2008-11-06T11:15:07
Invalid: 2008-11-06T11:03:07PM
Invalid: 2008/11/06
Invalid: 11/06/2008
Invalid: 11/06/2008T11:03:07PM