Affinity Publisher Customer Beta - 1.9.0.843 - Database merge issue

[leminilab]

Hi,

Very excited by the data merge function!
While testing it (I'm a PC user) I realized the xslx document I linked is only read up until line 105 out of 180.

Is there anything I can try to solve this out?
Thanks for your help!

[Patrick Connor]

@leminilab

Please can you create a new thread and supply your xlsx or ask for an upload link if it contains sensitive information

[leminilab]

Hi,
I found the culprit: my first column was not always filled. Publisher stopped when it met an empty cell at row 105. It didn't stop at row 4 which was also emtpy though...
Thanks for your help!

[Patrick Connor]

That's not ideal, perhaps it could handle this case better. Thanks for letting us know

[leminilab]

Hopefully you can replicate this without my file which is quite sensitive for me...🤔
If not, I can still find a way to erase the sensitive infos prior to sending it... Just let me know if you need the file!

Thanks for your help and have a nice day! 😀

[Jon P]

@leminilab

I've just split this into it's own thread so we don't clutter the beta release thread.

I'd be intrigued to see the file just to check if this is expected, could you upload it here please?

Thanks

[leminilab]

Done! I erased the sensitive infos but the problem remains: only the first 105 rows are taken into account. Hope that helps!

[leminilab]

I also observed that cell formatting from column C is not maintained.

[Jon P]

Quote

I found the culprit: my first column was not always filled.

This was actually the cause of the other issue too, a fair few rows in that file start with no data in the first column, apart from the first one all have been missed on import. I've passed this on to development.

Quote

I also observed that cell formatting from column C is not maintained.

The spaces do seem to have been missed, I've also passed this on.

Thanks for the reports!