Skip to main content
Question

import fields from an excel file into a custom lu


Forum|alt.badge.img+3

Hello , 
I'd like to import data (custom fields exported from a standard table) into a custom table, I've tried migration data .

In history job :

during execution I saw the imported fields but when I look at the lu in question no field has been imported .

I wonder if I should change the procedure?

thanks in advance

8 replies

Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 10 replies
  • February 5, 2024

hi @maryadu28 
Please check this topic Migration Job - Custom Field | IFS Community
 

there this documentation is reffered: 
Excel Migration_Guidelines.PDF (insided.com)


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 7 replies
  • February 5, 2024

Hello,

Thanks for your response but the link does not work 


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 10 replies
  • February 5, 2024

Hello @maryadu28 ,

 

i attached 2 documents to this message. Are you able to open those?

The topic i refferd to is called “Migration Job - Custom Field” and is posted by “Ntaylor”

Hope this helps.


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 7 replies
  • February 5, 2024

Sorry, I'm a real beginner, but if I want to import an excel file into a custom empty table, I'll do excel migration? What procedure do I use?

 

 


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 7 replies
  • February 5, 2024

I'm coming back to you about importing data from excel, so I've followed the documentation :

then I run the job , download the file, get a message saying that the 20 rows have been inserted, but when I consult the table in question I can't find the rows. 

 


DHCRADPA
Hero (Customer)
Forum|alt.badge.img+9
  • Hero (Customer)
  • 79 replies
  • February 5, 2024

Migration jobs usually have 2 steps. Import data into a temp table, Copy the data from the temp table into the IFSAPP table. Make sure you run both steps.


Forum|alt.badge.img+3
  • Author
  • Do Gooder (Customer)
  • 7 replies
  • February 5, 2024

I followed the doc, yes you're right the data is inserted into a table but which one I don't know.


lglover241
Hero (Partner)
Forum|alt.badge.img+10
  • Hero (Partner)
  • 32 replies
  • February 5, 2024
maryadu28 wrote:

Sorry, I'm a real beginner, but if I want to import an excel file into a custom empty table, I'll do excel migration? What procedure do I use?

 

 


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