Navigation Menu Link to get free Adobe Reader Link to CAAR Committee Contact Us Link Link to ARMS Schedule Link to the Department of Health and Human Services Disclaimer link to reports Links to ARMS forms Link to ARMS Manual Link to ARMS Hot Topics Link to Monitoring web site Link to Frequently Asked Questions link to ARMS System Link to other resources link to Division's home page  

ARMS Logo width=
Click here for ARMS home page
right corner image
 
     

File Import Feature (PDF)

File Import for ARMS Data

The import file should be formatted as follows (with comas separating each field):
StateFiscalYear,Region,Provider,CountyCode,Month,Year,LastName,SSN,DOB,ServiceCode,Units,Route

State Fiscal Year

4 Characters

Region

1 Character

Provider

4 Characters

County Code

3 Characters

Month

2 Characters

Year

4 Characters

Last Name

40 Characters

SSN

4 Characters (Last 4 digits of SSN or Assigned number)

Date of Birth (DOB)

8 Characters (Must be a valid date)

Service Code

3 Characters

Units

3 Characters (Zero filled)

Route

3 Characters (Zero filled)


The following is a sample data based on the above format:

FY,Region,ProviderCode,CountyCode,ReportMonth,ReportYear,LastName,SSN,DOB,Service,Units,SRW
2008,D,D058,097,07,2005,Poteat,1234,01021960,180,003,041
2008,D,D057,096,06,2005,Smith,5678,02031961,180,004,041
2008,D,D056,095,05,2005,Rauschenberger,9012,04051962,180,005,041
2008,D,D055,094,04,2005,Allen,3456,05071962,180,006,041


Notes from Programmer

There is no need to pad each record to the maximum length. Using commas to separate the data means that each record is determined by the comma, not by the length of the field, thus making the file smaller and reducing the import time.


The filename can be what you want; however, he suggests that we use the extension ".CSV" instead of .TXT.  CSV stands for comma separated values.

 

Revised per Tim Waters, ARMS Programmer, August 13, 2007