Base de données en ligne des effets indésirables de Canada Vigilance - Version française

Suivre :

Base de données en ligne des effets indésirables de Canada Vigilance - Version française
Votez :
Nombre de votes : 91
Veuillez prendre note que les commentaires sont modérés. Les commentaires peuvent prendre un certain temps avant d’apparaître en ligne. Pour de plus amples renseignements, veuillez consulter nos règles de participation.

Commentaires d'utilisateurs

Since this is critical for user who exports the data from these extract files to create a database I thought of sharing it here.
In API world "" are delimiters in extract files which is seen here too. However I experienced that even data is entered with quotations (" ") in some extracts files and it results in missing data when imported into a database. Machine can't distinguish it. e.g. Drug Product Ingredient table: $"ENBREL "IMMUNEX""$. The end result is only ENBREL. IMMUNEX is lost due to extra quotation. I understand that its verbatim but please use some other special characters that are not delimiters. Please take any necessary action to solve this perhaps before next quarterly update release.

Just strip the double quotes from each line.

Dear Karin, Indeed that was helpful to know. I will email them. Thanks.

Hello, I have some valuable inputs but first can you please confirm if questions or comments here are replied by owner on this page?

AP - we share comments and questions on our site with the dataholder - in this case, we'll forward your comment to Health Canada. This database can also be found here and if you prefer to forward suggestions or comments directly to Health Canada offices, have a look here for some specific ways to get in touch

Hope this is helpful!
Karin - the open-ouvert team

Please consolidate the dose units in report_drug such that all the doses are in the same order of magnitude. (e.g. mg --> grams) (mg/kg --> mg taken since weight is reported). Also, please check for the integrity of the data with respect to dosages as some are off by orders of magnitude. Lastly, please check for typographical errors when inputting drug names.