Transcribe Servlet and Project Names #177
Assignees
Comments
mysql> select count(*) from project where name like CONCAT('%', 'paleography:' ,'%');
+----------+
| count(*) |
+----------+
| 805 |
+----------+
1 row in set (0.00 sec)
mysql> select distinct name from project where collection="french";
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| name |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| paleography:440 |
| paleography:434 |
| paleography:448 |
| paleography:455 |
| paleography:438 |
| paleography:459 |
| paleography:473 |
| paleography:458 |
| paleography:450 |
| paleography:489 |
| paleography:488 |
| paleography:477 |
| paleography:418 |
| paleography:478 |
| paleography:492 |
| paleography:437 |
| paleography:451 |
| paleography:472 |
| paleography:487 |
| paleography:464 |
| paleography:404 |
| paleography:436 |
| paleography:475 |
| paleography:466 |
| paleography:446 |
| paleography:441 |
| paleography:449 |
| paleography:442 |
| paleography:500 |
| paleography:471 |
| paleography:502 |
| paleography:453 |
| paleography:443 |
| paleography:470 |
| paleography:468 |
| paleography:465 |
| paleography:452 |
| paleography:422 |
| paleography:469 |
| paleography:490 |
| paleography:474 |
| paleography:481 |
| paleography:467 |
| paleography:494 |
| paleography:495 |
| paleography:485 |
| paleography:498 |
| paleography:447 |
| paleography:461 |
| paleography:445 |
| paleography:444 |
| paleography:483 |
| paleography:484 |
| paleography:454 |
| paleography:496 |
| paleography:486 |
| paleography:457 |
| paleography:493 |
| paleography:456 |
| paleography:499 |
| paleography:460 |
| paleography:480 |
| paleography:479 |
| paleography:497 |
| paleography:463 |
| paleography:439 |
| paleography:435 |
| paleography:476 |
| paleography:501 |
| paleography:482 |
| paleography:462 |
| paleography:430 |
| paleography:491 |
| paleography:1816 |
| paleography:2055 |
| paleography:1817 |
| paleography:1814 |
| paleography:1807 |
| Contracts, charters, financial records of the St. Lambert's Cathedral in Liège |
| Acknowldgement of patronage |
| Agreement to join fiefs |
| Discours et harangue des ambassadeurs du Roy avec ceulx d'Angleterre touchant le pourparler du mariage d'entre monseigneur le duc d'Anjou et d'Alençon avec la Royne d'Angleterre |
| Ethica ad Nicomadum [Translation by Nicole Oresme] |
| Homage for fiefs (Acknowledgement of fiefs) |
| Harangue faicte à la Royne mere du Roy à Poictiers par le seigneur de Salevert, presidial de ladicte ville, le lendemain de son arrivée qui fut le vingt huictiesme novembre 1575 |
| Hommage de Jehan Vepres, dit le Moine à son frère, pour un fief |
| Itinerarium [French] |
| L'enfant sage à trois ans [qui] fut interrogé par Adrian empereur lequel luy rendit responce de chacune chose qui luy demande |
| La Charité quittance |
| Le roman de Tristan de L▒onois |
| Leasing contract |
| Lectures on the Charter of the Forests, reissued by Henry III in 1225 |
| Legal notebook |
| Les croniques de Nicolas Trivet |
| Letter signed from Philip II, King of Spain, to his nephew Rudolf II, Holy Roman Emperor |
| Memoranda about Charles d'Orléans's rights as Count of Blois |
| Negotiations at Calais |
| Payment au nain de la reine |
| Quittance for payment for military expenses in Picardy |
| Receipt for repairs made to the castle of Rochefort |
| Roman de Mandevie : les melancolies sur les conditions de ce monde |
| Troisieme registre des contracts d'acquets faits dans l'etendue du fief et seigneurie de l'Epiniere |
| Acte de foy et hommage au profit de noble homme Claude de Vignes, seigneur de la Vischardière |
| Fables and other poems |
| Land sale by Pierre le Canu |
| Payment for the defense of Guyenne |
| Letter of John Stanlawe to John Randulf, viscount of Caen, regarding a program of repairs to be made at the castle of Caen |
| Account book |
| La Charit▒ quittance |
| L'enfant sage ▒ trois ans [qui] fut interrog▒ par Adrian empereur lequel luy rendit responce de chacune chose qui luy demande |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
110 rows in set (0.01 sec)mysql> select distinct name from project where name like CONCAT('%', 'paleography:' ,'%');
+------------------+
| name |
+------------------+
| paleography:440 |
| paleography:434 |
| paleography:448 |
| paleography:455 |
| paleography:438 |
| paleography:459 |
| paleography:473 |
| paleography:458 |
| paleography:450 |
| paleography:489 |
| paleography:488 |
| paleography:477 |
| paleography:418 |
| paleography:478 |
| paleography:492 |
| paleography:437 |
| paleography:451 |
| paleography:472 |
| paleography:487 |
| paleography:464 |
| paleography:404 |
| paleography:436 |
| paleography:475 |
| paleography:466 |
| paleography:446 |
| paleography:441 |
| paleography:449 |
| paleography:442 |
| paleography:500 |
| paleography:471 |
| paleography:502 |
| paleography:453 |
| paleography:443 |
| paleography:470 |
| paleography:468 |
| paleography:465 |
| paleography:452 |
| paleography:422 |
| paleography:469 |
| paleography:490 |
| paleography:474 |
| paleography:481 |
| paleography:467 |
| paleography:494 |
| paleography:495 |
| paleography:485 |
| paleography:498 |
| paleography:447 |
| paleography:461 |
| paleography:445 |
| paleography:444 |
| paleography:483 |
| paleography:484 |
| paleography:454 |
| paleography:496 |
| paleography:486 |
| paleography:457 |
| paleography:493 |
| paleography:456 |
| paleography:499 |
| paleography:460 |
| paleography:480 |
| paleography:479 |
| paleography:497 |
| paleography:463 |
| paleography:439 |
| paleography:435 |
| paleography:476 |
| paleography:501 |
| paleography:482 |
| paleography:462 |
| paleography:430 |
| paleography:491 |
| paleography:1816 |
| paleography:2055 |
| paleography:1817 |
| paleography:1814 |
| paleography:1807 |
+------------------+
78 rows in set (0.01 sec)For those 78 projects, their metadata.title is also paleography:1234 These are the 32 unaffected French master transcriptions that the static pages work with today, except for the ones with diacritic issues those don't work today but we already know that and know to fix it -----------------------------+ |
| Contracts, charters, financial records of the St. Lambert's Cathedral in Liège |
| Acknowldgement of patronage |
| Agreement to join fiefs |
| Discours et harangue des ambassadeurs du Roy avec ceulx d'Angleterre touchant le pourparler du mariage d'entre monseigneur le duc d'Anjou et d'Alençon avec la Royne d'Angleterre |
| Ethica ad Nicomadum [Translation by Nicole Oresme] |
| Homage for fiefs (Acknowledgement of fiefs) |
| Harangue faicte à la Royne mere du Roy à Poictiers par le seigneur de Salevert, presidial de ladicte ville, le lendemain de son arrivée qui fut le vingt huictiesme novembre 1575 |
| Hommage de Jehan Vepres, dit le Moine à son frère, pour un fief |
| Itinerarium [French] |
| L'enfant sage à trois ans [qui] fut interrogé par Adrian empereur lequel luy rendit responce de chacune chose qui luy demande |
| La Charité quittance |
| Le roman de Tristan de L▒onois |
| Leasing contract |
| Lectures on the Charter of the Forests, reissued by Henry III in 1225 |
| Legal notebook |
| Les croniques de Nicolas Trivet |
| Letter signed from Philip II, King of Spain, to his nephew Rudolf II, Holy Roman Emperor |
| Memoranda about Charles d'Orléans's rights as Count of Blois |
| Negotiations at Calais |
| Payment au nain de la reine |
| Quittance for payment for military expenses in Picardy |
| Receipt for repairs made to the castle of Rochefort |
| Roman de Mandevie : les melancolies sur les conditions de ce monde |
| Troisieme registre des contracts d'acquets faits dans l'etendue du fief et seigneurie de l'Epiniere |
| Acte de foy et hommage au profit de noble homme Claude de Vignes, seigneur de la Vischardière |
| Fables and other poems |
| Land sale by Pierre le Canu |
| Payment for the defense of Guyenne |
| Letter of John Stanlawe to John Randulf, viscount of Caen, regarding a program of repairs to be made at the castle of Caen |
| Account book |
| La Charit▒ quittance |
| L'enfant sage ▒ trois ans [qui] fut interrog▒ par Adrian empereur lequel luy rendit responce de chacune chose qui luy demande |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ |
|
|
|
sql for id_name table that compares what we need. |
thehabes
added
the
migration
|
Can match one to the other |
|
Golden. |
|
Here's the fix:
|
|
|
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
The front end static pages communicates with T-PEN like
<a href="http://newberry.rerum.io/paleography/transcribe/Cartulaire de l'Abbaye-aux-Bois" id="transcribeLink">Transcribe with TPEN</a>This gets a 500.
getMasterProject()fails because it is looking in the TPEN_NL mysql database for a project.name = "Cartulaire de l'Abbaye-aux-Bois" which is from the manifest.label (see https://iiif.library.utoronto.ca/presentation/v2/paleography:2055/manifest)In the MySQL database, project.name for this is
paleography:2055, notCartulaire de l'Abbaye-aux-Bois.The transcribe serlvet has no programmatic way to connect
Cartulaire de l'Abbaye-aux-Boiswithpaleography:2055.The static pages know
Cartulaire de l'Abbaye-aux-Boisandpaleography:2055are the same manuscript. The static pages have to discern which title or pass, or they have to pass both possible titles.Alternatively, we could update all project names that are currently
paleography:2055to beCartulaire de l'Abbaye-aux-Bois. Know that there are 78 master projects like this, and 805 total projects like this. 805 because each master manuscript has many projects copied from it, and the copied projects behave the same way as far as project.name goes. Originally we did not rely on the project name, we relied on a substring of the manifest @id. We changed things up to be cleaner, but left these 805 projects behind.From a user's point of view, their project names do not line up with the manuscript listing name. In my project list, my project is titled
paleography:2055(from when this would have worked previously) notCartulaire de l'Abbaye-aux-BoisThe text was updated successfully, but these errors were encountered: