Jump to content
Our response time is longer than usual currently. We're working to answer users as quickly as possible and thank you for your continued patience.

Data Merge(V2) pulling wrong field


Recommended Posts

I just installed V2 today and was alarmed when the fields displayed in my output were incorrect. I thought something had changed in my data file. However, when I checked, everything was fine. Ran the V1 file that I had backed up (fortunately) and it pulled the correct data field from the XLSX file.

I've attached what the source file looks like, the starting point and results for both V1 and V2 using the same Excel file.

 

Jerome

 

Publisher_V2_Data_Merge_Error.jpg

Link to comment
Share on other sites

Hi, @Jerome W,
In order to be able to reproduce the phenomenon, could you provide an AFPUB file and the corresponding XLSX file that shows this malfunction?

6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity  Publisher, Affinity Designer, Affinity Photo).

Mais je vous le demande, peut-on imaginer une police sans sérifs ?

Link to comment
Share on other sites

Thanks for the feedback. I checked the columns for untitled columns and blanks, didn't find any. I simplified the excel file to keep just 1 record, remove every other worksheet (had no issues with another V2 file where the datasource only included one worksheet), replace formulas with values, and removed additional fields. I also reduced the .afpub file to just 2 layouts (4 pages) and am getting the same results.

I've attached both the .afpub and .xlsx file (columns not read properly highlighted in red). 

Thanks.  

Jerome

Weekly Planner - Horizontal - 1 Pg - A5_simplfied.afpub DigitalPlanner_Data.xlsx

Link to comment
Share on other sites

24 minutes ago, Jerome W said:

Interesting. I've removed and reinstalled Publisher thinking that might fix it, but I'm still having the problem. Luckily, I still have Publisher v1.05 installed. I'm running a PC with Windows 11.

I tried also in  MacOS and it works. v2 and v2-beta

Could you try to use atached  files for datamerge?

DigitalPlanner_Data2.xlsx DigitalPlanner_Data3.csv

Link to comment
Share on other sites

Interesting. The .xlsx file had the same issue, but the .csv file worked as expected. I'm going to try installing Publisher on an older computer to see what happens. I switched from InDesign to Publisher to get away from having to export .csv files (among other issues). I may have to go back to exporting CSV files (at least on this computer☹️).

 

Jerome

Link to comment
Share on other sites

I did some more testing. If I use anything other than custom formatting in the Excel file to display the date, the file works fine. I tried putting letters, unformatted dates and date formulas in the Excel file and they all worked fine. Looks like I'll have to use the "=TEXT(date,"D")  formula rather than custom formatting in Excel to display the days. Weird that it works for other people (and in Publisher V1). I wonder if there's some hidden parameter that effects how Publisher reads from Excel.

 

Jerome 

Link to comment
Share on other sites

The behaviour seems normal on my computer on both Windows 10 and Windows 11, and everything appears to be correct.

6 cœurs, 12 processus - Windows 11 pro - 4K - DirectX 12 - Suite universelle Affinity (Affinity  Publisher, Affinity Designer, Affinity Photo).

Mais je vous le demande, peut-on imaginer une police sans sérifs ?

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...

Important Information

Please note there is currently a delay in replying to some post. See pinned thread in the Questions forum. These are the Terms of Use you will be asked to agree to if you join the forum. | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.