Batch POI download utility available

 

PoiSync is a utility that allows you to download a set of POI files from POI Factory in batch mode. This allows you to periodically synchronize/update all your POI files at once.

The utility for batch download POI files is now available for download at

http://www.nextgenlogic.com/poi.php

To install, unzip to a directory. The documentation is in both text and html and can be found in the directory named doc.

Thanks to all the beta users and the valuable feedback. A special thanks to mobajwa for hosting the download.

4 5 6
<<Page 3>>

You Sure? :)

Hey Phil,

Two Thumbs Up!

It's like a pet how you train it the way you want him/her to act. It might take a while to make your poifile.txt the way you want it. But after that.... it ROCKS smile Not only speeding up in downloading but also so easy to organize & can keep your poi files up to date.
[/quote]I have downloaded nearly 100 files in under 2 minutes, no lie.[/quote] smile :) smile

Worth it.

--
Garmin Nuvi 2555 LMT, Street Pilot C340, nuvi 265WT, Mio Moov 300, nuvi 255W, Navigon 2100 (Retired)

Changing poi files after download

kyue2 wrote:

I do some file manipulation before it is loaded into the GPS and would rather not have to do that work on files already the way I want them.

I agree, it kinda sucks when you have a file that you change a bit after downloading. I wish there was a standard for poi files on the site. A lot of them I noticed don't really have the name of the poi in the individual poi's. For example, the Jack in the Box file. When downloading it the name of the individual poi's is the address of the location (kind of pointless because the garmin only needs to know this, not me) so I have to swap the address into the description and then change all the poi names to Jack in the Box. I like it better this way so when I am searching for All Categories in my food folder or even in my main folder I know what the poi is without having to go to the map and look at its icon. Anyways, I wish there was a standard to how poi's are made on this site.

Thanks

Oh, and I forgot, thanks everyone for the help with auto the auto login. I got it to work. I was so confused and didnt know I had to make a new .bat file with that line on it. Thanks!

Thanks

Thanks for the tools. Very useful.

extra bat file or shortcut

dgwood12 wrote:

Oh, and I forgot, thanks everyone for the help with auto the auto login. I got it to work. I was so confused and didnt know I had to make a new .bat file with that line on it. Thanks!

You don't have to use the extra bat file if you only wanted to do the update in windows scheduler. In scheduler you could point to the poisync.bat file and put the "<mylogin.txt" in the Add agruments box.

But having the extra bat file is handy if you want to just go ahead and update before the scheduled time, or for those not using scheduler.

For those not using a scheduler, another way to run poisync.bat using the autologin method is to create a shortcut to poisync.bat, right click the shortcut, click on properties, and add the "<mylogin.txt" to the end of the link in the Target box.

My Beta test

Evert wrote:
dgwood12 wrote:

Oh, and I forgot, thanks everyone for the help with auto the auto login. I got it to work. I was so confused and didnt know I had to make a new .bat file with that line on it. Thanks!

You don't have to use the extra bat file if you only wanted to do the update in windows scheduler. In scheduler you could point to the poisync.bat file and put the "<mylogin.txt" in the Add agruments box.

But having the extra bat file is handy if you want to just go ahead and update before the scheduled time, or for those not using scheduler.

For those not using a scheduler, another way to run poisync.bat using the autologin method is to create a shortcut to poisync.bat, right click the shortcut, click on properties, and add the "<mylogin.txt" to the end of the link in the Target box.

This is how to login using mylogin.txt file from run command:
"C:\Documents and Settings\Owner\Desktop\poisync\poisync.bat" poisync.bat poisync mylogin.bat
double click poisync mylogin.bat

This is how I scheduled auto download using XP
click start
click control panel
click scheduled tasks
follow wizard to set-up auto download event
browse files and select -> poisync mylogin.bat
set-up one time test
verify test auto download ran as planned
modify schedule task to run when required

Just what I needed. Thanks.

Just what I needed. Thanks.

.

phillyguy19020 wrote:

This is how to login using mylogin.txt file from run command:
"C:\Documents and Settings\Owner\Desktop\poisync\poisync.bat" poisync.bat poisync mylogin.bat
double click poisync mylogin.bat

This is how I scheduled auto download using XP
click start
click control panel
click scheduled tasks
follow wizard to set-up auto download event
browse files and select -> poisync mylogin.bat
set-up one time test
verify test auto download ran as planned
modify schedule task to run when required

This post is malfunctioning, I tried posting again but can't get it to post. Any one wanting additional info message me.

Sometimes what you type is not what you get

phillyguy19020 wrote:

…….

This post is malfunctioning, I tried posting again but can't get it to post. Any one wanting additional info message me.

I had the same problem is my earlier post in this thread.

You need to use special characters for some of the characters in your post. Follow the link below and scroll down where you see what to type to get the ampersand, greater than, less than, and other characters.
http://www.poi-factory.com/filter/tips

Thanks Evert for the link

This is how to login using mylogin.txt file from run command:

"C:\Documents and Settings\Owner\Desktop\poisync\poisync.bat"(one space here)<mylogin.txt

This is how I wrote the autoexec 'bat file'

Open notepad
type - poisync.bat <mylogin.txt
name file - poisync mylogin.bat
double click poisync mylogin.bat

This is how I scheduled auto download using XP

click start
click control panel
click scheduled tasks
follow wizard to set-up auto download event
browse files and select - poisync mylogin.bat
set-up one time test
verify test auto download ran as planned
modify schedule task to run when required

You are welcome

I am glad it worked for you.

Easier

I think its just easier to make another .bat file. That way I can just open that whenever I want and also run it through a scheduler without any other arguments.

Problem with Java, and a solution

I installed the latest version of Java, then tried running poisync.bat. I got the following error, "'java' is not recognized as an internal or external command, operable program or batch file."

When I checked the html file in the poisync doc folder, the suggestion was to check the java version by going to the command line (accessible by typing Start > Run > cmd) and entering "java -version." This produced the same error.

If anyone else has this problem, here is what I had to do to resolve the problem.

For Windows 7, 64-bit.
Click Start button, then right-click on "Computer" (for XP right-click on "My Computer") and select "Properties."

On the left side of the screen select "Advanced system settings" (for XP, click the "Advanced" tab at the top right of the screen) then click the "Environment Variables" button.

In the "System variables" section, scroll down and click on "Path" and then click the "Edit" button.

Go to the end of the "Variable value:" line. Do not delete anything in the box. After the final semicolon, add a path to where your java.exe file is located. I added the following "C:\Program Files (x86)\java\jre6\bin;" without the quotes. (For XP and other 32-bit systems, the path will likely be "C:\Program Files\java\jre6\bin;" without the quotes.)

Click "OK" and on the next window click "OK."

Double-click on poisync.bat, and the error should no longer occur.

Java not recognized

ryb97001 wrote:

I installed the latest version of Java, then tried running poisync.bat. I got the following error, "'java' is not recognized as an internal or external command, operable program or batch file."

When I checked the html file in the poisync doc folder, the suggestion was to check the java version by going to the command line (accessible by typing Start > Run > cmd) and entering "java -version." This produced the same error.

If anyone else has this problem, here is what I had to do to resolve the problem.

For Windows 7, 64-bit.
Click Start button, then right-click on "Computer" (for XP right-click on "My Computer") and select "Properties."

On the left side of the screen select "Advanced system settings" (for XP, click the "Advanced" tab at the top right of the screen) then click the "Environment Variables" button.

In the "System variables" section, scroll down and click on "Path" and then click the "Edit" button.

Go to the end of the "Variable value:" line. Do not delete anything in the box. After the final semicolon, add a path to where your java.exe file is located. I added the following "C:\Program Files (x86)\java\jre6\bin;" without the quotes. (For XP and other 32-bit systems, the path will likely be "C:\Program Files\java\jre6\bin;" without the quotes.)

Click "OK" and on the next window click "OK."

Double-click on poisync.bat, and the error should no longer occur.

I had the same problem when i first tried the utility and did the same thing. Thanks for showing others how to do it! smile

Way to confirm node actually downloaded.

Thanks schumans.

--
Vince Nuvi 350

Thanks

Awesome tool.

Thanks

ryb97001 wrote:

I installed the latest version of Java, then tried running poisync.bat. I got the following error, "'java' is not recognized as an internal or external command, operable program or batch file."

When I checked the html file in the poisync doc folder, the suggestion was to check the java version by going to the command line (accessible by typing Start > Run > cmd) and entering "java -version." This produced the same error.

If anyone else has this problem, here is what I had to do to resolve the problem.

For Windows 7, 64-bit.
Click Start button, then right-click on "Computer" (for XP right-click on "My Computer") and select "Properties."

On the left side of the screen select "Advanced system settings" (for XP, click the "Advanced" tab at the top right of the screen) then click the "Environment Variables" button.

In the "System variables" section, scroll down and click on "Path" and then click the "Edit" button.

Go to the end of the "Variable value:" line. Do not delete anything in the box. After the final semicolon, add a path to where your java.exe file is located. I added the following "C:\Program Files (x86)\java\jre6\bin;" without the quotes. (For XP and other 32-bit systems, the path will likely be "C:\Program Files\java\jre6\bin;" without the quotes.)

Click "OK" and on the next window click "OK."

Double-click on poisync.bat, and the error should no longer occur.

Got mine working on Vista 64 bit after your tip.

batch poi

Schumans great program. However for us comp illiterates can you tell me how to install macros that will give date and time of updates. Not sure how to wright destination with macro in it Thanks

Here you go

rldr12 wrote:

Schumans great program. However for us comp illiterates can you tell me how to install macros that will give date and time of updates. Not sure how to wright destination with macro in it Thanks

This will give you date

01-17-2010 = (space here)%%month%%-%%day%%-%%year%%
or
2010-01-17 = (space here)%%rear%%-%%month%%-%%day%%
0r
20100117 = (space here)%%date%%

Date and time

rldr12 wrote:

Schumans great program. However for us comp illiterates can you tell me how to install macros that will give date and time of updates. Not sure how to wright destination with macro in it Thanks

Hi,

The date and time used by the macro is the date and time of the download, not the date and time of the last update. The update time stamp information is not easily available to this tool.

You don't need to install anything to use the macros. The program will expand the %%date%% and %%time%% strings in the destination path with the date and time of the download.

For example, if you have a destination of c:\mydir_%%date%%\whitecastle.csv, the program will create a directory named mydir_20100117 and place the file there if you download today (01/17/2010 in yyyymmdd format).

I'm hoping that at some point the poi update information would be available and I can take advantage of it. Until then, the only way to get the last update date is a lot of work and error prone.

batch poi

where do i put it and do i need it on every line

Beta test

Thanks for the new features.

Needed to modify computer properties, need to add ryb97001 comments to doc html

Encrytion worked as designed

Dating Folders and/or files
I found dating main folder or main sub-folderfolder works best because new download creates a new main folder or sub-folder with all the downloaded files. If you date the files and use one folder or subfolder than I would have to sort every other file, or third or forth file (etc).

Renaming poiFiles.txt
Had to name file name poiFile_weekly.txt
Found I could name file weekly.txt

For this to work you must edit poisync.bat to except poifile_weekly or poifiles_monthly, weekly or monthly, save as separate poisync weekly.bat or poisync monthly bat.

Then you'll need separate poisync mylogin weekly.bat and poisync mylogin monthly bat.

Then create two scheduled tasks, one for weekly and one for monthly scheduled tasks.

Schuman,

Great work can't wait to see what else develops.

Can the scheduled task be sequenced within the utility as a weekly event, e.g. schedule weekly task - weeks 1, 2, & 3 runs weekly.txt, weeks 4 runs monthly.txt?

Now all we need is a gpx convertion to ov2, can this be added to this utility?

Try these

rldr12 wrote:

where do i put it and do i need it on every line

How are you going to use it?

Folder

C:\MyPOIs %%date% will return C:\MyPOIs 20100117

C:\MyPOIs %%year%%-%%month%%-%%day%% will return
C:\MyPOIs 2010-01-17

C:\MyPOIs %%month%%-%%day%%-%%year%% will return
C:\MyPOIs 01-17-2010

Files

C:\MyPOIs\Redlight Cameras %%date%.csv will return C:\MyPOIs\Redlight Cameras 20100117.csv

C:\MyPOIs\Redlight Cameras %%month%%-%%day%%-%%year%%.csv will return
C:\MyPOIs\Redlight Cameras 01-17-2010.csv

poisync.bat

Thanx for this info .....solved my dilemma

--
Golf,whenever and wherever you can ... Always swing hard, just in case you hit it ..... If you can reach it,you can hole it, SEE IT FEEL IT DO IT !

Need Help with your POIfiles.txt?

If you have any trouble with posting your POIfiles.txt here from POISync, please copy/paste it at www.pastebin.ca and post the URL here. Let someone take a look at it & edit it for you. Or more, you can discuss about it.

e.g. Here is mine
http://pastebin.ca/1756922

Now someone can look at what I am doing wrong and he/she can make changes at the bottom part & repost it, I think it's a good idea to get help.

--
Garmin Nuvi 2555 LMT, Street Pilot C340, nuvi 265WT, Mio Moov 300, nuvi 255W, Navigon 2100 (Retired)

Question for you

kmo wrote:

If you have any trouble with posting your POIfiles.txt here from POISync, please copy/paste it at www.pastebin.ca and post the URL here. Let someone take a look at it & edit it for you. Or more, you can discuss about it.

e.g. Here is mine
http://pastebin.ca/1756922

Now someone can look at what I am doing wrong and he/she can make changes at the bottom part & repost it, I think it's a good idea to get help.

kmo,
There are probably a good 60 or 70 lines. Are you going to load them all in manual mode? I ask because I split my download folders as C:\MyPOIs\Express\MyPOIfile.csv and c:\MyPOIs\Manual\MyPOIfile.csv

The express folder can load unsupervised and is majority of my files such as stores, gas, wineries. The manual folder will need me to decide proximity alert for files such as off beat tourist attractions, rest stops, redlight and speed cameras.

Make a duplicate file and try a test download.

phillyguy19020

Hey Phil,

I used Express Mode for all my custom POIs.

I am satisfy with my RLC alert " Revenue Enhancement Device Ahead! " smile

I use all other POIs if I stop in a town when my way between NYC & Florida along I-95. I know most of Rest Areas for now.

Let me know if you have better idea for me. Everyday is learning day.

Thanks.

--
Garmin Nuvi 2555 LMT, Street Pilot C340, nuvi 265WT, Mio Moov 300, nuvi 255W, Navigon 2100 (Retired)

scheduling and ov2

phillyguy19020 wrote:

For this to work you must edit poisync.bat to except poifile_weekly or poifiles_monthly, weekly or monthly, save as separate poisync weekly.bat or poisync monthly bat.

Can the scheduled task be sequenced within the utility as a weekly event, e.g. schedule weekly task - weeks 1, 2, & 3 runs weekly.txt, weeks 4 runs monthly.txt?

Now all we need is a gpx convertion to ov2, can this be added to this utility?

Hi phillyguy,

The 1.0.4 beta allows you to specify the input file, so you should not need to edit poisync.bat any more. The concern I have with editing poisync.bat is that it would get overwritten if you unzip the new version into the same directory.

The way I would see how you would schedule is:

poisync weekly.txt

POISynC 1.0.4 Beta

schumans has a lot of improvement in this version as he mentioned.

Meanwhile, I am collecting all the information from this discussion thread to provide help file for step by step instruction which will include in the next version.

If anyone interest in testing & would like to provide feedback for help of the final version, please let us know here.

I am providing URLs for the Beta File to download. Doesn't matter which site you choose to download, they are all the SAME file.

http://hotfile.com/dl/24906446/87a69b7/poisync104Beta.zip.ht...

http://www.megaupload.com/?d=2LV80TQ6

http://rapidshare.com/files/337820339/poisync104Beta.zip.htm...

Thanks go to the Author - schumans, POI Factory Staffs & all feedbacks from users.

Thanks.

--
Garmin Nuvi 2555 LMT, Street Pilot C340, nuvi 265WT, Mio Moov 300, nuvi 255W, Navigon 2100 (Retired)

scheduling and ov2

schumans wrote:
phillyguy19020 wrote:

For this to work you must edit poisync.bat to except poifile_weekly or poifiles_monthly, weekly or monthly, save as separate poisync weekly.bat or poisync monthly bat.

Can the scheduled task be sequenced within the utility as a weekly event, e.g. schedule weekly task - weeks 1, 2, & 3 runs weekly.txt, weeks 4 runs monthly.txt?

Now all we need is a gpx convertion to ov2, can this be added to this utility?

Hi phillyguy,

The 1.0.4 beta allows you to specify the input file, so you should not need to edit poisync.bat any more. The concern I have with editing poisync.bat is that it would get overwritten if you unzip the new version into the same directory.

The way I would see how you would schedule is:

poisync weekly.txt <mylogin.txt
poisync monthly.txt <mylogin.txt

I was not not planning on getting into scheduling, so the intent is to provide something that would work with the scheduler instead.

I have not thought about ov2, but that's an interesting idea. I assume you would want to be able to download a gpx or csv file and have it auto convert to ov2? I'll have to dig into the ov2 format since that is binary instead of text, but I may be able to do something there.

Looks like I screwed up my previous post.

Simply the Best

This Utility does not install on your computer.
It's FREE of Sypware/Virus and does not invade your privacy.

It will not download POI factory Red Light Camera file unless you are authorized. Because some new users think they can download RLC file with POISYNC without contributing.

It is written in Java and should work on other platforms other than Windows.

--
Garmin Nuvi 2555 LMT, Street Pilot C340, nuvi 265WT, Mio Moov 300, nuvi 255W, Navigon 2100 (Retired)

Thanks

Thanks for the download.

--
Alan-Garmin c340

thanks

thanks

create target file list for poifiles.txt

Thanks for the program, When I first seen the request for it, I wasn't sure that it could be done.
It works great.

This is a method to get a list of POI folder\files into a text file which can be used to paste into POIFILES.txt

1. Select "Start"
2. Select "Run"
3. Type: Command, select OK
4. At the Dos prompt,type: cd\garmin\poi (or whatever the file path is for your POI files)
5. Type: dir /s /b *.csv *.gpx *.ov2 > POI-List.txt

When you open the text file, you should have multiple lines similar to this (more or less):
C:\Garmin\POI\Motorcycles\Harley Davidson.gpx

--
Jake88

1.0.4 now available

Version 1.0.4 is now officially available at:

http://www.nextgenlogic.com/poi.php

Thanks for all that beta tested the latest version. Some of the new functions in this version are:

  • Modified batch file to take optional control file names (other than poiFiles.txt).
  • Download and unzip zip files for RLC file
  • Synchronize with local file
  • Encrypt login file

Good effort

Thank you for creating this. The concept appears good, but the app looks terribly complicated. I got overwhelmed reading the readme.txt and I stopped there. IMO, It doesnt seem to be ready for most people including those who may be computer savy, such as myself. It really seems to be be geared for those who are into Linux or who are programmers or hackers. wink

Perhaps a future release of this app could be made to operate in much the same way as POI loader? All the user needs to do is select the POI file and then it updates your POI on your device, without overiding other POIs that you may have stored eg. updating only Walmart POIS even though you may have Costco, Red light cameras, and other POIs.

Otherwise, I'll continue to update manually as before using POI Loader each time there is an update.

New Tutorial

Hey all. I've been really busy this week due to the start of a new semester so I haven't been able to create another tutorial for the latest release. I'm hoping i'll be able to do one soon. Any requests on what to see on the tutorial? I am going to go over the auto login and also how to update the redlight files in the new one. Anything else you guys would like to see in it?

Beginner to Advance Users

Sam888 wrote:

Thank you for creating this. The concept appears good, but the app looks terribly complicated. I got overwhelmed reading the readme.txt and I stopped there. IMO, It doesnt seem to be ready for most people including those who may be computer savy, such as myself. It really seems to be be geared for those who are into Linux or who are programmers or hackers. wink

Perhaps a future release of this app could be made to operate in much the same way as POI loader? All the user needs to do is select the POI file and then it updates your POI on your device, without overiding other POIs that you may have stored eg. updating only Walmart POIS even though you may have Costco, Red light cameras, and other POIs.

Otherwise, I'll continue to update manually as before using POI Loader each time there is an update.

This Utility for Beginner to Advance Users.

It may not meet your Criteria what you expect like Garmin POI Loader.

For a beginner, it's a simple way to create poifile.txt with this concept:

Download URL _SPACE_ Local Folder where you want to save & rename POI File.

e.g.

http://www.poi-factory.com/poifiledownload/csv?node=6643 C:\MyPOI\Rest Areas.csv

Then, catch your files in C:\MyPOI

If you can Login here with your Username & Password here, then you are good to go to run POIsync.bat

Do not worry about Auto Login feature, Unzipping RLC files, etc.. those are for Advance Users.

It's not OS (Operating System) specific program, it's just a java based TOOL.

To your expectation, hope someone can write a Windows based program here some days.

--
Garmin Nuvi 2555 LMT, Street Pilot C340, nuvi 265WT, Mio Moov 300, nuvi 255W, Navigon 2100 (Retired)

More like MS DOS than Linux

Sam888 wrote:

It really seems to be be geared for those who are into Linux or who are programmers or hackers.

Or some of us old pharts that used MS DOS batch files, command line executables, redirection of Output, piping output to input etc. as a matter of course.

or...

Evert wrote:
Sam888 wrote:

It really seems to be be geared for those who are into Linux or who are programmers or hackers.

Or some of us old pharts that used MS DOS batch files, command line executables, redirection of Output, piping output to input etc. as a matter of course.

We remember using EDLIN to create those batch files.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet

MS DOS line editor

a_user wrote:

We remember using EDLIN to create those batch files.

Indeed, and that was not for the weak hearted.

Add Another Thanks

Thanks for a great tool. This really saves time.

--
Jim Garmin nuvi 660

Need poifile.txt builder help

Are you having trouble creating download lines for poiSync?

Would you like to add the date to folders, subfolders, and/or file names at a click of the mouse?

Would you like to sort your lines by Category or POI file name?

Available soon
I'm creating POIdownload Builder an excel spreadsheet. You will still have to get the poi file download link. You can have date added with a click all configured in the formula. I'm not adding macros. To sort Category or POI file name, simply perform basic menu clicks. Copy and paste results column to the poifile text file.

I am not a programmer but have found this spreadsheet to be really useful. If you would like a copy to try out message me.

Now Available

phillyguy19020 wrote:

Are you having trouble creating download lines for poiSync?

Would you like to add the date to folders, subfolders, and/or file names at a click of the mouse?

Would you like to sort your lines by Category or POI file name?

Available soon
I'm creating POIdownload Builder an excel spreadsheet. You will still have to get the poi file download link. You can have date added with a click all configured in the formula. I'm not adding macros. To sort Category or POI file name, simply perform basic menu clicks. Copy and paste results column to the poifile text file.

I am not a programmer but have found this spreadsheet to be really useful. If you would like a copy to try out message me.

POIdownload Builder 1.00, an excel spreadsheet is now available. I will forward a copy to Schuman and the Beta testers. Anyone wanting a copy to try out message me.

poisync tutorials

Added two new tutorials today. One covers the redlight cameras and the second covers auto login and encryption. Check them out and let me know what you think or if something is confusing.

http://www.screentoaster.com/user?username=dgwood12

A tutorial on control files is in the works and will be available shortly!

Excel file to generate poi-file.txt

I've have an Excel that may help with the creation of the poifiles.txt. The file will build a directory list of your POI files, parse out the unwanted file lines (.bmp & .mp3) and generate a poi-file.txt file (which you can rename). You'll need to provide the POI file links and paste them into the Excel file.

Each time you open the Excel file, do a file, saveas... to establish the filepath which is required for the macros to work properly.

Phillyguy19020, would you take a look at this? Maybe we can combine our Excel files into a single file.

This is the link:
http://www.datafilehost.com/download-5992e2fd.html

--
Jake88

If you still are confused ....

Once you know how to use poisync, you realize how simple it is to use. The easiest way to learn how to use poisync (for me) was to watch dgwood12's tutorial at

http://www.screentoaster.com/watch/stWU9RRUVIR19cQ15bWlxdVVZ...

--
Vince Nuvi 350

Jake,

Jake88 wrote:

I've have an Excel that may help with the creation of the poifiles.txt. The file will build a directory list of your POI files, parse out the unwanted file lines (.bmp & .mp3) and generate a poi-file.txt file (which you can rename). You'll need to provide the POI file links and paste them into the Excel file.

I downloaded the file but can't figure out how to use it. Where does it go and what is it supposed to read? How do you tell it what to do?

--
ɐ‾nsǝɹ Just one click away from the end of the Internet

Excel File Instructions

a_user

1: Select File, and SaveAs to establish a file path.
2: Click the Step 1 macro button and select your POI folder. That will create an Excel file named Book#.xls
3: Copy & Paste that File Data into column B
4: Select Cell B1
5: Click Step 2 macro button, select OK, OK and then enter a file extension that you want to parse such as *.bmp ....Those lines will be deleted. Repeat for *.mp3 files or other file types in list not needed.
6. Copy POI file links from POI Factory website download buttons and paste into Column A.
7. Click Step 3 macro button to generate Poi-Files.txt. Notepad will automatically open the file.
8. Rename the file POIFILES.txt

Let me know how how it goes.

--
Jake88

I get hung up at step 2

Jake88 wrote:

a_user

1: Select File, and SaveAs to establish a file path.
2: Click the Step 1 macro button and select your POI folder. That will create an Excel file named Book#.xls

OK, how do you select your POI folder? My folder and your sheet are on the desk top.

I don't see any way to select a folder.

Oh, my POI folder has sub folders in it as well. Does your VB program handle those?

Quote:

3: Copy & Paste that File Data into column B
4: Select Cell B1
5: Click Step 2 macro button, select OK, OK and then enter a file extension that you want to parse such as *.bmp ....Those lines will be deleted. Repeat for *.mp3 files or other file types in list not needed.
6. Copy POI file links from POI Factory website download buttons and paste into Column A.
7. Click Step 3 macro button to generate Poi-Files.txt. Notepad will automatically open the file.
8. Rename the file POIFILES.txt

Let me know how how it goes.

--
ɐ‾nsǝɹ Just one click away from the end of the Internet
4 5 6
<<Page 3>>