| ||||||
 |
| | LinkBack | أدوات الموضوع | انواع عرض الموضوع |
|
#1
05-12-2009, 07:40 AM
| ||
| ||
| I'm trying to import book review data from another MySQL db and have a capable friend who's willing to give this a shot. I have the data in an Excel sheet, and my friend is already familiar with the original MySQL db, if that helps. As a head-start he's asked me to find out which fields/tables he needs to alter in order to pull in the data as threads in a specific vB forum. Could someone identify the fields & tables that we need to map for the import? Below are the existing fields we need to map. (the format is "existing-db --> vB db") title --> Thread Title author names --> vB custom field (provided via a mod, we'll figure it out) category --> Thread Prefix cover photo --> 1st attachment of thread's 1st post review title --> Post Title (or thread title if first post) review --> Post Contents date --> Date rating --> Thread Rating username --> Username Firstly, I have previously imported the old db's users. They're in vB with the same username & email address, and I used the 'hidden' field via ImpEx to maintain the old db's userids. Some of the reviews ("threads") have multiple reviews ("posts") per book, so each review/post after the first would just be replies to the thread. I mention this because I'm not sure if vB differentiates between the same fields depending on thread-starter or reply-poster. I also need to know where to put the cover photos -- vB attachments are currently in the filesystem, not the db, so I would think I can just copy those into the attachment directory. I'm not sure how to reflect that in the vB db filed re: filenames. I had hoped that ImpEx would have an open-import option that might allow me to just map source fields to destination fields so that I could to this myself, but since there isn't such an option I'm appealing to anyone who can point me in the right direction. Thanks so much. I couldn't find developer documentation on the schema (if there is a resource for this, I'd appreciate someone pointing it out for me!). cheers. __DEFINE_LIKE_SHARE__  |
|
| مواقع النشر (المفضلة) |
« NTI Media Maker 8 Premium v8.0.0.6316اافضل من النيرو
|
حصريا CheatBook Issue April 2009 لشفرات جميع الالعاب »
العرض العادي
| |
المواضيع المتشابهه | ||||
| الموضوع | كاتب الموضوع | المنتدى | مشاركات | آخر مشاركة |
| Importing very large MySQL database | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 05-20-2010 07:10 AM |
| Importing data from a CSV file into vBulletin 4 using ImpEx | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-05-2010 08:28 PM |
| Forum Importing data after the fact. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 12-25-2009 05:48 AM |
| Need some suggestions on a Mysql/data issue. | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 07-09-2009 01:40 AM |
| Forum showing 0 threads / 0 posts but there are threads/posts... | محروم.كوم | منتدى أخبار المواقع والمنتديات العربية والأجنبية | 0 | 04-14-2009 11:50 PM |
الساعة الآن 07:19 PM
- اخبار رياضية
- اخبار الامارات
- اخبار ريال مدريد
- اخبار برشلونه
- العاب فلاش
- مسلسلات وافلام
- مسجات
- فيديو كليبات
- سيارات للبيع
- ارقام سيارات
- ارقام هواتف
- هواتف للبيع
- حيوانات للبيع
- قوارب ويخوت للبيع
- ملابس واكسسوارات
- ساعات ومجوهرات
- اناشيد اسلامية
- نغمات اناشيد
- نغمات اسلامية
- ادعية اسلامية
- رقية شرعية
- قران كريم
- ديبيات اسلامية
- اذكار المسلم
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227