avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • November 18, 2018, 03:24 PM
  • Proudly celebrating 13 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - magician62 [ switch to compact view ]

Pages: [1] 2 3 4 5 6next
Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 06, 2018, 02:07 AM »
Windows has a command line length limit.

Dropping too many files on it at once can exceed that limit.

But seems weird that it disallows then allows the same number.

Not sure whether Windows will break it into multiple commands.

This is what I was finding weird. I had expected I could drop the number to a point which would give me a clue. But to then accept greater numbers made little sense. The only thing I could think of was something interrupted the process. I will just have to make sure I don't try and rename too big a group :)

Accepted, it's not a perfect solution, but it has proven the concept works, and although it can be quite slow on larger batches. I would say having all the species in one screen does allow for a general increase in speed and easier processing.

The biggest time consumer is creating the shortcuts and setting icons.

I got the shortcut creation time down  creating a text list of all the species, prefixing with underscore and replacing spaces with underscore. Then prefixing the whole lot with the command. I then duplicated the shortcut 150 times renamed to species and finally properties to change the command inside.

I still have to finish the icon side :)

The concept will work for just about anything I want to add.

I also suffix with location, so have used the same technique for that too. Saves having to open a renaming program and select to create a rule for the change.

I can see a full fledged drag drop with creation from a data list would benefit those who predominantly use a mouse. 

All i need to do now is figure the best way of handling which camera in the filename. :)

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 05, 2018, 12:26 PM »
Have encountered an occasional issue with larger batches.

Though have not been able to narrow down. The number of files it will process seems to vary I started at 1000 error. Stepped down to around 300 error, then dropped close to above 255, worked Went back to 400, worked.
All filenames are of the same length.

Now it gets weird. The time taken for similar size batches is varying quite wildly, so something else must be going on.

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 05, 2018, 11:48 AM »
Files have no need to move. Rename is in same location.

The code used is
# DND-Rename.ps1
for ($i = 1; $i -lt $args.Count; $i++) {
Move-Item $args[$i] ($args[$i] -replace "(\.[^.]+$)", "$($args[0])`$1")

Post New Requests Here / Re: IDEA: Automagic Digital Photo Manager
« on: November 05, 2018, 07:30 AM »
A little observation, as I need to look further at this util. I work always in GMT for photograph times, but I suspect not all cameras do. :)

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 05, 2018, 07:25 AM »
I was using "move". :)

The irony on Icons was i have several graphics packages, just none allowed me to create icons!

I suspect part of my speed issue is, my system was a W10 upgrade from W7 rather than fresh install. I have occasions where if several large files are sent to my computer from another on the network, I can loose total control till completed. If I pull the same files, I have no problems. The solution is probably a format, but even when I upgraded, I really didn't fancy spending a month or more re-installing and reconfiguring everything to where I had it before. :)

A good way of describing, and it is not just this util. If I drag a number of files from an explorer window to my graphics program, I can not select any file in the source folder till all the files have loaded as I get a busy cursor. File "moves" see explorer processor usage go silly. It's almost as though it has forgotten to multi task. :)

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 05, 2018, 01:55 AM »
Try changing the shortcut Target to the following:

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -ExecutionPolicy Bypass -NoExit -File "E:\Renamer\DnD-Rename.ps1" _Kingfisher

-ExecutionPolicy Bypass will tell Powershell to ignore all security settings and just run the script, (since it's rather simple this should be OK).
-NoExit will keep the console window open so you can read any errors.

That sorted it. :)

Now executes as intended.

A couple of issues I have identified,, which I suspect is a function of how windows now seems to work.

On processing large numbers of files 100+ (each 10-20mb). I am unable to add further files till they are processed, as windows will not allow them to be selected.

Having to create an icon... :)

Due to the way this works, it may not be suited to the original idea because of the delays it creates with larger groups of files, as mentioned that may be windows, but it does work very well for another task I have in mind. :)

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 04, 2018, 05:28 PM »
Not an All-in-One solution but just something simple in the meantime.

As best I can tell, I have done as stated but nothing appears to happen. Console window opens and closes, but that seems it. There does seem to be red writing at thee top of the console window, but not possible to read. Is there a way to make it persist?

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -File "E:\Renamer\DnD-Rename.ps1" _Kingfisher

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 03, 2018, 04:06 AM »
* Stephen66515 waves
Waves back. :)

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 03, 2018, 03:48 AM »
I'm more the maker not the thinker. (even if i thought my idea mirrors request...)
I'm more the creator not the user. (even if standard wheel exists; i like to have my custom ones...)
And finally, if you need to think and rethink (maby due to the way i communicate), i do not harm anyone or want to convince anyone.
Free world for free softwares :-)

Your are in best hands @mouser  :-*
He can better communicate and final product does what he say.

Best wishes!

I have no issue with how you communicate, we all do it differently, if we all did it the same the world would be very plain. If you have ever tried talking to some of the natives in England, even we have trouble understanding them even if born 10 miles down the road!

I think when I have something in my mind, reading anothers take on it can sometimes be harder as you try to see how it fits. Second coffee now taking effect :)

It does look like mouser may have a simple solution to piggyback existing tools, but thank you for your interest.

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 03, 2018, 03:04 AM »
Once I know how it works, it shouldn't be a problem.

Examples are good especially if regex is involved :)

I use a number of Skwire's utils that use regex and can normally muddle my way through. :)

If it uses regex and has a result preview option, even better. :)

I do have Bulk Rename Utility installed if that helps. :)

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 03, 2018, 02:56 AM »
Restatement of requirements

A user resizeable interface window which contains a variable number of tiles approximately 150px square.

Each tile should have the ability to allow an image thumbnail in place or overlayed on the tile

When one, or many files are dragged from Windows and "dropped" onto the appropriate tile. A predefined rename function should auto-magically be performed on the file(s)

Ideally this rename function is immediate, or in a running queue, so the original file is updated as soon as resources are available. ( This is to accommodate the possible effect of a renaming large group of files)

Does that make it easier?

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 03, 2018, 02:48 AM »
To intrude once more lightly into this thread.. A long while ago I wrote a program called Drag and Drop Robot: http://www.donationc.../drag-and-drop-robot
That program let you drop files into a window and ran a batch commandline on each.

*IF* you could separate your needs into a gui drag and drop tool, and a commandline renamer, it wouldn't be too hard to take the Drag and Drop Robot Code and make it so there was a grid of drop targets with associated images, and a separate commandline specified for each target.  Dropping files onto a target cell would simply queue that commandline up in the batch queue.

Having said all that, it's still an interesting idea of kodezwerg or someone else wants to make a more dedicated renamer tool..
Interesting. Second coffee has arrived. :)

I will restate the requirement, which might make for an easier to split the functions, and your idea may then work.

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 03, 2018, 02:27 AM »
After first coffee

I will add the original source location should be from outside the utility, so once I catch up, I can wildcard the originating windows folders and work across a few.. We see about 150 species, but there is no real upper limit.

Just yesterday a little over 1000 images were added to the stack. :)

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 03, 2018, 02:21 AM »
If i may stick to my written text and your reply....

you mean the steps where i told about fileoperations and what boxes are doing... you want in fact virtual folders?

i mean....
the "boxes" thing what i mentioned and on screenshot displayed as large icons on right side

those should have some kind of "playlist" (stored locations of added files, just names, no actual files)
and my "execute" button will just rename original files in original folders and add them to selectex box.
opening a box will open something that look, feel and smell like explorer with whatever files you added.

that right?
Sorry, As mentioned in my reply to mouser, I am still digesting what you wrote. :)
It was a bit late last night for thinking too much. :) And I have read through a couple of times, slowly building in my mind a picture of what you propose.

Give ma a chance to down a few coffee, and I will have another read through this morning.

Post New Requests Here / Re: IDEA: Drag Drop renamer
« on: November 02, 2018, 06:24 PM »
This is an interesting idea..

Let me try to summarize the idea:
You want to be able to rename a bunch of files that can be categorized as being one of a set of categories, and where the categories are usually visual in nature and so dragging and dropping onto the visual category would be natural.

May I suggest a slightly different way of going at this that would require hugely less coding and take advantage of existing tools:

If you think of the renaming as taking place in two stages:  First organizing your photos in category FOLDERS, and then renaming files inside folders.
Use your favorite file explorer replacement, with folders in thumbnail mode, to organize your photos.  Just create folders for each category and copy or move images into them.
Then stage 2 is renaming files based on what folder they are in.

A file explorer tool seems built well for your desired use and reinventing the wheel for this would be a considerable amount of work...

Still thinking over the KodeZwerg response, but to answer you question.

For myself it is all images, but the idea allowed for use by others

Sorting to folders would mean breaking the existing file structure and necessitating it to be rebuilt later.

It also doesn't accommodate images where there is more than one primary subject, as occasionally happens (I hadn't mentioned this as using suffix, I could just process a second time if needed). 

My current method uses a drag drop renamer where i can drag from various locations sometimes using wildcard view, and drop into the utility, then process. The util does allow multiple instances but there is only so much space available where you can still access the start button. So often limited to 9 or at best 18 options, but that uses up 2 monitors

Using the method you suggest would likely be slower than the existing method after adding back the original structure.

Also working on a starting structure containing over 150K files and potentially 3-10k being added a week, it is growing quite quickly and is already onto a second 2TB drive

Post New Requests Here / IDEA: Drag Drop renamer
« on: November 02, 2018, 01:21 PM »
Having looked on the web, I can find noting that fits the bill, so if anyone knows of something that fits the bill, please speak up.

In this modern day, like many, I take photographs, in my case birds. I have in the last year accumulated around 150k pictures, which really could do with better identification. I have already used a number of methods to append the species, but none are overly efficient.
My preference is to put the subject species into the filename.

The current filename format before species is
After species I get

As to the idea, which should work for just about anything or any filetype.

A variable size window, so a variable number of "tiles" can be created, allowing for multi monitor use.

The tile size would be around 150px. square or variable but the same size for all tiles.

Each tile is in effect a drop zone where a single, or multiple selection of images can be dropped and the assigned rename applied.

Ideally the tile should have the ability to overlay a users supplied image using the full tile, keeping aspect ratio and sizing to longest side.

Under the Tile should be the rename criteria, Ideally without Underscores, but could be user defined.

I envisage a user interface where the user would put the rename criteria

In this interface there would be
A row for each tile which would contain The rename criteria and a link to a source image which would be imported and then saved with the program settings to create the thumbnail on the tile.
Ideally a selector to indicate substitute spaces which in my case is an underscore, but maybe give the user a box to type what they want
A selector to indicate if the above character should be used to separate the rename criteria from original filename.
An option could also select prepend the original filename for those that would like it
These three could be just added as options to the row above. which would allow different affects for different adjustment is people needed it

The ability to save the rename set, so multiple sets for different purposes could be created.

Ideally the rename process might be some form of queue so that it does not interfere with subsequent drops. This would be most beneficial where a 100 or so images need a rename in one drop
Files may be from multiple locations, but filenames are unique.
Renamed files will remain in their source folders

I have attached an image that gives an idea of the sort of layout (Borrowed from other software)

Hopefully that explains it :)

Post New Requests Here / Re: IDEA Data extraction and convert to CSV
« on: November 29, 2017, 02:02 AM »
Many thanks. I have downloaded. Will check when we get back, assuming we don't have snow after we go out :)

Post New Requests Here / Re: IDEA Data extraction and convert to CSV
« on: November 28, 2017, 10:13 AM »
The original solution works. And that is what is needed at the end of the day. Hope to put it to a bigger test later on today. :)

Post New Requests Here / Re: IDEA Data extraction and convert to CSV
« on: November 28, 2017, 06:58 AM »
Oh! I missed all the fun :) Totally lost a day there. If anyone finds it, please let me know.

As to direct import in Access, for myself quite sometime since I imported data not in CSV format, and never in the above format. If I say I remember Access 2.... :)

Post New Requests Here / Re: IDEA Data extraction and convert to CSV
« on: November 26, 2017, 04:32 PM »
So decided to have a little play, few issues, but that was my source data! :)

No need for process from Doc.

GUI would I assume make frequent use easier, and I can see the use growing over time.
Input and column separator options would also be good.

For the moment I have placed the text source in the same folder as the util, which only takes a few seconds.

My test used 9 records, 3 of which didn't process correctly due to issues. One was found to be a duplicate. A bonus!

Post New Requests Here / Re: IDEA Data extraction and convert to CSV
« on: November 26, 2017, 03:46 PM »
Many thanks, have downloaded. As it is late here at the moment, and I need to be up early, I will likely test later tomorrow.

Post New Requests Here / Re: IDEA Data extraction and convert to CSV
« on: November 26, 2017, 02:42 PM »
That looks like it will work. The order of result columns is not important, as the columns can be re-ordered or handled in a query later.

Post New Requests Here / Re: IDEA Data extraction and convert to CSV
« on: November 26, 2017, 01:25 PM »
I do have Excel, and I know I can transpose rows/columns, but as far as I know it may not be possible for this case. I am using Office 2007 just in case new features have appeared since

Output format

fieldname1 fieldname2 fieldname3
data1         data2         data3
data1                          data3
data1         data2         data3

Using the @ symbol for delimitation

Post New Requests Here / Re: IDEA Data extraction and convert to CSV
« on: November 26, 2017, 12:07 PM »
All data single line, and would hazard no more than 200 characters.

Post New Requests Here / IDEA Data extraction and convert to CSV
« on: November 26, 2017, 10:30 AM »
I have a number of large files which contain multiple records of two columns of data. The first column is effectively a field name, the second the data. There are multiple records in the file so am looking to extract the data to a CSV with field names as the first row.

The delimiter will need to be the @ symbol as the data may contain a comma. I can format the data to have a delimiter after fieldname and after data if it helps.

Original data source is a word doc, which will be exported to txt for processing. Final destination will be Access

To make it a little harder, not all fieldnames exist in every record, but the first one will always be there.

Ideally the snack will allow the user to define the word in the first column which is the start of a record. Not all rows are really needed, so either they can all be captured and later processed to remove un-needed fields and data. Or if a facility for the user to define the fields existed, I can enter the fieldnames as needed for each document type.

Data example

[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]

Alternatively I can have each record in a seperate text file, if that would be easier

Hopefully someone can help, as there are several thousand records in the documents

Pages: [1] 2 3 4 5 6next