The Wiert Corner – irregular stream of stuff

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

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

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

    Join 1,860 other subscribers

Archive for April 26th, 2018

MijnJohn – gerritdejager.nl – oud en jong hebben moeite met digitalisering: omdat alle mijn* verschillend werken.

Posted by jpluimers on 2018/04/26

[Archive.is] MijnJohn – gerritdejager.nl

“Ik ben er niet voor om het administratieve proces van mijn leveranciers te vereenvoudigen, ze zijn er om mijn administratieve processen te vereenvoudigen.”

Gerelateerd:

 

 

 

 

 

https://twitter.com/franskesmeets/status/985831429593554945

 

–jeroen

Posted in Opinions | Leave a Comment »

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).

  • [WayBack] Global Trade Item Number – Wikipedia
  • [WayBack] API 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

[How To] Scan a barcode and add the product name to Wunderlist
byu/plepleus intasker

 

Posted in Cloud, Cloud Apps, Cloud Development, Development, 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 »