[<Solved> How to use csv import for many colors & sizes for a single product?]

@alwayspaws There's no contradiction with my explanations. When you use the 'Reference' field it is up to you with your own numbering scheme.

But the IDs are assigned authomatically, if you change them manually, you will breal the links between products and their combinations, et c.

[<Solved> How to use csv import for many colors & sizes for a single product?]

Look: PRODUCTID is the 'artifical' index and primary key of 'products' table, it assigned automatically and should not be changed. The PRODUCTID field in the 'COMBINATIONS' table and in the combinations csv is binding with the 'products' table. So, when you have lets say 10 combinationsof one product, then you should have 10 lines in the combinations CSV, each of them starting with the same number. And this number MUST be equal with corresponding product_id in the 'products' table

[Transformer Theme = How Compatible?]

@vincentdenkspel said in Transformer Theme = How Compatible?:

I’ve contacted the developer of the transformer theme if he has the intention to make the transformer 4 theme compatible with TB. He said he has not.

I've read some discussion about it on the themeforest. Transformer V4 has been designed only for PS1.7 so it has a lot of differences compared to transforver V3 which is only for PS1.6/TB. That's why theme's author won't make transformer v4 compatible with TB

[Transformer Theme = How Compatible?]

If we talk about transformer/panda theme then i have to note one nuance: those themes contains really a lot of modules and thus i make conclusion, that this themes could not be made by one man, i suppose it has been made by a studio/company. So, if we want to start similar crowdfunding project, then we have to take in account need of paying the group of devs, designers, translators, and so on. I think this is more complicated task in comparison to make module for binding elastic search to the TB.

[Transformer Theme = How Compatible?]

@vincentdenkspel I thought you were a leader of that project. I like your idea with crowdfunding. From another hand, i see possible issue (perhaps that's why @occam is so sceptic): a theme itself is a) usually commercial product, b) could be even more complicated compared to product itself (not only development, but also support)

So, who and how will support theme? It requires a separate department if not an agency.

However, will repeat, i like your idea

[Is there a way to use an svg logo instead of png or jpg?]

I've tried to use svg in the custom contents. In that case you should paste the svg source into tinyMCE. There's one trick for it (https://world.episerver.com/Modules/Forum/Pages/Thread.aspx?id=114996) , otherwise tinyMCE will delete all svg:

1. Always have a name attibute for the svg element: <svg name="something"
2. Always have a data-mce attribute for the svg element: <svg data-mce-something="something"
3. Include some text content within the svg element: Using these techniques i could succesfully store inline svg in an xhtml property

All this means, you have to edit appropriate .tpl manually

[Transformer Theme = How Compatible?]

@vincentdenkspel Just as info: that module - is it your project? If yes, could you tell me more about this module's crowdfunding story?

[<Solved> How to use csv import for many colors & sizes for a single product?]

Yes, that's right

[<Solved> How to use csv import for many colors & sizes for a single product?]

@alwayspaws I've made a field separator as ^ sign, so at the import you should set this symbol as a field delimiter.

[<Solved> How to use csv import for many 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

[<Solved> How to use csv import for many 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 :)

[<Solved> How to use csv import for many colors & sizes for a single product?]

@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?

[<Solved> How to use csv import for many colors & sizes for a single product?]

I'm sorry, i just imported the combinations. I have no any image and product, so i can't show you much. I just opened the combinations tab in the BO, and saw, that combinations were imported. Actually, i didn't imported all of them because had to go off the office. I can do complete import again within 2 hours.

So, the process is following: 1. In the l.o. calc i open .ods and chose file->save as... , save dialog appears. I set the flag "edit filter settings" 2. In the filter settings dialog i chose a ^ sign as a field delimiter (just because it used rarely, so will avoid possible ambiguities like with commas, semicolons, quotes, et c.), and semicolon as a text delimiter. Also i set the flag "Quote all text cells" 3. After tis the impirt process is made as usual in the TB's BO.

I've figured out, that your file's column structure does not match with one required by TB's BO import tool

[<Solved> How to use csv import for many colors & sizes for a single product?]

I've imported just combinations, used ^ as field delimiter and semicolon as value delimiter. Also when exported as csv i used option to embrace string fields in double quotes.

[<Solved> How to use csv import for many colors & sizes for a single product?]

@alwayspaws Probavly, success?

[<Solved> How to use csv import for many colors & sizes for a single product?]

Can i ask you to send the original ods file? I'll try on my snadbox. ichest@gmail.com

[<Solved> How to use csv import for many colors & sizes for a single product?]

@alwayspaws You'll be angry with me.... Perhaps, it would be better to try manual import via the phpmyadmin or HeidiSQL? And i froget to mension - i use the double quote for text

UPD: tried 2 open your CSV in the Libreoffice calc - everything is Ok, i set the flag "Quoted field as text" - everything is perfect.

[<Solved> How to use csv import for many colors & sizes for a single product?]

I use semicolon as a field delimiter too. The comma is a source of difficulties. All "string" fields i embrace with quotes.

[Can't install module. Receive error message...]

@club3m You have to review the 'override' folder in your TB installation folder. It is obvious, that there is a module in your TB installation which already overrides the standard one, thus stopping your installation.

[How migrate products comments from Pshop1.6]

That's why i adviced to try the HeidiSQL. It has an option for database dump, which force to generate not "DROP TABLE", but "DELETE FROM TABLE" instead - i did exactly this way and managed to transfer data from one database to another

[How migrate products comments from Pshop1.6]

@x97wehner I mensioned Heidi just because this is a tool for "not dba" people, it could help you with various options, which you may not have to know.

More important is sql clauses i've pasted from my dump. This is what switches off the table keys before inserting data and switches on that keys after data inserts complete

[Transformer Theme = How Compatible?]

@occam Exactly! That's why i've lost any motivation for further translation of transformer onto my language. The conclusion is... we have to motiv8 ourselves somehow to make a theme much better than notorious transformer? :)

[How migrate products comments from Pshop1.6]

There's following SQL clauses in the SQL dump, check, whether it present in your SQL dump: Before inserting table data: /!40000 ALTER TABLE your_table_name DISABLE KEYS */; After inserting table data /!40000 ALTER TABLE your_table_name ENABLE KEYS */;

If not, just add it manually, or make dump again, with appropriate options. Try to use HeidiSQL for this.

[Let's talk about Search!]

@dynambee Thanks for information Ian. It will be very useful for me soon :)

[Transformer Theme = How Compatible?]

There's one more issue to discuss: the Transformer/Panda themes are commercial, and author earns valuable income from it. Community agree to make translations by own efforts, but, IMHO, the author should give for it some binuses. For instance, extended support and/or discount for buying his another products.

UPD. just invented an idea: let's open a theme translation project on the launchpad under more or less restrictive license spuring theme's author for givin some 'mature' motivation for community :)