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.