Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Excel Import


littleminxltd@hotmail.co.u

Recommended Posts

Posted

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.

Posted

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

Posted

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.

Posted

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.

Posted

@@[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...

Posted

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?

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...