This forum uses cookies
This forum makes use of cookies to store your login information if you are registered, and your last visit if you are not. Cookies are small text documents stored on your computer; the cookies set by this forum can only be used on this website and pose no security risk. Cookies on this forum also track the specific topics you have read and when you last read them. Please confirm whether you accept or reject these cookies being set.

A cookie will be stored in your browser regardless of choice to prevent you being asked this question again. You will be able to change your cookie settings at any time using the link in the footer.

I can't export data
#1
Hi.

I'm trying to export data from:
Sensor: Acceleration (without g)

Sensor: Acceleration with g
Mechanics: Spring

But I can't export it, I tried with Excel but it doesn't work, i try to send via Whats app, Google drive, copy to my folders, Bluetooth, nearby, etc.
On my device only woks from .CSV but I want them in Excel Cry


Also I tried to export it from remote  control, but it doesn't export it in any format (Included .CSV)

My device is a Xiaomi Redmi Note 9S  if it gives some info to you.

I would appreciate any help from the community here.

Thanks, Jason. Big Grin
Reply
#2
Do you have Excel installed in your phone?
Reply
#3
This could particularly happen for huge data sets in the sensor experiments as the binary Excel format is restricted to less then 64k rows. The spring experiment should not come close to this limit though.

The export fails silently, correct? How many rows do the .csv files comprise?

Not that it seems relevant: Android 11?
Reply
#4
I have the same problem with one of my phones (samsung S4) even when the recording (does not matter from which sensor) is very short. When I try to export data via gmail in Excel format it tells "Couldn't attach file"...  I thought it is due to absence of Excel in this phone. Normally I am using .csv files and they are OK.


Attached Files
.zip   Acceleration without g 2021-06-16 10-20-09.zip (Size: 17.73 KB / Downloads: 430)
Reply
#5
That's odd. I just tried on an Android 6 and an Android 12 phone and exporting Excel to gmail worked well on both. But I have the impression that we are looking at two different problems here.

@Jarsgon: Let's start with the remote control export, simply because it is easier to get a bit more information from this one. Could you press F12 in your browser and look for a tab called "console" before trying the export function. Then when exporting, do you see if there is an error message anywhere (typically accompanied by a red circle with a white "x" inside). - Sorry, this description is a bit vague, but F12 accesses the debug console on most browsers with slightly different layout.

@solid: Does Excel export work when sending to other apps? Have you ever used adb or a "logcat" app? These allow to access error logs from all apps and it might be interesting to see if something is logged by gmail when it fails to open the excel file.

To both of you: I assume that you are on the latest version of phyphox? (1.1.9 from April)
Reply
#6
(06-15-2021, 02:16 AM)Jarsgon Wrote: Hi.

I'm trying to export data from:
Sensor: Acceleration (without g)

Sensor: Acceleration with g
Mechanics: Spring

But I can't export it, I tried with Excel but it doesn't work, i try to send via Whats app, Google drive, copy to my folders, Bluetooth, nearby, etc.
On my device only woks from .CSV but I want them in Excel Cry


Also I tried to export it from remote  control, but it doesn't export it in any format (Included .CSV)

My device is a Xiaomi Redmi Note 9S  if it gives some info to you.

I would appreciate any help from the community here.

Thanks, Jason. Big Grin
I know I am 4 years too late and you might have moved on with your life far far ahead but I am leaving this here for the people who will find this thread later:

1. Have excel app installed on your phone 
2. Don't try to export the data from the main page(the page with the acceleration graphs). It won't work with excel.

3. Click on the graph you need and you will see three options: Pan and Zoom, Pick Data and more tools.
4. Click on more tools and once you click on more tools. You will find your "export this dataset" option. Click on it.
5. Click on excel. Duh!
6. Select where you want to send it or place it.
7. Voila! You have your excel file now.

Hope this helps
Reply
#7
(02-26-2025, 04:41 AM)Shreedip Wrote: 1. Have excel app installed on your phone 
This should not be a requirement (on iOS it definitely isn't). At the end, you just would like to have an app installed that could open the old binary Excel file.

Quote:2. Don't try to export the data from the main page(the page with the acceleration graphs). It won't work with excel.
Hm… data is regularly exported that way to Excel at educational institutions worldwide. If it does not work for you, we need to look into it again and fix it. Most people would like to have the full data package and not just an individual graph.
Reply


Forum Jump: