Maximo List Archive - Loading PMs through CSV file : Unparseable Date/Time Error

This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.

Loading PMs through CSV file : Unparseable Date/Time Error

From: Victor (2011-12-30 22:50)

Hi All,
I am trying to import preview one of my PM data load templates for PM.
I get the following error for the Nextdate field :
BMXAA4144E - The date/time format is not valid.
Unparseable date: "2/23/2016 12:00 AM"
Tried all different data/time formats. Seems like none of the formats work.
Note: I have the MM/dd/yyyy format for changedate and it doesn't prompts any error for that changedate format.
Any help or insight would be appreciated.
Thanks & regards,
Victor.

From: Chris Lawless (2011-12-30 17:54)

Have you tried UTC date format such as:
2016-02-23T00:00:00-05:00
I usually find the best approach is to export some data then copy the
format for the import.
Chris.
On Fri, Dec 30, 2011 at 5:50 PM, Victor <vikas17.j@gmail.com> wrote:
> **
>
>
> Hi All,
>
> I am trying to import preview one of my PM data load templates for PM.
>
> I get the following error for the Nextdate field :
>
> BMXAA4144E - The date/time format is not valid.
> Unparseable date: "2/23/2016 12:00 AM"
>
> Tried all different data/time formats. Seems like none of the formats work.
>
> Note: I have the MM/dd/yyyy format for changedate and it doesn't prompts
> any error for that changedate format.
>
> Any help or insight would be appreciated.
>
> Thanks & regards,
> Victor.
>
>
>

From: Victor (2011-12-30 23:14)

Hi Chris,
Thanks for the reply, let me try that and then I will let you know the results.
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, Chris Lawless <lawlessc@...> wrote:
>
> Have you tried UTC date format such as:
>
> 2016-02-23T00:00:00-05:00
>
> I usually find the best approach is to export some data then copy the
> format for the import.
>
> Chris.
> On Fri, Dec 30, 2011 at 5:50 PM, Victor <vikas17.j@...> wrote:
>
> > **
> >
> >
> > Hi All,
> >
> > I am trying to import preview one of my PM data load templates for PM.
> >
> > I get the following error for the Nextdate field :
> >
> > BMXAA4144E - The date/time format is not valid.
> > Unparseable date: "2/23/2016 12:00 AM"
> >
> > Tried all different data/time formats. Seems like none of the formats work.
> >
> > Note: I have the MM/dd/yyyy format for changedate and it doesn't prompts
> > any error for that changedate format.
> >
> > Any help or insight would be appreciated.
> >
> > Thanks & regards,
> > Victor.
> >
> >
> >
>
>
>
>

From: Victor (2011-12-30 23:36)

Hi Chris,
Another question, how to convert the standard excel date/time in UTC format. The time zone is US/PST.
Thanks in advance.
Victor.
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hi Chris,
>
> Thanks for the reply, let me try that and then I will let you know the results.
>
> Thanks & regards,
> Victor.
>
> --- In MAXIMO@yahoogroups.com, Chris Lawless <lawlessc@> wrote:
> >
> > Have you tried UTC date format such as:
> >
> > 2016-02-23T00:00:00-05:00
> >
> > I usually find the best approach is to export some data then copy the
> > format for the import.
> >
> > Chris.
> > On Fri, Dec 30, 2011 at 5:50 PM, Victor <vikas17.j@> wrote:
> >
> > > **
> > >
> > >
> > > Hi All,
> > >
> > > I am trying to import preview one of my PM data load templates for PM.
> > >
> > > I get the following error for the Nextdate field :
> > >
> > > BMXAA4144E - The date/time format is not valid.
> > > Unparseable date: "2/23/2016 12:00 AM"
> > >
> > > Tried all different data/time formats. Seems like none of the formats work.
> > >
> > > Note: I have the MM/dd/yyyy format for changedate and it doesn't prompts
> > > any error for that changedate format.
> > >
> > > Any help or insight would be appreciated.
> > >
> > > Thanks & regards,
> > > Victor.
> > >
> > >
> > >
> >
> >
> >
> >
>

From: Victor (2011-12-30 23:50)

Updates :
I resolved the date error but I am getting a new error now :
BMXAA1702E - Cannot read from the file.
null
Thanks & regards,
Victor.
--- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
>
> Hi Chris,
>
> Another question, how to convert the standard excel date/time in UTC format. The time zone is US/PST.
>
> Thanks in advance.
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@> wrote:
> >
> > Hi Chris,
> >
> > Thanks for the reply, let me try that and then I will let you know the results.
> >
> > Thanks & regards,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, Chris Lawless <lawlessc@> wrote:
> > >
> > > Have you tried UTC date format such as:
> > >
> > > 2016-02-23T00:00:00-05:00
> > >
> > > I usually find the best approach is to export some data then copy the
> > > format for the import.
> > >
> > > Chris.
> > > On Fri, Dec 30, 2011 at 5:50 PM, Victor <vikas17.j@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi All,
> > > >
> > > > I am trying to import preview one of my PM data load templates for PM.
> > > >
> > > > I get the following error for the Nextdate field :
> > > >
> > > > BMXAA4144E - The date/time format is not valid.
> > > > Unparseable date: "2/23/2016 12:00 AM"
> > > >
> > > > Tried all different data/time formats. Seems like none of the formats work.
> > > >
> > > > Note: I have the MM/dd/yyyy format for changedate and it doesn't prompts
> > > > any error for that changedate format.
> > > >
> > > > Any help or insight would be appreciated.
> > > >
> > > > Thanks & regards,
> > > > Victor.
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
>

From: Chris Lawless (2011-12-30 18:50)

Excel has functions to extract the date, month, year etc that you can then concatenate to form a UTC string - if there isn't a UTC date format.
On Dec 30, 2011, at 6:36 PM, "Victor" <vikas17.j@gmail.com> wrote:
> Hi Chris,
>
> Another question, how to convert the standard excel date/time in UTC format. The time zone is US/PST.
>
> Thanks in advance.
> Victor.
>
> --- In MAXIMO@yahoogroups.com, "Victor" <vikas17.j@...> wrote:
> >
> > Hi Chris,
> >
> > Thanks for the reply, let me try that and then I will let you know the results.
> >
> > Thanks & regards,
> > Victor.
> >
> > --- In MAXIMO@yahoogroups.com, Chris Lawless <lawlessc@> wrote:
> > >
> > > Have you tried UTC date format such as:
> > >
> > > 2016-02-23T00:00:00-05:00
> > >
> > > I usually find the best approach is to export some data then copy the
> > > format for the import.
> > >
> > > Chris.
> > > On Fri, Dec 30, 2011 at 5:50 PM, Victor <vikas17.j@> wrote:
> > >
> > > > **
> > > >
> > > >
> > > > Hi All,
> > > >
> > > > I am trying to import preview one of my PM data load templates for PM.
> > > >
> > > > I get the following error for the Nextdate field :
> > > >
> > > > BMXAA4144E - The date/time format is not valid.
> > > > Unparseable date: "2/23/2016 12:00 AM"
> > > >
> > > > Tried all different data/time formats. Seems like none of the formats work.
> > > >
> > > > Note: I have the MM/dd/yyyy format for changedate and it doesn't prompts
> > > > any error for that changedate format.
> > > >
> > > > Any help or insight would be appreciated.
> > > >
> > > > Thanks & regards,
> > > > Victor.
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
>
>