Import in server script

Idea created by robert_schaub on Dec 2, 2015
    Active
    Score25

    I have a nightly task that runs and has the need to import records from an external file. The table is defined in the manage data. I have absolutely no problem with an import at a client level. However the same script does NOT work at the server level. I had to create a work around that grabs a list of ID numbers for table to be imported. Then it runs through a loop to generate records by setting the ID in the related ID field. All fields are defined to lookup import table. Sure would be nice to be able to do a straight import or and Import that updates records and add new records from a server script instead of the bulky work around.