Skip to main content
Solved

Excel Migration


Forum|alt.badge.img+6

I’m trying to configure an Excel Migration Job to act on an API that accepts a single attribute, which is a string of keys. 

I wondered if anyone has had any experience in doing this or something similar.

This is the string I get from debug (without the carriage returns) that uses the POSITION_UTIL_API.Modify_Pos method…

              p0_ VARCHAR2(32000) :=

              'STRUCT_ID'||chr(31)||'16'||chr(30)||

              'POS_CODE'||chr(31)||'500042162'||chr(30)||

              'VALID_FROM'||chr(31)||'2023-05-22-00.00.00'||chr(30)||

              'VALID_TO'||chr(31)||'9999-12-31-00.00.00'||chr(30)||

              'OLD_POS_CODE'||chr(31)||'500042318'||chr(30)||

              'SUP_POS_CODE'||chr(31)||'500042319'||chr(30);

I’ve tried many variations in Excel like replacing the || with & and double-quoting like “’STRUCT_ID’”.

Best answer by Fikret

Hello,

after our research, i'm sorry to say that our migration tools are not able to do that. Unfortunately it should be done manually.

View original
Did this topic help you find an answer to your question?

2 replies

Fikret
Do Gooder (Employee)
Forum|alt.badge.img+2
  • Do Gooder (Employee)
  • 3 replies
  • Answer
  • June 16, 2023

Hello,

after our research, i'm sorry to say that our migration tools are not able to do that. Unfortunately it should be done manually.


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Customer)
  • 23 replies
  • June 21, 2023

Thanks very much Fikret


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings