Results 1 to 2 of 2

Thread: Bulk data upload into existing database.

  1. #1
    Join Date
    Jan 2008
    Posts
    29

    Question Bulk data upload into existing database.

    I need to upload several records at one time into my existing database.

    I have exported the idx_link.csv file to see the structure since I have added several custom fields to my site.

    I want to make sure that I don't overwrite my database (yes, I backed it up), so how do I add the new records?

    Can I just start at the next record number?
    Do I add them through phpMyAdmin using the Import function?
    Can someone please give me a step by step for this?
    Thanks!

  2. #2
    Join Date
    Jun 2002
    Location
    Winnipeg Canada
    Posts
    4,913

    Default

    All you really need to know is the last record number and the category, the rest could be done in the excel spreadsheet I posted on the forum (link below). Once it's done, export it as a tab delimited text file and import it via the admin panel. Instructions on how to use the spreadsheet are included.

    Don't import the database again, as it can actually cause issues because IndexU will allow certain characters (and escape them) but when you try to import them via phpmyadmin they will not be escaped and will create errors.

    The spreadsheet can be see here http://www.nicecoder.com/community/s...ead.php?t=5118

Similar Threads

  1. Replies: 8
    Last Post: 06-16-2007, 02:51 PM
  2. Bulk add
    By vittle in forum v5.x
    Replies: 4
    Last Post: 08-04-2005, 07:53 AM
  3. Change to data in database
    By morgankd in forum v5.x
    Replies: 1
    Last Post: 06-24-2004, 01:05 AM
  4. How to import existing database
    By Veg in forum v5.x
    Replies: 2
    Last Post: 05-20-2002, 08:33 PM

Posting Permissions

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