Can I Import Measurements From An Excel File?

I’m not one of the users who has been pining for this feature – though I suspect it will not go unused on my system – but I feel like the measurements folders would be the right default.

:unicorn:

1 Like

I’m thinking that one should allow for it in the Preferences for those that would like a separate folder, however, for myself, I normally keep my Excell files with the pattern system book, so I really don’t know what to say.

:rofl: And can we?

In other words you would like to have a seperate export/ import default file path seperate from the Pattern and Measurement paths?

Well now that I’ve worked out the details of Importing measurements, it shouldn’t be too difficult to add an Import for the Custom variables. :slight_smile:

Also to note… while testing I came across another thing to add. The way the import was working was to just add the imported measurements to the existing loaded / imported measurements. I thought maybe maybe a user might want to overwrite the existing - adding only the imported measurements. So I added a “Merge import” option.

Checking the Merge import option merges the import with any existing (like importing from a pattern), while unchecked, the import will overwrite any existing.

I also added and Import CSV toolbutton & icon to the Toolbar:

Oh… and I also fixed the “Import from pattern” default path… it was looking in the Templates path, not the default Pattern path.

3 Likes

I think the short answer would be yes, for everyone else to have the option of creating a special folder for them and being directed straight to it when they want to import/export. It will also be good to keep a black template - with the headers - somewhere, to use as a ‘starter’ document.

:crossed_fingers::crossed_fingers::crossed_fingers:

Nice!

:star_struck:

2 Likes

I like the idea of a blank template for users, it will make it easier to see how it’s supposed to be set up ready for import. Thank you

3 Likes

You will be able to make your own template by exporting a measurement file that you use and deleting the image numbers and measurement values. That way, you’ll just be left with the headings and other necessary data.

If you use the same measurement areas for all of your clients, you can leave the image numbers in and only populate the actual measurements before importing.

2 Likes

What if I add a “clear” option that clears the value & formula fields when exporting? Although clearing some formulas can be tricky as some measurements are basically one mesurement minus another. Hmmm.

I would assume too, that once you’ve exported a (blank?) CSV you would convert that to an Excel file as your template. For the really ambtious, one could create a database and entry form based on the Excel template. :slight_smile:

2 Likes

Exactly. To be able to import a CSV file what’s important are the header names and the measurement names.Those have to be valid or we won’t really know what to do with the CSV file. It’s why I removed the “no header” option in the Export to CSV as we want to be able to identify what column is what, and if they are in the correct order.

3 Likes

I added a path pref for Import / Export"

While there is no real standard for CSV files, I changed the 1st line of the CSV to use the defacto standard comment symbol # as the 1st character in the line:

image

4 Likes

Thank you, Douglas, I have to copy from a written sheet of paper if I make any new changes, then go into Seamlyme to add the new changes. I have only used a spreadsheet a couple of times, and those were premade templates. It shouldn’t take me long to refresh my memory. Can’t wait to try the new feature.

2 Likes

Made some additions to the Import CSV.

  1. It now checks that all the table header names are included in the csv file… regardless of column order. If any of the header names are not found the import is terminated.

  2. It now maps the column data to the correct column if for some reason the columns get switched around in another app such as Excel.

3 Likes