Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Question Unanswered: How in the HELL do I do this!?!?!?!?

    I need to set up a data feed. I have some code from the merchant that I am affiliated with. I don't have an Idea how this works. I don't know how to set up a database, or a data feed. Can someone help me out? Or at least point me in the right direction? Any help that I can get with this will be very much appreciated...

    Info from the merchant:

    The data feed file is a standard tab delimited text file with these features:
    Simple 8-bit text file, i.e. not Unicode.
    Field names are in the first row.
    Fields are delimited by the tab character.
    Lines are delimited by newline & carriage return characters, i.e. standard windows text file format.
    Character fields are NOT enclosed by quotes.

    More info from the merchant:

    File Fields:
    Name – Name of Product. Character Field, Up to 128 Characters.
    Description – Short Description of Product in text. No HTML. Character Field, Up to 1024 Characters, although most descriptions will be only 3-4 lines long.
    SKU – Product SKU. Character Field, Up to 20 Characters.
    URL_Product – URL for product. This URL includes your affiliate code so that you can be paid for the referral. Character Field, Up to 255 Characters.
    URL_Image_Small – Location of Small product image hosted by ZZ/SDM. Character Field, Up to 255 Characters.
    URL_image_Large – Location of Large product image hosted by ZZ/SDM. Character Field, Up to 255 Characters.
    Price – Actual zZounds selling price. Manufacturers sometimes restrict us from show prices for some items. If the price is missing, then “Call zZounds for price must be shown.” You may choose to display only products where a price can be shown. Numeric Field.
    Price_High – High selling price range. For most products, this field will be missing. It will be present for items like guitars, where the price can vary according to the guitar’s color and/or finish. If this field is populated, then you should show the price as occurring in a range between the Price field and this Price_High field, e.g. “from $259.00 to $329.00”. Numeric Field.
    Price_List – List price of product. Numeric Field.
    Category – Leaf category for product. Character Field, Up to 64 Characters.
    Manufacturer – Manufacturer name of product. Character Field, Up to 64 Characters.
    Shipping_Cost – Minimum (ground) shipping cost to customer. If 0, then shipping is free and this should be noted on your site as “Free Shipping” or something similar. Users may feel that a shipping price of $0 is inaccurate and represents a bug. Numeric Field.


    Here's a little of the data feed that the merchant gave me:

    Name Description SKU URL_Product URL_Image_Small URL_Image_Large Price Price_High Price_List Category Manufacturer Shipping_Cost
    Aardvark Aark24 Professional Studio System with Magix Audio Studio 7 Deluxe (Windows) Built upon a decade of experience in engineering high-end digital audio gear, the Aark24's premium 24-bit outboard A/D converters and innovative design give your sound supreme clarity and precise accuracy. You'll notice the difference in any recording session where sonic excellence is an absolute must. AARAARK24 http://www.zzounds.com/a--57287/item...OWN Aardvark 0
    Aardvark DirectPro 24/96 PC Studio Interface with Magix Audio Studio 7 Deluxe (Windows) Finally, there's a system that allows you to capture your creative spirit directly to the PC from anywhere in your professional studio. The Direct Pro 24/96 features 4 high quality class A mic preamps with combo XLR/¼ in. inputs, 6 outputs, 24-bit/96kHz, SPDIF 2 ms Latency, SPDIF, and MIDI. The powerful DSP mixing control panel and direct mic/line inputs make the 24/96 the perfect solution to record directly to your computer without a mixer. Includes DSP Reverb, EQ & on-board compressor and shielded PCI card for pristine sound. It works well with all recording software such as Cubase SX, SONAR. PC/MAC, ASIO, GSIF, etc. AARDIRECTPRO2496 http://www.zzounds.com/a--57287/item...95 699.00 PCI Audio Interfaces Aardvark 0
    Aardvark Direct Pro LX6 PCI Audio Interface with Magix Audio Studio 7 Deluxe (Windows) The Direct Pro LX6 is one of the latest additions to the new Direct Pro Series, Aardvark's line of all-in-one professional hard disk recording interfaces, which began with the popular Direct Pro 24/96. The LX6 is a professional 4 in/6 out, 24-bit, 96 kHz audio interface with a powerful DSP that replaces the need for outboard effects and outboard mixers. Now with 88.2 kHz support! AARPROLX6 http://www.zzounds.com/a--57287/item...95 499.00 PCI Audio Interfaces Aardvark 0
    Aardvark Direct Pro Q10 PCI Audio Interface with Magix Audio Studio 7 Deluxe (Windows) The Direct Pro Q10 is the latest entry to Aardvark's innovative Direct Pro Series, which began with the popular Direct Pro 2496 and has grown to include the Direct Pro LX6 and the Direct Mix USB3. AARQ10 http://www.zzounds.com/a--57287/item...5 1099.00 PCI Audio Interfaces Aardvark 0
    Aardvark Direct Mix USB3 Audio Interface (Macintosh and Windows) The USB3 is an easy to use USB audio interface with everything you need to record, playback, and monitor pro-quality audio from any Mac, PC or laptop. With 24-bit A/D converters, stereo 1/4 in. I/O, mic input, headphone jack with level controls, EFRTM guitar input, and complete recording software for PC/Mac, it makes the perfect compact, pro audio recording solution. AARUSB3 http://www.zzounds.com/a--57287/item...95 299.00 USB Audio Interfaces Aardvark 0
    Abilene Bronze Acoustic Guitar Strings (Light) Abilene acoustic guitar strings are formulated to deliver a rich and vibrant live performance. Every set utilizes premium alloys to enhance longevity and tonal alloys to enhance longevity and tonal to meet the exacting specification for each individual gauge. Each string is individually sealed to protect it from oxidation -- insuring untarnished performance with every set. You'll hear and feel the difference. ABLASLT http://www.zzounds.com/a--57287/item... 9.95 Acoustic Guitar Strings - 6 Strings Abilene 4.99
    Abilene Bronze Acoustic Guitar Strings (Medium) Abilene acoustic guitar strings are formulated to deliver a rich and vibrant live performance. Every set utilizes premium alloys to enhance longevity and tonal alloys to enhance longevity and tonal to meet the exacting specification for each individual gauge. Each string is individually sealed to protect it from oxidation -- insuring untarnished performance with every set. You'll hear and feel the difference. ABLASMD http://www.zzounds.com/a--57287/item... 9.95 Acoustic Guitar Strings - 6 Strings Abilene 4.99
    Abilene PU100 Acoustic Guitar Pickup The Abilene PU-100 is a great sounding magnetic acoustic pickup that mounts easily in the soundhole of your favorite acoustic guitar. Features include volume and tone controls, detachable 1/4 in. cable, and an easily removable soundhole clip. ABLPU100 http://www.zzounds.com/a--57287/item...69.95 Acoustic Guitar Pickups Abilene 4.99

  2. #2
    Join Date
    Mar 2004
    Posts
    2
    If someone could at least help with creating a database in MySQL using this info, that would be wonderful!

  3. #3
    Join Date
    Mar 2004
    Posts
    8
    Originally posted by BadAssRocker
    If someone could at least help with creating a database in MySQL using this info, that would be wonderful!
    Import into MS Access as text file createing a new table. There U will see table structure. Follow mySQL manual how to create table similar to MS ACCESS one.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •