Schema Information

• Documentation (Excel)


• Sample files
  • RE1313002.xml
  • RE5757004.xml

2025​ Summary and Reminders

• Validating Parcel ID format to our website – see row 24 of the Excel schema documentation
• ​​​​​Parsing out address into discrete fields – see rows 50-54; 56-58; 79-84 of the Excel schema documentation
• Use StreetName for additional miscellaneous data – see row 186 of the Excel schema documentation
• Allow subclasses of property type – see rows 190-193 of the Excel schema documentation
• Update country code to USPS format – see line 60 of the Excel schema documentation
• ​ Parcel numbers
  • Provide formatted parcels numbers with punctuation (ex: "." and "-")
  • See the DOR current parcel number formats for each county
  • Acknowledgement emails contain parcel numbers when a XML does not meet the schema requirements
  • Use consistent parcel number formats to enable DOR's use of the XML rolls (ex: processing of Real Estate Transfer Returns, chargebacks, sharing of omitted taxes, Tax Incremental District (TID) processing)
• Tax incremental district (TID) parcels
  • Identify TID parcels within the XML
  • "TypeTID" – see row 143 of the Excel schema documentation
  • "TIDCode" – see row 144 of the Excel schema documentation
  • See the active TID report for a list of each active TID, the type and the code
• Parcels without a situs address
  • Schema has a specific field called NoPhysicalAddress and allows, either:
    1. Select the NoPhysicalAddress option, or
    2. Provide a standard street, city, state, zip
  • Enter "unknown" if your system does not support either option
• See our filing assistance document available on our website
• Send DOR your public (redacted) data to maintain consistency with providing any data

Prepare the File

1. Name each XML with its corresponding DOR Co-muni code – to improve the XML names and quickly identify which file belongs to a specific municipality
2. Submit one real estate XML and one personal property XML for each municipality – to make the XML easier to locate when working together to troubleshoot issues
3. Upload the county - send a zip file with all municipality XML included
   • Send a single zipped file for each real estate XML and each personal property XML
     
   
   
   • Make sure the zipped file only contains xml files
     
   
   
   • Do not include internal folders in your zip file
     

Transfer the Test Data

Send the file with file transfer protocol (FTP).

Steps:

1. Select your county (Cnty asmt rolls) from the dropdown list
2. Select "Yes" for "Is this a test file?"
3. Select your file with the browse option
4. Transfer the file
5. ​You will receive acknowledgement response after your individual file(s) processed

Transfer the Data

Send the file with file transfer protocol (FTP)

Steps

1. Select your county (Cnty asmt rolls) from the dropdown list
2. Select "No" for "Is this a test file?"
3. Select your file with the browse option
4. Transfer the file

Acknowledgments

• DOR sends acknowledgments by email
• The acknowledge email, stating we accepted or rejected the file, contains the file name as it is stored in our system
• If the XML does not meet the schema requirements, the acknowledgement will provide both the Record Number and the Parcel Id causing the reject
• Contains parcel numbers when an XML does not meet the schema requirements
• When you contact DOR staff, include this file name (from our email response) to help expedite troubleshooting, especially when the file does not use the Co-muni code or if the number or file contains an error

DOR Review

• Test files are processed individually
• To help us respond to questions, DOR's acknowledgement email contains the file name as it is stored in our system

Questions?

If you have any questions, contact us at OTAS@wisconsin.gov or (608) 266-7750.

​​