跳至內容
選單
此問題已被標幟
2 回覆
3180 瀏覽次數

How to concatenate single cell values ? (all version)

頭像
捨棄
作者 最佳答案

Importing variants, tags, etc.often requires to format the structured file before importing it. Unfortunately, Odoo only allows values separated by commas. So it could be painful to reformat the file with the aim to concatenate each value in a single cell.

The solution is the "M2M Concatenator" tool available by creating this following Gspreadsheet : 


Under the Script menu, you will find two modes of concatenation handled by GScript.

Single ID Mode

This mode works if your file contains one ID per group of lines, for example :

IDValue
1A

B
2X

Y

Z

Using this mode will generate the following table :

IDValueConcatenation
1AA,B

B
2XX,Y,Z

Y

Z

Duplicated ID Mode

This mode works if your file contains one ID per line even if multiple lines are related to the same ID, for example :

IDValue
1A
1B
2X
2Y
2

Z

Using this mode will generate the following table :

IDValueConcatenation
1AA,B
1B
2XX,Y,Z
2Y
2Z
Instructions to use
1. Make a copy of the sheet in your own Google Drive.
2. The GSheet has to contain at least the following columns : id & value.
3. Depending on the structure of your file, run the right concatenation mode described above.
4. The script will create the column "Concatenation" with the concatenated values.
5. Note that the concatenation automatically removes the duplicated values and this system is not case sensitive. It means that if, for the same ID, the column "Value" contains "Red" and "red", the "Concatenation" column will only contain "Red".
6. Save the GSheet as Excel or CSV.
7. Remove the lines without concatenation by sorting on it.
8. Import your file in Odoo.

頭像
捨棄
最佳答案

Can you provide us the Google Spreadsheet link of this useful M2M Concatenator?

頭像
捨棄
相關帖文 回覆 瀏覽次數 活動
6
8月 24
4648
1
9月 15
6277
2
12月 24
7281
2
12月 23
1726
1
11月 23
1249