#19

ISI parser does not fill Couple_Articles_Author

    • Status: Fixed
    • Priority: High (2)
    • Component: -
    • Estimate: None/Small/Medium/Large None
    The new ISI parser does not fill the table Couple_Articles_Author! Checked two separate databases and found the same. Attached is a third, small database and associated ISI text file with the same problem.
  • Followers
     
    Ico-users AndreSomers (Assigned To) , Edwin_Horlings 
     
    Attachments
    Fico_general
    756 KB Added by Edwin_Horlings on September 29, 2009 09:49 UTC   Details
    Fico_txt
    91.3 KB Added by Edwin_Horlings on September 29, 2009 09:49 UTC   Details
    Associations
     
    No associations
    Activity
     
    User picture

          on Sep 29, 2009 @ 09:49am UTC * By Edwin_Horlings

    Attachment hugo.mdb added
    file:bWqfn4Rn0r3QrzeJe5aVNr: Access file parsed from hugo.txt
    User picture

          on Sep 29, 2009 @ 09:49am UTC * By Edwin_Horlings

    Attachment hugo.txt added
    User picture

          on Sep 29, 2009 @ 09:53am UTC * By AndreSomers

    Status changed from New to Invalid
    User picture

          on Sep 29, 2009 @ 09:54am UTC * By Edwin_Horlings

    Please explain
    User picture

          on Sep 29, 2009 @ 10:43am UTC * By AndreSomers

    Status changed from Invalid to New
    The query Couple_Articles_Author*s* is not properly created.
    User picture

          on Sep 29, 2009 @ 10:48am UTC * By AndreSomers

    Status changed from New to Accepted
    Work remaining set to 0.0
    A table stub is created somehow. Probably, the merging of development branches caused an older version of the empty stub database to be used again.

    A small fix in the replacing query is needed to remove the -1 authors.
    User picture

          on Sep 30, 2009 @ 11:04am UTC * By AndreSomers

    Temporary work-around:
    Delete the created Couple_Articles_Authors table. Instead, create a query with that name, using the following SQL:

    SELECT DISTINCT Couple_Articles_ResearchAddresses_Authors.Articles_ID, Couple_Articles_ResearchAddresses_Authors.Authors_ID, Couple_Articles_ResearchAddresses_Authors.[author position]
    FROM Couple_Articles_ResearchAddresses_Authors
    WHERE Couple_Articles_ResearchAddresses_Authors.Authors_ID > 0;
    User picture

          on Sep 30, 2009 @ 11:10am UTC * By AndreSomers

    Priority changed from Highest (1) to High (2)
    User picture

          on Sep 30, 2009 @ 11:10am UTC * By AndreSomers

    Milestone changed from Backlog to Next Release
    User picture

          on Nov 24, 2009 @ 08:58am UTC * By AndreSomers

    Status changed from Accepted to Test
    User picture

          on Jun 28, 2010 @ 03:03pm UTC * By AndreSomers

    Status changed from Test to Fixed
    Status set to "fixed", since no more issues have been reported.
    Time Expenditure
    Loading