2. PHPRunner General questions
  3. Strange import behaviour in phpr 9
This topic is locked

Strange import behaviour in phpr 9

 		8/7/2016 5:07:29 AM
PHPRunner General questions
M
 merlingolden author

In phprunner import page if the date 1st to 23rd of any month it will not import the date, month and year is not a problem, phpr 9 is comfortable with date from 24 to 31st only <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=24069&image=1&table=forumtopics' class='bbc_emoticon' alt=':P' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=24069&image=2&table=forumtopics' class='bbc_emoticon' alt=':P' />
example a column with this date 01-07-16 10:46 Will not import, also same with 23-07-16 11:24

BUT this date is imported correctly 24-07-16 10:27
database used mysql 5.6.17 and field is datetime,
Merlin
Sergey Kornilov admin 8/9/2016

This is really strange. Just in case make sure that correct date format was selected during import.
If this doesn't help post your project to Demo Account and contact support directly sending a test import file so we can troubleshoot this.
M
 		merlingolden author 8/10/2016

It is a bug in phprunner v9. Anyone can reproduce it

  1. Make a simple project create one table with ID field and a datetime field using a phprunner
  2. Build
  3. Browse the import page and try to copy-paste or upload the following data it will import only the second one, that is 24th date not the 23rd date
    Data to import:
    23-07-16 17:41

    24-07-16 19:40
    Thats it, try with changing any date from 1st to 23rd and 24th to 31st of any month/year result will be the same it will upload only 24th to 31st, but create blank entry for 1st to 23rd dates. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=80027&image=1&table=forumreplies' class='bbc_emoticon' alt=':huh:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=80027&image=2&table=forumreplies' class='bbc_emoticon' alt=':huh:' />
    BUT IN PHPR v8.1 there is no issue with the same table and settings <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=80027&image=3&table=forumreplies' class='bbc_emoticon' alt=':)' />


    This is really strange. Just in case make sure that correct date format was selected during import.
    If this doesn't help post your project to Demo Account and contact support directly sending a test import file so we can troubleshoot this.