Skip to main content

import dates or change a field's data type? All my imports - xlsx and csv - say date fields

Comments

5 comments

  • Permanently deleted user
    Doyle Van Zandt commented  ·    ·  

    Jeez. It truncated the rest of my question. All my imports identify date fields as "single line." How can I import dates or at least change field type.

    0
  • Permanently deleted user
    Jennifer commented  ·    ·  

    It is difficult to say why it is not importing properly without seeing the document. We recommend sending it over to us at support@trackvia.com so we can take a look. Most often, it has to do with the way the date is formatted in Excel. It sometimes stores values like 03/25/2005 as text, rather than as intrinsic dates and it can be hard to determine when this is happening. You can try confirming the field is stored as a date in the document and if you have any trouble, feel free to reach out to support. At this time we do not have the ability to convert text to a date type, however we are working on getting that functionality included in the near future.

    0
  • Permanently deleted user
    DJ commented  ·    · 

    Doyle,

    We recently released a new import process that allows you to choose the field type to import. If our system identifies the best field type as a single line for the data in the spreadsheet, you can choose to change that to a date field type to resolve your problem.

    0
  • Permanently deleted user

    Anonymous commented  ·    · 

    My date fields in Excel (4-22-2014) were all listed as "Invalid" in the import. What is the valid format for TV?

    0
  • Permanently deleted user
    Jake Marwil commented  ·    ·  

    Hi Dennis,

    A best practice for importing dates into TrackVia is to make sure they are in the
    (yyyy-mm-dd) format. An easy solution is to create an additional field in your Excel file and have it contain a formula (=TEXT(A1,"YYYY" & "-" & "MM" & "-" &"DD")) that reformats the source date field into the yyyy-mm-dd format as needed (Where A1 is your date column). Then make sure to copy/paste special this formula as values. When importing, ignore the original source data field and import the new correctly formatted field instead. Please let us know if you have any further questions.

    Regards,

    Jake

    0

Please sign in to leave a comment.

Powered by Zendesk