Creating a data merge spreadsheet

[typeglyph]

I've attempted to create a spreadsheet (numbers converted to CSV) and my stumbling block is file path for images.

My Mac Harddrive is called MacintoshHD and the folder is called Documents2 within is a folder called Jewelry and another folder called images

I've tried: MacintoshHD/Documents2/Jewelry/images but the images do not get linked.

                  MacintoshHD:Documents2/Jewelry/images

Can you help?  What is the correct way to write a file path on MacOS?

A tutorial file on creating a data merge spreadsheet would be fantastic. I'd write one if I could figure out the path problem, first.

I did not find anything in forums & the help video and document is incomplete.

thank you

[wonderings]

Not sure if this will help but most likely it should be something like this

 

MacintoshHD>Users>your username>Documents>

[h_d]

2 hours ago, typeglyph said:

 

 

My Mac Harddrive is called MacintoshHD and the folder is called Documents2 within is a folder called Jewelry and another folder called images

I've tried: MacintoshHD/Documents2/Jewelry/images but the images do not get linked.

                  MacintoshHD:Documents2/Jewelry/images

 

Is your hard drive really called MacintoshHD? The default name is Macintosh HD (with a space), although of course you may have changed it.

And has the folder really been created 'flat' on the hard drive?

In most cases I would expect it to be somewhere like

Macintosh HD/Users/your_user_name/Jewelry/images/

One way of finding out for sure, in Finder, is to click on the folder and then type Cmd-I (the letter, for Get Info). This will bring up a window like this:

I've blurred out my user name. The shows you where the folder is. The path for this folder would be:

Macintosh HD/Users/myusername/Documents/Affinity Stuff/

However, you can make it easier on yourself...

Just place the csv file in the same folder as the images. That way you can just use the file names, including the .jpg (or whatever) name extension, without the full path. I have a test Numbers spreadsheet with dummy data which links to Affinity Designer files in the same folder, like this:

 

The exported .csv is kept in the same folder as the  ".afdesign" files and they link fine into Publisher.

Post back if you need more info.

Cheers,

H

 

 

[Old Bruce]

This is for use if your images are not in the same folder as the CSV file....

While in the Finder if you Control + Click or Right Click on one of your images you can see there is a choice to Copy it. If you hold down the Option Key that choice will change to Copy as Path Name. Then you can paste that whole path into the spreadsheet and change just the names of the indiviual files. Remember to keep the file extensions on the name.