Succes!

Facebook Group Files --> Kunena --> EasyDiscuss

Note: This assumes you are a Admin of the Facebook Group

1. Create Facebook Developer Account and Create an App.
2. In the FB Graph API run

{your Facebook group number}/files?fields=download_link,from,message,updated_time&limit=1000

3. Copy this into a text editor, and massage the info into an .html document
4. Grab a browser extension that can download all files on a page, open the .html and download the files.
5. Remove whitespace from file names. (I used Applescript)
6. Upload files into a new folder in

media/kunena/attachments/PICK_A_NUMBER

7. Go back to the .html and massage it into a semicolon separated .txt file, remove the

https://..../  from  https://..../FILENAME.pdf

decode the text. e.g. replace

%20

with a

space

, import this .txt into Excel
8. Create Excel sheets for jos_kunena_attachments, jos_kunena_messages, joe_kunena_messages_text, jos_kunena_topics, jos_kunena_user_topics
9. Use the title of each table column for the first row of the excel sheet
10. Make sure that kunena_topics

id

matches kunena_messages

thread

, and kunena_topics

first_post_id

matches kunena_messages

id

. (pick an arbitrary number above the last id number in your sql table)
11. In the other tables when you see

mesid

that should match kunena_messages

id

12. Copy the columns from Step 7 into the appropriate columns in the _kunena_ excel sheets
13. Match up the Joomla! Username & ID with the respective column in the all the tables (excel sheets)
14. Fill in the other rows using a previous post from your Kunena forum as a template (note: I used the decoded file name as the subject)
15. Create UNIX timestamps from the FB dates (good one here)
16. I used the command/terminal to get the file size of each file. (cd into folder and run

ls -l

, copy into the text editor and remove everything but the filename and file size)
17. Export the Excel sheets as a .csv, open the csv and remove the top row, remove any extra commas at the end of each line, and make certain the last line is an empty/new line.
18. In phpMyAdmin select the table and import the csv
19. Go back to JoomlaAdmin / EasyDiscuss and rerun migration


Note: When I did the above the new posts were created in a single category, despite me specifying otherwise. I manually changed the category in

jos_discuss_posts

. Small price to pay considering everything else.

I hope this helps someone one day. Cheers!