building node to import heath benefit in HR Tables
I have not received a response to this post. Does anyone have any comments or guidance?
Dave – it depends on what you expect to see as a response from the community. Now ideally you’d have a dozen responses along the lines of “Yes it was easy and here is the code” – but more than likely the answer is “nobody has tried” and therefore I wouldn’t have expected response back to say that.
For your question “is this doable”? Sure – it is just data in SQL in the end. The biggest trick is knowing where the data all goes and then if there are any calculations that you have to do regarding totals, amounts, or what have you.
I don’t know how well Microsoft has documented those tables in their SDK. But obviously your best friend will be entering the data in by hand and looking at a dexsql.log to see the insert statements and where they go.
Once you have that – SC won’t have an issue running the inserts or sql procs in order to create the transactions.
If you would like to submit an answer or comment, please sign in to the eOne portal.