Imported file shows inconsistent data

Tagged: import, xls

This topic has 12 replies, 3 voices, and was last updated 7 years, 3 months ago by Jason Lee.

Viewing 13 posts - 1 through 13 (of 13 total)

Author
Posts
January 28, 2016 at 07:17 #7256

Jason Lee
Participant
I have created a price table in xls like this:

The numbers all have 2 decimal points with center alignment.
After I import the xls into my site, it looks like this:

Some numbers have extra numbers behind the decimal and the center alignment has been lost.
Is there a way to import without any changes?
Thank you
January 28, 2016 at 07:35 #7258

Jason Lee
Participant
Not sure why the img links are broken. Here are the links
XLS reference: Created in Excel
Supsystic reference: After imported into plugin
January 30, 2016 at 06:23 #7286

Jason Lee
Participant
Hello Mila,
Could you have a look into this issue please?
Thanks
February 1, 2016 at 15:21 #7331

mila_support
Member
Hello!
I’m sorry. I forgot to respond you.
I gave this issue to our developer. He will check what is wrong and will fix this in next version of data table plugin.
As for the alignment issue – as I said you in another topic – the improvement of this function will take approximately 3 weeks.
I will inform you about the updates with improvements and fixes for you.
February 2, 2016 at 02:50 #7340

Jason Lee
Participant
Thank you mila. Looking forward to the update.
February 10, 2016 at 16:30 #7389

mila_support
Member
Hello!
We have released new versions of data table plugin with fixes for you.
Please update the both versions of plugin and check it!
February 11, 2016 at 02:01 #7400

Jason Lee
Participant
Thank you for updating. It works brilliantly!! :)
February 14, 2016 at 04:22 #7409

Jacques Surveyer
Participant
I have a a bikes table with 3 columns and 2oo records in csv format. I cannot find any docs on how to import this into Data Table. I do have the Pro version which I am running on localhost for testing.
Jacques Surveyer
February 17, 2016 at 14:49 #7430

mila_support
Member
Hello @jbsurveyer!
1. Create new data table and click “Import” button in the Settings -> http://prntscr.com/a4dgok
2. In the popup window choose File extension type and delimeter, then choose file and click Import -> http://prntscr.com/a4dhg3
3. Done!
If you will have any problems with it – just let me know!
February 21, 2016 at 07:52 #7499

Jason Lee
Participant
Hi Mila,
I have come across a slight issue with imported data.
The problem is the columns in rows 9 and 10 are always merging together.
I have duplicated the same data to show you -> http://prntscr.com/a5zfhr
Can this be fixed as soon as possible?
Thank you
February 21, 2016 at 09:52 #7500

Jason Lee
Participant
Hi Mila,
Just letting you know it’s now OK with another excel file. Not sure what happened.
Thank you
February 22, 2016 at 17:03 #7543

mila_support
Member
Hi!
You can provide us the file in our internal support and we will check what is wrong.
February 23, 2016 at 10:13 #7555

Jason Lee
Participant
Thank you. Next time I will do so.
Author
Posts