Page 2 of 8 FirstFirst 1234 ... LastLast
Results 11 to 20 of 75
  1. #11
    Join Date
    Mar 2004
    Posts
    96
    Plugin Contributions
    0

    Default

    I was able to follow everything up until:

    Add column names
    CODE
    C10 = products_model
    D10 = products_name


    what do you mean? paste products_model into cell 10?
    There is nothing below cell C 10 in the workbook, and to the right of it, (in e10), there is
    2;"1";"3";;;"30.0000";"0";"2005-04-09 14:32:44";NULL;NULL;"0.00";"1";"0";"0";"2";"1";"1";"0";"0";"0";"1";"0";"1";"0";" 0";"0";"0";"30.0000";"1";"1"

    etc...

    Please advise!!! Thanks.

  2. #12
    Join Date
    Mar 2004
    Posts
    96
    Plugin Contributions
    0

    Default

    Let me ask this.....is there anyone on these forums who has actually followed this tutorial from start to end and completed it?

    Just curious.

  3. #13
    Join Date
    Apr 2005
    Posts
    6
    Plugin Contributions
    0

    Default

    lol, mate, I'm with you. It's a bit cryptic, and I'm not willing to test this stuff on even a test database.

  4. #14
    Join Date
    May 2005
    Location
    Oakland, CA
    Posts
    39
    Plugin Contributions
    0

    Default

    Yes!! it works! I created the code generating workbook in excel.

    I get an error when running in MYsql though:

    Code:
    products_ id = 43 LIMIT 1
    I think it was error #1064 I believe.

    NEVER GIVE UP

    PS, does this also work for images?

  5. #15
    Join Date
    Mar 2004
    Posts
    96
    Plugin Contributions
    0

    Default

    I'm not exactly sure what that script does.

    I ended up writing my own script that takes data from a .csv file my client prepared (columns for item name and price)
    and dumps them into ZenCart with attributes.

    Works OK and I was able to get 1000 items into the database pretty quickly.

  6. #16
    Join Date
    Feb 2005
    Location
    Northern Virginia
    Posts
    586
    Plugin Contributions
    0

    Default

    Well, personally, I LOVE Juxi's solution and it has worked great for me. It does take a certain level of comfort with Excel and its formulas however.
    Denise

    ... ever amazed at the Power of Zen!

  7. #17
    Join Date
    Mar 2004
    Posts
    883
    Plugin Contributions
    1

    Default

    Let me ask this.....is there anyone on these forums who has actually followed this tutorial from start to end and completed it?
    lol, mate, I'm with you. It's a bit cryptic, and I'm not willing to test this stuff on even a test database.
    Yes!! it works! I created the code generating workbook in excel.
    NEVER GIVE UP
    I'm not exactly sure what that script does.
    Well, personally, I LOVE Juxi's solution and it has worked great for me. It does take a certain level of comfort with Excel and its formulas however.
    This is a 'hands on' tutorial.

    When mastered,
    you can do things in a fraction of a second that could take forever in Admin…
    update your products' descriptions and prices,
    reorganize your categories, zones, geo-zones, attributes and options,
    re-associate paths and names of your images to products,
    put products on special or featured,
    and more.

    It shows you…
    how to set up a worksheet,
    how to import data from the tables into Excel,
    how to label your rows with user friendly descriptions,
    how to learn about a table's fields and their constraints,
    how to learn what tables/fields need to be updated in ANY situation,
    how to compose your SQL script using a simple point-click-tap method,
    how to load those scripts to update your database.

    It also provides…
    suggested 'best practices',
    things you should avoid,
    useful tips for working within Excel.

    It is a beginner's guide, NOT a final solution.
    NO final scripts are provided, but self-proofing methods to write them are.
    NO templates are provided, but the processes needed to create them are.

    It does not put any constraints on…
    how far you can extend its use,
    how many problems you can cause for yourself.

    For sure, the more you know about Excel and mySQL instructions, the easier it will be to see how it all comes together.

    The tutorial is not perfect or definitive.

    It addresses UPDATING your tables, not INSERTING new records. I never finished the 'inserting new records' addendum that I was working on.
    But, that has not prevented numerous users from adapting their worksheets to do that.

    It is not a plug-in and go solution for your situation.
    But, it contains the tools and framework needed to get you working on a solution to your needs.

    That is all it was ever intended to be.

    Juxi

  8. #18
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default

    And nicely-written, at that too Juxi! ::tup
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  9. #19
    Join Date
    Apr 2005
    Posts
    6
    Plugin Contributions
    0

    Default

    Originally posted by nmuta@May 1 2005, 02:40 PM
    I was able to follow everything up until:

    Add column names
    CODE
    C10 = products_model
    D10 = products_name


    what do you mean? paste products_model into cell 10?
    There is nothing below cell C 10 in the workbook, and to the right of it, (in e10), there is
    2;"1";"3";;;"30.0000";"0";"2005-04-09 14:32:44";NULL;NULL;"0.00";"1";"0";"0";"2";"1";"1";"0";"0";"0";"1";"0";"1";"0";" 0";"0";"0";"30.0000";"1";"1"

    etc...

    Please advise!!! Thanks.
    I to am stuck here, with the exception that I don't have this problem: There is nothing below cell C 10 in the workbook, and to the right of it, (in e10), there is
    2;"1";"3";;;"30.0000";"0";"2005-04-09 14:32:44";NULL;NULL;"0.00";"1";"0";"0";"2";"1";"1";"0";"0";"0";"1";"0";"1";"0";" 0";"0";"0";"30.0000";"1";"1"

    ;;Add column names

    CODE

    C10 = products_model
    D10 = products_name

    Now, do I enter this as products_model, or as C10 = products_model, and this goes into sheet2, correct? The trouble I am having is I keep getting NAME# and REF# errors.

    Thanks for any assistance. I am slowly getting there with this script. I'm having to learn both spreadsheeting and sql at the same time 8-P.

  10. #20
    Join Date
    Mar 2004
    Posts
    883
    Plugin Contributions
    1

    Default

    For: nmuta & stiiixy

    First, when I wrote the original message… I went through the process that I had done myself many times and wrote down the steps that I performed. I proofed it for accuracy, but did not actually do one from scratch using the instructions. In trying to recreate the situation that you described, I have gone through it as if I was a first time reader. I've noted a couple typos and some areas that could be worded better. I will submit an edited version to Kim with those changes. I do not expect there will be any substantive differences, only minor editorial changes for clarity.

    RE: Code Blocks
    For the most part, they are intended to be copy / pasted.
    The format is cell reference = code block to be pasted.
    If the code block begins or ends with a <space>, then it is bounded with &#39; &#39; to denote there is a space that must be included. Only the code block should be entered into the referenced cell. The first = is a delimiter between the cell reference and the code block to be pasted and serves no other purpose. Possibly, removing the first = sign would eliminate the confusion.

    RE: The contents in E10
    Because you have something other than product_id in E10, I think one of the early steps was missed.

    Capture information from needed tables
    using CSV in Excel format, with field names in first row, save to file

    Make room for formula and other information
    Insert 9 rows at top of worksheet, column names should be on row 10
    Insert 4 cols at left of worksheet, &#39;products_id&#39; should be in &#39;E10&#39;

    These are important and all subsequent cell references and formulae are dependent on them. Please check to see if that is the problem. (column names should say field names)

    RE: NAME# and REF# errors
    The information above will hopefully clear them.

 

 
Page 2 of 8 FirstFirst 1234 ... LastLast

Similar Threads

  1. Replies: 16
    Last Post: 16 May 2016, 06:10 AM
  2. v139h Product Data Dump to Excel
    By kevinmc3 in forum General Questions
    Replies: 1
    Last Post: 17 Jul 2012, 10:13 PM
  3. Insert new Data With SQLScripts Created In Excel
    By twi in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 15 Mar 2012, 10:57 PM
  4. Excel Data Feed
    By Adds in forum General Questions
    Replies: 2
    Last Post: 11 May 2007, 10:51 AM
  5. update products with data manager?
    By elgabi in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 7 Sep 2006, 10:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR