Delimiter in Import Manager

[Former Member]

We have upgraded to:

MDM Version 5.5 SP6, 5.5.62.33

Before this patch was loaded we used Text delimted with tab delimiter (\t) in the Import Manager for uploading of records.

After the patch update the text delimited file can be used with the tab (\t) as delimiter. When the file is read however it is read without any delimiter and is imported as a string.

I have tried to change to comma delimited ( with no luck ( error).

Anyone that came accross this problem, please advise.

Interesting enough is that the MDIS system still works fine.

Thanks for any imput

CHris

[Former Member]

Thanks to all for your support and input. The problem has been resolved.

A hotfix has been released. for P6 NOTE:1161921.

Our version now is V5.5 SP6 5.5.62.48.

Chris

[Former Member]

Hi Chris,

Your source file is working fine with most of the SP06 patches used by others.

Still if its not working on your MDM server you can try one more thing

- Save your .txt file with UTF-8 encoding as MDM uses this encoding.If your .txt file is not using tis encoding it may be giving an error due to this.

- Then try importing again with the smae delimiter as you have given in your file through Import manger.

- If it still does not work then probably it could be a patch issue.

Hope it helps

Kindly reward points if found useful

Thanks

Simona

[Former Member]

HI Chris,

I tried your test data in 5.5 sp6 (5.5.62.33).

Tried Importing through import Manager.

If you import with the type DELIMITED TEXT ,

Delimiter - give a space , so just hit the space bar key once.

and try importing the record .I did this way,it works fine.

Thanks,

Felix

[Former Member]

Thanks Jitesh,

I'am having problems adding links, so i resorted to pasting the File.

Its a plain text file, no funnies. copy and paste to notepad.

Let me know if this does not work.

Unique_ID Item_Status Long_Description Short_Description Product_ID Contract_Indicator Catalogue_ID External_Manufacturer Manufacturer_Part_Number Product_Group Original_SAP_Material_Number General_Purpose_ID General_Purpose_XREF UOM Compressed_Part_Number Catalogue_Type Stock_Indicator Price_Unit Currency Price PBQ_UOM SOURCE Source_Status

433174120 ACTIVE SHIM 5 SET SP032.107 BREDEL SP32 SHIM 5 SET SP032.107 BREDEL SP32 433174120 Y N ROTARY PUMP, 433 433174120 each, EA X 1 ZAR 325.55 each, EA 1, SWA0, Supply Chain Bafokeng Rasimone, SWA0 ACTIVE

[Former Member]

Hi,

I tried the sample file given by you and its working as expected.Hope your file format is proper i.e. data into the file is separated with tab only.

Regards,

Jitesh Talreja

[Former Member]

Hi Chris,

I tried importing in both the ways you specified and both are working perfectly fine.I am using MDM 5.5 SP06 5.5.61.48.Could you give your sample data so that i can try importing that.

Regards,

Jitesh Talreja