Advanced Export FeaturesSolved

I would like the ability to Export more options. I am one of those guys that upload bulk serial numbers to my shopping cart to send to the customer.

The problem is that when I use the export command, I only want to export FREE serials that are not used. There is no way to do that from the web. Even in the Advanced Search, it doesn't allow me to export those Advanced Search Results.

Please add the following web export features:1. After doing an Advanced Search, allow me to export those serials2. When doing an export, allow the export all of the fields: (Product Key, Email, Activations).

1. After doing an Advanced Search, allow me to export those serials

OK, we'll add this.

2. When doing an export, allow the export all of the fields: (Product Key, Email, Activations).

Would a CSV export work for you?

CSV or XLS format would be grate 😀

Also, I want the ability to search for part of the email or name. For example if I search for say E-mail address, I have to get the E-mail address perfect before it will find it.

Would something like an asterisk character work for you? That is...

*@example.com

would find all emails sent from the "example.com" domain name. Or...

john*

would find all emails that start with "john".

We've added the ability to search emails using the * character as a wildcard character. You can only use it in the "advanced search" box. The "Quick find" box requires either an exact match of the email or an exact match of the product key.

We'll be adding the ability for different export types soon.

Ok thanks....Waiting for it...Need it.

Hi,DId this ever get done? I would really like to export my email addresses, I don't want to have to code to the web API to do it!thanks,Matt

Hey Matt,

No, the LimeLM interface for exporting data other than the product keys hasn't been written yet. It's been low priority because (a) the web API can already export all the data from your account and (b) because there have been other features that benefit a greater number of users.

That being said, this *is* on our short list of things to get done. I don't have a hard date for you.

Thanks Sam - a bit disappointing, given this request is over a year old, but hey. I'm guessing it would be all of 20 minutes work?

I'm guessing it would be all of 20 minutes work?

I wish it only took 20 minutes. No, it's more like 2 to 5 days of work. Not a huge task, but not insignificant either.

Is there some reason that none of the export options include the number of deactivations? This is a crucial statistic for me.

Wow, this is an old topic that we should've updated when we actually added the features requested in it.

Just a note for future readers: yes, we have the ability to export in XML, CVS, and text formats. And yes, you can filter exactly which keys and what data to export.

>> "Is there some reason that none of the export options include the number of deactivations?"

We just haven't added it to the output. We'll add it to the list of things to do. However, this information is readily available in the web API functions as the "total_deacts" and "deac_limit" in the following functions:

https://wyday.com/limelm/help/api/limelm.pkey.getDetails/https://wyday.com/limelm/help/api/limelm.pkey.activity/https://wyday.com/limelm/help/api/limelm.pkey.advancedSearch/

Any of which seem like a better fit than manually exporting all the data in your account to get a value that by its very nature changes often. In other words, even when we do add this to the export functionality in LimeLM, you'll still be better off using web API for this particular data.

"Any of which seem like a better fit than manually exporting all the data in your account to get a value that by its very nature changes often. In other words, even when we do add this to the export functionality in LimeLM, you'll still be better off using web API for this particular data."

Yes, the values change often. But this is true no matter what.

Exporting a CSV and sorting it in Excel would take about 30 seconds. Using the web API to build an equivalently-formatted, easily sortable table of results would surely take an order of magnitude longer.