Trimble Business Center

 View Only
Back to discussions
Expand all | Collapse all

can't import csv

  • 1.  can't import csv

    Posted 09-24-2023 15:51

    All of  sudden csv files don't want to import.  Even if I export one it will not import back in.  "Suitable importer could not be found."  Where did it go?



    ------------------------------
    Mark Turrin
    ------------------------------


  • 2.  RE: can't import csv

    Posted 09-24-2023 19:22

    while in the import command. did you right click on the file before import to choose the CSV file type? 



    ------------------------------
    Francisco Guerrero
    ------------------------------

    Original Message


  • 3.  RE: can't import csv

    Posted 09-24-2023 19:47

    Normally I just drag and drop.  Your suggestion worked for a .TXT I converted from the original file but not that particular CSV.  The weird thing is it does work for other CSV files.  Not sure why the drag and drop function stopped working though.



    ------------------------------
    Mark Turrin
    ------------------------------

    Original Message


  • 4.  RE: can't import csv

    Posted 09-25-2023 07:12

    This has randomly happened to me as well.  I usually just have to restart and make sure you have the right csv type selected. 

     

    Mike Hathaway, PLS | Survey Manager

    Office: 509.505.5551 extension 251 | Direct line: 509.606.1561 | Cell: 509.710.2081  |  E: mhathaway@welchcomer.com | Web: www.welchcomer.com            

     

    This e-mail and any attachments are intended solely for the use of the individual to whom they are addressed. Please visit our website for our confidentiality policy.

     




    Original Message


  • 5.  RE: can't import csv

    Posted 09-25-2023 07:31

    I had this happen awhile back.  Open your import editor and verify that at least 1 CSV option is enabled.  Screen shot below shows P,N,E,elev,Code (Control) enabled.  I accidently unchecked it at one point so TBC wouldn't recognize CSVs.



    ------------------------------
    Jason Smyth
    ------------------------------

    Original Message


  • 6.  RE: can't import csv

    Posted 09-25-2023 07:52

    Mark I recently had this happen to me with a specific file I had received. After looking at the file I found an artifact (trash text) over in one of the columns that was missed in the cleanup of the spreadsheet prior to saving it as a CSV. It gave me the same error, I think it was looking for an importer with an extra column and all of mine are limited to either P, N, E, Z, D or P, N, E, Z, FC since those are the ones I have enabled.



    ------------------------------
    John Woodall
    ------------------------------

    Original Message


  • 7.  RE: can't import csv

    Posted 09-25-2023 13:07

    I completely agree with this suggestion.

    When I had the same issue, the reason for the issue seemed to be opened by Exel. I assume that the CSV file is written some invisible data if it was opened by Exel.

    So you should confirm the CSV file by Notepad or something without Exel, and you should delete everything without  P, N, E, Z, D or P, N, E, Z, FC.



    ------------------------------
    Nao NAKAMURA
    Sitech JAPAN
    ------------------------------

    Original Message