Versions Compared

Old Version 22

changes.mady.by.user Penny Mok

Saved on

compared with

New Version 23

changes.mady.by.user Ryan Chen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26952

CSV connector failed to keep Text type column format

Added a system variable @IPKF to control which column format would be kept after import.

The @IPKF system variable is for CSV Connector only.

  • 0(default): keep date/time column format

  • 1: keep date/time/Text column format

  • -1: keep any column format

ORG-26921

CSV Connector supports append rows from script

CSV Connector supports append rows to import more files by scripts.

LT sample scripts:

Code Block
newbook;
string fname, path$=system.path.program$ + "Samples\Batch Processing\"; 
findfiles fname:=fname$ ext:="*.csv";
int num = fname.GetNumTokens(CRLF);
wbook.dc.add("CSV");
loop(ii,1,num)
{
next$ = fname.GetToken(ii, CRLF)$;
if (ii==1)
{
	wks.dc.flags=256;	// turn on append rows mode
}
wks.dc.source$=next$;
Tree tr1=wks.dc.optn$;
tr1.settings.partial.SetAttribute("Use", 1);
tr1.settings.partial.row$="2";
tr1.ToString(wks.dc.optn$);
wks.dc.import();
}

ORG-27074

Connector failed for Date Time More Cases

Improved JSON connector Connector to support auto detect date time, and import it as date time data.

For example:

the 1996-08-20T00:00:00 value will be imported as 1996-08-20 00:00:00 with column format “yyyy-MM-dd HH:mm:ss”.

Export

JIRA

SUMMARY

DESCRIPTION

DETAILS

ORG-26748

Want export matrix window as image support graph objects

A new system variable @UPM can be used to control this (default = 1 means to include the graph objects and this fix, or 0 to use old behavior)

1.New a project, open attached “Test UPC.opju”

2.With matrix window active, select File menu - Export - Image, and export as *.png file with default settings.

3.Check the exported image file.

==> It does not show the graph object (the colorful one, named with “paths“)

ORG-21563

Plot Highlight Improvements suggested by Thomas Preuer

We support exporting plot selection effect and data highlighter effect.

We can support it in Copy Graph as Picture tool and Export Graph tool.

Export Graphs Advanced will be later.

If there are multiple plots in the graph, we can select one of them and export the selection effect.

We can use data highlighter tool to highlight some data and export the highlighter effect.

...