Division of Alcoholic beverages and tobacco
Electronic Data Submission (EDS)
Batch File Instructions
A. Register for System Access
- Request access using the Registration Form. You must include both the main company email address (the main account) and the person developing the batch files (you).
- Ensure your spam filter allows for emails from "EDS.Support@dbpr.state.fl.us."
- You should receive a confirmation email with the test FTP log-in information within one business day. Please Contact Us if you don't receive a confirmation email and you have checked your spam filter.
B. Test FTP Connection
- Ensure you can access the FTP Test server at ftp://sftp.dbpr.state.fl.us using the credentials supplied in the steps above.
- Ensure your spam filter allows for emails from "DoNotReply@dbpr.state.fl.us."
- Please Contact Us if you are having problems connecting to the server.
C. Download the Appropriate Batch File Specifications, Format, and Sample
These files provide the technical specifications for creating the batch upload file.
- Identify, download, and review the appropriate batch file specifications based on the actual paper form(s) you submit each month.
- Incorporate the Countries, States and Counties codes.
D. Add DBPR Business Entities
The following files contain a listing of business entities that should be loaded into your system. These files are updated monthly. You should update your database with the updated files before running your monthly reports.
- Download Business Entities Part 1(3.66 MB CSV)
- Download Business Entities Part 2 (3.70 MB CSV)
Last Updated: April 29, 2013
- When reporting your 'detailed transactions' you must specify the associated Florida Permit Number and Business Entity IDs which are provided in this file.
- You may experience a collision due to the fact that DBPR has re-used permit numbers. This means that you may find more than one business using the same permit number. When more than one business is found (a collision), please select the appropriate one including the Business Entity ID. This ensures that you are reporting the correct businesses by using both the permit number and unique business entity ID.
E. Program Your System / Generate Batch File
- Using the information supplied above, program your data system to generate the batch file in the specified format.
- Ensure your system uses all of the validation rules and database constraints contained within the batch file specifications files.
- The flat file format is comma separated and pipe delimited.
- Ensure the file name is formatted correctly using the Form ID, Business Entity ID and Report Year and Month separated by underscores (FormID_BusinessEntityID_YearMonth: 3_77773_200911.txt).
- Submit your system generated files to the FTP Test server at ftp://sftp.dbpr.state.fl.us until successful (no system errors).
- Important: Always ensure that you are using the correct permit number and email address!
F. Conduct Upload Test
- Prior to submitting your first official monthly report, we require you to test your batch configuration (listed in step E above).
- Once your file format is correct we ask you run reports for the previous 6 months and compare the results with your prior (paper) report submissions. Once your system's automated reports match your prior paper reports, please upload them to the same FTP Test server at ftp://sftp.dbpr.state.fl.us.
Note: You may find minor variations between those of your paper and automated reports. These differences may indicate similar variations that would be found during a regular bi-yearly audit. The purpose of this test is to ensure your system is setup correctly and is NOT an audit.
- We will review that data to ensure it reconciles with your prior paper based report submissions.
- Once you have successfully configured your system, tested, and uploaded your past reports, please Contact Us. We'll review your data and provide you with the credentials to submit data to our production FTP server.
G. Begin Submitting Monthly Reports
- Your email from AB&T will indicate if your batch file format and test data have been accepted.
- AB&T will send you the location and log-in credentials to the Production FTP Server.
Important: Reports are not officially received by AB&T until you submit them to the Production FTP site!
- You are responsible for successfully submitting your monthly reports within your regular deadline dates. You have not officially submitted a report until you receive the automated email message indicating that AB&T has received it.
- Once you are working in the Production environment, you will be given an option to view your data using our Web-based EDS interface. Your log-in credentials for this system will be provided when you receive your Production FTP credentials.