{"id":316,"date":"2018-09-26T17:39:24","date_gmt":"2018-09-26T15:39:24","guid":{"rendered":"https:\/\/www.smartlux.com\/sdl\/?p=316"},"modified":"2019-05-21T18:09:06","modified_gmt":"2019-05-21T16:09:06","slug":"combine-multiple-lines-into-one-row","status":"publish","type":"post","link":"https:\/\/www.smartlux.com\/sdl\/combine-multiple-lines-into-one-row\/","title":{"rendered":"Version 0.9.0 – combine multiple lines into one row"},"content":{"rendered":"

With the new features in version 0.9.0, Simple Data Logger takes a big step towards the release of version 1.0 (planned for next Monday).<\/p>\n

Combine multiple lines into one row<\/h2>\n

This is best explained with an example: We’re using a counting scale and it sends the (net) weight, count and average piece weight to the PC (each in a separate line):
\n\"Multiple<\/p>\n

While we want to capture all of these values, we do not want them to appear in individual lines (rows) in our CSV file. Instead, these three values should be written into one row (as three columns).<\/p>\n

This is now possible with Simple Data Logger by using the Combine<\/strong> setting in the Process<\/strong> tab:
\n\"Process<\/p>\n

The result is one row containing three values:
\n\"3
\nWithout this setting, the values would have been written into three separate rows:
\n\"3<\/p>\n

Ignore “empty” lines<\/h2>\n

In the example above, you may have noticed that the counting scale sent a fourth line containing only the carriage return and line feed characters. By selecting “Ignore received lines consisting only of white-space characters<\/a>“, we don’t have to consider this row when setting the desired number of columns.<\/p>\n

This settings also affects synchronized polling<\/a> with a delay: “empty” lines are not considered to be an answer from the device and do not prompt SDL to repeat the polling command.<\/p>\n

Show sent data in the event log<\/h2>\n

Until now, only data received form the connected device was shown in the event log even though SDL already had the ability to send commands. This sent data is now shown in green<\/span> (the screenshot also shows the reply from the scale and the captured weight value<\/span>):
\n\"EventYou can change this behavior in the Settings<\/strong> tab:
\n\"Settings<\/p>\n

Line numbers and custom comments<\/h2>\n

SDL can add line numbers as well as a custom comment (e.g. the project or sample name) to each row. You’ll find these settings in the File<\/strong> tab:
\n\"AddResult:
\n\"Line<\/p>\n

Bug fixes and UI improvements<\/h2>\n

We’ve fixed a bug which caused SDL to stop data collection when a number conversion error occurred. The error is now logged, but SDL does not stop.<\/p>\n

We’ve also harmonized the positioning and margins of the user interface elements to make SDL easier and more pleasant to use.<\/p>\n","protected":false},"excerpt":{"rendered":"

With the new features in version 0.9.0, Simple Data Logger takes a big step towards the release of version 1.0:
\n– Combine multiple lines into one row
\n– Ignore “empty” lines
\n– Show sent data (commands) in the event log
\n– Line numbers and custom comments
\n– Bug fixes and UI improvements<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_titles_title":"Simple Data Logger 0.9.0: combine multiple lines into one row","_seopress_titles_desc":"Simple Data Logger takes a big step towards the release of version 1.0: Combine multiple lines into one row, ignore "empty" lines, show sent commands in the event log, add line numbers and custom comments.","_seopress_robots_index":"","_seopress_robots_follow":"","_seopress_robots_imageindex":"","_seopress_robots_snippet":"","_seopress_robots_primary_cat":"none","_seopress_robots_breadcrumbs":"","_seopress_robots_freeze_modified_date":"","_seopress_robots_custom_modified_date":"","_seopress_robots_canonical":"","_seopress_social_fb_title":"","_seopress_social_fb_desc":"","_seopress_social_fb_img":"","_seopress_social_fb_img_attachment_id":0,"_seopress_social_fb_img_width":0,"_seopress_social_fb_img_height":0,"_seopress_social_twitter_title":"","_seopress_social_twitter_desc":"","_seopress_social_twitter_img":"","_seopress_social_twitter_img_attachment_id":0,"_seopress_social_twitter_img_width":0,"_seopress_social_twitter_img_height":0,"_seopress_redirections_value":"","_seopress_redirections_enabled":"","_seopress_redirections_enabled_regex":"","_seopress_redirections_logged_status":"","_seopress_redirections_param":"","_seopress_redirections_type":301,"_seopress_analysis_target_kw":"","_seopress_news_disabled":"","_seopress_video_disabled":"","_seopress_video":[{"url":"","title":"","desc":"","thumbnail":"","duration":"","rating":"","view_count":"","tag":"","cat":""}],"_seopress_pro_schemas_manual":[],"_seopress_pro_rich_snippets_disable_all":"","_seopress_pro_rich_snippets_disable":[],"_seopress_pro_schemas":[],"footnotes":""},"categories":[13],"tags":[29,30,26,31,28,32],"class_list":["post-316","post","type-post","status-publish","format-standard","hentry","category-changelog","tag-columns","tag-counting-scale","tag-csv","tag-line-numbers","tag-lines","tag-rows"],"_links":{"self":[{"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/posts\/316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/comments?post=316"}],"version-history":[{"count":1,"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/posts\/316\/revisions"}],"predecessor-version":[{"id":325,"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/posts\/316\/revisions\/325"}],"wp:attachment":[{"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/media?parent=316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/categories?post=316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.smartlux.com\/sdl\/wp-json\/wp\/v2\/tags?post=316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}