Skip to main content
Solved

Migrate Arabic data into custom table

  • December 1, 2021
  • 3 replies
  • 195 views
M
Sidekick (Customer)
Forum|alt.badge.img+10

i have a requirement to upload arabic data into a custom table. i tried doing that using standard migration job but some special characters appeared.

Best answer by Sajith D

Hi @m.arif,

You can use the standard migration jobs to load data as long as you mark the character set in use as Unicode and make sure you save your data file as UTF-8 compatible type. 

Simple example below,
 

 

 

Cheers

This topic has been closed for replies.

3 replies

S
Superhero (Employee)
Forum|alt.badge.img+21
  • Sajith D
  • Superhero (Employee)
  • Answer
  • December 1, 2021

Hi @m.arif,

You can use the standard migration jobs to load data as long as you mark the character set in use as Unicode and make sure you save your data file as UTF-8 compatible type. 

Simple example below,
 

 

 

Cheers

Randini Jayasundara
M
Sidekick (Customer)
Forum|alt.badge.img+10
  • m.arif
  • Author
  • Sidekick (Customer)
  • December 2, 2021

Thanks @Sajith D  , it worked . Would like to ask if there is a way to directly insert this data into custom field directly. I mean is there a way to insert data into custom field. Appreciate if you can send me an example.

S
Superhero (Employee)
Forum|alt.badge.img+21
  • Sajith D
  • Superhero (Employee)
  • December 2, 2021

Hi @m.arif ,

i don’t believe you can do this using a direct file migration. You will need to do a source migration after the data is loaded in to a container table. 

please have a look at “Migrate Custom Fields data” section in which will tell you how to do this when you have the key columns from the standard LU in your data set

https://docs.ifs.com/techdocs/Foundation1/040_administration/260_data_management/050_data_migration/003_data_migration_in_custom_objects/080_custom_fields/default.htm

 

Cheers

Terms & ConditionsCookie settingsAccessibility statement