Skip to main content
S
suryap6328
April 12, 2023
Question

Export Data Store Entity to CSV doesn't export all records

  • April 12, 2023
  • 7 replies
  • 0 views

I have a view with 11017 records and I'm trying to export this data to csv via Export Data Store Entity to CSV smart service. The issue is that it exports only 11015 records and the file size is around 200KB

    7 replies

    stefanhelzle0001
    stefanhelzle0001
    April 12, 2023

    Without any details, it is impossible to suggest anything.

    S
    suryap6328Author
    April 12, 2023

    The view actually has 53 columns but I'm querying only 3 columns. After applying the filter I can see 11017 records in the view and 11015 records are extracted to CSV

    S
    shuaibs6722
    April 12, 2023

    Are you sure there are no filters applied?

    S
    suryap6328Author
    April 12, 2023

    After applying a filter I'm receiving 11015 records in CSV and 11017 records in the view.

    K
    karinav0003
    April 12, 2023

    does your view have a primary key? I would suggest checking the view, this might be causing the issue. You can find more suggestions here:

    https://docs.appian.com/suite/help/23.1/Export_To_CSV_Smart_Service.html#avoiding-query-timeouts-when-exporting-data 

      S
      suryap6328Author
      April 12, 2023

      No, my view doesn't have a primary key. So I did try assigning the primary key but interestingly the smart service started exporting more than 173430+ records and throws an error while the view has only 11017 records.

      S
      suryap6328Author
      April 13, 2023

      I used row_number() as the primary key which for some reason generated 173430+ records. So instead I have used 2 ID columns from the table to create a primary key in the view and that solved the problem

      Terms & ConditionsAccessibility statement