Maximum data export (Shortcode)

  • emir94

    (@emir94)


    9 years, 1 month ago

    Hi Michael,

    We are using the export shortcode for data, which will increase a lot over a year (we’re talking around 1 million entries).

    Would this cause any issues or will the plugin break if a million entries were exported using the shortcode?

    Thanks,
    Emir Kobaslic

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Michael Simpson

    (@msimpson)

    9 years, 1 month ago

    when pulling data out of the DB, it could get slow. Exports & shortcodes that pull a lot of data could cause the server to run out of memory during that call making it limit how much data is returned (but you should be able to increase your server memory). But it will keep collecting the submissions with no problem.

    Thread Starter emir94

    (@emir94)

    9 years, 1 month ago

    Hi Michaell,

    Thanks for your reply.

    We’re running the website on our own server. I have it set to 256MB at the moment. Is this sufficient or would you recommend even more?

    Just another question:

    Is there a way to display the name of the person that has submitted the highest number of specific values (selected from a dropdown in CF7). The dropdown has a number of options of which “Inbound Scheduled”, “Outbound Scheduled” and “Rescheduled” are only counted as targets for the employees. We want to be able to show management who is the person that has the highest number of targets.

    Would you be able to help me with this, please?

    I appreciate your support,
    Emir Kobaslic

    Plugin Author Michael Simpson

    (@msimpson)

    9 years, 1 month ago

    Q1:
    If you are talking a million entries, you might need more memory. It depends on #rows times #columns times how much data in each field.

    Q2:
    If a person is logged in when he submits a form, then his login name is captured in the “Submitted Login” field.

    We can use CountField to count like below:

    [cfdb-table form="YOUR-FORM" show="user,Submitted Login" trans="user=strval(Submitted Login)&&CountField(Submitted Login,user)&&SortByField(Submitted Login,DESC)" headers="Submitted Login=count"]

    add limit=”1″ to get just the top scorer.

    In Trans:
    – user=strval(Submitted Login) I create a copy of what is in “Submitted Login” as a new column “user”. Because I need two different column names in CountField (probably I should fix that code)
    – CountField(Submitted Login,user) Counts the entries for each user. The count ends up in Submitted Login field.
    https://cfdbplugin.com/?page_id=1167
    – SortByField sorts by the count, descending so largest first
    – “show” orders the columns
    – “headers” renames “Submitted Login” to “count” to be less confusing

    Thread Starter emir94

    (@emir94)

    9 years, 1 month ago

    Hi Michael,

    Thanks for your reply.

    Is there anyway I can use “submit_time>today” as we only want results for today and also to be able to count certain values?

    For example, this is what we have in our code, but it isn’t working:

    [cfdb-table form="Schedule Tracker" filter="submit_time>today&&outcome!=Voicemail&&outcome!=ETA Query&&outcome!=Hung Up" show="user,Submitted Login" trans="user=strval(Submitted Login)&&CountField(Submitted Login,user)&&SortByField(Submitted Login,DESC)" headers="Submitted Login=count"]

    This is just saying that there are no entries.

    Thanks,
    Emir Kobaslic

    Plugin Author Michael Simpson

    (@msimpson)

    9 years, 1 month ago

    I would expect that to work. If the filter is just filter="submit_time>today" do you get results from today?

    Thread Starter emir94

    (@emir94)

    9 years, 1 month ago

    No, I don’t. As soon as I add filter="submit_time>today", I just the columns “user” and “count” with no data. When I remove it, I get the accurate number.

    Could you please help with this?

    Thanks,
    Emir Kobsaslic

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Maximum data export (Shortcode)’ is closed to new replies.