[Skip to main content](#vessel-content) # Exported report data diff to column headers ## - **[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")** - [![vmrayner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12065-vmrayner "View vmrayner's Profile") Topic Author - [ Offline](/forum/user/12065-vmrayner) Less More - Posts: 38 - Thank you received: 0 - - 13 years 11 months ago [\#81005](#81005) by [vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile") *[Exported report data diff to column headers](/forum/3-bug-report/76553-exported-report-data-diff-to-column-headers#81005 "I'm setting up a new shop and am trying to become familiar with reporting. I have generated a report of some test transactions - just a listing of all orders to date. The CSV exported file, when opened in Excel has a couple of columns of data out of sync with the column descriptions. All columns after this point are incorrectly labeled. I've attached the sample report. For example, order_full_price column seems to have payment_method data beneath it. How is this corrected and can I alter the report to get rid of columns that are of no need to me? Thank you Viv")* was created by *[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")* I'm setting up a new shop and am trying to become familiar with reporting. I have generated a report of some test transactions - just a listing of all orders to date. The CSV exported file, when opened in Excel has a couple of columns of data out of sync with the column descriptions. All columns after this point are incorrectly labeled. I've attached the sample report. For example, order_full_price column seems to have payment_method data beneath it. How is this corrected and can I alter the report to get rid of columns that are of no need to me? Thank you Viv Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjU1My1leHBvcnRlZC1yZXBvcnQtZGF0YS1kaWZmLXRvLWNvbHVtbi1oZWFkZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")** - [![vmrayner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12065-vmrayner "View vmrayner's Profile") Topic Author - [ Offline](/forum/user/12065-vmrayner) Less More - Posts: 38 - Thank you received: 0 - - 13 years 11 months ago [\#81007](#81007) by [vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile") Replied by *[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")* on topic *[Exported report data diff to column headers](/forum/3-bug-report/76553-exported-report-data-diff-to-column-headers#81007 "I'm setting up a new shop and am trying to become familiar with reporting. I have generated a report of some test transactions - just a listing of all orders to date. The CSV exported file, when opened in Excel has a couple of columns of data out of sync with the column descriptions. All columns after this point are incorrectly labeled. I've attached the sample report. For example, order_full_price column seems to have payment_method data beneath it. How is this corrected and can I alter the report to get rid of columns that are of no need to me? Thank you Viv")* Try again - csv file attached *This attachment is hidden for guests. Please log in or register to see it.* Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjU1My1leHBvcnRlZC1yZXBvcnQtZGF0YS1kaWZmLXRvLWNvbHVtbi1oZWFkZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 13 years 11 months ago [\#81354](#81354) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Exported report data diff to column headers](/forum/3-bug-report/76553-exported-report-data-diff-to-column-headers#81354 "I'm setting up a new shop and am trying to become familiar with reporting. I have generated a report of some test transactions - just a listing of all orders to date. The CSV exported file, when opened in Excel has a couple of columns of data out of sync with the column descriptions. All columns after this point are incorrectly labeled. I've attached the sample report. For example, order_full_price column seems to have payment_method data beneath it. How is this corrected and can I alter the report to get rid of columns that are of no need to me? Thank you Viv")* Hi, The problem is a separator issue. You have selected to use the comma separator instead of the semi colon for CSVs in the configuration. However, in the date format, there is actually a comma. So when excel opens the CSV, it shifts the columns as it sees the dates in two columns instead of one. If you change the separator, that should fix the issue automatically. Alternatively, you can overwrite the file administrator/components/com_hikashop/classes/widget.php with the one in this archive to fix the issue. The following user(s) said Thank You: [vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjU1My1leHBvcnRlZC1yZXBvcnQtZGF0YS1kaWZmLXRvLWNvbHVtbi1oZWFkZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")** - [![vmrayner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12065-vmrayner "View vmrayner's Profile") Topic Author - [ Offline](/forum/user/12065-vmrayner) Less More - Posts: 38 - Thank you received: 0 - - 13 years 11 months ago [\#81545](#81545) by [vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile") Replied by *[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")* on topic *[Exported report data diff to column headers](/forum/3-bug-report/76553-exported-report-data-diff-to-column-headers#81545 "I'm setting up a new shop and am trying to become familiar with reporting. I have generated a report of some test transactions - just a listing of all orders to date. The CSV exported file, when opened in Excel has a couple of columns of data out of sync with the column descriptions. All columns after this point are incorrectly labeled. I've attached the sample report. For example, order_full_price column seems to have payment_method data beneath it. How is this corrected and can I alter the report to get rid of columns that are of no need to me? Thank you Viv")* It is true that the export works with semicolon delimiter but I have to take special measures to open it up in Excel. Normally, Excel will just open a comma delimited file with no trouble and I have other modules exporting data in comma delimited csv files. Thanks for the revised file but I downloaded and extracted the new widgets.php from here. I copied it over to replace the existing widgets.php file. I then attempted to export the same data but the problem remained. Did it work for you? Thanks Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjU1My1leHBvcnRlZC1yZXBvcnQtZGF0YS1kaWZmLXRvLWNvbHVtbi1oZWFkZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")** - [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile") - [ Offline](/forum/user/63-nicolas) Less More - Posts: 86555 - Thank you received: 14304 - - 13 years 11 months ago [\#81720](#81720) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Exported report data diff to column headers](/forum/3-bug-report/76553-exported-report-data-diff-to-column-headers#81720 "I'm setting up a new shop and am trying to become familiar with reporting. I have generated a report of some test transactions - just a listing of all orders to date. The CSV exported file, when opened in Excel has a couple of columns of data out of sync with the column descriptions. All columns after this point are incorrectly labeled. I've attached the sample report. For example, order_full_price column seems to have payment_method data beneath it. How is this corrected and can I alter the report to get rid of columns that are of no need to me? Thank you Viv")* My bad, I didn't give you the correct version of the file. Here is the correct one. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjU1My1leHBvcnRlZC1yZXBvcnQtZGF0YS1kaWZmLXRvLWNvbHVtbi1oZWFkZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")** - [![vmrayner's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/12065-vmrayner "View vmrayner's Profile") Topic Author - [ Offline](/forum/user/12065-vmrayner) Less More - Posts: 38 - Thank you received: 0 - - 13 years 10 months ago [\#82193](#82193) by [vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile") Replied by *[vmrayner](/forum/user/12065-vmrayner "View vmrayner's Profile")* on topic *[Exported report data diff to column headers](/forum/3-bug-report/76553-exported-report-data-diff-to-column-headers#82193 "I'm setting up a new shop and am trying to become familiar with reporting. I have generated a report of some test transactions - just a listing of all orders to date. The CSV exported file, when opened in Excel has a couple of columns of data out of sync with the column descriptions. All columns after this point are incorrectly labeled. I've attached the sample report. For example, order_full_price column seems to have payment_method data beneath it. How is this corrected and can I alter the report to get rid of columns that are of no need to me? Thank you Viv")* Yes. That worked. Thanks! Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMtYnVnLXJlcG9ydC83NjU1My1leHBvcnRlZC1yZXBvcnQtZGF0YS1kaWZmLXRvLWNvbHVtbi1oZWFkZXJzP3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.050 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)