Jump to content
Sign in to follow this  
Murfee

Affinity Publisher Customer Beta - 1.9.0.796 - Data Merge crash

Recommended Posts

Data merge was a very short lived test 😫

Mojave with the latest Numbers 10.1, file exported as .xlsx and crashes Publisher as soon as it is selected in the Data Merge Manager

Share this post


Link to post
Share on other sites
19 minutes ago, Murfee said:

Data merge was a very short lived test

I have just tested it and it works for me.

I had to reset Publisher to make it actually start on my computer.

Regards

Share this post


Link to post
Share on other sites
21 minutes ago, Jon P said:

@Murfee Can you attach the xlsx file?

Thanks

Hi John, I can't upload the original xslx that I tried...too confidential 😀

I have attached a very simple one, this doesn't crash Publisher but the first column with the Months doesn't pull through, it just shows 0000.

The original file I tried was full of formulas that might have got confused during the export to Excel... not the best file to test with 😀

Simple Testing 2 Data Merge for Publisher 1.9.xlsx

 

Share this post


Link to post
Share on other sites

I'll look into that month missing, but I'm keen to reproduce this crash (even if it has formulas or things we don't support, we should never just crash!)

If you use this link to upload the file it will remain confidential and only used internally for testing.


Serif Europe Ltd. - www.serif.com

Share this post


Link to post
Share on other sites
3 minutes ago, Jon P said:

I'll look into that month missing, but I'm keen to reproduce this crash (even if it has formulas or things we don't support, we should never just crash!)

If you use this link to upload the file it will remain confidential and only used internally for testing.

Uploaded, thanks

Share this post


Link to post
Share on other sites
1 hour ago, Murfee said:

Is there a reason that the Mac version can not import Numbers or Pages documents? 

Yes, those are proprietary file formats which are not publicly documented and change from release to release so they would be a moving target of reverse-engineering that is not likely worth Serif's time to unravel.

Share this post


Link to post
Share on other sites

Thanks for the file, I've logged that crash, seems to be caused by the EDATE formula. If I remove those it's fine


Serif Europe Ltd. - www.serif.com

Share this post


Link to post
Share on other sites
Quote

 have attached a very simple one, this doesn't crash Publisher but the first column with the Months doesn't pull through, it just shows 0000.

It's because we don't understand the date formatting used, you get similar behavior if you place it - I'll pass this on


Serif Europe Ltd. - www.serif.com

Share this post


Link to post
Share on other sites
6 hours ago, Jon P said:

Thanks for the file, I've logged that crash, seems to be caused by the EDATE formula. If I remove those it's fine

Thanks Jon, I have been using CSV exported from Numbers and it is working well, I just need to remember to replace the original file when I update anything and all is good. The translation to Excel can be difficult sometimes due to the difference in functions, it should just replace a formula with values but it doesn't always.

Share this post


Link to post
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...
Sign in to follow this  

×
×
  • Create New...

Important Information

Please note the Annual Company Closure section in the Terms of Use. 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.