[email protected] Posted January 12, 2014 Posted January 12, 2014 Hi is there anyone that is able to help me regarding excel import, as once converted to CSV file do I replace all the , with " can't remember how it was done. Thanks in advance.
Mort-lemur Posted January 12, 2014 Posted January 12, 2014 Excel import of what to where ? Now running on a fully modded, Mobile Friendly 2.3.4 Store with the Excellent MTS installed - See my profile for the mods installed ..... So much thanks for all the help given along the way by forum members.
[email protected] Posted January 12, 2014 Author Posted January 12, 2014 Excel Import where your saving it to a CSV file ready to import to website ie description price of goods etc but before you import it when its saved to a CSV format you then have to select edit, replace what I believe is either the commas , or ; with ".. Unsure
MrPhil Posted January 12, 2014 Posted January 12, 2014 Are you using Easy Populate to import the CSV file, and having trouble preparing the CSV file itself? EP's documentation should tell you what it wants for separators (e.g., comma) and how to properly export an Excel spreadsheet so that those separators are used, fields containing separators are enclosed in ", and what column headers are needed.
[email protected] Posted January 12, 2014 Author Posted January 12, 2014 Hi Phil Ive prepared sheet to go up, but once Ive changed to csv when I done it before I had to replace the ; with " but keeps coming up when I import to web row 2 wrong. Grrr been trying to figure out what it is for ages but don't seem to be getting anywhere.
Dan Cole Posted January 13, 2014 Posted January 13, 2014 @@[email protected] Have you downloaded and installed the Easy Populate contribution? If so, download some test data so you can see the format required, add your data to it and then import your information back into your database using Easy Populate. That has always worked for me... Need help? See this thread and provide the information requested. Is your version of osC up to date? You'll find the latest osC community version (CE Phoenix) here.
MrPhil Posted January 13, 2014 Posted January 13, 2014 when I done it before I had to replace the ; with " What? The basic CSV principle here is that your target that's going to import the file determines what the separator between fields is (comma and tab are the most common, but others are possible). If a field happens to contain the separator, the usual practice is to wrap the field in " or ' delimiters. If the field also contains the delimiters, presumably an escape character \ would have to be used (but I'm not sure). The spreadsheet exporting a CSV file should handle all this for you. Are you manually producing a CSV file? You talk about importing into Excel -- does this have anything to do with osC?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.