Dear all
I am currently evaluating Devart's excel addin with Freshdesk
So far I encountered 2 issues:
- when trying to import tickets data I got an OutOfMemory error (ticket was raised with Devart's support); For now I worked around the issue by discarding some of the big fields
- the other issue I face when trying to import the TimeEntry data. For an unknown reason, it only brings me 13 rows (even in preview, regardless on how many rows I indicate) Any idea ahy?
Using excel addin with FreshDesk
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Using excel addin with FreshDesk
Looks like the data being read are bigger than all the available memory on the computer. In this case you cannot read all data._jE wrote:- when trying to import tickets data I got an OutOfMemory error (ticket was raised with Devart's support);
If you want just to get the data to, you can use Devart's Skyvia tool for exporting tickets to CSV file.
You can create an export package in the following way:
1. Go to https://skyvia.com/ and register for free.
2. Create a Freshdesk connection on the Connections page. For more information, please refer to https://skyvia.com/resources/docs/index ... shdesk.htm
3. Go to the Integration page and create a new Export package.
4. Under Source click Select and select Freshdesk, then select your Freshdesk connection in the drop-down list below.
5. Click the "Add task" button.
6. In the drop-down list select Ticket;
7. After you selected Leads, select a check box near the name of this entity. This selects all columns for export.
8. Click Save, and the task will be created.
9. Click Save in the package editor, and the package will be created.
10. Click Run, and package will be executed.
11. When execution is complete you will see results in the Run History pane.
12. The number of exported rows for an entity is a link. Click it to download the result CSV file.
We could not reproduce the issue. We create a 20 time entries, and all 20 items are selected by Excel. Could you please describe how exactly you indicate the number of rows which should be selected?_jE wrote:- the other issue I face when trying to import the TimeEntry data. For an unknown reason, it only brings me 13 rows (even in preview, regardless on how many rows I indicate) Any idea ahy?
Re: Using excel addin with FreshDesk
Hi
the first issue was solved meanwhile, I discarded 2 fields (Description and DescriptionHTML) and now it works properly.
The second one is still pending. Please provide an email where I can send you printscreens with steps taken.
Cheers,
the first issue was solved meanwhile, I discarded 2 fields (Description and DescriptionHTML) and now it works properly.
The second one is still pending. Please provide an email where I can send you printscreens with steps taken.
Cheers,
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Using excel addin with FreshDesk
You can send the sceenshots to support at devart dot com or via our contact form.
Re: Using excel addin with FreshDesk
Thanks, Pinturiccio
Mail sent.
Cheers,
Mail sent.
Cheers,
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Using excel addin with FreshDesk
We have answered you via e-mail.