Data Exchange plugin - share data between SMath Studio and CSV/ODF/ODS/ODT/XeLaTeX files - Messages
Martin
- added [MATH=eng]importData.ODS(2)[/MATH] and [MATH=eng]importData.XLSX(2)[/MATH]
- changes in ODT/ODF markup (italic greek letters);
- LaTeX format changed to XeLaTeX format (Unicode support);
- changes on XeLaTeX markup + dialog to choose some options;
- Each save dialog can memorize settings;
- Plugin Languages: ENG/ITA/RUS.
best regards,
w3b5urf3r
special thanks for the importData.xxx(2) functions.
Meanwhile I am convinced that you found a generic way to handle special characters issues in Latex. My experience with the exported tex file with Miktex under Windows is:
- you need a very recent version (containing XeLaTeX 0.9998)
- you have to manually install XITS and Libertine (font) packages via Package manager.
Given that, compilation is no problem.
I attached my personal "save as" test file, feel free to use that in the plugin docs.
Definitely a matter of taste: I do not need any title page in exported latex documents. Instead, I would propose to obey the page layout settings (heading/footer) as defined in the main program settings.
The assignment operator symbol options might be useful for odt export as well.
Is there sort of localization file/list of strings for the dialogs that I might edit for german UI?
There are still issues with the file directories.
Given your example files, your design intent seems to be that the default directory for import and export should be the directory where the currently executed/active sm sheet resides. This seems sensible to me, thus I would support this point of view.
However, when starting SMath from program manager and then loading a file, the default import/export directory is not the directory of the sm file, but the system user document directory, in my case "C:\users\Kraska\Documents". This is new, as previous versions used the install dir as default in such situations.
In the settings directory, there is a DataExchange subdir with lots of other possibly random named subdirs. I guess, these were created by various versions of the plugin. Can these be safely removed? If so, I would suggest to use system temp dir for such data.
What is the path/name of the dialog settings file?
Martin
SaveTest.sm (36 KiB) downloaded 82 time(s).
WroteDefinitely a matter of taste: I do not need any title page in exported latex documents. Instead, I would propose to obey the page layout settings (heading/footer) as defined in the main program settings.
I've thinked about that (even for ODT documents), but I've seen many proposal in the forum about header and footer enhancements; I prefer to wait the next SMath relase to see if something changes or not...
WroteThe assignment operator symbol options might be useful for odt export as well.
Maybe, it's not easy as in TeX documents...
WroteIs there sort of localization file/list of strings for the dialogs that I might edit for german UI?
Yes, and would be a pleasure for me to have also the German translation; I attach here the list, send me back a PM with translated strings.
WroteThere are still issues with the file directories.
Given your example files, your design intent seems to be that the default directory for import and export should be the directory where the currently executed/active sm sheet resides. This seems sensible to me, thus I would support this point of view.
However, when starting SMath from program manager and then loading a file, the default import/export directory is not the directory of the sm file, but the system user document directory, in my case "C:\users\Kraska\Documents". This is new, as previous versions used the install dir as default in such situations.
I know that; using the "save"/"save as..." menus and changing the working directory the C# variables that I know does not changes... Actually I'm not able to fix it; BTW I've found a similar issue using links (like those in SMath Reference Book): a link show you another sheet but the domain still remain the same, so if you save a change in a 2nd document you overwrite the 1st, not the 2nd!!!
WroteIn the settings directory, there is a DataExchange subdir with lots of other possibly random named subdirs. I guess, these were created by various versions of the plugin. Can these be safely removed? If so, I would suggest to use system temp dir for such data.
It's a bug of the previous relase, actually solved... you can delete any folder whitout losses or damages. The change is in my plans, however as for now I want to keep the settings directory (just for public debugging purposes).
WroteWhat is the path/name of the dialog settings file?
DataExchange.dll.config; about location look here http://stackoverflow.com
best regards,
w3b5urf3r
EDIT: "TRANSLATABLE STRINGS" FILE UPDATED
DataExchange - Translation Sheet.zip (1 KiB) downloaded 84 time(s).
- added German language UI;
- CODE: changed language handling.
EDIT: Nightly updated (German XeLaTeX dialog lacks, sorry for the drawback)
best regards,
w3b5urf3r
- added Spanish language UI;
- fixed Italian and Russian UI issues.
best regards,
w3b5urf3r
First, thanks so much for this plugin!
I noticed one abnormality in using it with worksheets containing English units. SMath wishes to use the symbol 'in' for the English unit 'inch', and LibreOffice does not display equations with this unit correctly (LibreOffice 4.0.2.2 Windows 7):
SMath equation:
H := 20 in
Gets exported into LibreOffice and is formatted like:
H_{"b"}`def`{20 ` nitalic in}
Which displays like:
H_b
If I enclose the 'in' formula definition in double-quotes
H_{"b"}`def`{20 ` nitalic "in"}
the equation displays correctly.
Thanks,
Duane
thank you for reporting this issue; I'll fix it ASAP

best regards,
w3b5urf3r
- OpenDocument files: fixed issue of inch unit ("in" reserved word);
- OpenDocument files: nitalic applied to hyperbolic a*h() functions;
- OpenDocument files: temporary folders moved in the system TEMP folder;
- OpenDocument files: fixed files creation PATH issues on Linux systems;
- Save dialogs: dialog size issue fixed;
- Paths: improvements in path handling;
- Plugin manual: added KNOWN ISSUES section;
Notes on exportData(#) functions
filename argument accept also the fileneme with a path (relative/absolute)
Notes for Linux users
"Current working directory" on Ubuntu is the home folder ("/home/home/" path)
best regards,
w3b5urf3r
Can the full version be expected to run under .net 2.0 or mono systems?
This would affect the my inofficial distribution with the plugins included.
WroteIf I use the compact version instead of the full version, then one (of possibly more) effects is that the importData.XLSX function is not available any more.
Can the full version be expected to run under .net 2.0 or mono systems?
This would affect the my inofficial distribution with the plugins included.
Hi Martin,
The "Full Package" (previous named as ".NET Framework 3.5" ) works on Linux too (with Mono 2.0 or later) but SMath crashes when you call XLSX I/O functions (At least on my PC; The issue seems something Mono-incompatible in the DocumentFormat.OpenXml.dll library); this is the cause because only the "Compact Package" have explicitly the Mono requirements.
I suggest you to share only the "Compact Package" to ensure the SMath Studio stability on Unix Systems.
best regards,
w3b5urf3r

Requirements: .NET Framework 3.5 (Windows) / MONO 2.0 or later (Linux);
Limitations: XLSX I/O functions disabled on non-Microsoft systems;
I don't know what could be the behavior of the Linux build on a Windows system without .NET 3.5 Framework (maybe PompelmoTell can help you to test it)

best regards,
w3b5urf3r
DataExchange_dll_[.NET 3.5 - MONO 2.0 - OS Adaptive].7z (1 MiB) downloaded 72 time(s).
WroteYou can try to add this version of Plugin to your SMath Studio Portable build
![]()
So I did. Updated version of the inofficial portable build
Any testing and feedback especially from linux users are welcome.
Handbook updated accordingly.
You may want to read my adventures in Linux, see the second edit of this post:
http://en.smath.info/forum/yaf_postsm9090_Attempted-to-divide-by-zero-when-saving.aspx#post9090
Puppy's windows installers run in a breeze and are safe to uninstall (I suggest precise 55 under 'older and derivatives' )
It seems that running SMath in Linux and Mono is quite "an adventure", as you said. I am afraid I can not do to much regarding this, just to try it like a curious ordinary user - nothing else. As a w3b5urf3r_reloaded plugins fan

Just for the record, here is the file - it seems it stopped at some moment (/dependences tag)
<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<?application progid="SMath Studio" version="0.95"?>
<regions>
<settings>
<calculation>
<precision>4</precision>
<exponentialThreshold>5</exponentialThreshold>
<fractions>decimal</fractions>
</calculation>
<pageModel active="true" printAreas="true" simpleEqualsOnly="false">
<paper id="1" orientation="Portrait" width="850" height="1100" />
<margins left="39" right="39" top="39" bottom="39" />
<header alignment="Center" color="#a9a9a9">&[DATE] &[TIME] - &[FILENAME]</header>
<footer alignment="Center" color="#a9a9a9">&[PAGENUM] / &[COUNT]</footer>
</pageModel>
<dependences>
<assembly name="SMath Studio" version="0.95" guid="a37cba83-b69c-4c71-9992-55ff666763bd" />
<assembly name="Math Region" version="0.95" guid="02f1ab51-215b-466e-a74d-5d8b1cf85e8d" />
<assembly name="Plot Region" version="1.7.4594.38" guid="c451c2b5-798b-4f08-b9ec-b90963d1ddaa" />
</d
Regards,
Radovan
Radovan, do all the problems also occure if there is no external plugin at all? Can you confirm the stability of the yesterday late night adaptivity patch by Davide? This saved me from maintaining two different distributions. However, half of the zip file size comes from the XLSX I/O feature. The distribution without this feature would fit on a floppy disk (as once Derive did).
Can the CR/LF issue be excluded as source for file compatibility problems?
Martin
The safe and easy way to test different linux distros is creating bootable usb sticks with this application:
http://www.pendrivelinux.com/universal-usb-installer-easy-as-1-2-3/
There is no need to install anything on hard diskd but just run the live distribution version booting the pc from a pendrive.
WroteRadovan, do all the problems also occure if there is no external plugin at all? Can you confirm the stability of the yesterday late night adaptivity patch by Davide? This saved me from maintaining two different distributions. However, half of the zip file size comes from the XLSX I/O feature. The distribution without this feature would fit on a floppy disk (as once Derive did).Martin
The save option regarding plots and pictures has no difference using the official build or compact one you've made. I tried Devide's nonlinear solver functions a bit and I and it works, at least everything I tried.
Regarding DataExcange plugin and compact version there are no crashes.
As I could see, save ODS, and save xeLaTex is working.
Export functions are working, except that I have to put the entire path of the file. If I do not put the path (current directory) then functions reported no errors (1) but I can not find them in the current directory. If I put the entire path then it seems ODS,ODF,CSV export seems to be just fine. It seems that XLSX is not working - it produces error "exportData.XLS(,,,) - function is not defined".
Importing functions are a bit problematic. For ODS there is no success. The file can not be find. If it is in the current directory, it can not be find. If I put the entire path than "Path is empty" error issued. It seems that XLSX is not working either - it produces error "importData.XLS(,,,) - function is not defined".
The same situation is when I put the plugin in the official SMath release.
I tried the recent DataExcange plugin from http://en.smath.info/forum/yaf_postsm9118_DataExchange-plugin.aspx#post9118 that Davide recomended.
As a conclusion of this short test. Save is working, Export is working but thu full path must be used, Import is not working, XSLX I/O is not working
BTW, I am using Xubuntu regular installation - not the Live or Virtualbox one. I could try some other ditros latter.
WroteCan the CR/LF issue be excluded as source for file compatibility problems?Martin
Sorry Martin, I have no idea what does it mean.
Regards,
Radovan
WroteIf I do not put the path (current directory) then functions reported no errors (1) but I can not find them in the current directory. If I put the entire path then it seems ODS,ODF,CSV export seems to be just fine. It seems that XLSX is not working - it produces error "exportData.XLS(,,,) - function is not defined"
The current working directory path will be fixed after the next SMath relase; as for now on my Ubuntu it's the home directory. Have you tried to use the "full package" on your Linux distro?
best regards,
w3b5urf3r

Wrote
WroteIf I do not put the path (current directory) then functions reported no errors (1) but I can not find them in the current directory. If I put the entire path then it seems ODS,ODF,CSV export seems to be just fine. It seems that XLSX is not working - it produces error "exportData.XLS(,,,) - function is not defined"
The current working directory path will be fixed after the next SMath relase; as for now on my Ubuntu it's the home directory. Have you tried to use the "full package" on your Linux distro?
yes, I did try the "full packeage" as well. There is no difference regarding the path. I should use the full path and my home directory is "/home/omorr/". I like your comment which includes "the next SMath release"


Regards,
Radovan
Edit: By the way, I think I mentioned this already. This "condensed" version is something I would prefer for my teaching in the first place
-
New Posts
-
No New Posts