ELM - Special characters in List Management

[Former Member]

I have the following two questions which are very important for business, can anyone let us know the simplest way we can workaround the following issues:

1. Special charaters to take care using UTF-8 format csv or txt files

2. Everytime correction to the file is done it cannot be uploaded or corrected to the server file for existing Lists, a new one needs to be created instead.

Details are below:

Point 1:

When we try liading special characters like in the word München it is replaced with M#nchen in the application after loading.

I think we can solve this by selecting the UTF-8 type of the csv file, has anyone done this/tried this, pls provide details.

Point 2:

In this case when a list is created & loaded and errors are encountered due to data we would like to correct the file and re-load without having to create a new list again.

Is there a possibility to correct the file and re-load it or upload it once more so that the corrected data is then available for the List to be loaded.

Please let us know the simplesrt workaround. Or let us know if we are not doing this right.

Thanks

Regads

Rahul

[Former Member]

Hi Rahul,

In response to point 1, yes you can solve the issue with special charatcters by converting the file to UTF-8 format and upload.

point 2: You can use the same external list to upload corrected file. Untlil unless there is atleast one BP or transaction is created from the file you have used, you can change the same external list to upload the corrected file for re-process... Meaning if there is anything wrong in upload or map steps (with out creating any bp or transaction), you can re-process and upload corrected file in the same external list.

Regards,

Priyanka

[Former Member]

Hi Priyanka,

Thanks for the answer, I will test point 1 but for point 2 I tried the steps for example I created a new List & selected

Read data

Map data

The rest I left unchecked, I started th eload, it gave an error in step 2 i.e Map data.

Now I should be able to correct the file locally & re-load it and repeat the step, but I cannot select th eupdated/corrected file again, nor can I check the flag for Map data?

Is this standard functionality or needs to be customized.

I would expect I should be able to select the corrected file & load it to the server to re-run th eList load, isnt this what you described in point2?

Thanks

Regards

Rahul

[Former Member]

Hi Rahul,

I am not sure if we can re process the list from Web ui.. but you can open the same list in GUI and re process the same with the updated file. Use transaction CRMD_MKTLIST. Open the external list in edit and remove the complete file path and then select the file again, it will ask if you want to delete all the steps already processed.. say yes and it will aloow you to check upload and map steps and process the same.

Hope this helps,

Priyanka