Topics started by AIDTrevorJ

1 Topic

A
Do Gooder (Customer)
AIDTrevorJDo Gooder (Customer)
asked in Data Migration

Automated import of external file to data load table

ASystem: IFS Apps 8 (Currently)Hi, I'm new to the community and fairly new to IFS. I have a requirement within the business that on an agreed schedule it will automate a process in IFS, where an external SQL based system produces a file which can be automatically imported into IFS and used to generate new projects. e.g.Step 1@19:00 the External Systems produces an external text file: Pipe Delimited and columns encompassed in double quotes ("")Step 2@19:30 IFS imports the data into a temporary tablestep 3@ 19:45 a scheduled event activates andValidates the imported data in the temporary table creates new Project records based on the data in the temporary table emails users to notify of any failed transactionsSteps 1 and 3 are in place, I’m having problems with step 2I have looked at the data Migration tool and can't see how to schedule and completely automate the steps in completing this, load file, save and importI have also looked at the external file tool and am a totally bemused by

2
A
Do Gooder (Customer)
3 years ago

Badges

Show all badges
Terms & ConditionsCookie settings