PG Offline

PG Offline => I need Help ! => Topic started by: Anup on November 04, 2019, 07:10:24 AM

Title: Converting or exporting .db3 file as .csv or PDF
Post by: Anup on November 04, 2019, 07:10:24 AM
Is there any chance that ,db3 can be converted/export as .csv or pdf format?

I understand that there are options to export .db3 as SQLgroup members ite or MYSQL dump but when
we can export group members list as .csv then messages can be fetched in ,csv or pdf format.

Any idea wilson??

Title: Re: Converting or exporting .db3 file as .csv or PDF
Post by: Wilson Logan on November 04, 2019, 07:36:56 AM
Members can be exported as CSV. 

Right click on the groupname and choose "Get Members for current group".  Wait a while for it to finish. 

Its asynchronous which means it makes requests without waiting for responses so it looks like it's finished when really it's still getting data.

So leave it for 5 minutes (or in your case, maybe an hour…) and then choose "Export members for current group" and you'll get the list as a CSV file.

If you're the owner you'll get real email addresses. If you're not the owner the email addresses will be munged.

Users can choose not to share their real email addresses and you won’t get them.

Early YG users (those grandfathered in from GeoCities)  didn't join with an email address and all you'll see is a big random number.

Cheers,

Wilson.

Title: Re: Converting or exporting .db3 file as .csv or PDF
Post by: Anup on November 04, 2019, 07:49:32 AM


Thanks for your reply.

In fact, i could not present my query properly.

I am concerned with YG messages. Can these be export as .csv or PDF.
But these three format as below could not be opened once i share to my friend.

1.   .DB3 file
2.  SQLite dump
3. MYSQL dump

Even SQLite is not opening at my end using any SQL opening program.

Message reads "File is encrypted or is not a database"

I am puzzled. Please help

Regards
Anup
Title: Re: Converting or exporting .db3 file as .csv or PDF
Post by: Wilson Logan on November 04, 2019, 08:32:31 AM
Dump files are dump files.

They are the *instructions* in SQL Query Language for how to recreate a database.

NOT the database.

Open them with Notepad and you will see they are text files of SQL commands.

Ask your friend to download PG Offline.

Create a PGO export file using File -- > Export to Folder.

Share with him the resulting PG4 file.

PG Offline is FREE to use if you are just importing archive (PG4) files and then sorting, searching & reading.

Only new downloading of data from Yahoo requires a licence.

Cheers,

Wilson.


Title: Re: Converting or exporting .db3 file as .csv or PDF
Post by: Anup on November 04, 2019, 02:01:38 PM

Thanks wilson. Understood that this data can be used only with PGoffline.

So is there chance that "ANY" of PG export data be used to migrate group to platform like google
or some other ( like wordpress)

I know i am asking too much.

Regards
Anup
Title: Re: Converting or exporting .db3 file as .csv or PDF
Post by: Wilson Logan on November 04, 2019, 03:28:12 PM
Its definitely possible.

I have ported to phpBB and Wordpress from PGO.

I am hoping to offer transfer to phpBB as a service soon.

Cheers,

Wilson.
Title: Re: Converting or exporting .db3 file as .csv or PDF
Post by: Anup on November 04, 2019, 04:12:15 PM

Thanks wilson. Got it.

Regards
Anup
Title: Re: Converting or exporting .db3 file as .csv or PDF
Post by: Anup on November 05, 2019, 03:42:29 PM

Hi Wilson,


Can we import this YG data to a new google group ?

I have arround 32000 messages data backup of my yahoo group created in the year 2000 with PG Offline.

Should i assume that these 32000 messages backup will be working with google group (to be created)

Any solution ??

Regards
Anup



Title: Re: Converting or exporting .db3 file as .csv or PDF
Post by: Wilson Logan on November 07, 2019, 10:36:08 AM
Yes, it is a function I am considering after I have developed  transfer to phpbb, groups.io and Wordpress