Hello BHW!
As you can see from my post count, I am not wery experienced in IM.
I figured this out because I needed myself to post .txt files to wordpress as posts, so I tried to find some solution but couldnt find one (There was ZipPoster which I think is long gone). So I made way out of this situation by myself. This is my first share on BHW so dont be too strict, and dont say this suck, but well it is a bit complicated. So here we go. (I will breafly explain the method, I am not in a mood to write down super detailed guide, sorry
)
1. You will need your articles in .txt format, and file name must be the title of your article. You can easily scrape this kind of articles with get article scraper lite.
2. When you have your articles head to MS Excel and open VBA developer and copy this code.
As you can see, this macro will take all .txt files from C:\Records\ and will copy in first column Names of files (Article Titles) and all text in other colum. Save this file in .csv format.
3. Head ower to your Wordpress dashboard and instal plugin called WP Ultimate CSV Importer (you can install other CSV file importers asvell, I am not trying to promote that plugin, I used it because it was most popular one, and was updated)
Ok I will not explain how to go on from here, because there are tutorials how to use that plugin. And there are examples of .csv files.
Yes In thees examples are many more columns which you can add, but in between lines you have all what you need to automate your article posting to wordpress.
All other minors adjustments you can make yourselves. Hope someone will find this useful
P.S Sorry for any grammar mistakes, if there was any, Im not native english speaker.
As you can see from my post count, I am not wery experienced in IM.
I figured this out because I needed myself to post .txt files to wordpress as posts, so I tried to find some solution but couldnt find one (There was ZipPoster which I think is long gone). So I made way out of this situation by myself. This is my first share on BHW so dont be too strict, and dont say this suck, but well it is a bit complicated. So here we go. (I will breafly explain the method, I am not in a mood to write down super detailed guide, sorry
1. You will need your articles in .txt format, and file name must be the title of your article. You can easily scrape this kind of articles with get article scraper lite.
2. When you have your articles head to MS Excel and open VBA developer and copy this code.
Code:
[COLOR=#000000][FONT=Arial]Sub macro_1()[/FONT][/COLOR][COLOR=#000000][FONT=Arial]Dim fso, fil[/FONT][/COLOR]
[COLOR=#000000][FONT=Arial]Set fso = CreateObject("Scripting.filesystemobject")[/FONT][/COLOR]
[COLOR=#000000][FONT=Arial]For Each fil In fso.getfolder("C:\Records\").Files[/FONT][/COLOR]
[COLOR=#000000][FONT=Arial]If fil.Name Like "*.txt" Then[/FONT][/COLOR]
[COLOR=#000000][FONT=Arial]Range("A" & Rows.Count).End(xlUp).Offset(1, 0) = Left(fil.Name, Len(fil.Name) - 4)[/FONT][/COLOR]
[COLOR=#000000][FONT=Arial]Range("A" & Rows.Count).End(xlUp).Offset(0, 1) = fso.opentextfile(fil).readall[/FONT][/COLOR]
[COLOR=#000000][FONT=Arial]End If[/FONT][/COLOR]
[COLOR=#000000][FONT=Arial]Next fil[/FONT][/COLOR]
[COLOR=#000000][FONT=Arial]End Sub[/FONT][/COLOR]
As you can see, this macro will take all .txt files from C:\Records\ and will copy in first column Names of files (Article Titles) and all text in other colum. Save this file in .csv format.
3. Head ower to your Wordpress dashboard and instal plugin called WP Ultimate CSV Importer (you can install other CSV file importers asvell, I am not trying to promote that plugin, I used it because it was most popular one, and was updated)
Ok I will not explain how to go on from here, because there are tutorials how to use that plugin. And there are examples of .csv files.
Yes In thees examples are many more columns which you can add, but in between lines you have all what you need to automate your article posting to wordpress.
All other minors adjustments you can make yourselves. Hope someone will find this useful
P.S Sorry for any grammar mistakes, if there was any, Im not native english speaker.