Double Quotes Issues

[Tokunbo Hiamang]

When I submit my data as a text file with double quotes around every character, the number of errors I get jumps high. Sometimes, I get the Cake PHP screen. 

When I take the double quotes off, I cannot submit decimals. Can someone please tell me what I am missing?

Thanks,

Toks

[Gregory Briddick, Jr.]

Can you paste the error messages that you are getting.  This would be very helpful in being able to troubleshoot what is going on without actually seeing the patient data.

[Tokunbo Hiamang]

Errors:

This is the error I am getting. Is there any place I can safely show you the patient data?

(If you are submitting a technical support request, please do not attach the file that you have attempted to upload here, if you would like to submit a file for review to the help desk, limit the file to 2 rows (header and the first row of data) and remove any identifying information from the file)

Entries:

• Case 1:
  • admission_dt:
    • Must be a valid YYYY-MM-DD hh:mm or YYYY-MM-DDThh:mm date time.
  • arrival_dt:
    • Must be a valid YYYY-MM-DD hh:mm or YYYY-MM-DDThh:mm date time.
  • date_of_birth:
    • YYYY-MM-DD format required.
  • discharge_dt:
    • discharge_dt is not within the chosen measurement period (12/01/2020 - 05/31/2021)
    • Must be a valid YYYY-MM-DD hh:mm or YYYY-MM-DDThh:mm date time.
  • discharge_status:
    • Not a valid selection.
  • ethnicity:
    • "E2" is not a valid selection.
  
  

--

Tokunbo M. Hiamang

[Gregory Briddick, Jr.]

Would it be helpful to have a webex to take a look at the data and walk you through it?  This looks like a formatting issue with the variables, specifically the date/time formats.  Depending on how you are exporting the datetime variable out of your RDBMS, the format may be incorrect.  I had to convert the datetime variable into a varchar and export it in string format, in the required layout.  Also, don't pull the file up in excel, as it will convert these to the decimal version of datetime, which won't be accepted by the portal.