Organising SFM field in Spreadsheet + unrecognised Etymology and Homonym fields
69 views
Skip to first unread message
Gede Primahadi Wijaya Rajeg
Aug 30, 2023, 12:09:48 PM8/30/23
to FLEx list
Dear FLEx users,
I am currently working on lexical database for Enggano in this project and have questions about FLEx import from spreadshet. I am using FLEx 9.
1. First question:
I have an issue with how to name/organise the column of spreadsheet with the SFM field when a given lexeme has two glosses.
In the screenshot 1 attached (original .xls file also attached), the \lx "kur" (rows 5 and 6) has two senses, namely 'from' (sense num 0, row 5) and 'origin' (sense num 1, row 6). Following the "Technical note on SFM database import" (pp. 16-17), FLEx allows nested senses but does not show how to manage that in a spreadsheet. However, my organisation in the .xls file is not recognised by FLEx (see screenshot 2) (after using Sheetswiper). I also include the .db file.
Has anyone had any experience with this? As a note, I am working on spreadsheet output of originally a FLEx database to update the current lexicon using spreadsheet for ease of collaboration with non FLEx users.
2. Second question:
While I followed the "Technical notes" to use \et and \hm as the supported fields for etymology and homonym id, these fields are not recognised when imported to FLEx and marked as "Residue" (screenshot 2 attached).
Has anyone got a similar issue?
I really appreciate your time and effort in helping me with these questions.
Best wishes,
Gede
Beth-docs Bryson
Aug 30, 2023, 4:47:59 PM8/30/23
to flex...@googlegroups.com
1. It is challenging to represent multiple senses in a spreadsheet, because a spreadsheet is not designed to handle that kind of structure. Maybe others on the list have suggestions.
2. Although the “default mapping” didn’t recognize your fields \et and \va, you can adjust the mapping. Simply click on one of those fields, then choose “Modify” at the bottom of that window, and tell FLEx which field it should map to.
Here is a playlist with videos about the most basic concepts about importing:
It doesn’t begin to scratch the surface of how to do imports, but it does cover importing from a spreadsheet and adjusting the mapping of SFM markers to fields in FLEx.
There are no doubt other questions or issues to discuss, but this might be a beginning.
-Beth
--
"FLEx list" messages are public. Only members can post.
flex_d...@sil.org
http://groups.google.com/group/flex-list.
---
You received this message because you are subscribed to the Google Groups "FLEx list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to flex-list+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/flex-list/c55f3016-c846-4a29-bc38-785ebe993806n%40googlegroups.com.
<1-nested-senses.PNG><format2.db><2-unrecognised-field.PNG><format2.xls>
Gede Primahadi Wijaya Rajeg
Aug 31, 2023, 5:59:25 AM8/31/23
to flex...@googlegroups.com
Dear Beth,
Many thanks for your responses! Really appreciate it. For the second point, yes, now I can map the residue fields using "modify" (I saw this as well in one of the video tutorials you gave, really helpful!).
For the first point, I think I managed to do the organisation of the multiple senses/glosses. I documented that step in the note attached so that I do not forget and in case anyone could use it (or could come up with a much better solution given the few caveats I found as I mentioned in point 2 in that note).
I also shared that note together with the original spreadsheet and the SFM file (and the FLEx backup on Figshare here).
Once again, thank you for your responses!
Best regards,
Gede
You received this message because you are subscribed to a topic in the Google Groups "FLEx list" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/flex-list/qxeiHksN0_o/unsubscribe.
To unsubscribe from this group and all its topics, send an email to flex-list+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/flex-list/2DF0C015-CECC-427A-B8D7-034E5AAFF37E%40sil.org.
Beth-docs Bryson
Sep 2, 2023, 3:05:14 PM9/2/23
to flex...@googlegroups.com
I’m glad the videos were helpful!
Yes, the solution you came up with for “two senses” is indeed a good solution—I’m glad you were able to figure that out!
The only thing I would add is this:
- If it’s practical, there is no reason not to edit the SFM file that SheetSwiper produces, to remove the empty senses, before you import.
The crucial thing is to end up with an SFM file that has a valid structure, a structure that FLEx knows how to import. But if you are removing an entire block (\ps, \sn, \ge, \gn) then it should be fine. If you use a tool like Notepad++, then you could make a regular expression that would search for those four (empty) markers, and remove the block all at once.
Alternatively, once it is in FLEx, you can filter for items with an empty Gloss field, and then simply delete those senses. (Hmm, you’d want to be careful to delete only the sense, not the entire entry.)
Glad you were able to do your import!
-Beth
To view this discussion on the web visit https://groups.google.com/d/msgid/flex-list/CALCOhC67YN0pUomx%2BEnsw%3Dxz8JYGM81WF0b2c5aAOs4r9dZ-8g%40mail.gmail.com.
<gpwrajeg_2023_organising-multiple-sense-of-a-lexeme-in-spreadsheet-before-FLEx-import.pdf>
Gede Primahadi Wijaya Rajeg
Sep 10, 2023, 2:56:49 AM9/10/23
to flex...@googlegroups.com
Hi Beth,
Many thanks for your regex solution! I just realised that the .db file is plain text and editable. Now it works better after replacing the empty senses before importing.
THanks again,
To view this discussion on the web visit https://groups.google.com/d/msgid/flex-list/9CB3FB49-8D62-457B-A9E0-E09CB542A4CC%40sil.org.
Reply all
Reply to author
Forward
0 new messages