cms90740 Posted September 11, 2015 Share Posted September 11, 2015 Try to go easy on me, I'm really new to javascript and need help with linking some external data to FusionPro. I have a tiny bit of experience with FusionPro, virtually zero with rules and tables and external data. I keep getting an error while trying to link the external csv file and I'm wondering what code needs to be typed in to fix it. I've attached a screenshot of what I'm trying to do. Thanks for your time. Quote Link to comment Share on other sites More sharing options...
step Posted September 11, 2015 Share Posted September 11, 2015 In your rule editor, if you have "building blocks" turned on, you can get the syntax for functions and objects by double-clicking on them: Objects > External Data > ExternalDataFileEx: new ExternalDataFileEx(Filename, Delimiter) So in your case: DepData = new ExternalDataFileEx('X:\\Data Source\\2015\\32703 Brinkers Open Enrollment\\Test Data\\BI_Dep_Detail_08282015_TEST.csv', ','); // Assuming comma-delimited. '\t' for tab-delimited Quote Link to comment Share on other sites More sharing options...
cms90740 Posted September 11, 2015 Author Share Posted September 11, 2015 Thanks so much for the quick reply! After typing that in with the correct delimiter, I receive a different error stating "ExternalDataEx requires more than 0 arguments", like I said I'm new to javascript and the little bit that I have googled and researched about "arguments" has really just confused me more than educate me. Any fix for this? Thanks again. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted September 11, 2015 Share Posted September 11, 2015 Thanks so much for the quick reply! After typing that in with the correct delimiter, I receive a different error stating "ExternalDataEx requires more than 0 arguments", like I said I'm new to javascript and the little bit that I have googled and researched about "arguments" has really just confused me more than educate me. Any fix for this? Thanks again. Please copy and paste the current syntax of your rule here. Quote Link to comment Share on other sites More sharing options...
cms90740 Posted September 11, 2015 Author Share Posted September 11, 2015 uploaded as doc2.jpg. Quote Link to comment Share on other sites More sharing options...
Dan Korn Posted September 11, 2015 Share Posted September 11, 2015 uploaded as doc2.jpg. Okay. You can just copy-and-paste the rule syntax instead of posting a picture. Anyway, get rid of the semicolon between "ExternalDataFileEx" and the opening parend "(". Quote Link to comment Share on other sites More sharing options...
cms90740 Posted September 11, 2015 Author Share Posted September 11, 2015 Perfect. Thanks so much. Still learning so every character effecting the outcome is like a foreign language. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.