[Skip to main content](#vessel-content) # Odd export file result ## - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") Topic Author - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 14 years 7 months ago [\#42330](#42330) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") *[Odd export file result](/forum/2-general-talk-about-hikashop/42330-odd-export-file-result#42330 "I can't figure out why my export file (using Joomla 1.5.2) is showing in the attached. I can't seem to convert for proper use in a report. This is only 1 order. I use this for Joomla 2.5 and it works...")* was created by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* I can't figure out why my export file (using Joomla 1.5.2) is showing in the attached. I can't seem to convert for proper use in a report. This is only 1 order. I use this for Joomla 2.5 and it works fine (except for some issues I'm still waiting on resolution). I can't imagine if I had many orders (expected) the time to convert to a readable format. Please advise. Thx Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQyMzMwLW9kZC1leHBvcnQtZmlsZS1yZXN1bHQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 7 months ago [\#42332](#42332) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Odd export file result](/forum/2-general-talk-about-hikashop/42330-odd-export-file-result#42332 "I can't figure out why my export file (using Joomla 1.5.2) is showing in the attached. I can't seem to convert for proper use in a report. This is only 1 order. I use this for Joomla 2.5 and it works...")* Hi, That file is totally ok. You must not be used the proper tool/options to open that file. Try to open it with Excel or openoffice calc with the semi colon as separator and it will display nicely in a table. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQyMzMwLW9kZC1leHBvcnQtZmlsZS1yZXN1bHQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") Topic Author - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 14 years 7 months ago [\#42338](#42338) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Re: Odd export file result](/forum/2-general-talk-about-hikashop/42330-odd-export-file-result#42338 "I can't figure out why my export file (using Joomla 1.5.2) is showing in the attached. I can't seem to convert for proper use in a report. This is only 1 order. I use this for Joomla 2.5 and it works...")* I know EXACTLY how to convert csv to readable excel format. I mentioned that I have this program installed for Joomla 2.5 installation and the csv file converts perfectly. Knowing how to convert is not my problem. My concern with this Joomla 1.5.25 version, is the csv file has odd csv broke up this 1 order and grabs other info. The 1 order seems to have been broken up in two lines rather than one long string matched up with the field headings. I don't know how to explain this any better. Here's the file converted. I would like to see your converted version of the file I submitted in my post above and see what I mean. - [ ![strangecsv.jpg](/forum/attachment/3043) ](/forum/attachment/3043 "strangecsv.jpg") [ ](/forum/attachment/3043?download=1 "strangecsv.jpg") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQyMzMwLW9kZC1leHBvcnQtZmlsZS1yZXN1bHQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 7 months ago [\#42339](#42339) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Odd export file result](/forum/2-general-talk-about-hikashop/42330-odd-export-file-result#42339 "I can't figure out why my export file (using Joomla 1.5.2) is showing in the attached. I can't seem to convert for proper use in a report. This is only 1 order. I use this for Joomla 2.5 and it works...")* Ok, I see what you mean. The file that you submitted in our first post has already been transformed by some tool as the double quotes are not correct. They are all doubled. I've reverted that back with notepad++ via a simple search and replace of "" to ". I've attached the corrected file. Then, I opened it with openoffice calc and it displayed nicely on two lines. One for the headers, one for the order data. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQyMzMwLW9kZC1leHBvcnQtZmlsZS1yZXN1bHQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) to join the conversation. - **[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")** - [![aheng5's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar6488.gif)](/forum/user/6488-aheng5 "View aheng5's Profile") Topic Author - [ Offline](/forum/user/6488-aheng5) Less More - Posts: 73 - Thank you received: 2 - - 14 years 7 months ago [\#42342](#42342) by [aheng5](/forum/user/6488-aheng5 "View aheng5's Profile") Replied by *[aheng5](/forum/user/6488-aheng5 "View aheng5's Profile")* on topic *[Re: Odd export file result](/forum/2-general-talk-about-hikashop/42330-odd-export-file-result#42342 "I can't figure out why my export file (using Joomla 1.5.2) is showing in the attached. I can't seem to convert for proper use in a report. This is only 1 order. I use this for Joomla 2.5 and it works...")* I respect your experience as I am not a core programmer; but I consider myself an expert in Excel programming. But apparently I can't get my message across. I did not change anything from the original raw file output that was exported of the 1 order. WYSIWYG in my file attachment initially submitted. I'm trying to figure out whether to stick with this program for Joomla 1.5.25 installations or not. I'll try to figure this out on my own. ![:(](/media/kunena/emoticons/22.png ":(") thank you Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQyMzMwLW9kZC1leHBvcnQtZmlsZS1yZXN1bHQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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") - [ Away](/forum/user/63-nicolas) Less More - Posts: 86323 - Thank you received: 14283 - - 14 years 7 months ago [\#42343](#42343) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile") Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Re: Odd export file result](/forum/2-general-talk-about-hikashop/42330-odd-export-file-result#42343 "I can't figure out why my export file (using Joomla 1.5.2) is showing in the attached. I can't seem to convert for proper use in a report. This is only 1 order. I use this for Joomla 2.5 and it works...")* No I got what you said. But I don't have the problem you have when I open a CSV exported from HikaShop. Multiple lines in fields of the CSVs are handled properly and normally displayed in one cell, not like in your screenshot. You can try on our demo website. The CSVs can be opened directly and are displayed properly. Our demo website is also on Joomla 1.5. The version of Joomla does not change anything for the export. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzQyMzMwLW9kZC1leHBvcnQtZmlsZS1yZXN1bHQ/dG1wbD1tYXJrZG93bg==) or [Create an account](/register) 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.094 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)