useImport
useImport hook allows you to import data from a CSV file. For each row in the file, it calls the create or createMany method of your data provider according to your configuration.
Internally, it uses Papa Parse to parse the file contents.
Usageβ
Here is a basic usage example of the useImport hook:
import { useImport } from "@refinedev/core";
interface IPostFile {
title: string;
categoryId: string;
}
export const PostList: React.FC = () => {
const { inputProps } = useImport<IPostFile>();
return <input {...inputProps} />;
};
Propertiesβ
resourceβ
Determines which resource is passed to the create or createMany method of your data provider. By default, it reads the resource name from the current route.
useImport({
resource: "posts",
});
If you have multiple resources with the same name, you can pass the identifier instead of the name of the resource. It will only be used as the main matching key for the resource, data provider methods will still work with the name of the resource defined in the <Refine/> component.
For more information, refer to the
identifierof the<Refine/>component documentation β
mapDataβ
If you want to map the data before sending it to a data provider method, you can use the mapData property.
useImport({
mapData: (data) => ({
...data,
category: {
id: data.categoryId,
},
}),
});
paparseOptionsβ
You can pass any Papa Parse options to the paparseOptions property.
useImport({
paparseOptions: {
header: true,
},
});
batchSizeβ
If you want to send the data in batches, you can use the batchSize property. When the batchSize is 1, it calls the create method of your data provider for each row in the file. When the batchSize is greater than 1, it calls the createMany method of your data provider for each batch. By default, it is set to Number.MAX_SAFE_INTEGER
useImport({
batchSize: 1,
});
onFinishβ
If you want to do something after the import is finished, you can use the onFinish property. It returns an object with two properties: succeeded and errored, which contain the responses of the successful and failed requests.
useImport({
onFinish: (result) => {
// success requests response
result.succeeded.forEach((item) => {
console.log(item);
});
// failed requests response
result.errored.forEach((item) => {
console.log(item);
});
},
});
metaβ
If you want to send additional data to the create or createMany method of your data provider, you can use the meta property.
useImport({
meta: {
foo: "bar",
},
});
onProgressβ
A callback function that is called when the import progress changes. It returns an object with two properties: totalAmount and processedAmount which contain the total amount of rows and the processed amount of rows.
useImport({
onProgress: ({ totalAmount, processedAmount }) => {
// progress percentage
console.log((processedAmount / totalAmount) * 100);
},
});
dataProviderNameβ
If there is more than one dataProvider, you can specify which one to use by passing the dataProviderName prop. It is useful when you have a different data provider for different resources.
useImport({
dataProviderName: "second-data-provider",
});
Return Valuesβ
inputPropsβ
inputProps is an object that contains the props of the input element. You can spread it to the input element.
const { inputProps } = useImport();
return <input {...inputProps} />;
typeβ
It is set to file by default.
acceptβ
It is set to .csv by default.
onChangeβ
It handles the file change event. If the file exists, it will call the handleChange method with the file as an argument.
handleChangeβ
handleChange is a function that handles the file change event. It accepts an object with a file property which is the file that is selected by the user.
const { handleChange } = useImport();
return (
<input
type="file"
onChange={(event) => {
if (event.target.files) {
handleChange({
file: event.target.files[0],
});
}
}}
/>
);
isLoadingβ
isLoading is a boolean that indicates whether the import is in progress or not.
mutationβ
Returns the result of either the useCreate or the useCreateMany hook.
FAQβ
Handling Relational Dataβ
Sometimes you need to process your parsed CSV data for certain cases, such as when your data includes relational data and references to other data or when your backend API requires a specific data format. To handle this, you can use the mapData option in useImport to customize the process.
For example, the CSV file is as follows:
"title","content","status","categoryId","userId"
"dummy title 1","dummy content 1","rejected","3","8"
"dummy title 2","dummy content 2","draft","44","8"
"dummy title 3","cummy content 3","published","41","10"
Since the user and category are relational fields, we store only their id fields in the exported file as userId and categoryId respectively. To create resources from this file, we need to map the data back to the required format of the backend API. To do this, we use the mapData option in useImport. Here's an example:
When creating these resources back, we should map it back to our backend API's required format. mapData option allows us to do this. Here is an example:
useImport<IPostFile>({
mapData: (item) => {
return {
title: item.title,
content: item.content,
status: item.status,
category: {
id: item.categoryId,
},
user: {
id: item.userId,
},
};
},
});
interface IPostFile {
title: string;
status: string;
content: string;
categoryId: string;
userId: string;
}
With this code, the parsed data will be mapped to conform to the API requirements.
API Referenceβ
Propertiesβ
| Property | Type | Description | Default |
|---|---|---|---|
resource | | Resource name for API data interactions. | Resource name that it reads from route |
mapData | | A mapping function that runs for every record. Mapped data will be included in the file contents. | |
paparseOptions | Custom Papa Parse options. | ||
batchSize | | Requests batch size. If it is 1, all records are sent one by one. By default, it is | |
onFinish | | Called with errors and successful responses when all requests are sent. | |
meta | | Metadata query for | |
onProgress | | Metadata query for Ex: | |
dataProviderName | | If there is more than one |
Return Valuesβ
| Property | Description | Type |
|---|---|---|
| inputProps | Props to that you can pass <input /> element props. | UseImportInputPropsType |
| handleChange | Props to handle <input type="file"> element onChange | function |
| isLoading | It can be used to handle the loading status for the Import operation | boolean |
| mutation | Result of the mutation/mutations of creating imported resources | UseMutationResult<{ data: TData }, TError, { resource: string; values: TVariables; }, unknown>) | UseMutationResult<{ data: TData[]},TError, { resource: string; values: TVariables[]; }, unknown>) |
Type Parametersβ
| Property | Description | Default |
|---|---|---|
| TItem | Interface of parsed csv data | any |
| TData | Result type of the data query type that extends BaseRecord | BaseRecord |
| TError | Custom error object that extends HttpError | HttpError |
| TVariables | Values for mutation function | any |
Exampleβ
npm create refine-app@latest -- --example core-use-import