Uploaded image for project: 'AdMax'
  1. AdMax
  2. ADMAX-632

Process to upload a "Group" file breaks.

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: unspecified
    • Fix Version/s: None
    • Component/s: Creative Editor
    • Labels:
      None
    • Environment:

      Operating System: All
      Platform: PC

    • Bugzilla Id:
      1253

      Description

      Process:

      1. Download a group file with the intent to edit the END DATE.
      2. Open in Excel.
      3. Make Changes to END DATE.
      4. Upload file.
      5. Get Error: Invalid Date Format

      Troubleshooting:

      Opened Text file after download:

      • Date format is yyyy-mm-dd

      Opened Text file after Excel touched it:

      • Date format is mm/dd/yyyy
      • Needed to select column or field and change the date format to a CUSTOM date
        format of yyyy-mm-dd.

      Conclusion:
      Application should parse any date format. This can be fixed in the following file:
      secontentmsngroupcsvfilereader.class.php

      applyCustomDataFilters() method

      If strtotime() fails it could be because the date in the file is past the
      maximum date supported by php (04:14, 19 January 2038). This is only an issue if
      PHP is using 32-bit timestamps. If it does fail, the date could be truncated to
      the max date (but account managers should be using the "no end date" feature
      rather than setting the date way in the future).

        Attachments

          Activity

            People

            • Assignee:
              carl Carl (Inactive)
              Reporter:
              abe Abe Madyun (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: