tag:blogger.com,1999:blog-4968667725127637904.post1742405266292948530..comments2024-03-21T05:38:29.299-07:00Comments on fishing with FDMEE: Universal Data Adapter - Extracting YTD balances (Source Filters)Francisco Amores (@akafdmee)http://www.blogger.com/profile/06055076603713050868noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-4968667725127637904.post-5885490770214042012017-03-29T08:05:22.738-07:002017-03-29T08:05:22.738-07:00Did you check that your SQL is correct? what do yo...Did you check that your SQL is correct? what do you get if you run a SQL query with those filters?Francisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-49882255621105615352017-02-09T10:17:18.587-08:002017-02-09T10:17:18.587-08:00hey Francisco i tried using your example to filter...hey Francisco i tried using your example to filter data which is coming from source using the period key however my aif_bal_load_rule isn't getting updated.below is code for it <br />LoadID = fdmContext["LOADID"]<br />perkey = str(fdmContext ["PERIODKEY"])<br />ustrPerKey = perkey.replace("-","")<br /><br /><br />sqlUpdateParams = "update AIF_BAL_RULE_LOAD_PARAMS SET PARAMETER_VALUE ="+ustrPerKey+ "where LoadID = ? and PARAMETER_NAME = 'P_DATE' and PARAMETER_TYPE = 'SOURCE_FILTERS'"<br />params = [LoadID]<br /><br />fdmAPI.executeDML(sqlUpdateParams,params,True)<br />fdmAPI.commitTransaction()<br />Anonymoushttps://www.blogger.com/profile/12397397560300429496noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-39890422353016176502016-12-05T17:47:47.904-08:002016-12-05T17:47:47.904-08:00I suggest you use IDe like Eclipse or editor like ...I suggest you use IDe like Eclipse or editor like Notepad++ rather than the FDMEE script editor.<br /><br />I would start with simple event script so you can see how they work.Francisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-766934509511724052016-11-10T16:48:39.447-08:002016-11-10T16:48:39.447-08:00And of course aftimport too. I saw only some piece...And of course aftimport too. I saw only some piece of script there, without experience of Jython I think it is a bit difficult to create it from the scratch. Although the requirement looks very simple : filtering date... Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-79946649529153740682016-11-10T16:46:30.289-08:002016-11-10T16:46:30.289-08:00the BefImport(i know I can find it in scripteditor...the BefImport(i know I can find it in scripteditor, but it is totally empty, so not sure where to start), I have set the parameter using TransDate to simply just take the data for year 2016 from SQL Server database view, but no idea to write the BefImport script there with Jython.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-70085196334805199482016-11-10T16:11:05.357-08:002016-11-10T16:11:05.357-08:00Hi Maya,
which script you refer to?Hi Maya,<br /><br />which script you refer to?Francisco Amores (@akafdmee)https://www.blogger.com/profile/06055076603713050868noreply@blogger.comtag:blogger.com,1999:blog-4968667725127637904.post-25717330891318282772016-11-09T21:17:32.993-08:002016-11-09T21:17:32.993-08:00hi Francisco, may I know how can I find the full s...hi Francisco, may I know how can I find the full sql script please?Anonymousnoreply@blogger.com