Can I Import Measurements From An Excel File?

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:

image

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

@optimusprime93

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