A comma-separated values (CSV) file is a delimited text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. A CSV file typically stores tabular data (numbers and text) in plain text, in which case each line will have the same number of fields.
In this article, I will introduce my application iris-fhir-bridge
IRIS-FHIR-Bridge is a robust interoperability engine built on InterSystems IRIS for Health, designed to transform healthcare data across multiple formats into FHIR and vice versa. It leverages the InterSystems FHIR Object Model (HS.FHIRModel.R4.*) to enable smooth data standardization and exchange across modern and legacy healthcare systems.
I try to create a tab delimiter file with bold header, when I convert the file into Microsoft Excel, it has a bold header. The file can be in text or CSV exension.
I am trying to use upload.csp as a template for choosing a CDV file to process. I am calling it from a zen page using this: <button caption="Import Client Consultation Extract" controlStyle="width:500px; height:100px; font-size:1.5em;"
It is very easy to import CSV data into IRIS. But what if we want to preserve the original IDs in CSV?
Recently I came across with the situation when I needed to import two csv's into IRIS which were linked by one column referencing to another csv's col: a typical Foreign Key and Primary Key situation, where csv1 contains this column as Primary Key, and csv2 as Foreign key with id's related to csv1.
The image is generated by ChatGPT so don't blame it - it tried its best to generate countries as primary keys with countries.csv-cities.csv relationship :)
Here's a practical example of how to import data from a CSV file into InterSystems CACHÉ using ObjectScript Assuming your CSV file is simple (e.g., comma-separated, with headers), you can use %Stream.FileCharacter to read it line by line and parse the data.
ClassMethod ImportCSV(filePath As %String) As %Status { Set stream = ##class(%Stream.FileCharacter).%New() Set sc = stream.LinkToFile(filePath) If 'sc Quit sc
I have a request from a client who wants to do the following. Currently, they have a data upload process via FTP in which they have implemented a RecordMap to store the information of the CSV files that are uploaded to the FTP directory. Now they want to have another directory so that it is ONLY executed through an external instruction, not when the file is uploaded to the directory.
Year.png)
Open Exchange app
