[SMF Converter] phpBB - 2.0.19+

[Azasuke]

Actually the converter failed 4 me it convert only 3200 post of 4000+

[njahnke]

hi,

i'm in the process of testing out smf with my enormous, heavily modded phpbb. with your help (searching other topics in this subforum) i was able to convert as far as step=2&substep=6&start=3700. this involved ignoring one duplicate key error for topics and increasing max_allowed_packet to get some of the larger posts through.

unfortunately:

Recalculating forum statistics... Unsuccessful!
This query:
ALTER TABLE `smf`.smf_smileys
ORDER BY LENGTH(code) DESC;
Caused the error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LENGTH(code) DESC' at line 2

syntax error!? any help would be much appreciated. thanks in advance.

edit: i'm using mysql 5.0.37.

[marlarkey]

Hi,

I must be really dense but I'm having a lot of trouble with this and would really appreciate some help...

I have downloaded the conversion kit from the download page (convert.php and phpBB2_to_smf.sql) but I see lots of references in this thread to "downloading the attachment from here".... but I can't find any attachments.  Where are they ?  All I can find are circular links that take me back to this thread ?!  Duh, how dense am I ?


Anyway, before trying this out on my forum I'm trying it out locally on my xampp localhost server.  I have the phpBB2 board and the smf board installed using the same xampp mysql database (using phpbb_ and smf_ table prefixes).  Both boards are working fine.

I have uploaded convert.php and phpBB2_to_smf.sql to the SMF folder..

Then when I run convert.php it brings up the page at which I enter the addresses of the two boards and I click PROCEED....

...then I get pages and pages of error messages and none of the phpBB2 data is loaded into the smf board::::

Code Select Expand


Notice: Undefined index: convert_script in C:\Program Files\xampp\htdocs\smf\convert.php on line 580

Warning: Invalid argument supplied for foreach() in C:\Program Files\xampp\htdocs\smf\convert.php on line 583

Notice: Undefined index: convert_script in C:\Program Files\xampp\htdocs\smf\convert.php on line 588

Warning: file(C:\Program Files\xampp\htdocs\smf/) [function.file]: failed to open stream: Permission denied in C:\Program Files\xampp\htdocs\smf\convert.php on line 588

Warning: Invalid argument supplied for foreach() in C:\Program Files\xampp\htdocs\smf\convert.php on line 597
Successful.
Recalculating forum statistics...
Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 935

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 945

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 953

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 963

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 976

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 989

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1035

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1037

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1043

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1049

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1060

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1061

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1069

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1071

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1077

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1078

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1084

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1085

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1109

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1111

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1117

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1129

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1154

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1156

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1192

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1193

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1231

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1236

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1297

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1299

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1335

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1354

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1827

Notice: Undefined variable: result in C:\Program Files\xampp\htdocs\smf\convert.php on line 1828

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1377

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in C:\Program Files\xampp\htdocs\smf\convert.php on line 1378
Successful.

Code tag.

[JayBachatero]

Actually the converter failed 4 me it convert only 3200 post of 4000+

Did you try running the conversion again?

njahnke What convert.php are you using?

marlarkey in the first post there is a .sql file attached used that.

[Naa]

marlarkey in the first post there is a .sql file attached used that.

I'm having the same problem as marlarkey, I have the convert.php (the right one for phpBB) and the sql (that I got attached from the first post) in the root directory of a fresh installed SMF and I'm trying to convert from a phpBB 2.0.22 (/forum) to SMF (/forums) and I'm getting the exact same errors.  The paths are correct.

[taxidriva]

I have the same problem "duplicate entry..." trying to convert from phpbb 2.0.21 to SMF and looked in many threads here and noone actually gives any solution, just links to this post saying to download file from here - we all did, and he problem still exists. Please help

edit: well nevermind it seems that i downloaded this file as .htm and didnt overwrite the old one when uploading to the server, so the converting was still done with he old one. Now I changed it to .sql and it worked fine and convertion was succesfull

[williamb]

Okay I have read (http://docs.simplemachines.org/index.php?topic=15) and most of this topic, lots of info here.  But I do have some questions...

FIRST My Setup
1) SMF is installed on the same database as my phpBB using the prefix of smf_ and it is running
2) nothing has been configured or altered

Now I would like to ask some straight forward questions about going forward further with the conversion from phpBB.
1) Do I need to set up the categories and permisions in SMF or does the conversion do that for me from my phpBB data?

2) When converting does it leave the phpBB data intact so that our users can continue to use the phpBB site until we are ready to turn it over to SMF?

3) Is it recommended during the conversion process to turn off the phpBB while undergoing this procedure?

4) Can I install packages, mods, skins, etc before a final conversion to get the forums to have the features and look I want?

5) Last and most important, I assume it will over write the number 1 member, that is me the admin on the new SMF forum with the number 1 member from phpBB.

Thanks everyone in advance.

[margarett]

1 - Converter will pick most of  it. It's recommended that you have a look at the permissions after, anyway.
2 - Yes
3 - It's recommended that you have it in maintenance mode
4 - Yes, if they do not interfere with database. As for themes, graphics, etc, no problem.
5 - All existing SMF database information will be overwritten. The created SMF admin will be gone.

6 - You did not asked for it but here it goes. I recommend that you convert more than once, so that you can go and adjust SMF, get familiar, and do it over and over.
6.1 - You might want to move SMF to a different folder after install. Take a look at "repair_settings.php" in the downloads page.

[williamb]

Thanks very much Margarett and as for 6 & 6.1, I kinda figured those.  Thank you very much!

[SNAFU0185]

Im running phpBB 2.0.21 and i get several error messages about avitars etc but am able to get past those the one that grinds me to a halt is
[code]Converting...
Converting topics... Unsuccessful!
This query:

    INSERT INTO `ourcave_biz_-_smf`.smf_topics
    (ID_TOPIC, isSticky, ID_FIRST_MSG, ID_LAST_MSG, ID_MEMBER_STARTED, ID_MEMBER_UPDATED, ID_BOARD, ID_POLL, locked, numReplies, numViews)
    VALUES ('957', '0', '34348', '34348', '57', '57', '42', '', '0', '0', '0'),
    ('958', '0', '34349', '34349', '57', '57', '42', '', '0', '0', '0'),
    ('959', '0', '34350', '34350', '57', '57', '32', '', '0', '0', '0'),
    ('960', '0', '34352', '34352', '57', '57', '28', '', '0', '0', '0'),
    ('961', '0', '34354', '34354', '57', '57', '42', '', '0', '0', '1'),
    ('962', '0', '34357', '34357', '57', '57', '32', '', '0', '0', '0'),
    ('963', '0', '34362', '34362', '57', '57', '28', '', '0', '0', '0'),
    ('965', '0', '34364', '34364', '57', '57', '32', '', '0', '0', '0'),
    ('966', '0', '34369', '34369', '57', '57', '32', '', '0', '0', '1'),
    ('968', '0', '34371', '34371', '57', '57', '32', '', '0', '0', '0'),
    ('969', '0', '34372', '34372', '57', '57', '28', '', '0', '0', '0'),
    ('970', '0', '34373', '34373', '57', '57', '28', '', '0', '0', '0'),
    ('972', '0', '34386', '37695', '57', '57', '19', '', '0', '106', '5774'),
    ('973', '0', '34421', '34449', '57', '63', '16', '', '0', '5', '103'),
    ('975', '0', '34447', '34447', '57', '57', '32', '', '0', '0', '1'),
    ('976', '0', '34448', '34448', '57', '57', '28', '', '0', '0', '0'),
    ('977', '0', '34452', '34458', '57', '46', '16', '', '0', '3', '41'),
    ('980', '0', '34480', '34480', '57', '', '32', '', '0', '0', '0'),
    ('981', '0', '34481', '34481', '57', '', '28', '', '0', '0', '0'),
    ('982', '0', '34482', '34482', '57', '', '28', '', '0', '0', '0'),
    ('983', '0', '34525', '34525', '57', '', '42', '', '0', '0', '0'),
    ('984', '0', '34543', '34543', '57', '', '32', '', '0', '0', '0'),
    ('987', '0', '34555', '34555', '57', '', '28', '', '0', '0', '0'),
    ('988', '1', '34619', '46039', '57', '186', '16', '', '0', '19', '940'),
    ('989', '0', '34587', '34687', '159', '159', '9', '', '0', '3', '125'),
    ('990', '0', '34592', '34592', '57', '57', '32', '', '0', '0', '0'),
    ('991', '0', '34593', '34593', '57', '57', '43', '', '0', '0', '4'),
    ('992', '0', '34596', '34596', '57', '57', '19', '', '0', '0', '70'),
    ('995', '0', '34616', '34616', '57', '57', '28', '', '0', '0', '3'),
    ('996', '0', '34617', '34617', '57', '57', '32', '', '0', '0', '2'),
    ('997', '0', '34618', '34671', '57', '68', '16', '', '0', '6', '202'),
    ('999', '0', '34627', '38711', '65', '57', '22', '', '0', '70', '1536'),
    ('1001', '0', '34665', '34689', '160', '2', '9', '', '0', '2', '106'),
    ('1004', '0', '34726', '34731', '57', '63', '39', '', '0', '1', '12'),
    ('1005', '0', '24326', '29752', '57', '', '45', '', '0', '2', '0'),
    ('1006', '0', '34736', '34736', '57', '57', '19', '', '0', '0', '57'),
    ('1007', '0', '34738', '34738', '57', '57', '32', '', '0', '0', '2'),
    ('1008', '0', '34739', '34739', '57', '57', '28', '', '0', '0', '0'),
    ('1009', '0', '34741', '34830', '-1', '57', '16', '', '0', '4', '120'),
    ('1010', '0', '34752', '34752', '57', '57', '39', '', '0', '0', '1'),
    ('1012', '0', '34756', '34761', '57', '57', '39', '', '0', '2', '5'),
    ('1013', '0', '34763', '34763', '57', '57', '28', '', '0', '0', '1'),
    ('1014', '0', '34765', '34783', '-1', '57', '25', '', '0', '3', '131'),
    ('1016', '0', '34779', '34813', '57', '63', '43', '', '0', '1', '3'),
    ('1020', '0', '34799', '34799', '46', '46', '43', '', '0', '0', '2'),
    ('1021', '0', '34800', '34800', '46', '46', '42', '', '0', '0', '8'),
    ('1022', '0', '34801', '34819', '46', '46', '43', '', '0', '2', '7'),
    ('1023', '0', '34802', '34843', '46', '46', '42', '', '0', '2', '9'),
    ('1024', '0', '34803', '34803', '46', '46', '42', '', '0', '0', '2'),
    ('1025', '0', '34811', '34831', '46', '57', '16', '', '0', '4', '106'),
    ('1026', '0', '34816', '34829', '63', '57', '39', '', '0', '1', '4'),
    ('1027', '0', '34820', '34820', '46', '46', '42', '', '0', '0', '1'),
    ('1028', '0', '34827', '34827', '105', '105', '8', '', '0', '0', '40'),
    ('1029', '0', '34800', '34800', '46', '46', '42', '', '0', '0', '4'),
    ('1030', '0', '34842', '34915', '46', '23', '16', '', '0', '5', '113'),
    ('1031', '0', '34844', '34844', '46', '46', '28', '', '0', '0', '2'),
    ('1032', '0', '34849', '34914', '-1', '23', '16', '', '0', '6', '111'),
    ('1036', '0', '34891', '38242', '57', '177', '16', '', '0', '19', '281'),
    ('1038', '0', '34899', '34929', '2', '-1', '3', '', '0', '2', '94'),
    ('1041', '0', '34955', '35245', '57', '57', '39', '', '0', '6', '18'),
    ('1042', '0', '34956', '34956', '57', '57', '32', '', '0', '0', '1'),
    ('1044', '0', '34970', '34970', '57', '57', '43', '', '0', '0', '3'),
    ('1049', '0', '35022', '35054', '2', '57', '4', '', '0', '1', '10'),
    ('1051', '0', '35057', '39335', '57', '57', '43', '', '0', '13', '31'),
    ('1052', '0', '35062', '35078', '57', '2', '19', '', '0', '2', '97'),
    ('1054', '0', '35088', '38152', '57', '177', '26', '', '0', '3', '50'),
    ('1057', '0', '35139', '35139', '2', '2', '21', '', '1', '0', '5'),
    ('1058', '0', '35141', '35141', '57', '57', '19', '', '0', '0', '49'),
    ('1059', '0', '35142', '35142', '57', '57', '42', '', '0', '0', '1'),
    ('1060', '0', '35143', '35143', '57', '57', '42', '', '0', '0', '1'),
    ('1061', '0', '35144', '35144', '57', '57', '42', '', '0', '0', '0'),
    ('1062', '0', '35145', '35145', '57', '57', '42', '', '0', '0', '1'),
    ('1063', '0', '35147', '35147', '57', '57', '32', '', '0', '0', '0'),
    ('1064', '0', '35148', '35148', '57', '57', '28', '', '0', '0', '0'),
    ('1065', '0', '35151', '35151', '57', '57', '43', '', '0', '0', '1'),
    ('1066', '0', '35152', '35152', '57', '57', '43', '', '0', '0', '4'),
    ('1067', '0', '35153', '35153', '57', '57', '39', '', '0', '0', '5'),
    ('1069', '1', '35196', '43348', '57', '200', '8', '', '0', '11', '258'),
    ('1070', '0', '35198', '39024', '2', '171', '11', '', '0', '6', '104'),
    ('1071', '0', '35203', '36398', '171', '174', '11', '', '0', '4', '133'),
    ('1072', '0', '35204', '35264', '171', '171', '22', '', '0', '8', '164'),
    ('1073', '0', '35218', '35218', '57', '57', '40', '', '0', '0', '2'),
    ('1075', '0', '35224', '38545', '171', '171', '22', '', '0', '32', '667'),
    ('1076', '0', '35243', '35243', '63', '63', '10', '', '0', '0', '10'),
    ('1077', '0', '35265', '45067', '171', '87', '22', '', '0', '30', '748'),
    ('1078', '0', '35266', '35755', '171', '171', '16', '', '0', '28', '383'),
    ('1080', '0', '35272', '35289', '171', '171', '8', '', '0', '2', '61'),
    ('1081', '0', '35273', '35273', '171', '171', '8', '', '0', '0', '34'),
    ('1082', '0', '35275', '35275', '57', '57', '46', '', '0', '0', '7'),
    ('1083', '0', '35276', '35276', '57', '57', '46', '', '0', '0', '3'),
    ('1084', '0', '35283', '35348', '2', '2', '15', '', '0', '7', '35'),
    ('1085', '0', '35275', '35275', '57', '57', '32', '', '0', '0', '0'),
    ('1086', '0', '35276', '35276', '57', '57', '32', '', '0', '0', '0'),
    ('1087', '1', '35287', '35301', '57', '63', '46', '', '0', '1', '6'),
    ('1090', '0', '35331', '35331', '171', '171', '8', '', '0', '0', '26'),
    ('1091', '0', '35332', '35332', '171', '171', '8', '', '0', '0', '28'),
    ('1092', '0', '35333', '35333', '171', '171', '8', '', '0', '0', '38'),
    ('1093', '0', '35336', '35384', '171', '57', '26', '', '0', '3', '77'),
    ('1094', '0', '35354', '35892', '57', '57', '19', '', '0', '12', '580'),
    ('1095', '0', '35355', '35817', '57', '57', '46', '', '0', '2', '5'),
    ('1096', '0', '35356', '35356', '57', '57', '46', '', '0', '0', '3'),
    ('1097', '0', '35357', '35357', '57', '57', '46', '', '0', '0', '4'),
    ('1098', '0', '35368', '35373', '171', '57', '30', '', '0', '1', '11'),
    ('1099', '0', '35371', '35371', '57', '57', '28', '', '0', '0', '0'),
    ('1100', '0', '35372', '35413', '46', '171', '16', '', '0', '6', '74'),
    ('1101', '0', '35374', '35374', '57', '57', '32', '', '0', '0', '0'),
    ('1102', '0', '35376', '35376', '57', '57', '39', '', '0', '0', '0'),
    ('1103', '0', '35377', '35434', '57', '63', '40', '', '0', '1', '3'),
    ('1104', '0', '35378', '35522', '57', '171', '28', '', '0', '1', '3'),
    ('1105', '0', '35380', '35380', '57', '57', '30', '', '0', '0', '0'),
    ('1106', '0', '35381', '35381', '57', '57', '32', '', '0', '0', '0'),
    ('1107', '0', '35382', '35382', '57', '57', '28', '', '0', '0', '3'),
    ('1108', '0', '35388', '46365', '171', '187', '22', '', '0', '194', '5709'),
    ('1110', '0', '35409', '35409', '172', '172', '49', '', '0', '0', '24'),
    ('1111', '0', '35457', '35457', '57', '57', '39', '', '0', '0', '0'),
    ('1112', '0', '35458', '35458', '57', '57', '40', '', '0', '0', '2'),
    ('1113', '0', '35459', '35459', '57', '57', '46', '', '0', '0', '3'),
    ('1115', '0', '35530', '37497', '57', '14', '16', '', '0', '4', '63'),
    ('1116', '0', '35536', '35538', '171', '171', '30', '', '0', '2', '9'),
    ('1117', '0', '35540', '35540', '2', '2', '47', '', '1', '0', '499'),
    ('1118', '1', '35541', '35541', '2', '2', '48', '', '1', '0', '11'),
    ('1121', '0', '35552', '35552', '57', '57', '32', '', '0', '0', '0'),
    ('1122', '0', '35553', '35553', '57', '57', '28', '', '0', '0', '1'),
    ('1123', '0', '35559', '35559', '57', '57', '26', '', '0', '0', '28'),
    ('1125', '0', '35597', '35597', '57', '57', '28', '', '0', '0', '1'),
    ('1126', '0', '35598', '35598', '57', '57', '28', '', '0', '0', '0'),
    ('1127', '0', '35677', '38036', '75', '75', '8', '', '0', '4', '100'),
    ('1128', '0', '35707', '35707', '57', '57', '28', '', '0', '0', '0'),
    ('1129', '0', '35708', '35708', '57', '57', '30', '', '0', '0', '2'),
    ('1130', '0', '35709', '35709', '57', '57', '28', '', '0', '0', '0'),
    ('1131', '0', '35751', '35751', '57', '57', '32', '', '0', '0', '2'),
    ('1132', '0', '35752', '35752', '57', '57', '28', '', '0', '0', '0'),
    ('1133', '0', '35808', '35808', '57', '57', '43', '', '0', '0', '2'),
    ('1134', '0', '35812', '35812', '57', '57', '43', '', '0', '0', '1'),
    ('1135', '0', '35813', '35813', '57', '57', '43', '', '0', '0', '1'),
    ('1136', '0', '35814', '35814', '57', '57', '43', '', '0', '0', '0'),
    ('1137', '0', '35815', '35815', '57', '57', '43', '', '0', '0', '0'),
    ('1138', '0', '35816', '35816', '57', '57', '43', '', '0', '0', '0'),
    ('1139', '0', '35818', '35818', '57', '57', '46', '', '0', '0', '5'),
    ('1140', '0', '35819', '35819', '57', '57', '28', '', '0', '0', '1'),
    ('1141', '0', '35820', '35820', '57', '57', '39', '', '0', '0', '0'),
    ('1142', '0', '35821', '35821', '57', '57', '41', '', '0', '0', '1'),
    ('1143', '0', '35822', '35822', '57', '57', '41', '', '0', '0', '1'),
    ('1144', '0', '35823', '35823', '57', '57', '41', '', '0', '0', '1'),
    ('1145', '0', '35824', '35824', '57', '57', '41', '', '0', '0', '2'),
    ('1146', '0', '35825', '35825', '57', '57', '41', '', '0', '0', '1'),
    ('1147', '0', '35843', '36737', '40', '40', '9', '', '0', '20', '439'),
    ('1148', '0', '35844', '37430', '57', '2', '15', '', '0', '3', '23'),
    ('1150', '0', '35863', '46434', '57', '57', '16', '', '0', '447', '8684'),
    ('1151', '0', '35946', '35946', '57', '57', '32', '', '0', '0', '0'),
    ('1152', '0', '35947', '35947', '57', '57', '28', '', '0', '0', '0'),
    ('1153', '0', '35948', '35948', '57', '57', '28', '', '0', '0', '0'),
    ('1154', '0', '35949', '35949', '57', '57', '28', '', '0', '0', '0'),
    ('1155', '0', '35950', '35950', '57', '57', '28', '', '0', '0', '0'),
    ('1156', '0', '35951', '37020', '57', '57', '19', '', '0', '3', '98'),
    ('1157', '0', '35970', '35971', '171', '57', '10', '', '0', '1', '14'),
    ('1158', '0', '35972', '35972', '57', '57', '39', '', '0', '0', '0'),
    ('1159', '0', '35973', '35973', '57', '57', '32', '', '0', '0', '2'),
    ('1160', '0', '35974', '35974', '57', '57', '28', '', '0', '0', '0'),
    ('1161', '0', '35975', '35975', '57', '57', '28', '', '0', '0', '1'),
    ('1162', '0', '35976', '35976', '57', '57', '28', '', '0', '0', '0'),
    ('1163', '0', '35981', '36044', '57', '57', '16', '', '0', '1', '16'),
    ('1164', '0', '36028', '36028', '57', '57', '10', '', '0', '0', '13'),
    ('1165', '0', '36046', '36046', '57', '57', '32', '', '0', '0', '1'),
    ('1166', '0', '36125', '36125', '57', '57', '10', '', '0', '0', '6'),
    ('1167', '0', '36210', '36237', '57', '63', '43', '', '0', '1', '3'),
    ('1168', '0', '36211', '36540', '2', '57', '16', '', '0', '8', '134'),
    ('1169', '0', '36216', '36241', '40', '57', '19', '', '0', '1', '62'),
    ('1170', '0', '36261', '36294', '57', '63', '26', '', '0', '1', '38'),
    ('1171', '0', '36281', '36281', '57', '57', '10', '', '0', '0', '14'),
    ('1172', '0', '36283', '36283', '57', '57', '10', '', '0', '0', '15'),
    ('1173', '0', '36345', '36345', '57', '57', '32', '', '0', '0', '1'),
    ('1174', '0', '36346', '36346', '57', '57', '28', '', '0', '0', '0'),
    ('1175', '0', '36347', '36347', '57', '57', '28', '', '0', '0', '1'),
    ('1176', '0', '36348', '36348', '57', '57', '28', '', '0', '0', '0'),
    ('1177', '0', '36349', '36349', '57', '57', '32', '', '0', '0', '0'),
    ('1178', '0', '36350', '36350', '57', '57', '28', '', '0', '0', '1'),
    ('1179', '0', '36351', '36351', '57', '57', '28', '', '0', '0', '0'),
    ('1180', '0', '36352', '36352', '57', '57', '28', '', '0', '0', '0'),
    ('1181', '0', '36353', '36353', '57', '57', '28', '', '0', '0', '0'),
    ('1182', '0', '36354', '36438', '57', '63', '39', '', '0', '1', '5'),
    ('1183', '0', '36356', '40925', '57', '177', '16', '', '0', '14', '562'),
    ('1184', '0', '36358', '44967', '57', '177', '23', '', '0', '7', '159'),
    ('1185', '0', '36367', '46435', '57', '57', '16', '', '0', '331', '9566'),
    ('1186', '0', '36372', '36378', '57', '57', '19', '', '0', '1', '51'),
    ('1187', '0', '36373', '36467', '173', '173', '11', '', '0', '3', '86'),
    ('1192', '0', '36426', '43263', '57', '63', '19', '', '0', '53', '1551'),
    ('1193', '0', '36397', '36411', '174', '171', '11', '', '0', '3', '86'),
    ('1195', '0', '36437', '39843', '63', '177', '16', '', '0', '2', '85'),
    ('1196', '0', '36441', '36441', '57', '57', '28', '', '0', '0', '5'),
    ('1197', '0', '36469', '36598', '174', '57', '3', '', '0', '7', '122'),
    ('1198', '0', '36476', '36533', '174', '57', '30', '', '0', '4', '14'),
    ('1199', '0', '36531', '38080', '57', '57', '48', '', '0', '5', '18'),
    ('1200', '0', '36543', '39031', '57', '171', '10', '', '0', '3', '41'),
    ('1201', '0', '36552', '36555', '171', '57', '22', '', '0', '1', '53'),
    ('1203', '0', '36561', '36561', '57', '57', '32', '', '0', '0', '1'),
    ('1204', '0', '36562', '36562', '57', '57', '42', '', '0', '0', '1'),
    ('1205', '0', '36563', '36563', '57', '57', '42', '', '0', '0', '1'),
    ('1206', '0', '36564', '36564', '57', '57', '42', '', '0', '0', '0'),
    ('1207', '0', '36565', '36565', '57', '57', '42', '', '0', '0', '0'),
    ('1208', '0', '36566', '36566', '57', '57', '42', '', '0', '0', '0'),
    ('1209', '0', '36567', '36567', '57', '57', '42', '', '0', '0', '0'),
    ('1210', '0', '36568', '39314', '57', '57', '43', '', '0', '2', '4'),
    ('1211', '0', '36572', '36673', '171', '57', '8', '', '0', '2', '91'),
    ('1212', '0', '36615', '36642', '57', '63', '16', '', '0', '2', '23'),
    ('1213', '0', '36616', '37314', '42', '57', '11', '', '0', '6', '120'),
    ('1214', '0', '36639', '36641', '57', '63', '16', '', '0', '1', '22'),
    ('1215', '0', '36666', '36666', '57', '57', '28', '', '0', '0', '2'),
    ('1216', '0', '36672', '36691', '57', '63', '39', '', '0', '1', '3'),
    ('1217', '0', '36741', '37133', '57', '57', '16', '', '0', '4', '52'),
    ('1218', '0', '36742', '39123', '171', '171', '22', '', '0', '35', '730'),
    ('1219', '0', '36744', '36744', '57', '57', '32', '', '0', '0', '1'),
    ('1220', '0', '36745', '36745', '57', '57', '40', '', '0', '0', '2'),
    ('1221', '0', '36746', '36746', '57', '57', '39', '', '0', '0', '1'),
    ('1222', '0', '36747', '36747', '57', '57', '28', '', '0', '0', '0'),
    ('1223', '0', '36748', '36748', '57', '57', '28', '', '0', '0', '1'),
    ('1224', '0', '36749', '36749', '57', '57', '28', '', '0', '0', '1'),
    ('1225', '0', '36776', '36777', '63', '57', '10', '', '0', '1', '24'),
    ('1226', '0', '36809', '36809', '57', '57', '10', '', '0', '0', '22'),
    ('1227', '0', '36888', '45142', '57', '87', '22', '', '0', '15', '567'),
    ('1228', '0', '36916', '37328', '171', '171', '8', '', '0', '8', '148'),
    ('1229', '0', '36932', '36988', '57', '63', '26', '', '0', '1', '29'),
    ('1230', '0', '36981', '36981', '57', '57', '10', '', '0', '0', '7'),
    ('1231', '0', '36983', '36983', '57', '57', '32', '', '0', '0', '1'),
    ('1232', '0', '36984', '36984', '57', '57', '28', '', '0', '0', '0'),
    ('1233', '0', '36985', '36985', '57', '57', '39', '', '0', '0', '0'),
    ('1234', '0', '37013', '46388', '57', '57', '16', '', '0', '45', '1712'),
    ('1236', '0', '37021', '37051', '57', '63', '10', '', '0', '1', '14'),
    ('1237', '0', '37030', '37030', '57', '57', '32', '', '0', '0', '3'),
    ('1238', '0', '37038', '44402', '57', '57', '39', '', '0', '20', '42'),
    ('1239', '0', '37068', '37518', '46', '57', '16', '', '0', '13', '173'),
    ('1240', '0', '37123', '37123', '57', '57', '10', '', '0', '0', '12'),
    ('1241', '1', '37164', '41455', '57', '', '22', '', '0', '36', '716'),
    ('1242', '0', '37181', '37181', '57', '57', '39', '', '0', '0', '0'),
    ('1243', '0', '37182', '37182', '57', '57', '32', '', '0', '0', '0'),
    ('1244', '0', '37183', '37183', '57', '57', '28', '', '0', '0', '0'),
    ('1245', '0', '37184', '37184', '57', '57', '28', '', '0', '0', '0'),
    ('1246', '0', '37185', '37185', '57', '57', '28', '', '0', '0', '1'),
    ('1247', '0', '37186', '37186', '57', '57', '28', '', '0', '0', '1'),
    ('1248', '0', '37187', '38148', '57', '177', '26', '', '0', '2', '72'),
    ('1249', '0', '37231', '37251', '63', '57', '10', '', '0', '1', '20'),
    ('1250', '0', '37318', '37318', '57', '57', '42', '', '0', '0', '0'),
    ('1251', '0', '37319', '37319', '57', '57', '42', '', '0', '0', '0'),
    ('1252', '0', '37320', '37320', '57', '57', '42', '', '0', '0', '0'),
    ('1253', '0', '37321', '37321', '57', '57', '42', '', '0', '0', '0'),
    ('1254', '0', '37322', '37322', '57', '57', '42', '', '0', '0', '0'),
    ('1255', '0', '37323', '37323', '57', '57', '10', '', '0', '0', '17'),
    ('1257', '0', '37386', '37403', '68', '63', '11', '', '0', '3', '106'),
    ('1258', '0', '37388', '37388', '57', '57', '46', '', '0', '0', '3'),
    ('1260', '0', '37460', '37460', '57', '57', '32', '', '0', '0', '0'),
    ('1261', '0', '37461', '37461', '57', '57', '39', '', '0', '0', '2'),
    ('1262', '0', '37462', '39581', '177', '177', '8', '', '0', '7', '140'),
    ('1263', '0', '37463', '37474', '177', '57', '11', '', '0', '4', '129'),
    ('1264', '0', '37466', '37582', '177', '177', '9', '', '0', '4', '144'),
    ('1265', '0', '37485', '37485', '57', '57', '42', '', '0', '0', '0'),
    ('1266', '0', '37486', '37486', '57', '57', '42', '', '0', '0', '0'),
    ('1267', '0', '37487', '37487', '57', '57', '42', '', '0', '0', '0'),
    ('1268', '0', '37488', '37488', '57', '57', '42', '', '0', '0', '0'),
    ('1269', '0', '37489', '37489', '57', '57', '42', '', '0', '0', '1'),
    ('1270', '0', '37490', '37490', '57', '57', '40', '', '0', '0', '1'),
    ('1271', '0', '37491', '37491', '57', '57', '42', '', '0', '0', '0'),
    ('1273', '0', '37541', '44965', '177', '177', '23', '', '0', '5', '63'),
    ('1274', '0', '37542', '40844', '177', '177', '8', '', '0', '15', '293'),
    ('1275', '0', '37549', '37583', '130', '57', '30', '', '0', '1', '10'),
    ('1276', '0', '37549', '37549', '130', '130', '28', '', '0', '0', '2'),
    ('1277', '0', '37581', '37916', '130', '57', '48', '', '0', '5', '18'),
    ('1278', '0', '37585', '37630', '177', '177', '3', '2', '0', '3', '56'),
    ('1279', '0', '37600', '37689', '57', '14', '16', '', '0', '3', '32'),
    ('1280', '0', '37614', '37830', '178', '40', '11', '', '0', '4', '65'),
    ('1281', '0', '37617', '37944', '40', '177', '9', '', '0', '25', '620'),
    ('1283', '0', '37650', '38037', '40', '75', '25', '', '0', '2', '113'),
    ('1284', '0', '37659', '37659', '40', '40', '8', '', '0', '0', '22'),
    ('1285', '0', '37660', '37802', '40', '46', '12', '', '1', '8', '168'),
    ('1286', '0', '37662', '37662', '40', '40', '17', '', '0', '0', '32'),
    ('1287', '0', '37663', '38604', '40', '2', '15', '', '0', '1', '16'),
    ('1288', '0', '37690', '37690', '40', '40', '26', '', '0', '0', '40'),
    ('1289', '0', '37696', '38047', '57', '57', '19', '', '0', '2', '75'),
    ('1290', '0', '37699', '37699', '57', '57', '32', '', '0', '0', '0'),
    ('1291', '0', '37700', '37700', '57', '57', '28', '', '0', '0', '0'),
    ('1292', '0', '37701', '37701', '57', '57', '28', '', '0', '0', '2'),
    ('1293', '0', '37710', '38546', '40', '177', '16', '', '0', '20', '487'),
    ('1294', '0', '37710', '37710', '40', '40', '17', '', '0', '0', '1'),
    ('1295', '0', '37781', '38754', '57', '57', '19', '', '0', '41', '1001'),
    ('1296', '0', '37854', '38792', '57', '182', '16', '', '0', '2', '30'),
    ('1297', '0', '37874', '37909', '177', '57', '19', '', '0', '4', '93'),
    ('1298', '0', '37881', '37898', '177', '177', '12', '', '0', '3', '69'),
    ('1299', '0', '37890', '37890', '57', '57', '10', '', '0', '0', '23'),
    ('1300', '0', '38010', '38010', '57', '57', '32', '', '0', '0', '0'),
    ('1301', '0', '38011', '38011', '57', '57', '43', '', '0', '0', '0'),
    ('1302', '0', '38012', '38012', '57', '57', '32', '', '0', '0', '0'),
    ('1303', '0', '38013', '38013', '57', '57', '39', '', '0', '0', '0'),
    ('1304', '0', '38014', '38014', '57', '57', '43', '', '0', '0', '1'),
    ('1305', '0', '38033', '38033', '57', '57', '10', '', '0', '0', '23'),
    ('1306', '0', '38034', '38034', '57', '57', '43', '', '0', '0', '1'),
    ('1307', '0', '38107', '38107', '57', '57', '16', '', '0', '0', '7'),
    ('1308', '0', '38129', '38352', '57', '177', '16', '', '0', '2', '32'),
    ('1309', '0', '38132', '38132', '177', '177', '10', '', '0', '0', '38'),
    ('1310', '0', '38151', '38593', '177', '177', '12', '', '0', '4', '70'),
    ('1311', '0', '38161', '41200', '2', '177', '48', '', '0', '11', '43'),
    ('1312', '0', '38162', '38163', '2', '57', '48', '', '0', '1', '7'),
    ('1313', '0', '38221', '38221', '57', '57', '32', '', '0', '0', '0'),
    ('1314', '0', '38222', '38222', '57', '57', '28', '', '0', '0', '0'),
    ('1315', '0', '38223', '38223', '57', '57', '42', '', '0', '0', '0'),
    ('1316', '0', '38224', '38224', '57', '57', '43', '', '0', '0', '2'),
    ('1317', '0', '38225', '38225', '57', '57', '40', '', '0', '0', '1'),
    ('1318', '0', '38253', '40241', '171', '46', '22', '', '0', '15', '310'),
    ('1319', '0', '38361', '38367', '105', '105', '8', '', '0', '2', '44'),
    ('1320', '0', '38389', '38431', '57', '46', '16', '', '0', '3', '35'),
    ('1321', '0', '38494', '38494', '177', '177', '26', '', '0', '0', '15'),
    ('1322', '0', '38553', '38553', '57', '57', '10', '', '0', '0', '20'),
    ('1324', '0', '38577', '38577', '63', '63', '10', '', '0', '0', '18'),
    ('1325', '0', '38584', '38588', '57', '177', '8', '', '0', '1', '38'),
    ('1327', '0', '38621', '38687', '40', '2', '16', '', '0', '4', '46'),
    ('1328', '0', '38626', '38626', '57', '57', '32', '', '0', '0', '1'),
    ('1329', '0', '38627', '38627', '57', '57', '28', '', '0', '0', '0'),
    ('1330', '0', '38628', '38628', '57', '57', '28', '', '0', '0', '0'),
    ('1331', '0', '38654', '38824', '57', '45', '16', '', '0', '2', '22'),
    ('1332', '0', '38662', '38662', '57', '57', '32', '', '0', '0', '0'),
    ('1333', '0', '38663', '38663', '57', '57', '28', '', '0', '0', '0'),
    ('1334', '0', '38664', '38664', '57', '57', '41', '', '0', '0', '1'),
    ('1335', '0', '38665', '38665', '57', '57', '43', '', '0', '0', '1'),
    ('1336', '0', '38667', '38667', '57', '57', '39', '', '0', '0', '1'),
    ('1337', '0', '38668', '38668', '57', '57', '28', '', '0', '0', '0'),
    ('1338', '0', '38669', '38669', '57', '57', '40', '', '0', '0', '1'),
    ('1339', '0', '38673', '38673', '57', '57', '32', '', '0', '0', '1'),
    ('1340', '0', '38674', '38674', '57', '57', '32', '', '0', '0'

[SNAFU0185]

('1340', '0', '38674', '38674', '57', '57', '32', '', '0', '0', '0'),
    ('1341', '0', '38675', '38675', '57', '57', '32', '', '0', '0', '0'),
    ('1342', '0', '38676', '38676', '57', '57', '43', '', '0', '0', '2'),
    ('1343', '0', '38677', '38677', '57', '57', '32', '', '0', '0', '0'),
    ('1344', '0', '38678', '42938', '57', '57', '28', '', '0', '2', '5'),
    ('1345', '0', '38679', '38679', '57', '57', '28', '', '0', '0', '0'),
    ('1346', '0', '38680', '38680', '57', '57', '28', '', '0', '0', '0'),
    ('1347', '0', '38681', '38681', '57', '57', '28', '', '0', '0', '0'),
    ('1348', '0', '38682', '42939', '57', '57', '28', '', '0', '2', '4'),
    ('1349', '0', '38683', '38683', '57', '57', '28', '', '0', '0', '0'),
    ('1350', '0', '38685', '38685', '57', '57', '46', '', '0', '0', '3'),
    ('1351', '0', '38712', '38712', '57', '57', '10', '', '0', '0', '21'),
    ('1352', '0', '38713', '38713', '57', '57', '10', '', '0', '0', '20'),
    ('1353', '0', '38729', '38780', '57', '2', '16', '', '0', '6', '59'),
    ('1354', '0', '38755', '38755', '57', '57', '19', '', '0', '0', '68'),
    ('1355', '0', '38758', '38758', '57', '57', '43', '', '0', '0', '0'),
    ('1356', '0', '38777', '45430', '57', '186', '43', '', '0', '23', '96'),
    ('1357', '0', '38801', '38801', '57', '57', '16', '', '0', '0', '20'),
    ('1358', '0', '38804', '38896', '171', '171', '22', '', '0', '2', '63'),
    ('1359', '0', '38811', '39012', '171', '2', '22', '', '0', '6', '106'),
    ('1360', '0', '38828', '39047', '171', '171', '22', '', '0', '6', '145'),
    ('1361', '0', '38834', '38861', '183', '63', '11', '', '0', '7', '94'),
    ('1362', '0', '38843', '39226', '2', '2', '21', '', '0', '2', '11'),
    ('1363', '0', '38845', '39066', '57', '177', '16', '', '0', '4', '44'),
    ('1365', '0', '38848', '38848', '171', '171', '10', '', '0', '0', '25'),
    ('1366', '0', '38849', '38849', '171', '171', '10', '', '0', '0', '25'),
    ('1368', '0', '38854', '38881', '183', '', '39', '5', '0', '3', '9'),
    ('1373', '0', '38889', '38889', '57', '57', '19', '', '0', '0', '90'),
    ('1374', '0', '38898', '38899', '2', '57', '11', '', '0', '1', '38'),
    ('1375', '0', '38910', '38910', '57', '57', '39', '', '0', '0', '1'),
    ('1376', '0', '38911', '38911', '57', '57', '39', '', '0', '0', '0'),
    ('1377', '0', '38912', '38912', '57', '57', '28', '', '0', '0', '0'),
    ('1378', '0', '38913', '38913', '57', '57', '28', '', '0', '0', '0'),
    ('1380', '0', '38937', '38937', '57', '57', '26', '', '0', '0', '23'),
    ('1381', '0', '38949', '38949', '57', '57', '41', '', '0', '0', '2'),
    ('1382', '0', '38950', '38950', '57', '57', '41', '', '0', '0', '2'),
    ('1383', '0', '38951', '38951', '57', '57', '40', '', '0', '0', '2'),
    ('1384', '0', '38952', '38952', '57', '57', '28', '', '0', '0', '1'),
    ('1385', '0', '38961', '38967', '2', '57', '4', '', '0', '1', '5'),
    ('1386', '0', '38970', '39004', '2', '46', '21', '', '0', '3', '12'),
    ('1387', '0', '39006', '39010', '171', '2', '10', '', '0', '1', '101'),
    ('1388', '0', '39007', '39019', '171', '57', '10', '', '0', '2', '96'),
    ('1389', '0', '39008', '39008', '171', '171', '8', '', '0', '0', '44'),
    ('1390', '0', '39006', '39010', '171', '2', '22', '', '0', '1', '6'),
    ('1391', '0', '39007', '39009', '171', '2', '22', '', '0', '1', '4'),
    ('1392', '0', '39029', '39029', '171', '171', '8', '', '0', '0', '32'),
    ('1393', '0', '39030', '39124', '171', '171', '22', '', '0', '7', '158'),
    ('1394', '0', '39036', '39138', '171', '177', '8', '', '0', '1', '20'),
    ('1395', '0', '39040', '39040', '57', '57', '10', '', '0', '0', '17'),
    ('1396', '0', '39046', '39046', '171', '171', '22', '', '0', '0', '47'),
    ('1397', '0', '39048', '39049', '171', '57', '8', '', '0', '1', '43'),
    ('1398', '0', '39052', '39052', '57', '57', '41', '', '0', '0', '1'),
    ('1399', '0', '39053', '39053', '57', '57', '28', '', '0', '0', '1'),
    ('1400', '0', '39065', '39065', '57', '57', '10', '', '0', '0', '17'),
    ('1401', '0', '39084', '39084', '57', '57', '10', '', '0', '0', '23'),
    ('1402', '0', '39085', '39085', '2', '2', '29', '', '0', '0', '4'),
    ('1403', '0', '39086', '39086', '2', '2', '29', '', '0', '0', '7'),
    ('1404', '0', '39087', '39087', '2', '2', '29', '', '0', '0', '5'),
    ('1405', '0', '39088', '39088', '2', '2', '29', '', '0', '0', '5'),
    ('1406', '0', '39089', '39089', '2', '2', '29', '', '0', '0', '3'),
    ('1407', '0', '39090', '39090', '2', '2', '29', '', '0', '0', '5'),
    ('1408', '0', '39093', '39093', '57', '57', '28', '', '0', '0', '7'),
    ('1409', '0', '39122', '39122', '171', '171', '22', '', '0', '0', '71'),
    ('1410', '0', '39126', '39152', '171', '171', '10', '', '0', '2', '80'),
    ('1411', '0', '39127', '39127', '46', '46', '43', '', '0', '0', '3'),
    ('1412', '0', '39128', '39128', '46', '46', '46', '', '0', '0', '7'),
    ('1413', '0', '39129', '39129', '46', '46', '43', '', '0', '0', '4'),
    ('1414', '0', '39130', '41870', '46', '57', '46', '', '0', '4', '16'),
    ('1415', '0', '39136', '39136', '177', '177', '26', '', '0', '0', '21'),
    ('1416', '0', '39139', '45709', '177', '187', '8', '', '0', '28', '587'),
    ('1417', '0', '39140', '40675', '6', '', '16', '', '0', '4', '70'),
    ('1418', '0', '39145', '41927', '177', '87', '49', '', '0', '2', '95'),
    ('1419', '0', '39126', '39152', '171', '171', '22', '', '0', '2', '8'),
    ('1420', '0', '39156', '39156', '171', '171', '8', '', '0', '0', '31'),
    ('1421', '0', '39162', '39165', '2', '57', '12', '', '0', '1', '29'),
    ('1422', '0', '39168', '39168', '171', '171', '10', '', '0', '0', '24'),
    ('1423', '0', '39219', '39809', '40', '177', '26', '', '0', '3', '62'),
    ('1424', '0', '39220', '39220', '40', '40', '9', '', '0', '0', '66'),
    ('1425', '0', '39224', '39224', '57', '57', '28', '', '0', '0', '0'),
    ('1426', '0', '39225', '39225', '57', '57', '41', '', '0', '0', '1'),
    ('1427', '0', '39228', '39283', '40', '40', '16', '', '0', '2', '51'),
    ('1428', '0', '39236', '39236', '40', '40', '16', '', '0', '0', '15'),
    ('1429', '0', '39237', '39240', '40', '40', '15', '', '0', '2', '13'),
    ('1430', '0', '39251', '39251', '57', '57', '28', '', '0', '0', '0'),
    ('1431', '0', '39255', '39284', '2', '2', '16', '', '0', '5', '115'),
    ('1432', '0', '39258', '39258', '57', '57', '28', '', '0', '0', '1'),
    ('1433', '0', '39280', '39280', '57', '57', '32', '', '0', '0', '0'),
    ('1434', '0', '39285', '39428', '2', '', '21', '', '0', '4', '14'),
    ('1437', '0', '39296', '39299', '2', '57', '12', '', '0', '1', '21'),
    ('1438', '0', '39297', '39511', '2', '57', '11', '', '0', '9', '221'),
    ('1439', '0', '39304', '39318', '46', '46', '28', '', '0', '2', '4'),
    ('1440', '0', '39305', '46433', '186', '187', '30', '', '0', '102', '331'),
    ('1442', '0', '39342', '42256', '57', '45', '10', '', '0', '3', '54'),
    ('1443', '0', '39343', '39343', '57', '57', '40', '', '0', '0', '2'),
    ('1444', '0', '39344', '39344', '57', '57', '28', '', '0', '0', '0'),
    ('1445', '0', '39345', '39345', '57', '57', '28', '', '0', '0', '3'),
    ('1446', '0', '39346', '41384', '46', '57', '28', '', '0', '1', '5'),
    ('1447', '0', '39347', '39360', '46', '57', '28', '', '0', '1', '4'),
    ('1448', '0', '39365', '39371', '57', '46', '28', '', '0', '3', '12'),
    ('1449', '0', '39370', '39370', '57', '57', '43', '', '0', '0', '2'),
    ('1450', '0', '39374', '39374', '57', '57', '10', '', '0', '0', '22'),
    ('1451', '0', '39376', '39381', '57', '171', '16', '', '0', '3', '85'),
    ('1452', '0', '39390', '39416', '186', '', '29', '', '0', '7', '24'),
    ('1453', '0', '39394', '39419', '57', '', '16', '', '0', '5', '61'),
    ('1454', '0', '39403', '39477', '186', '57', '30', '', '0', '5', '14'),
    ('1455', '0', '39412', '42431', '57', '57', '30', '', '0', '3', '10'),
    ('1456', '0', '39413', '39560', '57', '', '28', '', '0', '4', '26'),
    ('1457', '0', '39418', '39418', '57', '', '41', '', '0', '0', '2'),
    ('1458', '0', '39431', '39431', '57', '', '19', '', '0', '0', '51'),
    ('1459', '0', '39438', '39438', '57', '', '26', '', '0', '0', '19'),
    ('1461', '0', '39487', '39592', '57', '57', '16', '', '0', '2', '96'),
    ('1462', '0', '39461', '39461', '57', '', '28', '', '0', '0', '1'),
    ('1463', '0', '39462', '39462', '57', '', '43', '', '0', '0', '1'),
    ('1464', '0', '39463', '39463', '57', '', '41', '', '0', '0', '3'),
    ('1465', '0', '39466', '41646', '186', '57', '30', '', '0', '16', '34'),
    ('1466', '0', '39489', '39497', '2', '57', '1', '', '0', '3', '89'),
    ('1467', '0', '39490', '39615', '187', '63', '11', '', '0', '5', '141'),
    ('1468', '0', '39500', '44752', '57', '57', '19', '', '0', '145', '6332'),
    ('1470', '0', '39502', '40135', '57', '57', '12', '', '0', '9', '140'),
    ('1472', '0', '42250', '42250', '57', '45', '10', '', '0', '0', '34'),
    ('1473', '0', '39538', '39538', '177', '', '10', '', '0', '0', '15'),
    ('1474', '0', '39575', '39583', '177', '57', '10', '', '0', '1', '21'),
    ('1475', '0', '39582', '39837', '177', '177', '9', '', '0', '10', '173'),
    ('1476', '0', '39586', '40195', '2', '61', '16', '', '0', '11', '216'),
    ('1477', '0', '39588', '41190', '2', '188', '1', '', '0', '7', '163'),
    ('1478', '0', '39609', '40918', '57', '57', '40', '', '0', '2', '4'),
    ('1479', '0', '39610', '39714', '57', '', '28', '', '0', '1', '6'),
    ('1480', '0', '39611', '39611', '177', '177', '10', '', '0', '0', '25'),
    ('1481', '0', '39626', '39748', '63', '', '10', '', '0', '2', '33'),
    ('1482', '0', '39652', '40182', '177', '177', '12', '', '0', '2', '42'),
    ('1483', '0', '39659', '39808', '57', '177', '26', '', '0', '2', '45'),
    ('1484', '0', '39663', '39693', '2', '', '11', '', '0', '2', '39'),
    ('1485', '0', '39664', '39690', '158', '57', '11', '', '0', '2', '51'),
    ('1486', '0', '39666', '39689', '87', '57', '11', '', '0', '2', '36'),
    ('1487', '0', '39671', '39692', '2', '', '21', '', '0', '1', '7'),
    ('1488', '0', '39789', '39789', '87', '2', '9', '', '0', '0', '71'),
    ('1489', '0', '39715', '39844', '87', '57', '30', '', '0', '3', '9'),
    ('1490', '0', '39803', '40897', '177', '186', '11', '', '0', '11', '455'),
    ('1491', '0', '39965', '42984', '171', '171', '16', '', '0', '11', '537'),
    ('1492', '0', '39728', '39964', '171', '171', '16', '', '0', '2', '29'),
    ('1493', '0', '39781', '39781', '177', '', '49', '', '0', '0', '25'),
    ('1494', '0', '39785', '39785', '177', '', '26', '', '0', '0', '10'),
    ('1495', '0', '39795', '42275', '177', '177', '16', '', '0', '39', '1869'),
    ('1496', '0', '39791', '39804', '63', '177', '10', '', '0', '1', '44'),
    ('1497', '0', '39502', '39724', '57', '', '45', '', '0', '2', '10'),
    ('1498', '0', '39846', '39864', '57', '57', '28', '', '0', '2', '7'),
    ('1499', '0', '39848', '39861', '57', '87', '28', '', '0', '1', '5'),
    ('1500', '0', '39854', '39862', '57', '87', '28', '', '0', '1', '3'),
    ('1501', '0', '39920', '46429', '57', '187', '16', '', '0', '201', '5563'),
    ('1502', '0', '39967', '40099', '63', '177', '10', '', '0', '2', '55'),
    ('1503', '0', '40006', '40006', '57', '57', '28', '', '0', '0', '1'),
    ('1504', '0', '40007', '40352', '57', '57', '42', '', '0', '12', '19'),
    ('1505', '0', '40008', '40008', '57', '57', '43', '', '0', '0', '0'),
    ('1506', '0', '40009', '40347', '57', '57', '43', '', '0', '2', '4'),
    ('1507', '0', '40010', '40010', '57', '57', '42', '', '0', '0', '3'),
    ('1508', '0', '40044', '44533', '87', '87', '22', '', '0', '34', '1081'),
    ('1509', '0', '40046', '40136', '87', '87', '30', '', '0', '4', '14'),
    ('1510', '0', '40069', '42230', '57', '45', '10', '', '0', '10', '307'),
    ('1511', '0', '40071', '40071', '57', '57', '28', '', '0', '0', '1'),
    ('1512', '0', '40072', '40072', '57', '57', '28', '', '0', '0', '1'),
    ('1513', '0', '40073', '40073', '57', '57', '28', '', '0', '0', '1'),
    ('1514', '0', '40074', '40074', '57', '57', '28', '', '0', '0', '1'),
    ('1515', '0', '40075', '40075', '57', '57', '32', '', '0', '0', '2'),
    ('1516', '0', '40101', '42308', '177', '177', '10', '', '0', '10', '299'),
    ('1517', '0', '40102', '40102', '177', '177', '10', '', '0', '0', '43'),
    ('1518', '0', '40103', '42240', '177', '45', '10', '', '0', '2', '60'),
    ('1520', '0', '40129', '40137', '87', '87', '10', '', '0', '2', '54'),
    ('1521', '0', '40188', '42232', '177', '45', '10', '', '0', '4', '89'),
    ('1522', '0', '40194', '40283', '61', '63', '11', '', '0', '5', '72'),
    ('1523', '0', '40207', '40282', '178', '63', '11', '', '0', '4', '77'),
    ('1524', '0', '40237', '40319', '57', '57', '16', '', '0', '7', '113'),
    ('1525', '0', '40253', '42916', '87', '87', '19', '', '0', '22', '646'),
    ('1526', '0', '40325', '40340', '186', '186', '15', '', '0', '3', '22'),
    ('1528', '0', '40342', '40532', '186', '186', '12', '', '0', '3', '91'),
    ('1529', '0', '40353', '42236', '63', '45', '10', '', '0', '1', '31');

Caused the error:

    Duplicate entry '957' for key 1

[margarett]

Are you using the converter from this topic?

PS: the avatars errors are normal, it's because they are not found

[SNAFU0185]

yea it links you to the downloads section anyways which is where i downloaded  it

[margarett]

No.

On the first post of this topic you will find the files you need. It's an improved converter by Jay. Use the .sql file attached, and the convert.php linked

[SNAFU0185]

ahhh that sql thingy wasnt there the first time i looked cool ill try that later today and report back

[SNAFU0185]

all went well untill i got the following

Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images...
Fatal error: Call to undefined function: copy_dir() in /home/virtual/site57/fst/var/www/html/smf/convert.php(665) : eval()'d code on line 20

now what?

[margarett]

Beats me...
Did everything converted except avatars?

[rheza02]

"Sorry, the database connection information used in the specified installation of SMF cannot access the installation of phpBB2. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: SELECT command denied to user 'sekindo_smf'@'localhost' for table 'phpbb_users"

what the problem...?, i can't convert my phpbb forum ?, how to make it can ?

sorry for my bad english

[margarett]

You need to allow the user from "smf database" to access the "phpbb database"

[chovy]

The package you tried to upload either is not a valid package or has become corrupted.

got the above message when trying upload the phpbb2 converter from simplemachines.org site.

Tried both .zip and .tar.gz