Import from American Funds and MFS

[Bird]

I can't believe no one else is having this problem, but it appears that the .DAT files generated under American Funds' Recordkeeper Direct platform (identical to the MFS platform, so that's the Relius interface we use) have been modified by the company that maintains the recordkeeping platform, DST.

The new files do not import to Relius because they have an extra column. I have (very unhappily) tried modifying the files in Excel, Notepad and Wordpad, and something about the structure is changing and they can't be cleaned up.

Relius is aware of the problem, American Funds is aware of the problem, and the only answer I am getting is that DST has to fix it, and is working on it, but I can get no word on when - a day, a month or a year from now.

Does anyone else have any insight on this?

[Guest Ken Simons]

I can't believe no one else is having this problem, but it appears that the .DAT files generated under American Funds' Recordkeeper Direct platform (identical to the MFS platform, so that's the Relius interface we use) have been modified by the company that maintains the recordkeeping platform, DST.

The new files do not import to Relius because they have an extra column. I have (very unhappily) tried modifying the files in Excel, Notepad and Wordpad, and something about the structure is changing and they can't be cleaned up.

Relius is aware of the problem, American Funds is aware of the problem, and the only answer I am getting is that DST has to fix it, and is working on it, but I can get no word on when - a day, a month or a year from now.

Does anyone else have any insight on this?

[FAPInJax]

Please contact Kelly Robinson in support. We are aware of the problem and a fix exists which you do not have.

[Guest Razmatazz]

Please contact Kelly Robinson in support. We are aware of the problem and a fix exists which you do not have.

MFS has had DST modify their files to to allow import into Relius Administration. However, American Funds has not contracted with Relius to establish a link nor have they arranged to have their files edited.

Firms trading with American Funds should contact them to establish a link or obtain files in the correct format.

[Bird]

Thank you both. This information is different from what I have been told by Relius and AF.

Razmatazz, if MFS has had DST correct the problem, and we are using the MFS import for AF files, shouldn't that have taken care of it? Or is it possible DST is generating different reports for MFS than they are for AF?

[Kimberly S]

Different DST clients (fund families) pay for and receive different levels of service and differing customized reporting.

[Guest Razmatazz]

Thank you both. This information is different from what I have been told by Relius and AF.

Razmatazz, if MFS has had DST correct the problem, and we are using the MFS import for AF files, shouldn't that have taken care of it? Or is it possible DST is generating different reports for MFS than they are for AF?

This information was from Relius support. I would contact the support manager, Kelly Robinson, as she was the contact in support for this issue and arranged for the changes to be made with MFS.

[Bird]

This information was from Relius support. I would contact the support manager, Kelly Robinson, as she was the contact in support for this issue and arranged for the changes to be made with MFS.

Thanks for the feedback. As you noted, American Funds doesn't have a contract with Relius, so Relius isn't supporting any fixes for that platform. But, there was a fix for the MFS files, and that still works on the AF files, so at least we have a workaround for now. I've urged AF to step up and contract with Relius.

[pmacduff]

It was interesting for me to read through this post because we began asking about an Am. Funds link for Relius over 7 years ago!! After repeated inquiries, I was given the answer that Am. Funds did not want to incur the cost of settting up their platform with Corbel. It's another way they claim to keep their costs down over other vendors.

While I'm sure that there are numerous other factors at work here, I imagine that the cost to the investment vendor has probably not decreased in the last 7 years!

[Guest Razmatazz]

It was interesting for me to read through this post because we began asking about an Am. Funds link for Relius over 7 years ago!! After repeated inquiries, I was given the answer that Am. Funds did not want to incur the cost of settting up their platform with Corbel. It's another way they claim to keep their costs down over other vendors.

While I'm sure that there are numerous other factors at work here, I imagine that the cost to the investment vendor has probably not decreased in the last 7 years!

Only MFS had their files modified to the original format, whereas American Funds has not had the files restored to their original status. You are correct, in the past American Funds has not been interested in creating their own interface with Relius Administration. If enough people contact them, I wonder if this would make a difference? (The alternative would be for American Funds to have the files provided in a format that could be easily edited or imported using other Relius programs like der's.)

[Guest gfowler]

This information was from Relius support. I would contact the support manager, Kelly Robinson, as she was the contact in support for this issue and arranged for the changes to be made with MFS.

Thanks for the feedback. As you noted, American Funds doesn't have a contract with Relius, so Relius isn't supporting any fixes for that platform. But, there was a fix for the MFS files, and that still works on the AF files, so at least we have a workaround for now. I've urged AF to step up and contract with Relius.

You mention there was a fix for the MFS files and that still works on the AF files - do you mind sharing what the workaround is? I have been playing with the files and discussing with Relius and I have not gotten a workaround yet. My next attempt is to create a transaction import based on the current AF files. Any help you can provide is greatly appreciated.

[Bird]

Tell your Relius support person you need a file called TRIMFILE.EXE.

There is an extra column (or two) in the "improved" files and this utility will strip it out without corrupting the file format. (You can't edit .DAT files in any editor I know of...Notepad, Wordpad, Excel...without corrupting it.)

I guess they need to talk more...your experience is like mine. When I called to follow up on this, I was told that there was an extra column (I knew that) and if I could just get rid of it everything would be ok. But it took a while for my support person to realize that they had a fix, and had had it for while.

[Bird]

Update: I got an e-mail this morning from American Funds that DST is going back to the old file format, as of today.

[Guest Kelly Robinson]

It is the understanding of SunGard Relius that the "Trimfile" utility is provided by MFS and is only authorized for use with MFS files. Therefore, we recommend that this utility NOT be used with American Funds files. We believe that American Funds should provide their files in a format that can be imported into Relius Administration. It appears that American Funds has recently restored their files to the original format, but these files should be imported through Transaction Import, not the MFS link.

Instructions will be posted to the FAQ's at www.relius.net describing how to place the American Funds file in a format that can then be imported through the Transaction Import routine.

Anyone who has questions on this issue is more than welcome contact me at 800-326-7235, x.5885.

To date, American Funds has not been interested in establishing a link with Relius Administration as MFS and others have.

Kelly Robinson

Manager, Relius Administration Pension Support

[Bird]

Well, well, it seems that DST has seen fit to modify their files again - this time removing the line feed so that all the data is strung together in one cell.

AF is trying to get an answer from DST, and as usual they are unresponsive so I figured I'd post it here to see if anyone knows more about it. (I understand that Relius doesn't support AF so any response from Relius would be above and beyond the call.)

And of course MFS is now Hartford so anyone reading this for the first time may find the prior references to MFS confusing.

[Bird]

Bump.

This is still unresolved; it seems the format was changed sometime in October. I guess hardly anyone (noone?) is trying to import files at this time of year and hasn't had the same problem, but I guess that will change come Jan 1. Unless I'm just crazy?

Has no one else in the whole pension world tried to import an AF dat file since November 1?

[Guest emtee]

We have been importing the AF files just fine.

[Bird]

Yes, that problem was resolved.

[Guest gfowler]

Yes, that problem was resolved.

Has anyone encountered problems with Roth money coming across - we are unable to map the source 154 to the Roth Deferral source in Relius. Any thoughts/comments are appreciated.

[Bird]

I just imported the Roth source successfully yesterday. I don't remember whether I had to map it or it just "knew." You might want to double check your source setup to make sure you have the Roth box checked.

Sorry, probably not that helpful!