Re: [LegacyUG] Renaming media files

2019-01-11 Thread Peter Matthews

I keep coming back to Irfanview image viewer as the best batch renaming free 
program.
- sort your files on the Windows Explorer tag, i.e. into 2 blocks.
- copy one block of your two blocks into a separate folder.
- open one of the copied files in Irfanview and select Batch Rename.
- select all the files in the folder for the renaming.
- the usual renaming options, but really powerful is the ability to pick out 
bits of
the original filename via the [...] method and rebuild the name using those 
bits
together with bits of fixed text or incrementing digits. See Irfanview 
renaming Help.
- choose whether the renamed files overwrite or copy elsewhere.
- use the 'preview' option to see if the renaming would work as intended.
- rename.
- repeat for the 2nd batch.

Of course the hard part is retaining the correct linkages in Legacy. I guess 
that's where the database wrangling come in!

Peter



At 18:11 11-01-19 +, Chris Swann via LegacyUserGroup wrote:
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-GB

All,

I suspect i already know the answer but.

I have a LOAD of media files that have the name Unknown(xxx), where xxx is a 
number. I have tagged the files (in Windows Explorer) as to whether they are 
1911 UK census images or UK BMD entries.

What I would like to do is rename, at the very least, the Census files to a 
standard 1911 England Census(xxx) format so that I at least have all the Census 
files in order.

Is there any way to bulk rename the files to replace the Unknown with 1911 
England Census without having to do each one individually ?

Alternatively, does anyone have a schema for the data tables that I could use 
to cook up my own Access query to try and achieve the desired outcome ?

Thanks in advance,

Chris Swann
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2019-01-11 Thread Brian Kelly
The table names have always been cryptic. When you have to type a table 
or variable name hundreds of times a day when writing code you want them 
short.


Brian Kelly

On 11-Jan.-19 3:24 p.m., Chris Hill wrote:
Unfortunately, our friends at Millennia have not put a database 
structure into it, and the table and field names are not always obvious. 
I think that they made it harder 2 or 3 versions ago.


--

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2019-01-11 Thread bobstree2
WARNING
If you use other tools to rename the files outside of Legacy you will lose the 
linkage to the indivlduals.   You should only rename the media files using 
Legacy's renaming tools. 


 Original message From: Chris Swann via LegacyUserGroup 
 Date: 1/11/19  2:50 PM  (GMT-05:00) To: 
legacyusergroup@legacyusers.com Cc: Chris Swann  
Subject: Re: [LegacyUG] Renaming media files 

Hi Barry,
Renaming the media files is the easy part lol, what I need to be
  able to do is link the new name back to Legacy so that the image
  is still linked to the correct individual(s)
C


On 11/01/2019 19:36, Barry via
  LegacyUserGroup wrote:



  
  
  
  
Hi
Try some free shareware called ‘Advanced Renamer’ for batch
renaming etc.
 

  
From: LegacyUserGroup
[mailto:legacyusergroup-boun...@legacyusers.com] On
  Behalf Of Chris Hill

Sent: 11 January 2019 18:59

To: Legacy User Group


Subject: Re: [LegacyUG] Renaming media files
  

 

  Hi


   


      Interesting problem, and my first
  question is 'why did you do it that way?' 


   


  All pre-1911 census records can
  be indexed by the Head of the family or by a location
  & page number (better if there are multiple families
  on the sheet). Individual 1911 census records can be
  indexed by the Head of the family and the summary sheets
  as before. Equally, BMD images must relate to one or more
  individuals, especially for parish records, which can be
  used to index them which I then extend with the date of
  the event. I have also structured the media folder into
  separate sub-folders by census year, births, marriages,
  deaths etc. which simplifies the file name system.


   


      However, somehow you need to
  build a list of the existing images and associate them
  against a list of new names, and then process them.


   


      How good is your VBA since that
  will be only way to do it and, depending on exactly how
  you you want to structure the new file names, can be built
  to do it automatically. Yes, it can be done, but you will
  need to work through the tables to identify what you need
  to find and update, and also make the change to the file
  as well. Alternatively you could write an external program
  to do it.


   


      It happens that I am a programmer
  and have worked on Access VBA, and I would need several
  attempts to write something to do it and test it out. Of
  course working on a backup copy until I was 100% happy
  that it was correct and that Legacy still liked it.


   


      Otherwise, it is the slow 'do it
  by hand' method. Change the file name, open the individual
  or event and manually re-identify the file - the media
  relinker is pretty well useless at that job if you let it
  try to locate the image, which no longer exists.


  
 
  
  
Regards
  
  
 
  
  
Chris
  


   


  -- Original Message --


  From: "Chris Swann via
  LegacyUserGroup" 


  To: "Legacy User Group" 


  Cc: "Chris Swann" 


  Sent: 11/01/2019 18:11:29

        
  Subject: [LegacyUG] Renaming media
  files


   


  

  All,


   


  I suspect i already know the
  answer but.


   


  I have a LOAD of media files that
  have the name Unknown(xxx), where xxx is a number. I
  have tagged the files (in Windows Explorer) as to
  whether they are 1911 UK census images or UK BMD
  entries.


   


  What I would like to do is
 

Re: [LegacyUG] Renaming media files

2019-01-11 Thread Kevin Ferguson
There is also DMEX that will rename a whole bunch of stuff. It is free too.

https://www.ghacks.net/2017/11/13/dmex-more-windows-explorer-functionality/
[https://www.ghacks.net/wp-content/uploads/2017/11/dmex.png]<https://www.ghacks.net/2017/11/13/dmex-more-windows-explorer-functionality/>

DMEX: more Windows Explorer functionality - gHacks Tech 
News<https://www.ghacks.net/2017/11/13/dmex-more-windows-explorer-functionality/>
DMEX is a free program for Microsoft Windows operating systems that adds a 
large number of new features and improvements to Windows Explorer. The 
application is a rewrite of DMEXMenu and DMEXBar which added similar 
functionality to Explorer. We reviewed DMEXBar back in 2006, so check this out 
if you ...
www.ghacks.net




www.abbydalesystems.com<http://www.abbydalesystems.com>


Numbers 6:24-26


From: LegacyUserGroup  on behalf of 
Barry via LegacyUserGroup 
Sent: Friday, January 11, 2019 1:36 PM
To: 'Legacy User Group'
Cc: Barry
Subject: Re: [LegacyUG] Renaming media files


Hi Try some free shareware called ‘Advanced Renamer’ for batch renaming etc.



From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On 
Behalf Of Chris Hill
Sent: 11 January 2019 18:59
To: Legacy User Group 
Subject: Re: [LegacyUG] Renaming media files



Hi



Interesting problem, and my first question is 'why did you do it that way?'



All pre-1911 census records can be indexed by the Head of the family or by 
a location & page number (better if there are multiple families on the sheet). 
Individual 1911 census records can be indexed by the Head of the family and the 
summary sheets as before. Equally, BMD images must relate to one or more 
individuals, especially for parish records, which can be used to index them 
which I then extend with the date of the event. I have also structured the 
media folder into separate sub-folders by census year, births, marriages, 
deaths etc. which simplifies the file name system.



However, somehow you need to build a list of the existing images and 
associate them against a list of new names, and then process them.



How good is your VBA since that will be only way to do it and, depending on 
exactly how you you want to structure the new file names, can be built to do it 
automatically. Yes, it can be done, but you will need to work through the 
tables to identify what you need to find and update, and also make the change 
to the file as well. Alternatively you could write an external program to do it.



It happens that I am a programmer and have worked on Access VBA, and I 
would need several attempts to write something to do it and test it out. Of 
course working on a backup copy until I was 100% happy that it was correct and 
that Legacy still liked it.



Otherwise, it is the slow 'do it by hand' method. Change the file name, 
open the individual or event and manually re-identify the file - the media 
relinker is pretty well useless at that job if you let it try to locate the 
image, which no longer exists.



Regards



Chris



-- Original Message --

From: "Chris Swann via LegacyUserGroup" 
mailto:legacyusergroup@legacyusers.com>>

To: "Legacy User Group" 
mailto:LegacyUserGroup@legacyusers.com>>

Cc: "Chris Swann" mailto:d...@derby99.plus.com>>

Sent: 11/01/2019 18:11:29

Subject: [LegacyUG] Renaming media files



All,



I suspect i already know the answer but.



I have a LOAD of media files that have the name Unknown(xxx), where xxx is a 
number. I have tagged the files (in Windows Explorer) as to whether they are 
1911 UK census images or UK BMD entries.



What I would like to do is rename, at the very least, the Census files to a 
standard 1911 England Census(xxx) format so that I at least have all the Census 
files in order.



Is there any way to bulk rename the files to replace the Unknown with 1911 
England Census without having to do each one individually ?



Alternatively, does anyone have a schema for the data tables that I could use 
to cook up my own Access query to try and achieve the desired outcome ?



Thanks in advance,



Chris Swann







[https://ipmcdn.avast.com/images/icons/icon-envelope-tick-green-avg-v1.png]<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
 Virus-free. 
www.avg.com<http://www.avg.com/email-signature?utm_medium=email_source=link_campaign=sig-email_content=webmail>
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2019-01-11 Thread Chris Hill
Hi Chris

Yes, you have to be carefully with files from Ancestry. My method is to
prefix the name that Ancestry has used for the file name with a sensible
name relating to the individuals or location.

Access will happily open a Legacy .fdb file. Unfortunately, our friends at
Millennia have not put a database structure into it, and the table and
field names are not always obvious. I think that they made it harder 2 or 3
versions ago. Self preservation of course, unless you want to build an
interface and need to buy a licence.

I have looked through it in the past and did make a change to the media
folder names so that they were correctly pointed to the [media folder
base]/folder/...  rather than to an explicit Windows folder. Don't actually
know why half of them were wrong but it was causing issues when I had a
copy on my laptop with a different folder structure - I keep my data away
from the default Legacy structure. And having a structured folder and file
system helps a lot - I don't want one folder with 1000s of files in it.

It is not always obvious what each table does, unless it has content that
you can identify, and how they link together. I think I have a list of the
tables with a description on my PC I can send you tomorrow.

Regards

Chris

>From my Motorola G6+

On Fri, 11 Jan 2019, 19:52 Chris Swann via LegacyUserGroup <
legacyusergroup@legacyusers.com wrote:

> Hi Chris,
>
> Thanks for the reply.
>
> I didn't actually do it, honest !! - it was Ancestry when I downloaded
> data ages back and created a new Legacy tree !! The other Census image
> files actually downloaded as  England Census(xxx) and, at least for
> now, are far easier to work with.
>
> Since then my files are in a far better state but I really want to tidy up
> all the "dross" that was present from the original build.
>
> My Access skills, although a little rusty, are pretty good as I have
> written complete and very complex applications for 4 large hospitals in the
> UK as well as being involved on programming, for some time, with a
> commercial aviation database.
>
> Given a schema I'm 99.9% certain I can sort out the appropriate
> codes/queries/whatever to accomplish the task.
>
> C
> On 11/01/2019 18:58, Chris Hill wrote:
>
> Hi
>
> Interesting problem, and my first question is 'why did you do it that
> way?'
>
> All pre-1911 census records can be indexed by the Head of the family
> or by a location & page number (better if there are multiple families on
> the sheet). Individual 1911 census records can be indexed by the Head of
> the family and the summary sheets as before. Equally, BMD images must
> relate to one or more individuals, especially for parish records, which can
> be used to index them which I then extend with the date of the event. I
> have also structured the media folder into separate sub-folders by census
> year, births, marriages, deaths etc. which simplifies the file name system.
>
> However, somehow you need to build a list of the existing images and
> associate them against a list of new names, and then process them.
>
> How good is your VBA since that will be only way to do it and,
> depending on exactly how you you want to structure the new file names, can
> be built to do it automatically. Yes, it can be done, but you will need to
> work through the tables to identify what you need to find and update, and
> also make the change to the file as well. Alternatively you could write an
> external program to do it.
>
> It happens that I am a programmer and have worked on Access VBA, and I
> would need several attempts to write something to do it and test it out. Of
> course working on a backup copy until I was 100% happy that it was correct
> and that Legacy still liked it.
>
> Otherwise, it is the slow 'do it by hand' method. Change the file
> name, open the individual or event and manually re-identify the file - the
> media relinker is pretty well useless at that job if you let it try to
> locate the image, which no longer exists.
>
> Regards
>
> Chris
>
> -- Original Message --
> From: "Chris Swann via LegacyUserGroup" 
> To: "Legacy User Group" 
> Cc: "Chris Swann" 
> Sent: 11/01/2019 18:11:29
> Subject: [LegacyUG] Renaming media files
>
> All,
>
> I suspect i already know the answer but.
>
> I have a LOAD of media files that have the name Unknown(xxx), where xxx is
> a number. I have tagged the files (in Windows Explorer) as to whether they
> are 1911 UK census images or UK BMD entries.
>
> What I would like to do is rename, at the very least, the Census files to
> a standard 1911 England Census(xxx) format so that I at least have all the
> Census files in order.
>
&g

Re: [LegacyUG] Renaming media files

2019-01-11 Thread Jennie Matheson
Hi Chris,

Not sure what OS you are running. Under Windows 10 (at least) you can
select all the files you want to have the same base name, then right click,
select rename and they will all be renamed base name (xxx)

Jennie

On Sat, Jan 12, 2019 at 5:14 AM Chris Swann via LegacyUserGroup <
legacyusergroup@legacyusers.com> wrote:

> All,
>
> I suspect i already know the answer but.
>
> I have a LOAD of media files that have the name Unknown(xxx), where xxx
> is a number. I have tagged the files (in Windows Explorer) as to whether
> they are 1911 UK census images or UK BMD entries.
>
> What I would like to do is rename, at the very least, the Census files
> to a standard 1911 England Census(xxx) format so that I at least have
> all the Census files in order.
>
> Is there any way to bulk rename the files to replace the Unknown with
> 1911 England Census without having to do each one individually ?
>
> Alternatively, does anyone have a schema for the data tables that I
> could use to cook up my own Access query to try and achieve the desired
> outcome ?
>
> Thanks in advance,
>
> Chris Swann
>
>
>
> --
>
> LegacyUserGroup mailing list
> LegacyUserGroup@legacyusers.com
> To manage your subscription and unsubscribe
> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
> Archives at:
> http://www.mail-archive.com/legacyusergroup@legacyusers.com/
>
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2019-01-11 Thread Chris Swann via LegacyUserGroup

Hi Barry,

Renaming the media files is the easy part lol, what I need to be able to 
do is link the new name back to Legacy so that the image is still linked 
to the correct individual(s)


C

On 11/01/2019 19:36, Barry via LegacyUserGroup wrote:


Hi Try some free shareware called ‘Advanced Renamer’ for batch 
renaming etc.


*From:*LegacyUserGroup 
[mailto:legacyusergroup-boun...@legacyusers.com] *On Behalf Of *Chris Hill

*Sent:* 11 January 2019 18:59
*To:* Legacy User Group 
*Subject:* Re: [LegacyUG] Renaming media files

Hi

    Interesting problem, and my first question is 'why did you do it 
that way?'


All pre-1911 census records can be indexed by the Head of the 
family or by a location & page number (better if there are multiple 
families on the sheet). Individual 1911 census records can be indexed 
by the Head of the family and the summary sheets as before. Equally, 
BMD images must relate to one or more individuals, especially for 
parish records, which can be used to index them which I then extend 
with the date of the event. I have also structured the media folder 
into separate sub-folders by census year, births, marriages, deaths 
etc. which simplifies the file name system.


    However, somehow you need to build a list of the existing images 
and associate them against a list of new names, and then process them.


    How good is your VBA since that will be only way to do it and, 
depending on exactly how you you want to structure the new file names, 
can be built to do it automatically. Yes, it can be done, but you will 
need to work through the tables to identify what you need to find and 
update, and also make the change to the file as well. Alternatively 
you could write an external program to do it.


    It happens that I am a programmer and have worked on Access VBA, 
and I would need several attempts to write something to do it and test 
it out. Of course working on a backup copy until I was 100% happy that 
it was correct and that Legacy still liked it.


    Otherwise, it is the slow 'do it by hand' method. Change the file 
name, open the individual or event and manually re-identify the file - 
the media relinker is pretty well useless at that job if you let it 
try to locate the image, which no longer exists.


Regards

Chris

-- Original Message --

From: "Chris Swann via LegacyUserGroup" 
mailto:legacyusergroup@legacyusers.com>>


To: "Legacy User Group" <mailto:LegacyUserGroup@legacyusers.com>>


Cc: "Chris Swann" mailto:d...@derby99.plus.com>>

Sent: 11/01/2019 18:11:29

Subject: [LegacyUG] Renaming media files

All,

I suspect i already know the answer but.

I have a LOAD of media files that have the name Unknown(xxx),
where xxx is a number. I have tagged the files (in Windows
Explorer) as to whether they are 1911 UK census images or UK BMD
entries.

What I would like to do is rename, at the very least, the Census
files to a standard 1911 England Census(xxx) format so that I at
least have all the Census files in order.

Is there any way to bulk rename the files to replace the Unknown
with 1911 England Census without having to do each one individually ?

Alternatively, does anyone have a schema for the data tables that
I could use to cook up my own Access query to try and achieve the
desired outcome ?

Thanks in advance,

Chris Swann




smime.p7s
Description: S/MIME Cryptographic Signature
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2019-01-11 Thread Chris Swann via LegacyUserGroup

Hi Chris,

Thanks for the reply.

I didn't actually do it, honest !! - it was Ancestry when I downloaded 
data ages back and created a new Legacy tree !! The other Census image 
files actually downloaded as  England Census(xxx) and, at least for 
now, are far easier to work with.


Since then my files are in a far better state but I really want to tidy 
up all the "dross" that was present from the original build.


My Access skills, although a little rusty, are pretty good as I have 
written complete and very complex applications for 4 large hospitals in 
the UK as well as being involved on programming, for some time, with a 
commercial aviation database.


Given a schema I'm 99.9% certain I can sort out the appropriate 
codes/queries/whatever to accomplish the task.


C

On 11/01/2019 18:58, Chris Hill wrote:

Hi

    Interesting problem, and my first question is 'why did you do it 
that way?'


All pre-1911 census records can be indexed by the Head of the 
family or by a location & page number (better if there are multiple 
families on the sheet). Individual 1911 census records can be indexed 
by the Head of the family and the summary sheets as before. Equally, 
BMD images must relate to one or more individuals, especially for 
parish records, which can be used to index them which I then extend 
with the date of the event. I have also structured the media folder 
into separate sub-folders by census year, births, marriages, deaths 
etc. which simplifies the file name system.


    However, somehow you need to build a list of the existing images 
and associate them against a list of new names, and then process them.


    How good is your VBA since that will be only way to do it and, 
depending on exactly how you you want to structure the new file names, 
can be built to do it automatically. Yes, it can be done, but you will 
need to work through the tables to identify what you need to find and 
update, and also make the change to the file as well. Alternatively 
you could write an external program to do it.


    It happens that I am a programmer and have worked on Access VBA, 
and I would need several attempts to write something to do it and test 
it out. Of course working on a backup copy until I was 100% happy that 
it was correct and that Legacy still liked it.


    Otherwise, it is the slow 'do it by hand' method. Change the file 
name, open the individual or event and manually re-identify the file - 
the media relinker is pretty well useless at that job if you let it 
try to locate the image, which no longer exists.


Regards

Chris

-- Original Message --
From: "Chris Swann via LegacyUserGroup" 
mailto:legacyusergroup@legacyusers.com>>
To: "Legacy User Group" <mailto:LegacyUserGroup@legacyusers.com>>

Cc: "Chris Swann" mailto:d...@derby99.plus.com>>
Sent: 11/01/2019 18:11:29
Subject: [LegacyUG] Renaming media files


All,
I suspect i already know the answer but.
I have a LOAD of media files that have the name Unknown(xxx), where 
xxx is a number. I have tagged the files (in Windows Explorer) as to 
whether they are 1911 UK census images or UK BMD entries.
What I would like to do is rename, at the very least, the Census 
files to a standard 1911 England Census(xxx) format so that I at 
least have all the Census files in order.
Is there any way to bulk rename the files to replace the Unknown with 
1911 England Census without having to do each one individually ?
Alternatively, does anyone have a schema for the data tables that I 
could use to cook up my own Access query to try and achieve the 
desired outcome ?

Thanks in advance,
Chris Swann




smime.p7s
Description: S/MIME Cryptographic Signature
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2019-01-11 Thread Barry via LegacyUserGroup
Hi Try some free shareware called ‘Advanced Renamer’ for batch renaming etc.

 

From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On 
Behalf Of Chris Hill
Sent: 11 January 2019 18:59
To: Legacy User Group 
Subject: Re: [LegacyUG] Renaming media files

 

Hi

 

Interesting problem, and my first question is 'why did you do it that way?' 

 

All pre-1911 census records can be indexed by the Head of the family or by 
a location & page number (better if there are multiple families on the sheet). 
Individual 1911 census records can be indexed by the Head of the family and the 
summary sheets as before. Equally, BMD images must relate to one or more 
individuals, especially for parish records, which can be used to index them 
which I then extend with the date of the event. I have also structured the 
media folder into separate sub-folders by census year, births, marriages, 
deaths etc. which simplifies the file name system.

 

However, somehow you need to build a list of the existing images and 
associate them against a list of new names, and then process them.

 

How good is your VBA since that will be only way to do it and, depending on 
exactly how you you want to structure the new file names, can be built to do it 
automatically. Yes, it can be done, but you will need to work through the 
tables to identify what you need to find and update, and also make the change 
to the file as well. Alternatively you could write an external program to do it.

 

It happens that I am a programmer and have worked on Access VBA, and I 
would need several attempts to write something to do it and test it out. Of 
course working on a backup copy until I was 100% happy that it was correct and 
that Legacy still liked it.

 

Otherwise, it is the slow 'do it by hand' method. Change the file name, 
open the individual or event and manually re-identify the file - the media 
relinker is pretty well useless at that job if you let it try to locate the 
image, which no longer exists.

 

Regards

 

Chris

 

-- Original Message --

From: "Chris Swann via LegacyUserGroup" mailto:legacyusergroup@legacyusers.com> >

To: "Legacy User Group" mailto:LegacyUserGroup@legacyusers.com> >

Cc: "Chris Swann" mailto:d...@derby99.plus.com> >

Sent: 11/01/2019 18:11:29

Subject: [LegacyUG] Renaming media files

 

All,

 

I suspect i already know the answer but.

 

I have a LOAD of media files that have the name Unknown(xxx), where xxx is a 
number. I have tagged the files (in Windows Explorer) as to whether they are 
1911 UK census images or UK BMD entries.

 

What I would like to do is rename, at the very least, the Census files to a 
standard 1911 England Census(xxx) format so that I at least have all the Census 
files in order.

 

Is there any way to bulk rename the files to replace the Unknown with 1911 
England Census without having to do each one individually ?

 

Alternatively, does anyone have a schema for the data tables that I could use 
to cook up my own Access query to try and achieve the desired outcome ?

 

Thanks in advance,

 

Chris Swann

 

 

 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2019-01-11 Thread Chris Hill

Hi

Interesting problem, and my first question is 'why did you do it 
that way?'


All pre-1911 census records can be indexed by the Head of the family 
or by a location & page number (better if there are multiple families on 
the sheet). Individual 1911 census records can be indexed by the Head of 
the family and the summary sheets as before. Equally, BMD images must 
relate to one or more individuals, especially for parish records, which 
can be used to index them which I then extend with the date of the 
event. I have also structured the media folder into separate sub-folders 
by census year, births, marriages, deaths etc. which simplifies the file 
name system.


However, somehow you need to build a list of the existing images and 
associate them against a list of new names, and then process them.


How good is your VBA since that will be only way to do it and, 
depending on exactly how you you want to structure the new file names, 
can be built to do it automatically. Yes, it can be done, but you will 
need to work through the tables to identify what you need to find and 
update, and also make the change to the file as well. Alternatively you 
could write an external program to do it.


It happens that I am a programmer and have worked on Access VBA, and 
I would need several attempts to write something to do it and test it 
out. Of course working on a backup copy until I was 100% happy that it 
was correct and that Legacy still liked it.


Otherwise, it is the slow 'do it by hand' method. Change the file 
name, open the individual or event and manually re-identify the file - 
the media relinker is pretty well useless at that job if you let it try 
to locate the image, which no longer exists.


Regards

Chris

-- Original Message --
From: "Chris Swann via LegacyUserGroup" 


To: "Legacy User Group" 
Cc: "Chris Swann" 
Sent: 11/01/2019 18:11:29
Subject: [LegacyUG] Renaming media files


All,

I suspect i already know the answer but.

I have a LOAD of media files that have the name Unknown(xxx), where xxx is a 
number. I have tagged the files (in Windows Explorer) as to whether they are 
1911 UK census images or UK BMD entries.

What I would like to do is rename, at the very least, the Census files to a 
standard 1911 England Census(xxx) format so that I at least have all the Census 
files in order.

Is there any way to bulk rename the files to replace the Unknown with 1911 
England Census without having to do each one individually ?

Alternatively, does anyone have a schema for the data tables that I could use 
to cook up my own Access query to try and achieve the desired outcome ?

Thanks in advance,

Chris Swann


-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


[LegacyUG] Renaming media files

2019-01-11 Thread Chris Swann via LegacyUserGroup

All,

I suspect i already know the answer but.

I have a LOAD of media files that have the name Unknown(xxx), where xxx 
is a number. I have tagged the files (in Windows Explorer) as to whether 
they are 1911 UK census images or UK BMD entries.


What I would like to do is rename, at the very least, the Census files 
to a standard 1911 England Census(xxx) format so that I at least have 
all the Census files in order.


Is there any way to bulk rename the files to replace the Unknown with 
1911 England Census without having to do each one individually ?


Alternatively, does anyone have a schema for the data tables that I 
could use to cook up my own Access query to try and achieve the desired 
outcome ?


Thanks in advance,

Chris Swann





smime.p7s
Description: S/MIME Cryptographic Signature
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2016-08-04 Thread Michele/Support
Mark,

I can’t reproduce this.  I have sent you an email from our ticketing system.

 

Michele

Technical Support

Millennia Corporation

 <mailto:mich...@legacyfamilytree.com> mich...@legacyfamilytree.com

 <http://www.legacyfamilytree.com/> www.legacyfamilytree.com 

 

From: Michele Lewis [mailto:mich...@legacyfamilytree.com] 
Sent: Thursday, August 4, 2016 11:37 AM
To: Legacy User Group <legacyusergroup@legacyusers.com>
Subject: Re: [LegacyUG] Renaming media files

 

Hmm, I need to test it. I will send you an email from our support queue so 
that we can get this logged in.




Michele

Technical Support

Millennia Corporation

 <mailto:mich...@legacyfamilytree.com> mich...@legacyfamilytree.com

 <http://www.legacyfamilytree.com/> www.legacyfamilytree.com 

 

On Thu, Aug 4, 2016 at 10:53 AM, Mark Wilby <mark.wilby1.leg...@gmail.com 
<mailto:mark.wilby1.leg...@gmail.com> > wrote:

Thanks Michele but if i use that method and then run the re linker I get broken 
media links

Media File: Marriage: Source Detail: Edmund Hare [97] and Ann Howard [101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Media File: Name: Source Detail: Ann HOWARD [101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Marriage Media File: Edmund Hare [97] and Ann Howard [101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Media File: Marriage Event: Source Detail: Edmund Hare [97] and Ann Howard [101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Marriage Event Media File: Witness to Marriage: Edmund Hare [97] and Ann Howard 
[101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Media File: Research Notes: Source Detail: Edmund HARE [97]

 

On Thu, Aug 4, 2016 at 3:21 PM Michele/Support <mich...@legacyfamilytree.com 
<mailto:mich...@legacyfamilytree.com> > wrote:

Photos attached to the Master Sources and Citation Detail screens will appear 
in the Picture Center and you can rename them there without losing your link. 
When you open the Picture Center, in the center top you will see a BROWSE 
button.  All you have to do is navigate to where the picture is located.

 

Michele

Technical Support

Millennia Corporation

mich...@legacyfamilytree.com <mailto:mich...@legacyfamilytree.com> 

www.legacyfamilytree.com <http://www.legacyfamilytree.com/>  

 

From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com 
<mailto:legacyusergroup-boun...@legacyusers.com> ] On Behalf Of Mark Wilby
Sent: Thursday, August 4, 2016 10:12 AM
To: LegacyUserGroup@legacyusers.com <mailto:LegacyUserGroup@legacyusers.com> 
Subject: [LegacyUG] Renaming media files

 

Hi guys

Hope this question isn't too simple. I can use the picture center to rename 
attached media file names used by events or individuals but if that file is 
used by a source the file is lost until I re link it. Is there a way to 
universally rename a file so source media links are renamed as well. 

--

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com <mailto:LegacyUserGroup@legacyusers.com> 
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


--

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com <mailto:LegacyUserGroup@legacyusers.com> 
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/

 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2016-08-04 Thread Michele Lewis
Hmm, I need to test it. I will send you an email from our support queue
so that we can get this logged in.

Michele
Tech Support
Legacy Family Tree
mich...@legacyfamilytree.com <br...@legacyfamilytree.com>
http://www.LegacyFamilyTree.com <http://www.legacyfamilytree.com/>

On Thu, Aug 4, 2016 at 10:53 AM, Mark Wilby <mark.wilby1.leg...@gmail.com>
wrote:

> Thanks Michele but if i use that method and then run the re linker I get
> broken media links
>
> Media File: Marriage: Source Detail: Edmund Hare [97] and Ann Howard [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Media File: Name: Source Detail: Ann HOWARD [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Marriage Media File: Edmund Hare [97] and Ann Howard [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Media File: Marriage Event: Source Detail: Edmund Hare [97] and Ann Howard
> [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Marriage Event Media File: Witness to Marriage: Edmund Hare [97] and Ann
> Howard [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Media File: Research Notes: Source Detail: Edmund HARE [97]
>
>
> On Thu, Aug 4, 2016 at 3:21 PM Michele/Support <
> mich...@legacyfamilytree.com> wrote:
>
>> Photos attached to the Master Sources and Citation Detail screens will
>> appear in the Picture Center and you can rename them there without losing
>> your link. When you open the Picture Center, in the center top you will see
>> a BROWSE button.  All you have to do is navigate to where the picture is
>> located.
>>
>>
>>
>> Michele
>>
>> Technical Support
>>
>> Millennia Corporation
>>
>> mich...@legacyfamilytree.com
>>
>> www.legacyfamilytree.com
>>
>>
>>
>> *From:* LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] *On
>> Behalf Of *Mark Wilby
>> *Sent:* Thursday, August 4, 2016 10:12 AM
>> *To:* LegacyUserGroup@legacyusers.com
>> *Subject:* [LegacyUG] Renaming media files
>>
>>
>>
>> Hi guys
>>
>> Hope this question isn't too simple. I can use the picture center to
>> rename attached media file names used by events or individuals but if that
>> file is used by a source the file is lost until I re link it. Is there a
>> way to universally rename a file so source media links are renamed as well.
>> --
>>
>> LegacyUserGroup mailing list
>> LegacyUserGroup@legacyusers.com
>> To manage your subscription and unsubscribe http://legacyusers.com/
>> mailman/listinfo/legacyusergroup_legacyusers.com
>> Archives at:
>> http://www.mail-archive.com/legacyusergroup@legacyusers.com/
>>
>
> --
>
> LegacyUserGroup mailing list
> LegacyUserGroup@legacyusers.com
> To manage your subscription and unsubscribe http://legacyusers.com/
> mailman/listinfo/legacyusergroup_legacyusers.com
> Archives at:
> http://www.mail-archive.com/legacyusergroup@legacyusers.com/
>
>
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2016-08-04 Thread Pat Hickin
Just as a matter of curiosity, why is the dob not shown on the names in the
Picture Center?  If you have ten names that are all the same, you have to
look at each name separately and choose the right one based on the names of
the parents.  Makes little sense to me.

Pat

On Thu, Aug 4, 2016 at 10:20 AM, Michele/Support <
mich...@legacyfamilytree.com> wrote:

> Photos attached to the Master Sources and Citation Detail screens will
> appear in the Picture Center and you can rename them there without losing
> your link. When you open the Picture Center, in the center top you will see
> a BROWSE button.  All you have to do is navigate to where the picture is
> located.
>
>
>
> Michele
>
> Technical Support
>
> Millennia Corporation
>
> mich...@legacyfamilytree.com
>
> www.legacyfamilytree.com
>
>
>
> *From:* LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] *On
> Behalf Of *Mark Wilby
> *Sent:* Thursday, August 4, 2016 10:12 AM
> *To:* LegacyUserGroup@legacyusers.com
> *Subject:* [LegacyUG] Renaming media files
>
>
>
> Hi guys
>
> Hope this question isn't too simple. I can use the picture center to
> rename attached media file names used by events or individuals but if that
> file is used by a source the file is lost until I re link it. Is there a
> way to universally rename a file so source media links are renamed as well.
>
> --
>
> LegacyUserGroup mailing list
> LegacyUserGroup@legacyusers.com
> To manage your subscription and unsubscribe http://legacyusers.com/
> mailman/listinfo/legacyusergroup_legacyusers.com
> Archives at:
> http://www.mail-archive.com/legacyusergroup@legacyusers.com/
>
>
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2016-08-04 Thread Shirley Crampton
Thank you, thank you Michele
I have been removing media and reentering it because I did not like my
original file names.  This will save a *lot* of work.

On Thu, Aug 4, 2016 at 10:53 AM, Mark Wilby <mark.wilby1.leg...@gmail.com>
wrote:

> Thanks Michele but if i use that method and then run the re linker I get
> broken media links
>
> Media File: Marriage: Source Detail: Edmund Hare [97] and Ann Howard [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Media File: Name: Source Detail: Ann HOWARD [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Marriage Media File: Edmund Hare [97] and Ann Howard [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Media File: Marriage Event: Source Detail: Edmund Hare [97] and Ann Howard
> [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Marriage Event Media File: Witness to Marriage: Edmund Hare [97] and Ann
> Howard [101]
>C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
> Media File: Research Notes: Source Detail: Edmund HARE [97]
>
>
> On Thu, Aug 4, 2016 at 3:21 PM Michele/Support <
> mich...@legacyfamilytree.com> wrote:
>
>> Photos attached to the Master Sources and Citation Detail screens will
>> appear in the Picture Center and you can rename them there without losing
>> your link. When you open the Picture Center, in the center top you will see
>> a BROWSE button.  All you have to do is navigate to where the picture is
>> located.
>>
>>
>>
>> Michele
>>
>> Technical Support
>>
>> Millennia Corporation
>>
>> mich...@legacyfamilytree.com
>>
>> www.legacyfamilytree.com
>>
>>
>>
>> *From:* LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] *On
>> Behalf Of *Mark Wilby
>> *Sent:* Thursday, August 4, 2016 10:12 AM
>> *To:* LegacyUserGroup@legacyusers.com
>> *Subject:* [LegacyUG] Renaming media files
>>
>>
>>
>> Hi guys
>>
>> Hope this question isn't too simple. I can use the picture center to
>> rename attached media file names used by events or individuals but if that
>> file is used by a source the file is lost until I re link it. Is there a
>> way to universally rename a file so source media links are renamed as well.
>> --
>>
>> LegacyUserGroup mailing list
>> LegacyUserGroup@legacyusers.com
>> To manage your subscription and unsubscribe
>> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
>> Archives at:
>> http://www.mail-archive.com/legacyusergroup@legacyusers.com/
>>
>
> --
>
> LegacyUserGroup mailing list
> LegacyUserGroup@legacyusers.com
> To manage your subscription and unsubscribe
> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
> Archives at:
> http://www.mail-archive.com/legacyusergroup@legacyusers.com/
>
>
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2016-08-04 Thread Mark Wilby
Thanks Michele but if i use that method and then run the re linker I get
broken media links

Media File: Marriage: Source Detail: Edmund Hare [97] and Ann Howard [101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Media File: Name: Source Detail: Ann HOWARD [101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Marriage Media File: Edmund Hare [97] and Ann Howard [101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Media File: Marriage Event: Source Detail: Edmund Hare [97] and Ann Howard
[101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Marriage Event Media File: Witness to Marriage: Edmund Hare [97] and Ann
Howard [101]
   C:\Legacy Files\Family Names\Hare\Edmund Hare Marriage 1817.jpg
Media File: Research Notes: Source Detail: Edmund HARE [97]


On Thu, Aug 4, 2016 at 3:21 PM Michele/Support <mich...@legacyfamilytree.com>
wrote:

> Photos attached to the Master Sources and Citation Detail screens will
> appear in the Picture Center and you can rename them there without losing
> your link. When you open the Picture Center, in the center top you will see
> a BROWSE button.  All you have to do is navigate to where the picture is
> located.
>
>
>
> Michele
>
> Technical Support
>
> Millennia Corporation
>
> mich...@legacyfamilytree.com
>
> www.legacyfamilytree.com
>
>
>
> *From:* LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] *On
> Behalf Of *Mark Wilby
> *Sent:* Thursday, August 4, 2016 10:12 AM
> *To:* LegacyUserGroup@legacyusers.com
> *Subject:* [LegacyUG] Renaming media files
>
>
>
> Hi guys
>
> Hope this question isn't too simple. I can use the picture center to
> rename attached media file names used by events or individuals but if that
> file is used by a source the file is lost until I re link it. Is there a
> way to universally rename a file so source media links are renamed as well.
> --
>
> LegacyUserGroup mailing list
> LegacyUserGroup@legacyusers.com
> To manage your subscription and unsubscribe
> http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
> Archives at:
> http://www.mail-archive.com/legacyusergroup@legacyusers.com/
>
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


Re: [LegacyUG] Renaming media files

2016-08-04 Thread Michele/Support
Photos attached to the Master Sources and Citation Detail screens will appear 
in the Picture Center and you can rename them there without losing your link. 
When you open the Picture Center, in the center top you will see a BROWSE 
button.  All you have to do is navigate to where the picture is located.

 

Michele

Technical Support

Millennia Corporation

mich...@legacyfamilytree.com <mailto:mich...@legacyfamilytree.com> 

www.legacyfamilytree.com <http://www.legacyfamilytree.com/>  

 

From: LegacyUserGroup [mailto:legacyusergroup-boun...@legacyusers.com] On 
Behalf Of Mark Wilby
Sent: Thursday, August 4, 2016 10:12 AM
To: LegacyUserGroup@legacyusers.com
Subject: [LegacyUG] Renaming media files

 

Hi guys

Hope this question isn't too simple. I can use the picture center to rename 
attached media file names used by events or individuals but if that file is 
used by a source the file is lost until I re link it. Is there a way to 
universally rename a file so source media links are renamed as well. 

-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/


[LegacyUG] Renaming media files

2016-08-04 Thread Mark Wilby
Hi guys
Hope this question isn't too simple. I can use the picture center to rename
attached media file names used by events or individuals but if that file is
used by a source the file is lost until I re link it. Is there a way to
universally rename a file so source media links are renamed as well.
-- 

LegacyUserGroup mailing list
LegacyUserGroup@legacyusers.com
To manage your subscription and unsubscribe 
http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com
Archives at:
http://www.mail-archive.com/legacyusergroup@legacyusers.com/