Gee
February 23, 2018, 4:10am
1
In need of assistance
on clicking a button, pops up a fileDialog allows me to select a csv file on my local machine.
obtain the selected files name and use this open and import the cvs into a datatable that may or
Having issues selecting filename and importing (tried bothy).
This is how I had been thinking of doing it.
https://webix.com/snippet/062e623d
Do I have to used an uploader view?
Any help would be much appricated
Gee
Gee
February 23, 2018, 4:59am
2
I think I have found out how to import data into the datatable
https://webix.com/snippet/d14da0a7
Does require that the id’s are data0, data1 etc. Original data will have different id’s
Gee
February 24, 2018, 4:25am
3
Still in need of help, I have been able to get a file selecting dialog and select a file. All I get however is the filename not the directory in which the file resides.
https://snippet.webix.com/ngffef6a
Not sure if I have done this correctly, if so then how do I get directory. If not can someone suggest another way.
Thanks
Nastja
February 27, 2018, 3:15pm
4
Hello!
Gee
March 1, 2018, 4:07am
5
Hi, thanks for getting back to me.
kind of figured that which was why I was surprised when I found I could load a local excel file into a datatable.
https://snippet.webix.com/jbv5i3xt
The problem now is I do not seem to be able to mix and match data loaded locally with that loaded from a file as you can see in the snippet.
Still working on resolving this. I see you have answered my other query, maybe this will help.
Thanks again, been fighting with this for over a week now.
Gee
March 14, 2018, 5:27pm
6
Another question, do I need pro just to import excel into a datatable… I’m guessing so.
Helga
March 7, 2018, 10:13am
7
Hi @Gee ,
You can add extra logic for your onBeforeFileAdd handler to convert Excel data into normal JSON with the necessary fields.
Just get Excel data as an array using the toObject() method of Webix Excel DataDriver and apply the needed transformations to it:
webix.DataDriver.excel.toObject(upload.file).then(function(data){
//turn data.data into JSON records
$$("dt1").parse(records);
});
Check the snippet, please: https://snippet.webix.com/d8ks0mug
Gee
March 11, 2018, 1:42am
8
Hi Helga,
Thanks for your assistance. Do you know if this works diffrently withon webix jet? I added the following to my program and I never see ‘process xsl’
view: "uploader",
value: "Import Receivers",
on: {
onBeforeFileAdd: function (upload) {
webix.message('onBeforeFileAdd: ' + JSON.stringify(upload));
webix.DataDriver.excel.toObject(upload.file).then(function(data){
webix.message('process xsl');
});
Gee
March 11, 2018, 3:09am
9
I.m seeing in debug, if that is any help:
maksim
March 14, 2018, 12:42pm
10
It seems you are using GPL version of Webix.
https://docs.webix.com/desktop__excelviewer.html
Gee
March 14, 2018, 3:02pm
11
This is true I am not using the pro version I’m developing for personal development purposes with a view to getting my employer to purchase. Is it possible in the non pro version to import say .cvs
Helga
March 14, 2018, 6:31pm
12
Is it possible in the non pro version to import say .cvs
Yes, you can use HTML FileReader API to get the contents of a CSV file and parse it into the datatable: Code Snippet
do I need pro just to import excel into a datatable
Yes, here you need a Pro version. Meanwhile, you can get a 30-day free trial .
Gee
March 14, 2018, 6:50pm
13
Helga, Thanks for your assistance. I might just go ahead and purchase a pro just for myself. I did download the 30-day trial by accident when downloading 5.2 but I’m reluctant to use as if I use some of the pro features after the 30 days I will be forced to purchase.
Given the support the Webix Team has provide me I think it only fair however I go ahead and purchase.
Your support is much appreciated.
Regards
been at this for a couple of days now. Here is what I aiming to achive.