Importing and Exporting Car Data | New ProTrak User Inquiries | Forum

Welcome to the ProTrak User Community Support Forum . The forum is designed around the chapters in The Manual. Please post your questions in the appropriate subforums. You may "Subscribe" to topics and reply by email.

A A A
Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —






— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_Print sp_TopicIcon
Importing and Exporting Car Data
March 20, 2020
2:29 am
Avatar
Alex Schneider
Member
Members
Forum Posts: 5
Member Since:
March 2, 2020
sp_UserOfflineSmall Offline

The PROTRAK BASICS manual table of contents lists an Appendix N -- Importing Data, evidently a couple of pages with two sections titled Importing Data and Importing Car Data. However I do not find this Appendix, nor for that matter an Appendix M -- Weighing and Filling a Car, which I don't currently need.

Failing that, I turned to the separate table of contents of Appendix L -- Frequently Asked Questions, and was led to Importing car data on page L-75. This is question H.1. -- How do I import car data from another program? The question and the response are specific to importing from Railbase Professional. The steps in this process are (1) exporting your (car) data in "comma-delimited format", (2) cleaning up your data (in for example, Excel), and (3) using ProTrak's "Import car data in Unknown format".

In order to correctly import car data from Excel, the columns must be in the sequence ProTrak is using. Upon exporting the sample car data to a CSV file I obtain the following single record:

x THB,3667 ,XM ,XM ,44,163700,56300,C,2500,23 Jul 49,Joe Brann,

which I interpret as the following fields

Initials,Number,CarKind,Class,Length,LoadLm,Lt_Wt,Plate,Volume,BuiltDate,Owner, ?

If I click "Import car data" I am asked if the file is in ProTrak car format, Unknown format, or Text format (ordered). I don't have any information about the ProTrak car format.

Selecting Text format offers options of 2 data fields (initials and number), 3 data fields (also carkind), or 4 (carkind and length).

The Unknown format offers me a checklist of 32 data fields in the unknown format file; I presume initials and number are pretty essential and carkind and length nearly as essential, and the selected fields must be in the order shown.

Thus to import the file I just exported I would use Unknown file format and check the fields listed.

My questions concerning Export are:

1. What is the significance of the "x" ahead of the reporting mark, THB?

2. Is there an additional field exported after owner which is blank in the example?

3. Why is only one of the nine cars in the example exported?

4. It appears the locomotive data can only be imported or exported in ProTrak format. Is this correct?

5. I would appreciate copies of Appendices M and N if they have ever been written.

Thank you.

Alex Schneider

March 20, 2020
8:24 am
Avatar
Joe-SVL
32826
Member
Members
Forum Posts: 243
Member Since:
April 26, 2015
sp_UserOfflineSmall Offline

Alex,

Welcome, I have never done any importing or exporting in ProTrak; but possibly others in our community have had good experiences with those tasks and can help you. You did the correct thing in looking in the PTBM and then Appendix L for answer to you inquiry.

wrt your question #5- There is no text anywhere for Appendices L or M. The PTBM author Doug Seymour just put those in a "placeholders" with the hope that he could provide applicable text at a later time.  Doug had to terminate his excellent work on the PTBM for personal reasons and we are left with where we are now.

 

Joe Brann, Orlando FL

The following users say thank you to Joe-SVL for this useful post:

Alex Schneider
Forum Timezone: America/Chicago

Most Users Ever Online: 189

Currently Online:
3 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Nashville: 248

Joe-SVL: 243

casowest: 95

Jim Brewer: 92

Mark Stafflrd: 58

Bob: 53

Fred: 43

John V: 43

jjoyce1: 32

Peter Jackson: 27

Member Stats:

Guest Posters: 0

Members: 259

Moderators: 0

Admins: 5

Forum Stats:

Groups: 3

Forums: 13

Topics: 432

Posts: 1815

Newest Members:

Fred52, ferretjack, Frank, bcole_-8@rogers.com, frich1230, waffle2@mac.com, innovativerc@gmail.com, KRFARRINGTON, George Giles, NandWSRY55

Administrators: earlyrail: 71, friscomike: 130, webmaster: 1, hunter48820: 23, Jim Moir: 489