Hi all,
I'm migrating an old c company to a new database,
Is it possible to import old history(posted purchase/sales invoices), with the attachments that they were originally posted with
Thanks
Hi all,
I'm migrating an old c company to a new database,
Is it possible to import old history(posted purchase/sales invoices), with the attachments that they were originally posted with
Thanks
Had a similar circumstance with a client wanting to move notes from NAV to BC SaaS. This required development to achieve. I’d suggest the same here
Thanks, I have been trying all sorts, but gathering from what you say, this is not as standard, it would need some dev work to make this possible?
Attachments are stored in blob fields and are therefore binary data. If the configuration package idea is to work you’d need to avoid excel. Export the package so you have a rapid start file. Data dependency will be on the posted data so post some before trying to apply the data in a new company.
I think an approach similar to the item image import would be needed - just in reverse. This would be custom though.
Try searching for "attachment" tables in your configuration package. Add them to your config pack, export them and then check if you see any relevant data to your "test" attachment. Then try importing to your new database.
Thanks, this company is moving to a new tenant, so copy company wont work, it has to be from scratch using config templates, I can't see how I could include original attachments
I don't know for sure but when copying a company, the attachments do remain intact so I would expect them to be included with your database migration The only way to know for sure is to test it. As an aside, Notes do not make it over when copying a company.