jnsgioia Posted October 12, 2017 Share Posted October 12, 2017 The important thing is to have a different symbol as a field delimeter and a multivalue delimiter. In your first csv you were using a comma for both. Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 OK, moving full steam ahead - for the 20th time today! lol Link to comment Share on other sites More sharing options...
jnsgioia Posted October 12, 2017 Share Posted October 12, 2017 @alwayspaws :) hope it works this time :) Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @jnsgioia Me, too. :) Trying now! Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 So I tried twice and got this error now: Errors occurred: Dog Clothes; Dog Hoodies (ID: null) cannot be saved Property Category->name is not valid Dog Clothes; Dog Hoodies cannot be saved Before, it was working with categories field like this: Dog Clothes; Dog Hoodies Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @daokakao by the way, I sent you the actual whole original .ods but things have changed since then. The combination names are size,color since that was fixed, instead of size;color. I removed all the products except the hoodie for all these tests. The image url is also updated in my latest ones. Just letting you know. Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @jnsgioia I know you can't spend your whole life trying to fix this, so don't worry about leaving. :) Link to comment Share on other sites More sharing options...
jnsgioia Posted October 12, 2017 Share Posted October 12, 2017 Ok, I think I now see your problem. Am I correct in that in the file you sent to @DaoKakao you had a semi colon between size and color and you changed it to a comma recently? Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 No that isn't the problem. It was changed months ago by Mdekker. That's why I wrote @DaoKakao that note just now. Here is how I work with spreadsheets: I first save as .ods so I can highlight and copy and replace as much as I need to. Once it looks good, I convert it to .csv. Then I upload it. Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 I need to see why I have these errors suddenly, even though those categories have existed since the very beginning. Errors occurred: Dog Clothes; Dog Hoodies (ID: null) cannot be saved Property Category->name is not valid Dog Clothes; Dog Hoodies cannot be saved Link to comment Share on other sites More sharing options...
jnsgioia Posted October 12, 2017 Share Posted October 12, 2017 The problem is in the file you first posted you have a comma between your fields as well as between size and color. In the error you just got it is because for categories you are using a semi colon as a multivalue separator but you told the upload that the multivalue separator is a comma. I think if you change the comma between the size and color to a semi colon and save the file with the field separator as a comma it should work. Do I now have you completely confused? :) Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 OK I'll change back to size;color but all we are doing is reversing all the work that was fixed two months ago. :( Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 What I need is to be able to create .ods and work on it and convert it to .csv when I'm ready. Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @jnsgioia Is this correct? To open csv's: To open the csv: select comma. Then go to save as copy. On the first popup box make sure “edit filter settings” is checked. Then on the second popup box make sure the field delimiter that is checked is the semicolon. Make sure the box that says “save cell content as shown” IS CHECKED. on admin csv import page: field separator as a semicolon and the multivalue as a comma Link to comment Share on other sites More sharing options...
DaoKakao Posted October 12, 2017 Share Posted October 12, 2017 @alwayspaws Why don't you make a sandbox environments for new features testing? It will ease your life. I can send my version of CSV for you. just try to import it? Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @DaoKakao I don't know how. I wish I did! By the way I use a Mac. I tried Xampp, etc last year and just couldn't get it to work. Is that what you mean for the sandbox? Yes, I'd like to try your version of the CSV. Thank you. Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @jnsgioia so now I have size;color and categories are: Dog Clothes; Dog Hoodies I tried to import and now I got this again: Errors occurred: Dog Clothes; Dog Hoodies (ID: null) cannot be saved Property Category->name is not valid Dog Clothes; Dog Hoodies cannot be saved Validating data... Link to comment Share on other sites More sharing options...
jnsgioia Posted October 12, 2017 Share Posted October 12, 2017 Did you save it with field delimeter - comma and import it (in tb bo) with field delimiter comma multivalue ; (opposite of what I told you above) Link to comment Share on other sites More sharing options...
DaoKakao Posted October 12, 2017 Share Posted October 12, 2017 Sandbox is kind a sandox for playing around with new features/modules/themes, et c. - i.e. this is testing installation of your shop, not for production. I use more windows PC, so it would be bit difficult to explain some things about macs, but this isn't impossible :) Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @jnsgioia said in How do I use a csv import for a large amount of colors & sizes for a single product?: Did you save it with field delimeter - comma and import it (in tb bo) with field delimiter comma multivalue ; (opposite of what I told you above) @jnsgioia said in How do I use a csv import for a large amount of colors & sizes for a single product?: Did you save it with field delimeter - comma and import it (in tb bo) with field delimiter comma multivalue ; (opposite of what I told you above) on admin csv import page: field separator is a semicolon and the multiple value is a comma Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @daokakao said in How do I use a csv import for a large amount of colors & sizes for a single product?: Sandbox is kind a sandox for playing around with new features/modules/themes, et c. - i.e. this is testing installation of your shop, not for production. I use more windows PC, so it would be bit difficult to explain some things about macs, but this isn't impossible :) Is this something I have to pay for? I can try it without bothering you. :) I'm currently using a test copy of my site in TB. Link to comment Share on other sites More sharing options...
jnsgioia Posted October 12, 2017 Share Posted October 12, 2017 @alwayspaws reverse them :) If you save the csv with a comma delimiter have the tb field separator comma, if you save it with a semi colon have the tb field delimiter semi colon Link to comment Share on other sites More sharing options...
DaoKakao Posted October 12, 2017 Share Posted October 12, 2017 @alwayspaws No, this is free - you should organize a sandbox by yourself. Here's an alternative for XAMPP: https://www.mamp.info/en/ - for MAC. If you encounter the problems with APACHE/NGINX configuration - i can help you @alwayspaws said in How do I use a csv import for a large amount of colors & sizes for a single product?: I’m currently using a test copy of my site in TB. This is exactly what the sandbox is Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @jnsgioia This is very confusing. Link to comment Share on other sites More sharing options...
alwayspaws Posted October 12, 2017 Author Share Posted October 12, 2017 @daokakao said in How do I use a csv import for a large amount of colors & sizes for a single product?: @alwayspaws No, this is free - you should organize a sandbox by yourself. Here's an alternative for XAMPP: https://www.mamp.info/en/ - for MAC. If you encounter the problems with APACHE/NGINX configuration - i can help you @alwayspaws said in How do I use a csv import for a large amount of colors & sizes for a single product?: I’m currently using a test copy of my site in TB. This is exactly what the sandbox is I will try that. I'm having problems with the import. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now