Home Applications iris-dataset-countries

iris-dataset-countries

This application is not supported by InterSystems Corporation. Please be notified that you use it at your own risk.
4.17
3 reviews
0
Awards
384
Views
133
IPM installs
3
0
Details
Releases
Reviews
Issues
Pull requests
Articles
Rate the applicationLeave review
AAnonymous15 Jan, 2024
Good dataset

This app contains a full csv file dataset about countries. It is easy to use and I have not noticed problems during import.

Robert Cemper22 Jan, 2022
complete and easy to use dataset
  • my review refers to version 1.1.0
  • Docker container builds clean and starts without any problems.
  • The test description fulfills immediately and covers all promises.
  • The errors mentioned in the previous review seem to be fixed.
  • Results displayed by $system.SQL.Shell() are sometimes hard to read
  • So I used SMP / Explorer / SQL
  • Image
NNigel Timothy Salm03 Aug, 2021
Import of Countries doesn't work properly

Hi

I am not using docker so I imported the class and ran the Import() method as follows:

set sc=##class(dc.data.Country).Import(0,"D:\NiPaRobotica\iris-dataset-countries\data\CountryTable.csv",,1,.count)

Only 16 records were loaded. The method returned 16. I would have expected it to return a Status as there is a parameter RowCount, passed by reference, and it returned 0.

As the method does not return a Status O looked at %objlasterror and this is what it says:

w $system.Status.GetErrorText(sc)
ERROR #5794: Datatype validation failed on type '%Double', with value equal to "Republic"

ERROR #5802: Datatype validation failed on property 'dc.data.Country:gnp', with value equal to "Republic"
ERROR #7207: Datatype value 'Robert G. Mugabe' is not a valid number
ERROR #5802: Datatype validation failed on property 'dc.data.Country:gnpold', with value equal to "Robert G. Mugabe"
ERROR #7207: Datatype value '980,1669000,37.8,595' is not a valid number
ERROR #5802: Datatype validation failed on property 'dc.data.Country:independenceyear', with value equal to "980,1669000,37.8,595"
ERROR #7207: Datatype value 'Zimbabwe' is not a valid number
ERROR #5802: Datatype validation failed on property 'dc.data.Country:lifeexpectancy', with value equal to "Zimbabwe"

So, something is causing a number of records to fail when saved.

The csv file opens correctly in Excel and there are 240 countries. There is nothing that I can see in Excel that would indicate a problem.

Nigel Salm

Made with
Install
zpm install dataset-countries download archive
Version
1.1.007 Jan, 2022
Category
Technology Example
Works with
InterSystems IRISInterSystems IRIS for Health
First published
24 Jan, 2021
Last checked by moderator
27 Jun, 2023Works