{"id":430,"date":"2015-06-29T11:49:32","date_gmt":"2015-06-29T18:49:32","guid":{"rendered":"http:\/\/www.icetips.com\/blog_wp\/?p=430"},"modified":"2015-06-29T22:19:23","modified_gmt":"2015-06-30T05:19:23","slug":"new-utilities-and-previewer-builds","status":"publish","type":"post","link":"http:\/\/www.icetips.com\/blog_wp\/2015\/06\/29\/new-utilities-and-previewer-builds\/","title":{"rendered":"New Utilities and Previewer builds"},"content":{"rendered":"

I have released two new product builds this morning. \u00a0Icetips Utilities build 1.2.2433<\/a> and Icetips Previewer build 2.7.392<\/a>.<\/p>\n

The Previewer build fixes a problem with the Page of Pages template which I found out was not working with the Legacy\/Clarion template chain. \u00a0This build also includes the fix to scrolling under Clarion 10.<\/p>\n

There are two new features in the Utilities that will come in very handy when dealing with importing comma separated files.<\/p>\n

First is a new property,\u00a0pDelimterStartsLine, to the SplitString method<\/a><\/strong>. \u00a0It allows it to split strings where the delimiter is the beginning of a line, not the end of it. \u00a0Normally SplitString splits strings based on CR+LF (<13,10>) characters at the end of the line. \u00a0Recently a customer needed to split a string that had no CR+LF pairs, but each record started with a specific string. \u00a0By\u00a0implementing this change he was able to split up his file and read the data correctly.<\/p>\n

The second new thing is the ParseCSVLine method<\/a><\/strong>. \u00a0It takes a line of comma separated CSV data and splits it into fields, stored in the CSVFields<\/a> property of the Icetips String Class<\/a>. \u00a0This method can take regular old CSV data and parse it into easily accessible field data. It handles commas in strings without problems so there is no worry about it getting out of sync if the data is otherwise properly formatted. \u00a0I have made it flexible so that you can specify if strings are quoted or not (if they are, the code will look for and ignore commas inside the string) as well as specify the delimiter to use (up to 4 characters). \u00a0The pStringsAreQuotes parameter defaults to TRUE and the pDelimiter defaults to a comma (,) \u00a0Check out the demo code<\/a> in the help:<\/p>\n

ITS  ITStringClass\r\nS    STRING(255)\r\nI    LONG \r\nF    LONG\r\nX    LONG \r\n  CODE\r\n  ITS.FileToLines('testcsv.csv')\r\n  LOOP I = 1 TO Records(ITS.Lines)\r\n    GET(ITS.Lines,I)\r\n    F = ITS.ParseCSVLine(ITS.Lines.OL)\r\n    ITS.ODS('Line: ' & ITS.Lines.OL)\r\n    IF F\r\n      ITS.ODS('  ' & Format(F,@n_3) & ' Fields from ' & ITS.Lines.OL)\r\n      LOOP X = 1 TO F\r\n        GET(ITS.CSVFields,X)\r\n        ITS.ODS('    ' & Format(X,@n02) & ' ' & ITS.CSVFields.OL)\r\n      END\r\n    END\r\n  END<\/pre>\n
\"ParseCSVLine<\/a>
ParseCSVLine example code (image)<\/figcaption><\/figure>\n
There are also some fixes in this Utilities release:<\/p>\n
\n\n\n\n
March 10, 2015<\/span><\/em><\/td>\nThe template could cause classes to export an older version which could cause \"xxx is unresolved for export\" errors when compiling exporting dlls.\u00a0 Fixed.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n\n\n\n
May 24, 2015<\/span><\/em><\/td>\nFixed a potential memory leak in the AddIntoParenthesis<\/a> method.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n\n\n\n
June 27, 2015<\/span><\/em><\/td>\nImage Class ResizeImage method did not work correctly on reports.\u00a0 Fixed.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\n\n\n\n
June 27, 2015<\/span><\/em><\/td>\nImage Class ResizeImage did not correctly size images when it was called multiple times for the same image control.\u00a0 Fixed.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
Arnor Baldvinsson<\/em><\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
I have released two new product builds this morning. \u00a0Icetips Utilities build 1.2.2433 and Icetips Previewer build 2.7.392. The Previewer build fixes a problem with the Page of Pages template which I found out was not working with the Legacy\/Clarion template chain. \u00a0This build also includes the fix to scrolling under Clarion 10. There are ...continue reading New Utilities and Previewer builds<\/span><\/a><\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[4,6],"tags":[],"class_list":["post-430","post","type-post","status-publish","format-standard","hentry","category-products","category-news"],"_links":{"self":[{"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/posts\/430","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/comments?post=430"}],"version-history":[{"count":2,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/posts\/430\/revisions"}],"predecessor-version":[{"id":433,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/posts\/430\/revisions\/433"}],"wp:attachment":[{"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/media?parent=430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/categories?post=430"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.icetips.com\/blog_wp\/wp-json\/wp\/v2\/tags?post=430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}