My scenario: We are using Excel spreadsheets to keep track of the 2000+ semi-trailers in our yards. We want to switch to Drupal to track this data. However, updating Drupal Nodes is far more time-consuming for our data entry personnel than editing a spreadsheet.
So here is my thought: Why not have Drupal import the data from a CSV file? This way, the data entry personnel can continue updating a spreadsheet, yet the data will be brought into Drupal on a cron basis using FeedAPI and CSV parser.
Each semi-trailer in our inventory has its own Drupal node, with various CCK fields attached to it. I would like to have this node's CCK values updated with data from the CSV file each time that trailer appears in the file.
How do I accomplish this? What modules should I use? How would I configure them?
ANY ideas or suggestions are welcomed and appreciated. Thanks!