AI Assistant
Notifications
Clear all

Trimble access csv file to auto cad civil 3d

15 Posts
9 Users
0 Reactions
1,810 Views
nomee
(@nomee)
Posts: 54
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

?ÿ
Good morning
I am using trimble access when i exporting data in csv format and after that csv file i try to import in auto cad points the massage is comes no point file format match founditry many time but its not working if any one have soulution i appricate
Thanks


 
Posted : April 10, 2019 6:19 am
stlsurveyor
(@stlsurveyor)
Posts: 2509
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Are you selecting the correct file format from the lower window? This is a must, and sometimes this has to be selected before you path to the csv and then after it loads. You will also get a preview of the file in the lower window.?ÿ


N10,000, E7,000, Z100.00
PLS - IL, MO, AR, KS, MN, KY

 
Posted : April 10, 2019 6:43 am
jeffrey-diamond
(@jeffrey-diamond)
Posts: 26
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

It could be a sharing violation. Make sure the .csv file is closed before you try to import it.


 
Posted : April 10, 2019 6:58 am
david-livingstone
(@david-livingstone)
Posts: 1136
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I convert to a field book file using the survey link.?ÿ If you type in "startsurveylink" at the command line that should pop up with a lot of different ways to convert files.


 
Posted : April 10, 2019 7:04 am
dave-karoly
(@dave-karoly)
Posts: 11990
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

After selecting the file there is a list of choices in the middle window:

Yours doesn't have the list of choices, not sure what is up with that.


 
Posted : April 10, 2019 7:10 am

rover83
(@rover83)
Posts: 2342
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Assuming you are exporting the typical PNEZD format:

Trimble supports alphanumeric point IDs. Civil 3D only supports numbers. If Civil3D cannot find a point file format it usually means you have one or more points coming out of Access that contain a non-numeric character in the Point ID field.

You will need to make sure the Point ID field in your CSV contains only numbers - no letters or special characters.


 
Posted : April 10, 2019 2:40 pm
david-kendall
(@david-kendall)
Posts: 129
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Mine does that sometimes as well.?ÿ Try changing the suffix .csv to .txt and see if that works.

Alternately you may open the csv in a text editor like notepad and save it as a text file

I can't find any difference in the makeup of the files but opening csv in Excel and performing a 'save as' .txt will also fix it

I'm not sure why it does that but my solution to that problem is to simply export as txt by changing the suffix in Access and skip all of the hassle.


 
Posted : April 10, 2019 10:28 pm
murphy
(@murphy)
Posts: 948
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

If you are setup to store vector info, the first line of the exported csv may contain an alphanumeric descriptor for the "point" field.?ÿ C3D will not accept this so you need to edit the csv to remove or rename the line identifying the origin of the vector before importing.

Also, if you don't like exporting a csv, you can just change the extension to ".txt" before exporting.?ÿ You will still have to edit the vector source but the points will be arranged from lowest number to highest instead of the order in which they were shot.?ÿ


 
Posted : April 11, 2019 4:53 am
kevin-w-shannon
(@kevin-w-shannon)
Posts: 22
Member
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Make sure there is no header as the first line of your .csv as well.


 
Posted : April 11, 2019 8:40 am
nomee
(@nomee)
Posts: 54
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

THANKS FOR YOUR REPLY I APPRICATE


 
Posted : April 13, 2019 9:15 am

nomee
(@nomee)
Posts: 54
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

THANKS FOR YOUR REPLY I APPRICATE


 
Posted : April 13, 2019 9:16 am
nomee
(@nomee)
Posts: 54
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

THANKS FOR YOUR REPLY I APPRICATE


 
Posted : April 13, 2019 9:16 am
nomee
(@nomee)
Posts: 54
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

THANKS  I APPRICATE


 
Posted : April 13, 2019 9:17 am
nomee
(@nomee)
Posts: 54
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

THANKS EVERY ONE WHO REPLY?ÿ


 
Posted : April 13, 2019 9:18 am
nomee
(@nomee)
Posts: 54
Member
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

THANKS


 
Posted : April 13, 2019 9:19 am