The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,854 other subscribers

Archive for 2018

Home – Outpan – GTIN to product attribute mapping

Posted by jpluimers on 2018/04/26

On my research list: Home – Outpan as it is a key-value store of EAN (actually GTIN, so including GS1 UPC, EAN which means barcodes like UPC-12, EAN-8, EAN-13 and ITF-14).

  • [WayBackGlobal Trade Item Number – Wikipedia
  • [WayBackAPI Documentation – Outpan Developers

    Legacy API

    Get Product Information

    GET https://api.outpan.com/v2/products/[GTIN]?apikey=[YOUR API KEY]


    Add Product Name

    POST https://api.outpan.com/v2/products/[GTIN]/name?apikey=[YOUR API KEY]

    Required POST parameters:

    name: The name you would like to add for this product.


    Add Product Attribute

    POST https://api.outpan.com/v2/products/[GTIN]/attribute?apikey=[YOUR API KEY]

    Required POST parameters:

    name: Name of the attribute you would like to add for this product.

    value: Value for the attribute you would like to add for this product.


    • [GTIN] is the barcode number (ISBN, EAN, UPC, …) of the product you’re looking up.
    • All API calls must be done via HTTPS. Plain HTTP calls will be rejected.

–jeroen

via [WayBack[How To] Scan a barcode and add the product name to Wunderlist : tasker

 

Posted in Barcode, Cloud, Cloud Apps, Cloud Development, Development, EAN, Infrastructure, Internet, Power User, Software Development | Leave a Comment »

When updates on a SELECT timeout with FireDAC, MSSQL 2016 and a ~8k varbinary field in the table

Posted by jpluimers on 2018/04/26

A change of FetchOptions.CursorKind from ckAutomatic to ckDynamic does the trick.

did fix this issue:

I stumbled about a problem regarding FireDAC and MSSQL 2016. The table has four fields, one being of type varbinary(max). When I omit this blob field from the SELECT, I can update any field without problems using the edit and post methods of TFDQuery. It is only when I include that blob field in the SELECT, I cannot update the other fields anymore (the blob is not changed). The post runs into a timeout. It seems that the table is somehow locked. That guess is backed by the fact that even a simple UPDATE query executed from Management Studio is also blocked until I reset my application inside the debugger.Interestingly an INSERT runs without problems.

Via: [WayBack] I stumbled about a problem regarding FireDAC and MSSQL 2016…. G+ Uwe Raabe

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »

On my research list for Delphi use – FlowFinity and DreamFactory

Posted by jpluimers on 2018/04/25

For my research list:

–jeroen

Posted in .NET, Delphi, Development, Software Development | 4 Comments »

Pathfinder, a fast GPU-based font rasterizer in Rust – pcwalton

Posted by jpluimers on 2018/04/25

When you thought font rendering was a done thing, read [WayBackPathfinder, a fast GPU-based font rasterizer in Rust – pcwalton

via: [WayBack] Text display is so critical, great speed is a MUST http://pcwalton.github.io/blog/2017/02/14/pathfinder/ – David Berneda – Google+

–jeroen

 

Posted in Algorithms, Development, Software Development | Leave a Comment »

Reminder to self: check out “Debugging helper for TDataSet” and “debugger TDataSetVisualizer” for Delphi

Posted by jpluimers on 2018/04/24

So I won’t forget to check these out:

Via  [WayBackI like programming in Delphi, but I don’t particularly like writing applications that work with database backends… – Thomas Mueller (dummzeuch) – Google+ (thanks Stefan Glienke)

Read the rest of this entry »

Posted in Delphi, Delphi 10 Seattle, Delphi 2010, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Delphi XE6, Delphi XE7, Delphi XE8, Development, Software Development | 1 Comment »

How to embed a superscript Registered symbol in a Rave memo buffer.

Posted by jpluimers on 2018/04/24

Thomas Pfister came with a nice solution to this question:

[WayBack] Does anyone know how to embed a superscript Registered symbol in a Rave memo buffer? – Phillip Woon – Google+

Since Google has such bad indexing of G+, here is the solution:

procedure TForm4.RvSystem1Print(Sender: TObject);
const
  SuperscriptOn = RPTFPrefix + RPTFSuperscript + RPTFOn + RPTFSuffix; // from RpDefine.pas
  SuperscriptOff = RPTFPrefix + RPTFSuperscript + RPTFOff + RPTFSuffix;
var
  MemoBuf: TMemoBuf;
begin
  MemoBuf := TMemoBuf.Create;
  try
    MemoBuf.Text := 'Test' + SuperscriptOn + '®' + SuperscriptOff + ' Test';
    MemoBuf.PrintStart := 0.5;
    MemoBuf.PrintEnd := 8.0;

    with Sender as TBaseReport do begin
      PrintMemo(MemoBuf, 1, true);
    end;
  finally
    FreeAndNil(MemoBuf);
  end;
end;

–jeroen

Source: Does anyone know how to embed a superscript Registered symbol in a Rave memo …

Posted in Delphi, Delphi 10 Seattle, Delphi 10.1 Berlin (BigBen), Delphi 2007, Delphi 2009, Delphi 2010, Delphi XE, Delphi XE2, Delphi XE3, Delphi XE4, Delphi XE5, Delphi XE6, Delphi XE7, Delphi XE8, Development, Software Development | Leave a Comment »

use `zypper refresh` when this fails: openSUSE Tumbleweed upgrade – openSUSE

Posted by jpluimers on 2018/04/23

A while ago, when upgrading from CPE_NAME="cpe:/o:opensuse:tumbleweed:20170206" to CPE_NAME="cpe:/o:opensuse:tumbleweed:20170213":

aRetrieving: monitoring-tools-1.14.0-4.2.x86_64.rpm ......................................................................................................[error]
File './x86_64/monitoring-tools-1.14.0-4.2.x86_64.rpm' not found on medium 'http://download.opensuse.org/repositories/server:/monitoring/openSUSE_Tumbleweed/'

What happened is that the local zypper configuration was out of sync with the repository. A zypper refresh solved that.

So I expanded my zypper-twup alias to always include the zypper refresh.

Then I updated the documentation from [old WayBackopenSUSE:Tumbleweed upgrade – openSUSE to [new WayBackopenSUSE:Tumbleweed upgrade – openSUSE.

Note you need an account at https://login.microfocus.com to logon to the various opensuse.org sites to make edits or post messages.

–jeroen

 

Posted in *nix, Linux, openSuSE, Power User, SuSE Linux, Tumbleweed | Leave a Comment »

If you never updated your Intel 320 SSD firmware, you should

Posted by jpluimers on 2018/04/23

Somehow I missed this:

So I made a file and an image backup, then updated the firmware.

–jeroen

Posted in Hardware, Power User, SSD | Leave a Comment »

A while ago, Windows 10 started to popup an Edge browser window after reboot without an internet connection

Posted by jpluimers on 2018/04/21

Does anyone know how to disable Edge popping up with a failed link www.msftconnecttest.com/redirect on machines blocked by a router?

This happens on the PC running Windows 10 Pro N (winver shows 1709 build 16299.371) that is not allowed to do any internet access.

Related: [WayBack] How to Find Out Which Build and Version of Windows 10 You Have | ilicomm

Later:

This seems to be intended as per these links:

TL;DR:

This can happen on Windows 8 and up when Windows thinks there is a partial network connection and a logon to a proxy or captive portal might solve the solution.

Allowing these in the proxy for port 80 solves the issue:

  •  *.msftncsi.com
  • *.msftconnecttest.com

--jeroen

Posted in Captive Portal, Internet, Power User, Windows, Windows 10 | Leave a Comment »

4 of the Best Critical Thinking Resources for Learners to Have

Posted by jpluimers on 2018/04/20

Critical thinking resources like these are some of the best ones for learners to have. Share them so they can use them as references and tools for development every day.

Source: [WayBack4 of the Best Critical Thinking Resources for Learners to Have.

Via: [WayBack] have to print it and put it on my desk, been trying to do this for a long time, but this is a really good list to have handy – Lars Fosdal – Google+

Sharing them and the pictures below.

–jeroen

Read the rest of this entry »

Posted in LifeHacker, Opinions, Power User | Leave a Comment »