Can I email my agency's file to the CDSS?
No. The CDSS does not accept files via email. Email is not a secure form of communication; never use email to send files that contain confidential information (e.g., Social Security Numbers [SSNs]). Agencies must transfer the file by using the CDSS – CDMIS Web Portal. In certain circumstances, CDSS – CDMIS Support may request a file to be uploaded to a secure Electronic File Transfer System. Instructions will be provided at that time.
Can I send a diskette, CD, or USB with my agency's file to the CDSS?
No. The CDSS does not accept diskettes, CDs, or USBs. Agencies must transfer the file by using the CDSS – CDMIS Web Portal.
Can I download a file from the CDMIS?
Yes. The CDD-801A Submission Export report, which is available via the CDD-801A Management Reports function, allows agencies to export one month of data into an Excel spreadsheet and save that file onto a computer.
How do I know if someone else in my agency has already transferred a file for a report month?
Each time a user attempts to submit a file using the CDD-801A Electronic File Transfer function, the CDSS – CDMIS checks to see if data already exists for that report period. If data already exists, a screen is displayed asking for confirmation to accept the file and overwrite the existing data in the selected report period or cancel the transfer. If there is no data in the report period, the file is accepted, and the user can check the status of the file the next day.
When I format the file, do I put quotation marks around the character fields?
No. Do not use quotation marks before and after character fields. The only delimiters allowed in the file are tabs (to separate fields) and CR/LF (to indicate the end of a row).
If I use the file transfer once, do I then have to use the file transfer every month after that?
No. For subsequent report periods, agencies can manually enter data (via the CDD-801A Input/Edit function) directly into the CDSS – CDMIS Web Portal. For example, agencies can do a one-time electronic file transfer to load all of their data into the CDSS – CDMIS. For the next report month, agencies can use the "Copy forward" button available within the CDD-801A Input/Edit function to copy data to a subsequent report period. After the data is copied to the new report period, agencies can edit the data by using the data entry screens.
Can I use the file transfer option whenever I want?
The CDSS – CDMIS Web Portal is always available for agencies to submit the CDD-801A. However, agencies cannot submit data for future report periods as reporting rules require that agencies submit information based on days of enrollment claimed for fiscal reimbursement purposes through agencies’ contracts.
Can I transfer a partial file now and transfer the rest later?
No. Each time agencies (successfully) transfer a file, existing data in the database for the given report period is erased. The transfer file replaces all currently existing data.
The only way for agencies to submit data in multiple files is to establish sub-agencies, but those sub-agencies must contain different groups of families.
How do I change the information I already transferred? I need to add, edit, and delete data.
Agencies have two options:
- Use the data entry screens on the CDSS – CDMIS Web Portal (i.e., utilize the “CDD-801A Input/Edit” function) to correct the information (this may be easier if agencies only need to make a few changes), or
- Make corrections to the file and upload the corrected file to the CDSS – CDMIS. (For the report period, all currently existing information is erased and the information contained in the new file is loaded into the database.)
Help! I transferred a file with wrong information. How do I delete all of the data in the file?
Agencies have two options:
- Use the data entry screens on the CDSS – CDMIS Web Portal (i.e., utilize the “CDD-801A Input/Edit” function) to delete all of the information, or
- Create a new file that contains correct information and upload the corrected file to the CDSS – CDMIS. When the file passes, all currently existing information is erased and the information contained in the new file is loaded into the database.
What happens to the file I transferred?
The file is processed in three steps:
- The file is immediately stored on the CDSS – CDMIS Web Portal.
- The file process begins at 2:45 a.m. the following morning.
- If processing is successful, the information in the file is transferred to the database.
- If processing is not successful, none of the information in the file is transferred to the database.
- A processing status report is created and stored (permanently) on the CDSS – CDMIS Web Portal.
How do I know if my file transfer was successful?
The CDD-801A Electronic File Status Report will indicate the “File Status.” If the File Status says "Passed, Loaded to database," the file has no error messages and the families and children in that file have been added to the report period and can be viewed in the database the following day. If the File Status says "Failed, Not loaded to database," the file has error messages, and the families and children were not added to the report period.
If one sub-agency uses the file transfer function, does the other one have to?
No. Every sub-agency is completely independent of any other sub-agency.
Can I switch from file transfer to web input (or vice versa) anytime?
Yes.
When I look at my transfer file, the data wraps into lots of rows. Did I do something wrong?
When printing or displaying an import file, long records may wrap around the screen or page for multiple “lines.” These are still considered single rows (records) if the end-of-line characters CR/LF appears after the last field.
Do I have to give my electronic file a special name before I transfer it to CDSS – CDMIS?
No. The CDSS – CDMIS Web Portal accepts files with any name. For agencies’ convenience, the CDSS – CDMIS Support recommends that agencies indicate the report period in files’ names.
My agency uses a software package to create the CDD-801A. Can I transfer that file to the CDSS – CDMIS Web Portal?
Agencies that use software created by vendors can submit files if the software has been updated with the file format specifications detailed in Appendix C: Creating Electronic Files. For more information, consult the specific vendor.
I forgot to report some families when I transferred the last report period’s electronic file. Can I just include those families in my file for next report period?
No. Files must contain information for only one report period. If agencies try to transfer a file with information for more than one report period, the entire file will be rejected. To add just a few families to a prior month, use the "CDD-801A Input/Edit" function.
What is a FIPS code and how do I find it?
FIPS stands for Federal Information Processing Standards. In California, FIPS codes are assigned by county. If the county is known, the FIPS code can be found on the CCD-26, Confidential Application for Child Development Services and Certification of Eligibility.
For residents of contiguous states, the FIPS code is the two-digit state code followed by three numbers associated with the counties in those states. The CDSS – CDMIS maintains a “Zip/FIPS Lookup” function that can be accessed from the “Resources” drop down menu. Select the zip code in this function; the City, FIPS Code and County are displayed to enter in files.
I used a spreadsheet to create my electronic file. When I try to transfer it, the transfer fails. Help!
Four common problems when using a spreadsheet are as follows:
-
Problem: Agencies include column headings at the top of the spreadsheet and enter data into the rows underneath. The database is unable to read the header row, so the file is rejected.
Solution: Remove the header row from the spreadsheet before saving the spreadsheet as a tab-delimited text file.
-
Problem: When the spreadsheet application creates the tab-delimited text file, it adds delimiters to the file. For example, quotation marks may be inserted around text fields.
Solution: Remove any additional characters from the file.
-
Problem: When agencies type a leading zero (“0”) in some entries, the spreadsheet application ignores the 0. For example, agencies enter "04" (i.e., licensed center-based care) as the type of child care, but the spreadsheet drops the "0" and displays only the "4."
Solution: Format the column in the spreadsheet as a "text" column rather than a number column or use custom formatting for the column and enter the format type as “00” so the leading zero is not dropped.
-
Problem: When agencies enter a date into the spreadsheet, the spreadsheet changes the format. For example, agencies enter "04/06/2012," but the spreadsheet displays "4/6/2012."
Solution: Format the column in the spreadsheet as a "text" column rather than a number column or use custom formatting for the column and enter the format type as “mm/dd/yyyy” so leading zeros are not dropped.