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
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
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.
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.
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.
What do you mean by saying āthe codesā?
Can you show an example screenshot of one of those your files etc please?
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.
In which case there is no number ācodeā reference to a measurement diagram - thus the ānaā for not applicable.
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.
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.
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.
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
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.
Yes. That was what I said.
Ok I will stick to SeamlyMe for the measurements.
Thank you very much.
Iāve discovered some issues with export / import of csv measurements.
The current Export to CSV, exports the measurements translated. No Bueno. The apps work with the measurement names internally in English. Only what you see in the GUI is translated. Problem is the CSV export is simply dumping the translated table widget, and not in English as stored in a measurement file.
We canāt import translated known measurements or they would need to be treated as custom measurements. And thereās no sensible way to translate csv measurement names EXACTLY back to English. A translated csv header row also presents a problem as the column names can not be used to validate and map the data.
Basicaslly put⦠to use āknownā csv measurments a user is going to have to export to csv in English, and work with measurement names outside of Seamly - such as in Excel - in English OR just work with custom measurments.
What if only the Image Reference is exported along with the value columns?
Brilliant! But not for that reason.
What we can do is still export the names & fullnames translated⦠along with the image number and values. Then for importing I can make it disregard the names, and use the (unique) image numbers as a key to load the English names which will then get translated to whatever the current GUI language is. Currently it does the opposite when you load a measurement file⦠it uses the name as a key to find the image number. If an imported image number is not a valid number or is ānaā then itās a custom measurement where we donāt care if itās translated. In either of those 2 cases I would make sure the name is prepended with the @ so SeamlyMe treats it as custom measurement where the names can be edited.
FYI
Iām adding CSV Import to SeamlyMe.
First I cleaned up the CSV Export by refactoring & removing an uneccessary 3rd party lib RT used to model the CSV. Yay! More bloated code gone.
I also added a creation line to the header and added the Description field which was missing from the current Export:
Now to finish the Import partā¦
My hero! What can I say?
I got rid of the checkbox to make the Table header optional⦠we need the headers to validate the column when importing. Iām also considering getting rid of the Codec dropdown as UTF-8 is the default for QTextStream, and I donāt think we really need a dozen+ options. If Excel or other spreadsheets didnāt export UTF-8 it would be a different story.
Yes, I think UIF-8 is most universal and it really doesnāt matter to the user, as long as user and the software can read it.