Can I Import Measurements From An Excel File?
Can I Import Measurements From An Excel File? If yes how? Rather than creating them on SeamlyMe
2 Likes
No, not at the moment. This will involve creating a comma delimited file with headings in a certain format that can read by SeamlyME.
It is in the Github issues and is still pending.
What I do is I create an Excel document with the codes and information that I wish to put into the file, including the codes, then I open SeamlyME and place both files next to each other on the screen. Then I open all of the Known codes in the order that they appear on my Excel list, click on OK when done. As you place a checkmark at the codes, it adds the code to the list so that theyāre in the order of the Excel list.
Then I go & enter all of the base & increment values, just going down the list in SeamlyME.
It doesnāt take long.
1 Like
Itās a pretty simple task to import a csvā¦ Iāve already played around with an csv import routine. Problem is validating the csv. First you have to make sure thereās the correct number of columnsā¦ and then āassumeā the data in that column is correct. In other words any Excel template has to match the SeamlyMe format. Then if adding a āknownā measurement, it has to be checked against the known database for correct name, full name, diag num, etc. Thereās a whole bunch of other features an import shoiuld include, but itās beyond the scope of this topic.
2 Likes
Thank you, @Douglas, once again, youāre amazing.
Just putting it out thereā¦ Wouldnāt it be easier to just have 3 columnsā¦ Code, base value & increment? Unknown codes can be added later by hand.
I feel that the Unknowns shouldnāt feature since theyāre not part of the actual program, but we could have the @code as the code with the values and the names can be added later by the person using it.
1 Like
What do you mean by saying āthe codesā?
Can you show an example screenshot of one of those your files etc please?
2 Likes
Sorry, theyāre not really ācodesā, theyāre just reference numbers to measurement areas:
The Known have numbers like the one highlighted in the list - G04 - This is what I mean by āCodesā. The items that are not in the Known may be added as Custom, in which case they get @ in front of their name.
The Known measurement areas are linked to images that show the area to be measured.
1 Like
In which case there is no number ācodeā reference to a measurement diagram - thus the ānaā for not applicable.
2 Likes
I can think of quite a few ways to tackle the validation problem (based on doing this sort of thing A LOT in many different applications) butā¦like Douglas saidā¦beyond the scope of the original question.
1 Like