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

Ok we talked about can we import measurements as excel file now maybe we can talk about how to import measurements as csv file.

Quesiton 1) Maybe can we create a csv template which can be recognized by Seamly2D by exporting the measurements of the manually created pattern as .csv file on Seamly2D?

It is just theory. Is it possible?

Question 2) For multi sizes?

I’m trying to make the process of creating a pattern and grading a lot faster and efficient.

1 Like

No need? You can already import the measurments into SeamlyMe:

This works because the measuerments are already validated. A csv file could be anything and we have to validate the data against the measurement schema and known measurements.

AgainL No need.

2 Likes

The problem that I have with this is that it only imports the measurement areas actually used in the pattern and not the ones that haven’t been used. Although it is very handy.

Perhaps an Import from SeamlyME will work better since it will have all of the measurement areas and will also already be validated.

The only problem with both of these methods is that it doesn’t import values.

And then…

Most people with any bookkeeping experience know how to handle CSV files and understand the importance of using valid codes and numbers, organising the columns into a specific order for importing into software and manually checking that everything is in order before importing a CSV into program. So I still don’t see why we can’t have a very simple Export to CSV to create a template and a very simple Import from CSV bring into SeamlyME. However, I know that you’re currently very busy with something else that’s very exciting, so I wait patiently :star_struck:

1 Like

Understood… but there’s good reason why we “idiot proof” software. Plus with SeamlyMe is goes beyond just checking if known names and values are correct… measurements often have to be in the correct order due to formulas… such as:

Aa… that’s called “Open”.

True.

Well we already have an Export to CSV in SeamlyMe… and there’s no such thing as a CSV template.

As I said before it’s easy to import a CSV, but without any validating there’s going to be issues with producing corrupted measurement files or worse SeamlyMe crashing.

2 Likes

Yes. That was what I said.

Ok I will stick to SeamlyMe for the measurements.

Thank you very much.