Import more then one line in description

Import more then one line in description

Avatar image
Oct 09, 2016
Jos wrote
HI,

How can I make a automatic import with this CSV information available?
Product reference number: 1742366
Outcome must be in long description like this:
Nr. 1 Show Me A Leader - Alter Bridge - Side1 - Duration 5:05 (etc. etc for the lines below)
Nr. 2 The Writing On The Wall - Alter Bridge - Side1 4:28
Nr. 3 The Other Side - Alter Bridge - Side1 5:55
4 My Champion - Alter Bridge 1 4:41
5 Poison In Your Veins - Alter Bridge 1 4:19
6 Cradle To The Grave - Alter Bridge 1 5:41
7 Losing Patience - Alter Bridge 1 4:10
1 This Side Of Fate - Alter Bridge 2 6:48
2 You Will Be Remembered - Alter Bridge 2 4:42
3 Crows On A Wire - Alter Bridge 2 4:27
4 Twilight - Alter Bridge 2 4:15
5 Island Of Fools - Alter Bridge 2 5:01
6 The Last Hero - Alter Bridge 2 6:42
7 Last Of Our Kind (Bonus Track) - Alter Bridge 2 5:34

Product reference number: 1742367
Nr. 1 Show Me A Leader - Alter Bridge - Side1 - Duration 5:05 (etc(etc for the lines below)
2 The Writing On The Wall - Alter Bridge 1 4:28
3 The Other Side - Alter Bridge 1 5:55
4 My Champion - Alter Bridge 1 4:41
5 Poison In Your Veins - Alter Bridge 1 4:19
6 Cradle To The Grave - Alter Bridge 1 5:41
7 Losing Patience - Alter Bridge 1 4:10
1 This Side Of Fate - Alter Bridge 2 6:48
2 You Will Be Remembered - Alter Bridge 2 4:42
3 Crows On A Wire - Alter Bridge 2 4:27
4 Twilight - Alter Bridge 2 4:15
5 Island Of Fools - Alter Bridge 2 5:01
6 The Last Hero - Alter Bridge 2 6:42
7 Last Of Our Kind (Bonus Track) - Alter Bridge 2 5:34

Product reference number: 1742368
Etc. etc.

This far is my knowledge about SQL
"Nr. "[CSV_COL(2)] " - " [CSV_COL(3)] " - Side " [CSV_COL(4)] " - Time " [CSV_COL(5)]

Thanks
Reply
11 Answers
Avatar image
Oct 10, 2016
Dmytro Grycelyak agent wrote
Hello Jos,

Import Wizard of Store Manager allows merging the columns, however, only 1 row will be imported for 1 product.

You will have to merge the rows (related to one product) in Excel previously and then proceed with the import.
Avatar image
Oct 12, 2016
Jos wrote
Hi Volodymyr,

I tried with "|" ";" etc. in the last column(F).

But...
How to merge? (in LibreOffice *.ods file)

Now it's paste and copy more the 4000 Vinyl's :>((
Avatar image
Oct 13, 2016
Dmytro Grycelyak agent wrote
Hello Jos,

In order to merge category columns in Excel or OpenOffice (LibreOffice), use the following formula:

=B2&"|"&C2
where
| - is the delimiter
B2 and C2 - columns you would like to merge.
Avatar image
Oct 13, 2016
Jos wrote
Thanks, this will help, but......

Now these lines:
1200836
1200836
1200836
1200836
1200836
1200836
1200836
1200836
1200836
1200836
1200836
1200836
1200836
1200836
getting merged??
Avatar image
Oct 15, 2016
Dmytro Grycelyak agent wrote
Hello Jos,

In your case, you should merge columns B, C, D and E only. Column A containing the identifier may remain separately.
Avatar image
Oct 15, 2016
Jos wrote
Hi,

I'll try it later today.

Thanks Volodymyr,

Bye,
Jos...
Avatar image
Oct 20, 2016
Jos wrote
Hi,

Didn't work sorry....

Bye,
Jos...
Avatar image
Oct 21, 2016
Dmytro Grycelyak agent wrote
Hello Jos,

The resulting file should look that way: http://screencast.com/t/0jnEha3Qphqi
Avatar image
Oct 21, 2016
Jos wrote
HI,

Are you working in Excel or Open/LibreOffice?
On the image it's exactly what I need!! :>))
I'll try it testing a soon as possible because i'm get
every day more the 100 new LP's available!!

Bye,
Jos...
Avatar image
Oct 21, 2016
Jos wrote
Hi Volodymyr,

What is it that I'm doing wrong here (file included).

Bye,
Jos (and THANK YOU)...
Avatar image
Oct 23, 2016
Jos wrote
Hi Volodymyr,

With the BIG help of you and a small part of me, I'm working now much faster importing the description text.

Bye,
Jos....