Messages

51

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

52

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.

53

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....

54

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!

55

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.

56

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.

57

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

58

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.

59

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

fieldname1@data1
fieldname2@data2
fieldname3@data3
fieldname4@data4
fieldname1@data1
fieldname2@data2
fieldname3@data3
fieldname4@data4
fieldname1@data1
fieldname3@data3
fieldname4@data4


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

60

Skwire Empire / Re: Release: Comic Book Archive Creator

« on: April 25, 2017, 11:27 AM »

Would like to see a couple of features.

Multiple source files to corresponding multiple output files. As mentioned above i.e a.pdf, b.pdf, c.pdf become a.cbz, b.cbz, c.cbz. etc.

Defineable output destination path/directory to allow different location.
Option to also move processed source files to a a defineable destination.

 

61

Post New Requests Here / Re: Replace text months to digital months

« on: August 01, 2016, 02:21 PM »

Thus, you can always find/sort documents by date (thus putting the date to good use), and there's no easy mistake about dates in ISO format.

-IainB (July 21, 2016, 08:06 AM)

Isn't this how everyone does it? I have been using this technique since 1982. And the ISO wasn't even published till 1988

62

Post New Requests Here / Re: Replace existing file with zero byte version with slight name change

« on: December 26, 2015, 04:47 PM »

So I went ahead and tried it, and although a little sleepy I got their in the end, was having issues with sPath syntax. I have now added multiple replacements as I realised I hade used more than one coding. Many thanks for your help.

63

Post New Requests Here / Re: Replace existing file with zero byte version with slight name change

« on: December 26, 2015, 03:01 PM »

Hi Jody, as it's getting late in the evening, will test in the morning and report back, many thanks.


Also you may not have seen my bug comment on Files2Folders, , last page
https://www.donation...opic=19770.msg393594

64

Post New Requests Here / Re: Replace existing file with zero byte version with slight name change

« on: December 26, 2015, 12:44 PM »

Hi Jody, the current format is " [PLACEHOLDER].ext" so always immediately before the extension and in the square brackets. .placeholder will be the new extension, so I can filter on that in future.

As mentioned though I can do the rename elsewhere quite easy. Getting the zero byte files is the hard bit. I can even drag drop them in bulk to a util that replaces the file with zero byte


Ath

The reason for creating files in advance gave the ability to see what is missing, using PLACEHOLDER provided a simple, and filterable visual aid to identify those files, which may have been of different length to allow for the expected file size.

I don't expect a zero byte file to reserve drive space. The methodology has changed with falling storage costs and there is now at least 100Gb reserved space on the drive should the missing files, though unlikely, appear.

65

Post New Requests Here / Replace existing file with zero byte version with slight name change

« on: December 26, 2015, 11:38 AM »

I have in multiple directories on a drive with files I once created as placeholders for later replacement with the correct file, and also reserving physical drive space.

They are identified in the name by " [PLACEHOLDER]"

What I am trying to do is bring all these files down to Zero Byte.

Then change the file type whatever it may be to ".placeholder"

Then remove " [PLACEHOLDER]" from the filename
 

An all in one solution would be great, but I can achieve the last two with Bulk Rename Utility in a couple of passes, so not a major issue.

Any thoughts.

66

Finished Programs / Re: DONE: Right Click any file and create New Folder by its Name

« on: December 17, 2015, 04:50 AM »

Hi Jody, looks like I have found a small issue with Files2Folder

If there is a trailing space no folder is created.

"Example .jpg"

Hopefully you can confirm, I am currently using Win10

67

Post New Requests Here / Re: IDEA: Folder File Count and Move

« on: October 14, 2015, 12:34 PM »

I think some of the issues were with folders beginning with " ", which obviously shouldn't be there in the first place. I still need to investigate, but it may just be as easy to do a quick rename and deal with them in later processing as they are less than 0.5% of the folders processed.

68

Post New Requests Here / Re: IDEA: Folder File Count and Move

« on: October 13, 2015, 03:21 PM »

I had a few issues at first which seems related to characters in the folder name. I have separated those for the moment and will investigate later.

But for the moment it seems to be working, only 14000 folders to go on this pass
Many thanks

69

Post New Requests Here / Re: IDEA: Drop Zone for Web Images

« on: October 12, 2015, 01:26 PM »

Works well. I like the create /update change. It will save 4 clicks for every image, especially when you are almost certain there will be a name conflict 

You should find a small donation of my appreciation.

70

Post New Requests Here / Re: IDEA: Drop Zone for Web Images

« on: October 12, 2015, 01:11 PM »

Your right, I must have missed typing minutes in the original spec

The JPG jpg issue is as you say. I must have hit on some images where everything was JPG which made it appear that a change has happened.

Can you repost the code, it didn't add correctly and now has emoticons

71

Post New Requests Here / Re: IDEA: Drop Zone for Web Images

« on: October 12, 2015, 11:34 AM »

That is much better.

There seems to have been a change that has crept in, in that the filetype is now JPG it was jpg

Also the default datestamp, has Minutes omitted

It may also need an error trap.
If you create a second event but don't change anything from the default it will throw an Invalid Option. This then cause a problem when you try to return to the config with a further error Invalid Gui name, and again on exiting.



I can use it with Firefox for what I need, but will  look at IE11 again and the security issue when I get a chance

72

Post New Requests Here / Re: IDEA: Drop Zone for Web Images

« on: October 12, 2015, 11:05 AM »

Going to download now and give it a try.

73

Post New Requests Here / Re: IDEA: Drop Zone for Web Images

« on: October 12, 2015, 09:31 AM »

Ok that didn't exactly do what I expected . When I dragged the attached image to the Drop Zone in Firefox it created a shortcut to the original, but IE11 it was barred.

However it will serve as a means of mutual testing, and an unexpected feature.


Another small issue found is that a "space" seems to be inserted after the date/time. I am using "yyyy-MM-dd_hh-mm-ss"

74

Post New Requests Here / Re: IDEA: Drop Zone for Web Images

« on: October 12, 2015, 09:22 AM »

Just did a check and it looks like the issue is with any image in IE11. Works OK in Firefox. Thought I did that check the other day, but must have forgotten.

Any webpage image with no hyperlink attached seem affected.

Can we bypass the filename check and maybe just produce a box that self closes after a few seconds indicating a save has been completed. And is there a way of making it appear on the monitor where the drop zone is located, if not just above the system tray so bottom right of monitor. I use 3 monitors and everything likes to appear in the middle of monitor 1

75

Post New Requests Here / IDEA: Folder File Count and Move

« on: October 11, 2015, 12:05 PM »

There seem to be a number of utilities out there for size of folders, but nothing obvious for File count.

Concept
From source folder move all sub folders with less than or greater than x files (not likely both) to definable Destination folder.

Givens
1. For ease destination folder would be at same or higher level than source folder on same drive, with a name of same or less length (should prevent path length issues and lengthy move process)
2. There will be only folders in the source folder.
3. If a sub folder contains a further folder it may be classified as 'one' item for the purpose of the count.

I have something like 20000 folders all with small files of varying numbers, the intent is to weed out those with few files for further review/categorisation.