Discussion Forum: Thread 315606 |
|
|
| | Author: | TheBrickResort | Posted: | Jan 11, 2022 16:54 | Subject: | Download My Orders - file format CSV/MS Excel | Viewed: | 44 times | Topic: | Technical Issues | |
|
| When I download to file format CSV or MS Excel:
The Location header and Batch header have their own columns, but
the result fields for both are in the Location column. (In turn, all of
the remaining headers are off by one column.)
Also, I have been unable to fix the Tracking No field in excel with column
width or formatting to return the actual tracking number. Maybe the cell/field
in the report is not formatted or long enough to begin with?
|
|
|
| | | | | |
| | | | Author: | SylvainLS | Posted: | Jan 11, 2022 17:32 | Subject: | Re: Download My Orders - file format CSV/MS Excel | Viewed: | 27 times | Topic: | Technical Issues | |
|
| In Technical Issues, skidoo6 writes:
| When I download to file format CSV or MS Excel:
The Location header and Batch header have their own columns, but
the result fields for both are in the Location column. (In turn, all of
the remaining headers are off by one column.)
Also, I have been unable to fix the Tracking No field in excel with column
width or formatting to return the actual tracking number. Maybe the cell/field
in the report is not formatted or long enough to begin with?
|
For the tracking numbers: The style is not defined in the file (which is normal
for CSV), it’s Excel that is soo smart it thinks tracking numbers are real numbers.
You should be able to force the format to “text” on your side too.
Don’t ask me where that is in modern Excel. In old Excel / LibreOffice / OpenOffice
/ …, it’s in Format | Cells | then Number tab (which should be the default open
tab) and choose “text” in the predefined styles.
|
|
|
| | | | | | | | | |
| | | | | | Author: | TheBrickResort | Posted: | Jan 11, 2022 18:31 | Subject: | Re: Download My Orders - file format CSV/MS Excel | Viewed: | 17 times | Topic: | Technical Issues | |
|
| I can change the format to text, but it doesn't change it back to the whole
tracking number, it just treats the abbreviated number (...E+21) as text and
then I get the warning box next to it that says The number in this cell is
formatted as text or preceded by and apostrophe with the drop down - convert
to number, ignore error, etc.
I just downloaded the orders I have as a buyer and noticed tracking numbers with
spaces download fine, regardless of length, but the ones without do not.
So I added some spaces and text to my seller orders to see what would happen.
It recognized the cells that led with text, contained text, or contained a space
as text and formatted the cell as text. But, the cells that contained only numbers
or led/end with a space did not work.
|
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | Author: | SylvainLS | Posted: | Jan 11, 2022 18:51 | Subject: | Re: Download My Orders - file format CSV/MS Excel | Viewed: | 21 times | Topic: | Technical Issues | |
|
| In Technical Issues, skidoo6 writes:
| I can change the format to text, but it doesn't change it back to the whole
tracking number, it just treats the abbreviated number (...E+21) as text and
then I get the warning box next to it that says The number in this cell is
formatted as text or preceded by and apostrophe with the drop down - convert
to number, ignore error, etc.
|
“Ignore error” sounds good to me.
It’s not your error, it’s not an error with the numbers, it’s Excel’s error for
thinking it’s smarter than you.
| I just downloaded the orders I have as a buyer and noticed tracking numbers with
spaces download fine, regardless of length, but the ones without do not.
So I added some spaces and text to my seller orders to see what would happen.
It recognized the cells that led with text, contained text, or contained a space
as text and formatted the cell as text. But, the cells that contained only numbers
or led/end with a space did not work.
|
Yes, when there’s a space in the middle, Excel thinks “oh, the user may actually
be right, it could really be text and not a number.” Otherwise, it’s “ah, dumb
user, they put spaces around numbers and I have to ignore them.”
There’s dumb, there’s dumber, then there’s Clippy-level dumb.
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | Author: | Stellar | Posted: | Jan 12, 2022 05:01 | Subject: | Re: Download My Orders - file format CSV/MS Excel | Viewed: | 13 times | Topic: | Technical Issues | |
|
| In Technical Issues, skidoo6 writes:
| I can change the format to text, but it doesn't change it back to the whole
tracking number, it just treats the abbreviated number (...E+21) as text and
then I get the warning box next to it that says The number in this cell is
formatted as text or preceded by and apostrophe with the drop down - convert
to number, ignore error, etc.
I just downloaded the orders I have as a buyer and noticed tracking numbers with
spaces download fine, regardless of length, but the ones without do not.
So I added some spaces and text to my seller orders to see what would happen.
It recognized the cells that led with text, contained text, or contained a space
as text and formatted the cell as text. But, the cells that contained only numbers
or led/end with a space did not work.
|
If you import a CSV to an Excel sheet, it lets you "Transform" the data from
it in a new window, try a few things to modify that column to get the result
you want before loading it.
|
|
|
|
|
|
|
|