Data Exchange plugin

Data Exchange plugin - share data between SMath Studio and CSV/ODF/ODS/ODT/XeLaTeX files - Messages

#61 Posted: 1/31/2013 7:43:47 PM
Martin Kraska

Martin Kraska

1222 likes in 2150 posts.

Group: Moderator

Sounds great! Looking forward for updated plugin.

Martin

Martin Kraska Pre-configured portable distribution of SMath Studio: https://en.smath.info/wiki/SMath%20with%20Plugins.ashx
#62 Posted: 2/2/2013 11:55:56 AM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

PLUGIN UPDATED


- 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
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
3 users liked this post
Mike Kaganski 2/2/2013 7:18:00 PM, Radovan Omorjan 2/2/2013 2:10:00 PM, Martin Kraska 2/3/2013 6:25:00 AM
#63 Posted: 2/3/2013 7:07:50 AM
Martin Kraska

Martin Kraska

1222 likes in 2150 posts.

Group: Moderator

Hello w3bsurf3r,

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).
Martin Kraska Pre-configured portable distribution of SMath Studio: https://en.smath.info/wiki/SMath%20with%20Plugins.ashx
#64 Posted: 2/3/2013 2:21:29 PM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

Hi Martin,

Wrote

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.


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...

Wrote

The assignment operator symbol options might be useful for odt export as well.


Maybe, it's not easy as in TeX documents...

Wrote

Is 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.

Wrote

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.


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!!!

Wrote

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.


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).

Wrote

What 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).
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#65 Posted: 2/5/2013 2:41:06 PM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

PLUGIN UPDATED

- added German language UI;
- CODE: changed language handling.

EDIT: Nightly updated (German XeLaTeX dialog lacks, sorry for the drawback)

best regards,

w3b5urf3r
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#66 Posted: 2/11/2013 6:49:21 AM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

PLUGIN UPDATED

- added Spanish language UI;
- fixed Italian and Russian UI issues.


best regards,

w3b5urf3r
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#67 Posted: 4/10/2013 3:44:01 PM
DuaneKaufman

DuaneKaufman

0 likes in 3 posts.

Group: User

Hello w3bsurf3r,

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 = 20 (pardon the use of ascii text where a picture would be better)

If I enclose the 'in' formula definition in double-quotes
H_{"b"}`def`{20 ` nitalic "in"}

the equation displays correctly.

Thanks,
Duane
#68 Posted: 4/10/2013 5:10:55 PM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

I Duane,

thank you for reporting this issue; I'll fix it ASAP [DONE]


best regards,

w3b5urf3r
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#69 Posted: 4/19/2013 11:03:07 AM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

PLUGIN UPDATED

- 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
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
1 users liked this post
sergio 4/19/2013 2:56:00 PM
#70 Posted: 4/19/2013 4:48:43 PM
Martin Kraska

Martin Kraska

1222 likes in 2150 posts.

Group: Moderator

If 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.
Martin Kraska Pre-configured portable distribution of SMath Studio: https://en.smath.info/wiki/SMath%20with%20Plugins.ashx
#71 Posted: 4/19/2013 5:10:11 PM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

Wrote

If 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
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#72 Posted: 4/19/2013 6:31:25 PM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

You can try to add this version of Plugin to your SMath Studio Portable build

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).
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
1 users liked this post
Martin Kraska 4/19/2013 7:45:00 PM
#73 Posted: 4/19/2013 7:44:26 PM
Martin Kraska

Martin Kraska

1222 likes in 2150 posts.

Group: Moderator

Wrote

You 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.
Martin Kraska Pre-configured portable distribution of SMath Studio: https://en.smath.info/wiki/SMath%20with%20Plugins.ashx
#74 Posted: 4/19/2013 9:48:56 PM
kilele

kilele

133 likes in 397 posts.

Group: User

I'm sure Omorr will test the plugins in your build soon, he recently posted a screenshot from his Linux installation.
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' )
1 users liked this post
Martin Kraska 4/20/2013 6:40:00 PM
#75 Posted: 4/20/2013 5:31:56 PM
Radovan Omorjan

Radovan Omorjan

325 likes in 2052 posts.

Group: Moderator

Hello,

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 I tried a bit this unofficial portable build (thanking to mkraska). My files I used to test these plugins worked fine. This time I used Xubuntu and found an additional issue (I think) I did not pay to much attention on before (or it might change something in the meantime regarding Xubuntu updates etc.). I did not noted any crashes, only the problem with nonvisible pictures, but I've noted that SMath file can not be safely saved if there are plots and graphs in it. Here are the errors when we try to save a file which includes plots or pictures (first picture), and then when we try to open that file (second picture)- it seems that it is not valid and corrupted. My experience with Linux up to now is: SMath file can be made in Windows, opened in Linux, worked correctly, but can not be saved in Linux if you have plots or pictures in it. I don't have the slightest idea what does it mean and what happened. Moreover, I think that someone already mentioned this corruption things.

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">&amp;[DATE] &amp;[TIME] - &amp;[FILENAME]</header>
      <footer alignment="Center" color="#a9a9a9">&amp;[PAGENUM] / &amp;[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
smathtestxubuntu.png
When Sisyphus climbed to the top of a hill, they said: "Wrong boulder!"
1 users liked this post
Martin Kraska 4/20/2013 6:39:00 PM
#76 Posted: 4/20/2013 6:39:02 PM
Martin Kraska

Martin Kraska

1222 likes in 2150 posts.

Group: Moderator

Radovan and kilele, thanks for reporting linux experience. I shall include corresponding advice in the handbook.

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
Martin Kraska Pre-configured portable distribution of SMath Studio: https://en.smath.info/wiki/SMath%20with%20Plugins.ashx
#77 Posted: 4/20/2013 11:21:20 PM
kilele

kilele

133 likes in 397 posts.

Group: User

As you can see in the Mono download page, the only official distribution supported by Mono is OpenSuse. Could anyone try Smath on that Linux distro downloading monono as explained in that page ? I tried myself but for now I can only access a laptop with 1gb ram.
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.
#78 Posted: 4/21/2013 3:55:35 AM
Radovan Omorjan

Radovan Omorjan

325 likes in 2052 posts.

Group: Moderator

Hello Martin
Wrote

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).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.

Wrote

Can 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
When Sisyphus climbed to the top of a hill, they said: "Wrong boulder!"
1 users liked this post
Davide Carpi 4/23/2013 4:12:00 AM
#79 Posted: 4/21/2013 5:13:35 AM
Davide Carpi

Davide Carpi

1416 likes in 2873 posts.

Group: Moderator

Hi Radovan,

Wrote

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"


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

If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#80 Posted: 4/21/2013 6:31:24 AM
Radovan Omorjan

Radovan Omorjan

325 likes in 2052 posts.

Group: Moderator

Hello Davide
Wrote


Wrote

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"


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" . As far as I am concerned, SMath under Mono is not so reliable at the moment regarding the behavior of both "ful" or "condensed" versions (as far as I can figure out). I use it on different distros, and the situation on saving problem appeared recently on my Xubuntu. Therefore, I do not know what is the cause of problems - diferent Linux distros, my actual configuration, something else I am not aware of... There are some other annoying things like when you open few SMath files, maximizing is just unavailable sometimes - some of the files are just windowed and can not be maximized. I hope that this will change to a more stable SMath on Linux and I am looking forward to the next SMath release . From my own experience, when the Wine or Mono are included, there is quite a chance that some things will simply not work or have some peculiar behavior sometimes.

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
When Sisyphus climbed to the top of a hill, they said: "Wrong boulder!"
  • New Posts New Posts
  • No New Posts No New Posts