ChartDataRead

ChartDataRead ( fileName ;​ doTranspose ;​ seriesSeparator ;​ elementSeparator )

Argument Type Range Default Note
fileName str 1..1000 (required) Max. 1000 chars.
doTranspose int 0..1 off
seriesSeparator str 1..1 "\n"
elementSeparator str 1..1 "\t"
Examples

ChartDataRead("Data/PlotData.dat")

ChartDataRead("Macintosh HD/Data/PlotData.dat")

ChartDataRead("C:/Programs/Data/plotdata.txt";​;​";";​" ")

Description

Instead of taking the chart values directly from FileMaker Pro via ChartData() they can also be imported from a text file. By using the 1st argument fileName the name of the file including an optional file path is defined. Please refer to File Path Syntax for the allowed syntax for file paths. As the default, the data is read row by row, i.e. a row corresponds to a data series. If the 2th argument doTranspose = on is used, the data is read in columns, i.e. a column corresponds to a data series. By using the arguments seriesSeparator and elementSeparator user-defined separators can be specified between the series and between the individual values. Unless otherwise defined, series are separated by a line feed "\n" and individual values by a tab character "\t". Decimal numbers can be entered using a decimal point or decimal comma; however, thousands separators and E-format are not permitted. The ChartDataOptions() function is ignored in connection with ChartDataRead(). Examples:

ChartDataRead("/Volumes/Macintosh HD/Data/Plotdata.dat")

ChartDataRead("C:/Programs/Data/plotdata.txt";​;​";";​" ")

The ChartDataRead() function can be positioned as you like, but always within the OpenDrawing() and CloseDrawing() functions. ChartDataRead() can also be called repeatedly.


OpenDrawing(200;​120)

LineChart(symbol;​on)

SymbolStyle(1;​bullet;​4)

SymbolStyle(2;​bullet;​4)

ChartDataRead("Data")

CloseDrawing()


OpenDrawing(200;​120)

OpenChart(5;​5;​120;​115;​off)

ChartDataRead("Data_1.txt")

BarChart()

CloseChart()

OpenChart(120;​0;​75;​75;​off)

ChartDataRead("Data_2.txt")

PieChart(label)

CloseChart()

OpenChart(120;​50;​75;​75;​off)

ChartDataRead("Data_3.txt")

PieChart(label)

CloseChart()

CloseDrawing()

Scroll to Top