CountyRolls schema is available for download – CountyRolls2022V2.4A.zip

Schema Information

• Documentation (Excel)
• Sample Files
  • RE1414002.xml
  • RE3232008.xml

2023 Summary and Reminders

• No schema changes for 2023
• 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
• 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 you to 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
• One parcel with multiple addresses (ex: apartment building)
  • Provide each street address for the parcel
  • Do not combine as a range into one entry
  • See the sample file "Re3030241.XML" in the "SampleReturns" folder within the zip file
• 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

• 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
• 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
• 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. Send an email to DORDeveloperRelations@wisconsin.gov with "XML County Rolls" in the subject line
6. 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
• 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

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