Upload Spreadsheet Large Files Connector - Not uploading all data

Kyle_Russell
Kyle_Russell Member
in Connectors

Hi All,

I have a dataset that I need to update using the Upload Spreadsheet Large Files connector, however when I drop in the new dataset it only seems to import 31,074 rows of data when it should be a couple of hundred thousand. For reference I've tried uploading as a CSV & an excel workbook - does anyone know why this is happening and how to fix?

Thanks

Tagged:

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    In the upload spreadsheet wizard, after you select the file, it should give you a preview and on the left is the range that it determined it should upload. Double check that the range is accurate and make changes to ensure that it is importing all the rows you want.

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓

    In the upload spreadsheet wizard, after you select the file, it should give you a preview and on the left is the range that it determined it should upload. Double check that the range is accurate and make changes to ensure that it is importing all the rows you want.

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Kyle_Russell
    Kyle_Russell Member

    Hi Mark,

    Thanks for the response! I'm not sure I can see the same options?

    DOMO Data Upload.PNG

  • MarkSnodgrass
    MarkSnodgrass Coach

    That screenshot does look different than mine. Try clicking on File rather than searching connectors and drag your file in and see if you get the options that I do. I was using an Excel file (.xlsx) as my example. If yours is a .csv, that could be why you don't see the same options I do.

    image.png

    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Categories