can't export

[messydeer]

Hi!

I have PGO 4.0.823. Downloaded my groups just fine and the search function seems to work. I'm getting stuck on the exporting function. I'd like to export all the messages and also a search result subset. The only export option I see is File > Export Folder, which is suggested in the tutorial. I do that, browse to the folder, name the file and go back to the 'groups export' window. The 'export' button is grayed out, leaving close as the only option. What can I do here?

Thanks,
Dan

[Wilson Logan]

Hi Dan,

Annoying bugette... you need to uncheck the group to export and recheck it.

So like, its checked before you specify the filepath to export to and when you come back from that dialogue PGO has lost the plot.

So even though the group is checked PGO has forgotten. If you uncheck and recheck the group to export you will unlock the Export button.

Sorry.. its stupid. We'll get it sorted.

Cheers,

Wilson.

[messydeer]

Great!

That worked. I don't have a database program and only want to export it into something searchable and editable, like Excel or something. These are group posts with primarily text, which I suppose is like most any other groups.

Any suggestions?

Dan

[Wilson Logan]

I have a guy writing a .DB3 to .CSV export stand alone app right now.

When its ready I will post a link.

Cheers,

Wilson.

[Wilson Logan]

OK, I have attached a stand alone app to take a PGO archive file and export it as a CSV file.

You start the app, choose an archive file (ie a file of messages you exported from PGO as a DB3 file) and then you choose the fields from the message table you want to export.

I recommend you choose at least the first 5 fields.  (ID, number, date, subject, content)

Chose other fields as you desire.

Software is free, as is where is, no warranty, your mileage may vary, objects in the rear view mirror, etc and so forth.

Cheers,

Wilson.

[cclark]

Hello:
I was able to download a set of messages as a .db3, and to use the program to convert to a .csv. However, I can't get the .csv to import into excel in a tabular format. BAsically, I just need a spreadsheet with columns that are things like: message number, date, sender, to, content, etc. Any thoughts? Thank you!
Charlotte

[Wilson Logan]

Hi Charlotte,

Excel has an Import Data wizard. Its been a while since I used it but I think it first asks for the filename and then its asks what character you've used as a separator (in your case its comma) and then... that's it I think.


I found a video on You Tube which may be helpful:

https://www.youtube.com/watch?v=z5Pxil4jVO4

Cheers,

Wilson.

[cclark]

Nope, that is the point. That doesn't work. I tried that with many various iterations. I was kindof hoping that your tutorial that said you could import as a .mdb would work, but that functionality appears to have been removed. Any other ideas? I can get it out as a .db3 or a .csv, but can't use either of those to review the text in any easy way.
Charlotte

[Wilson Logan]

Hi Charlotte,

The file is semi-colon separated but I'm sure you noticed that.

When I try to import it into Excel it is interpreting new-lines as row ends.

The new-lines shouldn't be seen as row ends.

I'll ask the developer how much of a problem it is to re-write the program to output directly to .xls rather than .csv

Cheers,

Wilson.