Discussions

 View Only
Expand all | Collapse all

Importing a file with both UPC Code (12 digits) and a Field containing COMMAS to CSV

  • 1.  Importing a file with both UPC Code (12 digits) and a Field containing COMMAS to CSV

    Posted 03-04-2017 21:27
    We have a field called "Catalog Description" that is a multi-line Text field that often contains commas. There is another field called "UPC" that is 12-16 digits.

    1. To avoid the UPC being converted to Scientific Notation when opening in Excel, you must used the "Import" function.  You then select "Comma" as the delimiter and mark the UPC field as TEXT (Not General) and then import. This correctly formats the UPC Code field on import.

    2. However, This is causing export errors for the "Catalog Description" field that holds many commas, causing the rest of the data columns to be mis-imported. Any thoughts?


  • 2.  RE: Importing a file with both UPC Code (12 digits) and a Field containing COMMAS to CSV

    Posted 03-16-2017 05:41
    I know this will add a step, but what if you import them in two different imports?

    I'm assuming you have some unique field that is deciding the "key" field.  (I hope its not one of these 2 in question, if so, forget this idea)

    But if it works you can import two different excel files as a possible work around.

    Where is the data coming from?  you might consider an integration if at all possible.