Importing a list from another source?

I'm managing a network of about 1000 Apple Laptops (G4 iBooks). These come and go from the network, and at any given time there's probably only 100-200 on the network.
Previously, to get all computers into an ARD list I've had to add them one by one when I see them online, and keep track of which ones I've added. There's no way to add a computer if you can't see it on the network at that moment.

I was excited when I found out that ARD 3 allowed users to "Import Lists" but now that I've just bought a copy, I'm disappointed to find that it can only import lists from... other lists.

I have a database (Filemaker, but that's irrelevent since it can export to csv easily) with all our laptops, serial numbers, MAC addresses, etc in them. Is there anyway I can generate an ARD list from this information, without the laptop needing to be online at the time?

eMac 1.25 GHz, Mac OS X (10.4.7)

Posted on Jul 19, 2006 10:41 PM

Reply
16 replies

Jul 21, 2006 9:00 AM in response to Joe Boyer

Exported lists are plist files. You could examine an exported plist with a text editor... the format for each computer is not complex:

<dict>
<key>hardwareAddress</key>
<string>AA:BB:CC:DD:EE:FF</string>
<key>hostname</key>
<string>mymac.mydomain.com</string>
<key>name</key>
<string>mymac</string>
<key>networkAddress</key>
<string>192.168.2.2</string>
<key>preferHostname</key>
<false/>
</dict>

I guess if you are doing DHCP you would set preferHostname to True.

Maybe you coud use a calulation field in FMPRo to:

1. construct a plist entry for each record
2. concatenate the results
3. add the plist header and trailer
4. export it as a .plist text file
5. import to ARD

I ahev not tried this but please let me know if it works.

hth,

b.

Jul 23, 2006 4:13 PM in response to buckster

Thanks for your suggestion buckster, that's exactly what I'd tried to do myself (even down to the calculation field from FMpro) but unfortunately it doesn't work.
There's something wrong with the way filemaker formats its export file that makes it invalid XML (which is what a plist is). But once I generate the file, Apple Remote Desktop can't open it. It doesn't come up with an error, just no response. Trying to open the same document in a plist editor tells me that it's not a valid plist file, even though I know it looks right.
So I'm wondering a) What's causing it to be an invalid plist file?
and b) Is there any other way of importing data into ARD?

Jul 24, 2006 4:48 PM in response to Brian Nesse

Nah, that's no help. If it was that simple I wouldn't need to post a question here.
"You can import a list of computers into Apple Remote Desktop by importing a file listing the computers’ IP addresses. The list can be in any file format (text, spreadsheet, word processor) and must contain either IP addresses or fully qualified domain names (such as foo.example.com). "

That's from the ARD manual, and you yourself said copy the IP addresses. Unfortunately, my 1000 computers are all on DHCP. No static IP addresses, no unique IP addresses, and thus no way to import unique computer information into ARD.

Jul 25, 2006 4:03 PM in response to Brian Nesse

That's the thing... all packets travelling the network identify which MAC address they're from as well as IP address, so it IS broadcast over the network. In fact MAC address is how ARD identifies unique computers, not by IP address (which can change).

So it's quite easy to track machines by MAC address, just that ARD's import function is so basic, it won't handle importing by MAC address. In my opinion, it would be a lot more useful than importing by freakin' IP addresses. 😟

Aug 29, 2006 10:11 AM in response to Joe Boyer

I see our school is not alone with regard to trying to ARD to manage machines with IP addresses dished out by DHCP.

The reason we moved to DHCP and purchased ARD was because of the number of machines to manage. But searching all the threads - seems you're S.O.L. with ARD if you're using DHCP. And where in the promo descrtiptions did it mention that you're ability to use ARD is sevely constrained?

As mentioned in this thread - we'd be more than happy to make a once around of current machines and collect their MAC address to populate ARD and make this part of the process for any added machines. But that's a bust also.

I look forward to a way to handle machines under DHCP - and to set the lease time to 6 months is not an option. We made a pitch to the school to spend the money to give us a better tool to allow the two of us to manage all the equipment. But the devel is in the details. No we have to go back and explain why they paid for it and we're not using it.

And why doesn't ARD identify machines by the permenant MAC address instead of a temporary IP address?

Thanks for any ideas out there.
- Tom

Aug 29, 2006 1:19 PM in response to buckster

Hello,

This does not work.

I have essentially created an applescript to parse a database and create the <dict>kkvkjsbndvkjsd</dict> entries so they conform. THe problem is the hash key in the file appears to be somehow tied to the computer which generated the original list (I am assuming that the Plist file has the same reference) Using a database or other tool to create the entries is possible, however, this will have to either be manually inserted into the plist file in preferences or you have to export and reimport a defined list.

Maybe an automator action can export and import for you.
Mike

Aug 29, 2006 2:30 PM in response to buckster

Sure - fair enough.

With minor exception (servers, etc) all the client machines get their IP via DHCP. Lease renew time is set to have them drop off daily so active machines can get an IP address.

When they drop their lease and come back on with another IP address - any information grabbed by ARD on their previous lease is lost as far as being tied back to the same client machine. When Bill Smith's machine with IP .150 drops the lease and now Jane Doe gets that .150 IP assigned when she next gets on her computer - the .150 information for Bill's machine is now inaccurate.

We also looked at using a list of MAC addresses to populate ARD - but appears ARD only makes use of the IP address to identify the clients. So as the DHCP leases are dropped and the same IP number picked up by a different client, all things are up in the air.

So we're trying to find how people are using ARD with DHCP to retain information on the machines with them changing IP addresses regularly. Because we had though of using a list - that brought us to this thread.

Have just been dissapointed that all references to DHCP that we've checked are notes about how those folks are also having problems and no solutions seem to be there.

Since the MAC address would only change if you replaced the ethernet port - not sure why ARD focuses so much on the IP address as a client identifier when the IP can be changed on a regular basis. So we're looking for ideas from others running shops with DHCP.

Thx!
- Tom

Sep 1, 2006 10:29 PM in response to buckster

Yes - have scanned both ways - list appears equal under both methods. Getting 'access denied' hassles - so kind of working our way through this. Kind of one paper wall after another to bust through.

Have several machines in the room that we can use with ARD so as not to walk the entire bldg. Even tho each has ARD checked in Prefs - none list it in the scan.

Will try and keep frustration out of the notes as we go.
thx!

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Importing a list from another source?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.