PDF-XChange - Tracker PDF Viewer - TIFF-XChange - Image-XChange - XMF-XChange - Raster-XChange - Support

Moderators: Tracker Support, Chris - Tracker Supp, Vasyl-Tracker Dev Team, Tracker Supp-Stefan

 
rsm norge as
User
Topic Author
Posts: 6
Joined: Thu Nov 05, 2015 7:09 am

Export to Excel

Mon Oct 09, 2017 8:37 am

We are considering PDF Tools for all our employees, but cannot get the PDF exported to Excel in any useable format. All records end up on one very long line.

We are using Norwegian Office 2013 with regional settings set to Norwegian.

Bjørn Chr. Borgen
RSM Norge AS
 
rsm norge as
User
Topic Author
Posts: 6
Joined: Thu Nov 05, 2015 7:09 am

Re: Export to Excel

Mon Oct 09, 2017 12:09 pm

Another issue is that every page in the PDF file ends up as a separate sheet in the Excel file. It would have been very useful to have a choice/option to have all pages in one sheet. When we tested the PDF export to Excel our 30 page PDF ended up as an Excel file with 30 separate sheets.
 
User avatar
Tracker Supp-Stefan
Site Admin
Posts: 11659
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Export to Excel

Mon Oct 09, 2017 12:49 pm

Hello rsm norge as,

I am afraid that currently there's no way to control the export - and each page of the file will end up as a separate sheet in Excel.
As for the information itself - can we get a sample of an original PDF page and the resulting excel file (zip/rar them before attaching)?

Regards,
Stefan
 
rsm norge as
User
Topic Author
Posts: 6
Joined: Thu Nov 05, 2015 7:09 am

Re: Export to Excel

Mon Oct 09, 2017 12:55 pm

I tried to find a way to upload sample files but could not find any way to do it. How can I send you these files?
Regards BCB @ RSM
 
User avatar
Tracker Supp-Stefan
Site Admin
Posts: 11659
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Export to Excel

Mon Oct 09, 2017 1:05 pm

Hello rsm norge as,

When you are in the reply page - click the button highlighted on the image below:
attachment.png

The file types accepted are PDF and archives (zip/rar/7z) - so make sure to archive the excel document first.

Regards,
Stefan
 
rsm norge as
User
Topic Author
Posts: 6
Joined: Thu Nov 05, 2015 7:09 am

Re: Export to Excel

Mon Oct 09, 2017 1:12 pm

Sorry. Didn't see the Attachements part... Files attached
Attachments
PDF-XChange Tools-Excel From PDF.PDF
Excel file-This must be renamed to XLSX
(7.34 KiB) Downloaded 15 times
PDF-XChange Tools.pdf
(21.58 KiB) Downloaded 17 times
 
rsm norge as
User
Topic Author
Posts: 6
Joined: Thu Nov 05, 2015 7:09 am

Re: Export to Excel

Tue Oct 17, 2017 8:14 am

Hello,

Any news on this? We would really like to know if there is something we can do in the software in order to have the export to Excel work as expected.

Thanks
 
User avatar
Tracker Supp-Stefan
Site Admin
Posts: 11659
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Export to Excel

Tue Oct 17, 2017 1:13 pm

Hello rsm norge as,

I have manadeg to reproduce your issue, and was awaiting some feedback from our devs.
It seems like this will need extra time to be investigated - so I've made a ticket in our system:
#4065: Editor 322.7: Export to excel formatting issue.
To allow us to look at this in detail - and we will post back again here as soon as we have any additional info.

Regards,
Stefan
 
jasmyndube
User
Posts: 1
Joined: Fri Oct 27, 2017 8:24 am
Contact:

Re: Export to Excel

Fri Oct 27, 2017 11:13 am

I tried to find a way to upload sample files but could not find any way to do it.
 
User avatar
Tracker Supp-Stefan
Site Admin
Posts: 11659
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Export to Excel

Fri Oct 27, 2017 11:27 am

Hello jasmyndube,

Welcome to our forums.
You can attached .pdf or archive files only, and there's a 5MB limit, so if your file is an excel document - archive it first (.zip/.rar/.7z) - and then you will be able to upload it to your post. If it's larger than 5MB - upload it somewhere else and share the link in your post, and we will be happy to take a look.

Regards,
Stefan
 
rsm norge as
User
Topic Author
Posts: 6
Joined: Thu Nov 05, 2015 7:09 am

Re: Export to Excel

Mon Nov 13, 2017 9:15 am

Tracker Supp-Stefan wrote:
Hello rsm norge as,

I have manadeg to reproduce your issue, and was awaiting some feedback from our devs.
It seems like this will need extra time to be investigated - so I've made a ticket in our system:
#4065: Editor 322.7: Export to excel formatting issue.
To allow us to look at this in detail - and we will post back again here as soon as we have any additional info.

Regards,
Stefan


Any news on this matter? Do you have any idea as of when this will be looked into?
Thanks :-)
 
User avatar
Tracker Supp-Stefan
Site Admin
Posts: 11659
Joined: Mon Jan 12, 2009 8:07 am
Location: London
Contact:

Re: Export to Excel

Mon Nov 13, 2017 11:49 am

Hello rsm norge as,

I see the ticket has been assigned to a developer, and work item assigned for the issue - so it will be worked on, however looking at the info available - it seems the issue is with detecting that there is table contents in the original file, so we are working on the logic for that. At the moment I can't give an estimate how long it will take us to develop this feature, but as soon as there is further info in the ticket - we will let you know!

Regards,
Stefan

Who is online

Users browsing this forum: No registered users and 1 guest