OrdaSoft forum
Welcome, Guest
Please Login or Register.    Lost Password?
VehicleManager component support
Go to bottom Favoured: 0
TOPIC: Vehicle Manager Import
#6135
uconcepts (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Vehicle Manager Import 3 Years, 10 Months ago Karma: 0  
Ok, I paid for the the pro package.. and followed some directions to not lose my data when upgrading.. lost all my data...

Now I'm trying to do an import. The directions on this seem pretty thin... I can't seem to find a full list of field names without going into the database to figure it out. I exported a full "sample" inventory... but it doesn't include field names...

I want to do a csv import. What field names are we supposed to use? I found a partial list but I can't find a complete list of field names.
 
Logged Logged  
  The administrator has disabled public write access.
#6136
uconcepts (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Vehicle Manager Import 3 Years, 10 Months ago Karma: 0  
Further issues - I export a full xml, and import it into excell (so I can figure out how to edit or add data), save it and try to export it as xml, and it says the mappings are not exportable... How is some client supposed to add their cars this way, lol.. I got one more try.. exporting the simple xml...
 
Logged Logged  
  The administrator has disabled public write access.
#6137
uconcepts (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Vehicle Manager Import 3 Years, 10 Months ago Karma: 0  
Yeah, that doesn't work either... How do I make this easy for a client who has no clue what an xml file is?
 
Logged Logged  
  The administrator has disabled public write access.
#6138
uconcepts (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Vehicle Manager Import 3 Years, 10 Months ago Karma: 0  
ok, next try was to take the csv export I downloaded.. with no field names.. copy the field names from the xml fle opened in excell... paste them into the csv... they don't match up.. the description field has numbers in it, and the published field has text in it... I can't tell what fields this info goes into, lol...

My goal is to have a file they can keep updated on their computer, and import as needed... I just need to be able to give them step by step directions on how to do it. "open in (name of program), edit, save, then save as (xml spreadsheet, xml data... whichever), and import..."
 
Logged Logged  
  The administrator has disabled public write access.
#6139
uconcepts (User)
Fresh Boarder
Posts: 10
graphgraph
User Offline Click here to see the profile of this user
Re:Vehicle Manager Import 3 Years, 10 Months ago Karma: 0  
Ok, here is a solution I figured out...

1.) Set your computer to save files with a pipe delimiter instead of a comma delimiter for csv or “comma separated value” spreadsheet files.
You may need to only do this one time, if you don’t save files in csv format for other reasons.
• Click "Start," then select "Settings," then "Control Panel." Click on "Regional and Language Options."
• Click on the button labeled "Customize" and highlight the data in the field labeled "List Separator." Type the pipe delimiter "|" in the field replacing the previous list separator. (Shift + key = | … this is a pipe character, not a lower case L or capital i; this key is between the backspace key and the + and = key on the upper right row)
• Click "OK" on the window titled "Customize Regional Options." Click "OK" on the window titled "Regional and Language Options."
(You can change this back to a comma after you’re done if desired)

2.) Edit the spreadsheet.
You’ll want to save two versions of this file.. Edit the inventory and save, then “make it ready” for import by deleting the first row and saving as a separate file.
• Open the .csv in Excell and edit/add cars as needed
• Click on "File" on the Excel menu bar then select the option "Save."
• It will ask if you’re sure you want to save it as this type – choose “Yes”
This will save your inventory so you can edit it at a future date)
• Delete the row of column labels
• Click on "File" on the Excel menu bar then select the option "Save As."
• Input a new name for the file in the text field labeled "File name" and select the value "CSV (Comma delimited)(*.csv). from the “save as Type” box" It’s important you choose a different name for this file with no column labels, you can add the date at the end of the name or simply a number or character to make it different.
• Click on the button labeled "Save" to save the file to your computer as a pipe-delimited format.

3.) Log in to web site to import csv file:
• Mouse over “Components” and click “Vehicle Manager”
• There is a 2nd menu on this page – Click “Import/Export”
• Import Type = “CSV File”
• Select all categories (select the first one, hold the Shift key on your keyboard and click the last one)
• Click “Browse” and find the new csv file you created in the above steps.
• Verify that all items imported correctly
• Check your vehicle list to verify all vehicles
• Check the front end of the web site to verify that all items are correct.
 
Logged Logged  
  The administrator has disabled public write access.
#6152
admin (Admin)
Admin
Posts: 4856
graph
User Offline Click here to see the profile of this user
Re:Vehicle Manager Import 3 Years, 10 Months ago Karma: 61  
Hello,

Sorry may be some correction,

Before any upgrade, please always do full backup !!!!! That save many time in future if some thing go bad.

For check format for data import, please do data export for one Vehicle - with that you will see full data format and what field go to what position.

Thanks,
OrdaSoft team
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
What are you looking for?
Anti-spam question: How many eyes has a typical person?