From david.joffe at tshwanedje.com Mon Nov 21 10:04:32 2022 From: david.joffe at tshwanedje.com (David Joffe) Date: Mon, 21 Nov 2022 17:04:32 +0200 Subject: [Tshwanelex-l] Import into TLex from csv, into a list field In-Reply-To: <2af94fce-bfe3-4617-97f1-3bcda1fd0678@Spark> References: <2af94fce-bfe3-4617-97f1-3bcda1fd0678@Spark> Message-ID: <637B9380.13402.2E5AB939@david.joffe.tshwanedje.com> Hi, it would be slightly easier to advise if you could try attach a small sample CSV with at least several entries to try understand more exactly what you want to do. - David On 20 Nov 2022 at 18:03, faszikam at faszikam.com wrote: Date sent: Sun, 20 Nov 2022 18:03:04 +0100 From: faszikam at faszikam.com To: tshwanelex-l at mailman.yale.edu Subject: [Tshwanelex-l] Import into TLex from csv, into a list field > > Hello, In importing data from a csv file into TLex, the Part of > Speech field, which is populated by the names of the parts of > speech: Noun, Verb, etc, are not meshed into the Part of Speech > field in TLex which is set up as a list where you can choose one > or more of the options. Instead a new field category is created, > and populated correctly. Is there a proper way to do this, if at > all possible? If not, is there a work-around possible?? Thanks. > JJ From david.joffe at tshwanedje.com Mon Nov 21 10:04:32 2022 From: david.joffe at tshwanedje.com (David Joffe) Date: Mon, 21 Nov 2022 17:04:32 +0200 Subject: [Tshwanelex-l] Search archives In-Reply-To: References: <7da13494-1fd1-4c21-9a04-aca80d3ee02c@Spark>, Message-ID: <637B9380.5935.2E5ABA33@david.joffe.tshwanedje.com> Hmm, in theory if you do a google search but add site:mailman.yale.edu/pipermail/tshwanelex-l I would guess it should effectively then search the archive? (I also have all the posts since the start but can't - David On 20 Nov 2022 at 17:34, Claire Bowern wrote: From: Claire Bowern Date sent: Sun, 20 Nov 2022 17:34:10 -0500 To: faszikam at faszikam.com Copies to: tshwanelex-l at mailman.yale.edu Subject: Re: [Tshwanelex-l] Search archives > > I don't think so, unless you download the posts. mailman is > pretty basic; if you are logged into the web interface you should > be able to see the posting history though, > Claire > > On Sun, Nov 20, 2022 at 11:57 AM wrote: > Hello. I have not been able to find a way to search the archives. Is > there one? Thanks. JJ > _______________________________________________ > Tshwanelex-l mailing list > Tshwanelex-l at mailman.yale.edu > https://mailman.yale.edu/mailman/listinfo/tshwanelex-l > > > > -- > > Claire Bowern > Professor, Director of Undergraduate Studies > Editor: Diachronica > Department of Linguistics, Yale University > From faszikam at faszikam.com Mon Nov 21 22:38:53 2022 From: faszikam at faszikam.com (faszikam at faszikam.com) Date: Tue, 22 Nov 2022 04:38:53 +0100 Subject: [Tshwanelex-l] Follow up on import/DTD topic Message-ID: I had attempted to Reply to an email from the listserve with screenshots, but then realized it is most probably text only, so here is a text version... 1. This is a sample from my .csv file; UTF-8 with BOM PRINCIPAL_PARTS_NO_DIACRITICALS,PRINCIPAL_PARTS,SHORT_DEFINITION,LONG_DEFINITION,SIMPLE_LEMMA,PART_OF_SPEECH a ab abs,? ab abs,"from, by",(away) from; by (agency) + abl.,a,Preposition abeo abire abii abitum,abe? ab?re abi? abitum,to go away,to go away,abeo,Verb absum abesse afui afuturus,absum abesse ?fu? ?fut?rus,"to be away, be absent","to be absent, be distant",absum,Verb ac,ac,and in addition,"and in addition, or and besides; and, as well, and indeed, and; even; in comparison: as, than",ac,Conjunction accedo accedere accessi accessum,acc?d? acc?dere access? accessum,"to approach, be added, be included","to go or come to, approach; be added, be included; happen; be an additional factor (esp. impersonal + quod or ut)",accedo,Verb accido accidere accidi ???,accid? accidere accid? ???,to fall; happen,"to fall, befall, happen",accido,Verb accipio accipere accepi acceptus,accipi? accipere acc?p? acceptus,to receive,"to receive; accept; hear (of), learn (of)",accipio,Verb acer acris acre,?cer ?cris ?cre,"sharp, piercing","sharp, keen; fierce",acer,Adjective acies aciei f.,aci?s acie? f.,edge; line of battle,sharp edge; keenness; battle line,acies,Noun ad,ad,"to, up to, towards","toward, to; for the purpose or benefit of ; to suit (+ acc.)",ad,Preposition addo addere addidi additus,add? addere addid? additus,to give to,"to add, insert, bring/attach to, say in addition; increase; impart; associate",addo,Verb adduco adducere adduxi adductus,add?c? adducere add?x? adductus,"to lead to, induce","to lead up/to/away; bring up/to; persuade, induce; lead, bring; contract, tighten",adduco,Verb 2. I imported as follows: Lemma::ppnd to column 1 PRINCIPAL_PARTS_NO_DIACRITICALS - custom field Lemma::pp to column 2 PRINCIPAL_PARTS - custom field Lemma::Sense::TE::TE to column 3 SHORT_DEFINITION Lemma::Sense::Definition::Definition to column 4 LONG_DEFINITION Lemma::LemmaSign to column 5 SIMPLE_LEMMA Lemma::PartOfSpeech to column 6 PART_OF_SPEECH 3. Got warnings after import of the type: "WARNING: Rescuing potentially discarded LIST ITEM at Column 6:Verb" for each row in the csv file. The text value from the csv file wasn't somehow merged with the check-box part of speech items. This is the problem. 4. The first 5 fields were populated correctly in my TLex database. For the values in the 6th column, a new field was created, named Column6ListVal under Sense, and these were imported correctly. All of this is just a start to my understanding how to create a custom DTD for the data I already have in spreadsheets. Any pointers on more details on how to create a custom DTD schema would be greatly appreciated. Thanks in advance. JJ -------------- next part -------------- An HTML attachment was scrubbed... URL: