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