ProductCart Shopping Cart Software Forums : Import/Export Suggestion 3 https://forum.productcart.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 11 Apr 2026 00:16:31 +0000 Sun, 03 May 2015 04:59:22 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 https://forum.productcart.com/RSS_post_feed.asp?TID=6000 <![CDATA[ProductCart Shopping Cart Software Forums]]> https://forum.productcart.com/forum_images/pc_logo_50.png https://forum.productcart.com/ <![CDATA[Import/Export Suggestion 3 : That actually brings up an interesting...]]> https://forum.productcart.com/import-export-suggestion-3_topic6000_post22452.html#22452 Author: Brett
Subject: 6000
Posted: 03-May-2015 at 4:59am

That actually brings up an interesting point. When exporting, you are able to specify the delimiter. I think both tabs and commas have their issues, because these are both characters which may appear in your average product/category descriptions. In fact. I always seem to have at least some kind of issue when I'm import / exporting. Lately I've used special ASCII characters as delimiter which seems to reduce the number of issues, but the system certainly isn't ideal.]]> Sun, 03 May 2015 04:59:22 +0000 https://forum.productcart.com/import-export-suggestion-3_topic6000_post22452.html#22452 <![CDATA[Import/Export Suggestion 3 : Other than the issues documented...]]> https://forum.productcart.com/import-export-suggestion-3_topic6000_post22451.html#22451 Author: NWClips Craig
Subject: 6000
Posted: 03-May-2015 at 4:20am

Other than the issues documented elsewhere (category long name and tabbed layouts), I haven't seen any issues with using the older file format/extension.  It just seems contradictory to require one thing (.XLS) then specify another (Excel 2007) that really don't go together.  Also, not allowing .TXT files means you can't use tab delimited files either.

FWIW - I did receive a support notice that the inability to import the tabbed layout information is being added to the PC bug reports.
]]> Sun, 03 May 2015 04:20:32 +0000 https://forum.productcart.com/import-export-suggestion-3_topic6000_post22451.html#22451 <![CDATA[Import/Export Suggestion 3 : Hmm this is an interesting point....]]> https://forum.productcart.com/import-export-suggestion-3_topic6000_post22447.html#22447 Author: Brett
Subject: 6000
Posted: 03-May-2015 at 3:17am

Hmm this is an interesting point. Have you run into any issues as a result of this? Are you able to just save the spreadsheet as .xls instead of .xlsx?]]> Sun, 03 May 2015 03:17:26 +0000 https://forum.productcart.com/import-export-suggestion-3_topic6000_post22447.html#22447 <![CDATA[Import/Export Suggestion 3 : Since Excel 2007 is specified...]]> https://forum.productcart.com/import-export-suggestion-3_topic6000_post22406.html#22406 Author: NWClips Craig
Subject: 6000
Posted: 03-April-2015 at 3:42pm

Since Excel 2007 is specified in the import/export procedures, why is only the older Excel 2003 and prior file extension of .XLS required?  The default for Excel 2007 and above is .XLSX.  ]]> Fri, 03 Apr 2015 15:42:58 +0000 https://forum.productcart.com/import-export-suggestion-3_topic6000_post22406.html#22406