Thanks Howard for brainstorming with me. also for anyone who is facing the same challenge with many LTI's unsigned here's my best workaround so far until I learn a better way:
First I abandoned adding a single new mysql row in the table mdl_lti and and mass importing rows as both were problematic maybe due to the servicesalt being null not sure what that is but correctly working fields have a value there and I don't know how it is created.
My new process which at least saves a little time:
1. duplicate a working LTI in any course say 100 times (this example shows just 1) and then
2. go to mysql find it's id number in adminer and then
3. run an update command to fix whatever you need to fix like this example
update mdl_lti set name = 'Biography: John J. Pershing', toolurl = 'https://www.pearsonrealize.com/community/lti/realize/launch/01a439bf-c590-3cb8-8cad-ed1a4bc0252c/viewer', password = 'some-number-from-your-provider', resourcekey= 'some-number-from-your-provider'
where ID = 158
This worked right away in Moodle without even purging cache.
Unzip your imscc file and you'll find the imsmanifest file deep within the folder, open that file with notepad +. Inside you will see each title and it's identifier number which points to one of many many folders each with an xml file which if you open it in notepad basically tells you the title again and the launch url which is all you need to make each lti work (besides the key and secret added elsewhere)
However, rather than opening each file folder it's easier to just use the IMSManifest because the identifier number in my case (all Pearson imscc files I hope) is the same number used in the url I need it's just a truncation:
example, in imsmanifest file you see this title and identifier
identifier="I_0dcdd503-c286-3c3b-9a73-835c35e864d8_R"> <title>Geography Core Concepts: Teacher Support</title>
Now, if I were to look within a folder named I_0dcdd503-c286-3c3b-9a73-835c35e864d8_R I would find the title and the needed url:
<blti:title>Geography Core Concepts: Teacher Support</blti:title>
rather than open thousands of folder to find that url just used excel (or better vba) to first find each instance of
identifier="I_ in the file imsmanifest
and then copy the next 36 consecutive numbers and concatenate the number like this
take all these values and use an update mysql statement like the example at the very top and here (remember to use ' at start and end of each:
update mdl_lti set name = 'Geography Core Concepts: Teacher Support', toolurl = 'https://www.pearsonrealize.com/community/lti/realize/launch/0dcdd503-c286-3c3b-9a73-835c35e864d8/viewer', password = 'some-number-from-your-provider', resourcekey= 'some-number-from-your-provider'
where ID = 158
I hope this helps someone. back up your database first
Howard - I would like to know that there are no other dependent tables and see there are a couple of tools to find dependencies but in a graphical interface. My ubuntu is not graphical and I don't know either in the server mysql nor in adminer online how to find dependent tables. I'm hoping LTI is such a small part of moodle that mdl_lti is the only table I need to worry about.
I attached the imsmanifest so you can see it. I had to delete a few hundred lines and zip it so it was below 500kb but those lines are just more links all with the same basic format at the thousands above it.