Hi Morgan ,

The corrupt data in the Publication Citator for IC/0104/02 has resolved. Please find attched screenshot for your refrence.

Please check and confirm.

screen-1-data.png 79.6 KB • Download

screen-2 data.png 79.6 KB • Download

Looks good Harsh .

Paul and Irit , could you confirm that all the data is correct within IC/0104/02, and then we'll complete this to-do.

Thanks,

Morgan 

Hi Morgan,
It looks like there are 6 entries appearing that were not on the Master List.  It's as though duplicates were uploaded but marked as "All Citations" instead of specific page numbers.   Example below:

Publication Report.pdf 84.2 KB • Download

OK. Thanks Irit. Please make the appropriate adjustments and then we'll migrate everything through on Tuesday.

Also, please confirm that the errors you were experiencing with the uploading tool are resolved.

Thanks,

Morgan

Hi Morgan,
I deleted the duplicates.  I then clicked "Consolidate" and received this Error message:

Error converting data type varchar to numeric.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Error converting data type varchar to numeric.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace: 

Thanks Irit .

Harsh , could you please resolve, and ensure that we can edit/add entries and consolidate without issue. We need to ensure that entries can be manually uploaded before we perform the migration to www.islg.

Morgan

Hello Morgan ,

Can you provide actual value for this corrupted data as we need to check with the actual value for resolution.

1.jpg 140 KB • Download

Also, can you perform all manual entries after migration as it would be difficult to sync all manual entries from new.islg to www.islg.

Hello Morgan ,

Above issue is resolved. As I mentioned above please provide us the value that creating corrupted data.

Hi Anil ,

The citator uploading tool appears to be working well now. Irit , will confirm how she uploaded the data to determine if the corrupt data somehow got copy/pasted from the original source.

Understood, that you'll be using the Publication Citator Master List to sync the data to ww.islg. Could you please use the following version, which has eliminated the problems in the original and should avoid the need to manually upload entries after the migration:

ISLG - Publication Citator Master -v2.xlsm 1.2 MB • Download

Harsh , the bookmarks are working well now.

Thanks,

Morgan

Paul and Irit ,

All the data for the Publication Citator should now be available on www.islg. Could you please confirm that the migration was successful. Also, please test to ensure the citator uploading tools are working so that we can maintain the site going forward.

The front-end of the Publication Citator is currently suppressed. When you've confirmed that the data is sound, we'll activate the front-end and perform our testing on the members site.

Thanks,

Morgan

This specific publication citator uploader for IC/0104/02 seems to be working well now. 

OK. We'll mark this to-do complete, and deal with other issues through fresh to-do's.

Thanks,

Morgan