Tokens & Dependencies - CSV Import

• Date Formatting
  • Table of Tokens
• Connection Formatting (Beta)

Date Formatting

In the event that your .CSV import has a different format for the Start Dates and End Dates than yyyy-MM-dd, Hoylu will flag the field for review so you can use this Table of Tokens to help Hoylu recognize the format. 

In the case of Figure 4, the date format in the .CSV is Sunday, May 26, 2024, and so it must be modified.

Figure 2. Date Format Setup.

1. Click on the triangular warning sign beside the mapped field
   
   
2. Use the Table of Tokens to identify which token(s) you need to use based off the example format (in the case of Figure 4, it is DDDD)
   
   
3. Type in the Token in the open field
   
   
4. Click the Confirm button that now appears since the conflict has been resolved

🚧  Warning: .CSV exports from different software may necessitate other functions like combining tokens or unmerging data from cells, which can grow complex. Please feel free to reach out to Support@Hoylu.com for further assistance.

Table of Tokens

Figure 2. Table of Tokens.

You can find additional tokens here. 

Upstream or Downstream Connection Formatting

Figure 3. Connection Format Setup popup window.

If your Predecessors and Successors are not importing properly or the fields are highlighting in red, you may need to adjust the expression of the connections. 

1. Click on the triangular warning sign beside the mapped field
   
   
2. Edit the Regular Expression so the resulting Task ID format matches the Task ID format in your .CSV file

In Figure 3, the Regular Expression removes the Connection Information FS-10days so only the valid Task ID 1 remains.

Please don't hesitate to reach out to your Customer Success Manager or Support@Hoylu.com for assistance.