richc
User
Sep 10, 2009, 10:55 PM
Post #4 of 5
(3147 views)
Shortcut
|
|
Re: [richc] Extracting listings
[In reply to]
|
Can't Post
|
|
In case anyone needs any pointers, it's quite easy if you can drive excel and are competent with phpmyadmin. I had about 200 listings with 30 fields in each so it was worthwhile.
1) Rename your old Listings Manager data file.csv and call it into Excel with the upsidedown ! as a delimiter.
2) Remove all the crap except the listings
3) Enter a listing in your new Instant Realty program, then export the whole table as csv using phpmyadmin.
4) Open in Excel and paste the field names in the top row to help out
5) Copy over the relevant columns of old data to the new file
6) Fill up any blanks with default values and clean up any stray data
7) Save as CSV
8) Use a good text editor eg Notepad++, its free, and replace the exclamation mark thing with | and remove the "" which may surround each text field. Or do it with your excel save options
9) Click on the table in phpadmin, load the file and set the options
10) If it doesn't work you can always delete the data in phpmyadmin, fix the csv and reimport
Or something like that....
Sweet as
|
