[Skip to main content](#vessel-content) # Importing thousands of records in 2 languages ## - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 11 years 11 months ago [\#179863](#179863) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#179863 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* was created by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* -- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions ![:)](/media/kunena/emoticons/8.png ":)") , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 11 years 11 months ago [\#179870](#179870) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#179870 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* Hi, Yes there is. In your CSV you can have such columns: product_description|nl-NL for the product description for the Dutch language if the Dutch is not your main language (for the main language, you can just use product_description). You can do the same for the product_name column. This requires to have either Falang or JoomFish installed in order to handle the product translations. The following user(s) said Thank You: [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 11 years 11 months ago [\#179941](#179941) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#179941 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* That is wonderful! Yes, we have Falang, so that shouldn' t be a problem. I am going to test it today. I am thrilled, this just saves me sooo much work! Thanks, Marjoline Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 11 years 11 months ago [\#180360](#180360) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#180360 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* I have succeeded with my first attempt, after discovering that I cannot use all delimiters when I use this techniek. Sometimes it works with ; sometimes not, it always works with a simple comma, but this can cause problems because of the comma's in the descriptions. But in the end it worked, and I am very happy. Just one last question: Can you tell me, can I translate in the same way all the other fields that get translated with Falang? So for instance: product_keywords = product_keywords|nl-NL product_meta_description = product_meta_description|nl-NL product_page_title = product_page_title|nl-NL etc. ? That would be magic! Cheers, Marjoline Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 11 years 11 months ago [\#180386](#180386) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#180386 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* Ah, ok, I have the answer. I just tried adding the above and lo and behold! It worked! Hikashop is the greatest! Cheers, Marjoline ps: Just one more little question: Is there anywhere we can find a listing of all the possible fields we can import? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 11 years 11 months ago [\#180403](#180403) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#180403 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* If you export your products, you'll get a CSV with all the possible columns (minus the translation columns as it is not yet handled by the export process) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 11 years 11 months ago [\#180558](#180558) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#180558 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* Ah, alas, not so unfortunately here. Please find attached my comparison between the Hika export fields and the hika import fields as it comes out our end.. Can you tell me how I can export in such a way as to have all the fields/columns? I mean including the missing fields (green) which are not in the export file but which are listed in the permitted columns listing? In the third column I have listed all the fields that I hoped would be permitted as foreign language fields. I hope my assumptions are correct. Cheers, Marjoline Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 11 years 11 months ago [\#180563](#180563) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#180563 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* Hi, The export of these fields is not supported yet by the export (like for the translation columns). It would require developing the capability and it's not just 2 lines of code. The following user(s) said Thank You: [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 11 years 11 months ago [\#181288](#181288) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#181288 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* Hi, thanks for your reply. I understand that it could be quite a bit of work. Are there any plans in the near future to develop this? Or do we need to find a way to link to the underlying MySQL tables to get the information out where we can use it? I have been told this is not necessarily very easy due to security issues when linking directly from a local MS Access application to a remote MySQL database. This is why the complete export file functionality would be very welcome. Kind regards, Marjoline Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[korzo](/forum/user/34428-korzo "View korzo's Profile")** - [![korzo's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar34428.png)](/forum/user/34428-korzo "View korzo's Profile") - [ Offline](/forum/user/34428-korzo) Less More - Posts: 193 - Thank you received: 76 - - 11 years 11 months ago [\#181294](#181294) by [korzo](/forum/user/34428-korzo "View korzo's Profile") Replied by *[korzo](/forum/user/34428-korzo "View korzo's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#181294 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* I think it shouldn't be hard to add translation column to your export using MS Access. Also you don't have to necessary connect to remote database. You can use Akeeba Backup + Remote CLI + mysql command to clone your remote database to local environment using one click. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")** - [![Marjoline's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/gallery/time_eye.jpg)](/forum/user/32405-marjoline "View Marjoline's Profile") Topic Author - [ Offline](/forum/user/32405-marjoline) Less More - Posts: 52 - Thank you received: 0 - - 11 years 11 months ago [\#181295](#181295) by [Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile") Replied by *[Marjoline](/forum/user/32405-marjoline "View Marjoline's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#181295 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* Ah, that is an excellent idea! Thank you. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[christina17](/forum/user/30738-christina17 "View christina17's Profile")** - [![christina17's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/30738-christina17 "View christina17's Profile") - [ Offline](/forum/user/30738-christina17) Less More - Posts: 14 - Thank you received: 0 - - 7 years 10 months ago [\#301118](#301118) by [christina17](/forum/user/30738-christina17 "View christina17's Profile") Replied by *[christina17](/forum/user/30738-christina17 "View christina17's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#301118 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* Hello, I tried to import multilangual records this way. I have falang and all the settings are ok. When I import the normal file without the extra columns it all goes well. When I try to import the extended file with the translations coliumns for german, englisch and french, I get a whole page with red remarks and nothing is imported. I attach the two files. Thank you for your help. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86315 - Thank you received: 14276 - - 7 years 10 months ago [\#301179](#301179) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Importing thousands of records in 2 languages](/forum/37-import-export-csv-xls/873052-importing-thousands-of-records-in-2-languages#301179 "-- HikaShop version -- : Latest -- Joomla version -- : Latest -- PHP version -- : Latest -- Browser(s) name and version -- : All -- Error-message(debug-mod must be tuned on) -- : No error, just an inquiry. Hi, We are on the last laps of building our Hikashop webshop for guitarbuilding and guitar parts. I am preparing the imports from the suppliers. These will be imports of 2000+ records. They are supplied to me with Dutch and English columns/descriptions. Is there any way of importing these so that the fields for Language 1 and Language 2 are filled with the right descriptions :) , or do I have to type everything over screen-by-2000+ screens for each of the products? :S So far you've come up with good workable solutions for each for each of my questions. Can you tell me, is there a simple Hika-solution for this one also? Cheers, Marjoline")* Hi, I don't see any problem with the columns for the languages. However there are problems with the price data and a problem with an extra column with a | for the products: [ monosnap.com/file/K3lM5xbmxlIiMGaOo0wdvDPbYLyCNT](https://monosnap.com/file/K3lM5xbmxlIiMGaOo0wdvDPbYLyCNT) Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtL2ltcG9ydC1leHBvcnQtY3N2LXhscy84NzMwNTItaW1wb3J0aW5nLXRob3VzYW5kcy1vZi1yZWNvcmRzLWluLTItbGFuZ3VhZ2VzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop- Install & Update- Product & Category Display- Content Creation- Sales and Orders- - Orders management- - Reports & Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import & Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel & Slider- - Mass Actions- - Filters & Search- - Discount & Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.219 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org) [](#top)