I try to migration data on Sales Quotation page but .csv file as following I can’t do it.
Because when I upload .csv file on Execute job that can't keep store on one row.
on my csv, I have data 3 rows on one column.
on Execute Job when I upload, it will split line by itself.
If manual input on Sales Quotation page, It can show many rows on Quotation Notes.
I need to migration data many rows on one column only like below image.
How can migration job when it has many rows on one column ?
page: Sales Quotation > Misc Quatation Info
Best answer by dhlelk
Hi @Onjira,
CSV files doesn't support line breaks, you could check this by opening the .csv file from notepad. Hence you could use a workaround to replace the new line character with a placeholder text like "#NEW_LINE#" when uploading and then replace it back to the new line character when migrating data to the source columns.
Check this link for steps on how to find and replace the new line character in excel.
Thereafter you could replace the placeholder text "#NEW_LINE#" back to the new line character on your source migration job. REPLACE(<YOUR_COLUMN_NAME_HERE>, '#NEW_LINE#', CHR(13) || CHR(10))
CSV files doesn't support line breaks, you could check this by opening the .csv file from notepad. Hence you could use a workaround to replace the new line character with a placeholder text like "#NEW_LINE#" when uploading and then replace it back to the new line character when migrating data to the source columns.
Check this link for steps on how to find and replace the new line character in excel.
Thereafter you could replace the placeholder text "#NEW_LINE#" back to the new line character on your source migration job. REPLACE(<YOUR_COLUMN_NAME_HERE>, '#NEW_LINE#', CHR(13) || CHR(10))
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
