Lot Info Export Window

Fusion provides the capability to automatically export information for selected lots and associated information each day. This information can then be imported into other software applications or services. This allows these services to always have an up-to-date and accurate context within which they can work while remaining distinct from Fusion. This window is used to set up the automatic export of this information to one or more services.

Each service you send information to is referred to as a destination in this window. For each destination that you create, you can decide which locations to set up (each location will have its own set of files that are sent) and which lots to include. You will also set up where the information is sent to and what kinds of information is included in the files.

Setting Up a Destination

To add a new destination, click the + button below the Destination list. You will be asked to name the destination. (To remove a destination, select it and click the - button. Fusion will delete the destination and stop sending information to it.) With the destination selected, you need to decide which locations will be included when sending information. Check the Include checkbox next to each location you want to include.

The rest of the settings apply to individual locations, so make sure the correct location is selected in the Location list before making more changes.

Included Lots Tab

When Fusion exports data to send each night for this location, it will only include lots that are in the list in this tab. This gives you control over what information is sent. You can manage this list manually using this tab as explained next. There is also a way to have Fusion automatically manage this list and this is described later in this topic (see the Auto Adding Lots Tab section).

The list shows the name of the lot and its current status (open or closed). To add a lot to the list, click the + button. The Lot field will be revealed so that you can enter the name of the lot to add.

If you want to add several lots at the same time, you may be able to use the Add New Lots… button which will show a menu with two options. The first, Add Open Lots Not Already Added, will simply make sure that all open lots for the location are in the list. The other option, Apply the Rules in the Options Tab, will apply the rules you set up so that Fusion can automatically manage this list. Normally these rules are applied each night, but you can use this option to test that the rules are working right when you first set them up. These rules are described more later in this topic.

To remove a lot, select it in the list and click the - button.

When you select a lot, the Owner list to the right of it will list the lot's current owners. By default, Fusion includes information for each owner in the file. If you would prefer that this information is not sent for certain owners, you can uncheck them in this list. It is also possible that the service that is consuming this information may have an account ID for each owner of a lot. If that is the case, select an owner and enter their ID in the Owner Account for This Destination field. Fusion will remember this ID for that owner so if the same owner has ownership in a different lot at this location, you won't have to enter it in every lot.

Auto Adding Lots

These options can be used to have Fusion automatically manage the list of lots that will be included in the export each night. Fusion will run these rules each night before creating the file, adding and removing lots based on the rules. This frees you from having to manage the included lots list manually. Be aware, though, that if you have to remove certain owners from each lot, you should still do this manually as Fusion will assume all owners should be included when it automatically adds a lot.

If you have a lot that Fusion keeps trying to automatically add that you don't want in the list, go to the Included Lots tab, find the lot in the list, and Right-Click it and choose Don't Auto Add This Lot. Fusion will now ignore this lot when it applies these rules each nigh.

Auto Send Setup Tab

This tab is used to tell Fusion where these files should be sent each night. The files can be sent to an FTP site or (if using the legacy format) sent as an email. You will need to learn from the service you are dealing with which option you should use and what you should enter in each setup field.

If the service wants the file to be uploaded to an FTP site each morning, check the Upload to destination via FTP every morning checkbox and then fill in the associated fields using information the service supplies. Note that is is possible for the Path field to be blank.

If the service wants the file to be emailed instead, check the Send to destination via email attachment every morning checkbox and then fill in the Send To Address with the email address the file should be sent to. (Note that this option is only available if you have chosen the legacy format.) When the email is sent, it will be from Fusion Auto Email <autoemail@ssgfusion.com>

Manually Export Tab

If you need Fusion to generate the files and send them immediately, you can do so in this tab. This can be useful for testing the files or that different delivery methods work. It may also be necessary if errors occurred making it impossible for Fusion to deliver the files during the night. If the errors have been corrected and it is necessary that the files be sent before the next morning, they could be sent manually here.

Options Tab

In this tab you can decide what information is included in the export. The exact options will be different depending on which file format you have chosen. Normally you will need to find out from the service which blocks they require and turn them on.

The Automatic Export and Error Handling

Each morning, shortly after midnight, Fusion cycles through each location you have included in each destination, creating an export based on the information you want included for each and sending it to the destination. If all goes well, the service will see the file and use the information in the file to update their service. If Fusion runs into an error (for example, if the internet is not working), Fusion will send a system message to you explaining the upload couldn't work and include the error message. In most cases this isn't a big deal because Fusion will just try again the next night. However, if timing is sensitive, or if you keep getting the same error several days in a row, you will need to figure out what is causing the error and correct it. You may also need to manually send the information from the Manually Export tab.

The most common causes of errors are:

Known Public Services

We are aware of the following public services that can receive Lot Export Files from Fusion:

Please note that it is possible to use these files for yourself as well. If you have software (or can create software) that will read in the exported files, you can then use it to do further analysis on your own data.

Getting Here

You can open this window by going to Fusion Office → Yard Reports → Lot Info Export.

Third Party Service Developer Information

The following information is for developers who need to consume the files Fusion exports. As mentioned above, two file formats are supported. If your service is using the Legacy format, details on the internal format can be found in the Lot Info Export PDF found on our website here. However, please note that while we continue to support this file format, we will not be enhancing it in the future.

If your service will be using the Second Generation format, please see the details below.

Second Generation Format Developer Information

File Structure

An export is broken into multiple files. This makes it easier to create and parse an export in an environment where resources may be limited and makes it easier to add new types of information to the export in the future. Each file is a JSON file (.json). If the files are being uploaded to an FTP site, each file will be zipped first so the file extension will become ".json.zip" for each file. The meta file (Meta.json)is always created and uploaded last, so if you are sweeping an FTP folder for a new export, you can check for the presence of the meta file to determine if all related files have been uploaded.

The type of most of the keys described below is self explanatory. In the raw JSON, boolean fields will be "true" or "false". Date fields will be in the format "YYYY-MM-DD" and an empty date will be "0000-00-00". Time fields are in the format "HH:MM:SS" and an empty time will be "00:00:00". Timestamps will be in the format "YYYY-MM-DDTHH:MM:SS". All UUIDs are 36 characters in this form: "C33897AD-A5D6-4BF2-BB10-2C3E7F6D2555".

Each type of file that can be exported is described below, including each of the keys in the file.

Meta File

The meta file will be named Meta.json. This file contains general information about the export, lists of all associated files in the export, and additional meta data for objects that are referenced from other files such as contacts and ingredients. It is always created and uploaded last.

Following is a list of keys and subkeys found in the file:

Lot Files

All the information for a lot is contained in one file, so there will be multiple lot files, one for each lot being exported. The name of each file is referred to in the Meta.json file and will be in the form Lot-<uuid>.json (ex. Lot-C33897AD-A5D6-4BF2-BB10-2C3E7F6D2555.json). The lot file can have the following keys in it:

Change History

FileDefinitionVersion=1; CreatorVersion=3.5